R_DngrsGdsMultiComponentProdTP

DDL: R_DNGRSGDSMULTICOMPONENTPRODTP Type: view_entity TRANSACTIONAL Package: EHDGM_RAP_MCP

DngrsGds Multi Component Product - TP

R_DngrsGdsMultiComponentProdTP is a Transactional CDS View that provides data about "DngrsGds Multi Component Product - TP" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncInfo) and exposes 24 fields with key field ChmlCmplncInfoUUID. It has 3 associations to related views. Part of development package EHDGM_RAP_MCP.

1 data source(s) 24 fields

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncInfo ChemicalComplianceInfo from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_Product _Product $projection.Product = _Product.Product
[0..*] R_DaGdsMlticmpProdHazardNoteTP _HazardNote
[0..*] R_DaGdsMlticmpClassfctnTP _Classification

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label DngrsGds Multi Component Product - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name DngrsGdsMulticomponentProduct view
ObjectModel.representativeKey ChmlCmplncInfoUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncInfoUUID I_ChmlCmplncInfo ChmlCmplncInfoUUID
CreationUTCDateTime I_ChmlCmplncInfo CreationUTCDateTime
CreatedByUser I_ChmlCmplncInfo CreatedByUser
LastChangeUTCDateTime I_ChmlCmplncInfo LastChangeUTCDateTime
LastChangedByUser I_ChmlCmplncInfo LastChangedByUser
_CreatedByUser I_ChmlCmplncInfo _CreatedByUser
_LastChangedByUser I_ChmlCmplncInfo _LastChangedByUser
DngrsGdsRespUnit I_ChmlCmplncInfo DngrsGdsRespUnit
ChmlCmplncInternalName I_ChmlCmplncInfo ChmlCmplncInternalName
ChemicalComplianceInfo
Product
RawMaterial
ChmlCmplncInfoType I_ChmlCmplncInfo ChmlCmplncInfoType
ChmlCmplncProdIsResearched I_ChmlCmplncInfo ChmlCmplncProdIsResearched
MaterialIsSold I_ChmlCmplncInfo MaterialIsSold
MaterialIsTransported I_ChmlCmplncInfo MaterialIsTransported
MaterialIsSourced I_ChmlCmplncInfo MaterialIsSourced
MaterialIsProduced I_ChmlCmplncInfo MaterialIsProduced
MatlIsMultiComponentProduct I_ChmlCmplncInfo MatlIsMultiComponentProduct
_Product _Product
_EnclosureDetails _EnclosureDetails
_Component _Component
_HazardNote _HazardNote
_Classification _Classification 
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.privilegedAssociations: [ '_CreatedByUser', '_LastChangedByUser' ]

@EndUserText.label: 'DngrsGds Multi Component Product - TP'

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel: {
  sapObjectNodeType.name: 'DngrsGdsMulticomponentProduct',
  representativeKey: 'ChmlCmplncInfoUUID',
  semanticKey: [ 'ChemicalComplianceInfo' ],
  usageType: {
    serviceQuality: #C,
    sizeCategory: #M,
    dataClass: #MASTER
  }
}

@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL

define root view entity R_DngrsGdsMultiComponentProdTP
  as select from           I_ChmlCmplncInfo       as ChemicalComplianceInfo
    left outer to one join I_ChmlCmplncProdAssgmt as ProductAssignment on  ChemicalComplianceInfo.ChmlCmplncInfoUUID =  ProductAssignment.ChmlCmplncInfoUUID
                                                                       and ProductAssignment.ChmlCmplncInfoType      <> 'BP'

  composition of exact one to one R_DaGdsMlticmpProdEnclrDetsTP as _EnclosureDetails
  composition of exact one to many R_DngrsGdsMlticmpProdCompTP  as _Component
  composition [0..*] of R_DaGdsMlticmpProdHazardNoteTP   as _HazardNote
  composition [0..*] of R_DaGdsMlticmpClassfctnTP               as _Classification

  // related pp product

  association [1..1]       to I_Product                         as _Product on $projection.Product = _Product.Product

{
  key ChemicalComplianceInfo.ChmlCmplncInfoUUID,

      ChemicalComplianceInfo.CreationUTCDateTime,
      ChemicalComplianceInfo.CreatedByUser,
      ChemicalComplianceInfo.LastChangeUTCDateTime,
      ChemicalComplianceInfo.LastChangedByUser,
      /* Associations */
      ChemicalComplianceInfo._CreatedByUser,
      ChemicalComplianceInfo._LastChangedByUser,

      ChemicalComplianceInfo.DngrsGdsRespUnit,
      ChemicalComplianceInfo.ChmlCmplncInternalName,
      // Internal Number

      cast(ChemicalComplianceInfo.Specification as ehfnd_vdm_cci_internal_nr preserving type)                as ChemicalComplianceInfo,
      cast(ChemicalComplianceInfo._PrimaryMaterial.Material as ehfnd_product_in_prod_master preserving type) as Product,
      cast(ChemicalComplianceInfo._PrimaryMaterial.Material as ehfnd_cci_raw_material preserving type)       as RawMaterial,

      ChemicalComplianceInfo.ChmlCmplncInfoType,
      ChemicalComplianceInfo.ChmlCmplncProdIsResearched,
      ChemicalComplianceInfo.MaterialIsSold,
      ChemicalComplianceInfo.MaterialIsTransported,
      ChemicalComplianceInfo.MaterialIsSourced,
      ChemicalComplianceInfo.MaterialIsProduced,
      ChemicalComplianceInfo.MatlIsMultiComponentProduct,

      /* Associations */
      _Product,

      /* Associations - BO */
      _EnclosureDetails,
      _Component,
      _HazardNote,
      _Classification
}

where
      ChemicalComplianceInfo.ChmlCmplncInfoType          = 'PP'
  and ChemicalComplianceInfo.MaterialIsTransported       = 'X'
  and ChemicalComplianceInfo.MatlIsMultiComponentProduct = 'X'

Learn More