I_WORKINPROCESSDETAIL

@VDM.viewType: #COMPOSITE
@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 entity I_WorkInProcessDetail 
  as select from P_Wipdetailbasic
{
  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,
  @Semantics.amount.currencyCode: 'TransactionCurrency'
  coalesce(TransacCrcyForInvoiceAmount,cast(0 as fins_vhcur12))             as TransacCrcyForInvoiceAmount,
  @Semantics.amount.currencyCode: 'ControllingObjectCurrency'
  coalesce(ObjectCrcyForInvoiceAmount,cast(0 as fins_vhcur12))              as ObjectCrcyForInvoiceAmount,
  @Semantics.amount.currencyCode: 'ControllingAreaCurrency'
  coalesce(CtrlgAreaCrcyForInvoiceAmount,cast(0 as fins_vhcur12))           as CtrlgAreaCrcyForInvoiceAmount,
  @Semantics.quantity.unitOfMeasure: 'UnitOfMeasure'
  coalesce(ForInvoiceQuantity,cast(0 as quan1_12))                          as ForInvoiceQuantity,

  @Semantics.amount.currencyCode: 'TransactionCurrency'
  coalesce(TransacCrcyForRjcnAmount,cast(0 as fins_vhcur12))                as TransacCrcyForRjcnAmount,
  @Semantics.amount.currencyCode: 'ControllingObjectCurrency'
  coalesce(ObjectCrcyForRjcnAmount,cast(0 as fins_vhcur12))                 as ObjectCrcyForRjcnAmount,
  @Semantics.amount.currencyCode: 'ControllingAreaCurrency'
  coalesce(CtrlgAreaCrcyForRjcnAmount,cast(0 as fins_vhcur12))              as CtrlgAreaCrcyForRjcnAmount,

  @Semantics.quantity.unitOfMeasure: 'UnitOfMeasure'
  coalesce(ForRjcnQuantity,cast(0 as quan1_12))                             as ForRjcnQuantity,
  SalesDocumentItemCurrency, //treated in next view

  @Semantics.amount.currencyCode: 'TransactionCurrency'
  coalesce(TransacCrcyInvoicedAmount,cast(0 as fins_vhcur12))               as TransacCrcyInvoicedAmount,
  @Semantics.amount.currencyCode: 'ControllingObjectCurrency'
  coalesce(ObjectCrcyInvoicedAmount,cast(0 as fins_vhcur12))                as ObjectCrcyInvoicedAmount,
  @Semantics.amount.currencyCode: 'TransactionCurrency'
  coalesce(CtrlgAreaCrcyInvoicedAmount,cast(0 as fins_vhcur12))             as CtrlgAreaCrcyInvoicedAmount,
  @Semantics.quantity.unitOfMeasure: 'UnitOfMeasure'
  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,


  @Semantics.amount.currencyCode: 'TransactionCurrency'
  coalesce(TransacCrcyRejectedAmount,cast(0 as fins_vhcur12))               as RejectedAmtInTransCrcy,
  @Semantics.amount.currencyCode: 'ControllingObjectCurrency'
  coalesce(ObjectCrcyRejectedAmount,cast(0 as fins_vhcur12))                as RejectedAmountInObjectCurrency,
  @Semantics.amount.currencyCode: 'ControllingAreaCurrency'
  coalesce(CtrlgAreaCrcyRejectedAmount,cast(0 as fins_trr_rejected_amount)) as RejectedAmountInCtrlgAreaCrcy,

  @Semantics.quantity.unitOfMeasure: 'UnitOfMeasure'
  coalesce(RejectedQuantity,cast(0 as quan1_12))                            as RejectedQuantity,
  @Semantics.amount.currencyCode: 'TransactionCurrency'
  coalesce(TransacCrcyWIPAmount,cast(0 as fins_vhcur12))                    as TransacCrcyWIPAmount,
  @Semantics.amount.currencyCode: 'ControllingObjectCurrency'
  coalesce(ObjectCrcyWIPAmount,cast(0 as fins_vhcur12))                     as ObjectCrcyWIPAmount,
  @Semantics.amount.currencyCode: 'ControllingAreaCurrency'
  coalesce(CtrlgAreaCrcyWIPAmount,cast(0 as fins_vhcur12))                  as CtrlgAreaCrcyWIPAmount,


  @Semantics.quantity.unitOfMeasure: 'UnitOfMeasure'
  coalesce(WIPQuantity,cast(0 as quan1_12))                                 as WIPQuantity,
  @Semantics.amount.currencyCode: 'TransacCurrencyInvoiceSimln'
  coalesce(TotTransacCrcyInvoiceSimlnAmt,cast(0 as fins_vhcur12))           as TotTransacCrcyInvoiceSimlnAmt,
  @Semantics.amount.currencyCode: 'ControllingObjectCurrency'
  coalesce(TotObjectCrcyInvoiceSimlnAmt,cast(0 as fins_vhcur12))            as TotObjectCrcyInvoiceSimlnAmt,
  @Semantics.amount.currencyCode: 'ControllingAreaCurrency'
  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, = ' '

  @Semantics.amount.currencyCode: 'TransacCurrencyInvoiceSimln'
  TransacCrcyInvoiceSimlnAmt,  //not null, = 0

  @Semantics.amount.currencyCode: 'ControllingObjectCurrency'
  ObjectCrcyInvoiceSimlnAmt,   //not null, = 0

  @Semantics.amount.currencyCode: 'ControllingAreaCurrency'
  CtrlgAreaCrcyInvoiceSimlnAmt //not null, = 0

};