LineItems
Retrieves line-item information from purchase orders.
View-Specific Information
Select
The cmdlet uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The cmdlet processes other filters client-side within the cmdlet.
- DocumentNumber supports the '=' comparison operator.
- SupplierANID 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.
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. | |
SupplierANID | String | The supplier'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. |