F_Mmim_Matdoc_Item_Ha

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_Item_Ha.
-- 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: FMMIMMATDOCITMHA

CREATE VIEW F_Mmim_Matdoc_Item_Ha AS
SELECT
  mblnr,
  mjahr,
  zeile,
  lgort,
  lifnr_sid,
  lifnr,
  emlif,
  mat_kdauf,
  kdauf,
  mat_kdpos,
  kdpos,
  kunnr,
  werks,
  lbbsa_sid,
  ummat,
  umwrk,
  umlgo,
  umcha,
  umbar,
  lbbsa_cid,
  cancelled,
  matnr,
  bwart,
  grund,
  sobkz,
  bwtar,
  kzbew,
  kzzug,
  kzvbr,
  charg_whs_sg AS charg,
  aufnr,
  work_item_id,
  pernr,
  sgtxt,
  knttp_gr,
  vfdat,
  hsdat,
  weunb,
  xmacc,
  ebeln,
  ebelp,
  vbeln_im,
  vbelp_im,
  mat_pspnr,
  ps_psp_pnr,
  shkzg,
  erfme,
  erfmg,
  line_id,
  parent_id,
  weanz,
  nroflabels,
  sgt_scat AS StockSegment,
  fsh_season_year AS ProductSeasonYear,
  fsh_season AS ProductSeason,
  fsh_collection AS ProductCollection,
  fsh_theme AS ProductTheme,
  ewm_lgnum,
  ewm_gmdoc,
  ewm_huident
FROM matdoc
-- UNION ALL with additional select branch(es): F_Mmim_Matdoc_Item_Hm
;