I_AllocReceiverKeyFieldTP

DDL: I_ALLOCRECEIVERKEYFIELDTP SQL: ALORCVRFIELDTP Type: view TRANSACTIONAL

Allocation Receiver Key Field TP

I_AllocReceiverKeyFieldTP is a Transactional CDS View that provides data about "Allocation Receiver Key Field TP" in SAP S/4HANA. It reads from 2 data sources (I_AllocationContextType, I_AllocationKeyField) and exposes 17 fields with key fields AllocationType, AllocationCycle, AllocationCycleStartDate, AllocationCycleSegment, AllocDocumentSequenceNumber. It has 3 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_AllocationContextType Context inner
I_AllocationKeyField I_AllocationKeyField from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_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] I_AllocationSegmentTP _Segment $projection.AllocationType = _Segment.AllocationType and $projection.AllocationCycle = _Segment.AllocationCycle and $projection.AllocationCycleStartDate = _Segment.AllocationCycleStartDate and $projection.AllocationCycleSegment = _Segment.AllocationCycleSegment
[1..1] I_AllocationCycleTP _Cycle $projection.AllocationType = _Cycle.AllocationType and $projection.AllocationCycle = _Cycle.AllocationCycle and $projection.AllocationCycleStartDate = _Cycle.AllocationCycleStartDate

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ALORCVRFIELDTP 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
EndUserText.label Allocation Receiver Key Field TP view
VDM.viewType #TRANSACTIONAL view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.writeDraftPersistence ALORCVRFIELDTPD view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY AllocationType I_AllocationKeyField AllocationType
KEY AllocationCycle AllocationCycle
KEY AllocationCycleStartDate AllocationCycleStartDate
KEY AllocationCycleSegment AllocationCycleSegment
KEY AllocDocumentSequenceNumber AllocDocumentSequenceNumber
AllocationFieldName AllocationFieldName
AllocationSetName AllocationSetName
AllocationFieldMinimumValue AllocationFieldMinimumValue
AllocationFieldMaximumValue AllocationFieldMaximumValue
AllocationSetId AllocationSetId
AllocationSetType AllocationSetType
AllocationFieldText
AllocKeyFieldIsInitial AllocKeyFieldIsInitial
AllocKeyFieldIsAllValues AllocKeyFieldIsAllValues
_RcvrRefKeyFld _RcvrRefKeyFld
_Segment _Segment
_Cycle _Cycle
@AbapCatalog.sqlViewName: 'ALORCVRFIELDTP'
@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

@EndUserText.label: 'Allocation Receiver Key Field TP'
@VDM.viewType: #TRANSACTIONAL
@ObjectModel:
{
  transactionalProcessingEnabled:true,
  writeDraftPersistence: 'ALORCVRFIELDTPD',
  semanticKey: ['AllocationType', 'AllocationCycle', 'AllocationCycleStartDate', 'AllocationCycleSegment', 'AllocDocumentSequenceNumber' ],
  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: true

//  entityChangeStateId: 'LastChangeTime'

}
define view I_AllocReceiverKeyFieldTP
  as select from I_AllocationKeyField
    inner join   I_AllocationContextType as Context on Context.AllocationType = I_AllocationKeyField.AllocationType

  association [0..*] to I_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 I_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 I_AllocationCycleTP    as _Cycle         on  $projection.AllocationType           = _Cycle.AllocationType
                                                                 and $projection.AllocationCycle          = _Cycle.AllocationCycle
                                                                 and $projection.AllocationCycleStartDate = _Cycle.AllocationCycleStartDate
{
  key I_AllocationKeyField.AllocationType,
  key AllocationCycle,
  key AllocationCycleStartDate,
  key AllocationCycleSegment,
  key AllocDocumentSequenceNumber,
      AllocationFieldName,
      AllocationSetName,
      AllocationFieldMinimumValue,
      AllocationFieldMaximumValue,
      AllocationSetId,
      AllocationSetType,
      @ObjectModel: {
               readOnly: true,
               virtualElement,
               virtualElementCalculatedBy: 'ABAP:CL_FCO_ALLOC_KEY_CDS_EXIT'
            }
      cast( '' as ltext )   as AllocationFieldText,
      
      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'