I_WorkInProcessDetail

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_WorkInProcessDetail.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_WorkInProcessDetail AS
SELECT
  PostingPeriod,
  TransactionCurrency,
  UnitOfMeasure,
  CostElement,
  CostCenter,
  CostCtrActivityType,
  Material,
  BusinessProcess,
  PersonnelNumber,
  ManualInvoiceItem,
  ProfitCenter,
  ControllingObject,
  ControllingDocument,
  ControllingDocumentItem,
  BillingDocumentCategory,
  BillingPlanItemUsage,
  WorkItem,
  EngagementProjectServiceOrg,
  AccountingIndicatorCode,
  CostAnalysisResource,
  CalendarMonth,
  TimeSheetOvertimeCategory,
  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,
  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 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,
  ControllingAreaCurrency,
  TransacCurrencyInvoiceSimln,
  RevenueCostElement,
  SoldMaterial,
  TransacCrcyInvoiceSimlnAmt,
  ObjectCrcyInvoiceSimlnAmt,
  CtrlgAreaCrcyInvoiceSimlnAmt
FROM P_Wipdetailbasic
;