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_Trrmonwbsbase.
-- 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: PTRRMONWBSBASE
CREATE VIEW P_Trrmonwbsbase AS
SELECT
WBSElement.ProjectInternalID AS ProjectInternalID,
cast ( WBSElement.WBSElementInternalID as fins_trr_wbselementinternalid preserving type ) AS WBSElementInternalID,
eva.rldnr AS Ledger,
WBSElement.CompanyCode AS CompanyCode,
WBSElement.Project AS Project,
WBSElement.Project AS ProjectExternalID,
WBSElement._Project.ProjectDescription AS ProjectDescription,
cast ( WBSElement.WBSElement as fins_trr_billelement ) AS WBSElement,
cast ( WBSElement.WBSElement as fins_trr_billelement ) AS WBSElementExternalID,
WBSElement.WBSElementObject AS WBSElementObject,
cast ( WBSElement.ResultAnalysisInternalID as fins_trr_recgnkey ) AS ResultAnalysisInternalID,
cast ( '000' as fins_fiscalperiod ) AS FiscalPeriod,
cast ( '0000' as fis_gjahr ) AS FiscalYear,
cast ( '0000000' as fis_jahrper_conv preserving type ) AS ToFiscalYearPeriod,
cast ( WBSElement.ResponsiblePerson as fins_trr_project_manager ) AS ProjectManager,
cast ( WBSElement.ResponsiblePersonName as fins_trr_project_manager_name) AS ProjectManagerName,
cast ( WBSElement.WBSDescription as fins_trr_wbs_description ) AS WBSElementDescription,
t001.waers AS CompanyCodeCurrency,
cast ( '0000000' as fis_jahrper_conv preserving type ) AS PostingFiscalPeriod,
cast ( '00000000' as fins_trr_last_evaldat ) AS PostingDate,
cast ( '0' as fins_trr_slsded ) AS ActlSlsDeductionAmtInCCCrcy,
cast ( '0' as fins_trr_actcost ) AS RecognizableCostAmtInCCCrcy,
cast ( '0' as fins_trr_actrevn ) AS RecognizableRevenueAmtInCCCrcy,
cast ( '0' as fins_trr_revnadjust ) AS RevenueAdjustmentAmtInCCCrcy,
cast ( '0' as fins_trr_cogsadj ) AS COGSAdjustmentAmtInCCCrcy,
cast ( '0' as fins_trr_defcogs ) AS DeferredCOGSAmtInCCCrcy,
cast ( '0' as fins_trr_defrevn ) AS DeferredRevenueAmtInCCCrcy,
cast ( '0' as fins_trr_accrevn ) AS AccruedRevenueAmtInCCCrcy,
cast ( '0' as fins_trr_acccogs ) AS AccruedCOGSAmtInCCCrcy,
cast ( '0' as fins_trr_resimmloss ) AS ImminentLossRsrvAmtInCCCrcy,
cast ( '0' as fins_trr_ressalesded ) AS SalesDeductReserveAmtInCCCrcy,
cast ( '0' as fins_trr_unrealcosts ) AS UnrlzdCostsReserveAmtInCCCrcy,
cast ( '0' as fins_trr_plancos ) AS PlannedCosAmtInCCCrcy,
cast ( '0' as fins_trr_planrev ) AS PlannedRevenueAmtInCCCrcy,
cast ( '0' as fins_trr_reccogs ) AS RecognizedCOGSAmtInCCCrcy,
cast ( '0' as fins_trr_recrevn ) AS RecognizedRevnAmtInCCCrcy,
cast ( '0' as fins_trr_recmargin ) AS RecognizedMarginAmtInCCCrcy,
cast ( '0' as fins_trr_unbilledrevenue ) AS UnbilledRevnInCoCodeCrcy,
cast ( '0' as fins_trr_cntraccrbalsht_cccrcy ) AS MnlContrAccrBalShtAmtInCCCrcy,
cast ( '0' as fins_trr_cntraccrpul_cccrcy ) AS MnlContrAccrPnLItmAmtInCCCrcy
FROM I_WBSElement AS WBSElement
INNER JOIN tkkaa ON /* join condition not captured in parsed metadata */
INNER JOIN fins_trr_conseva AS eva ON /* join condition not captured in parsed metadata */
INNER JOIN t001 ON /* join condition not captured in parsed metadata */
;