I_ALLOCATIONKEYFIELD

CDS View

Allocation Key Field

I_ALLOCATIONKEYFIELD is a CDS View in S/4HANA. Allocation Key Field. It contains 13 fields. 19 CDS views read from this table.

Used by 19 CDS view(s) 13 fields

CDS Views using this table (19)

ViewTypeJoinVDMDescription
I_AllocationCycleKeyFieldTP view from TRANSACTIONAL Allocation Cycle Key Field TP
I_AllocationKeyFieldTP view from TRANSACTIONAL Allocation Key Field TP
I_AllocationSenderKeyFieldTP view from TRANSACTIONAL Allocation Sender Key Field TP
I_AllocRcvrTracingKeyFieldTP view from TRANSACTIONAL Allocation Receiver Tracing Key Field TP
I_AllocReceiverKeyFieldTP view from TRANSACTIONAL Allocation Receiver Key Field TP
I_AllocSenderValueKeyFieldTP view from TRANSACTIONAL Allocation Sender Value Key Field TP
I_FuncnlAreaCostAllocSgmt view from COMPOSITE Cost Allocation Segment for Funcnl Area
I_FuncnlAreaCostAllocSgmt view union COMPOSITE Cost Allocation Segment for Funcnl Area
I_FundCostAllocSgmt view union COMPOSITE Cost Allocation Segment for Fund
I_FundCostAllocSgmt view from COMPOSITE Cost Allocation Segment for Fund
I_GrantCostAllocSgmt view from COMPOSITE Cost Allocation Segment for Grant
I_GrantCostAllocSgmt view union COMPOSITE Cost Allocation Segment for Grant
P_AllocationCostCenterVH view from COMPOSITE
P_AllocationKeyField view from BASIC
P_AllocRcvrTracingRefCount view from CONSUMPTION
P_TDDVirtualField view from COMPOSITE
P_WhereUsdIntOrdAlloc view_entity inner COMPOSITE
P_WhereUsdIntOrdAlloc view_entity union_all COMPOSITE
P_WhereUsdIntOrdAllocPlnCat view_entity from COMPOSITE WUIO Allocations - Relation to the Plan Category

Fields (13)

KeyField CDS FieldsUsed in Views
KEY AllocationCycle AllocationCycle 3
KEY AllocationCycleSegment AllocationCycleSegment 3
KEY AllocationCycleStartDate AllocationCycleStartDate 3
KEY AllocationSetType AllocationSetType 2
KEY AllocationType AllocationType 7
KEY AllocDocumentSequenceNumber AllocDocumentSequenceNumber 3
_Cycle _Cycle 2
_Segment _Segment 2
AllocationFieldMaximumValue AllocationFieldMaximumValue 1
AllocationFieldMinimumValue AllocationFieldMinimumValue 1
AllocationFieldName AllocationFieldName 1
AllocationSetId AllocationSetId 1
AllocationSetName AllocationSetName 1 
@AbapCatalog.sqlViewName: 'ALLOCKEYFIELD'
@AbapCatalog.compiler.compareFilter: true

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

@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Allocation Key Field'

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

@VDM.viewType: #BASIC
define view I_AllocationKeyField 
  as select from t811k

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

{
  key cast(tab as fco_allocation_type) as AllocationType,         
  key cycle   as AllocationCycle,      
  key cast( sdate as fco_alloc_valid_from ) as AllocationCycleStartDate,      
  key seqnr   as AllocationCycleSegment,
  key setkind as AllocationSetType,
  key pos     as AllocDocumentSequenceNumber, 
  field       as AllocationFieldName, 
  setname     as AllocationSetName,
  valmin      as AllocationFieldMinimumValue,  
  valmax      as AllocationFieldMaximumValue, 
  setid       as AllocationSetId,
  cast( case when valmin = '#' then 'X' else '' end as boolean ) as  AllocKeyFieldIsInitial,
  cast( case when valmin = '*' then 'X' else '' end as boolean ) as AllocKeyFieldIsAllValues,
  
  _Cycle,
  _Segment 
} 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T811K"
],
"ASSOCIATED":
[
"I_ALLOCATIONCYCLE",
"I_ALLOCATIONSEGMENT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More