| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /1CADMC/00000537 | TVV2 | 5 | KVGR2 | | nvarchar | 3 | 0 | | |
2 | /1CADMC/00000538 | TVV2T | 6 | KVGR2 | | nvarchar | 3 | 0 | | |
3 | /BIC/B0000176000 | PSA for 2LIS_11_VAHDR T90CLNT090 Sales Doc. Header | 25 | KVGR2 | | nvarchar | 3 | 0 | | |
4 | /BIC/B0000177000 | PSA for 2LIS_11_V_ITM T90CLNT090 Sls-Ship.Alloc.Item | 15 | KVGR2 | | nvarchar | 3 | 0 | | |
5 | /BIC/B0000178000 | PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item | 25 | KVGR2 | | nvarchar | 3 | 0 | | |
6 | /BIC/B0000179000 | PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule | 38 | KVGR2 | | nvarchar | 3 | 0 | | |
7 | /BIC/B0000180000 | PSA for 2LIS_11_V_SCL T90CLNT090 Sls-Ship.Alloc.Sch. | 28 | KVGR2 | | nvarchar | 3 | 0 | | |
8 | /BIC/B0000181000 | PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond. | 20 | KVGR2 | | nvarchar | 3 | 0 | | |
9 | /BIC/B0000183000 | PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item | 48 | KVGR2 | | nvarchar | 3 | 0 | | |
10 | /BIC/B0000185000 | PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item | 48 | KVGR2 | | nvarchar | 3 | 0 | | |
11 | /BIC/B0000186000 | PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond. | 40 | KVGR2 | | nvarchar | 3 | 0 | | |
12 | /SMD/MD_____00YV | SID-Tabelle fuer Customer group 2 | 3 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
13 | A710 | Surcharge/TradeLane/ServiceType/ContainerTypeSize | 5 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
14 | A711 | Surcharge/TradeLane/ServiceType/POL/ContainerTypeSize | 5 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
15 | A712 | Surcharge/TradeLane/ServiceType/POD/ContainerTypeSize | 5 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
16 | A720 | Trade Lane/POR - City/POD - City/ServiceType/Cont.TypeSize | 4 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
17 | A721 | TradeLane/POR-Countr/POD-Countr/ServiceType/Cont.TypeSize | 4 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
18 | A722 | TradeLane/POR - City/POD-Countr/ServiceType/Cont.TypeSize | 4 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
19 | A723 | TradeLane/POR-Countr/POD - City/ServiceType/Cont.TypeSize | 4 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
20 | A724 | TradeLane/POL/POD/ServiceType/Cont.TypeSize | 4 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
21 | A730 | TradeLane/ServiceType/ContainerTypeSize | 4 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
22 | A731 | TradeLane/ServiceType/POL/ContainerTypeSize | 4 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
23 | A732 | TradeLane/ServiceType/POD/ContainerTypeSize | 4 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
24 | ZEIM_LIPS | SD document: Delivery: Item data | 90 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
25 | ZEIM_VBAK | Sales Document: Header Data | 54 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
TOPBasic Functions |
26 | TVV2 | Customer Group 2 | 2 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
27 | TVV2T | Customer group 2: Description | 3 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
TOPBilling |
28 | VBRP | Billing Document: Item Data | 90 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
TOPConditions |
29 | A740 | SD Doc./Cust.grp.2/POR - City/POD - City/Shpg Cond./Variant | 5 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
30 | A741 | SD Doc./Cust.grp.2/POR-Countr/POD-Countr/Shpg Cond./Variant | 5 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
31 | A742 | SD Doc./Cust.grp.2/POR - City/POD-Countr/Shpg Cond./Variant | 5 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
32 | A743 | SD Doc./Cust.grp.2/POR-Countr/POD - City/Shpg Cond./Variant | 5 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
33 | A744 | SD Doc./Cust.grp.2/POL/POD/Shpg Cond./Variant | 5 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
TOPCross-Application Components |
34 | VVBAK | Sales Document: Header Data | 54 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
TOPCustomer Master |
35 | KNVV | Customer Master Sales Data | 44 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
TOPData Collection |
36 | S260 | SD - Sales order | 23 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
37 | S260BIW1 | SD - Sales order | 23 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
38 | S260BIW2 | SD - Sales order | 23 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
39 | S261 | SD - Delivery note | 68 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
40 | S261BIW1 | SD - Delivery note | 68 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
41 | S261BIW2 | SD - Delivery note | 68 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
42 | S262 | SD - Billing document | 56 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
43 | S262BIW1 | SD - Billing document | 56 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
44 | S262BIW2 | SD - Billing document | 56 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
45 | S263 | SD - Sales order/delivery note | 20 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
46 | S263BIW1 | SD - Sales order/delivery note | 20 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
47 | S263BIW2 | SD - Sales order/delivery note | 20 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
48 | S264 | SD- Offer | 23 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
49 | S264BIW1 | S264BIW1 * SD - Quotation | 23 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
50 | S264BIW2 | S264BIW2 * SD - Quotation | 23 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
51 | /BEV1/RBVBAK | Sales Document: Header Data | 54 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
TOPSales |
52 | VBAK | Sales Document: Header Data | 54 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
TOPShipping |
53 | LIPS | SD document: Delivery: Item data | 90 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |
TOPSimulation |
54 | VSVBAK_CN | Version: Sales document: Header data | 55 | KVGR2 | Customer group 2 | nvarchar | 3 | 0 | | |