I_ALLOCATIONINFORMATION

CDS View

Allocation Information

I_ALLOCATIONINFORMATION is a CDS View in S/4HANA. Allocation Information. 3 CDS views read from this table.

Used by 3 CDS view(s)

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_AllocationInformation view from CONSUMPTION
P_AllocFldGrpExtenFldInfo view from CONSUMPTION
P_WhereUsedAllocationContext view_entity from COMPOSITE 
@AbapCatalog.sqlViewName: 'ALLOCINFORMATION'
@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

@VDM.viewType: #BASIC
@EndUserText.label: 'Allocation Information'

define view I_AllocationInformation
  as select from t811i
{
  //key tab   as DatabaseTable,

  key cast(tab as fco_allocation_type) as AllocationType,         
  //key alart as AllocationType,

  key cast(alart as fco_allocation_posting_type) as AllocationPostingType,     
  key ipknz as AllocationActualPlanVariant,      
  key field as AllocationFieldName,      
  fieldtype as AllocationFieldType,
  magr1     as SuperiorToField1,
  magr2     as SuperiorToField2,
  cast(cact as fco_information_type)      as AllocationCycleFieldActive,
  cast(scact as fco_information_type)     as SenderTracingFieldActive,
  cast(sact as fco_information_type)      as SenderFieldActive,
  cast(ract as fco_information_type)      as ReceiverFieldActive, 
  cast(rcact as fco_information_type)     as ReceiverTracingFieldActive,
  cast(cset as fco_information_type)      as AllocationCycleFieldGroup,
//  cast((case when field = 'RCNTR' then scset else '' end) as fco_information_type)as SenderTracingFieldGroup,

//  cast((case when field = 'RCNTR' then sset else '' end) as fco_information_type) as SenderFieldGroup,

//  cast((case when field = 'RCNTR' then rset else '' end) as fco_information_type) as ReceiverFieldGroup,

//  cast((case when field = 'RCNTR' then rcset else '' end) as fco_information_type) as ReceiverTracingFieldGroup,

  cast(scset  as fco_information_type)    as SenderTracingFieldGroup,
  cast(sset   as fco_information_type)    as SenderFieldGroup,
  cast(rset   as fco_information_type)    as ReceiverFieldGroup,
  cast(rcset  as fco_information_type)    as ReceiverTracingFieldGroup,
  cast(csing  as fco_information_type)    as AllocationCycleSingleField,
  cast(scsing as fco_information_type)    as SenderTracingSingleField,
  cast(ssing  as fco_information_type)    as SenderSingleField,
  cast(rsing  as fco_information_type)    as ReceiverSingleField,
  cast(rcsing as fco_information_type)    as ReceiverTracingSingleField, 
  cast(cint   as fco_information_type)    as AllocationCycleFieldInterval,
  cast(scint  as fco_information_type)    as SenderTracingFieldInterval,
  cast(sint   as fco_information_type)    as SenderFieldInterval,
  cast(rint   as fco_information_type)    as ReceiverFieldInterval,
  cast(rcint  as fco_information_type)    as ReceiverTracingFieldInterval,
  anzpos                                  as AllocationFieldDisplayPosition,
  cast('' as fco_alloc_shlp_entity_name)  as AllocationSearchHelpEntityName,
  cast('' as domname)                     as AllocationSearchHelpOutput,
  cast('' as fco_group_shlp_entity_name)  as GroupValueHelpEntityName,
  cast('' as domname)                     as GroupValueHelpOutput,
  cast('' as domname)                     as GroupValueHelpOutputText
}

Learn More