I_AllocSenderValueKeyFieldTP

DDL: I_ALLOCSENDERVALUEKEYFIELDTP SQL: ALOSENDVALFLDTP Type: view TRANSACTIONAL

Allocation Sender Value Key Field TP

I_AllocSenderValueKeyFieldTP is a Transactional CDS View that provides data about "Allocation Sender Value Key Field TP" in SAP S/4HANA. It reads from 2 data sources (I_AllocationContextType, I_AllocationKeyField) and exposes 16 fields with key fields AllocationType, AllocationCycle, AllocationCycleStartDate, AllocationCycleSegment, AllocDocumentSequenceNumber. It has 2 associations to related views.

2 data source(s) 16 fields

Data Sources (2)

SourceAliasJoin Type
I_AllocationContextType Context inner
I_AllocationKeyField I_AllocationKeyField from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_AllocationSegmentTP _Segment $projection.AllocationType = _Segment.AllocationType and $projection.AllocationCycle = _Segment.AllocationCycle and $projection.AllocationCycleStartDate = _Segment.AllocationCycleStartDate and $projection.AllocationCycleSegment = _Segment.AllocationCycleSegment
[1..1] I_AllocationCycleTP _Cycle $projection.AllocationType = _Cycle.AllocationType and $projection.AllocationCycle = _Cycle.AllocationCycle and $projection.AllocationCycleStartDate = _Cycle.AllocationCycleStartDate

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ALOSENDVALFLDTP 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 #C view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label Allocation Sender Value Key Field TP view
VDM.viewType #TRANSACTIONAL view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.writeDraftPersistence ALOSENDVALFLDTPD view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY AllocationType I_AllocationKeyField AllocationType
KEY AllocationCycle AllocationCycle
KEY AllocationCycleStartDate AllocationCycleStartDate
KEY AllocationCycleSegment AllocationCycleSegment
KEY AllocDocumentSequenceNumber AllocDocumentSequenceNumber
AllocationFieldName AllocationFieldName
AllocationSetName AllocationSetName
AllocationFieldMinimumValue AllocationFieldMinimumValue
AllocationFieldMaximumValue AllocationFieldMaximumValue
AllocationSetId AllocationSetId
AllocationSetType AllocationSetType
AllocationFieldText
AllocKeyFieldIsInitial AllocKeyFieldIsInitial
AllocKeyFieldIsAllValues AllocKeyFieldIsAllValues
_Segment _Segment
_Cycle _Cycle 
@AbapCatalog.sqlViewName: 'ALOSENDVALFLDTP'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking:#NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M

@EndUserText.label: 'Allocation Sender Value Key Field TP'
@VDM.viewType: #TRANSACTIONAL

@ObjectModel:
{
  transactionalProcessingEnabled:true,
  writeDraftPersistence: 'ALOSENDVALFLDTPD',
  semanticKey: ['AllocationType', 'AllocationCycle', 'AllocationCycleStartDate', 'AllocationCycleSegment', 'AllocDocumentSequenceNumber' ],
  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: true

//  entityChangeStateId: 'LastChangeTime'

}
define view I_AllocSenderValueKeyFieldTP as
select from I_AllocationKeyField
  inner join I_AllocationContextType as Context on Context.AllocationType = I_AllocationKeyField.AllocationType

  association [1..1] to I_AllocationSegmentTP   as _Segment                           on  $projection.AllocationType           = _Segment.AllocationType
                                                                                      and $projection.AllocationCycle          = _Segment.AllocationCycle
                                                                                      and $projection.AllocationCycleStartDate = _Segment.AllocationCycleStartDate
                                                                                      and $projection.AllocationCycleSegment   = _Segment.AllocationCycleSegment

  association [1..1] to I_AllocationCycleTP     as _Cycle                             on  $projection.AllocationType           = _Cycle.AllocationType
                                                                                      and $projection.AllocationCycle          = _Cycle.AllocationCycle
                                                                                      and $projection.AllocationCycleStartDate = _Cycle.AllocationCycleStartDate
{
  key I_AllocationKeyField.AllocationType,
  key AllocationCycle,
  key AllocationCycleStartDate,
  key AllocationCycleSegment,
  key AllocDocumentSequenceNumber,
      AllocationFieldName,
      AllocationSetName,
      AllocationFieldMinimumValue,
      AllocationFieldMaximumValue,
      AllocationSetId,
      AllocationSetType,
      @ObjectModel: {
            readOnly: true,
            virtualElement,
            virtualElementCalculatedBy: 'ABAP:CL_FCO_ALLOC_KEY_CDS_EXIT'
         }
      cast( '' as ltext )                      as  AllocationFieldText,

      
      AllocKeyFieldIsInitial,      
      AllocKeyFieldIsAllValues,

      @ObjectModel.association.type: #TO_COMPOSITION_PARENT
      _Segment,
      @ObjectModel.association.type: #TO_COMPOSITION_ROOT
      _Cycle
}
where
  AllocationSetType = '1'

  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ALLOCATIONCONTEXTTYPE",
"I_ALLOCATIONKEYFIELD"
],
"ASSOCIATED":
[
"I_ALLOCATIONCYCLETP",
"I_ALLOCATIONSEGMENTTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More