P_AllocFldGroupDataInformation

DDL: P_ALLOCFLDGROUPDATAINFORMATION SQL: PALFLDGRDTAINF Type: view CONSUMPTION

P_AllocFldGroupDataInformation is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_AllocationFieldGroup) and exposes 27 fields with key fields AllocationType, AllocationPostingType, AllocationActualPlanVariant, AllocationFieldGroup. It has 1 association to related views.

1 data source(s) 27 fields

Data Sources (1)

SourceAliasJoin Type
I_AllocationFieldGroup I_AllocationFieldGroup from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_AllocDataFldDesc _AllocFieldDesc $projection.AllocationType = _AllocFieldDesc.AllocationType and $projection.AllocationFieldGroup = _AllocFieldDesc.AllocDataFldDefName

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PALFLDGRDTAINF view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.preserveKey true 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 (27)

KeyFieldSource TableSource FieldDescription
KEY AllocationType AllocationType
KEY AllocationPostingType AllocationPostingType
KEY AllocationActualPlanVariant AllocationActualPlanVariant
KEY AllocationFieldGroup AllocationFieldGroup
AllocVariablePortingType AllocVariablePortingType
AllocFldActlPlnVarValue AllocFldActlPlnVarValue
AllocationDataFieldName1 _AllocFieldDesc AllocationDataFieldName1
AllocationDataFieldName2 _AllocFieldDesc AllocationDataFieldName2
AllocationDataFieldName3 _AllocFieldDesc AllocationDataFieldName3
AllocationDataFieldName4 _AllocFieldDesc AllocationDataFieldName4
AllocationDataFieldName5 _AllocFieldDesc AllocationDataFieldName5
AllocationDataFieldName6 _AllocFieldDesc AllocationDataFieldName6
AllocationDataFieldName7 _AllocFieldDesc AllocationDataFieldName7
AllocationDataFieldName8 _AllocFieldDesc AllocationDataFieldName8
AllocationDataFieldName9 _AllocFieldDesc AllocationDataFieldName9
AllocationDataFieldName10 _AllocFieldDesc AllocationDataFieldName10
AllocDataFieldVisibility1 _AllocFieldDesc AllocDataFieldVisibility1
AllocDataFieldVisibility2 _AllocFieldDesc AllocDataFieldVisibility2
AllocDataFieldVisibility3 _AllocFieldDesc AllocDataFieldVisibility3
AllocDataFieldVisibility4 _AllocFieldDesc AllocDataFieldVisibility4
AllocDataFieldVisibility5 _AllocFieldDesc AllocDataFieldVisibility5
AllocDataFieldVisibility6 _AllocFieldDesc AllocDataFieldVisibility6
AllocDataFieldVisibility7 _AllocFieldDesc AllocDataFieldVisibility7
AllocDataFieldVisibility8 _AllocFieldDesc AllocDataFieldVisibility8
AllocDataFieldVisibility9 _AllocFieldDesc AllocDataFieldVisibility9
AllocDataFieldVisibility10 _AllocFieldDesc AllocDataFieldVisibility10
_Field _Field 
@AbapCatalog.sqlViewName: 'PALFLDGRDTAINF'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking:#NOT_REQUIRED
@AbapCatalog.preserveKey:true
@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_AllocFldGroupDataInformation
  as select from I_AllocationFieldGroup
  //t811h

  association [1..1] to I_AllocDataFldDesc as _AllocFieldDesc on  $projection.AllocationType       = _AllocFieldDesc.AllocationType
                                                              and $projection.AllocationFieldGroup = _AllocFieldDesc.AllocDataFldDefName

{
      //I_AllocationFieldGroup

  key AllocationType,
  key AllocationPostingType,
  key AllocationActualPlanVariant,
  key AllocationFieldGroup,
      AllocVariablePortingType,
      AllocFldActlPlnVarValue,


      _AllocFieldDesc.AllocationDataFieldName1,
      _AllocFieldDesc.AllocationDataFieldName2,
      _AllocFieldDesc.AllocationDataFieldName3,
      _AllocFieldDesc.AllocationDataFieldName4,
      _AllocFieldDesc.AllocationDataFieldName5,
      _AllocFieldDesc.AllocationDataFieldName6,
      _AllocFieldDesc.AllocationDataFieldName7,
      _AllocFieldDesc.AllocationDataFieldName8,
      _AllocFieldDesc.AllocationDataFieldName9,
      _AllocFieldDesc.AllocationDataFieldName10,

      _AllocFieldDesc.AllocDataFieldVisibility1,
      _AllocFieldDesc.AllocDataFieldVisibility2,
      _AllocFieldDesc.AllocDataFieldVisibility3,
      _AllocFieldDesc.AllocDataFieldVisibility4,
      _AllocFieldDesc.AllocDataFieldVisibility5,
      _AllocFieldDesc.AllocDataFieldVisibility6,
      _AllocFieldDesc.AllocDataFieldVisibility7,
      _AllocFieldDesc.AllocDataFieldVisibility8,
      _AllocFieldDesc.AllocDataFieldVisibility9,
      _AllocFieldDesc.AllocDataFieldVisibility10,

      /* Associations */
      //I_AllocationFieldGroup

      _Field
} where 
    AllocationType = 'ACDOC_CC'
    or AllocationType = 'ACDOC_PC'
    or AllocationType = 'ACDOC_PA'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ALLOCATIONFIELDGROUP",
"I_ALLOCDATAFLDDESC"
],
"ASSOCIATED":
[
"I_ALLOCDATAFLDDESC"
],
"BASE":
[
"I_ALLOCATIONFIELDGROUP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More