C_ChmlCmplncPckgdProdAssgmtTP

DDL: C_CHMLCMPLNCPCKGDPRODASSGMTTP Type: view_entity CONSUMPTION
13 Fields 1 Data Sources 1 Associations

Packaged Product Assignment - TP

C_ChmlCmplncPckgdProdAssgmtTP is a Consumption CDS View that provides data about "Packaged Product Assignment - TP" in SAP S/4HANA. It reads from 1 data source (R_ChmlCmplncInfoPckgdProdTP) and exposes 13 fields with key field PckgdProductAssgmtUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_ChmlCmplncInfoPckgdProdTP R_ChmlCmplncInfoPckgdProdTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_ChmlCmplncInfoQuickView _ChmlCmplncInfoQuickVw $projection.PckgdChmlCmplncInfoUUID = _ChmlCmplncInfoQuickVw.ChmlCmplncInfoUUID

Annotations (9)

NameValueLevelField
EndUserText.label Packaged Product Assignment - TP view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #CONSUMPTION view
Search.searchable true view
Metadata.allowExtensions true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY PckgdProductAssgmtUUID PckgdProductAssgmtUUID Product Assignment
PckgdChmlCmplncInfoUUID PckgdChmlCmplncInfoUUID Chemical Compliance Information PP
UnpckgdChmlCmplncInfoUUID UnpckgdChmlCmplncInfoUUID Chemical Compliance Information UP
Material _MatAss Material Vehicle Model
MaterialName _MatAss MaterialName Material Description
ChmlCmplncInfoType _ToPackagedProduct ChmlCmplncInfoType Type of Chemical Compliance Information
MaterialIsTransported _ToPackagedProduct MaterialIsTransported Is Transported
MaterialIsSold _ToPackagedProduct MaterialIsSold Is Sold
MaterialIsSourced _ToPackagedProduct MaterialIsSourced Is Purchased
MaterialIsProduced _ToPackagedProduct MaterialIsProduced Is Produced
_MatAss _MatAss
_ChmlCmplncInfoQuickVw _ChmlCmplncInfoQuickVw
_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 C_ChmlCmplncPckgdProdAssgmtTP.
-- 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_ChmlCmplncPckgdProdAssgmtTP AS
SELECT
  PckgdProductAssgmtUUID,
  PckgdChmlCmplncInfoUUID,
  UnpckgdChmlCmplncInfoUUID,
  _MatAss.Material AS Material,
  _MatAss.MaterialName AS MaterialName,
  _ToPackagedProduct.ChmlCmplncInfoType AS ChmlCmplncInfoType,
  _ToPackagedProduct.MaterialIsTransported AS MaterialIsTransported,
  _ToPackagedProduct.MaterialIsSold AS MaterialIsSold,
  _ToPackagedProduct.MaterialIsSourced AS MaterialIsSourced,
  _ToPackagedProduct.MaterialIsProduced AS MaterialIsProduced
FROM R_ChmlCmplncInfoPckgdProdTP
LEFT OUTER JOIN C_ChmlCmplncInfoQuickView AS _ChmlCmplncInfoQuickVw ON PckgdChmlCmplncInfoUUID = _ChmlCmplncInfoQuickVw.ChmlCmplncInfoUUID  -- association [0..1]
;

Learn More