I_REGION

CDS View

Region

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

CDS Views using this table (26)

ViewTypeJoinVDMDescription
/PF1/C_VH_REGION view from Priority
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_FrcElmntOrgAddrRegionVH view from CONSUMPTION Value help consumption view for Address Country/Region
C_GHORegionVH view from CONSUMPTION Region
C_MassUpdtRegionVH view from CONSUMPTION Region Value Help
C_MKT_RegionTextVH view_entity 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)
CIC_COUNTRY_SUBDIV view_entity from CIC Projection of Entity Country Subdivision Code
cuan_region_search view_entity from Region Search
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_HK_HCMSTATEOFBIRTHVH view_entity from BASIC Hongkong Family Member State Of Birth VH
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 4
KEY Region Region 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.

-- Region
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_REGION (
    COUNTRY,
    REGION,
    PRIMARY KEY (COUNTRY, REGION)
);