C_AllocationSenderKeyFieldTP

DDL: C_ALLOCATIONSENDERKEYFIELDTP SQL: CALLOCSENDFIELD Type: view CONSUMPTION

Allocation Sender Key Field

C_AllocationSenderKeyFieldTP is a Consumption CDS View that provides data about "Allocation Sender Key Field" in SAP S/4HANA. It reads from 1 data source (I_AllocationSenderKeyFieldTP) and exposes 15 fields with key fields AllocationType, AllocationCycle, AllocationCycleStartDate, AllocationCycleSegment, AllocDocumentSequenceNumber. It has 3 associations to related views.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_AllocationSenderKeyFieldTP I_AllocationSenderKeyFieldTP from

Associations (3)

CardinalityTargetAliasCondition
[0..*] C_AllocSndrRefKeyFldTP _SndrRefKeyFld $projection.AllocationType = _SndrRefKeyFld.AllocationType and $projection.AllocationCycle = _SndrRefKeyFld.AllocationCycle and $projection.AllocationCycleStartDate = _SndrRefKeyFld.AllocationCycleStartDate and $projection.AllocationCycleSegment = _SndrRefKeyFld.AllocationCycleSegment and $projection.AllocDocumentSequenceNumber = _SndrRefKeyFld.AllocDocumentSequenceNumber
[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 CALLOCSENDFIELD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK 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
EndUserText.label Allocation Sender Key Field view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY AllocationType AllocationType
KEY AllocationCycle AllocationCycle
KEY AllocationCycleStartDate AllocationCycleStartDate
KEY AllocationCycleSegment AllocationCycleSegment
KEY AllocDocumentSequenceNumber AllocDocumentSequenceNumber
AllocationFieldName AllocationFieldName
AllocationSetName AllocationSetName
AllocationFieldMinimumValue AllocationFieldMinimumValue
AllocationFieldMaximumValue AllocationFieldMaximumValue
AllocationSetId AllocationSetId
AllocationFieldText AllocationFieldText
AllocationSetType AllocationSetType
_SndrRefKeyFld _SndrRefKeyFld
_Segment _Segment
_Cycle _Cycle 
@AbapCatalog.sqlViewName: 'CALLOCSENDFIELD'
@AbapCatalog.compiler.compareFilter: true

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

@ClientHandling.algorithm: #SESSION_VARIABLE

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

@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'Allocation Sender Key Field'

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

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

}

define view C_AllocationSenderKeyFieldTP as 
//select from P_AllocationKeyField

//select from Z_I_AllocationSenderKeyFieldTP

select from I_AllocationSenderKeyFieldTP 
  association [0..*] to C_AllocSndrRefKeyFldTP  as _SndrRefKeyFld  on  $projection.AllocationType              = _SndrRefKeyFld.AllocationType
                                                                   and $projection.AllocationCycle             = _SndrRefKeyFld.AllocationCycle
                                                                   and $projection.AllocationCycleStartDate    = _SndrRefKeyFld.AllocationCycleStartDate
                                                                   and $projection.AllocationCycleSegment      = _SndrRefKeyFld.AllocationCycleSegment
                                                                   and $projection.AllocDocumentSequenceNumber = _SndrRefKeyFld.AllocDocumentSequenceNumber

  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,
//  key AllocationSetType,

  key AllocDocumentSequenceNumber,
  AllocationFieldName, 
  AllocationSetName,
  AllocationFieldMinimumValue, 
  AllocationFieldMaximumValue, 
  AllocationSetId,
  AllocationFieldText,
  AllocationSetType,
  @ObjectModel.association.type: #TO_COMPOSITION_CHILD
  _SndrRefKeyFld,
  @ObjectModel.association.type: #TO_COMPOSITION_PARENT
  _Segment,
  @ObjectModel.association.type: #TO_COMPOSITION_ROOT
  _Cycle
}
where 
  AllocationSetType = '2'

Learn More