I_WorkInProcessDetail

@AbapCatalog.sqlViewName: 'IWIPDETAIL'
//@ClientDependent: true

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Detail WIP 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 I_WorkInProcessDetail
  as

  select
    PostingPeriod,       //not null

    TransactionCurrency, //not null

    UnitOfMeasure,       //not null

    CostElement,         //not null

    CostCenter,          //not null

    CostCtrActivityType, //not null

    Material,            //not null

    BusinessProcess,     //not null

    PersonnelNumber,     //not null

    //    coalesce(EmployeeFullName,' ')                                  as EmployeeFullName,

    ManualInvoiceItem,   //not null

    ProfitCenter,        //not null

    ControllingObject,   //not null

    ControllingDocument, //not null

    ControllingDocumentItem, //not null

    BillingDocumentCategory, //not null

    BillingPlanItemUsage,    //not null

    WorkItem,                //not null

    EngagementProjectServiceOrg, //not null

    AccountingIndicatorCode, //not null

    CostAnalysisResource,    //not null

    CalendarMonth,           //not null  

    TimeSheetOvertimeCategory,  //not null

    cast(coalesce(ResultAnalysisVersion,'000') as versn_abgr)        as ResultAnalysisVersion,
    cast(coalesce(ServicesRenderedDate,'00000000') as fbuda)         as ServicesRenderedDate,
    coalesce(TransacCrcyForInvoiceAmount,cast(0 as fins_vhcur12))    as TransacCrcyForInvoiceAmount,
    coalesce(ObjectCrcyForInvoiceAmount,cast(0 as fins_vhcur12))     as ObjectCrcyForInvoiceAmount,
    coalesce(CtrlgAreaCrcyForInvoiceAmount,cast(0 as fins_vhcur12))  as CtrlgAreaCrcyForInvoiceAmount,
    coalesce(ForInvoiceQuantity,cast(0 as quan1_12))                 as ForInvoiceQuantity,

    coalesce(TransacCrcyForRjcnAmount,cast(0 as fins_vhcur12))       as TransacCrcyForRjcnAmount,
    coalesce(ObjectCrcyForRjcnAmount,cast(0 as fins_vhcur12))        as ObjectCrcyForRjcnAmount,
    coalesce(CtrlgAreaCrcyForRjcnAmount,cast(0 as fins_vhcur12))     as CtrlgAreaCrcyForRjcnAmount,

    coalesce(ForRjcnQuantity,cast(0 as quan1_12))                    as ForRjcnQuantity,
    SalesDocumentItemCurrency, //treated in next view

    coalesce(TransacCrcyInvoicedAmount,cast(0 as fins_vhcur12))      as TransacCrcyInvoicedAmount,
    coalesce(ObjectCrcyInvoicedAmount,cast(0 as fins_vhcur12))       as ObjectCrcyInvoicedAmount,
    coalesce(CtrlgAreaCrcyInvoicedAmount,cast(0 as fins_vhcur12))    as CtrlgAreaCrcyInvoicedAmount,
    coalesce(InvoicedQuantity,cast(0 as quan1_12))                   as InvoicedQuantity,

//    coalesce(TransacCrcyRejectedAmount,cast(0 as fins_vhcur12))      as TransacCrcyRejectedAmount,

//    coalesce(ObjectCrcyRejectedAmount,cast(0 as fins_vhcur12))       as ObjectCrcyRejectedAmount,

//    coalesce(CtrlgAreaCrcyRejectedAmount,cast(0 as fins_vhcur12))    as CtrlgAreaCrcyRejectedAmount,


    coalesce(TransacCrcyRejectedAmount,cast(0 as fins_vhcur12))      as RejectedAmtInTransCrcy,
    coalesce(ObjectCrcyRejectedAmount,cast(0 as fins_vhcur12))       as RejectedAmountInObjectCurrency,
    coalesce(CtrlgAreaCrcyRejectedAmount,cast(0 as fins_trr_rejected_amount))    as RejectedAmountInCtrlgAreaCrcy,

    coalesce(RejectedQuantity,cast(0 as quan1_12))                   as RejectedQuantity,
    coalesce(TransacCrcyWIPAmount,cast(0 as fins_vhcur12))           as TransacCrcyWIPAmount,
    coalesce(ObjectCrcyWIPAmount,cast(0 as fins_vhcur12))            as ObjectCrcyWIPAmount,
    coalesce(CtrlgAreaCrcyWIPAmount,cast(0 as fins_vhcur12))         as CtrlgAreaCrcyWIPAmount,
    coalesce(WIPQuantity,cast(0 as quan1_12))                        as WIPQuantity,
    coalesce(TotTransacCrcyInvoiceSimlnAmt,cast(0 as fins_vhcur12))  as TotTransacCrcyInvoiceSimlnAmt,
    coalesce(TotObjectCrcyInvoiceSimlnAmt,cast(0 as fins_vhcur12))   as TotObjectCrcyInvoiceSimlnAmt,
    coalesce(TotCtrlgAreaCrcyInvcSimlnAmt,cast(0 as fins_vhcur12))   as TotCtrlgAreaCrcyInvcSimlnAmt,
    ControllingObjectCurrency,   //treated in next view

    ControllingAreaCurrency,     //treated in next view

    TransacCurrencyInvoiceSimln, //treated in next view

    RevenueCostElement, //not null, = ' '

    SoldMaterial,       //not null, = ' '

    TransacCrcyInvoiceSimlnAmt,  //not null, = 0

    ObjectCrcyInvoiceSimlnAmt,   //not null, = 0

    CtrlgAreaCrcyInvoiceSimlnAmt //not null, = 0

  from P_Wipdetailbasic;