P_WIPDETAILBASIC

@AbapCatalog.sqlViewName: 'PDLIWIP_BAS'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@VDM.private:true //= @VDM.private

@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'WIP details from DIP data'


@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED

//Used for WIP detail app

//ad01wip_dtl is calcualted by DIP tool but update is triggered by results analysis and event based revenue recognition

//Selects from from ad01dli, ad01dlisf, ad01wip_dtl and P_Projwipdetpernr


define view P_Wipdetailbasic
  as

  select
    cast ( a.poper as fis_jahrper_conv preserving type ) as  PostingPeriod,
    a.twaer                                              as  TransactionCurrency,
    a.meinh                                              as  UnitOfMeasure,
    a.kstar                                              as  CostElement,
    a.kostl                                              as  CostCenter,
    a.lstar                                              as  CostCtrActivityType,
    a.matnr                                              as  Material,
    a.prznr                                              as  BusinessProcess,
    a.pernr                                              as  PersonnelNumber,
    //       z.EmployeeFullName as EmployeeFullName,

    a.manual                                             as  ManualInvoiceItem,
    a.prctr                                              as  ProfitCenter,
    a.objnr                                              as  ControllingObject,
    a.belnr                                              as  ControllingDocument,
    a.docln                                              as  ControllingDocumentItem,
    a.bpcat                                              as  BillingDocumentCategory,
    a.billingplanitemusage                               as  BillingPlanItemUsage,
    a.work_item_id                                       as  WorkItem,
    a.serv_org                                           as  EngagementProjectServiceOrg,
    a.bemot                                              as  AccountingIndicatorCode,
    a.rsrce                                              as  CostAnalysisResource,
    a.prs_work_period                                    as  CalendarMonth,
    a.overtimecat                                        as  TimeSheetOvertimeCategory,
    c.ra_versn                                           as  ResultAnalysisVersion,
    c.fbuda                                              as  ServicesRenderedDate,
    sum(b.in_wtgbtr)                                     as  TransacCrcyForInvoiceAmount,
    sum(b.in_wogbtr)                                     as  ObjectCrcyForInvoiceAmount,
    sum(b.in_wkgbtr)                                     as  CtrlgAreaCrcyForInvoiceAmount,
    sum(b.in_megbtr)                                     as  ForInvoiceQuantity,


    sum(b.no_wtgbtr)                                     as  TransacCrcyForRjcnAmount,
    sum(b.no_wogbtr)                                     as  ObjectCrcyForRjcnAmount,
    sum(b.no_wkgbtr)                                     as  CtrlgAreaCrcyForRjcnAmount,
    sum(b.no_megbtr)                                     as  ForRjcnQuantity,
    /*     sum(b.rv_wtgbtr1) as RV_WTGBTR1,    these fields are not used by DIP anymore
           sum(b.rv_wtgbtr2) as RV_WTGBTR2,
           sum(b.rv_wtgbtr3) as RV_WTGBTR3,
           sum(b.rv_wtgbtr4) as RV_WTGBTR4,  */
    b.rv_waers                                           as  SalesDocumentItemCurrency,
    sum(c.abc_wtg)                                       as  TransacCrcyInvoicedAmount,
    sum(c.abc_wog)                                       as  ObjectCrcyInvoicedAmount,
    sum(c.abc_wkg)                                       as  CtrlgAreaCrcyInvoicedAmount,
    sum(c.abc_meg)                                       as  InvoicedQuantity,

    sum(c.noc_wtg)                                       as  TransacCrcyRejectedAmount,
    sum(c.noc_wog)                                       as  ObjectCrcyRejectedAmount,
    sum(c.noc_wkg)                                       as  CtrlgAreaCrcyRejectedAmount,

    sum(c.noc_wtg)                                       as  RejectedAmtInTransCrcy,
    sum(c.noc_wog)                                       as  RejectedAmountInObjectCurrency,
    sum(c.noc_wkg)                                       as  RejectedAmountInCtrlgAreaCrcy,

    sum(c.noc_meg)                                       as  RejectedQuantity,
    sum(c.tbc_wtg)                                       as  TransacCrcyWIPAmount,
    sum(c.tbc_wog)                                       as  ObjectCrcyWIPAmount,
    sum(c.tbc_wkg)                                       as  CtrlgAreaCrcyWIPAmount,
    sum(c.tbc_meg)                                       as  WIPQuantity,
    sum(c.tbr_wtg)                                       as  TotTransacCrcyInvoiceSimlnAmt,
    sum(c.tbr_wog)                                       as  TotObjectCrcyInvoiceSimlnAmt,
    sum(c.tbr_wkg)                                       as  TotCtrlgAreaCrcyInvcSimlnAmt,
    c.hwaer                                              as  ControllingObjectCurrency,
    c.kwaer                                              as  ControllingAreaCurrency,
    c.rv_waers                                           as  TransacCurrencyInvoiceSimln,
    cast (' ' as kstar)                                  as  RevenueCostElement,
    cast (' ' as matnr)                                  as  SoldMaterial,
    cast (0 as eb_fkwrt)                                 as  TransacCrcyInvoiceSimlnAmt,  //AFLE ENABLEMENT

    cast (0 as eb_fkwrt)                                 as  ObjectCrcyInvoiceSimlnAmt,   //AFLE ENABLEMENT

    cast (0 as eb_fkwrt)                                 as  CtrlgAreaCrcyInvoiceSimlnAmt //AFLE ENABLEMENT

  from              ad01dli     as a
    left outer join ad01dlisf   as b on  a.dlinr = b.dlinr
                                     and b.dlius = '01'
    left outer join ad01wip_dtl as c on a.dlinr = c.dlinr
  //  left outer join P_Projwipdetpernr as z on z.PersonnelNumber = a.pernr

  group by
    a.poper,
    a.twaer,
    a.meinh,
    a.kstar,
    a.kostl,
    a.lstar,
    a.matnr,
    a.prznr,
    a.pernr,
    a.manual,
    a.prctr,
    a.objnr,
    a.belnr,
    a.docln,
    a.bpcat,
    a.billingplanitemusage,
    a.work_item_id,
    a.serv_org,
    a.bemot,
    a.rsrce,
    a.prs_work_period,
    a.overtimecat,
    b.rv_waers,
    c.hwaer,
    c.kwaer,
    c.ra_versn,
    c.fbuda,
    c.rv_waers

  ;
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"AD01DLI",
"AD01DLISF",
"AD01WIP_DTL"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/