Fclm_Mm_Invplan

@AbapCatalog.sqlViewName: 'VFCLMMMIVP'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Invoice Plan'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #P
define view Fclm_Mm_Invplan as select from fpla as a
      inner join fplt as b
      on a.mandt = b.mandt and a.fplnr = b.fplnr
         and b.fksaf <> 'C' and b.fksaf <> 'D' 
{
a.mandt,
      a.fplnr as InvoicePlanNumber,b.fpltr as InvoicePlanItem,
      b.fpttp as Datecategory,b.fkdat as IPSettlementDate,b.waers as IPCurrency,
      b.fproz as IPPercentage,b.fakwr as IPBillingValue,b.zterm as IPPaymentTerms,
      b.afdat as IPBillingDate,b.netwr as POItemNetAmount,b.set_by_final as IPFinalIndicator,
      a.status as Status,a.final as FinalIndicator,b.fksaf as billingStatus
       --FKSAF  -- when 'A' then 'Open'
                -- when 'B' then 'Partially processed'
                -- when 'C' then 'Invoiced'
                -- when 'D' then 'Rejected'
                -- when 'E' then 'Billing Requested'
                -- else 'Not Relevant'    
}