C_CmplRqValidityAreaVH

DDL: C_CMPLRQVALIDITYAREAVH SQL: CCMPLRQVALAREAVH Type: view CONSUMPTION
15 Fields 2 Data Sources 1 OData Services 1 Fiori Apps

Compliance Req Validity Area Value Help

C_CmplRqValidityAreaVH is a Consumption CDS View that provides data about "Compliance Req Validity Area Value Help" in SAP S/4HANA. It reads from 2 data sources (I_Region, I_Region) and exposes 15 fields with key fields Country, Region, CmplRqValidityArea, Region, CmplRqValidityArea. It is exposed through 1 OData service (UI_MANUAL_DG_INFO). It is used in 1 Fiori application: Manage Dangerous Goods Information.

Data Sources (2)

SourceAliasJoin Type
I_Region Region from
I_Region Region union

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CCMPLRQVALAREAVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Compliance Req Validity Area Value Help view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #META view
ObjectModel.dataCategory #VALUE_HELP view

OData Services (1)

ServiceBindingVersionContractRelease
UI_MANUAL_DG_INFO UI_MANUAL_DG_INFO V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F7337 Manage Dangerous Goods Information Transactional

Manage Dangerous Goods Information

Business Role: Environmental Manager

With this app, you can classify waste products according to dangerous goods regulations. When you select a material in the Manage Material Data app, you can create dangerous goods assessments for the products assigned to this material and their related packaged products. This app is available when the Product Compliance component is not activated in the system.

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY Country I_Region Country Venue: Ctry/Reg
KEY Region I_Region Region Venue Region
KEY CmplRqValidityArea Validity Area
CountryName Country/Region
RegionName Region
CountryasCountry Validity Area Description
KEY Region Venue Region
KEY CmplRqValidityArea I_Region Country Validity Area
CountryName Country/Region
RegionName Region
KEY Region Venue Region
KEY CmplRqValidityArea Validity Area
CountryName Country/Region
RegionName Region
CmplRqValidityAreaText Validity Area Description

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_CmplRqValidityAreaVH.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CCMPLRQVALAREAVH

CREATE VIEW C_CmplRqValidityAreaVH AS
SELECT
  Region.Country AS Country,
  Region.Region AS Region,
  CONCAT(Region.Country, CONCAT('/' , Region.Region)) AS CmplRqValidityArea,
  Region._Country._Text[1: Language = $session.system_language ].CountryName AS CountryName,
  Region._RegionText[1: Language = $session.system_language ].RegionName AS RegionName,
  cast('' as abap.char(80)) as CmplRqValidityAreaText AS CountryasCountry,
  cast('' as abap.char(80)) AS CmplRqValidityAreaText
FROM I_Region AS Region
-- UNION with additional select branch(es): I_Region
;

Learn More