Sales 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 |
| tdsls094 | Sales Order Types |
| tdsls300 | Sales Contracts |
| tdsls301 | Sales Contract Lines |
This table shows the attribute mapping for the dimension:
| Attribute | Mapping |
|---|---|
| Company | tdsls301.compnr |
| Contract | tdsls301.cono |
| Contract Desc | tdsls300.cdes |
| Contract ID Desc | tdsls301.cono + tdsls300.cdes |
| Contract Line Date | tdsls301.cdat |
| Contract Line Status | tdsls301.icap |
| Contract Line Status Filter | tdsls301.icap |
| Contract Line Status Sort | tdsls301.icap |
| Contract Line Type | tdsls301.icyp |
| Contract Line Type Filter | tdsls301.icyp |
| Contract Line Type Sort | tdsls301.icyp |
| Contract Status | tdsls300.icap |
| Contract Status Filter | tdsls300.icap |
| Contract Status Sort | tdsls300.icap |
| Customer Contract Reference | tdsls301.ccrf |
| Customer Item | tdsls301.citm |
| Customer Order | tdsls301.corn |
| Delivery Terms | tdsls301.cdec |
| Delivery Terms Desc | tcmcs041.dsca |
| Effective Date | tdsls301.sdat |
| Effectivity Unit | tdsls301.effn |
| Expiry Date | tdsls301.edat |
| Extended | Indicates if the expiry date was changed to a later date.
|
| Goods Flow | tdsls301.dest |
| Goods Flow Filter | tdsls301.dest |
| Goods Flow Sort | tdsls301.dest |
| Line | tdsls301.pono |
| New Customer | 1 if no sales contract lines exist for the Sold-to BP in the quarter before the
Effective Date. Else, 0. |
| New Item | 1 if no sales contract lines exist for the Item in the quarter before the
Effective Date. Else, 0. |
| Original Contract | tdsls300.ocon |
| Original Contract Desc | tdsls300.cdes (for tdsls300.ocon) |
| Payment Terms | tdsls300.cpay |
| Payment Terms Desc | tcmcs013.dsca |
| Reference A | tdsls300.refe |
| Reference B | tdsls300.refb |
| Renewed | Indicates if another contract exists with the same customer-item combination and
with a later effective date.
|
| Responsible Office | tdsls300.rofc |
| Responsible Office Desc | tcmcs065.dsca |
| Sales Office | tdsls301.cofc |
| Sales Office Desc | tcmcs065.dsca |
| Sales Order Type | tdsls300.sotp |
| Sales Order Type Desc | tdsls094.dsca |
| Sales Price Group | tdsls301.cpgs |
| Sales Price Group Desc | tcmcs024.dsca |
| Unknown | 1 for null records, else 0 |
| deleted | 1 if tdsls301 is deleted in LN, else 0 |
| Customer Defined Fields | Standard list of fields |