I_AllocSndrRefKeyFldTP

DDL: I_ALLOCSNDRREFKEYFLDTP SQL: ALOTDDSNDRREFTP Type: view TRANSACTIONAL

Allocation TDD Sender Reference Field

I_AllocSndrRefKeyFldTP is a Transactional CDS View that provides data about "Allocation TDD Sender Reference Field" in SAP S/4HANA. It reads from 1 data source (I_AllocTopDwnDistrRefFld) and exposes 16 fields with key fields AllocationType, AllocationCycle, AllocationCycleStartDate, AllocationCycleSegment, AllocationSetType. It has 2 associations to related views.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_AllocTopDwnDistrRefFld I_AllocTopDwnDistrRefFld from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_AllocationSenderKeyFieldTP _KeyField $projection.AllocationType = _KeyField.AllocationType and $projection.AllocationCycle = _KeyField.AllocationCycle and $projection.AllocationCycleStartDate = _KeyField.AllocationCycleStartDate and $projection.AllocationCycleSegment = _KeyField.AllocationCycleSegment and $projection.AllocDocumentSequenceNumber = _KeyField.AllocDocumentSequenceNumber
[1..1] I_AllocationCycleTP _Cycle $projection.AllocationType = _Cycle.AllocationType and $projection.AllocationCycle = _Cycle.AllocationCycle and $projection.AllocationCycleStartDate = _Cycle.AllocationCycleStartDate

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ALOTDDSNDRREFTP 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
AbapCatalog.preserveKey true view
EndUserText.label Allocation TDD Sender Reference Field view
VDM.viewType #TRANSACTIONAL view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.writeDraftPersistence ALOTDDSNDRREFTPD view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY AllocationType AllocationType
KEY AllocationCycle AllocationCycle
KEY AllocationCycleStartDate AllocationCycleStartDate
KEY AllocationCycleSegment AllocationCycleSegment
KEY AllocationSetType AllocationSetType
KEY AllocDocumentSequenceNumber AllocDocumentSequenceNumber
KEY AllocationFieldName AllocationFieldName
KEY AllocRefDocumentSequenceNumber AllocRefDocumentSequenceNumber
AllocationSetName AllocationSetName
AllocReferenceFromValue AllocReferenceFromValue
AllocReferenceToValue AllocReferenceToValue
AllocReferenceSourceFromValue AllocReferenceSourceFromValue
AllocReferenceSourceToValue AllocReferenceSourceToValue
AllocationSetId AllocationSetId
_KeyField _KeyField
_Cycle _Cycle 
@AbapCatalog.sqlViewName: 'ALOTDDSNDRREFTP'
@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

@AbapCatalog.preserveKey:true

@EndUserText.label: 'Allocation TDD Sender Reference Field'
@VDM.viewType: #TRANSACTIONAL
@ObjectModel:
{
  transactionalProcessingEnabled:true,
  writeDraftPersistence: 'ALOTDDSNDRREFTPD',
  semanticKey: ['AllocationType', 'AllocationCycle', 'AllocationCycleStartDate', 'AllocationCycleSegment', 
    'AllocDocumentSequenceNumber', 'AllocationFieldName', 'AllocRefDocumentSequenceNumber'],
  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: true

//  entityChangeStateId: 'LastChangeTime' 

}
define view I_AllocSndrRefKeyFldTP as 
select from I_AllocTopDwnDistrRefFld 
  association [1..1] to I_AllocationSenderKeyFieldTP   as _KeyField                   on  $projection.AllocationType              = _KeyField.AllocationType
                                                                                      and $projection.AllocationCycle             = _KeyField.AllocationCycle
                                                                                      and $projection.AllocationCycleStartDate    = _KeyField.AllocationCycleStartDate
                                                                                      and $projection.AllocationCycleSegment      = _KeyField.AllocationCycleSegment
                                                                                      and $projection.AllocDocumentSequenceNumber = _KeyField.AllocDocumentSequenceNumber
                                                                                      
  association [1..1] to I_AllocationCycleTP            as _Cycle                      on  $projection.AllocationType           = _Cycle.AllocationType
                                                                                      and $projection.AllocationCycle          = _Cycle.AllocationCycle
                                                                                      and $projection.AllocationCycleStartDate = _Cycle.AllocationCycleStartDate

{
  //I_AllocTopDwnDistrRefFld 

  key AllocationType, 
  key AllocationCycle, 
  key AllocationCycleStartDate, 
  key AllocationCycleSegment, 
  key AllocationSetType, 
  key AllocDocumentSequenceNumber, 
  key AllocationFieldName, 
  key AllocRefDocumentSequenceNumber, 
      AllocationSetName, 
      AllocReferenceFromValue, 
      AllocReferenceToValue, 
      AllocReferenceSourceFromValue,
      AllocReferenceSourceToValue, 
      AllocationSetId,
      
      @ObjectModel.association.type: #TO_COMPOSITION_PARENT
      _KeyField,
      @ObjectModel.association.type: #TO_COMPOSITION_ROOT
      _Cycle
}
where AllocationSetType = '2'

Learn More