P_AllocationSegmentStatusText

DDL: P_ALLOCATIONSEGMENTSTATUSTEXT SQL: PALOSESTTE Type: view CONSUMPTION Package: ODATA_MANAGE_ALLOCATION

Allocation Segment Stattus Text

P_AllocationSegmentStatusText is a Consumption CDS View that provides data about "Allocation Segment Stattus Text" in SAP S/4HANA. It reads from 1 data source (I_AllocationStatus) and exposes 2 fields with key field AllocationStatus. Part of development package ODATA_MANAGE_ALLOCATION.

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

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

        else 3 //green

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

Learn More