I_ChmlCmplncCountry

DDL: I_CHMLCMPLNCCOUNTRY Type: view COMPOSITE Package: EHFND_BO_CCI
10 Fields 1 Data Sources 3 Associations

Countries/Regions of Raw Material

I_ChmlCmplncCountry is a Composite CDS View that provides data about "Countries/Regions of Raw Material" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncMktCvrg) and exposes 10 fields with key field ChmlCmplncMktCvrgUUID. It has 3 associations to related views. Part of development package EHFND_BO_CCI.

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncMktCvrg I_ChmlCmplncMktCvrg from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_ChmlCmplncMktReqTP _ChmlCmplncMktReq _ChmlCmplncMktReq.ChmlCmplncMktReqUUID = $projection.ChmlCmplncMktReqUUID
[1..1] I_Country _Country $projection.Country = _Country.Country
[1..1] I_ChmlCmplncInfo _ChmlCmplncInfo _ChmlCmplncInfo.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID

Annotations (9)

NameValueLevelField
EndUserText.label Countries/Regions of Raw Material view
AbapCatalog.sqlViewName ICCCNTRY view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncMktCvrgUUID ChmlCmplncMktCvrgUUID Marketability Coverage
ChmlCmplncMktReqUUID ChmlCmplncMktReqUUID Marketability Request
ChmlCmplncInfoUUID ChmlCmplncInfoUUID Chemical Compliance Information PP
Country Country Venue: Ctry/Reg
CountryName
ChmlCmplncProdnIsReqd _ChmlCmplncMktReq ChmlCmplncProdnIsReqd Produce In
ChmlCmplncProdnAllwd ChmlCmplncProdnAllwd Produce In
ChmlCmplncSalesIsReqd _ChmlCmplncMktReq ChmlCmplncSalesIsReqd Sell In
ChmlCmplncSalesAllwd ChmlCmplncSalesAllwd Sell In
_ChmlCmplncInfo _ChmlCmplncInfo

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 I_ChmlCmplncCountry.
-- 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.

CREATE VIEW I_ChmlCmplncCountry AS
SELECT
  ChmlCmplncMktCvrgUUID,
  ChmlCmplncMktReqUUID,
  ChmlCmplncInfoUUID,
  Country,
  _Country._Text[1: Language = $session.system_language ].CountryName AS CountryName,
  _ChmlCmplncMktReq.ChmlCmplncProdnIsReqd AS ChmlCmplncProdnIsReqd,
  ChmlCmplncProdnAllwd,
  _ChmlCmplncMktReq.ChmlCmplncSalesIsReqd AS ChmlCmplncSalesIsReqd,
  ChmlCmplncSalesAllwd
FROM I_ChmlCmplncMktCvrg
LEFT OUTER JOIN I_ChmlCmplncMktReqTP AS _ChmlCmplncMktReq ON _ChmlCmplncMktReq.ChmlCmplncMktReqUUID = ChmlCmplncMktReqUUID  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [1..1]
LEFT OUTER JOIN I_ChmlCmplncInfo AS _ChmlCmplncInfo ON _ChmlCmplncInfo.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID  -- association [1..1]
;

Learn More