I_RO_SAFTMaterialDocumentItem

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 I_RO_SAFTMaterialDocumentItem.
-- 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: IROSAFTMATDOC

CREATE VIEW I_RO_SAFTMaterialDocumentItem AS
SELECT
  _Matdoc.mblnr AS MaterialDocument,
  _Matdoc.mjahr AS MaterialDocumentYear,
  _Matdoc.record_type AS MaterialDocumentRecordType,
  cast(_Matdoc.zeile as nsdm_mblpo preserving type) AS MaterialDocumentItem,
  cast(_Matdoc.line_id as nsdm_mb_line_id preserving type ) AS MaterialDocumentLine,
  cast(_Matdoc.matbf as nsdm_matbf preserving type ) AS StockIdentifyingMaterial,
  _Matdoc.werks AS Plant,
  _Matdoc.lifnr AS Supplier,
  cast(_Matdoc.kunnr as nsdm_ekunn preserving type ) AS Customer,
  cast(_Matdoc.sobkz as nsdm_spcl_stock_type preserving type ) AS ProjectNetworkHasSpecialStock,
  _Matdoc.bukrs AS CompanyCode,
  _Matdoc.erfme AS EntryUnit,
  _Matdoc.erfmg AS GoodsMovementEntryQty,
  _Matdoc.budat AS PostingDate,
  _Matdoc.matnr AS Product,
  cast(_Matdoc.dmbtr_stock as nsdm_dmbtr_stock_l preserving type ) AS GoodsMovementStkAmtInCCCrcy,
  cast(_Matdoc.waers as nsdm_comp_code_currency preserving type ) AS CompanyCodeCurrency,
  _Matdoc.stock_qty AS MatlStkChangeQtyInBaseUnit,
  _Matdoc.menge AS GoodsMovementQuantity,
  _Matdoc.meins AS AlternativeUnit,
  cast(_Matdoc.gjahr as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  _Matdoc.bldat AS DocumentDate,
  _Matdoc.xblnr AS DocumentReferenceID,
  _Matdoc.charg AS Batch,
  _Matdoc.lgort AS StorageLocation,
  _Matdoc.bwart AS GoodsMovementType,
  _Matdoc.bwtar AS InventoryValuationType,
  _Matdoc.shkzg AS DebitCreditCode,
  _Matdoc.sakto AS ActiveGLAccount,
  _Matdoc.blart AS AccountingDocumentType,
  _Matdoc.sgtxt AS MaterialDocumentItemText,
  _Matdoc.usnam AS CreatedByUser,
  _Matdoc.vgart AS MaterialLedgerTransactionType,
  cast(concat( _Matdoc.mblnr, _Matdoc.mjahr) as fac_awkey) AS OriginalReferenceDocument,
  _Valuation.ValuationClass AS ValuationClass
FROM matdoc AS _Matdoc
INNER JOIN t001w AS _Plant ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RO_SAFTProductValuation AS _Valuation ON _Matdoc.matbf = _Valuation.Product AND _Plant.bwkey = _Valuation.ValuationArea AND _Matdoc.bwtar = _Valuation.ValuationType  -- association [0..1]
;