CountriesMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - CountriesMD
Overview
This view provides a comprehensive set of country-specific data for SAP systems, including country names, languages, nationalities, postal code formats, bank account formats, tax registration number formats, and various other settings.
Data Sources
| Source Table/View | Description |
|---|---|
| T005 | Country-specific settings table |
| T005T | Country-specific settings text table |
Key Use Cases
- Retrieve country-specific data for reporting and analysis
- Configure system settings based on country-specific requirements
- Validate and format data entered by users based on country-specific rules
Query Logic
The view joins the T005 and T005T tables on the MANDT and LAND1 fields to retrieve both country-specific settings and their corresponding text descriptions.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| OB01 | Maintain Country-Specific Settings |
| OB02 | Display Country-Specific Settings |
| OB03 | Copy Country-Specific Settings |
| OB04 | Delete Country-Specific Settings |
| OB05 | Transport Country-Specific Settings |
| OB06 | Activate Country-Specific Settings |
| OB07 | Deactivate Country-Specific Settings |
| OB08 | Display Country-Specific Settings for All Clients |
| OB09 | Display Country-Specific Settings for a Specific Client |
| OB10 | Maintain Country-Specific Settings for a Specific Client |
| OB11 | Copy Country-Specific Settings for a Specific Client |
| OB12 | Delete Country-Specific Settings for a Specific Client |
| OB13 | Transport Country-Specific Settings for a Specific Client |
| OB14 | Activate Country-Specific Settings for a Specific Client |
| OB15 | Deactivate Country-Specific Settings for a Specific Client |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client | |
| CountryKey_LAND1 | Country Key | |
| CountryName_LANDX | Country Name | |
| Language_SPRAS | Language | |
| Nationality_NATIO | Nationality | |
| CountryName__max50Characters___LANDX50 | Country Name (max 50 characters) | |
| Nationality__max50Characters___NATIO50 | Nationality (max 50 characters) | |
| SuperRegionPerCountryText_PRQ_SPREGT | Super Region Per Country Text | |
| VehicleCountryKey_LANDK | Vehicle Country Key | |
| PostalCodeLength_LNPLZ | Postal Code Length | |
| RuleForThePostalCodeFieldCheck_PRPLZ | Rule For The Postal Code Field Check | |
| FormattingRoutineKeyForPrintingAddresses_ADDRS | Formatting Routine Key For Printing Addresses | |
| Flag_StreetAddressPostalCodeRequiredEntry_XPLZS | Flag Street Address Postal Code Required Entry | |
| Flag_PoBoxPostalCodeRequired_XPLPF | Flag Po Box Postal Code Required | |
| CountryLanguage_SPRAS | Country Language | |
| CountryVersionFlag_XLAND | Country Version Flag | |
| Flag_PrintCountryNameInForeignAddresses_XADDR | Flag Print Country Name In Foreign Addresses | |
| StandardNameFormat_NMFMT | Standard Name Format | |
| Flag_CityFileAddressCheck_XREGS | Flag City File Address Check | |
| FlagStreetSpecificPostalCode__cityFile___XPLST | Flag Street Specific Postal Code (city File) | |
| CountryIsoCode_INTCA | Country Iso Code | |
| IsoCountryCode3Char_INTCA3 | Iso Country Code 3 Char | |
| IsoCountryCodeNumeric3Characters_INTCN3 | Iso Country Code Numeric 3 Characters | |
| Indicator_EuropeanUnionMember_XEGLD | Indicator European Union Member | |
| Indicator_DiscountBaseAmountIsTheNetValue_XSKFN | Indicator Discount Base Amount Is The Net Value | |
| Indicator_BaseAmountForTaxIsNetOfDiscount_XMWSN | Indicator Base Amount For Tax Is Net Of Discount | |
| BankAccountNumberLength_LNBKN | Bank Account Number Length | |
| RuleForCheckingBankAccountNumberField_PRBKN | Rule For Checking Bank Account Number Field | |
| BankNumberLength_LNBLZ | Bank Number Length | |
| RuleForCheckingBankNumberField_PRBLZ | Rule For Checking Bank Number Field | |
| PostOfficeBankCurrentAccountNumberLength_LNPSK | Post Office Bank Current Account Number Length | |
| RuleForCheckingPostalCheckAccountNumberField_PRPSK | Rule For Checking Postal Check Account Number Field | |
| Indicator_UseCheckModuleForBankFields_XPRBK | Indicator Use Check Module For Bank Fields | |
| NameOfTheBankKey_BNKEY | Name Of The Bank Key | |
| LengthOfBankKey_LNBKS | Length Of Bank Key | |
| RuleForCheckingBankKeyField_PRBKS | Rule For Checking Bank Key Field | |
| Indicator_UseCheckModuleForTaxFieldsEtc_XPRSO | Indicator Use Check Module For Tax Fields Etc | |
| RuleForCheckingVatRegistrationNumberField_PRUIN | Rule For Checking Vat Registration Number Field | |
| VatRegistrationNumberLength_UINLN | Vat Registration Number Length | |
| PermittedInputLengthForTaxNumbre1_LNST1 | Permitted Input Length For Tax Numbre1 | |
| RuleForCheckingTaxCode1Field_PRST1 | Rule For Checking Tax Code1 Field | |
| PermittedInputLengthForTaxNumber2_LNST2 | Permitted Input Length For Tax Number2 | |
| RuleForCheckingTaxCode2Field_PRST2 | Rule For Checking Tax Code2 Field | |
| PermittedInputLengthForTaxNumber3_LNST3 | Permitted Input Length For Tax Number3 | |
| RuleForCheckingTaxCode3Field_PRST3 | Rule For Checking Tax Code3 Field | |
| PermittedInputLengthForTaxNumber4_LNST4 | Permitted Input Length For Tax Number4 | |
| RuleForCheckingTaxCode4Field_PRST4 | Rule For Checking Tax Code4 Field | |
| PermittedInputLengthForTaxNumber5_LNST5 | Permitted Input Length For Tax Number5 | |
| RuleForCheckingTaxCode5Field_PRST5 | Rule For Checking Tax Code5 Field | |
| Duevo_Nationality_LANDD | Duevo Nationality | |
| Procedure__pricing_KALSM | Procedure (pricing) | |
| AlternativeCountryKey_LANDA | Alternative Country Key | |
| PaymentPeriodForBillOfExchange_WECHF | Payment Period For Bill Of Exchange | |
| ShortNameForForeignTradeStatistics_LKVRZ | Short Name For Foreign Trade Statistics | |
| IntrastatCode_INTCN | Intrastat Code | |
| DecimalPointFormat_XDEZP | Decimal Point Format | |
| DateFormat_DATFM | Date Format | |
| CurrencyKeyOfTheIndexBasedCurrency_CURIN | Currency Key Of The Index Based Currency | |
| CurrencyKeyOfTheHardCurrency_CURHA | Currency Key Of The Hard Currency | |
| CountryCurrency_WAERS | Country Currency | |
| ExchangeRateTypeForTranslationIntoCountryCurrency_KURST | Exchange Rate Type For Translation Into Country Currency | |
| ChartOfDepreciatonForAssetValuation_AFAPL | Chart Of Depreciaton For Asset Valuation | |
| MaximumLowValueAssetAmount_GWGWRT | Maximum Low Value Asset Amount | |
| NetBookValueForChangeoverOfDepreciationMethod_UMRWRT | Net Book Value For Changeover Of Depreciation Method | |
| IndicatorPostNetBookValueForRetirement_KZRBWB | Indicator Post Net Book Value For Retirement | |
| IndicatorTransferDownPaymentsFromPreviousYears_XANZUM | Indicator Transfer Down Payments From Previous Years | |
| WithholdingTaxCertificateNumbering_Concepts_CTNCONCEPT | Withholding Tax Certificate Numbering (Concepts) | |
| TaxesAtIndividualServiceLevel_KZSRV | Taxes At Individual Service Level | |
| Indicator_DisplayCapitalGoodsIndicator_XXINVE | Indicator Display Capital Goods Indicator | |
| SuperRegionPerCountry_SUREG | Super Region Per Country |