P_RU_FinStmMaterialDocument

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_RU_FinStmMaterialDocument.
-- 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: PRUFSTMMATDOC
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id

CREATE VIEW P_RU_FinStmMaterialDocument AS
SELECT
  materialDoc.mblnr AS MaterialDocument,
  materialDoc.mjahr AS MaterialDocumentYear,
  materialDoc.zeile AS MaterialDocumentItem,
  materialDoc.matnr AS Material,
  plant.ValuationArea AS ValuationArea,
  materialDoc.bwtar AS InventoryValuationType,
  materialDoc.werks AS Plant,
  materialDoc.werks AS Currency,
  cast( case materialDoc.shkzg when 'H' then materialDoc.menge * -1 else materialDoc.menge end as menge13 ) as Quantity AS mengeendasmenge13asQuantity,
  materialDoc.meins AS MaterialBaseUnit,
  materialDoc.budat AS PostingDate
FROM matdoc AS materialDoc
;