C_AllocCycleRunStatusFilter

DDL: C_ALLOCCYCLERUNSTATUSFILTER SQL: CALOCRUNCYCFLT Type: view CONSUMPTION

Allocation Cycle Run Status

C_AllocCycleRunStatusFilter is a Consumption CDS View that provides data about "Allocation Cycle Run Status" in SAP S/4HANA. It reads from 1 data source (I_AllocationCycle). It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_AllocationCycle I_AllocationCycle from

Parameters (2)

NameTypeDefault
P_AllocationObjectType alloc_run_view_type
P_CompanyCode fis_bukrs

Associations (1)

CardinalityTargetAliasCondition
[1..1] P_AllocationCycle _CycleCalc $projection.AllocationType = _CycleCalc.AllocationType and $projection.AllocationCycle = _CycleCalc.AllocationCycle and $projection.AllocationCycleStartDate = _CycleCalc.AllocationCycleStartDate

Annotations (11)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName CALOCRUNCYCFLT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Allocation Cycle Run Status view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #CONSUMPTION view
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'CALOCRUNCYCFLT'
@AbapCatalog.compiler.compareFilter: true

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

@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Allocation Cycle Run Status'

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

@VDM.viewType: #CONSUMPTION

define view C_AllocCycleRunStatusFilter
  with parameters
    @Consumption.valueHelpDefinition: [ { entity: { name: 'C_AllocationRunViewTypeVH', element: 'AllocationRunViewType'  } } ]
    P_AllocationObjectType : alloc_run_view_type,
    @Consumption.valueHelpDefinition: [ { entity: { name: 'I_CompanyCodeVH', element: 'CompanyCode'   } } ]
    P_CompanyCode          : fis_bukrs
  as select from I_AllocationCycle

  association [1..1] to P_AllocationCycle as _CycleCalc on  $projection.AllocationType           = _CycleCalc.AllocationType
                                                        and $projection.AllocationCycle          = _CycleCalc.AllocationCycle
                                                        and $projection.AllocationCycleStartDate = _CycleCalc.AllocationCycleStartDate
{
      @UI.selectionField: [{position: 50}]
      @ObjectModel.text.element: ['AllocationContextTypeText']
      @Consumption.labelElement: 'AllocationContextTypeText'
      @Consumption.valueHelpDefinition: [ { entity: { name: 'C_AllocRunContextValueHelp', element: 'AllocationType'  } } ]
      @UI.textArrangement: #TEXT_ONLY
      //      @UI.selectionField: [{element: 'AllocationContextTypeText'}]

  key AllocationType,

      @Consumption.semanticObject: 'OverheadCycle'
      @UI.hidden
  key AllocationCycle,
      @Semantics.businessDate.from: true
  key AllocationCycleStartDate,

      @UI.selectionField: [{position: 40}]
      @ObjectModel.text.element: ['AllocationCycleNameText']
      @Consumption.labelElement: 'AllocationCycleNameText'
      @UI.textArrangement: #TEXT_LAST
      @Consumption.valueHelpDefinition: [ { entity: { name: 'C_AllocationCycleVH', element: 'AllocationCycleName'  } } ]
      AllocationCycleName,
      @Semantics.text: true
      @UI.hidden: true
      @Consumption.filter.hidden: true
      cast('' as fco_alloc_cycle_name)                                             as AllocationCycleNameText,

      @Consumption.valueHelpDefinition: [ { entity: { name: 'C_AllocationLedgerVH', element: 'Ledger'  } } ]
      @UI.selectionField: [{position: 60}]
      @UI.textArrangement: #TEXT_LAST
      @ObjectModel.text.element: ['AllocationExecutionLedgerName']
      @Consumption.labelElement: 'AllocationExecutionLedgerName'
      cast(Ledger as alloc_execution_ledger preserving type )                      as AllocationExecutionLedger,
      //      @ObjectModel.readOnly: true

      @Semantics.text: true
      @UI.hidden: true
      @Consumption.filter.hidden: true
      cast('' as alloc_execution_ledger_name)                                      as AllocationExecutionLedgerName,
      @Consumption.valueHelpDefinition: [ { entity: { name: 'C_AllocationPostingTypeVH', element: 'AllocationPostingType'  } } ]
      @UI.selectionField: [{position: 70}]
      @UI.textArrangement: #TEXT_ONLY
      @ObjectModel.text.element: ['AllocationPostingTypeText']
      @Consumption.labelElement: 'AllocationPostingTypeText'
      AllocationPostingType,
      @Semantics.text: true
      @UI.hidden: true
      @Consumption.filter.hidden: true
      cast('' as fco_alart_text)                                                   as AllocationPostingTypeText,
      @Semantics.text: true
      @UI.hidden: true
      @Consumption.filter.hidden: true
      cast('' as fco_tab_text)                                                     as AllocationContextTypeText,
      @UI.selectionField: [{position: 80}]
      @UI.textArrangement: #TEXT_ONLY
      @ObjectModel.text.element: ['AllocActualPlanVariantText']
      @Consumption.labelElement: 'AllocActualPlanVariantText'
      AllocationActualPlanVariant,
      @Semantics.text: true
      @UI.hidden: true
      @Consumption.filter.hidden: true
      cast('' as fco_actual_plan_text)                                             as AllocActualPlanVariantText,
      @Semantics.booleanIndicator: true
      @Consumption.filter.selectionType: #SINGLE
      cast(AllocationIsCumulative as fco_alloc_run_is_cumulative preserving type ) as AllocationRunIsCumulative,
      @Consumption.valueHelpDefinition: [{ entity:{ name: 'C_UniversalAllocationTagVH', element: 'AllocationTagID' } }]
      //      @UI.selectionField: [{position: 90}]

      cast('' as fco_tag_id)                                                       as AllocationTagID

      //      @ObjectModel.text.element: ['CompanyCodeName']

      //      @UI.textArrangement: #TEXT_LAST

      //      :P_CompanyCode as CompanyCode


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ALLOCATIONCYCLE"
],
"ASSOCIATED":
[
"P_ALLOCATIONCYCLE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/