P_AllocationInformation

DDL: P_ALLOCATIONINFORMATION SQL: PALLOCINFO Type: view CONSUMPTION

P_AllocationInformation is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_AllocationInformation) and exposes 39 fields with key fields AllocationType, AllocationPostingType, AllocationActualPlanVariant, AllocationFieldName.

Data Sources (1)

SourceAliasJoin Type
I_AllocationInformation I_AllocationInformation from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PALLOCINFO view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY AllocationType AllocationType
KEY AllocationPostingType AllocationPostingType
KEY AllocationActualPlanVariant AllocationActualPlanVariant
KEY AllocationFieldName AllocationFieldName
AllocationFieldType AllocationFieldType
SuperiorToField1 SuperiorToField1
SuperiorToField2 SuperiorToField2
AllocationCycleFieldActive AllocationCycleFieldActive
SenderTracingFieldActive SenderTracingFieldActive
SenderFieldActive SenderFieldActive
ReceiverFieldActive ReceiverFieldActive
ReceiverTracingFieldActive ReceiverTracingFieldActive
AllocationCycleFieldGroup AllocationCycleFieldGroup
SenderTracingFieldGroup SenderTracingFieldGroup
SenderFieldGroup SenderFieldGroup
ReceiverFieldGroup ReceiverFieldGroup
ReceiverTracingFieldGroup ReceiverTracingFieldGroup
AllocationCycleSingleField AllocationCycleSingleField
SenderTracingSingleField SenderTracingSingleField
SenderSingleField SenderSingleField
ReceiverSingleField ReceiverSingleField
ReceiverTracingSingleField ReceiverTracingSingleField
AllocationCycleFieldInterval AllocationCycleFieldInterval
SenderTracingFieldInterval SenderTracingFieldInterval
SenderFieldInterval SenderFieldInterval
ReceiverFieldInterval ReceiverFieldInterval
ReceiverTracingFieldInterval ReceiverTracingFieldInterval
AllocationFieldLabel
AllocationFieldLength
AllocationFieldPropertyType
AllocationFieldIsUppercase
AllocationFieldDecimalPlaces
AllocationFieldPrecision
AllocationFieldScale
AllocationSearchHelpEntityName AllocationSearchHelpEntityName
AllocationSearchHelpOutput AllocationSearchHelpOutput
GroupValueHelpEntityName GroupValueHelpEntityName
GroupValueHelpOutput GroupValueHelpOutput
GroupValueHelpOutputText GroupValueHelpOutputText
@AbapCatalog.sqlViewName: 'PALLOCINFO'
@AbapCatalog.compiler.compareFilter: true

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

@ClientHandling.algorithm: #SESSION_VARIABLE

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

@VDM.viewType: #CONSUMPTION
@VDM.private: true

define view P_AllocationInformation
  as select from I_AllocationInformation
{
  //key DatabaseTable,

  key AllocationType,
  //key AllocationType,

  key AllocationPostingType,
  key AllocationActualPlanVariant,
  key AllocationFieldName,
      AllocationFieldType,
      SuperiorToField1,
      SuperiorToField2,
      AllocationCycleFieldActive,
      SenderTracingFieldActive,
      SenderFieldActive,
      ReceiverFieldActive,
      ReceiverTracingFieldActive,
      AllocationCycleFieldGroup,
      SenderTracingFieldGroup,
      SenderFieldGroup,
      ReceiverFieldGroup,
      ReceiverTracingFieldGroup,
      AllocationCycleSingleField,
      SenderTracingSingleField,
      SenderSingleField,
      ReceiverSingleField,
      ReceiverTracingSingleField,
      AllocationCycleFieldInterval,
      SenderTracingFieldInterval,
      SenderFieldInterval,
      ReceiverFieldInterval,
      ReceiverTracingFieldInterval,
      
      cast(
       case AllocationFieldDisplayPosition
        when '00' then '99'
        else AllocationFieldDisplayPosition
       end as anzpos ) as AllocationFieldDisplayPosition,

      @ObjectModel: {
          readOnly: true,
          virtualElement,
          virtualElementCalculatedBy: 'ABAP:CL_FCO_ALLOC_INFO_CDS_EXIT'
       }
      cast( '' as scrtext_l )                      as  AllocationFieldLabel,

      @ObjectModel: {
          readOnly: true,
          virtualElement,
          virtualElementCalculatedBy: 'ABAP:CL_FCO_ALLOC_INFO_CDS_EXIT'
       }
      cast( '' as ddleng )                         as  AllocationFieldLength,

      @ObjectModel: {
          readOnly: true,
          virtualElement,
          virtualElementCalculatedBy: 'ABAP:CL_FCO_ALLOC_INFO_CDS_EXIT'
       }
      cast( '' as /iwbep/sbod_edm_core_type )      as  AllocationFieldPropertyType,

      @ObjectModel: {
          readOnly: true,
          virtualElement,
          virtualElementCalculatedBy: 'ABAP:CL_FCO_ALLOC_INFO_CDS_EXIT'
       }
      cast( '' as boolean )                        as  AllocationFieldIsUppercase,

      @ObjectModel: {
          readOnly: true,
          virtualElement,
          virtualElementCalculatedBy: 'ABAP:CL_FCO_ALLOC_INFO_CDS_EXIT'
       }
      cast( 0 as int4 )                            as  AllocationFieldDecimalPlaces,

      @ObjectModel: {
          readOnly: true,
          virtualElement,
          virtualElementCalculatedBy: 'ABAP:CL_FCO_ALLOC_INFO_CDS_EXIT'
       }
      cast( 0 as int4 )                            as  AllocationFieldPrecision,

      @ObjectModel: {
          readOnly: true,
          virtualElement,
          virtualElementCalculatedBy: 'ABAP:CL_FCO_ALLOC_INFO_CDS_EXIT'
       }
      cast( 0 as int4 )                            as  AllocationFieldScale,
      
      AllocationSearchHelpEntityName,
      AllocationSearchHelpOutput,
      GroupValueHelpEntityName,
      GroupValueHelpOutput,
      GroupValueHelpOutputText
      
//      @ObjectModel: {

//          readOnly: true,

//          virtualElement

//       //   virtualElementCalculatedBy: 'ABAP:CL_FCO_ALLOC_INFO_CDS_EXIT'

//       }

//      cast('' as fco_alloc_shlp_entity_name) as AllocationSearchHelpEntityName

}