P_Projectwiprevdetlbasic

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 P_Projectwiprevdetlbasic.
-- 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.
-- SQL view name: PPROJ_DLIWPRV_BS

CREATE VIEW P_Projectwiprevdetlbasic AS
SELECT
  a.PostingPeriod AS PostingPeriod,
  a.TransactionCurrency AS TransactionCurrency,
  a.UnitOfMeasure AS UnitOfMeasure,
  a.CostElement AS CostElement,
  a.CostCenter AS CostCenter,
  a.CostCtrActivityType AS CostCtrActivityType,
  a.Material AS Material,
  a.BusinessProcess AS BusinessProcess,
  a.PersonnelNumber AS PersonnelNumber,
  e.bldat AS DocumentDate,
  cast ( a.ManualInvoiceItem as pro_dw_man_item ) AS ManualInvoiceItem,
  a.ControllingObject AS ControllingObject,
  cast ( ( a.TransacCrcyForInvoiceAmount - a.TransacCrcyInvoicedAmount ) as pro_dw_in_wtgbtr ) AS TransacCrcyForInvoiceAmount,
  cast ( ( a.ObjectCrcyForInvoiceAmount - a.ObjectCrcyInvoicedAmount ) as pro_dw_in_wogbtr ) AS ObjectCrcyForInvoiceAmount,
  cast ( ( a.CtrlgAreaCrcyForInvoiceAmount - a.CtrlgAreaCrcyInvoicedAmount )as pro_dw_in_wkgbtr ) AS CtrlgAreaCrcyForInvoiceAmount,
  cast ( ( a.ForInvoiceQuantity - a.InvoicedQuantity ) as pro_dw_in_quantity ) AS ForInvoiceQuantity,
  cast ( a.TransacCrcyForRjcnAmount as pro_dw_no_wtgbtr ) AS TransacCrcyForRjcnAmount,
  cast ( a.ObjectCrcyForRjcnAmount as pro_dw_no_wogbtr ) AS ObjectCrcyForRjcnAmount,
  cast ( a.CtrlgAreaCrcyForRjcnAmount as pro_dw_no_wkgbtr ) AS CtrlgAreaCrcyForRjcnAmount,
  cast ( a.ForRjcnQuantity as pro_dw_no_quantity ) AS ForRjcnQuantity,
  a.SalesDocumentItemCurrency AS SalesDocumentItemCurrency,
  cast ( a.TransacCrcyInvoicedAmount as ad01abc_wtg ) AS TransacCrcyInvoicedAmount,
  cast ( a.ObjectCrcyInvoicedAmount as ad01abc_wog ) AS ObjectCrcyInvoicedAmount,
  cast ( a.CtrlgAreaCrcyInvoicedAmount as ad01abc_wkg ) AS CtrlgAreaCrcyInvoicedAmount,
  cast ( a.InvoicedQuantity as ad01abc_meg ) AS InvoicedQuantity,
  cast ( a.TransacCrcyRejectedAmount as ad01noc_wtg ) AS TransacCrcyRejectedAmount,
  cast ( a.ObjectCrcyRejectedAmount as ad01noc_wog ) AS ObjectCrcyRejectedAmount,
  cast ( a.CtrlgAreaCrcyRejectedAmount as ad01noc_wkg ) AS CtrlgAreaCrcyRejectedAmount,
  cast ( a.RejectedQuantity as ad01noc_meg ) AS RejectedQuantity,
  cast ( a.TransacCrcyWIPAmount as ad01tbc_wtg ) AS TransacCrcyWIPAmount,
  cast ( a.ObjectCrcyWIPAmount as ad01tbc_wog ) AS ObjectCrcyWIPAmount,
  cast ( a.CtrlgAreaCrcyWIPAmount as ad01tbc_wkg ) AS CtrlgAreaCrcyWIPAmount,
  cast ( a.WIPQuantity as ad01tbc_meg ) AS WIPQuantity,
  cast ( a.TotTransacCrcyInvoiceSimlnAmt as ad01rev_wtg ) AS TotTransacCrcyInvoiceSimlnAmt,
  cast ( a.TotObjectCrcyInvoiceSimlnAmt as pro_dw_revsim_wogbtr ) AS TotObjectCrcyInvoiceSimlnAmt,
  cast ( a.TotCtrlgAreaCrcyInvcSimlnAmt as ad01rev_wkg ) AS TotCtrlgAreaCrcyInvcSimlnAmt,
  cast ( a.RevenueCostElement as pro_dw_rev_kstar ) AS RevenueCostElement,
  cast ( a.SoldMaterial as pro_dw_rev_matnr ) AS SoldMaterial,
  cast ( a.TransacCrcyInvoiceSimlnAmt as ad01rev_wtg ) AS TransacCrcyInvoiceSimlnAmt,
  cast ( a.ObjectCrcyInvoiceSimlnAmt as ad01rev_wog ) AS ObjectCrcyInvoiceSimlnAmt,
  cast ( a.CtrlgAreaCrcyInvoiceSimlnAmt as ad01rev_wkg ) AS CtrlgAreaCrcyInvoiceSimlnAmt,
  a.ControllingObjectCurrency AS ControllingObjectCurrency,
  a.ControllingAreaCurrency AS ControllingAreaCurrency,
  a.TransacCurrencyInvoiceSimln AS TransacCurrencyInvoiceSimln,
  a.ResultAnalysisVersion AS ResultAnalysisVersion,
  b.pspnr AS WBSElementInternalID,
  b.posid AS WBSElement,
  b.post1 AS WBSDescription,
  c.pspnr AS ProjectInternalID,
  c.pspid AS Project,
  c.post1 AS ProjectDescription,
  b.pbukr AS CompanyCode,
  b.pgsbr AS BusinessArea,
  b.pkokr AS ControllingArea,
  b.prctr AS ProfitCenter,
  cast(' ' as abgr_schl) AS ResultAnalysisInternalID,
  b.werks AS Plant,
  cast ( b.scope as scope preserving type ) AS ControllingObjectClass,
  b.func_area AS FunctionalArea,
  cast(' ' as saknr_soll) AS ProfitLossAccountUnbilledRev,
  z.sakha AS BlanceSheetAccountUnbilledRev
FROM P_Wipdetailbasic AS a
INNER JOIN prps AS b ON /* join condition not captured in parsed metadata */
INNER JOIN proj AS c ON /* join condition not captured in parsed metadata */
INNER JOIN tka01 AS d ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cobk AS e ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_Wiprevdetsrvkb AS z ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_Wiprevdetailbasic
;