Sales Order Line Detail
This table shows the tables from which fields are retrieved for the dimension:
| Table | Description |
|---|---|
| tcmcs005 | Reasons |
| tcmcs013 | Payment Terms |
| tcmcs031 | Lines of Business |
| tcmcs041 | Terms of Delivery |
| tcmcs045 | Areas |
| tcmcs066 | Channels |
| tdsls094 | Sales Order Types |
| tdsls400 | Sales Orders |
| tdsls401 | Sales Order Lines |
This table shows the attribute mapping for the dimension:
| Attribute | Mapping |
|---|---|
| Additional Cost Line | tdsls401.acsl |
| Additional Cost Line Filter | tdsls401.acsl |
| Additional Cost Line Sort | tdsls401.acsl |
| Area | tdsls400.creg |
| Area Desc | tcmcs045.dsca |
| Back Order Quantity Confirmed | tdsls401.bqco |
| Back Order Quantity Confirmed Filter | tdsls401.bqco |
| Back Order Quantity Confirmed Sort | tdsls401.bqco |
| Channel | tdsls401.chan |
| Channel Desc | tcmcs066.dsca |
| Contract Ignored | tdsls401.cnig |
| Contract Ignored Filter | tdsls401.cnig |
| Contract Ignored Sort | tdsls401.cnig |
| Contract Linked | 1 if tdsls401.cono <> '' else 0 |
| Delivery Terms | tdsls401.cdec |
| Delivery Terms Desc | tcmcs041.dsca |
| Delivery Type | tdsls401.dltp |
| Delivery Type Filter | tdsls401.dltp |
| Delivery Type Sort | tdsls401.dltp |
| Effectivity Unit | tdsls401.effn |
| Engineering Item Revision | tdsls401.revi |
| Invoiced | 1 if Invoice Date exists (tdsls401.invd <> 0), else 0 |
| Line of Business | tdsls400.cbrn |
| Line of Business Desc | tcmcs031.dsca |
| Lot | tdsls401.clot |
| New Customer Sales | 1, if no sales order lines exist for the Sold-to BP
(tdsls400.ofbp) in the quarter before the Invoice Date (tdsls401.invd) or if not
invoiced, the Planned Delivery Date (tdsls401.ddta). Else, 0. |
| New Item Sales | 1, if no sales order lines exist for the Item (tdsls401.item) in
the quarter before the Invoice Date (tdsls401.invd) or if not invoiced, the Planned
Delivery Date (tdsls401.ddta). Else, 0. |
| Order Line Type | tdsls401.oltp |
| Order Line Type Filter | tdsls401.oltp |
| Order Line Type Sort | tdsls401.oltp |
| Origin | tdsls400.corg |
| Origin Filter | tdsls400.corg |
| Origin Sort | tdsls400.corg |
| Original Document Type | tdsls400.odty |
| Original Document Type Filter | tdsls400.odty |
| Original Document Type Sort | tdsls400.odty |
| Payment Terms | tdsls401.cpay |
| Payment Terms Desc | tcmcs013.dsca |
| Price Origin | tdsls401.porg |
| Price Origin Filter | tdsls401.porg |
| Price Origin Sort | tdsls401.porg |
| Return | 1 if Sales Order Line Status = Return. Else, 0. |
| Return Reason | tdsls400.retr |
| Return Reason Desc | tcmcs005.dsca |
| Rush Order Line | tdsls401.ruso |
| Rush Order Line Filter | tdsls401.ruso |
| Rush Order Line Sort | tdsls401.ruso |
| Sales Order Line Status | Return, if Ordered Quantity < 0 Invoice Only, if Ordered Quantity = 0 If Ordered Quantity > 0:
Note: Ordered Quantity = tdsls401.qoor but if Back Order Confirmed
(tdsls401.bqco) = yes then Ordered Quantity = tdsls401.qoor –
tdsls401.qbbo
|
| Sales Order Status | tdsls400.hdst |
| Sales Order Status Filter | tdsls400.hdst |
| Sales Order Status Sort | tdsls400.hdst |
| Sales Order Type | tdsls400.sotp |
| Sales Order Type Desc | tdsls094.dsca |