RequisitionLineItems
Line item details of the requisition.
View-Specific Information
Select
The connector uses the SAP Ariba API to process WHERE clause conditions that are built with the following column and operators:
- ApprovableId supports the '=,IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [RequisitionLineItems]
SELECT * FROM [RequisitionLineItems] WHERE [ApprovableId] = 'Val1'
The connector processes other filters client-side within the connector.
Columns
| Name | Type | References | Description |
| ApprovableId [KEY] | String |
Requisitions.ApprovableId | The unique identifier of the approvable requisition. |
| NumberInCollection [KEY] | Int | The position index of the line item in the collection. | |
| RequisitionId | String | The identifier of the parent requisition. | |
| Description | String | The description of the line item. | |
| DescriptionShortName | String | The short name of the line item. | |
| ItemCategory | String | The category of the item. | |
| DescriptionSupplierPartNumber | String | The supplier's part number for the item. | |
| DescriptionSupplierPartAuxiliaryId | String | The auxiliary identifier for the supplier's part. | |
| CommonCommodityCode | String | The common commodity code of the item. | |
| Outline | String | The outline string representation. | |
| Quantity | Decimal | The numerical quantity requested. | |
| Amount | Decimal | The total monetary amount for the line item. | |
| AmountCurrency | String | The currency of the line item amount. | |
| DescriptionUnitOfMeasure | String | The unit of measurement. | |
| DescriptionPriceAmount | Decimal | The unit price monetary amount. | |
| DescriptionPriceCurrency | String | The currency for the unit price. | |
| DescriptionPriceBasisQuantity | Int | The quantity used as the basis for the price. | |
| DescriptionPriceBasisQuantityUOM | String | The unit of measure for the price basis quantity. | |
| DescriptionPriceBasisQuantityDesc | String | The description of the price basis quantity. | |
| NeedBy | Datetime | The date by which the requisition items are needed. | |
| AccountCategoryUniqueName | String | The unique system identifier for the account category. | |
| AccountCategoryDescription | String | The human-readable description for the account category. | |
| CommodityExportMapEntryAccountTypeUniqueName | String | The unique system identifier for the commodity export account type. | |
| PurchaseOrgUniqueName | String | The unique system identifier for the purchasing organization. | |
| PurchaseOrgName | String | The human-readable name of the purchasing organization. | |
| PurchaseGroupUniqueName | String | The unique system identifier for the purchasing group. | |
| PurchaseGroupName | String | The human-readable name of the purchasing group. | |
| SplitAccountingType | String | The type of split accounting applied. | |
| SupplierName | String | The human-readable name of the supplier. | |
| SupplierUniqueName | String | The unique system identifier for the supplier. | |
| SupplierCommonSupplierName | String | The common name of the supplier. | |
| SupplierLocationName | String | The human-readable name of the supplier's location. | |
| SupplierLocationUniqueName | String | The unique system identifier for the supplier's location. | |
| ShipToName | String | The human-readable name of the shipping destination. | |
| ShipToUniqueName | String | The unique system identifier for the shipping destination. | |
| BillingAddressName | String | The human-readable name of the billing address. | |
| BillingAddressUniqueName | String | The unique system identifier for the billing address. | |
| DeliverTo | String | The recipient to whom the items should be delivered. | |
| SplitAccountings | String | Split accountings for this line item. |