Purchase Schedule 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. Purchase schedule lines with the status Canceled are stored in the fact table but are always hidden and not available for analysis.
This table shows the table from which fields are retrieved for the dimension:
| Table | Description |
|---|---|
| tcmcs013 | Payment Terms |
| tcmcs041 | Terms of Delivery |
| tcmcs045 | Areas |
| tcmcs201 | Purchase Types |
| tdpur094 | Purchase Order Types |
| tdpur310 | Purchase Schedules |
| tdpur311 | Purchase Schedule Lines |
This table shows the attribute mapping for the dimension:
| Attribute | Mapping |
|---|---|
| Actual Receipt Date | tdpur311.ddte |
| Area | tdpur310.creg |
| Area Desc | tcmcs045.dsca |
| Company | tdpur311.compnr |
| Confirmation Date | tdpur311.cfdt |
| Consigned | tdpur310.cons |
| Consigned Filter | tdpur310.cons |
| Consigned Sort | tdpur310.cons |
| Delivery Terms | tdpur310.cdec |
| Delivery Terms Desc | tcmcs041.dsca |
| Direct Delivery | tdpur310.drct |
| Direct Delivery Filter | tdpur310.drct |
| Direct Delivery Sort | tdpur310.drct |
| Effectivity Unit | tdpur311.effn |
| Engineering Item Revision | tdpur311.revi |
| Invoice Date | tdpur311.invd |
| New Item | 1, if no purchase schedule lines exist for the Item in the quarter before the Receipt Date. Else, 0. |
| New Supplier | 1, if no purchase schedule lines exist for the Buy-from BP in the quarter before the Receipt Date. Else, 0. |
| Order Discount | tdpur310.odis |
| Origin | tdpur311.corg |
| Origin Filter | tdpur311.corg |
| Origin Sort | tdpur311.corg |
| Payment Terms | tdpur310.cpay |
| Payment Terms Desc | tcmcs013.dsca |
| Planned Receipt Date | tdpur311.ddta |
| Planned Shipment Date | tdpur311.shdt |
| Purchase Order Type | tdpur310.cotp |
| Purchase Order Type Desc | tdpur094.dsca |
| Purchase Schedule Line Status | tdpur311.stat |
| Purchase Schedule Line Status Filter | tdpur311.stat |
| Purchase Schedule Line Status Sort | tdpur311.stat |
| Purchase Schedule Status | tdpur310.stat |
| Purchase Schedule Status Filter | tdpur310.stat |
| Purchase Schedule Status Sort | tdpur310.stat |
| Purchase Schedule Type | tdpur311.styp |
| Purchase Schedule Type Filter | tdpur311.styp |
| Purchase Schedule Type Sort | tdpur311.styp |
| Purchase Type | tdpur311.ptpe |
| Purchase Type Desc | tcmcs201.desc |
| Receipt Date | Actual Receipt Date. When empty, Planned Receipt Date. |
| Receipt Date Variance in Hours | Actual Receipt Date - Planned Receipt Date (tdpur311.ddte - tdpur311.ddta ) |
| Requirement Type | tdpur311.rqtp |
| Requirement Type Filter | tdpur311.rqtp |
| Requirement Type Sort | tdpur311.rqtp |
| Schedule | tdpur311.schn |
| Schedule Position | tdpur311.spon |
| Shipment / Receipt Based Filter | tdpur310.tqal |
| Shipment / Receipt Based Sort | tdpur310.tqal |
| Shipment Receipt Based | tdpur310.tqal |
| Terminated | tdpur310.term |
| Terminated Filter | tdpur310.term |
| Terminated Sort | tdpur310.term |
| deleted | 1 if tdpur311 is deleted in LN, else 0 |
| Customer Defined Fields | Standard list of fields |