I_ProdCmplncMlticmpProdComp

DDL: I_PRODCMPLNCMLTICMPPRODCOMP Type: view_entity COMPOSITE Package: EHFND_API_ODATA_MCP

Multicomponent Product Component

I_ProdCmplncMlticmpProdComp is a Composite CDS View that provides data about "Multicomponent Product Component" in SAP S/4HANA. It reads from 1 data source (I_MatlBasedCmpstnComponent) and exposes 11 fields with key field ChmlCompUUID. It has 1 association to related views. Part of development package EHFND_API_ODATA_MCP.

Data Sources (1)

SourceAliasJoin Type
I_MatlBasedCmpstnComponent Component from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ProdCmplncMlticmpProdCmpstn _MultiComponentComposition _MultiComponentComposition.ChmlCompositionUUID = $projection.ChmlCompositionUUID and _MultiComponentComposition.ChmlCompositionStatus = 'RE'

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Multicomponent Product Component view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #COMPOSITE view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ChmlCompUUID I_MatlBasedCmpstnComponent MatlBsdCompUUID
ChmlCompositionUUID I_MatlBasedCmpstnComponent ChmlCompositionUUID
ChemicalComplianceInfo
ChmlCompQty I_MatlBasedCmpstnComponent ChmlCompQty
ChmlCompQtyAsText I_MatlBasedCmpstnComponent ChmlCompQtyAsText
ChmlCompQtySAPUnit
ChmlCompQtyISOUnit
ChmlCmplncInfoUUID I_MatlBasedCmpstnComponent ChmlCmplncInfoUUID
_ChmlCmplncInfo _ChmlCmplncInfo
_UnitOfMeasure _UnitOfMeasure
_MultiComponentComposition _MultiComponentComposition
@AccessControl.authorizationCheck: #MANDATORY

@EndUserText.label: 'Multicomponent Product Component'

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL }

@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #COMPOSITE

define view entity I_ProdCmplncMlticmpProdComp
  as select from I_MatlBasedCmpstnComponent as Component

  association [0..1] to I_ProdCmplncMlticmpProdCmpstn as _MultiComponentComposition
    on  _MultiComponentComposition.ChmlCompositionUUID   = $projection.ChmlCompositionUUID
    and _MultiComponentComposition.ChmlCompositionStatus = 'RE'

{
  key Component.MatlBsdCompUUID                                                                 as ChmlCompUUID,

      Component.ChmlCompositionUUID,
      cast(_ChmlCmplncInfo.Specification as ehfnd_vdm_cci_internal_nr preserving type)          as ChemicalComplianceInfo,

      @Semantics.quantity.unitOfMeasure: 'ChmlCompQtySAPUnit'
      Component.ChmlCompQty,

      Component.ChmlCompQtyAsText,

      @ObjectModel.foreignKey.association: '_UnitOfMeasure'
      cast(ChmlCompQtyUnit as ehfnd_vdm_component_unit_sap preserving type)                     as ChmlCompQtySAPUnit,

      cast(_UnitOfMeasure.UnitOfMeasureISOCode as ehfnd_vdm_component_unit_iso preserving type) as ChmlCompQtyISOUnit,

      @Consumption.hidden: true
      Component.ChmlCmplncInfoUUID,

      /* Associations */
      @Consumption.hidden: true
      _ChmlCmplncInfo,

      _UnitOfMeasure,
      _MultiComponentComposition
}