P_SubstBsdCmpstnReleasedComp

DDL: P_SUBSTBSDCMPSTNRELEASEDCOMP Type: view CONSUMPTION

Substances of Released Material or substance Composition

P_SubstBsdCmpstnReleasedComp is a Consumption CDS View that provides data about "Substances of Released Material or substance Composition" in SAP S/4HANA. It reads from 1 data source (I_SubstBsdCmpstnComponent) and exposes 17 fields with key field ChmlCompUUID.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_SubstBsdCmpstnComponent I_SubstBsdCmpstnComponent from

Annotations (8)

NameValueLevelField
EndUserText.label Substances of Released Material or substance Composition view
AbapCatalog.sqlViewName PSRELCOMPONENT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY ChmlCompUUID ChmlCompUUID
ChmlCmplncInfoUUID ChmlCmplncInfoUUID
ChmlCompositionUUID ChmlCompositionUUID
SubstanceUUID SubstanceUUID
ChmlCompReldType ChmlCompType
ChmlCompReldQty ChmlCompQty
ChmlCompReldQtyAsText ChmlCompQtyAsText
ChmlCompReldQtyUnit ChmlCompQtyUnit
ChmlCompReldLowrLimitQtyOptr ChmlCompOperatorLowerLimit
ChmlCompReldLowerLimitQty ChmlCompQtyLowerLimit
ChmlCompReldLowrLimitQtyAsText ChmlCompQtyLowerLimitAsText
ChmlCompReldUprLimitQtyOptr ChmlCompOperatorUpperLimit
ChmlCompReldUpperLimitQty ChmlCompQtyUpperLimit
ChmlCompReldUprLimitQtyAsText ChmlCompQtyUpperLimitAsText
ChmlCompositionStatus _Composition ChmlCompositionStatus
ChmlCompositionType _Composition ChmlCompositionType
_ChmlCmplncInfo _ChmlCmplncInfo 
@EndUserText.label: 'Substances of Released Material or substance Composition'
@AbapCatalog:
{
  -- SQL view name (16 characters)
  sqlViewName: 'PSRELCOMPONENT',

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

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

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

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

define view P_SubstBsdCmpstnReleasedComp
  as select from I_SubstBsdCmpstnComponent
{

  key ChmlCompUUID,

      ChmlCmplncInfoUUID,
      ChmlCompositionUUID,
      SubstanceUUID,

      ChmlCompType                as ChmlCompReldType,
      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,

      _Composition.ChmlCompositionStatus,
      _Composition.ChmlCompositionType,

      _ChmlCmplncInfo
}
where
  _Composition.ChmlCompositionStatus = 'RE'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHMLCOMPOSITION",
"I_SUBSTBSDCMPSTNCOMPONENT"
],
"ASSOCIATED":
[
"I_CHMLCMPLNCINFO"
],
"BASE":
[
"I_SUBSTBSDCMPSTNCOMPONENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More