CountriesMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - CountriesMD
Overview
This view provides a comprehensive list of country-specific settings and configurations used in SAP systems. It combines data from the T005 and T005T tables to provide a single source of truth for country-related information.
Data Sources
| Source Table/View | Description |
|---|---|
| T005 | Country-specific settings and configurations |
| T005T | Country-specific texts and translations |
Key Use Cases
- Retrieve country-specific settings for various business processes, such as address formatting, postal code validation, and tax calculations.
- Obtain country-specific texts and translations for user interfaces, reports, and other documents.
- Analyze country-specific data to identify trends, patterns, and potential areas for improvement.
Query Logic
The view combines data from the T005 and T005T tables using an INNER JOIN on the MANDT and LAND1 fields. This ensures that only country-specific settings and texts that match are included in the view.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| OB01 | Maintain Country-Specific Settings |
| OB02 | Maintain Country-Specific Texts |
| OB03 | Maintain Country-Specific Currencies |
| OB04 | Maintain Country-Specific Units of Measure |
| OB05 | Maintain Country-Specific Number Ranges |
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 |