C_ChmlCmplncMktProdAssgmt

DDL: C_CHMLCMPLNCMKTPRODASSGMT Type: view CONSUMPTION
10 Fields 1 Data Sources 3 Associations

Packaged Product Assignment

C_ChmlCmplncMktProdAssgmt is a Consumption CDS View that provides data about "Packaged Product Assignment" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncProdAssgmt) and exposes 10 fields with key field ChmlCmplncProdAssgmtUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncProdAssgmt I_ChmlCmplncProdAssgmt from

Associations (3)

CardinalityTargetAliasCondition
[1..1] C_ChmlCmplncMktTP _ChmlCmplncMktTP _ChmlCmplncMktTP.ChmlCmplncInfoUUID = $projection.ChmlCmplncProdUUID
[1..1] I_ChmlCmplncInfoTP _ChmlCmplncInfoTP _ChmlCmplncInfoTP.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID
[1..1] I_ChmlCmplncMktReq _ChmlCmplncMktReq _ChmlCmplncMktReq.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID

Annotations (14)

NameValueLevelField
EndUserText.label Packaged Product Assignment view
AbapCatalog.sqlViewName CCCMKTPRODASSGMT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
UI.headerInfo.typeName Packaged Products view
UI.headerInfo.typeNamePlural Packaged Products view
UI.headerInfo.title.value ProductName view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncProdAssgmtUUID ChmlCmplncProdAssgmtUUID Product Assignment
ChmlCmplncInfoUUID ChmlCmplncInfoUUID Chemical Compliance Information PP
ChmlCmplncProdUUID ChmlCmplncProdUUID Product Assignment
ActiveChmlCmplncInfoUUID _ChmlCmplncInfoTP ActiveChmlCmplncInfoUUID Chemical Compliance Information
MaterialasMaterial
Applicationnotneededatthemoment
_ChmlCmplncMktTP _ChmlCmplncMktTP
_ChmlCmplncInfoTP _ChmlCmplncInfoTP
_ChmlCmplncInfoProduct _ChmlCmplncInfoProduct
_ChmlCmplncMktReq _ChmlCmplncMktReq

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_ChmlCmplncMktProdAssgmt.
-- 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_ChmlCmplncMktProdAssgmt AS
SELECT
  ChmlCmplncProdAssgmtUUID,
  ChmlCmplncInfoUUID,
  ChmlCmplncProdUUID,
  _ChmlCmplncInfoTP.ActiveChmlCmplncInfoUUID AS ActiveChmlCmplncInfoUUID
FROM I_ChmlCmplncProdAssgmt
LEFT OUTER JOIN C_ChmlCmplncMktTP AS _ChmlCmplncMktTP ON _ChmlCmplncMktTP.ChmlCmplncInfoUUID = ChmlCmplncProdUUID  -- association [1..1]
LEFT OUTER JOIN I_ChmlCmplncInfoTP AS _ChmlCmplncInfoTP ON _ChmlCmplncInfoTP.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID  -- association [1..1]
LEFT OUTER JOIN I_ChmlCmplncMktReq AS _ChmlCmplncMktReq ON _ChmlCmplncMktReq.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID  -- association [1..1]
;

Learn More