Purchase Contract 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.
This table shows the table from which fields are retrieved for the dimension:
| Table | Description |
|---|---|
| tcmcs013 | Payment Terms |
| tcmcs024 | Price Groups |
| tcmcs041 | Terms of Delivery |
| tcmcs065 | Departments |
| tdpur094 | Purchase Order Types |
| tdpur300 | Purchase Contracts |
| tdpur301 | Purchase Contract Lines |
This table shows the attribute mapping for the dimension:
| Attribute | Mapping |
|---|---|
| BP Order Reference | tdpur301.owno |
| Company | tdpur301.compnr |
| Consigned | tdpur301.cons |
| Consigned Filter | tdpur301.cons |
| Consigned Sort | tdpur301.cons |
| Contract | tdpur301.cono |
| Contract Desc | tdpur300.cdes |
| Contract ID Desc | tdpur301.cono + tdpur300.cdes |
| Contract Line Date | tdpur301.cdat |
| Contract Line Status | tdpur301.icap |
| Contract Line Status Filter | tdpur301.icap |
| Contract Line Status Sort | tdpur301.icap |
| Contract Line Type | tdpur301.cltp |
| Contract Line Type Filter | tdpur301.cltp |
| Contract Line Type Sort | tdpur301.cltp |
| Contract Status | tdpur300.icap |
| Contract Status Filter | tdpur300.icap |
| Contract Status Sort | tdpur300.icap |
| Contract Type | tdpur301.icyp |
| Contract Type Filter | tdpur301.icyp |
| Contract Type Sort | tdpur301.icyp |
| Corporate Purchase Contract | tdpur300.copc |
| Corporate Purchase Contract Filter | tdpur300.copc |
| Corporate Purchase Contract Sort | tdpur300.copc |
| Delivery Terms | tdpur301.cdec |
| Delivery Terms Desc | tcmcs041.dsca |
| Effective Date | tdpur301.sdat |
| Effectivity Unit | tdpur301.effn |
| Expiry Date | tdpur301.edat |
| Extended | Indicates if the expiry date was changed to a later date.
|
| Line | tdpur301.pono |
| New Item | 1, if no purchase contract lines exist for the Item in the quarter before the Effective Date. Else, 0. |
| New Supplier | 1, if no purchase contract lines exist for the Buy-from BP in the quarter before the Effective Date. Else, 0. |
| Original Contract | tdpur300.ocon |
| Original Contract Desc | tdpur300.cdes (for tdpur300.ocon) |
| Payment Terms | tdpur300.cpay |
| Payment Terms Desc | tcmcs013.dsca |
| Purchase Office | tdpur301.cofc |
| Purchase Office Desc | tcmcs065.dsca |
| Purchase Order Type | tdpur300.cotp |
| Purchase Order Type Desc | tdpur094.dsca |
| Purchase Price Group | tdpur301.cpgp |
| Purchase Price Group Desc | tcmcs024.dsca |
| Reference A | tdpur300.refe |
| Reference B | tdpur300.refb |
| Renewed | Indicates if another contract exists with the same supplier-item combination and
with a later effective date.
|
| Responsible Office | tdpur300.rofc |
| Responsible Office Desc | tcmcs065.dsca |
| Sequence | tdpur301.csqn |
| Unknown | 1 for null records, else 0 |
| deleted | 1 if tdpur301 is deleted in LN, else 0 |
| Customer Defined Fields | Standard list of fields |