VC_INTEGRATION_MARA

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 VC_INTEGRATION_MARA.
-- 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: VCIMARA

CREATE VIEW VC_INTEGRATION_MARA AS
SELECT
  MATNR,
  ERSDA,
  CREATED_AT_TIME,
  LAEDA,
  VPSTA,
  PSTAT,
  LVORM,
  MTART,
  MBRSH,
  MATKL,
  BISMT,
  MEINS,
  BSTME,
  ZEINR,
  ZEIAR,
  ZEIVR,
  ZEIFO,
  AESZN,
  BLATT,
  BLANZ,
  FERTH,
  FORMT,
  GROES,
  WRKST,
  NORMT,
  LABOR,
  EKWSL,
  BRGEW,
  NTGEW,
  GEWEI,
  VOLUM,
  VOLEH,
  BEHVO,
  RAUBE,
  TEMPB,
  DISST,
  TRAGR,
  STOFF,
  SPART,
  EANNR,
  WESCH,
  BWVOR,
  BWSCL,
  SAISO,
  ETIAR,
  ETIFO,
  ENTAR,
  EAN11,
  NUMTP,
  LAENG,
  BREIT,
  HOEHE,
  MEABM,
  PRDHA,
  AEKLK,
  CADKZ,
  QMPUR,
  ERGEW,
  ERGEI,
  ERVOL,
  ERVOE,
  GEWTO,
  VOLTO,
  VABME,
  KZREV,
  KZKFG,
  XCHPF,
  VHART,
  FUELG,
  STFAK,
  MAGRV,
  BEGRU,
  DATAB,
  LIQDT,
  SAISJ,
  PLGTP,
  MLGUT,
  EXTWG,
  SATNR,
  ATTYP,
  KZKUP,
  KZNFM,
  PMATA,
  MSTAE,
  MSTAV,
  MSTDE,
  MSTDV,
  TAKLV,
  RBNRM,
  MHDRZ,
  MHDHB,
  MHDLP,
  INHME,
  INHAL,
  VPREH,
  ETIAG,
  INHBR,
  CMETH,
  CUOBF,
  KZUMW,
  KOSCH,
  SPROF,
  NRFHG,
  MFRPN,
  BMATN,
  MPROF,
  KZWSM,
  SAITY,
  PROFL,
  IHIVI,
  ILOOS,
  SERLV,
  KZGVH,
  XGCHP,
  KZEFF,
  COMPL,
  IPRKZ,
  RDMHD,
  PRZUS,
  MTPOS_MARA,
  BFLME,
  MATFI,
  CMREL,
  BBTYP,
  SLED_BBD,
  GTIN_VARIANT,
  GENNR,
  RMATP,
  GDS_RELEVANT,
  WEORA,
  HUTYP_DFLT,
  PILFERABLE,
  WHSTC,
  WHMATGR,
  HNDLCODE,
  HAZMAT,
  HUTYP,
  TARE_VAR,
  MAXC,
  MAXC_TOL,
  MAXL,
  MAXB,
  MAXH,
  MAXDIM_UOM,
  HERKL,
  MFRGR,
  QQTIME,
  QQTIMEUOM,
  QGRP,
  SERIAL,
  PS_SMARTFORM,
  LOGUNIT,
  CWQREL,
  CWQPROC,
  CWQTOLGR,
  ADPROF,
  IPMIPPRODUCT,
  ALLOW_PMAT_IGNO,
  MEDIUM,
  COMMODITY,
  ANIMAL_ORIGIN,
  TEXTILE_COMP_IND,
  LAST_CHANGED_TIME,
  MATNR_EXTERNAL,
  CHML_CMPLNC_RLVNCE_IND,
  LOGISTICAL_MAT_CATEGORY,
  SALES_MATERIAL,
  IDENTIFICATION_TAG_TYPE,
  SGT_CSGR,
  SGT_COVSA,
  SGT_STAT,
  SGT_SCOPE,
  SGT_REL,
  ANP,
  PSM_CODE,
  FSH_MG_AT1,
  FSH_MG_AT2,
  FSH_MG_AT3,
  FSH_SEALV,
  FSH_SEAIM,
  FSH_SC_MID,
  DUMMY_PRD_INCL_EEW_PS,
  SCM_MATID_GUID16,
  SCM_MATID_GUID22,
  SCM_MATURITY_DUR,
  SCM_SHLF_LFE_REQ_MIN,
  SCM_SHLF_LFE_REQ_MAX,
  SCM_PUOM,
  RMATP_PB,
  PROD_SHAPE,
  MO_PROFILE_ID,
  OVERHANG_TRESH,
  BRIDGE_TRESH,
  BRIDGE_MAX_SLOPE,
  HEIGHT_NONFLAT,
  HEIGHT_NONFLAT_UOM,
  SCM_KITCOMP,
  SCM_PROD_PAOOPT,
  SCM_BOD_DEPLVL,
  SCM_RESTRICT_INVBAL,
  SCM_DRP_GL_STOCK,
  SCM_EXCL_EXPEDITE,
  /CWM/XCWMAT,
  /CWM/VALUM,
  /CWM/TOLGR,
  /CWM/TARA,
  /CWM/TARUM,
  /BEV1/LULEINH,
  /BEV1/LULDEGRP,
  /BEV1/NESTRUCCAT,
  /DSD/SL_TOLTYP,
  /DSD/SV_CNT_GRP,
  /SAPMP/KADU,
  /SAPMP/ABMEIN,
  /SAPMP/KADP,
  /SAPMP/BRAD,
  /SAPMP/SPBI,
  /SAPMP/TRAD,
  /SAPMP/KEDU,
  /SAPMP/SPTR,
  /SAPMP/FBDK,
  /SAPMP/FBHK,
  /SAPMP/RILI,
  /SAPMP/FBAK,
  /SAPMP/AHO,
  /SAPMP/MIFRR,
  /VSO/R_TILT_IND,
  /VSO/R_STACK_IND,
  /VSO/R_BOT_IND,
  /VSO/R_TOP_IND,
  /VSO/R_STACK_NO,
  /VSO/R_PAL_IND,
  /VSO/R_PAL_OVR_D,
  /VSO/R_PAL_OVR_W,
  /VSO/R_PAL_B_HT,
  /VSO/R_PAL_MIN_H,
  /VSO/R_TOL_B_HT,
  /VSO/R_NO_P_GVH,
  /VSO/R_QUAN_UNIT,
  /VSO/R_KZGVH_IND,
  PACKCODE,
  DG_PACK_STATUS,
  SRV_DURA,
  SRV_DURA_UOM,
  SRV_SERWI,
  SRV_ESCAL,
  SOM_CYCLE,
  SOM_CYCLE_RULE,
  SOM_TC_SCHEMA,
  MCOND,
  RETDELC,
  LOGLEV_RETO,
  NSNID,
  OVLPN,
  ADSPC_SPC,
  VARID,
  MSBOOKPARTNO,
  DPCBT,
  XGRDT,
  IMATN,
  PICNUM,
  BSTAT,
  COLOR_ATINN,
  SIZE1_ATINN,
  SIZE2_ATINN,
  COLOR,
  SIZE1,
  SIZE2,
  FREE_CHAR,
  CARE_CODE,
  BRAND_ID,
  FIBER_CODE1,
  FIBER_PART1,
  FIBER_CODE2,
  FIBER_PART2,
  FIBER_CODE3,
  FIBER_PART3,
  FIBER_CODE4,
  FIBER_PART4,
  FIBER_CODE5,
  FIBER_PART5,
  FASHGRD
FROM mara
;