| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | T7CNTPM_ITM | TPM: Item | 12 | ITMNO | Item Number | nvarchar | 4 | 0 | | |
| 2 | T7CNTPM_USAGE | TPM: Usage Data | 4 | ITMNO | Item Number | nvarchar | 4 | 0 | | |
| TOPCross-Application Components |
| 3 | FRE_BIF_OPI_IN | Inbound Interface Table Order Proposal Item | 3 | ITMNO | Order Proposal Item Number | nvarchar | 10 | 0 | | |
| 4 | FRE_IF_ITEM | F&R Order Outbound IF: internal Item Table | 7 | ITMNO | Order Proposal Item Number | nvarchar | 10 | 0 | | |
| 5 | FRE_OP_PO_KEY | Key-Completion F&R Order Proposal <-> R/3 Purchase Order | 8 | ITMNO | Order Proposal Item Number | nvarchar | 10 | 0 | | |
| TOPEnvironment, Health and Safety |
| 6 | /TDAG/CPT_TASKD | CP: Dokumente zu Aufgabenpositionen | 3 | ITMNO | Item Number | nvarchar | 10 | 0 | | |
| 7 | /TDAG/CPT_TASKDA | CP: Dokumente zu Aufgabenpositionen / Archiv | 3 | ITMNO | Item Number | nvarchar | 10 | 0 | | |
| 8 | /TDAG/CPT_TASKI | CP: Positionsdaten für Aufgaben | 3 | ITMNO | Item Number | nvarchar | 10 | 0 | | |
| 9 | /TDAG/CPT_TASKIA | CP: Positionsdaten für Aufgaben / Archiv | 3 | ITMNO | Item Number | nvarchar | 10 | 0 | | |
| 10 | /TDAG/CPT_TRCKI | Obsolete - CP: Tracker - Positionsdaten | 3 | ITMNO | Item Number | nvarchar | 10 | 0 | | |
| 11 | /TDAG/CPT_TRCKIA | Obsolete - CP: Tracker - Positionsdaten / Archiv | 3 | ITMNO | Item Number | nvarchar | 10 | 0 | | |
| TOPExchanges |
| 12 | OIA12I | Movement Based Netting document item | 4 | ITMNO | Exchange - netting document item number | nvarchar | 5 | 0 | | |
| 13 | OIA12ICOND | Conditions of OIA12I items | 4 | ITMNO | Exchange - netting document item number | nvarchar | 5 | 0 | | |
| TOPFinancial Supply Chain Management |
| 14 | BNK_XSTAT_RSN | Status Reason Information | 3 | ITMNO | Item Number | nvarchar | 5 | 0 | | |
| 15 | BNK_XSTAT_TX | Status: Transaction Information | 3 | ITMNO | Item Number | nvarchar | 5 | 0 | | |
| TOPGlobal Trade Services |
| 16 | /SAPSLL/BOPIT | GTS: General Bill of Product - Item Data | 4 | ITMNO | Sequence Number | nvarchar | 5 | 0 | | |
| 17 | /SAPSLL/CUPEDRI | GTS: Period Entry Reference to Customs Document Item | 29 | ITMNO | Sequence Item Number (Supplementary Customs Declaration) | nvarchar | 10 | 0 | | |
| TOPShipping |
| 18 | LIPSPO | LIPS Reference Data Purchase Order | 5 | ITMNO | Item Number of Purchasing Document | nvarchar | 5 | 0 | | |
| TOPWarranty Claim Processing |
| 19 | PVWTY | Warranty Claim Item (PPE Variant) | 7 | ITMNO | Key for Detailed Item Data | nvarchar | 40 | 0 | | |
