I_Country

DDL: I_COUNTRY SQL: IFICOUNTRY Type: view BASIC Package: S_ADDRESS_VDM

Country/Region

I_Country is a Basic CDS View (Dimension) that provides data about "Country/Region" in SAP S/4HANA. It reads from 1 data source (t005) and exposes 6 fields with key field Country. It has 1 association to related views. It is exposed through 15 OData services (C_BILLGDOCREDACTED_SD, C_SALESORDERMANAGE_SD, UI_BILLINGDOCUMENT_MANAGE, ...). Part of development package S_ADDRESS_VDM.

1 data source(s) Exposed by 15 service(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
t005 t005 from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_CountryText _Text $projection.Country = _Text.Country

Annotations (21)

NameValueLevelField
EndUserText.label Country/Region view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName IFICOUNTRY view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ObjectModel.representativeKey Country view
ObjectModel.sapObjectNodeType.name Country view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.compositionRoot true view
Search.searchable true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AbapCatalog.buffering.numberOfKeyFields 1 view
Metadata.ignorePropagatedAnnotations true view

OData Services (15)

ServiceBindingVersionContractRelease
C_BILLGDOCREDACTED_SD C_BILLGDOCREDACTED V2 C1 NOT_RELEASED
C_SALESORDERMANAGE_SD C_SALESORDERMANAGE_SRV V4 C1 NOT_RELEASED
UI_BILLINGDOCUMENT_MANAGE UI_BILLINGDOCUMENT_MANAGE V4 C1 NOT_RELEASED
UI_CADOCUMENT_MNG UI_CADOCUMENT_MNG V4 C1 NOT_RELEASED
UI_CREDITMEMOREQUESTMANAGE UI_CREDITMEMOREQUESTMANAGE V4 C1 NOT_RELEASED
UI_CUSTOMERRETURNMANAGE UI_CUSTOMERRETURNMANAGE V4 C1 NOT_RELEASED
UI_DEBITMEMOREQUESTMANAGE UI_DEBITMEMOREQUESTMANAGE V4 C1 NOT_RELEASED
UI_EHS_FND_CRR_OVERVIEW UI_EHS_FND_CRR_OVERVIEW V2 C1 NOT_RELEASED
UI_INTERESTDETAILSDATAMANAGE UI_INTRSTDETAILSDATAMANAGE V2 C1 NOT_RELEASED
UI_PRELIMBILLINGDOCUMENT_F6990 UI_PRELIMBILLINGDOCUMENT_F6990 V4 C1 NOT_RELEASED
UI_SALESCONTRACTMANAGE UI_SALESCONTRACTMANAGE V4 C1 NOT_RELEASED
UI_SALESDOCUMENTMANAGE UI_SALESDOCUMENTMANAGE V4 C1 NOT_RELEASED
UI_SALESQUOTATIONMANAGE UI_SALESQUOTATIONMANAGE V4 C1 NOT_RELEASED
UI_SLSORDERWITHOUTCHARGEMANAGE UI_SLSORDERWITHOUTCHARGEMANAGE V4 C1 NOT_RELEASED
UI_SOURCING_PROJECT_COMPARE UI_SRCGPROJ_COMPARE V2 C1 NOT_RELEASED

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Country land1
CountryThreeLetterISOCode intca3
CountryThreeDigitISOCode intcn3
CountryISOCode intca
IsEuropeanUnionMember xegld
_Text _Text 
@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