P_AllocationStatus

DDL: P_ALLOCATIONSTATUS SQL: PALOSTATUS Type: view CONSUMPTION

Allocation Status

P_AllocationStatus is a Consumption CDS View that provides data about "Allocation Status" in SAP S/4HANA. It reads from 2 data sources (I_AllocationCycle, I_AllocationSegment) and exposes 5 fields with key fields AllocationType, AllocationCycle, AllocationCycleStartDate, AllocationSegmentIsLocked.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
I_AllocationCycle Cycle from
I_AllocationSegment Segment inner

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PALOSTATUS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey 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
EndUserText.label Allocation Status view
VDM.private true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY AllocationType I_AllocationCycle AllocationType
KEY AllocationCycle I_AllocationCycle AllocationCycle
KEY AllocationCycleStartDate I_AllocationCycle AllocationCycleStartDate
KEY AllocationSegmentIsLocked I_AllocationSegment AllocationSegmentIsLocked
StatusCount 
@AbapCatalog.sqlViewName: 'PALOSTATUS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: 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

@EndUserText.label: 'Allocation Status'
@VDM.private: true
define view P_AllocationStatus as 
select from I_AllocationCycle as Cycle
inner join I_AllocationSegment as Segment 
 on  Segment.AllocationCycle = Cycle.AllocationCycle 
 and Segment.AllocationType = Cycle.AllocationType
 and Segment.AllocationCycleStartDate = Cycle.AllocationCycleStartDate
{
    //key Cycle.DatabaseTable,

    key Cycle.AllocationType,
    key Cycle.AllocationCycle,
    key Cycle.AllocationCycleStartDate,    
    key Segment.AllocationSegmentIsLocked,
        count( * ) as StatusCount  
}
group by Cycle.AllocationType, Cycle.AllocationCycle, Cycle.AllocationCycleStartDate, AllocationSegmentIsLocked

Learn More