Retrieves line-item information from purchase orders.

View-Specific Information

Select

The add-in uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The add-in processes other filters client-side within the add-in.

• DocumentNumber supports the '=' comparison operator.
• BuyerANID supports the '=' comparison operator.
• OrderStatus supports the '=' comparison operator.
• RoutingStatus supports the '=' comparison operator.
• StartDate and EndDate (when both are specified) support the '=' comparison operator.

For example, the following queries are processed server side:

SELECT * FROM LineItems WHERE DocumentNumber = 'DO240'

SELECT * FROM LineItems WHERE OrderStatus = 'CHANGED'

SELECT * FROM LineItems WHERE RoutingStatus = 'Sent'

SELECT * FROM LineItems WHERE StartDate = '2000-01-01T00:00:00' AND EndDate = '2000-01-15T01:00:00'

Columns

Name	Type	References	Description
LineNumber [KEY]	Int		Position (counting from 1) of this item in an order. Used to maintain a reference between items in create and update OrderRequest documents.
DocumentNumber [KEY]	String	Orders.DocumentNumber	Same as the orderID. The documentNumber is an identifier for a particular order, similar to the purchase order number.
Eanid	String		The European Article Number, EAN, barcode.
Unspsc	String		The United Nations Standard Products and Services Code, UNSPSC, classification.
Priority	Int		Priority indicator, used to drive the priority of the orders for the suppliers.
ProductIdentifier	String		Reference product number.
LineOfBusiness	String		Line of business.
ProductFamily	String		Product family.
ProductSubFamily	String		Product sub family.
ProductCode	String		Product code.
PartCategory	String		Part category.
PartType	String		Part type.
Category	String		Category.
SupplierPart	String		SupplierPartID is how the supplier identifies an item.
SupplierBatchId	String		An identifier from supplier to identify the material/goods produced in a single manufacturing run.
BuyerPartId	String		It represents a product in buyer system. This identifier is specified by the buyer.
BuyerBatchId	String		An identifier from buyer to identify the material/goods produced in a single manufacturing run.
ManufacturerName	String		The manufacturer's name.
ManufacturerPartId	String		The manufacturer's part number.
PlannerCode	String		Planner code.
PlannerDescription	String		Planner description.
Description	String		Description of the items.
MaterialGoAheadEndDate	Datetime		Date denoting the end of the material go-ahead period (go-ahead for purchase of input materials).
ProductionGoAheadEndDate	Datetime		Date denoting the end of the production go-ahead period.
AgreementId	String		The procurement system agreement ID for this request.
AgreementDate	Datetime		The date and time the agreement request was created. This is different from the effective and expiry date of the agreement.
NeedBy	Datetime		The date this item was requested for delivery.
RequestedDeliveryDate	Datetime		The date this item was requested for delivery.
RequestedShipmentDate	Datetime		The ship date requested by the buyer for the item.
PreviousAsnId	String		Previous ship notice ID.
PreviousAsnDate	Datetime		Previous ship notice date.
IsoCountryCode	String		The International Organization for Standardization (ISO) country code for the country in the shipping address.
ItemShipToStreet	String		The Street element is the street address of the ShipTo location where ordered products are to be delivered.
ItemShipToCity	String		The City element is the city where ordered products are to be shipped.
ItemShipToState	String		The State element is a two-letter state, province, or territory code for the location where the goods are to be shipped.
ItemShipToCountry	String		The Country element is the country where goods are to be shipped.
ItemShipToCode	String		Item ship to code.
ItemShipToPostalCode	String		The PostalCode element is the postal or zip code where goods are to be shipped.
ItemShipToName	String		For ship to, the Name element value should be the company or organization of the employee receiving ordered products.
ItemReturnAuthorizationNumber	String		Return Authorization Number information for a line item.
ReleaseType	String		A string value to identify the type of release. The value will be either jit or forecast.
ItemLocation	String		Item location.
StorageLocation	String		Storage location.
Quantity	Double		How many items are desired. Supplier and Commodity level items in an order of type 'blanket' will use a default value of '1'. The quantity in this case will not be used to compute the sub total. The MaxAmount in the BlanketItemDetail will be used to indicate any line level amounts.
UnitOfMeasure	String		The UnitOfMeasure element contains the item Unit of Measure code as defined by the United Nations UOM standard.
PbqQuantity	Double		The PriceBasisQuantity element contains the quantity-based pricing for a line item. Quantity-based Pricing is commonly also referred to as Price-Based Quantity or PBQ. Quantity-based pricing allows the unit price of an item to be based on a different price unit quantity than 1.
PbqUOM	String		Unit of measure for the PriceBasisQuantity.
PbqConversionFactor	Double		Conversion factor for the PriceBasisQuantity.
ConfirmedQuantity	Double		Confirmed quantity.
PreviousReceivedQuantity	Double		Previous received quantity.
PreviousReceivedQuantityUom	String		Unit of measure for the previous received quantity.
CumulativeShipQuantity	Double		A number value to identify the cumulative quantity of all goods shipped against the scheduling agreement release over a period up to a certain date.
CumulativeReceivedQuantity	Double		A number value to identify the cumulative quantity of all goods received against the scheduling agreement released over a period up to a certain date.
CumulativeReceivedUom	String		Unit of measure for the cumulative received quantity.
UnitPriceConversionDate	Datetime		Price per unit of item conversion date.
UnitPriceAmount	Decimal		Price per unit of item amount.
UnitPriceApprox	Decimal		Price per unit of item approx.
UnitPriceCurrencyCode	String		Price per unit of item currency code.
AccountingDistributionAccountingName	String		The accounting distribution identifier. An accounting distribution divides the cost of an item among multiple parties. Suppliers return this identifier on invoices to facilitate the buyer's reconciliation process. Name.
AccountingDistributionAccountingSegments	String		The accounting distribution identifier. An accounting distribution divides the cost of an item among multiple parties. Suppliers return this identifier on invoices to facilitate the buyer's reconciliation process. Segments.
AccountingDistributionChargeConversionDate	Datetime		The accounting distribution identifier. An accounting distribution divides the cost of an item among multiple parties. Suppliers return this identifier on invoices to facilitate the buyer's reconciliation process. Charge conversion date.
AccountingDistributionChargeAmount	Decimal		The accounting distribution identifier. An accounting distribution divides the cost of an item among multiple parties. Suppliers return this identifier on invoices to facilitate the buyer's reconciliation process. Charge amount.
AccountingDistributionChargeApprox	Decimal		The accounting distribution identifier. An accounting distribution divides the cost of an item among multiple parties. Suppliers return this identifier on invoices to facilitate the buyer's reconciliation process. Charge approx.
AccountingDistributionChargeCurrencyCode	String		The accounting distribution identifier. An accounting distribution divides the cost of an item among multiple parties. Suppliers return this identifier on invoices to facilitate the buyer's reconciliation process. Charge currency code.
SerialNumberInfoMaximum	Double		The buyer's instructions on acceptable serial number values to be sent in an Advance Ship Notice (ASN). Maximum.
SerialNumberInfoMinimum	Double		The buyer's instructions on acceptable serial number values to be sent in an Advance Ship Notice (ASN). Minimum.
SerialNumberInfoProfile	String		The buyer's instructions on acceptable serial number values to be sent in an Advance Ship Notice (ASN). Profile. Can be profile, range, or list.
SerialNumberInfoValues	String		The buyer's instructions on acceptable serial number values to be sent in an Advance Ship Notice (ASN). Values.
SerialNumberInfoProfileType	String		The buyer's instructions on acceptable serial number values to be sent in an Advance Ship Notice (ASN). Profile type. Can be numeric or null.
BuyerANID	String		The buyer's ANID.
OrderStatus	String		Indicates what state of processing the order has reached.
RoutingStatus	String		Routing Status indicates whether a purchase order or service order is queued, sent, acknowledged, or if routing failed.
StartDate	Datetime		Searches by the date on which SAP Business Network receives the purchase order. The maximum date range is 31 days. These two parameters startDate and endDate must exist together or neither.
EndDate	Datetime		Searches by the date on which SAP Business Network receives the purchase order. The maximum date range is 31 days. These two parameters startDate and endDate must exist together or neither.