P_BillingDocProcFlowPM1

@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'PBILLGDOPROCFPM1'
define view P_BillingDocProcFlowPM1 
  as select distinct from P_BillingDocProcFlow0 as Level0  --> Level 0
    inner join            I_BillingDocumentItem as LevelM1 --> Level Minus1
    on  LevelM1.BillingDocument             = Level0.BillingDocument
    and LevelM1.ReferenceSDDocument         != ''
{
      //Key

  key case 
    when LevelM1.PrelimBillingDocument is initial
      then LevelM1.ReferenceSDDocument
    else
      LevelM1.PrelimBillingDocument
    end as LevelM1Document,

  key case 
    when LevelM1.PrelimBillingDocument is initial
      then LevelM1.ReferenceSDDocumentItem
    else
      LevelM1.PrelimBillingDocumentItem
    end as LevelM1DocumentItem,

  key case 
    when LevelM1.PrelimBillingDocument is initial
      then LevelM1.ReferenceSDDocumentCategory
    else
      'PBD'
    end as LevelM1DocumentCategory,

      //Billing Document

  key Level0.BillingDocument,
      Level0.BillingDocumentType,
      Level0.SDDocumentCategory,

      //Organization

      Level0.SalesOrganization
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLINGDOCUMENTITEM",
"P_BILLINGDOCPROCFLOW0"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/