I_COUNTRY

CDS View

Country/Region

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

Used by 84 CDS view(s) 7 fields

CDS Views using this table (84)

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_CL_StRpSalesLedgerLog view_entity inner CONSUMPTION Chile Sales Ledger Log
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_DaGdsPaInstrnTransptPrmssn view_entity from CONSUMPTION Logs Pack Instr Transport Permission
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_FxdAstCountryOfOriginVH view from CONSUMPTION Fixed Asset Country/Region of Origin Value Help
C_IntTaxJurisdictionCodeVH view_entity inner CONSUMPTION Internal Tax Jurisdiction Code
C_MassUpdtCountryVH view from CONSUMPTION Country Value Help
C_MM_CountryValueHelp view from CONSUMPTION Country/Region Value Help
C_NO_SAFTTax view inner CONSUMPTION SAF-T Norway Tax
C_PaInsnChkRuleTransptPrmssn view_entity from CONSUMPTION DG Check Rule Transport Permission
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_StRpCatCountryVH view from CONSUMPTION Country/Region
C_StRpCountryVH view from CONSUMPTION Country/Region
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_IN_TaxDefConditionType view_entity inner COMPOSITE India Tax condition Type
I_InsuranceClaimCountryLink view_entity from BASIC Insurance Claim Country
I_MKT_Country view from BASIC Marketing: Country/Region
I_MX_BusinessPartner view_entity inner COMPOSITE Provides BP detailed information
I_PL_SAFTInvoiceTaxEUCode view_entity inner COMPOSITE SAF T PL tax EU code
I_PT_SAFTRegIndrctTaxAbroad view_entity inner COMPOSITE SAFT PT RITA Information
I_SAFTVatCode view inner COMPOSITE SAFT Vat Codes
I_ScrtyClCmplmntyIdnCtryReg view_entity from COMPOSITE Identification of Country Region
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
P_AR_ElectronicDplItemsFromSD view inner CONSUMPTION Argentina Electronic Duplicate - Detailed Items from SD
P_AR_SalesFromSDWithZeroVAT view inner CONSUMPTION Argentina Sales Documents from SD with Zero VAT
P_AR_TaxItem view inner CONSUMPTION Private View for Argentina Tax Item
P_CL_PurJournalEntryTaxItem view_entity inner CONSUMPTION Chile Purchase Journal Entry Tax Item
P_CL_SalesJournalEntryTaxItem view_entity inner CONSUMPTION Sales Journal Entry Tax Item
P_CL_StRpJrnlEntryItemWithTax view_entity inner CONSUMPTION Journal Entry With Tax Log for Chilean Reports
P_CnsldtnCountry view from COMPOSITE Consolidation Combined Country/Region
P_GB_ParkedTaxItems view left_outer CONSUMPTION Parked customer/supplier items
P_IN_GSTR3BTaxDefConditionType view_entity inner COMPOSITE India GSTR3B Tax Definition Condition Type
P_IT_VATRegItmCA view inner CONSUMPTION Italy: Value Added Tax Register Item for Contract Accounting
P_NL_SAFTVATCode view inner COMPOSITE NL Audit File VAT Codes
P_PE_PurDmstcSuplrTaxItem view inner CONSUMPTION Peru: Purchase Domestic Supplier Tax Item
P_PE_PurFrgnSuplrEntryAggrgd view inner CONSUMPTION Purchase Ledger Foreign Items Aggregated
P_PE_PurFrgnSuplrTaxItem view_entity inner CONSUMPTION Purchase Ledger Foreign Tax Items
P_PL_SAFTInvoiceTaxEUCode view inner COMPOSITE SAF-T PL get tax EU code
P_PT_CAOpenItemSum view_entity inner COMPOSITE Portugal Contract Accounting Sum of Open Items
P_RO_SAFTCActgStdPartAddrTxNr view_entity left_outer CONSUMPTION Standard Partner Address and Tax Number
P_RO_SAFTCACTGSTDPARTADDRTXNRM view_entity left_outer CONSUMPTION Standard Partner Address and Tax Number
P_RU_TaxCode view inner COMPOSITE Tax Category
P_ScrtyClCmplmntyIdnCtryReg view_entity from COMPOSITE Identification of Country Region
P_ScrtyClCmplmntyIdnCtryReg view_entity union COMPOSITE Identification of Country Region
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 EU Sales tax Item View for Statutory Reporting
P_StRpTaxItmWithEUTaxClass7 view left_outer COMPOSITE EU Sales tax Item View for Statutory Reporting
R_TaxCodesPerCountry view_entity from BASIC Tax Codes per Country
TaxRegisterFOTCountryScope view_entity inner Tax Register FOT Country Scope

Fields (7)

KeyField CDS FieldsUsed in Views
KEY Country Country,DestinationCountry 12
KEY TaxCalculationProcedure TaxCalculationProcedure,TaxJurisdictionCalcProcedure 6
CountryCurrency CountryCurrency 3
CountryISOCode CountryISOCode 1
CountryThreeDigitISOCode CountryThreeDigitISOCode 1
CountryThreeLetterISOCode CountryThreeLetterISOCode 1
IsEuropeanUnionMember IsEuropeanUnionMember 1 
@EndUserText.label: 'Country/Region'
@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@AccessControl.authorizationCheck: #NOT_REQUIRED   // #CHECK

@AbapCatalog.sqlViewName: 'IFICOUNTRY'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@ObjectModel.representativeKey: 'Country'
@ObjectModel.sapObjectNodeType.name: 'Country'
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass:  #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.compositionRoot:true
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE,
                                     #CDS_MODELING_DATA_SOURCE,
                                     #CDS_MODELING_ASSOCIATION_TARGET]
@Search.searchable: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #ACTIVE
@AbapCatalog.buffering.type: #FULL
@AbapCatalog.buffering.numberOfKeyFields: 1
@Metadata.ignorePropagatedAnnotations: true
 
define view I_Country
  as select from t005
  association [0..*] to I_CountryText as _Text on $projection.Country = _Text.Country
{
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @ObjectModel.text.association: '_Text'
  key land1  as Country,
      intca3 as CountryThreeLetterISOCode,
      intcn3 as CountryThreeDigitISOCode,
      intca  as CountryISOCode,
      xegld  as IsEuropeanUnionMember,

      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _Text

}

Learn More