P_GMAVCSetLocCurr

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_GMAVCSetLocCurr.
-- 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: PGMAVCSETLCURR
-- Parameters: P_CompanyCodeCurrency : vdm_v_company_code_currency

CREATE VIEW P_GMAVCSetLocCurr AS
SELECT
  cast($session.user as vdm_userid) AS UserID,
  cast(t1.waers as vdm_v_company_code_currency) as CompanyCodeCurrency AS userasvdm_useridasUserID,
  cast(t1.waers as vdm_v_company_code_currency) AS CompanyCodeCurrency
FROM tcurc AS t1
LEFT OUTER JOIN tcurc AS t2 ON /* join condition not captured in parsed metadata */
INNER JOIN t001 AS t0 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tcurc AS t3 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fpb_persparm AS p2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_GMAVCLDGRACTMinMax AS g1 ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): fpb_persparm, P_GMAVCLDGRACTMinMax, tcurc
;