| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /1CADMC/00000492 | TSABT | 6 | ABTNR | | nvarchar | 4 | 0 | | |
2 | /1RA/0SD010MI | Items for Class SD01 - Raw Data | 52 | ABTNR | Department number | nvarchar | 4 | 0 | | |
3 | /SMD/MD_____00RN | SID-Tabelle fuer Department | 3 | ABTNR | Department | nvarchar | 4 | 0 | | |
4 | BBPT_T023 | Material groups | 7 | ABTNR | Department number | nvarchar | 4 | 0 | | |
5 | CNV_20800_KNVK | CNV backup copy: Customer master contact person | 11 | ABTNR | Department number | nvarchar | 4 | 0 | | |
6 | ZEIM_LIPS | SD document: Delivery: Item data | 149 | ABTNR | Department number | nvarchar | 4 | 0 | | |
TOPAdvertising Management |
7 | JJTAM | IS-M/AM: Media Contact Person | 30 | ABTNR | Contact person department | nvarchar | 4 | 0 | | |
TOPAssortment List |
8 | WBBL | Assort. list control break | 13 | ABTNR | Department number | nvarchar | 4 | 0 | | |
TOPBasic Functions |
9 | TSAB | Contact persons: standard departments | 2 | ABTNR | Department number | nvarchar | 4 | 0 | | |
TOPBusiness Partner Enhancements for Financial Services |
10 | TP16 | Business Partner: Department | 3 | ABTNR | Department | nvarchar | 4 | 0 | | |
TOPCross-Application Components |
11 | SKNVK | Customer Master Contact table for BC417 Course | 10 | ABTNR | Contact person department | nvarchar | 4 | 0 | | |
12 | VVBKD | Sales Document: Business Data | 39 | ABTNR | Department number | nvarchar | 4 | 0 | | |
TOPCustomer Master |
13 | KNVK | Customer Master Contact Partner | 10 | ABTNR | Contact person department | nvarchar | 4 | 0 | | |
TOPData Collection |
14 | S160 | Perishables | 69 | ABTNR | Department number | nvarchar | 4 | 0 | | |
15 | S200 | Inventory Controlling Stores | 41 | ABTNR | Department number | nvarchar | 4 | 0 | | |
TOPMaster Data Synchronization |
16 | CVIC_CP1_LINK | Department Nos of Contact Persons (Customer/Vendor-->BP) | 2 | ABTNR | Department number | nvarchar | 4 | 0 | | |
TOPMaterial Groups |
17 | T023 | Material Groups | 7 | ABTNR | Department number | nvarchar | 4 | 0 | | |
TOPMaterial Maintenance |
18 | TSABT | Contact Person Departments: Texts | 3 | ABTNR | Department number | nvarchar | 4 | 0 | | |
TOPPlant Master |
19 | WRF4 | Plant/ Departments | 3 | ABTNR | Department number | nvarchar | 4 | 0 | | |
20 | WRF6 | Plant / material group | 6 | ABTNR | Department number | nvarchar | 4 | 0 | | |
TOPProfitability Analysis |
21 | CE1R300 | Operating Concern IDES | 57 | ABTNR | Department number | nvarchar | 4 | 0 | | |
22 | CE2R300 | Operating Concern IDES | 41 | ABTNR | Department number | nvarchar | 4 | 0 | | |
23 | CE4R300 | Operating Concern IDES | 26 | ABTNR | Department number | nvarchar | 4 | 0 | | |
24 | CE4R300_ACCT | Ergebnisbereich IDES | 27 | ABTNR | Abteilungsnummer | nvarchar | 4 | 0 | | |
25 | CE4R300_FLAG | Ergebnisbereich IDES | 23 | ABTNR | Flag: Merkmal manuell oder über TKEZU kontiert | nvarchar | 1 | 0 | | |
26 | CE4R300_KENC | Operating Concern IDES | 25 | ABTNR | Department number | nvarchar | 4 | 0 | | |
TOPSales |
27 | VBKD | Sales Document: Business Data | 39 | ABTNR | Department number | nvarchar | 4 | 0 | | |
TOPSales Promotions |
28 | SADLSTRECB | Dynamic Part of Address List (Record Body) | 80 | ABTNR | Department number | nvarchar | 4 | 0 | | |
TOPShipping |
29 | LIPS | SD document: Delivery: Item data | 149 | ABTNR | Department number | nvarchar | 4 | 0 | | |
TOPSimulation |
30 | VSVBKD_CN | Version: Sales document - commercial data | 40 | ABTNR | Department number | nvarchar | 4 | 0 | | |
TOPUse AP-MD-BP Components |
31 | BUT051 | BP Relationship: Contact Person Relationship | 11 | ABTNR | Department | nvarchar | 4 | 0 | | |
32 | BUT051S | Shadow Table BP Relationship: Contact Person Relationship | 12 | ABTNR | Department | nvarchar | 4 | 0 | | |
33 | TB910 | Contact Person Departments | 2 | ABTNR | Department | nvarchar | 4 | 0 | | |
34 | TB911 | Contact person in standard departments: Texts | 3 | ABTNR | Department | nvarchar | 4 | 0 | | |