C_ChmlCmplncMktTP

DDL: C_CHMLCMPLNCMKTTP Type: view CONSUMPTION
31 Fields 1 Data Sources 6 Associations

Marketability of Unpackaged Product

C_ChmlCmplncMktTP is a Consumption CDS View that provides data about "Marketability of Unpackaged Product" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncInfoTP) and exposes 31 fields with key field ChmlCmplncInfoUUID. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncInfoTP _ComplianceInfo from

Associations (6)

CardinalityTargetAliasCondition
[0..*] C_ChmlCmplncMktCvrgTP _MarketCoverage _MarketCoverage.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID -- Additional Information -- Material Data for Primary Material
[0..1] C_ChmlCmplncPrimMatl _MaterialDataPrimary _MaterialDataPrimary.ChmlCmplncInfoUUID = $projection.ActiveChmlCmplncInfoUUID -- Specific Marketability
[0..*] C_ChmlCmplncMktSpcfcCvrg _SpecificCoverage _SpecificCoverage.ChmlCmplncProdUUID = $projection.ActiveChmlCmplncInfoUUID -- Packaged Products
[0..*] C_ChmlCmplncMktProdAssgmt _PackagedProducts _PackagedProducts.ChmlCmplncProdUUID = $projection.ActiveChmlCmplncInfoUUID -- Marketability related Key Figures
[0..1] I_ChmlCmplncMktKeyFig _MarketKeyFig _MarketKeyFig.ChmlCmplncInfoUUID = $projection.ActiveChmlCmplncInfoUUID
[0..1] C_ChmlCmplncRespUnitDngrsGdsVH _RespDangerousGoodsVH _RespDangerousGoodsVH.ResponsibleUnit = $projection.DngrsGdsRespUnit

Annotations (18)

NameValueLevelField
EndUserText.label Marketability of Unpackaged Product view
AbapCatalog.sqlViewName CCCMKTTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.draftEnabled true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
Search.searchable true view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncInfoUUID ChmlCmplncInfoUUID Chemical Compliance Information PP
ActiveChmlCmplncInfoUUID I_ChmlCmplncInfoTP ActiveChmlCmplncInfoUUID Chemical Compliance Information
CmplRqRsltNavgnLink I_ChmlCmplncInfoTP ActiveChmlCmplncInfoUUID Chemical Compliance Information
MaterialasMaterial
MaterialName _MaterialDataPrimary MaterialName Material Description
ChmlCmplncInfoCombinedName _MaterialDataPrimary ChmlCmplncInfoCombinedName
NmbrOfChmlCmplncReqOpn _MarketKeyFig NmbrOfChmlCmplncReqOpn
NmbrOfChmlCmplncPckgdProducts _MarketKeyFig NmbrOfChmlCmplncPckgdProducts
NmbrOfChmlCmplncReqOpnWithTot _MarketKeyFig NmbrOfChmlCmplncReqOpnWithTot
ChmlCmplncApplication
NmbrOfChmlCmplncMktCountries _MarketKeyFig NmbrOfChmlCmplncMktCountries
NmbrOfChmlCmplncReqProcd _MarketKeyFig NmbrOfChmlCmplncReqProcd
NmbrOfInProcessCmplRqRslts _MarketKeyFig NmbrOfInProcessCmplRqRslts
NmbrOfReleasedCmplRqRslts _MarketKeyFig NmbrOfReleasedCmplRqRslts
NmbrOfCmplRqRslts _MarketKeyFig NmbrOfCmplRqRslts
ReleasedCmplRqRsltsCritlty 0
ReleasedCmplRqRsltsPctName _MarketKeyFig ReleasedCmplRqRsltsPctName
ReleasedCmplRqRsltsPct _MarketKeyFig ReleasedCmplRqRsltsPct
InProcessCmplRqRsltsCritlty 0
InProcessCmplRqRsltsPctName _MarketKeyFig InProcessCmplRqRsltsPctName
InProcessCmplRqRsltsPct _MarketKeyFig InProcessCmplRqRsltsPct
ProdStewardshipRespUnit ProdStewardshipRespUnit Responsible Unit
ResponsibleUnitName
LastChangeUTCDateTime LastChangeUTCDateTime Time Stamp
LastChangedByUser LastChangedByUser User Name
UserDescription _LastChangedByUser UserDescription Full Name
_MarketCoverage _MarketCoverage
_SpecificCoverage _SpecificCoverage
_PackagedProducts _PackagedProducts
_MaterialDataPrimary _MaterialDataPrimary
_RespDangerousGoodsVH _RespDangerousGoodsVH

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_ChmlCmplncMktTP.
-- 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_ChmlCmplncMktTP AS
SELECT
  ChmlCmplncInfoUUID,
  _ComplianceInfo.ActiveChmlCmplncInfoUUID AS ActiveChmlCmplncInfoUUID,
  _ComplianceInfo.ActiveChmlCmplncInfoUUID AS CmplRqRsltNavgnLink,
  _MaterialDataPrimary.MaterialName AS MaterialName,
  _MaterialDataPrimary.ChmlCmplncInfoCombinedName AS ChmlCmplncInfoCombinedName,
  _MarketKeyFig.NmbrOfChmlCmplncReqOpn AS NmbrOfChmlCmplncReqOpn,
  _MarketKeyFig.NmbrOfChmlCmplncPckgdProducts AS NmbrOfChmlCmplncPckgdProducts,
  _MarketKeyFig.NmbrOfChmlCmplncReqOpnWithTot AS NmbrOfChmlCmplncReqOpnWithTot,
  cast( '' as ehpma_application ) AS ChmlCmplncApplication,
  _MarketKeyFig.NmbrOfChmlCmplncMktCountries AS NmbrOfChmlCmplncMktCountries,
  _MarketKeyFig.NmbrOfChmlCmplncReqProcd AS NmbrOfChmlCmplncReqProcd,
  _MarketKeyFig.NmbrOfInProcessCmplRqRslts AS NmbrOfInProcessCmplRqRslts,
  _MarketKeyFig.NmbrOfReleasedCmplRqRslts AS NmbrOfReleasedCmplRqRslts,
  _MarketKeyFig.NmbrOfCmplRqRslts AS NmbrOfCmplRqRslts,
  0 AS ReleasedCmplRqRsltsCritlty,
  _MarketKeyFig.ReleasedCmplRqRsltsPctName AS ReleasedCmplRqRsltsPctName,
  _MarketKeyFig.ReleasedCmplRqRsltsPct AS ReleasedCmplRqRsltsPct,
  0 AS InProcessCmplRqRsltsCritlty,
  _MarketKeyFig.InProcessCmplRqRsltsPctName AS InProcessCmplRqRsltsPctName,
  _MarketKeyFig.InProcessCmplRqRsltsPct AS InProcessCmplRqRsltsPct,
  ProdStewardshipRespUnit,
  _RespUnitForProductStewardship._Text[1: Language = $session.system_language ].ResponsibleUnitName AS ResponsibleUnitName,
  LastChangeUTCDateTime,
  LastChangedByUser,
  _LastChangedByUser.UserDescription AS UserDescription
FROM I_ChmlCmplncInfoTP AS _ComplianceInfo
LEFT OUTER JOIN C_ChmlCmplncMktCvrgTP AS _MarketCoverage ON _MarketCoverage.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN C_ChmlCmplncPrimMatl AS _MaterialDataPrimary ON _MaterialDataPrimary.ChmlCmplncInfoUUID = ActiveChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN C_ChmlCmplncMktSpcfcCvrg AS _SpecificCoverage ON _SpecificCoverage.ChmlCmplncProdUUID = ActiveChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN C_ChmlCmplncMktProdAssgmt AS _PackagedProducts ON _PackagedProducts.ChmlCmplncProdUUID = ActiveChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN I_ChmlCmplncMktKeyFig AS _MarketKeyFig ON _MarketKeyFig.ChmlCmplncInfoUUID = ActiveChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN C_ChmlCmplncRespUnitDngrsGdsVH AS _RespDangerousGoodsVH ON _RespDangerousGoodsVH.ResponsibleUnit = DngrsGdsRespUnit  -- association [0..1]
;

Learn More