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 |