WCB_DDL_MKPF_MSEG

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 WCB_DDL_MKPF_MSEG.
-- 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: WCB_V_MATDOC

CREATE VIEW WCB_DDL_MKPF_MSEG AS
SELECT
  MKPF.mandt AS MANDT,
  MKPF.mblnr AS MBLNR,
  MKPF.mjahr AS MJAHR,
  MKPF.vgart AS VGART,
  MKPF.blart AS BLART,
  MKPF.blaum AS BLAUM,
  MKPF.bldat AS BLDAT,
  MKPF.budat AS BUDAT,
  MKPF.cpudt AS CPUDT,
  MKPF.cputm AS CPUTM,
  MKPF.aedat AS AEDAT,
  MKPF.usnam AS USNAM,
  MKPF.tcode AS TCODE,
  MKPF.xblnr AS XBLNR,
  MKPF.bktxt AS BKTXT,
  MKPF.frath AS FRATH,
  MKPF.frbnr AS FRBNR,
  MKPF.wever AS WEVER,
  MKPF.xabln AS XABLN,
  MKPF.awsys AS AWSYS,
  MKPF.bla2d AS BLA2D,
  MKPF.tcode2 AS TCODE2,
  MKPF.bfwms AS BFWMS,
  MKPF.exnum AS EXNUM,
  MKPF.spe_budat_uhr AS SPE_BUDAT_UHR,
  MKPF.spe_budat_zone AS SPE_BUDAT_ZONE,
  MKPF.le_vbeln AS LE_VBELN,
  MKPF.spe_logsys AS SPE_LOGSYS,
  MKPF.spe_mdnum_ewm AS SPE_MDNUM_EWM,
  MKPF.gts_cusref_no AS GTS_CUSREF_NO,
  MKPF.fls_rsto AS FLS_RSTO,
  MKPF.msr_active AS MSR_ACTIVE,
  MKPF.knumv AS KNUMV,
  MSEG.zeile AS ZEILE,
  MSEG.line_id AS LINE_ID,
  MSEG.parent_id AS PARENT_ID,
  MSEG.line_depth AS LINE_DEPTH,
  MSEG.maa_urzei AS MAA_URZEI,
  MSEG.bwart AS BWART,
  MSEG.xauto AS XAUTO,
  MSEG.matnr AS MATNR,
  MSEG.werks AS WERKS,
  MSEG.lgort AS LGORT,
  MSEG.charg AS CHARG,
  MSEG.insmk AS INSMK,
  MSEG.zusch AS ZUSCH,
  MSEG.zustd AS ZUSTD,
  MSEG.sobkz AS SOBKZ,
  MSEG.lifnr AS LIFNR,
  MSEG.kunnr AS KUNNR,
  MSEG.kdauf AS KDAUF,
  MSEG.kdpos AS KDPOS,
  MSEG.kdein AS KDEIN,
  MSEG.plpla AS PLPLA,
  MSEG.shkzg AS SHKZG,
  MSEG.waers AS WAERS,
  MSEG.dmbtr AS DMBTR,
  MSEG.bnbtr AS BNBTR,
  MSEG.bualt AS BUALT,
  MSEG.shkum AS SHKUM,
  MSEG.dmbum AS DMBUM,
  MSEG.bwtar AS BWTAR,
  MSEG.menge AS MENGE,
  MSEG.meins AS MEINS,
  MSEG.erfmg AS ERFMG,
  MSEG.erfme AS ERFME,
  MSEG.bpmng AS BPMNG,
  MSEG.bprme AS BPRME,
  MSEG.ebeln AS EBELN,
  MSEG.ebelp AS EBELP,
  MSEG.lfbja AS LFBJA,
  MSEG.lfbnr AS LFBNR,
  MSEG.lfpos AS LFPOS,
  MSEG.sjahr AS SJAHR,
  MSEG.smbln AS SMBLN,
  MSEG.smblp AS SMBLP,
  MSEG.elikz AS ELIKZ,
  MSEG.sgtxt AS SGTXT,
  MSEG.equnr AS EQUNR,
  MSEG.wempf AS WEMPF,
  MSEG.ablad AS ABLAD,
  MSEG.gsber AS GSBER,
  MSEG.kokrs AS KOKRS,
  MSEG.pargb AS PARGB,
  MSEG.parbu AS PARBU,
  MSEG.kostl AS KOSTL,
  MSEG.projn AS PROJN,
  MSEG.aufnr AS AUFNR,
  MSEG.anln1 AS ANLN1,
  MSEG.anln2 AS ANLN2,
  MSEG.xskst AS XSKST,
  MSEG.xsauf AS XSAUF,
  MSEG.xspro AS XSPRO,
  MSEG.xserg AS XSERG,
  MSEG.gjahr AS GJAHR,
  MSEG.xruem AS XRUEM,
  MSEG.xruej AS XRUEJ,
  MSEG.bukrs AS BUKRS,
  MSEG.belnr AS BELNR,
  MSEG.buzei AS BUZEI,
  MSEG.belum AS BELUM,
  MSEG.buzum AS BUZUM,
  MSEG.rsnum AS RSNUM,
  MSEG.rspos AS RSPOS,
  MSEG.kzear AS KZEAR,
  MSEG.pbamg AS PBAMG,
  MSEG.kzstr AS KZSTR,
  MSEG.ummat AS UMMAT,
  MSEG.umwrk AS UMWRK,
  MSEG.umlgo AS UMLGO,
  MSEG.umcha AS UMCHA,
  MSEG.umzst AS UMZST,
  MSEG.umzus AS UMZUS,
  MSEG.umbar AS UMBAR,
  MSEG.umsok AS UMSOK,
  MSEG.kzbew AS KZBEW,
  MSEG.kzvbr AS KZVBR,
  MSEG.kzzug AS KZZUG,
  MSEG.weunb AS WEUNB,
  MSEG.palan AS PALAN,
  MSEG.lgnum AS LGNUM,
  MSEG.lgtyp AS LGTYP,
  MSEG.lgpla AS LGPLA,
  MSEG.bestq AS BESTQ,
  MSEG.bwlvs AS BWLVS,
  MSEG.tbnum AS TBNUM,
  MSEG.tbpos AS TBPOS,
  MSEG.xblvs AS XBLVS,
  MSEG.vschn AS VSCHN,
  MSEG.nschn AS NSCHN,
  MSEG.dypla AS DYPLA,
  MSEG.ubnum AS UBNUM,
  MSEG.tbpri AS TBPRI,
  MSEG.tanum AS TANUM,
  MSEG.weanz AS WEANZ,
  MSEG.grund AS GRUND,
  MSEG.evers AS EVERS,
  MSEG.evere AS EVERE,
  MSEG.imkey AS IMKEY,
  MSEG.kstrg AS KSTRG,
  MSEG.paobjnr AS PAOBJNR,
  MSEG.prctr AS PRCTR,
  MSEG.ps_psp_pnr AS PS_PSP_PNR,
  MSEG.nplnr AS NPLNR,
  MSEG.aufpl AS AUFPL,
  MSEG.aplzl AS APLZL,
  MSEG.aufps AS AUFPS,
  MSEG.vptnr AS VPTNR,
  MSEG.fipos AS FIPOS,
  MSEG.sakto AS SAKTO,
  MSEG.bstmg AS BSTMG,
  MSEG.bstme AS BSTME,
  MSEG.xwsbr AS XWSBR,
  MSEG.emlif AS EMLIF,
  MSEG.exbwr AS EXBWR,
  MSEG.vkwrt AS VKWRT,
  MSEG.aktnr AS AKTNR,
  MSEG.zekkn AS ZEKKN,
  MSEG.vfdat AS VFDAT,
  MSEG.cuobj_ch AS CUOBJ_CH,
  MSEG.exvkw AS EXVKW,
  MSEG.pprctr AS PPRCTR,
  MSEG.rsart AS RSART,
  MSEG.geber AS GEBER,
  MSEG.fistl AS FISTL,
  MSEG.matbf AS MATBF,
  MSEG.ummab AS UMMAB,
  MSEG.bustm AS BUSTM,
  MSEG.bustw AS BUSTW,
  MSEG.mengu AS MENGU,
  MSEG.wertu AS WERTU,
  MSEG.lbkum AS LBKUM,
  MSEG.salk3 AS SALK3,
  MSEG.vprsv AS VPRSV,
  MSEG.fkber AS FKBER,
  MSEG.dabrbz AS DABRBZ,
  MSEG.vkwra AS VKWRA,
  MSEG.dabrz AS DABRZ,
  MSEG.xbeau AS XBEAU,
  MSEG.lsmng AS LSMNG,
  MSEG.lsmeh AS LSMEH,
  MSEG.kzbws AS KZBWS,
  MSEG.qinspst AS QINSPST,
  MSEG.urzei AS URZEI,
  MSEG.j_1bexbase AS J_1BEXBASE,
  MSEG.mwskz AS MWSKZ,
  MSEG.txjcd AS TXJCD,
  MSEG.ematn AS EMATN,
  MSEG.j_1agirupd AS J_1AGIRUPD,
  MSEG.vkmws AS VKMWS,
  MSEG.hsdat AS HSDAT,
  MSEG.berkz AS BERKZ,
  MSEG.mat_kdauf AS MAT_KDAUF,
  MSEG.mat_kdpos AS MAT_KDPOS,
  MSEG.mat_pspnr AS MAT_PSPNR,
  MSEG.xwoff AS XWOFF,
  MSEG.bemot AS BEMOT,
  MSEG.prznr AS PRZNR,
  MSEG.llief AS LLIEF,
  MSEG.lstar AS LSTAR,
  MSEG.xobew AS XOBEW,
  MSEG.grant_nbr AS GRANT_NBR,
  MSEG.zustd_t156m AS ZUSTD_T156M,
  MSEG.spe_gts_stock_ty AS SPE_GTS_STOCK_TY,
  MSEG.kblnr AS KBLNR,
  MSEG.kblpos AS KBLPOS,
  MSEG.xmacc AS XMACC,
  MSEG.vgart_mkpf AS VGART_MKPF,
  MSEG.budat_mkpf AS BUDAT_MKPF,
  MSEG.cpudt_mkpf AS CPUDT_MKPF,
  MSEG.cputm_mkpf AS CPUTM_MKPF,
  MSEG.usnam_mkpf AS USNAM_MKPF,
  MSEG.xblnr_mkpf AS XBLNR_MKPF,
  MSEG.tcode2_mkpf AS TCODE2_MKPF,
  MSEG.vbeln_im AS VBELN_IM,
  MSEG.vbelp_im AS VBELP_IM,
  MSEG.sgt_scat AS SGT_SCAT,
  MSEG.sgt_umscat AS SGT_UMSCAT,
  MSEG.sgt_rcat AS SGT_RCAT,
  MSEG.oinavnw AS OINAVNW,
  MSEG.oicondcod AS OICONDCOD,
  MSEG.condi AS CONDI
FROM nsdm_e_MKPF AS MKPF
INNER JOIN nsdm_e_mseg AS MSEG ON /* join condition not captured in parsed metadata */
;