C_AllocRcvrRefKeyFldTP

DDL: C_ALLOCRCVRREFKEYFLDTP SQL: CALOTDDRCVRREFTP Type: view CONSUMPTION

Allocation TDD Receiver Reference Field

C_AllocRcvrRefKeyFldTP is a Consumption CDS View that provides data about "Allocation TDD Receiver Reference Field" in SAP S/4HANA. It reads from 1 data source (I_AllocRcvrRefKeyFldTP) 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_AllocRcvrRefKeyFldTP I_AllocRcvrRefKeyFldTP from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_AllocationReceiverKeyFieldTP _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] C_AllocationCycleTP _Cycle $projection.AllocationType = _Cycle.AllocationType and $projection.AllocationCycle = _Cycle.AllocationCycle and $projection.AllocationCycleStartDate = _Cycle.AllocationCycleStartDate

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CALOTDDRCVRREFTP 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 #CONSUMPTION view
ObjectModel.transactionalProcessingDelegated true 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: 'CALOTDDRCVRREFTP'
@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: #CONSUMPTION
@ObjectModel:
{
  transactionalProcessingDelegated: true,
  //draftEnabled: true,

  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: true
//  entityChangeStateId: 'LastChangeTime'

}
define view C_AllocRcvrRefKeyFldTP
  as select from I_AllocRcvrRefKeyFldTP
  association [1..1] to C_AllocationReceiverKeyFieldTP 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 C_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 = '2'

Learn More