| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMD/MD_____00SZ | SID-Tabelle fuer X-distr.chain status | 3 | VMSTA | Distribution-chain-specific material status | nvarchar | 2 | 0 | | |
2 | /SMD/MD_____00WT | SID-Tabelle fuer DChain-spec. status | 3 | VMSTA | Distribution-chain-specific material status | nvarchar | 2 | 0 | | |
3 | SGT_MVKE | Segmentation | Sales Status | 6 | VMSTA | Distribution-chain-specific material status | nvarchar | 2 | 0 | | |
TOPCompany Pension Scheme Germany |
4 | P01CVD | Actuarial CPS Data | 14 | VMSTA | Processing Status for Interface Data | nvarchar | 1 | 0 | | |
5 | P01CVH | Actuarial CPS Header Records | 12 | VMSTA | Processing Status for Interface Data | nvarchar | 1 | 0 | | |
6 | P01CVR | Actuarial CPS Pension Data | 14 | VMSTA | Processing Status for Interface Data | nvarchar | 1 | 0 | | |
TOPCustomer Master |
7 | TVMS | Materials: Status in Sales and Distribution | 2 | VMSTA | Distribution-chain-specific material status | nvarchar | 2 | 0 | | |
8 | TVMST | Materials: SD Status: Texts | 3 | VMSTA | Distribution-chain-specific material status | nvarchar | 2 | 0 | | |
TOPMaterial Master |
9 | MVKE | Sales Data for Material | 10 | VMSTA | Distribution-chain-specific material status | nvarchar | 2 | 0 | | |
10 | MVKE_TMP | File for Incorrect Data in Direct Input | 13 | VMSTA | Distribution-chain-specific material status | nvarchar | 2 | 0 | | |
11 | MVVE | Sales Data for Material | 10 | VMSTA | Distribution-chain-specific material status | nvarchar | 2 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
12 | /BEV1/TSSTMATS | Statistics: Category/Material Status | 7 | VMSTA | Distribution-chain-specific material status | nvarchar | 2 | 0 | | |