C_ChmlCmplncInfoPckgdProdVH

DDL: C_CHMLCMPLNCINFOPCKGDPRODVH Type: view_entity CONSUMPTION Package: EHFND_CNS_CCI
18 Fields 1 Data Sources 2 Associations

Packaged Product Value Help

C_ChmlCmplncInfoPckgdProdVH is a Consumption CDS View that provides data about "Packaged Product Value Help" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncInfoPckgdProdVH) and exposes 18 fields with key field ChmlCmplncInfoUUID. It has 2 associations to related views. Part of development package EHFND_CNS_CCI.

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncInfoPckgdProdVH ChmlCmplncInfoPckgdProd from

Associations (2)

CardinalityTargetAliasCondition
[0..1] R_ChmlCmplncInfoPckgdProdDraft _PckgdProdAssgmtDraft_c _PckgdProdAssgmtDraft_c.PckgdChmlCmplncInfoUUID = ChmlCmplncInfoPckgdProd.ChmlCmplncInfoUUID and _PckgdProdAssgmtDraft_c.DraftEntityOperationCode = 'C'
[0..1] R_ChmlCmplncInfoPckgdProdDraft _PckgdProdAssgmtDraft_d _PckgdProdAssgmtDraft_d.PckgdChmlCmplncInfoUUID = ChmlCmplncInfoPckgdProd.ChmlCmplncInfoUUID and ( _PckgdProdAssgmtDraft_d.DraftEntityOperationCode = 'D' or _PckgdProdAssgmtDraft_d.DraftEntityOperationCode = 'L' )

Annotations (11)

NameValueLevelField
EndUserText.label Packaged Product Value Help view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey ChmlCmplncInfoUUID view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncInfoUUID I_ChmlCmplncInfoPckgdProdVH ChmlCmplncInfoUUID Chemical Compliance Information PP
Specification I_ChmlCmplncInfoPckgdProdVH Specification Compliance View - Packaged
ChmlCmplncInternalName
Material
ProductName
ProdStewardshipRespUnit I_ChmlCmplncInfoPckgdProdVH ProdStewardshipRespUnit Responsible Unit
DngrsGdsRespUnit I_ChmlCmplncInfoPckgdProdVH DngrsGdsRespUnit Responsible Unit for Dangerous Goods
ChmlCmplncInfoType I_ChmlCmplncInfoPckgdProdVH ChmlCmplncInfoType Type of Chemical Compliance Information
MaterialIsSold I_ChmlCmplncInfoPckgdProdVH MaterialIsSold Is Sold
MaterialIsTransported I_ChmlCmplncInfoPckgdProdVH MaterialIsTransported Is Transported
MaterialIsSourced I_ChmlCmplncInfoPckgdProdVH MaterialIsSourced Is Purchased
MaterialIsProduced I_ChmlCmplncInfoPckgdProdVH MaterialIsProduced Is Produced
MaterialIsDisposed I_ChmlCmplncInfoPckgdProdVH MaterialIsDisposed Is Disposed
MaterialIsEmissionRelevant I_ChmlCmplncInfoPckgdProdVH MaterialIsEmissionRelevant Emission Relevant
ChmlCmplncProdIsResearched I_ChmlCmplncInfoPckgdProdVH ChmlCmplncProdIsResearched R&D Sample
MatlIsMultiComponentProduct I_ChmlCmplncInfoPckgdProdVH MatlIsMultiComponentProduct
BrnddChmlCmplncInfoUUID
UnpckgdChmlCmplncInfoUUID

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_ChmlCmplncInfoPckgdProdVH.
-- 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 C_ChmlCmplncInfoPckgdProdVH AS
SELECT
  ChmlCmplncInfoPckgdProd.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  ChmlCmplncInfoPckgdProd.Specification AS Specification,
  ChmlCmplncInfoPckgdProd.ProdStewardshipRespUnit AS ProdStewardshipRespUnit,
  ChmlCmplncInfoPckgdProd.DngrsGdsRespUnit AS DngrsGdsRespUnit,
  ChmlCmplncInfoPckgdProd.ChmlCmplncInfoType AS ChmlCmplncInfoType,
  ChmlCmplncInfoPckgdProd.MaterialIsSold AS MaterialIsSold,
  ChmlCmplncInfoPckgdProd.MaterialIsTransported AS MaterialIsTransported,
  ChmlCmplncInfoPckgdProd.MaterialIsSourced AS MaterialIsSourced,
  ChmlCmplncInfoPckgdProd.MaterialIsProduced AS MaterialIsProduced,
  ChmlCmplncInfoPckgdProd.MaterialIsDisposed AS MaterialIsDisposed,
  ChmlCmplncInfoPckgdProd.MaterialIsEmissionRelevant AS MaterialIsEmissionRelevant,
  ChmlCmplncInfoPckgdProd.ChmlCmplncProdIsResearched AS ChmlCmplncProdIsResearched,
  ChmlCmplncInfoPckgdProd.MatlIsMultiComponentProduct AS MatlIsMultiComponentProduct
FROM I_ChmlCmplncInfoPckgdProdVH AS ChmlCmplncInfoPckgdProd
LEFT OUTER JOIN R_ChmlCmplncInfoPckgdProdDraft AS _PckgdProdAssgmtDraft_c ON _PckgdProdAssgmtDraft_c.PckgdChmlCmplncInfoUUID = ChmlCmplncInfoPckgdProd.ChmlCmplncInfoUUID AND _PckgdProdAssgmtDraft_c.DraftEntityOperationCode = 'C'  -- association [0..1]
LEFT OUTER JOIN R_ChmlCmplncInfoPckgdProdDraft AS _PckgdProdAssgmtDraft_d ON _PckgdProdAssgmtDraft_d.PckgdChmlCmplncInfoUUID = ChmlCmplncInfoPckgdProd.ChmlCmplncInfoUUID AND ( _PckgdProdAssgmtDraft_d.DraftEntityOperationCode = 'D' OR _PckgdProdAssgmtDraft_d.DraftEntityOperationCode = 'L' )  -- association [0..1]
;

Learn More