| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | ZZZ_IF_KRANK | Interface Meldesatz Krankenstände | 6 | PNR | Character Feld der Länge 8 | nvarchar | 8 | 0 | | |
| TOPAerospace Defence Industry Solution |
| 2 | ORFCALC | Data Record ORF Calculation, ATTENTION: MOVE-CORR! | 3 | PNR | Part Number | nvarchar | 15 | 0 | | |
| TOPNon-Ferrous Metal enhancements |
| 3 | /NFM/TCOVHIS | Coverage History | 9 | PNR | Document Item Number | nvarchar | 6 | 0 | | |
| TOPProvisioning |
| 4 | ADS2KIPBRO_CMD | SPEC 2000 IP: Key fields for master data creation | 4 | PNR | Part Number | nvarchar | 15 | 0 | | |
| 5 | SPCIPCSN | Locations | 3 | PNR | Part Number | nvarchar | 15 | 0 | | |
| 6 | SPCIPEFF | Effectivity Range | 3 | PNR | Part Number | nvarchar | 15 | 0 | | |
| 7 | SPCIPOCH | Other Charges - Code & Amount | 3 | PNR | Part Number | nvarchar | 15 | 0 | | |
| 8 | SPCIPOSC | SPEC2000: Stores optional suppliers for the subject SPL | 2 | PNR | Part Number | nvarchar | 15 | 0 | | |
| 9 | SPCIPOSC_D | SPEC2000: Stores deleted entries for SPCIPOSC | 2 | PNR | Part Number | nvarchar | 15 | 0 | | |
| 10 | SPCIPOSDS | Optional Suppliers and Distributors | 3 | PNR | Part Number | nvarchar | 15 | 0 | | |
| 11 | SPCIPPARTS | Other parts that can be used | 3 | PNR | Part Number | nvarchar | 15 | 0 | | |
| 12 | SPCIPPDR | Spare parts / End items | 3 | PNR | Part Number | nvarchar | 15 | 0 | | |
| 13 | SPCIPPDS | SPEC2000: Procurement Data Segment | 3 | PNR | Part Number | nvarchar | 15 | 0 | | |
| 14 | SPCIPPQA | Price Break - Quantity & Amount | 3 | PNR | Part Number | nvarchar | 15 | 0 | | |
| 15 | SPCIPRPDE | Replacing Parts / Replaced Parts | 3 | PNR | Part Number | nvarchar | 15 | 0 | | |
| 16 | SPCIPSPLMNT | SPEC2000: Stores Additional/Long/MultipleOccurance fields | 6 | PNR | Part Number | nvarchar | 15 | 0 | | |
| 17 | SPCIPUOA | Used On Assemblies | 3 | PNR | Part Number | nvarchar | 15 | 0 | | |
| TOPTravel Planning |
| 18 | TA23OS | Field Control for Travel Res. Request Item: Other Services | 4 | PNR | Integration of Other Service in the GDS PNR | nvarchar | 1 | 0 | | |
