C_AllocationCycleInformation

@AbapCatalog.sqlViewName: 'CALLOCCYCLEINFO'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: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: #CONSUMPTION
@EndUserText.label: 'Allocation Cycle Information'
define view C_AllocationCycleInformation as 
select from P_AllocationInformation
  inner join I_AllocationContextType as context on  context.AllocationType = P_AllocationInformation.AllocationType
{

  //key DatabaseTable,  

  key P_AllocationInformation.AllocationType,
  //key AllocationType,

  key AllocationPostingType,
  key AllocationActualPlanVariant,
  key AllocationFieldName,
      AllocationFieldType,
      SuperiorToField1,
      SuperiorToField2,
      AllocationCycleFieldActive                  as AllocationFieldActive,
      AllocationCycleFieldGroup                   as AllocationFieldGroup,
      AllocationCycleSingleField                  as AllocationSingleField,
      AllocationCycleFieldInterval                as AllocationFieldInterval,
      AllocationFieldLabel,
      AllocationFieldLength,
      AllocationFieldPropertyType,
      AllocationFieldIsUppercase,
      AllocationFieldDecimalPlaces,
      AllocationFieldPrecision,
      AllocationFieldScale,
      AllocationFieldDisplayPosition,
      cast(case AllocationFieldName
        when 'RBUKRS'   then 'X'
        when 'RLDNR'    then 'X'
        when 'CATEGORY' then 'X'
        when 'RACCT' then 'X'
        else ' '
        end as boolean )                          as AllocationFieldIsStatic,
      AllocationSearchHelpEntityName,
      AllocationSearchHelpOutput,
      GroupValueHelpEntityName,
      GroupValueHelpOutput,
      GroupValueHelpOutputText      
}
where
     AllocationCycleFieldActive = 'X'
  or AllocationCycleFieldActive = '+'