C_AllocationSenderElementTP

DDL: C_ALLOCATIONSENDERELEMENTTP SQL: CALLOCSENELEMENT Type: view CONSUMPTION

Allocation Sender Element

C_AllocationSenderElementTP is a Consumption CDS View that provides data about "Allocation Sender Element" in SAP S/4HANA. It reads from 1 data source (I_AllocationSenderElementTP) and exposes 20 fields with key fields AllocationType, AllocationCycle, AllocationCycleStartDate, AllocationCycleSegment, AllocElementSequenceNumber. It has 2 associations to related views.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
I_AllocationSenderElementTP I_AllocationSenderElementTP from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_AllocationSegmentTP _Segment $projection.AllocationType = _Segment.AllocationType and $projection.AllocationCycle = _Segment.AllocationCycle and $projection.AllocationCycleStartDate = _Segment.AllocationCycleStartDate and $projection.AllocationCycleSegment = _Segment.AllocationCycleSegment
[1..1] C_AllocationCycleTP _Cycle $projection.AllocationType = _Cycle.AllocationType and $projection.AllocationCycle = _Cycle.AllocationCycle and $projection.AllocationCycleStartDate = _Cycle.AllocationCycleStartDate

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CALLOCSENELEMENT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Allocation Sender Element view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #CONSUMPTION view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY AllocationType AllocationType
KEY AllocationCycle AllocationCycle
KEY AllocationCycleStartDate AllocationCycleStartDate
KEY AllocationCycleSegment AllocationCycleSegment
KEY AllocElementSequenceNumber AllocElementSequenceNumber
AllocationElement1 AllocationElement1
AllocationElement2 AllocationElement2
AllocationElement3 AllocationElement3
AllocationElement4 AllocationElement4
AllocationElement5 AllocationElement5
AllocationElement6 AllocationElement6
AllocationElement7 AllocationElement7
AllocationElement8 AllocationElement8
AllocationElement9 AllocationElement9
AllocationElement10 AllocationElement10
AllocationElementValue AllocationElementValue
AllocationCurrency AllocationCurrency
AllocSenderReceiverVariant AllocSenderReceiverVariant
_Segment _Segment
_Cycle _Cycle 
@AbapCatalog.sqlViewName: 'CALLOCSENELEMENT'
@AbapCatalog.compiler.compareFilter: true

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

@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Allocation Sender Element'

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

@VDM.viewType: #CONSUMPTION

@ObjectModel:
{
  transactionalProcessingDelegated: true,
  //draftEnabled: true,

  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: true
//  entityChangeStateId: 'LastChangeTime'

}
define view C_AllocationSenderElementTP as 
//select from I_AllocationElement

//select from Z2_I_AllocationElementTP

//select from Z_I_AllocationSenderElementTP

select from I_AllocationSenderElementTP
  association [1..1] to C_AllocationSegmentTP      as _Segment                        on  $projection.AllocationType           = _Segment.AllocationType
                                                                                      and $projection.AllocationCycle          = _Segment.AllocationCycle
                                                                                      and $projection.AllocationCycleStartDate = _Segment.AllocationCycleStartDate
                                                                                      and $projection.AllocationCycleSegment   = _Segment.AllocationCycleSegment
                                                                                      
  association [1..1] to C_AllocationCycleTP        as _Cycle                          on  $projection.AllocationType           = _Cycle.AllocationType
                                                                                      and $projection.AllocationCycle          = _Cycle.AllocationCycle
                                                                                      and $projection.AllocationCycleStartDate = _Cycle.AllocationCycleStartDate   
{
  //key DatabaseTable,

  key AllocationType,
  key AllocationCycle,
  key AllocationCycleStartDate,
  key AllocationCycleSegment,
//  AllocSenderReceiverVariant,

  //key AllocSenderReceiverVariant,

  key AllocElementSequenceNumber,
  AllocationElement1,
  AllocationElement2,
  AllocationElement3,
  AllocationElement4,
  AllocationElement5,
  AllocationElement6,
  AllocationElement7,
  AllocationElement8,
  AllocationElement9,
  AllocationElement10,
  //@Semantics.amount.currencyCode: 'AllocationCurrency'

  AllocationElementValue,
  //@Semantics.currencyCode: true  

  AllocationCurrency,
  AllocSenderReceiverVariant,
  @ObjectModel.association.type: #TO_COMPOSITION_PARENT
  _Segment,
  @ObjectModel.association.type: #TO_COMPOSITION_ROOT
  _Cycle
}
where AllocSenderReceiverVariant = 'S'

Learn More