| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | A053 | Taxes Using Jurisdiction Code | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
2 | A965 | Country/Plant/TaxCl.Mat/TaxCl1Cust | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
3 | A966 | Country/Plant/TaxCl.2Mat/TaxCl2Cust | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
4 | P2RA_ST | Payroll Result: Tax (Austria) | 44 | ALAND | ISO Code of Country or DTC | nvarchar | 2 | 0 | | |
TOPAdvertising Management |
5 | A212 | IS-M: DelCtry/BP Tax Classification | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
6 | A260 | IS-M: DelCtry/TaxC1 | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
7 | A261 | IS-M: VAT Country/RecLand/Cust.Tax Classification | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
8 | A262 | IS-M: VAT Country/RecCountry/CustTaxCl/TaxClass | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
9 | A263 | IS-M: DelCtry/Mat.Tax Class. | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
10 | JHAPD | IS-M/AM: OPM Service Item | 26 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
11 | JHTFP | IS-M/AM: Billing/Settlement Documents - Item | 144 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
12 | JJTDISK | IS-M/AM Tax Classification for Service | 3 | ALAND | Country is relevant for taxes | nvarchar | 3 | 0 | | |
TOPAustria |
13 | PA0042 | HR Master Record: Infotype 0042 (Fiscal Data - Austria) | 143 | ALAND | ISO Code of Country or DTC | nvarchar | 2 | 0 | | |
14 | T5A71 | L16 Consolidation File | 131 | ALAND | ISO Code of Country or DTC | nvarchar | 2 | 0 | | |
TOPBasic Functions |
15 | A121 | Legal Control: Values for Calculating Foreign Percentage | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
16 | A340 | Foreign Trade: CAP: Restitution rates | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
17 | EIKP | Foreign Trade: Export/Import Header Data | 3 | ALAND | Delivering country | nvarchar | 3 | 0 | | |
18 | T604S | Preference: Determine Preference Zone in Export | 2 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
19 | T604U | Foreign Trade: Convert Commodity Code/Import Code No. | 2 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
20 | T605U | Foreign Trade: Convert Export/Import Bus. Trans. Type | 2 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
21 | T606A | Legal Control: Departure Country / Legal Regulations | 2 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
22 | T606O | Legal Control: Embargo - Dependent on Departure Country | 3 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
23 | T615U | Foreign Trade: Import/Export Customs Office Conversion | 2 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
24 | T616U | Foreign Trade: Import/Export Procedure Conversion | 2 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
25 | T617 | Foreign Trade: Proposal for Foreign Trade Header Data | 3 | ALAND | Country Key | nvarchar | 3 | 0 | | |
26 | T618U | Foreign Trade: Conversion of Import/Export Mode of Transport | 2 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
27 | TROAZ | Routes: Determination in Sales Documents | 2 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
TOPBilling |
28 | A399 | Withholding tax code - country-specific | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
29 | KNVI | Customer Master Tax Indicator | 3 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
30 | KNVL | Customer Master Licenses | 3 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
31 | VBRP | Billing Document: Item Data | 44 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
TOPConditions |
32 | A002 | Country/Customer Classification/Material Classification | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
33 | A003 | Tax Classification | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
34 | A011 | Country/Country of Dest./Customer Classif./Material Classif. | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
35 | A040 | Country/State/Customer Classif.1/Material Classification 1 | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
36 | A041 | Country/State/County/Customer Classif.2/Material Classif.2 | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
37 | A042 | Country/State/City/Customer Classif.3/Material Classif.3 | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
38 | A078 | Departure Country / Destination Country | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
39 | A156 | Country of Departure/Destination Country/Del. Country | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
40 | A180 | Country/Preference Zone/Cross-Plant Grouping | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
41 | A354 | Country/Region/PlntRegion | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
42 | A356 | Country/PlntRegion/ST Code/TaxCl1Cust/TaxCl.Mat | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
43 | A357 | Country/Plant/Ctrl code | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
44 | A358 | Country/Plant/Ctrl code/Material | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
45 | A362 | Country/NBM-NCM Code | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
46 | A367 | Country/Plant/Region/Material | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
47 | A368 | Country/PlntRegion/Region/TaxCl1Cust/TaxCl.Mat | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
48 | A369 | Country/Plant/Ctrl code/TaxCl1Cust | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
49 | A371 | Country/Plant/Ctrl code/Ship-to | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
50 | A390 | Brazil: 100% reversals | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
51 | A602 | Condition Table for Pricing A602 | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
52 | A940 | Condition Table for Pricing A940 | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
TOPContract Accounts Receivable and Payable |
53 | FKK_JFRP_SHORT | Item Data for IS-M/SD Billing Document - Extracts | 18 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
TOPData Collection |
54 | S050 | Shipment | 11 | ALAND | Country: shipment start | nvarchar | 3 | 0 | | |
55 | S050E | S050 - Structural Information | 6 | ALAND | Country: shipment start | nvarchar | 3 | 0 | | |
TOPFinancial Accounting |
56 | A395 | Arg.: Country/Fisc.Type | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
57 | A396 | Arg.: Country/Fisc.Type/Material | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
58 | A397 | Arg.: Tax relevant classification | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
59 | T007V | Tax Codes to be Transported | 3 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
TOPInventory Management |
60 | A133 | Mixed Taxes, Domestic | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
TOPLease Accounting |
61 | TFILA_RE_CAT_C | Assign Sales Tax Flag and Clearing Account to Refi. Categ. | 12 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
TOPLocalization |
62 | A291 | Land/SteuKennz. | 4 | ALAND | Lieferndes Land (Land aus dem die Ware versandt wird) | nvarchar | 3 | 0 | | |
63 | A292 | BR: ISS from SD: Ship-to-City | 4 | ALAND | Lieferndes Land (Land aus dem die Ware versandt wird) | nvarchar | 3 | 0 | | |
64 | A293 | Land/StKla2-Kd | 4 | ALAND | Lieferndes Land (Land aus dem die Ware versandt wird) | nvarchar | 3 | 0 | | |
65 | A341 | Land/StKla3-Kd | 4 | ALAND | Lieferndes Land (Land aus dem die Ware versandt wird) | nvarchar | 3 | 0 | | |
66 | A342 | Land/StKla2-Mat | 4 | ALAND | Lieferndes Land (Land aus dem die Ware versandt wird) | nvarchar | 3 | 0 | | |
67 | A343 | BR: Substituiçao Tributária from SD | 4 | ALAND | Lieferndes Land (Land aus dem die Ware versandt wird) | nvarchar | 3 | 0 | | |
68 | A344 | BR: ICMS base reduction carrier: Land/St. Basis/Belegart | 4 | ALAND | Lieferndes Land (Land aus dem die Ware versandt wird) | nvarchar | 3 | 0 | | |
69 | A346 | Land/Dyn.Schlüssel1/Dyn.Schlüssel2/Dyn.Schlüssel3/St.-Grp. | 4 | ALAND | Lieferndes Land (Land aus dem die Ware versandt wird) | nvarchar | 3 | 0 | | |
70 | A347 | Land/SF/ST/Schlüssel1/Schlüssel2/Schlüssel3/St.-Grp. | 4 | ALAND | Lieferndes Land (Land aus dem die Ware versandt wird) | nvarchar | 3 | 0 | | |
71 | A348 | Land/SF/ST/XSUBT/Schlüssel1/Schlüssel2/Schlüssel3/St.-Grp. | 4 | ALAND | Lieferndes Land (Land aus dem die Ware versandt wird) | nvarchar | 3 | 0 | | |
72 | A349 | Land/ST/MATNR | 4 | ALAND | Lieferndes Land (Land aus dem die Ware versandt wird) | nvarchar | 3 | 0 | | |
73 | A373 | Country/Plant/Material | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
74 | A374 | Country/Sales org./Region/PlntRegion/TaxCl3Cust/TaxCl.3Mat | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
75 | A375 | Country/Sales org./Region/PlntRegion/TaxCl2Cust/TaxCl.2Mat | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
76 | A376 | Country/Sales org./Region/PlntRegion/TaxCl4Cust/TaxCl.4Mat | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
77 | A382 | Land/Belegart/SF/ST/Schlüssel1/Schlüssel2/Schlüssel3/St.-Grp | 4 | ALAND | Lieferndes Land (Land aus dem die Ware versandt wird) | nvarchar | 3 | 0 | | |
78 | A392 | Land | 4 | ALAND | Lieferndes Land (Land aus dem die Ware versandt wird) | nvarchar | 3 | 0 | | |
79 | A393 | Land/Lieferant | 4 | ALAND | Lieferndes Land (Land aus dem die Ware versandt wird) | nvarchar | 3 | 0 | | |
80 | A394 | Land/Empfänger | 4 | ALAND | Lieferndes Land (Land aus dem die Ware versandt wird) | nvarchar | 3 | 0 | | |
81 | IDGT_CODE_LC | Tax Catalog Code | 2 | ALAND | Country Key | nvarchar | 3 | 0 | | |
82 | J_1INEWJCODE | VAT Transition Dummy Jurisdiction Code | 2 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
83 | J_1ITCJCMAP | Tax code and Jurisdiction code mapping | 2 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
TOPLogistics - General |
84 | A190 | Condition Table for Pricing A190 | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
85 | A191 | Condition Table for Pricing A191 | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
86 | A192 | Country/Goods Rec./StCla-Mat | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
87 | A193 | Condition Table for Pricing A193 | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
TOPMaterial Maintenance |
88 | TVST | Organizational Unit: Shipping Points | 6 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
TOPMaterial Master |
89 | MAEX | Material Master: Legal Control | 3 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
90 | MLAN | Tax Classification for Material | 3 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
91 | MVAN | Tax Classification for Material | 3 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
92 | STEUMM_TMP | File for Incorrect Data in Direct Input | 6 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
93 | STEU_TMP | File for Incorrect Data in Direct Input | 6 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
TOPPatient Accounting |
94 | NVBRP | IS-H: Billing document item data | 19 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
TOPPeriodical Sales and Distribution |
95 | JDTMLAN | IS-M/SD: Tax Code for Publication | 3 | ALAND | Country is relevant for taxes | nvarchar | 3 | 0 | | |
96 | JFRP | IS-M/SD: Billing Document - Item Data | 16 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
TOPRecycling Administration Core Functions |
97 | J_7LVBRPOS | NON-SD Interface: Billing: Item Data | 15 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
98 | /BEV1/BO_VAT | Settlement Materials for the VAT Adjustment | 2 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
99 | /BEV1/RBVAT | Settlement Materials Value-Added Tax Rates | 2 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
TOPTransportation |
100 | TROIZ | Route Determination: By Country and Zone | 2 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
101 | TROLZ | Routes: Determination in Deliveries | 2 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
TOPUSA |
102 | PA0566 | HR Master Record: Infotype 0566 | 44 | ALAND | Country Key | nvarchar | 3 | 0 | | |
TOPWarranty Claim Processing |
103 | A388 | Country/Tax Class.-Customer | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |
104 | A389 | Country/Partner/Tax Class.-Customer | 4 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | | |