I_REGION

CDS View

Region

I_REGION is a CDS View in S/4HANA. Region. It contains 2 fields. 20 CDS views read from this table.

Used by 20 CDS view(s) 2 fields

CDS Views using this table (20)

ViewTypeJoinVDMDescription
C_BPTaxJurisdictionVHTemp view from CONSUMPTION Tax Jurisdiction
C_CmplRqRegionValueHelp view from CONSUMPTION Compliance Requirement Region Value Help
C_CmplRqValidityAreaVH view from CONSUMPTION Compliance Req Validity Area Value Help
C_CmplRqValidityAreaVH view union CONSUMPTION Compliance Req Validity Area Value Help
C_Cn_RgnVH view from CONSUMPTION Region Value Help
C_CostCenterRegionVH view from CONSUMPTION Region
C_MassUpdtRegionVH view from CONSUMPTION Region Value Help
C_MM_RegionValueHelp view from CONSUMPTION Region Value Help
C_ProfitCenterRegionVH view from CONSUMPTION Region of a Profit Center
C_Purordmaintainregionvalhelp view from CONSUMPTION Region Value Help
C_RegionVHTemp view from CONSUMPTION Region (State, Province, County)
FAC_CDS_UH_REGION view from Region Master Data
I_CA_CountryRegionValueHelp view_entity from BASIC CA Province and Territory of Service
I_EHSRegionVH view from BASIC Region
I_ES_CountryRegionValueHelp view_entity from BASIC ES Province and Territory of Service
I_MKT_Region view from BASIC Marketing: Country/Region
I_REGION_OID view_entity from Wrapper view for Region OID
I_RegionVH view_entity from BASIC Region
I_US_TaxState view from BASIC US External Tax State
I_US_TaxStateVH view from COMPOSITE US External Tax State Value Help

Fields (2)

KeyField CDS FieldsUsed in Views
KEY Country CmplRqValidityArea,Country 3
KEY Region Region 3 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'Region'
@ObjectModel.sapObjectNodeType.name: 'Region'
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE,
                                     #CDS_MODELING_DATA_SOURCE,
                                     #CDS_MODELING_ASSOCIATION_TARGET]
@AbapCatalog.sqlViewName: 'IREGION'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Region'
@Analytics : {dataCategory: #DIMENSION, dataExtraction.enabled : true}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@Search.searchable: true
@Metadata.ignorePropagatedAnnotations:true

define view I_Region
  as select from t005s
  association [0..*] to I_RegionText as _RegionText on  $projection.Region  = _RegionText.Region
                                                    and $projection.Country = _RegionText.Country
  association [1..1] to I_Country    as _Country    on  $projection.Country = _Country.Country
{
      @ObjectModel.foreignKey.association: '_Country'
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
  key t005s.land1 as Country,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      @ObjectModel.text.association: '_RegionText'
  key t005s.bland as Region,

      _RegionText,
      _Country
}

Learn More