P_AllocationSegmentStatusText

DDL: P_ALLOCATIONSEGMENTSTATUSTEXT SQL: PALOSESTTE Type: view CONSUMPTION

P_AllocationSegmentStatusText is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_AllocationStatus) and exposes 2 fields with key field AllocationStatus.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
I_AllocationStatus I_AllocationStatus from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PALOSESTTE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY AllocationStatus AllocationStatus
_Text _Text 
@AbapCatalog.sqlViewName: 'PALOSESTTE'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M

@VDM.viewType: #CONSUMPTION

@VDM.private: true
define view P_AllocationSegmentStatusText as 
select from I_AllocationStatus 
{
  //I_AllocationStatus 

  key AllocationStatus, 
  key cast(case when AllocationStatus = 'L'
        then 'X' 
        else ' ' end as active preserving type) as AllocationSegmentIsLocked,  
  /* Associations */ 
  //I_AllocationStatus 

      case when AllocationStatus = 'L'
        then 1 //red

        else 3 //green

      end as CriticalityCode,        
  _Text
}
where AllocationStatus = 'L' or AllocationStatus = 'A'

Learn More