Production Order
When a record is deleted in LN, a record with deleted = 1 is stored in the dimension. Records are not removed from the dimension. A production order that has status Created, Modify, Scheduled, or Printed and is deleted in LN, is hidden in the degenerate dimension in Birst. Production orders with status Closed or Archived that are deleted when archiving orders, are not hidden and remain available for analysis.
This table shows the table from which fields are retrieved for the dimension:
| Table | Description |
|---|---|
| tisfc001 | Production Orders |
This table shows the attribute mapping for the dimension:
| Attribute | Mapping |
|---|---|
| Actual Closing date | tisfc001.cldt |
| Actual Delivery Date | tisfc001.adld |
| Actual Production Start Date | tisfc001.apdt |
| Calculation Date | tisfc001.cada |
| Company | tisfc001_compnr |
| Completion Date | tisfc001.cmdt |
| Confirmed Delivery Date | tisfc001.cdld |
| Planned Delivery Date | tisfc001.pldt |
| Planned Production Start Date | tisfc001.prdt |
| Production Order | tisfc001.pdno |
| Reference Date | tisfc001.efdt |
| Requested Delivery Date | tisfc001.rdld |
| Unknown | 1 for null records, else 0 |
| deleted | 1 if deleted in LN, else 0 |
| Customer Defined Fields | Standard list of fields |