P_MatlBasedCmpstnReleasedComp

DDL: P_MATLBASEDCMPSTNRELEASEDCOMP Type: view CONSUMPTION Package: EHFND_BO_CMPS_MATLBASED

Material Components of Released Material Based composition

P_MatlBasedCmpstnReleasedComp is a Consumption CDS View that provides data about "Material Components of Released Material Based composition" in SAP S/4HANA. It reads from 1 data source (I_MatlBasedCmpstnComponent) and exposes 17 fields with key field MatlBsdCompUUID. Part of development package EHFND_BO_CMPS_MATLBASED.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_MatlBasedCmpstnComponent I_MatlBasedCmpstnComponent from

Annotations (7)

NameValueLevelField
EndUserText.label Material Components of Released Material Based composition view
AbapCatalog.sqlViewName PMRELCOMPONENT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY MatlBsdCompUUID MatlBsdCompUUID
ChmlCmplncInfoUUID ChmlCmplncInfoUUID
ChmlCompositionUUID ChmlCompositionUUID
CompChmlCmplncInfoUUID CompChmlCmplncInfoUUID
ChmlCompReldQty ChmlCompQty
ChmlCompReldQtyAsText ChmlCompQtyAsText
ChmlCompReldQtyUnit ChmlCompQtyUnit
ChmlCompReldLowrLimitQtyOptr ChmlCompOperatorLowerLimit
ChmlCompReldLowerLimitQty ChmlCompQtyLowerLimit
ChmlCompReldLowrLimitQtyAsText ChmlCompQtyLowerLimitAsText
ChmlCompReldUprLimitQtyOptr ChmlCompOperatorUpperLimit
ChmlCompReldUpperLimitQty ChmlCompQtyUpperLimit
ChmlCompReldUprLimitQtyAsText ChmlCompQtyUpperLimitAsText
ChmlCompIsRemoved ChmlCompIsRemoved
MatlBsdCompProductionType MatlBsdCompProductionType
ChmlCompositionStatus _Composition ChmlCompositionStatus
_ChmlCmplncInfo _ChmlCmplncInfo 
// ----------------------------------------------------

//  Material Based Compositon - Released components

// ----------------------------------------------------


@EndUserText.label: 'Material Components of Released Material Based composition'
@AbapCatalog:
{
  -- SQL view name (16 characters)
  sqlViewName: 'PMRELCOMPONENT',

  --If it's true, the filter conditions are compared and, if they match, the associated join expression is evaluated only once
  compiler.compareFilter: true
}

--Access Control: Authorizations Checks
@AccessControl:
{
  authorizationCheck: #NOT_REQUIRED
}

--Client Handling of the view
@ClientHandling.algorithm: #SESSION_VARIABLE

--VDM view type
@VDM.viewType: #CONSUMPTION
@VDM.private: true

define view P_MatlBasedCmpstnReleasedComp
  as select from I_MatlBasedCmpstnComponent
{
  key MatlBsdCompUUID,

      ChmlCmplncInfoUUID,
      ChmlCompositionUUID,
      CompChmlCmplncInfoUUID,

      ChmlCompQty                 as ChmlCompReldQty,
      ChmlCompQtyAsText           as ChmlCompReldQtyAsText,
      ChmlCompQtyUnit             as ChmlCompReldQtyUnit,

      ChmlCompOperatorLowerLimit  as ChmlCompReldLowrLimitQtyOptr,
      ChmlCompQtyLowerLimit       as ChmlCompReldLowerLimitQty,
      ChmlCompQtyLowerLimitAsText as ChmlCompReldLowrLimitQtyAsText,

      ChmlCompOperatorUpperLimit  as ChmlCompReldUprLimitQtyOptr,
      ChmlCompQtyUpperLimit       as ChmlCompReldUpperLimitQty,
      ChmlCompQtyUpperLimitAsText as ChmlCompReldUprLimitQtyAsText,

      ChmlCompIsRemoved,
      MatlBsdCompProductionType,

      _Composition.ChmlCompositionStatus,

      _ChmlCmplncInfo

}
where
  _Composition.ChmlCompositionStatus = 'RE'

Learn More