P_IRM_PositionValues

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_IRM_PositionValues.
-- 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: PPOSVAL
-- Parameters: P_KeyDate : vdm_v_key_date

CREATE VIEW P_IRM_PositionValues AS
SELECT
  PositionValue.CompanyCode AS CompanyCode,
  PositionValue.FinancialTransaction AS FinancialTransaction,
  PositionValue.SecurityAccount AS SecurityAccount,
  PositionValue.SecurityClass AS SecurityClass,
  PositionValue.SecurityAccountGroup AS SecurityAccountGroup,
  ProductGroup.FinancialInstrProductCategory AS FinancialInstrProductCategory,
  PositionValue.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  PositionValue.TreasuryPosAssetLiabilityCode AS TreasuryPosAssetLiabilityCode,
  PositionValue.PositionCurrency AS PositionCurrency,
  PositionValue.NominalCurrency AS NominalCurrency,
  PositionValue.BookValueAmtInPositionCurrency AS BookValueAmtInPositionCurrency,
  PositionValue._CompanyCode AS _CompanyCode,
  PositionValue._SecurityAccount AS _SecurityAccount,
  PositionValue._SecurityClass AS _SecurityClass,
  PositionValue._SecurityAccountGroup AS _SecurityAccountGroup
FROM I_FinInstrProductGroup AS ProductGroup
INNER JOIN I_Ftr_Position_Values AS PositionValue ON /* join condition not captured in parsed metadata */
INNER JOIN I_PayingValuationArea AS PayingValuationArea ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Currency AS _NominalCurrency ON NominalCurrency = _NominalCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _PositionCurrency ON PositionCurrency = _PositionCurrency.Currency  -- association [1..1]
;