C_AllocSndrRefKeyFldTP

DDL: C_ALLOCSNDRREFKEYFLDTP SQL: CALOTDDSNDRREFTP Type: view CONSUMPTION

Allocation TDD Sender Reference Field

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

Associations (2)

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

Annotations (15)

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

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

}
define view C_AllocSndrRefKeyFldTP as 
select from I_AllocSndrRefKeyFldTP 
  association [1..1] to C_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 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,
      
      @ObjectModel.association.type: #TO_COMPOSITION_PARENT
      _KeyField,
      @ObjectModel.association.type: #TO_COMPOSITION_ROOT
      _Cycle
}
where AllocationSetType = '2'

Learn More