P_RTPCOrderPostedVariance

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_RTPCOrderPostedVariance.
-- 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: PFIRTPCORPOVARC

CREATE VIEW P_RTPCOrderPostedVariance AS
SELECT
  aufnr AS OrderID,
  aufnr_org AS Origin_OrderID,
  aufps AS OrderItem,
  rldnr AS Ledger,
  slalittype AS SubLedgerAcctLineItemType,
  varc_uacct AS OriginGLAccount,
  umatnr AS OriginMaterial,
  ukostl AS OriginCostCenter,
  ulstar AS OriginCostCenterActivityType,
  varc_hkgrp AS CostOriginGroup,
  rrunit AS Unit,
  paobjnr AS ProfitabilitySegment,
  fiscyearper AS FiscalYearPeriod,
  xreversed,
  xreversing,
  sum(_item.msl) AS ValuationQuantity,
  sum( hsl ) AS hsl,
  sum( ksl ) AS ksl,
  sum( osl ) AS osl,
  sum( vsl ) AS vsl,
  sum( bsl ) AS bsl,
  sum( csl ) AS csl,
  sum( dsl ) AS dsl,
  sum( esl ) AS esl,
  sum( fsl ) AS fsl,
  sum( gsl ) AS gsl,
  sum( kfsl ) AS kfsl,
  sum( vmsl ) AS vmsl,
  sum( rmsl ) AS rmsl
FROM acdoca AS _item
INNER JOIN I_Ledger AS _ledger ON /* join condition not captured in parsed metadata */
;