I_FldLogsMatlDocumentRecord

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_FldLogsMatlDocumentRecord.
-- 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.

CREATE VIEW I_FldLogsMatlDocumentRecord AS
SELECT
  mblnr AS MaterialDocument,
  mjahr AS MaterialDocumentYear,
  zeile AS MaterialDocumentItem,
  menge AS QuantityInBaseUnit,
  meins AS MaterialBaseUnit,
  ebeln AS PurchaseOrder,
  ebelp AS PurchaseOrderItem,
  bwart AS GoodsMovementType,
  cast(sjahr as nsdm_sjahr preserving type) AS ReversedMaterialDocumentYear,
  cast(smbln as nsdm_smbln preserving type) AS ReversedMaterialDocument,
  cast(smblp as nsdm_smblp preserving type) AS ReversedMaterialDocumentItem,
  matnr AS Material,
  record_type AS MaterialDocumentRecordType,
  header_counter AS IsMaterialDocumentHeader,
  werks AS Plant,
  cast(umwrk as nsdm_plant preserving type) AS IssuingOrReceivingPlant,
  vbeln_im AS DeliveryDocument,
  vbelp_im AS DeliveryDocumentItem,
  cancelled AS GoodsMovementIsCancelled,
  reversal_movement AS IsReversalMovementType,
  erfme AS EntryUnit,
  erfmg AS QuantityInEntryUnit,
  xauto AS IsAutomaticallyCreated,
  matbf AS StockIdentifyingMaterial,
  lbbsa_sid AS InventoryStockType,
  lgort_sid AS StockIdfgStorageLocation,
  cast(mat_pspnr as ps_s4_pspnr ) AS SpecialStockIdfgWBSElement,
  stock_qty AS MatlStkChangeQtyInBaseUnit,
  charg_sid AS Batch,
  bwtar AS ValuationType,
  budat AS PostingDate,
  bstme AS OrderQuantityUnit,
  rsnum AS Reservation,
  rspos AS ReservationItem,
  aufnr AS OrderID,
  nplnr AS ProjectNetwork
FROM matdoc
;