I_ALLOCSNDRREFKEYFLDTP

CDS View

Allocation TDD Sender Reference Field

I_ALLOCSNDRREFKEYFLDTP is a CDS View in S/4HANA. Allocation TDD Sender Reference Field. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_AllocSndrRefKeyFldTP view from CONSUMPTION Allocation TDD Sender Reference Field 
@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