P_ALLOCFLDGRPEXTENFLDINFO

CDS View

P_ALLOCFLDGRPEXTENFLDINFO is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_AllocFldGrpExtnDataField view from CONSUMPTION Allocation Field Group Extension Fields 
@AbapCatalog.sqlViewName: 'PALFLDGRPEXTEN'
@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_AllocFldGrpExtenFldInfo
  //t811i

  as select from I_AllocationInformation
  //t811h

  association [0..1] to I_AllocDataFldDesc as _AllocInformation1 on $projection.AllocationType        = _AllocInformation1.AllocationType
                                                                 and(
                                                                   $projection.AllocationFieldName    = _AllocInformation1.AllocationDataFieldName1
                                                                   or $projection.AllocationFieldName = _AllocInformation1.AllocationDataFieldName2
                                                                   or $projection.AllocationFieldName = _AllocInformation1.AllocationDataFieldName3
                                                                   or $projection.AllocationFieldName = _AllocInformation1.AllocationDataFieldName4
                                                                   or $projection.AllocationFieldName = _AllocInformation1.AllocationDataFieldName5
                                                                   or $projection.AllocationFieldName = _AllocInformation1.AllocationDataFieldName6
                                                                   or $projection.AllocationFieldName = _AllocInformation1.AllocationDataFieldName7
                                                                   or $projection.AllocationFieldName = _AllocInformation1.AllocationDataFieldName8
                                                                   or $projection.AllocationFieldName = _AllocInformation1.AllocationDataFieldName9
                                                                   or $projection.AllocationFieldName = _AllocInformation1.AllocationDataFieldName10
                                                                 )

{
      //P_AllocationInformation

  key AllocationType,
  key AllocationPostingType,
  key AllocationActualPlanVariant,
  key AllocationFieldName,

      ReceiverTracingSingleField,
      ReceiverTracingFieldInterval,
      ReceiverTracingFieldGroup,

      concat(concat(concat(concat(concat(concat(concat(concat(AllocationFieldName,';'),''),';'),
        ReceiverTracingSingleField), ';'),
          ReceiverTracingFieldInterval),';'),
            ReceiverTracingFieldGroup) as AllocFldGrpExtnDataFieldKey

}
where
  (
       AllocationType = 'ACDOC_CC'
    or AllocationType = 'ACDOC_PC'
    or AllocationType = 'ACDOC_PA'
  )
  and ReceiverTracingFieldActive = 'X'
  and _AllocInformation1.AllocDataFldDefName is null
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ALLOCATIONINFORMATION",
"I_ALLOCDATAFLDDESC"
],
"ASSOCIATED":
[
"I_ALLOCDATAFLDDESC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More