P_PlmrCompositionName

DDL: P_PLMRCOMPOSITIONNAME SQL: PPCMPSNAME Type: view CONSUMPTION

P_PlmrCompositionName is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_ChmlComposition) and exposes 10 fields with key field ChmlCompositionUUID.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_ChmlComposition composition from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PPCMPSNAME view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey ChmlCompositionUUID view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ChmlCompositionUUID ChmlCompositionUUID
SubstanceUUID SubstanceUUID
PolymerCompositionIntID PolymerCompositionIntID
ChmlCompositionStatus ChmlCompositionStatus
ChmlCompositionType ChmlCompositionType
PlmrCmpstnNavgnLinkUUID
PolymerCompositionName
PolymerIsBsdOnOECDDef
_CompositionStatus _CompositionStatus
_CompositionType _CompositionType 
@AbapCatalog.sqlViewName: 'PPCMPSNAME'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

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

@ObjectModel.representativeKey: 'ChmlCompositionUUID'

define view P_PlmrCompositionName
  as select from I_ChmlComposition as composition
{
  key ChmlCompositionUUID,

      SubstanceUUID,

      PolymerCompositionIntID,

      ChmlCompositionStatus,

      ChmlCompositionType,

      @ObjectModel.virtualElement
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EHFND_PLMR_CMPS_EXIT'
      cast( hextobin('00000000000000000000000000000000') as ehfnd_cci_ccmps_uuid ) as PlmrCmpstnNavgnLinkUUID,

      @ObjectModel.virtualElement
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EHFND_PLMR_CMPS_EXIT'
      cast( '' as ehfnd_sub_pcmps_ccmps_name )                                     as PolymerCompositionName,

      @ObjectModel.virtualElement
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EHFND_PLMR_CMPS_EXIT'
      cast( '' as ehfnd_sub_polymer_oecd )                                         as PolymerIsBsdOnOECDDef,

      _CompositionStatus,
      _CompositionType

}
where
      ChmlCompositionStatus = 'RE'
  and ChmlCompositionType   = 'POLYMER'

Learn More