RequisitionLineItemSplitAccountings
Split accounting details of the requisition line items.
View-Specific Information
Select
The driver 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 [RequisitionLineItemSplitAccountings]
SELECT * FROM [RequisitionLineItemSplitAccountings] WHERE [ApprovableId] = 'Val1'
The driver processes other filters client-side within the driver.
Columns
| Name | Type | References | Description |
| ApprovableId [KEY] | String |
Requisitions.ApprovableId | The unique identifier of the approvable requisition. |
| LineItemNumberInCollection [KEY] | Int | The position index of the parent line item. | |
| NumberInCollection [KEY] | Int | The position index of this accounting entry. | |
| RequisitionId | String | The identifier of the parent requisition. | |
| ErpSplitValue | String | The value representing the ERP split. | |
| Quantity | Decimal | The split quantity. | |
| Percentage | Decimal | The percentage split applied to this accounting entry. | |
| Amount | Decimal | The monetary amount allocated to this split. | |
| AmountCurrency | String | The currency of the allocated amount. | |
| Account | String | The raw string identifier for the account. | |
| AssetUniqueName | String | The unique system identifier for the asset. | |
| AssetDescription | String | The human-readable description for the asset. | |
| BusinessUnit | String | The raw string identifier for the business unit. | |
| CostCenterDescription | String | The human-readable description for the cost center. | |
| CostCenterUniqueName | String | The unique system identifier for the cost center. | |
| DepartmentUniqueName | String | The unique system identifier for the department. | |
| DepartmentCostCenterDescription | String | The human-readable cost center description for the department. | |
| GLBusinessUnit | String | The raw string identifier for the general ledger business unit. | |
| GeneralLedgerUniqueName | String | The unique system identifier for the general ledger. | |
| GeneralLedgerDescription | String | The human-readable description for the general ledger. | |
| InternalOrderUniqueName | String | The unique system identifier for the internal order. | |
| InternalOrderDescription | String | The human-readable description for the internal order. | |
| LineItem | String | The raw string identifier for the line item accounting rule. | |
| Location | String | The raw string identifier for the location. | |
| Product | String | The raw string identifier for the product. | |
| Project | String | The raw string identifier for the project. | |
| StatisticsCode | String | The raw string identifier for the statistics code. | |
| WBSElementUniqueName | String | The unique system identifier for the WBS element. | |
| WBSElementDescription | String | The human-readable description for the WBS element. | |
| CustomFields | String | Custom split-accounting details. |