C_ChmlCmplncMnlDngrsGdsTP

DDL: C_CHMLCMPLNCMNLDNGRSGDSTP Type: view_entity CONSUMPTION Package: EHFND_CNS_CCI_DG
36 Fields 1 Data Sources 1 Associations 2 OData Services 1 Fiori Apps

Manual Maintenance of DG Data Projection

C_ChmlCmplncMnlDngrsGdsTP is a Consumption CDS View that provides data about "Manual Maintenance of DG Data Projection" in SAP S/4HANA. It reads from 1 data source (R_ChmlCmplncMnlDngrsGdsTP) and exposes 36 fields with key field ChmlCmplncMnlDngrsGdsUUID. It has 1 association to related views. It is exposed through 2 OData services (ASQL_F7337, UI_MANUAL_DG_INFO). It is used in 1 Fiori application: Manage Dangerous Goods Information. Part of development package EHFND_CNS_CCI_DG.

Data Sources (1)

SourceAliasJoin Type
R_ChmlCmplncMnlDngrsGdsTP R_ChmlCmplncMnlDngrsGdsTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_CmbndChmlCmplncMatlAssgmt _MaterialAssignment $projection.ChmlCmplncInfoUUID = _MaterialAssignment.ChmlCmplncInfoUUID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
Metadata.allowExtensions true view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F7337 ASQL_F7337 C2 NOT_RELEASED
UI_MANUAL_DG_INFO UI_MANUAL_DG_INFO V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F7337 Manage Dangerous Goods Information Transactional

Manage Dangerous Goods Information

Business Role: Environmental Manager

With this app, you can classify waste products according to dangerous goods regulations. When you select a material in the Manage Material Data app, you can create dangerous goods assessments for the products assigned to this material and their related packaged products. This app is available when the Product Compliance component is not activated in the system.

Fields (36)

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

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_ChmlCmplncMnlDngrsGdsTP.
-- 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_ChmlCmplncMnlDngrsGdsTP AS
SELECT
  ChmlCmplncMnlDngrsGdsUUID,
  ChmlCmplncInfoUUID,
  _DangerousGoodsTexts._MaterialDataPrimary.ChmlCmplncInfoCombinedName AS ChmlCmplncInfoCombinedName,
  _DangerousGoodsTexts._MaterialDataPrimary.Material AS Material,
  ChmlCmplncProdUUID,
  ChmlCmplncInfoPckgdProd,
  _DangerousGoodsTexts.ChmlCmplncInfoPckgdProdName AS ChmlCmplncInfoPckgdProdName,
  CmplRqVersUUID,
  _DangerousGoodsTexts.CmplRqVersName AS CmplRqVersName,
  DngrsGoodsPackagingType,
  _DangerousGoodsTexts.DescOfDngrsGdsPckgName AS DescOfDngrsGdsPckgName,
  _DangerousGoodsTexts.DescOfDngrsGdsPckgCompleteName AS DescOfDngrsGdsPckgCompleteName,
  DngrsGoodsPackagingSize,
  DngrsGoodsPackagingSizeUnit,
  DngrsGoodsModeOfTransport,
  _DangerousGoodsTexts.DngrsGoodsModeOfTransportName AS DngrsGoodsModeOfTransportName,
  ProductIsPackaged,
  TransportPermission,
  _DangerousGoodsTexts.TransportPermissionName AS TransportPermissionName,
  _TransportPermission.TransportPermissionCriticality AS TransportPermissionCriticality,
  ClassifiedAsDangerousGood,
  _DangerousGoodsTexts.ClassifiedAsDangerousGoodName AS ClassifiedAsDangerousGoodName,
  DngrsGoodsDescription,
  CreationDateTime,
  CreatedByUser,
  _DangerousGoodsTexts.CreatedByUserDescription AS CreatedByUserDescription,
  LastChangeDateTime,
  LastChangedByUser,
  _DangerousGoodsTexts.LastChangedByUserDescription AS LastChangedByUserDescription,
  virtual UICT_HasAProduct : ehfnd_boolean AS virtualUICT_HasAProductehfnd_boolean,
  virtual UICT_HasNotAProduct : ehfnd_boolean AS virtualUICT_HasNotAProductehfnd_boolean
FROM R_ChmlCmplncMnlDngrsGdsTP
LEFT OUTER JOIN C_CmbndChmlCmplncMatlAssgmt AS _MaterialAssignment ON ChmlCmplncInfoUUID = _MaterialAssignment.ChmlCmplncInfoUUID  -- association [0..*]
;

Learn More