| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /1CADMC/00000525 | TVM2 | 5 | MVGR2 | | nvarchar | 3 | 0 | | |
2 | /1CADMC/00000526 | TVM2T | 6 | MVGR2 | | nvarchar | 3 | 0 | | |
3 | /BIC/B0000177000 | PSA for 2LIS_11_V_ITM T90CLNT090 Sls-Ship.Alloc.Item | 36 | MVGR2 | | nvarchar | 3 | 0 | | |
4 | /BIC/B0000178000 | PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item | 70 | MVGR2 | | nvarchar | 3 | 0 | | |
5 | /BIC/B0000179000 | PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule | 67 | MVGR2 | | nvarchar | 3 | 0 | | |
6 | /BIC/B0000180000 | PSA for 2LIS_11_V_SCL T90CLNT090 Sls-Ship.Alloc.Sch. | 48 | MVGR2 | | nvarchar | 3 | 0 | | |
7 | /BIC/B0000181000 | PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond. | 44 | MVGR2 | | nvarchar | 3 | 0 | | |
8 | /BIC/B0000183000 | PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item | 64 | MVGR2 | | nvarchar | 3 | 0 | | |
9 | /BIC/B0000185000 | PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item | 65 | MVGR2 | | nvarchar | 3 | 0 | | |
10 | /BIC/B0000186000 | PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond. | 48 | MVGR2 | | nvarchar | 3 | 0 | | |
11 | /SMD/MD_____00S0 | SID-Tabelle fuer Material group 2 | 3 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
12 | ZEIM_LIPS | SD document: Delivery: Item data | 95 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
13 | ZEIM_VBAP | Sales Document: Item Data | 125 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
TOPAccount Determination |
14 | TVM2 | Material Pricing Group 2 | 2 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
15 | TVM2T | Material Pricing Group 2: Description | 3 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
TOPBilling |
16 | VBRP | Billing Document: Item Data | 95 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
TOPCross-Application Components |
17 | VVBAP | Sales Document: Item Data | 125 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
TOPData Collection |
18 | S260 | SD - Sales order | 52 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
19 | S260BIW1 | SD - Sales order | 52 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
20 | S260BIW2 | SD - Sales order | 52 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
21 | S261 | SD - Delivery note | 73 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
22 | S261BIW1 | SD - Delivery note | 73 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
23 | S261BIW2 | SD - Delivery note | 73 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
24 | S262 | SD - Billing document | 61 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
25 | S262BIW1 | SD - Billing document | 61 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
26 | S262BIW2 | SD - Billing document | 61 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
27 | S263 | SD - Sales order/delivery note | 47 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
28 | S263BIW1 | SD - Sales order/delivery note | 47 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
29 | S263BIW2 | SD - Sales order/delivery note | 47 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
30 | S264 | SD- Offer | 54 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
31 | S264BIW1 | S264BIW1 * SD - Quotation | 54 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
32 | S264BIW2 | S264BIW2 * SD - Quotation | 54 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
TOPDistributor-Reseller-Management |
33 | KOTW001 | Matl grp 2/Matl grp 3/Price list | 4 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
TOPLogistics - General |
34 | WBHI | Trading Contract: Item Data | 60 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
TOPMaterial Master |
35 | MVKE | Sales Data for Material | 25 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
36 | MVKE_TMP | File for Incorrect Data in Direct Input | 28 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
37 | MVVE | Sales Data for Material | 25 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
38 | /BEV1/RBVBAP | Sales Document: Item Data | 125 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
TOPSales |
39 | VBAP | Sales Document: Item Data | 125 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
TOPShipping |
40 | LIPS | SD document: Delivery: Item data | 95 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
TOPSimulation |
41 | VSVBAP_CN | Version: Sales document: Item data | 126 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
TOPTariffs, Duties and Permits |
42 | A423 | Customer Specific Tax (FOB) | 6 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
43 | A424 | Exception for States (FOB) | 7 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
44 | A425 | State Tax FOB | 6 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
45 | A426 | State Tax on delivered goods | 6 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
46 | A433 | Customer Specific Tax (FOB) - Federal | 5 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
47 | A434 | Incoterms / Material group 2 - Federal | 5 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |
48 | OIHL | License Master Data | 9 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | | |