P_RelStratCharValues

DDL: P_RELSTRATCHARVALUES SQL: PCHARVALUES Type: view COMPOSITE Package: VDM_MM_PUR_REL_STRAT

Classification for Release Strategy

P_RelStratCharValues is a Composite CDS View that provides data about "Classification for Release Strategy" in SAP S/4HANA. It reads from 1 data source (I_ClfnObjectCharcValForKeyDate) and exposes 9 fields with key fields ReleaseGroup, PurchasingReleaseStrategy, CharacteristicInternalID, ReleaseInternalCounter. Part of development package VDM_MM_PUR_REL_STRAT.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_ClfnObjectCharcValForKeyDate I_ClfnObjectCharcValForKeyDate from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PCHARVALUES view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ReleaseGroup
KEY PurchasingReleaseStrategy
KEY CharacteristicInternalID CharcInternalID
KEY ReleaseInternalCounter CharcValuePositionNumber
CharacteristicValueInternalID
ObjectID
ClassObjIndicator ClfnObjectType
ClassType ClassType
CharacteristicValue CharcValue 
@AbapCatalog.sqlViewName: 'PCHARVALUES'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
//@EndUserText.label: 'Classification for Release Strategy'

@VDM.viewType: #COMPOSITE
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_RelStratCharValues as select from I_ClfnObjectCharcValForKeyDate( P_KeyDate: $session.system_date )
{
  key    substring(ClfnObjectID, 1, 2)          as ReleaseGroup,
  key    substring(ClfnObjectID, 3, 2)          as PurchasingReleaseStrategy,
  key    CharcInternalID                        as CharacteristicInternalID,
  key    CharcValuePositionNumber               as ReleaseInternalCounter,
         cast('0000' as adzhl) as CharacteristicValueInternalID,

         cast(ClfnObjectID as abap.char( 4 ))   as ObjectID,

         ClfnObjectType                         as ClassObjIndicator,
         ClassType                              as ClassType,
         CharcValue                             as CharacteristicValue
}
where
  ClassType = '032' //ClassType 032 indicates Release Strategy

Learn More