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.

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

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)
);