I_AllocationSenderKeyFieldTP

DDL: I_ALLOCATIONSENDERKEYFIELDTP SQL: ALOSENDFIELDTP Type: view TRANSACTIONAL

Allocation Sender Key Field TP

I_AllocationSenderKeyFieldTP is a Transactional CDS View that provides data about "Allocation Sender 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_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] 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 ALOSENDFIELDTP 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 Sender Key Field TP view
VDM.viewType #TRANSACTIONAL view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.writeDraftPersistence ALOSENDFLDTPD 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
AllocKeyFieldIsAllValues
_SndrRefKeyFld _SndrRefKeyFld
_Segment _Segment
_Cycle _Cycle
@AbapCatalog.sqlViewName: 'ALOSENDFIELDTP'
@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 Sender Key Field TP'
@VDM.viewType: #TRANSACTIONAL
@ObjectModel:
{
  transactionalProcessingEnabled:true,
  writeDraftPersistence: 'ALOSENDFLDTPD',
  semanticKey: ['AllocationType', 'AllocationCycle', 'AllocationCycleStartDate', 'AllocationCycleSegment', 'AllocDocumentSequenceNumber' ],
  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: true

//  entityChangeStateId: 'LastChangeTime'

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

  association [0..*] to I_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 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,

      @ObjectModel.readOnly: true
      cast( '' as boolean ) as AllocKeyFieldIsInitial,
      @ObjectModel.readOnly: true
      cast( '' as boolean ) as AllocKeyFieldIsAllValues,

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