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_Trrmonbase.
-- 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: PTRRMONBASE
-- Parameters: P_ToFiscalYearPeriod : fis_tojahrper_c
CREATE VIEW P_Trrmonbase AS
SELECT
WBSElement.ProjectInternalID AS ProjectInternalID,
cast ( WBSElement.WBSElementInternalID as fins_trr_wbselementinternalid preserving type ) AS WBSElementInternalID,
semtag.Ledger AS Ledger,
semtag.CompanyCode AS CompanyCode,
WBSElement.WBSElementObject AS WBSElementObject,
cast ( WBSElement.Project as ps_pspid_edit preserving type ) AS ProjectExternalID,
WBSElement._Project.ProjectDescription AS ProjectDescription,
cast ( WBSElement.WBSElement as ps_posid_edit preserving type ) AS WBSElementExternalID,
cast ( WBSElement.ResultAnalysisInternalID as fins_trr_recgnkey preserving type ) AS ResultAnalysisInternalID,
cast ( '000' as fins_fiscalperiod preserving type ) AS FiscalPeriod,
cast ( '0000' as fis_gjahr preserving type) AS FiscalYear,
cast ( semtag.FiscalYearPeriod as fis_jahrper_conv preserving type ) AS ToFiscalYearPeriod,
cast ( WBSElement.ResponsiblePerson as fins_trr_project_manager preserving type ) AS ProjectManager,
cast ( WBSElement.ResponsiblePersonName as fins_trr_project_manager_name preserving type ) AS ProjectManagerName,
cast ( WBSElement.WBSDescription as fins_trr_wbs_description preserving type ) AS WBSElementDescription,
semtag.CompanyCodeCurrency AS CompanyCodeCurrency,
cast ( lifecyc.PostingFiscalPeriod as fis_jahrper_conv preserving type ) AS PostingFiscalPeriod,
cast ( lifecyc.PostingDate as fins_trr_last_evaldat preserving type ) AS PostingDate,
0 AS PlannedCosAmtInCCCrcy,
0 AS PlannedRevenueAmtInCCCrcy
FROM I_WBSElement AS WBSElement
INNER JOIN P_TRRMONWBSUNION AS wbsunion ON /* join condition not captured in parsed metadata */
INNER JOIN tkkaa ON /* join condition not captured in parsed metadata */
INNER JOIN I_GLAccountLineItem AS semtag ON /* join condition not captured in parsed metadata */
INNER JOIN I_SemTagGLAccount AS semTagGl ON /* join condition not captured in parsed metadata */
INNER JOIN I_EvtBsdRevnRecgnEvalScp AS evalscp ON /* join condition not captured in parsed metadata */
;