P_ALLOCFIELDGROUPINFORMATION

@AbapCatalog.sqlViewName: 'PALLOFLDGRPINFO'
@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_AllocFieldGroupInformation
  as select from P_AllocFldGroupDataInformation

  //t811i

  association [0..1] to P_AllocationInformation   as _AllocInformation1  on  $projection.AllocationType              = _AllocInformation1.AllocationType
                                                                         and $projection.AllocationActualPlanVariant = _AllocInformation1.AllocationActualPlanVariant
                                                                         and $projection.AllocationPostingType       = _AllocInformation1.AllocationPostingType
                                                                         and $projection.AllocationDataFieldName1    = _AllocInformation1.AllocationFieldName

  association [0..1] to P_AllocationInformation   as _AllocInformation2  on  $projection.AllocationType              = _AllocInformation2.AllocationType
                                                                         and $projection.AllocationActualPlanVariant = _AllocInformation2.AllocationActualPlanVariant
                                                                         and $projection.AllocationPostingType       = _AllocInformation2.AllocationPostingType
                                                                         and $projection.AllocationDataFieldName2    = _AllocInformation2.AllocationFieldName

  association [0..1] to P_AllocationInformation   as _AllocInformation3  on  $projection.AllocationType              = _AllocInformation3.AllocationType
                                                                         and $projection.AllocationActualPlanVariant = _AllocInformation3.AllocationActualPlanVariant
                                                                         and $projection.AllocationPostingType       = _AllocInformation3.AllocationPostingType
                                                                         and $projection.AllocationDataFieldName3    = _AllocInformation3.AllocationFieldName

  association [0..1] to P_AllocationInformation   as _AllocInformation4  on  $projection.AllocationType              = _AllocInformation4.AllocationType
                                                                         and $projection.AllocationActualPlanVariant = _AllocInformation4.AllocationActualPlanVariant
                                                                         and $projection.AllocationPostingType       = _AllocInformation4.AllocationPostingType
                                                                         and $projection.AllocationDataFieldName4    = _AllocInformation4.AllocationFieldName

  association [0..1] to P_AllocationInformation   as _AllocInformation5  on  $projection.AllocationType              = _AllocInformation5.AllocationType
                                                                         and $projection.AllocationActualPlanVariant = _AllocInformation5.AllocationActualPlanVariant
                                                                         and $projection.AllocationPostingType       = _AllocInformation5.AllocationPostingType
                                                                         and $projection.AllocationDataFieldName5    = _AllocInformation5.AllocationFieldName

  association [0..1] to P_AllocationInformation   as _AllocInformation6  on  $projection.AllocationType              = _AllocInformation6.AllocationType
                                                                         and $projection.AllocationActualPlanVariant = _AllocInformation6.AllocationActualPlanVariant
                                                                         and $projection.AllocationPostingType       = _AllocInformation6.AllocationPostingType
                                                                         and $projection.AllocationDataFieldName6    = _AllocInformation6.AllocationFieldName

  association [0..1] to P_AllocationInformation   as _AllocInformation7  on  $projection.AllocationType              = _AllocInformation7.AllocationType
                                                                         and $projection.AllocationActualPlanVariant = _AllocInformation7.AllocationActualPlanVariant
                                                                         and $projection.AllocationPostingType       = _AllocInformation7.AllocationPostingType
                                                                         and $projection.AllocationDataFieldName7    = _AllocInformation7.AllocationFieldName

  association [0..1] to P_AllocationInformation   as _AllocInformation8  on  $projection.AllocationType              = _AllocInformation8.AllocationType
                                                                         and $projection.AllocationActualPlanVariant = _AllocInformation8.AllocationActualPlanVariant
                                                                         and $projection.AllocationPostingType       = _AllocInformation8.AllocationPostingType
                                                                         and $projection.AllocationDataFieldName8    = _AllocInformation8.AllocationFieldName

  association [0..1] to P_AllocationInformation   as _AllocInformation9  on  $projection.AllocationType              = _AllocInformation9.AllocationType
                                                                         and $projection.AllocationActualPlanVariant = _AllocInformation9.AllocationActualPlanVariant
                                                                         and $projection.AllocationPostingType       = _AllocInformation9.AllocationPostingType
                                                                         and $projection.AllocationDataFieldName9    = _AllocInformation9.AllocationFieldName

  association [0..1] to P_AllocationInformation   as _AllocInformation10 on  $projection.AllocationType              = _AllocInformation10.AllocationType
                                                                         and $projection.AllocationActualPlanVariant = _AllocInformation10.AllocationActualPlanVariant
                                                                         and $projection.AllocationPostingType       = _AllocInformation10.AllocationPostingType
                                                                         and $projection.AllocationDataFieldName10   = _AllocInformation10.AllocationFieldName
{
      //I_AllocationFieldGroup

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


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

      concat(concat(concat(concat(concat(concat(concat(concat(AllocationDataFieldName1,';'),AllocDataFieldVisibility1),';'),
        _AllocInformation1.ReceiverTracingSingleField), ';'),
          _AllocInformation1.ReceiverTracingFieldInterval),';'),
            _AllocInformation1.ReceiverTracingFieldGroup)   as AllocFieldGroupDataFieldKey1,

      concat(concat(concat(concat(concat(concat(concat(concat(AllocationDataFieldName2,';'),AllocDataFieldVisibility2),';'),
       _AllocInformation2.ReceiverTracingSingleField), ';'),
         _AllocInformation2.ReceiverTracingFieldInterval),';'),
           _AllocInformation2.ReceiverTracingFieldGroup)    as AllocFieldGroupDataFieldKey2,

      concat(concat(concat(concat(concat(concat(concat(concat(AllocationDataFieldName3,';'),AllocDataFieldVisibility3),';'),
        _AllocInformation3.ReceiverTracingSingleField), ';'),
          _AllocInformation3.ReceiverTracingFieldInterval),';'),
            _AllocInformation3.ReceiverTracingFieldGroup)   as AllocFieldGroupDataFieldKey3,

      concat(concat(concat(concat(concat(concat(concat(concat(AllocationDataFieldName4,';'),AllocDataFieldVisibility4),';'),
        _AllocInformation4.ReceiverTracingSingleField), ';'),
          _AllocInformation4.ReceiverTracingFieldInterval),';'),
            _AllocInformation4.ReceiverTracingFieldGroup)   as AllocFieldGroupDataFieldKey4,

      concat(concat(concat(concat(concat(concat(concat(concat(AllocationDataFieldName5,';'),AllocDataFieldVisibility5),';'),
        _AllocInformation5.ReceiverTracingSingleField), ';'),
          _AllocInformation5.ReceiverTracingFieldInterval),';'),
            _AllocInformation5.ReceiverTracingFieldGroup)   as AllocFieldGroupDataFieldKey5,

      concat(concat(concat(concat(concat(concat(concat(concat(AllocationDataFieldName6,';'),AllocDataFieldVisibility6),';'),
        _AllocInformation6.ReceiverTracingSingleField), ';'),
          _AllocInformation6.ReceiverTracingFieldInterval),';'),
              _AllocInformation6.ReceiverTracingFieldGroup) as AllocFieldGroupDataFieldKey6,

      concat(concat(concat(concat(concat(concat(concat(concat(AllocationDataFieldName7,';'),AllocDataFieldVisibility7),';'),
        _AllocInformation7.ReceiverTracingSingleField), ';'),
          _AllocInformation7.ReceiverTracingFieldInterval),';'),
              _AllocInformation7.ReceiverTracingFieldGroup) as AllocFieldGroupDataFieldKey7,

      concat(concat(concat(concat(concat(concat(concat(concat(AllocationDataFieldName8,';'),AllocDataFieldVisibility8),';'),
      _AllocInformation8.ReceiverTracingSingleField), ';'),
        _AllocInformation8.ReceiverTracingFieldInterval),';'),
            _AllocInformation8.ReceiverTracingFieldGroup)   as AllocFieldGroupDataFieldKey8,

      concat(concat(concat(concat(concat(concat(concat(concat(AllocationDataFieldName9,';'),AllocDataFieldVisibility9),';'),
        _AllocInformation9.ReceiverTracingSingleField), ';'),
          _AllocInformation9.ReceiverTracingFieldInterval),';'),
            _AllocInformation9.ReceiverTracingFieldGroup)   as AllocFieldGroupDataFieldKey9,

      concat(concat(concat(concat(concat(concat(concat(concat(AllocationDataFieldName10,';'),AllocDataFieldVisibility10),';'),
        _AllocInformation10.ReceiverTracingSingleField), ';'),
          _AllocInformation10.ReceiverTracingFieldInterval),';'),
            _AllocInformation10.ReceiverTracingFieldGroup)  as AllocFieldGroupDataFieldKey10

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_ALLOCATIONINFORMATION",
"P_ALLOCFLDGROUPDATAINFORMATION"
],
"ASSOCIATED":
[
"P_ALLOCATIONINFORMATION"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/