F_Mmim_Matdoc_Item_Hm

DDL: F_MMIM_MATDOC_ITEM_HM SQL: FMMIMMATDOCITMHM Type: view
55 Fields 1 Data Sources

Matdoc Items Multi Accounting

F_Mmim_Matdoc_Item_Hm is a CDS View that provides data about "Matdoc Items Multi Accounting" in SAP S/4HANA. It reads from 1 data source (matdoc) and exposes 55 fields with key fields mblnr, mjahr, zeile.

Data Sources (1)

SourceAliasJoin Type
matdoc matdoc from

Annotations (9)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName FMMIMMATDOCITMHM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Matdoc Items Multi Accounting view

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY mblnr mblnr Material Doc.
KEY mjahr mjahr Mat. Doc. Year
KEY zeile maa_urzei Orig. Line Itm
lgort lgort Sublocation
lifnr_sid lifnr_sid Supplier SID
lifnr lifnr Vendor no.
emlif emlif Supplier
kunnr kunnr Stock customer
werks werks Receiving Plant
lbbsa_sid lbbsa_sid Stock Type
ummat ummat Receiving Mat.
umwrk umwrk Receiving plant
umlgo umlgo Receiving SLoc.
umcha umcha Receiving Batch
umbar umbar Val. Type Tfr.
lbbsa_cid lbbsa_cid Stock Type
cancelled cancelled Item Discarded
matnr matnr Vehicle Model
bwart bwart Valuation Type
grund grund Reason for mvt.
sobkz sobkz Special Stock
bwtar bwtar Valuation Type
kzbew kzbew Movement ind.
kzzug kzzug Receipt Ind.
kzvbr kzvbr Consumption
charg charg_whs_sg Batch SID
work_item_id work_item_id Work Item ID
pernr pernr Personnel no.
sgtxt sgtxt Text
knttp_gr knttp_gr Acct Assgmt Cat
vfdat vfdat SLED/BBD
hsdat hsdat Date of Manuf.
weunb weunb GR Non-Valuated
weanz weanz No. of GR Slips
nroflabels nroflabels No. of Labels
xmacc
ebeln ebeln Source PurchDoc
ebelp ebelp Item pur. doc.
vbeln_im vbeln_im Delivery
vbelp_im vbelp_im Item
shkzg shkzg Returns
erfme erfme Unit of Entry
erfmg erfmg Quantity in UnE
record_type record_type Type of Data Record
xauto xauto Auto. Item Keys
line_id
parent_id
StockSegment sgt_scat Stock Segment
ProductSeasonYear fsh_season_year Season Year
ProductSeason fsh_season Season
ProductCollection fsh_collection Collection
ProductTheme fsh_theme Theme
ewm_lgnum ewm_lgnum Warehouse No.
ewm_gmdoc ewm_gmdoc Warehouse Document
ewm_huident ewm_huident Handling Unit

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_Hm.
-- 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: FMMIMMATDOCITMHM

CREATE VIEW F_Mmim_Matdoc_Item_Hm AS
SELECT
  mblnr,
  mjahr,
  maa_urzei AS zeile,
  lgort,
  lifnr_sid,
  lifnr,
  emlif,
  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,
  work_item_id,
  pernr,
  sgtxt,
  knttp_gr,
  vfdat,
  hsdat,
  weunb,
  weanz,
  nroflabels,
  'X' AS xmacc,
  ebeln,
  ebelp,
  vbeln_im,
  vbelp_im,
  shkzg,
  erfme,
  erfmg,
  record_type,
  xauto,
  cast ('000000' as abap.numc( 6 )) AS line_id,
  cast ('000000' as abap.numc( 6 )) AS parent_id,
  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
;

Learn More