C_CmbndChmlCmplncPckgdProd

DDL: C_CMBNDCHMLCMPLNCPCKGDPROD SQL: CCCIPCKGDPRD Type: view CONSUMPTION Package: EHFND_CNS_CCI_DG
34 Fields 1 Data Sources 1 Associations

Manual Maintenance Packaged Products

C_CmbndChmlCmplncPckgdProd is a Consumption CDS View that provides data about "Manual Maintenance Packaged Products" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncMnlDngrsGdsUnion) and exposes 34 fields with key field ChmlCmplncMnlDngrsGdsUUID. It has 1 association to related views. Part of development package EHFND_CNS_CCI_DG.

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncMnlDngrsGdsUnion I_ChmlCmplncMnlDngrsGdsUnion from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ChmlCmplncAddlDtaMnlDngrsGds _DangerousGoodsTexts $projection.ChmlCmplncMnlDngrsGdsUUID = _DangerousGoodsTexts.ChmlCmplncMnlDngrsGdsUUID

Annotations (12)

NameValueLevelField
EndUserText.label Manual Maintenance Packaged Products view
AbapCatalog.sqlViewName CCCIPCKGDPRD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey ChmlCmplncMnlDngrsGdsUUID view
Metadata.allowExtensions true view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncMnlDngrsGdsUUID ChmlCmplncMnlDngrsGdsUUID Generic Key
ChmlCmplncInfoUUID ChmlCmplncInfoUUID Chemical Compliance Information PP
ChmlCmplncInfoCombinedName
Material
ChmlCmplncInfoPckgdProd _DangerousGoodsTexts ChmlCmplncInfoPckgdProd Product
ChmlCmplncInfoPckgdProdName _DangerousGoodsTexts ChmlCmplncInfoPckgdProdName
CmplRqVersUUID CmplRqVersUUID NodeID
CmplRqVersName _DangerousGoodsTexts CmplRqVersName Compliance Requirement Name
DngrsGoodsModeOfTransport DngrsGoodsModeOfTransport Mode of Transport
DngrsGoodsModeOfTransportName
TransportPermission TransportPermission Transport Permission
TransportPermissionName _DangerousGoodsTexts TransportPermissionName
TransportPermissionCriticality _TransportPermission TransportPermissionCriticality
ClassifiedAsDangerousGood ClassifiedAsDangerousGood Classified As
ClassifiedAsDangerousGoodName _DangerousGoodsTexts ClassifiedAsDangerousGoodName
DngrsGoodsDescription DngrsGoodsDescription Dangerous Goods Description
ProductIsPackaged ProductIsPackaged Dangerous Goods: Is Packed Product
DngrsGoodsPackagingType DngrsGoodsPackagingType Dangerous Goods Packaging Type
DescOfDngrsGdsPckgName _DangerousGoodsTexts DescOfDngrsGdsPckgName
DngrsGoodsPackagingSize DngrsGoodsPackagingSize Dangerous Goods Packaging Size
DngrsGoodsPackagingSizeUnit DngrsGoodsPackagingSizeUnit DngrsGds Packaging Size Unit
HasActiveEntity HasActiveEntity TRUE
DraftEntityOperationCode DraftEntityOperationCode Draft - Operation Code
PCPrptyIsActive
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
CreatedByUserDescription _DangerousGoodsTexts CreatedByUserDescription Description
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangedByUserDescription _DangerousGoodsTexts LastChangedByUserDescription Description
_DangerousGoodsTexts _DangerousGoodsTexts
_Product _DangerousGoodsTexts _Product
_ChmlCmplncInfo _ChmlCmplncInfo
_CmplRqVers _CmplRqVers

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_CmbndChmlCmplncPckgdProd.
-- 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.
-- SQL view name: CCCIPCKGDPRD

CREATE VIEW C_CmbndChmlCmplncPckgdProd AS
SELECT
  ChmlCmplncMnlDngrsGdsUUID,
  ChmlCmplncInfoUUID,
  _DangerousGoodsTexts._MaterialDataPrimary.ChmlCmplncInfoCombinedName AS ChmlCmplncInfoCombinedName,
  _DangerousGoodsTexts._MaterialDataPrimary.Material AS Material,
  _DangerousGoodsTexts.ChmlCmplncInfoPckgdProd AS ChmlCmplncInfoPckgdProd,
  _DangerousGoodsTexts.ChmlCmplncInfoPckgdProdName AS ChmlCmplncInfoPckgdProdName,
  CmplRqVersUUID,
  _DangerousGoodsTexts.CmplRqVersName AS CmplRqVersName,
  DngrsGoodsModeOfTransport,
  _DangerousGoodsTexts._DngrsGoodsModeOfTransportTxt.DngrsGoodsModeOfTransportName AS DngrsGoodsModeOfTransportName,
  TransportPermission,
  _DangerousGoodsTexts.TransportPermissionName AS TransportPermissionName,
  _TransportPermission.TransportPermissionCriticality AS TransportPermissionCriticality,
  ClassifiedAsDangerousGood,
  _DangerousGoodsTexts.ClassifiedAsDangerousGoodName AS ClassifiedAsDangerousGoodName,
  DngrsGoodsDescription,
  ProductIsPackaged,
  DngrsGoodsPackagingType,
  _DangerousGoodsTexts.DescOfDngrsGdsPckgName AS DescOfDngrsGdsPckgName,
  DngrsGoodsPackagingSize,
  DngrsGoodsPackagingSizeUnit,
  HasActiveEntity,
  DraftEntityOperationCode,
  cast(PCPrptyIsActive as boole_d) AS PCPrptyIsActive,
  CreationDateTime,
  CreatedByUser,
  _DangerousGoodsTexts.CreatedByUserDescription AS CreatedByUserDescription,
  LastChangeDateTime,
  LastChangedByUser,
  _DangerousGoodsTexts.LastChangedByUserDescription AS LastChangedByUserDescription,
  _DangerousGoodsTexts._Product AS _Product
FROM I_ChmlCmplncMnlDngrsGdsUnion
LEFT OUTER JOIN I_ChmlCmplncAddlDtaMnlDngrsGds AS _DangerousGoodsTexts ON ChmlCmplncMnlDngrsGdsUUID = _DangerousGoodsTexts.ChmlCmplncMnlDngrsGdsUUID  -- association [1..1]
;

Learn More