I_AllocRcvrTracingRefKeyFldTP

@AbapCatalog.sqlViewName: 'ALORCVRREFTP'
@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 Receiver Reference Field'
@VDM.viewType: #TRANSACTIONAL
@ObjectModel:
{
  transactionalProcessingEnabled:true,
  writeDraftPersistence: 'ALORCVRFLDTPD',
  semanticKey: ['AllocationType', 'AllocationCycle', 'AllocationCycleStartDate', 'AllocationCycleSegment', 
    'AllocDocumentSequenceNumber', 'AllocationFieldName', 'AllocRefDocumentSequenceNumber'],
  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: true

//  entityChangeStateId: 'LastChangeTime' 

}
define view I_AllocRcvrTracingRefKeyFldTP as 
select from I_AllocTopDwnDistrRefFld 
  association [1..1] to I_AllocRcvrTracingKeyFieldTP   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,
      
      AllocRefKeyFieldIsInitial,
      AllocRefKeyFieldIsAllValues,
      AllocSourceKeyFieldIsInitial,
      AllocSourceKeyFieldIsAllValues,
      
      @ObjectModel.association.type: #TO_COMPOSITION_PARENT
      _KeyField,
      @ObjectModel.association.type: #TO_COMPOSITION_ROOT
      _Cycle
}
where 
  AllocationSetType = '4'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ALLOCTOPDWNDISTRREFFLD"
],
"ASSOCIATED":
[
"I_ALLOCATIONCYCLETP",
"I_ALLOCRCVRTRACINGKEYFIELDTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/