Sales Order Line
When a record is deleted in LN, a record with deleted = 1 is stored in the dimension. Records are not removed from the dimension. Sales order lines for a sales order that does not have status Closed and are deleted in LN, are hidden in the degenerate dimension in Birst. Sales order lines of a sales order with status Closed that are deleted when archiving orders, are not hidden and remain available for analysis.
Canceled sales order lines are always hidden.
This table shows the table from which fields are retrieved for the dimension:
Table | Description |
---|---|
tdsls401 | Sales Order Lines |
This table shows the attribute mapping for the dimension:
Attribute | Mapping |
---|---|
Company | tdsls401_compnr |
Customer Requested Delivery Date | tdsls401.ddtc |
Delivery Date | tdsls401.dldt |
Initial Requested Delivery Date | tdsls401.ddtb |
Invoice Date | tdsls401.invd |
Order Date | tdsls401.odat |
Original Promised Delivery Date | tdsls401.ddtd |
Planned Delivery Date | tdsls401.ddta |
Planned Receipt Date | tdsls401.prdt |
Release Date | tdsls401.rdta |
Sales Order | tdsls401.orno |
Sales Order Line | tdsls401.pono |
Sequence Number | tdsls401.sqnb |
deleted | 1 if deleted in LN, else 0 |
Customer Defined Fields | Standard list of fields |