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