C_AllocRcvrTracingKeyFieldTP

DDL: C_ALLOCRCVRTRACINGKEYFIELDTP SQL: CALLOCRECVALFLD Type: view CONSUMPTION Package: ODATA_MANAGE_ALLOCATION

Allocation Receiver Tracing Key Field

C_AllocRcvrTracingKeyFieldTP is a Consumption CDS View that provides data about "Allocation Receiver Tracing Key Field" in SAP S/4HANA. It reads from 1 data source (I_AllocRcvrTracingKeyFieldTP) and exposes 18 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_AllocRcvrTracingKeyFieldTP I_AllocRcvrTracingKeyFieldTP from

Associations (3)

CardinalityTargetAliasCondition
[0..*] C_AllocRcvrTracingRefKeyFldTP _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 CALLOCRECVALFLD 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 Tracing Key Field view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view

Fields (18)

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
AllocIsReferenceBaseFilled
_RcvrRefKeyFld _RcvrRefKeyFld
_Segment _Segment
_Cycle _Cycle
@AbapCatalog.sqlViewName: 'CALLOCRECVALFLD'
@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 Tracing Key Field'

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

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

}
define view C_AllocRcvrTracingKeyFieldTP
  as
  //select from P_AllocationKeyField

  //select from Z_I_AllocRcvrTracingKeyFieldTP

  select from I_AllocRcvrTracingKeyFieldTP
  association [0..*] to C_AllocRcvrTracingRefKeyFldTP 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: { 
        readOnly: true,
        virtualElement,
        virtualElementCalculatedBy: 'ABAP:CL_FCO_ALLOC_KEY_CDS_EXIT'
      }
      cast( '' as boolean ) as AllocIsReferenceBaseFilled,

      @ObjectModel.association.type: #TO_COMPOSITION_CHILD
      _RcvrRefKeyFld,
      @ObjectModel.association.type: #TO_COMPOSITION_PARENT
      _Segment,
      @ObjectModel.association.type: #TO_COMPOSITION_ROOT
      _Cycle
}
where
  AllocationSetType = '4'