C_AllocationReceiverKeyFieldTP

DDL: C_ALLOCATIONRECEIVERKEYFIELDTP SQL: CALLOCRCVRFIELD Type: view CONSUMPTION Package: ODATA_MANAGE_ALLOCATION

Allocation Receiver Key Field

C_AllocationReceiverKeyFieldTP is a Consumption CDS View that provides data about "Allocation Receiver Key Field" in SAP S/4HANA. It reads from 1 data source (I_AllocReceiverKeyFieldTP) and exposes 17 fields with key fields AllocationType, AllocationCycle, AllocationCycleStartDate, AllocationCycleSegment, AllocDocumentSequenceNumber. It has 3 associations to related views. Part of development package ODATA_MANAGE_ALLOCATION.

Data Sources (1)

SourceAliasJoin Type
I_AllocReceiverKeyFieldTP I_AllocReceiverKeyFieldTP from

Associations (3)

CardinalityTargetAliasCondition
[0..*] C_AllocRcvrRefKeyFldTP _RcvrRefKeyFld $projection.AllocationType = _RcvrRefKeyFld.AllocationType and $projection.AllocationCycle = _RcvrRefKeyFld.AllocationCycle and $projection.AllocationCycleStartDate = _RcvrRefKeyFld.AllocationCycleStartDate and $projection.AllocationCycleSegment = _RcvrRefKeyFld.AllocationCycleSegment and $projection.AllocDocumentSequenceNumber = _RcvrRefKeyFld.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 CALLOCRCVRFIELD 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 Receiver Key Field view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view

Fields (17)

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
AllocKeyFieldIsInitial AllocKeyFieldIsInitial
AllocKeyFieldIsAllValues AllocKeyFieldIsAllValues
_RcvrRefKeyFld _RcvrRefKeyFld
_Segment _Segment
_Cycle _Cycle
@AbapCatalog.sqlViewName: 'CALLOCRCVRFIELD'
@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 Receiver Key Field'

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

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

}

define view C_AllocationReceiverKeyFieldTP as 
//select from P_AllocationKeyField

select from I_AllocReceiverKeyFieldTP  
  association [0..*] to C_AllocRcvrRefKeyFldTP  as _RcvrRefKeyFld  on  $projection.AllocationType              = _RcvrRefKeyFld.AllocationType
                                                                   and $projection.AllocationCycle             = _RcvrRefKeyFld.AllocationCycle
                                                                   and $projection.AllocationCycleStartDate    = _RcvrRefKeyFld.AllocationCycleStartDate
                                                                   and $projection.AllocationCycleSegment      = _RcvrRefKeyFld.AllocationCycleSegment
                                                                   and $projection.AllocDocumentSequenceNumber = _RcvrRefKeyFld.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,  
  
  AllocKeyFieldIsInitial,
  AllocKeyFieldIsAllValues,
      
  @ObjectModel.association.type: #TO_COMPOSITION_CHILD
  _RcvrRefKeyFld,
  @ObjectModel.association.type: #TO_COMPOSITION_PARENT
  _Segment,
  @ObjectModel.association.type: #TO_COMPOSITION_ROOT
  _Cycle  
}
where 
  AllocationSetType = '3'