F_Mmim_Matdoc

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 F_Mmim_Matdoc.
-- 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 F_Mmim_Matdoc AS
SELECT
  mblnr AS MaterialDocument,
  mjahr AS MaterialDocumentYear,
  zeile AS MaterialDocumentItem,
  matbf AS Material,
  cast(werks as werks_d) AS Plant,
  charg AS Batch,
  lbbsa_sid AS InventoryStockType,
  lgort AS StorageLocation,
  kunnr AS Customer,
  umwrk AS IssuingOrReceivingPlant,
  umlgo AS IssuingOrReceivingStorageLoc,
  lbbsa_cid AS IssuingOrReceivingStockType,
  vbeln_im AS DeliveryDocument,
  ebeln AS PurchaseOrder,
  aufnr AS OrderID,
  usnam AS CreatedByUser,
  pernr AS PersonnelNumber,
  work_item_id AS WorkItem,
  bwart AS GoodsMovementType,
  erfme AS EntryUnit,
  blart AS AccountingDocumentType,
  sobkz AS InventorySpecialStockType,
  sgt_scat AS StockSegment,
  cast(rsnum as nsdm_rsnum preserving type ) AS Reservation,
  fsh_season_year AS ProductSeasonYear,
  fsh_season AS ProductSeason,
  fsh_collection AS ProductCollection,
  fsh_theme AS ProductTheme
FROM matdoc
;