P_AllocationCycleNote

DDL: P_ALLOCATIONCYCLENOTE SQL: PALOCYCNOTE Type: view CONSUMPTION

P_AllocationCycleNote is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_AllocationCycleNoteTP) and exposes 4 fields with key fields AllocationType, AllocationCycle, AllocationCycleStartDate.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_AllocationCycleNoteTP I_AllocationCycleNoteTP from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PALOCYCNOTE 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 #B view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY AllocationType AllocationType
KEY AllocationCycle AllocationCycle
KEY AllocationCycleStartDate AllocationCycleStartDate
NoteText 
@AbapCatalog.sqlViewName: 'PALOCYCNOTE'
@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: #B
@ObjectModel.usageType.sizeCategory: #M

@VDM.viewType: #CONSUMPTION
@VDM.private: true
define view P_AllocationCycleNote as 
select from I_AllocationCycleNoteTP 
{
    key AllocationType,
    key AllocationCycle,
    key AllocationCycleStartDate,
    max(NoteText) as NoteText
}
group by AllocationType, AllocationCycle, AllocationCycleStartDate

Learn More