I_Projectwipdetail

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_Projectwipdetail.
-- 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: IPROJ_DLI_WIP

CREATE VIEW I_Projectwipdetail AS
SELECT
  a.WBSElementInternalID AS WBSElementInternalID,
  a.WBSElement AS WBSElement,
  a.CostElement AS CostElement,
  a.CostCenter AS CostCenter,
  a.CostCtrActivityType AS CostCtrActivityType,
  a.Material AS Material,
  a.BusinessProcess AS BusinessProcess,
  a.PersonnelNumber AS PersonnelNumber,
  a.ManualInvoiceItem AS ManualInvoiceItem,
  a.RevenueCostElement AS RevenueCostElement,
  a.SoldMaterial AS SoldMaterial,
  a.BillingDocumentCategory AS BillingDocumentCategory,
  a.BillingPlanItemUsage AS BillingPlanItemUsage,
  a.WorkItem AS WorkItem,
  a.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
  a.AccountingIndicatorCode AS AccountingIndicatorCode,
  a.CostAnalysisResource AS CostAnalysisResource,
  a.CalendarMonth AS CalendarMonth,
  a.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  a.ResultAnalysisVersion AS ResultAnalysisVersion,
  a.ServicesRenderedDate AS ServicesRenderedDate,
  a.PostingPeriod AS PostingPeriod,
  a.ControllingDocument AS ControllingDocument,
  a.ControllingDocumentItem AS ControllingDocumentItem,
  a.TransactionCurrency AS TransactionCurrency,
  a.UnitOfMeasure AS UnitOfMeasure,
  a.SalesDocumentItemCurrency AS SalesDocumentItemCurrency,
  a.ControllingObjectCurrency AS ControllingObjectCurrency,
  a.ControllingAreaCurrency AS ControllingAreaCurrency,
  a.TransacCurrencyInvoiceSimln AS TransacCurrencyInvoiceSimln,
  a.WBSDescription AS WBSDescription,
  a.ProjectInternalID AS ProjectInternalID,
  a.Project AS Project,
  a.ProjectDescription AS ProjectDescription,
  a.CompanyCode AS CompanyCode,
  a.BusinessArea AS BusinessArea,
  a.ControllingArea AS ControllingArea,
  a.ProfitCenter AS ProfitCenter,
  a.ResultAnalysisInternalID AS ResultAnalysisInternalID,
  a.Plant AS Plant,
  a.ControllingObjectClass AS ControllingObjectClass,
  a.FunctionalArea AS FunctionalArea,
  a.ProjectManager AS ProjectManager,
  a.ProjectManagerName AS ProjectManagerName,
  a.EmployeeFullName AS EmployeeFullName,
  a.ControllingObject AS ControllingObject,
  a.CreationDate AS CreationDate,
  a.BillableAmountInTransacCrcy AS BillableAmountInTransacCrcy,
  a.BillableAmountInCtrlgObjCrcy AS BillableAmountInCtrlgObjCrcy,
  a.BillableAmountInCtrlgAreaCrcy AS BillableAmountInCtrlgAreaCrcy,
  a.BillableQuantity AS BillableQuantity,
  a.NonBillableAmountInTransacCrcy AS NonBillableAmountInTransacCrcy,
  a.NonBllbleAmtInCtrlgObjCurrency AS NonBllbleAmtInCtrlgObjCurrency,
  a.NonBillableAmtInCtrlgAreaCrcy AS NonBillableAmtInCtrlgAreaCrcy,
  a.NonBillableQuantity AS NonBillableQuantity,
  a.TransacCrcyInvoicedAmount AS TransacCrcyInvoicedAmount,
  a.ObjectCrcyInvoicedAmount AS ObjectCrcyInvoicedAmount,
  a.CtrlgAreaCrcyInvoicedAmount AS CtrlgAreaCrcyInvoicedAmount,
  a.InvoicedQuantity AS InvoicedQuantity,
  a.RejectedAmtInTransCrcy AS RejectedAmtInTransCrcy,
  a.RejectedAmountInObjectCurrency AS RejectedAmountInObjectCurrency,
  a.RejectedAmountInCtrlgAreaCrcy AS RejectedAmountInCtrlgAreaCrcy,
  a.RejectedQuantity AS RejectedQuantity,
  a.TransacCrcyWIPAmount AS TransacCrcyWIPAmount,
  a.ObjectCrcyWIPAmount AS ObjectCrcyWIPAmount,
  a.CtrlgAreaCrcyWIPAmount AS CtrlgAreaCrcyWIPAmount,
  a.WIPQuantity AS WIPQuantity,
  a.TotTransacCrcyInvoiceSimlnAmt AS TotTransacCrcyInvoiceSimlnAmt,
  a.TotObjectCrcyInvoiceSimlnAmt AS TotObjectCrcyInvoiceSimlnAmt,
  a.TotCtrlgAreaCrcyInvcSimlnAmt AS TotCtrlgAreaCrcyInvcSimlnAmt,
  a.TransacCrcyInvoiceSimlnAmt AS TransacCrcyInvoiceSimlnAmt,
  a.ObjectCrcyInvoiceSimlnAmt AS ObjectCrcyInvoiceSimlnAmt,
  a.CtrlgAreaCrcyInvoiceSimlnAmt AS CtrlgAreaCrcyInvoiceSimlnAmt,
  a._EntProjProjectRespPersn AS _EntProjProjectRespPersn,
  a._ResponsiblePerson AS _ResponsiblePerson,
  a.ProjectResponsiblePerson AS ProjectResponsiblePerson
FROM P_Projectwipdetailbasic AS a
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON UnitOfMeasure = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _SalesDocumentItemCurrency ON SalesDocumentItemCurrency = _SalesDocumentItemCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ControllingObjectCurrency ON ControllingObjectCurrency = _ControllingObjectCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ControllingAreaCurrency ON ControllingAreaCurrency = _ControllingAreaCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransacCurrencyInvoiceSimln ON TransacCurrencyInvoiceSimln = _TransacCurrencyInvoiceSimln.Currency  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
;