R_ChmlCmplncMnlDngrsGdsTP

DDL: R_CHMLCMPLNCMNLDNGRSGDSTP Type: view_entity TRANSACTIONAL Package: EHFND_RAP_CCI_DG
22 Fields 1 Data Sources 1 Associations

Manual Maintenance of DG Data - TP

R_ChmlCmplncMnlDngrsGdsTP is a Transactional CDS View that provides data about "Manual Maintenance of DG Data - TP" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncMnlDngrsGds) and exposes 22 fields with key field ChmlCmplncMnlDngrsGdsUUID. It has 1 association to related views. Part of development package EHFND_RAP_CCI_DG.

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncMnlDngrsGds I_ChmlCmplncMnlDngrsGds from

Associations (1)

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

Annotations (10)

NameValueLevelField
EndUserText.label Manual Maintenance of DG Data - TP view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.sapObjectNodeType.name DangerousGoodsManualData view
ObjectModel.representativeKey ChmlCmplncMnlDngrsGdsUUID view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncMnlDngrsGdsUUID ChmlCmplncMnlDngrsGdsUUID Generic Key
ChmlCmplncInfoUUID ChmlCmplncInfoUUID Chemical Compliance Information PP
ChmlCmplncProdUUID ChmlCmplncProdUUID Product Assignment
ChmlCmplncInfoPckgdProd _DangerousGoodsTexts ChmlCmplncInfoPckgdProd Product
ClassifiedAsDangerousGood ClassifiedAsDangerousGood Classified As
DngrsGoodsModeOfTransport DngrsGoodsModeOfTransport Mode of Transport
TransportPermission TransportPermission Transport Permission
DngrsGoodsPackagingType DngrsGoodsPackagingType Dangerous Goods Packaging Type
DngrsGoodsPackagingSize DngrsGoodsPackagingSize Dangerous Goods Packaging Size
DngrsGoodsPackagingSizeUnit DngrsGoodsPackagingSizeUnit DngrsGds Packaging Size Unit
CmplRqVersUUID CmplRqVersUUID NodeID
ProductIsPackaged ProductIsPackaged Dangerous Goods: Is Packed Product
DngrsGoodsDescription DngrsGoodsDescription Dangerous Goods Description
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
_ChmlCmplncInfo _ChmlCmplncInfo
_TransportPermission _TransportPermission
_CmplRqVers _CmplRqVers
_DangerousGoodsTexts _DangerousGoodsTexts
_Product _DangerousGoodsTexts _Product

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 R_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 R_ChmlCmplncMnlDngrsGdsTP AS
SELECT
  ChmlCmplncMnlDngrsGdsUUID,
  ChmlCmplncInfoUUID,
  ChmlCmplncProdUUID,
  _DangerousGoodsTexts.ChmlCmplncInfoPckgdProd AS ChmlCmplncInfoPckgdProd,
  ClassifiedAsDangerousGood,
  DngrsGoodsModeOfTransport,
  TransportPermission,
  DngrsGoodsPackagingType,
  DngrsGoodsPackagingSize,
  DngrsGoodsPackagingSizeUnit,
  CmplRqVersUUID,
  ProductIsPackaged,
  DngrsGoodsDescription,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  _DangerousGoodsTexts._Product AS _Product
FROM I_ChmlCmplncMnlDngrsGds
LEFT OUTER JOIN I_ChmlCmplncAddlDtaMnlDngrsGds AS _DangerousGoodsTexts ON ChmlCmplncMnlDngrsGdsUUID = _DangerousGoodsTexts.ChmlCmplncMnlDngrsGdsUUID  -- association [1..1]
;

Learn More