| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMERP/STG_MM001 | Data staging - Material master plant view complex table | 331 | PREFE | Preference indicator in export/import | nvarchar | 1 | 0 | | |
2 | ZEIM_LIPS | SD document: Delivery: Item data | 154 | PREFE | Preference indicator in export/import | nvarchar | 1 | 0 | | |
3 | ZEIM_VBAP | Sales Document: Item Data | 168 | PREFE | Preference indicator in export/import | nvarchar | 1 | 0 | | |
TOPBasic Functions |
4 | LFEI | Vendor Master: Preference for Import and Export | 6 | PREFE | Preference indicator in export/import | nvarchar | 1 | 0 | | |
5 | MAPEWG | Material master: Preference determination: Cross-plant | 6 | PREFE | Preference indicator in export/import | nvarchar | 1 | 0 | | |
6 | MMPREF_PRO_01 | Logging table for archiving object MMPREF | 7 | PREFE | Preference indicator in export/import | nvarchar | 1 | 0 | | |
7 | MMPREF_PRO_03 | Log table - Component - Information | 13 | PREFE | Preference indicator in export/import | nvarchar | 1 | 0 | | |
8 | MMPREK_PRO_01 | Log table for archiving object MMPREK | 10 | PREFE | Preference indicator in export/import | nvarchar | 1 | 0 | | |
9 | MMPREK_PRO_03 | Log table - Component - Information | 16 | PREFE | Preference indicator in export/import | nvarchar | 1 | 0 | | |
10 | MMPREW_PRO_01 | Log table for archiving object MMPREW | 11 | PREFE | Preference indicator in export/import | nvarchar | 1 | 0 | | |
11 | MMPREW_PRO_03 | Preference CPG: Log components - Information | 15 | PREFE | Preference indicator in export/import | nvarchar | 1 | 0 | | |
TOPBilling |
12 | VBRP | Billing Document: Item Data | 134 | PREFE | Preference indicator in export/import | nvarchar | 1 | 0 | | |
TOPCross-Application Components |
13 | MMARC | Plant Data for Material | 135 | PREFE | Preference indicator in export/import | nvarchar | 1 | 0 | | |
14 | VVBAP | Sales Document: Item Data | 168 | PREFE | Preference indicator in export/import | nvarchar | 1 | 0 | | |
TOPForeign Trade |
15 | /SAPSLL/PRPREFR3 | GTS: Material Master Record: Preference Data (Summarized) | 9 | PREFE | Preference: Preference Indicator for GTS | nvarchar | 2 | 0 | | |
TOPGlobal Trade Services |
16 | /SAPSLL/KMATPREF | GTS: Preference Processing KMAT - Storage of Results | 11 | PREFE | Preference: Preference Indicator | nvarchar | 2 | 0 | | |
17 | /SAPSLL/PRFPMRC | SLL: Preference: Log: product: Result of BOM Calc - Compnt | 13 | PREFE | Preference: Preference Indicator | nvarchar | 2 | 0 | | |
18 | /SAPSLL/PRFPMV | SLL: Preference: Logging: Products: Values | 8 | PREFE | Preference: Preference Indicator | nvarchar | 2 | 0 | | |
19 | /SAPSLL/PRPREF | SLL: Product Master: Preference Data | 10 | PREFE | Preference: Preference Indicator | nvarchar | 2 | 0 | | |
TOPMaterial Master |
20 | MAPE | Material Master: Export Control File | 5 | PREFE | Preference indicator in export/import | nvarchar | 1 | 0 | | |
21 | MARC | Plant Data for Material | 135 | PREFE | Preference indicator in export/import | nvarchar | 1 | 0 | | |
22 | MARC_TMP | File for Incorrect Data in Direct Input | 138 | PREFE | Preference indicator in export/import | nvarchar | 1 | 0 | | |
23 | MVRC | Cross-version fields for MARC | 135 | PREFE | Preference indicator in export/import | nvarchar | 1 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
24 | /BEV1/RBVBAP | Sales Document: Item Data | 168 | PREFE | Preference indicator in export/import | nvarchar | 1 | 0 | | |
TOPSales |
25 | VBAP | Sales Document: Item Data | 168 | PREFE | Preference indicator in export/import | nvarchar | 1 | 0 | | |
TOPShipping |
26 | LIPS | SD document: Delivery: Item data | 154 | PREFE | Preference indicator in export/import | nvarchar | 1 | 0 | | |
TOPSimulation |
27 | VSVBAP_CN | Version: Sales document: Item data | 169 | PREFE | Preference indicator in export/import | nvarchar | 1 | 0 | | |