P_ChmlCompositionOverallStatus

DDL: P_CHMLCOMPOSITIONOVERALLSTATUS SQL: PCCMPSTNALLSTS Type: view COMPOSITE

P_ChmlCompositionOverallStatus is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_ChmlCmpstnOverallStsCritlty) and exposes 3 fields with key field ChmlCmplncInfoUUID. It has 2 associations to related views.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
P_ChmlCmpstnOverallStsCritlty OverallStsCritlty from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ChmlCmpstnOverallStatus _StatusText $projection.ChmlCompositionStatus = _StatusText.ChmlCmpstnOverallStatus -- Constants
[1..1] P_ChmlCmplConstants _Constants _Constants.Constant1 = _Constants.Constant1

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PCCMPSTNALLSTS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #B view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncInfoUUID ChmlCmplncInfoUUID
ChmlCompositionStsCriticality ChmlCmpstnTotlStsCriticality
_StatusText _StatusText 
@AbapCatalog.sqlViewName: 'PCCMPSTNALLSTS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #COMPOSITE
@VDM.private: true

@ObjectModel:
{
  resultSet.sizeCategory: #XS,

  --Performance Annotations
  usageType:
  {
    dataClass: #META,
    sizeCategory: #S,
    serviceQuality: #B
  }
}

define view P_ChmlCompositionOverallStatus

  as select from P_ChmlCmpstnOverallStsCritlty as OverallStsCritlty

  -- Status Text
  association [0..1] to I_ChmlCmpstnOverallStatus as _StatusText on $projection.ChmlCompositionStatus = _StatusText.ChmlCmpstnOverallStatus

  -- Constants
  association [1..1] to P_ChmlCmplConstants       as _Constants  on _Constants.Constant1 = _Constants.Constant1

{
  key ChmlCmplncInfoUUID,

      ChmlCmpstnTotlStsCriticality as ChmlCompositionStsCriticality,
      case
           when ChmlCmpstnTotlStsCriticality  = 1
           then _Constants[inner].ConstantMissing

           when ChmlCmpstnTotlStsCriticality  = 2
           then _Constants[inner].ConstantInProgress

           when ChmlCmpstnTotlStsCriticality  = 3
           then _Constants[inner].ConstantReleased
         end                       as ChmlCompositionStatus,

      _StatusText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_CHMLCMPLCONSTANTS",
"P_CHMLCMPSTNOVERALLSTSCRITLTY"
],
"ASSOCIATED":
[
"I_CHMLCMPSTNOVERALLSTATUS",
"P_CHMLCMPLCONSTANTS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More