I_AllocRcvrRefKeyFldTP

DDL: I_ALLOCRCVRREFKEYFLDTP SQL: ALOTDDRCVRREFTP Type: view TRANSACTIONAL

Allocation TDD Receiver Reference Field

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

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
I_AllocTopDwnDistrRefFld I_AllocTopDwnDistrRefFld from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_AllocReceiverKeyFieldTP _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 ALOTDDRCVRREFTP 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 Receiver Reference Field view
VDM.viewType #TRANSACTIONAL view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.writeDraftPersistence ALOTDDRCVRFLDTPD view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view

Fields (20)

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
AllocRefKeyFieldIsInitial AllocRefKeyFieldIsInitial
AllocRefKeyFieldIsAllValues AllocRefKeyFieldIsAllValues
AllocSourceKeyFieldIsInitial AllocSourceKeyFieldIsInitial
AllocSourceKeyFieldIsAllValues AllocSourceKeyFieldIsAllValues
_KeyField _KeyField
_Cycle _Cycle 
@AbapCatalog.sqlViewName: 'ALOTDDRCVRREFTP'
@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: 'ALOTDDRCVRFLDTPD',
  semanticKey: ['AllocationType', 'AllocationCycle', 'AllocationCycleStartDate', 'AllocationCycleSegment',
    'AllocDocumentSequenceNumber', 'AllocationFieldName', 'AllocRefDocumentSequenceNumber'],
  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: true

//  entityChangeStateId: 'LastChangeTime'

}
define view I_AllocRcvrRefKeyFldTP
  as select from I_AllocTopDwnDistrRefFld
  association [1..1] to I_AllocReceiverKeyFieldTP 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_ALLOCRECEIVERKEYFIELDTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More