| 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 | | |
