I_COUNTRY

CDS View
7 Fields 83 CDS Views

Country/Region

I_COUNTRY is a CDS View in S/4HANA. Country/Region. It contains 7 fields. 83 CDS views read from this table.

CDS Views using this table (83)

ViewTypeJoinVDMDescription
A_Country view from BASIC API Country/Region
C_BadDebtReserveCountryVH view from CONSUMPTION Country/Region
C_BankChainCountryVH view_entity from CONSUMPTION Country/Region for Bank Chains
C_BG_SAFTBusPartEUTaxNumber view_entity from CONSUMPTION BP EU VAT Number for BG SAFT
C_BPIntTaxJurisdictionTmpVH view from CONSUMPTION C view for internal tax jurisdiction
C_ChgMgmtCountryVH view from CONSUMPTION Change Management Country/Region Value Help
C_ChmlCmplncCountryVH view from CONSUMPTION Countries/Regions with Filter
C_ChmlCmplncInfoTransptPrmssn view from CONSUMPTION Chml Cmplnc Info Transport Permission
C_ChmlCmplncMktCountryVH view from CONSUMPTION Country / Region Value Help with Filter
C_ChmlCmplncReqCountryVH view from CONSUMPTION Value Help for Countries/Regions with Filter
C_CmplRqRsltPCNCntrsAllVH view from CONSUMPTION Country and Region for worldwide CRVs
C_CN_CntryKeyVH view from CONSUMPTION Country/Region Value Help
C_Countryvhtemp view from CONSUMPTION Value Help for Country
C_DbtflAcctsValnCountryVH view from CONSUMPTION Country/Region Value Help
C_DngrsGdsApplyRglnCheckRules view from CONSUMPTION Transport Check Rules
C_DngrsGdsChkRuleTransptPrmssn view from CONSUMPTION Dangerous Goods Check Rule Transport Permission
C_EDocMsgCountryValueHelp view_entity from CONSUMPTION Electronic Inbound Msg Country/Region
C_EntProjectTaxJurisdictionVH view left_outer CONSUMPTION Tax Jurisdiction Value Help
C_FldLogsCountryVH view_entity from CONSUMPTION Field Logistics Country
C_FrcElmntOrgAddrCountryVH view from CONSUMPTION Value Help Consumption View for Address Country/Region
C_FxdAstCountryOfOriginVH view from CONSUMPTION Fixed Asset Country/Region of Origin Value Help
C_GHOCountryVH view from CONSUMPTION Country/Region
C_MassUpdtCountryVH view from CONSUMPTION Country Value Help
C_MM_CountryValueHelp view from CONSUMPTION Country/Region Value Help
C_NO_SAFTJournalItemTax view inner CONSUMPTION SAF-T Norway Journal Item Tax
C_NO_SAFTTax view_entity inner CONSUMPTION SAF-T Norway Tax
C_PE_StRpJournalEntryWithTax view inner CONSUMPTION Peru journal entries with tax
C_PE_StRpSalesLedgerCube view inner CONSUMPTION Sales Ledger Peru - Cube
C_PurOrdTaxJurisdictionValHelp view left_outer CONSUMPTION PurOrd Tax Jurisdiction Value Help
C_RevnVarcCntryVH view from CONSUMPTION Value help for Country/Region
C_RO_SAFTBusPartEUTaxNumber view from CONSUMPTION BP EU VAT Number for RO SAFT
C_RO_StRpDomesticSlsPurListC view left_outer CONSUMPTION Romania Domestic Sales and Purchase List - Cube
C_RSHCountry view from CONSUMPTION F4 help for country/region
C_SegmentationCountryVH_F9070 view_entity from CONSUMPTION Country
C_StRpCatCountryVH view from CONSUMPTION Country/Region
C_StRpCountryVH view from CONSUMPTION Country/Region
C_TranspOrdCtryRegVH view from CONSUMPTION Country Region
CIC_COUNTRY_SUBDIV view_entity inner CIC Projection of Entity Country Subdivision Code
CIC_COUNTRYCODE view_entity from CIC Projection on Country Code
cuan_country_search view_entity from Country/Region Search
FAC_COUNTRYVH view from Data Source for Country/Region
FAC_TAXCOUNTRYVH view from Value help for tax country
I_BrexitProtocolValidity view from BASIC Northern Ireland Protocol Validity
I_CnsldtnMasterData view union_all COMPOSITE Consolidation - Combined Master Data
I_COUNTRYCODE_OID view_entity from Wrapper view for Countrycode
I_CountrySrchHelp view from BASIC Suchhilfe für Feld Land
I_CountryVH view from BASIC Country/Region
I_DngrsGdsRlvtRglnBtwnCntrs view cross COMPOSITE DG Regulation relevant between two countries/regions
I_EHSCountriesExclGroups view from BASIC Countries/Regions excluding groups
I_HCM_ESSBankControlKeyVH view_entity from COMPOSITE
I_HCM_ESSBankControlKeyVH view_entity union_all COMPOSITE
I_HK_HCMIssueCountryVH view_entity from BASIC Country for Issue
I_IN_TaxDefConditionType view_entity inner COMPOSITE India Tax condition Type
I_InsuranceClaimCountryLink view_entity from BASIC Insurance Claim Country
I_MX_BusinessPartner view_entity inner COMPOSITE Provides BP detailed information
I_PPS_PurchaseContractTaxCode view_entity inner COMPOSITE Purchase Contract Tax Code values
I_SAFTVatCode view inner COMPOSITE SAFT Vat Codes
I_SG_StRpTaxItemCube view left_outer COMPOSITE Tax Items for Singapore Statutory Reporting
I_SI_CountryCodeValueHelp view_entity union_all BASIC Country International Codes
I_TaxCountryValueHelp view from COMPOSITE Tax Country/Region
I_TimeDependentTaxStatus view from BASIC View to determine is Time dependent Tax is active
I_TW_HCMNationalityVH view_entity from BASIC Nationality
P_AR_ElectronicDplItemsFromSD view inner CONSUMPTION
P_AR_SalesFromSDWithZeroVAT view inner CONSUMPTION
P_AR_TaxItem view inner CONSUMPTION
P_CnsldtnCountry view from COMPOSITE
P_GB_ParkedTaxItems view left_outer CONSUMPTION
P_IN_GSTR3BTaxDefConditionType view_entity inner COMPOSITE
P_IT_VATRegItmCA view inner CONSUMPTION Italy: Value Added Tax Register Item for Contract Accounting
P_NL_SAFTVATCode view inner COMPOSITE
P_PE_PurDmstcSuplrTaxItem view inner CONSUMPTION
P_PE_PurFrgnSuplrEntryAggrgd view inner CONSUMPTION
P_PE_PurFrgnSuplrTaxItem view_entity inner CONSUMPTION
P_PL_SAFTInvoiceTaxEUCode view inner COMPOSITE
P_PT_CAOpenItemSum view_entity inner COMPOSITE
P_RO_SAFTCActgStdPartAddrTxNr view_entity left_outer CONSUMPTION
P_RO_SAFTCACTGSTDPARTADDRTXNRM view_entity left_outer CONSUMPTION
P_RU_TaxCode view inner COMPOSITE
P_SI_NonResidenceSector view_entity from COMPOSITE Slovenian SFR Sector for None residence
P_SlsPurListBPTaxItem20 view left_outer CONSUMPTION Sales Purchase List BP Tax Item (Helper)
P_StRpTaxItmWithEUTaxClass7 view inner COMPOSITE
P_StRpTaxItmWithEUTaxClass7 view left_outer COMPOSITE
TaxRegisterFOTCountryScope view_entity inner Tax Register FOT Country Scope

Fields (7)

KeyField CDS FieldsUsed in Views
KEY Country BankCountry,Country,DestinationCountry 11
CountryCurrency CountryCurrency 4
CountryISOCode CountryISOCode 2
CountryThreeDigitISOCode CountryThreeDigitISOCode 1
CountryThreeLetterISOCode CountryThreeLetterISOCode 1
IsEuropeanUnionMember IsEuropeanUnionMember 1
TaxCalculationProcedure TaxCalculationProcedure,TaxJurisdictionCalcProcedure 4

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Country/Region
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_COUNTRY (
    COUNTRY,
    COUNTRYCURRENCY,
    COUNTRYISOCODE,
    COUNTRYTHREEDIGITISOCODE,
    COUNTRYTHREELETTERISOCODE,
    ISEUROPEANUNIONMEMBER,
    TAXCALCULATIONPROCEDURE,
    PRIMARY KEY (COUNTRY)
);

Learn More