Customer Item
This table shows the table from which fields are retrieved for the dimension:
Table | Description |
---|---|
tcibd004 | Item Codes by Item Code System |
tcibd006 | Item Code Systems |
This table shows the attribute mapping for the dimension:
Attribute | Mapping |
---|---|
Business Partner | tcibd004.bpid |
Company | tcibd004_compnr |
Customer Item | tcibd004.aitc |
Customer Item Desc | tcibd004.aitd |
Customer Item ID Desc | tcibd004.aitc + tcibd004.aitd |
Item | tcibd004.item |
Item Code System | tcibd004.citt |
Item Code System Desc | tcibd006.dsca |
Unknown | 1 for null records, else 0 |
deleted | 1 if deleted in LN, else 0 |
Customer Defined Fields | Standard list of fields |