| 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 | 287 | STAWN | Commodity Code/Import Code Number for Foreign Trade | nvarchar | 17 | 0 | | |
2 | J_3RFGTD_ITEM | Import Customs Declaration Items | 26 | STAWN | Commodity Code/Import Code Number for Foreign Trade | nvarchar | 17 | 0 | | |
TOPBasic Functions |
3 | EIPO | Foreign Trade: Export/Import: Item Data | 4 | STAWN | Commodity Code/Import Code Number for Foreign Trade | nvarchar | 17 | 0 | | |
4 | MAFU | Foreign Trade: Additional Information for Material/Code No. | 6 | STAWN | Commodity Code/Import Code Number for Foreign Trade | nvarchar | 17 | 0 | | |
5 | MMPREF_PRO_02 | Log table - Main component - Information | 8 | STAWN | Commodity code (8 digits) preference | nvarchar | 8 | 0 | | |
6 | MMPREF_PRO_03 | Log table - Component - Information | 15 | STAWN | Commodity Code/Import Code Number for Foreign Trade | nvarchar | 17 | 0 | | |
7 | MMPREK_PRO_02 | Log table - Main component - Information | 11 | STAWN | Commodity code (8 digits) preference | nvarchar | 8 | 0 | | |
8 | MMPREK_PRO_03 | Log table - Component - Information | 18 | STAWN | Commodity Code/Import Code Number for Foreign Trade | nvarchar | 17 | 0 | | |
9 | MMPREW_PRO_02 | Preference CPG: Log main component - Information | 10 | STAWN | Commodity code (8 digits) preference | nvarchar | 8 | 0 | | |
10 | MMPREW_PRO_03 | Preference CPG: Log components - Information | 17 | STAWN | Commodity Code/Import Code Number for Foreign Trade | nvarchar | 17 | 0 | | |
11 | T604 | Foreign Trade: Commodity Code / Import Code Number | 3 | STAWN | Commodity Code/Import Code Number for Foreign Trade | nvarchar | 17 | 0 | | |
12 | T604P | Preference: Preference Zone/Rule | 3 | STAWN | Commodity code (8 digits) preference | nvarchar | 8 | 0 | | |
13 | T604STW | Foreign Trade: Keywords for commodity codes | 5 | STAWN | Commodity Code/Import Code Number for Foreign Trade | nvarchar | 17 | 0 | | |
14 | T604T | Foreign Trade: Commodity Code/Import Code No. Description | 4 | STAWN | Commodity Code/Import Code Number for Foreign Trade | nvarchar | 17 | 0 | | |
15 | T606AS | Legal Control: Export Control Class - Commodity Code | 4 | STAWN | Commodity Code/Import Code Number for Foreign Trade | nvarchar | 17 | 0 | | |
16 | T610FA | Import Processing: Anti-dumping Code Determination | 3 | STAWN | Code number for import processing in foreign trade | nvarchar | 17 | 0 | | |
17 | T610FD | Import Processing: Pharmaceut. Products Code Determination | 3 | STAWN | Code number for import processing in foreign trade | nvarchar | 17 | 0 | | |
18 | T610FE | Import Processing: Import Verification Doc. Determination | 3 | STAWN | Code number for import processing in foreign trade | nvarchar | 17 | 0 | | |
19 | T610FK | Import Processing: Customs Quota Code Determination | 3 | STAWN | Code number for import processing in foreign trade | nvarchar | 17 | 0 | | |
20 | T610FL | Import Processing: Third-country Duty Rate Determination | 3 | STAWN | Code number for import processing in foreign trade | nvarchar | 17 | 0 | | |
21 | T610FP | Import Processing: Preferential Duty Rate Determination | 3 | STAWN | Code number for import processing in foreign trade | nvarchar | 17 | 0 | | |
22 | T610FS | Import Processing: Customs Exemption Determination | 3 | STAWN | Code number for import processing in foreign trade | nvarchar | 17 | 0 | | |
23 | T618ME | CAP-relevant material components | 6 | STAWN | Commodity Code/Import Code Number for Foreign Trade | nvarchar | 17 | 0 | | |
TOPCross-Application Components |
24 | MMARC | Plant Data for Material | 91 | STAWN | Commodity Code/Import Code Number for Foreign Trade | nvarchar | 17 | 0 | | |
TOPForeign Trade |
25 | /SAPSLL/SWNWLR3 | GTS: Worklist: Retransfer of MATNR - STAWN Relation | 5 | STAWN | Commodity Code/Import Code Number for Foreign Trade | nvarchar | 17 | 0 | | |
26 | /SAPSLL/T604R3 | GTS: Worklist: Retransfer of Commodity Code | 4 | STAWN | Commodity Code/Import Code Number for Foreign Trade | nvarchar | 17 | 0 | | |
TOPLocalization |
27 | A151 | Dest. Ctry/Comm. code | 5 | STAWN | Commodity Code/Import Code Number for Foreign Trade | nvarchar | 17 | 0 | | |
28 | J_3RSCCDITEM | Cargo Customs Declaration Item | 7 | STAWN | Commodity Code/Import Code Number for Foreign Trade | nvarchar | 17 | 0 | | |
TOPMaterial Master |
29 | MARC | Plant Data for Material | 91 | STAWN | Commodity Code/Import Code Number for Foreign Trade | nvarchar | 17 | 0 | | |
30 | MARC_TMP | File for Incorrect Data in Direct Input | 94 | STAWN | Commodity Code/Import Code Number for Foreign Trade | nvarchar | 17 | 0 | | |
31 | MVRC | Cross-version fields for MARC | 91 | STAWN | Commodity Code/Import Code Number for Foreign Trade | nvarchar | 17 | 0 | | |