NSDM_e_v_OLR3_MARX

DDL: NSDM_DDL_V_OLR3_MARX SQL: NSDM_V_OLR3_MARX Type: view
326 Fields 2 Data Sources

V_OLR3_MARX Compatibility View

NSDM_e_v_OLR3_MARX is a CDS View that provides data about "V_OLR3_MARX Compatibility View" in SAP S/4HANA. It reads from 2 data sources (mara, nsdm_e_marc) and exposes 326 fields with key fields mandt, matnr, ersda, ernam, laeda.

Data Sources (2)

SourceAliasJoin Type
mara a from
nsdm_e_marc b inner

Annotations (11)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName NSDM_V_OLR3_MARX view
EndUserText.label V_OLR3_MARX Compatibility View view
ObjectModel.usageType.sizeCategory L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #AUTOMATED view
AccessControl.authorizationCheck #NOT_ALLOWED view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.viewEnhancementCategory #PROJECTION_LIST view

Fields (326)

KeyFieldSource TableSource FieldDescription
KEY mandt mara mandt Editing Client
KEY matnr mara matnr Vehicle Model
KEY ersda mara ersda Entry Date
KEY ernam mara ernam User Name
KEY laeda mara laeda Last Change
KEY aenam mara aenam User Name
KEY vpsta mara vpsta Complete status
KEY mtart mara mtart Product Type
KEY mbrsh mara mbrsh Industry
KEY matkl mara matkl Product Sold Group
KEY bismt mara bismt Old matl number
KEY meins mara meins Valuation Unit
KEY bstme mara bstme Unit.Order
KEY zeinr mara zeinr Document
KEY zeiar mara zeiar Document Type
KEY zeivr mara zeivr Doc. Version
KEY zeifo mara zeifo Page Format
KEY aeszn mara aeszn Doc. Change No.
KEY blatt mara blatt Page Number
KEY blanz mara blanz No. Of Sheets
KEY ferth mara ferth Prod./insp.memo
KEY formt mara formt Page format
KEY groes mara groes Size/dimensions
KEY wrkst mara wrkst Basic Material
KEY normt mara normt Ind. Std Desc.
KEY labor mara labor Work Center
KEY ekwsl mara ekwsl Purch.value key
KEY brgew mara brgew Weight
KEY ntgew mara ntgew Net Weight
KEY gewei mara gewei Weight Unit
KEY volum mara volum Volume
KEY voleh mara voleh Volume Unit
KEY behvo mara behvo Container
KEY raube mara raube Stor.conditions
KEY tempb mara tempb Temperature
KEY disst mara disst Low-Level Code
KEY tragr mara tragr Transport.Group
KEY stoff mara stoff Haz. matl no.
KEY spart mara spart Source supplier
KEY kunnr mara kunnr Stock customer
KEY eannr mara eannr EAN Number
KEY wesch mara wesch GR slips quantity
KEY bwvor mara bwvor Procure. rule
KEY saiso mara saiso Season
KEY etiar mara etiar Label type
KEY etifo mara etifo Label form
KEY entar mara entar Field deact.
KEY ean11 mara ean11 EAN/UPC
KEY numtp mara numtp EAN Category
KEY laeng mara laeng Length
KEY breit mara breit Width
KEY hoehe mara hoehe Height
KEY meabm mara meabm Unit
KEY prdha mara prdha Prod.Hierarchy
KEY aeklk mara aeklk Net Change Cstg
KEY cadkz mara cadkz CAD Indicator
KEY qmpur mara qmpur QM Procurement
KEY ergew mara ergew Allowed Pkg wt
KEY ergei mara ergei Unit of weight
KEY ervol mara ervol Allowed Volume
KEY ervoe mara ervoe Volume unit
KEY gewto mara gewto Excess wt tolerance
KEY volto mara volto Excess volume tol.
KEY vabme mara vabme Var. Order Unit
KEY kzrev mara kzrev Revision Level
KEY kzkfg mara kzkfg Origin of config
KEY vhart mara vhart Packag.Mat.Type
KEY fuelg mara fuelg Maximum level
KEY stfak mara stfak Stacking factor
KEY magrv mara magrv Matl Grp Pckmat
KEY begru mara begru AuthorizGroup
KEY datab mara datab Validity period
KEY liqdt mara liqdt Valid To
KEY saisj mara saisj Season Year
KEY plgtp mara plgtp Price band cat.
KEY mlgut mara mlgut W/ Empties BOM
KEY extwg mara extwg Ext. Matl Group
KEY satnr mara satnr Cross-plant CM
KEY attyp mara attyp Trdg Goods Cat.
KEY kznfm mara kznfm Follow-up matl
KEY pmata mara pmata Pr. Ref. Matl
KEY mstae mara mstae X-Plant Status
KEY mstav mara mstav X-DChain status
KEY mstde mara mstde Valid from
KEY mstdv mara mstdv Valid from
KEY taklv mara taklv Tax class.
KEY rbnrm mara rbnrm Catalog Profile
KEY mhdrz mara mhdrz Rem. Shelf Life
KEY mhdhb mara mhdhb Tot. shelf life
KEY mhdlp mara mhdlp Storage %
KEY inhme mara inhme Content Unit
KEY inhal mara inhal Net Contents
KEY vpreh mara vpreh Comp.price unit
KEY etiag mara etiag Label.matl grpg
KEY inhbr mara inhbr Gross Contents
KEY cmeth mara cmeth Method
KEY cuobf mara cuobf Int. object no.
KEY kzumw mara kzumw Envt. relevant
KEY kosch mara kosch Prod.allocation
KEY sprof mara sprof Pricing profile
KEY nrfhg mara nrfhg Disc. in kind
KEY mfrpn mara mfrpn Mfr Part Number
KEY mfrnr mara mfrnr Manufacturer
KEY bmatn mara bmatn Int. material no.
KEY mprof mara mprof Mfr Part Profile
KEY kzwsm mara kzwsm Units meas. use
KEY saity mara saity Rollout
KEY profl mara profl Project Profile
KEY ihivi mara ihivi Highly viscous
KEY iloos mara iloos In bulk/liquid
KEY serlv mara serlv SerializLevel
KEY kzgvh mara kzgvh Closed
KEY xgchp mara xgchp Batch rec. req.
KEY kzeff mara kzeff Assign.eff.vals
KEY iprkz mara iprkz PI Shelf Life
KEY rdmhd mara rdmhd Rounding rule
KEY przus mara przus ProdComposition
KEY mtpos_mara mara mtpos_mara GenItemCatGroup
KEY bflme mara bflme Log. variants
KEY matfi mara matfi Material locked
KEY cmrel mara cmrel CM Relevant
KEY bbtyp mara bbtyp Astmt List Type
KEY sled_bbd mara sled_bbd Expiration Date
KEY gtin_variant mara gtin_variant Variant
KEY gennr mara gennr GenericMaterial
KEY rmatp mara rmatp RefProd. GUID
KEY werks nsdm_e_marc werks Receiving Plant
pstat nsdm_e_marc pstat Processing Status
lvorm nsdm_e_marc lvorm Stock del. flag
bwtty nsdm_e_marc bwtty Valuation Cat.
xchar nsdm_e_marc xchar HU assignment
mmsta nsdm_e_marc mmsta Primary Status
mmstd nsdm_e_marc mmstd Valid From
maabc nsdm_e_marc maabc ABC Indicator
kzkri nsdm_e_marc kzkri Critical Part
ekgrp nsdm_e_marc ekgrp Sub. purchasing grp
ausme nsdm_e_marc ausme Unit of Issue
dispr nsdm_e_marc dispr MRP profile
dismm nsdm_e_marc dismm MRP Type
dispo nsdm_e_marc dispo MRP Controller
kzdie nsdm_e_marc kzdie MRPCtrllr=buyer
plifz nsdm_e_marc plifz Plnd Deliv.Time
webaz nsdm_e_marc webaz GR Proc. Time
perkz nsdm_e_marc perkz Period Type
ausss nsdm_e_marc ausss Assembly scrap
disls nsdm_e_marc disls Lot Sizing Procedure
beskz nsdm_e_marc beskz Procuremt Type
sobsl nsdm_e_marc sobsl SpecProcuremKey
minbe nsdm_e_marc minbe Reorder Point
eisbe nsdm_e_marc eisbe Safety Stock
bstmi nsdm_e_marc bstmi Min. Lot Size
bstma nsdm_e_marc bstma To Lot Size
bstfe nsdm_e_marc bstfe Fixed lot size
bstrf nsdm_e_marc bstrf Rounding value
mabst nsdm_e_marc mabst Max.Stock Level
losfx nsdm_e_marc losfx LSI Costs
sbdkz nsdm_e_marc sbdkz Indiv./ Coll.
lagpr nsdm_e_marc lagpr Storage Costs
altsl nsdm_e_marc altsl SelectionMethod
kzaus nsdm_e_marc kzaus Share of scrap
ausdt nsdm_e_marc ausdt Dunning Date
nfmat nsdm_e_marc nfmat Follow-Up Matl
kzbed nsdm_e_marc kzbed Reqmts grouping
miskz nsdm_e_marc miskz Mixed MRP
fhori nsdm_e_marc fhori Margin Key
pfrei nsdm_e_marc pfrei Autom. fix. pl. ords
ffrei nsdm_e_marc ffrei Autom. release
rgekz nsdm_e_marc rgekz Backflushing
fevor nsdm_e_marc fevor Prodn Supervisor
bearz nsdm_e_marc bearz Processing Time
ruezt nsdm_e_marc ruezt Setup time
tranz nsdm_e_marc tranz Move Time
basmg nsdm_e_marc basmg Base quantity
dzeit nsdm_e_marc dzeit InhseProdTime
maxlz nsdm_e_marc maxlz Max. Storage
lzeih nsdm_e_marc lzeih Time unit
kzpro nsdm_e_marc kzpro Withd.fm.pr.bin
gpmkz nsdm_e_marc gpmkz Rough-Cut Plng
ueeto nsdm_e_marc ueeto Overdeliv. Tol.
ueetk nsdm_e_marc ueetk Unlimited
uneto nsdm_e_marc uneto Underdel. Tol.
wzeit nsdm_e_marc wzeit Total RL time
atpkz nsdm_e_marc atpkz Replacemt Part
vzusl nsdm_e_marc vzusl Surcharge %
herbl nsdm_e_marc herbl State of manufac
insmk nsdm_e_marc insmk Stock Type
sproz nsdm_e_marc sproz Sample %
quazt nsdm_e_marc quazt Quarantine
ssqss nsdm_e_marc ssqss QM Control Key
mpdau nsdm_e_marc mpdau Mean insp. dur.
kzppv nsdm_e_marc kzppv Insp. plan ind.
kzdkz nsdm_e_marc kzdkz Doc. required
wstgh nsdm_e_marc wstgh Active subst.
prfrq nsdm_e_marc prfrq Inspection Interval
nkmpr nsdm_e_marc nkmpr Next inspection
umlmc nsdm_e_marc umlmc Stock in tfr
ladgr nsdm_e_marc ladgr Loading Group
xchpf nsdm_e_marc xchpf Batch Mgmt Rqt(Plnt)
usequ nsdm_e_marc usequ Quota arr.usage
lgrad nsdm_e_marc lgrad Target Service Level
auftl nsdm_e_marc auftl Splitting
plvar nsdm_e_marc plvar Plan version
otype nsdm_e_marc otype Type of Val.
objid nsdm_e_marc objid Work Center
mtvfp nsdm_e_marc mtvfp Avail. check
periv nsdm_e_marc periv FYear Variant
kzkfk nsdm_e_marc kzkfk Corr. factors
vrvez nsdm_e_marc vrvez Setup time
vbamg nsdm_e_marc vbamg Base quantity
vbeaz nsdm_e_marc vbeaz Processing time
lizyk nsdm_e_marc lizyk Deactivated
bwscl nsdm_e_marc bwscl Supply source
kautb nsdm_e_marc kautb Autom. PO
kordb nsdm_e_marc kordb Source list
stawn nsdm_e_marc stawn Commodity Code
herkl nsdm_e_marc herkl C/R of Origin
herkr nsdm_e_marc herkr Reg. of Origin
expme nsdm_e_marc expme Comm. code unit
mtver nsdm_e_marc mtver Intrastat Group
prctr nsdm_e_marc prctr Profit Centers
trame nsdm_e_marc trame Stk in Transit
mrppp nsdm_e_marc mrppp Planning cal.
sauft nsdm_e_marc sauft Repetitive Mfg
fxhor nsdm_e_marc fxhor Plng time fence
vrmod nsdm_e_marc vrmod Consmption mode
vint1 nsdm_e_marc vint1 Bwd cons. per.
vint2 nsdm_e_marc vint2 Fwd cons.period
verkz nsdm_e_marc verkz Version
stlal nsdm_e_marc stlal AlternativeBOM
stlan nsdm_e_marc stlan Usage
plnnr nsdm_e_marc plnnr Task List Group
aplal nsdm_e_marc aplal Group Counter
losgr nsdm_e_marc losgr Cstg Lot Size
sobsk nsdm_e_marc sobsk SpecProcType
frtme nsdm_e_marc frtme Production unit
lgpro nsdm_e_marc lgpro Storage Location
disgr nsdm_e_marc disgr MRP Group
kausf nsdm_e_marc kausf Component Scrap
qzgtp nsdm_e_marc qzgtp CertificateType
qmatv nsdm_e_marc qmatv Insp. Setup
takzt nsdm_e_marc takzt Takt time
rwpro nsdm_e_marc rwpro Coverage Prof.
copam nsdm_e_marc copam Field name
abcin nsdm_e_marc abcin CC Phys. Inv.
awsls nsdm_e_marc awsls Variance key
sernp nsdm_e_marc sernp SerialNoProfile
cuobj nsdm_e_marc cuobj Object Number
stdpd nsdm_e_marc stdpd Conf. Material
sfepr nsdm_e_marc sfepr REM Profile
xmcng nsdm_e_marc xmcng Neg. Stocks
qssys nsdm_e_marc qssys Target QM Sys.
lfrhy nsdm_e_marc lfrhy Planning Cycle
rdprf nsdm_e_marc rdprf Rounding Prfl.
vrbmt nsdm_e_marc vrbmt Ref.matl: cons.
vrbwk nsdm_e_marc vrbwk Ref.plant:cons.
vrbdt nsdm_e_marc vrbdt Date to
vrbfk nsdm_e_marc vrbfk Multiplier
autru nsdm_e_marc autru Autom.reset
prefe nsdm_e_marc prefe Cus. Preference
prenc nsdm_e_marc prenc Exemption cert.
preno nsdm_e_marc preno Exempt.cert.no.
prend nsdm_e_marc prend Iss.date of crt
prene nsdm_e_marc prene Vendor decl.
preng nsdm_e_marc preng Vdr decl. date
itark nsdm_e_marc itark Military goods
servg nsdm_e_marc servg Service Level
kzkup nsdm_e_marc kzkup Co-Product
strgr nsdm_e_marc strgr Strategy Group
cuobv nsdm_e_marc cuobv Int. object no.
lgfsb nsdm_e_marc lgfsb Storage Location
schgt nsdm_e_marc schgt Bulk material
ccfix nsdm_e_marc ccfix CC ind. fixed
eprio nsdm_e_marc eprio Withdr.Seq.Grp
qmata nsdm_e_marc qmata QM Matl Auth.
resvp nsdm_e_marc resvp Adjustmt period
plnty nsdm_e_marc plnty Task List Type
uomgr nsdm_e_marc uomgr UoM Group
umrsl nsdm_e_marc umrsl Conv. Group
abfac nsdm_e_marc abfac Air Buoy. Fact.
sfcpf nsdm_e_marc sfcpf Prod. Sched. Profile
shflg nsdm_e_marc shflg Safety Time Ind
shzet nsdm_e_marc shzet Safety Time
mdach nsdm_e_marc mdach Action Control
kzech nsdm_e_marc kzech Enter batch
megru nsdm_e_marc megru UoM Group
mfrgr nsdm_e_marc mfrgr Prod.Frgt Group
vkumc nsdm_e_marc vkumc Stk transfer SV
vktrw nsdm_e_marc vktrw St.in trans./SP
kzagl nsdm_e_marc kzagl Smth prom. cons
fvidk nsdm_e_marc fvidk Prod. Version
fxpru nsdm_e_marc fxpru Fixed-Price Co-Prod.
loggr nsdm_e_marc loggr Logistics group
fprfm nsdm_e_marc fprfm Dist.prof.
glgmg nsdm_e_marc glgmg Tied Empties
vkglg nsdm_e_marc vkglg SlsVal.TiedEmpt
indus nsdm_e_marc indus Mat. category
mownr nsdm_e_marc mownr EU prod.list no.
mogru nsdm_e_marc mogru CAP prod. group
casnr nsdm_e_marc casnr CAS no.(pharm.)
gpnum nsdm_e_marc gpnum PRODCOM no.
steuc nsdm_e_marc steuc Control Code
fabkz nsdm_e_marc fabkz Sched. Agr. Forecast
matgr nsdm_e_marc matgr Mat. Grouping
vspvb nsdm_e_marc vspvb Supply Area
dplfs nsdm_e_marc dplfs Fair share rule
dplpu nsdm_e_marc dplpu Push distribution
dplho nsdm_e_marc dplho Deploymnt hrzn
minls nsdm_e_marc minls Min. Lot Size
maxls nsdm_e_marc maxls Max. Lot Size
fixls nsdm_e_marc fixls Fix. lot size
ltinc nsdm_e_marc ltinc Lot size incr.
compl nsdm_e_marc compl This field is no longer used
convt nsdm_e_marc convt Conv. type
shpro nsdm_e_marc shpro Time Profile
ahdis nsdm_e_marc ahdis MRP Relevant
diber nsdm_e_marc diber MRP area exists
kzpsp nsdm_e_marc kzpsp Cross-Project
ocmpf nsdm_e_marc ocmpf Overall profile
apokz nsdm_e_marc apokz Relevant to APO
mcrue nsdm_e_marc mcrue MARDH rec. already exists for per. before last of MARD per.
lfmon nsdm_e_marc lfmon Current Period
lfgja nsdm_e_marc lfgja Year Cur.Period
eislo nsdm_e_marc eislo Min. Saf. Stock
ncost nsdm_e_marc ncost Do Not Cost
uchkz nsdm_e_marc uchkz OB Management
ucmat nsdm_e_marc ucmat PB Material

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 NSDM_e_v_OLR3_MARX.
-- 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: NSDM_V_OLR3_MARX

CREATE VIEW NSDM_e_v_OLR3_MARX AS
SELECT
  a.mandt AS mandt,
  a.matnr AS matnr,
  a.ersda AS ersda,
  a.ernam AS ernam,
  a.laeda AS laeda,
  a.aenam AS aenam,
  a.vpsta AS vpsta,
  a.mtart AS mtart,
  a.mbrsh AS mbrsh,
  a.matkl AS matkl,
  a.bismt AS bismt,
  a.meins AS meins,
  a.bstme AS bstme,
  a.zeinr AS zeinr,
  a.zeiar AS zeiar,
  a.zeivr AS zeivr,
  a.zeifo AS zeifo,
  a.aeszn AS aeszn,
  a.blatt AS blatt,
  a.blanz AS blanz,
  a.ferth AS ferth,
  a.formt AS formt,
  a.groes AS groes,
  a.wrkst AS wrkst,
  a.normt AS normt,
  a.labor AS labor,
  a.ekwsl AS ekwsl,
  a.brgew AS brgew,
  a.ntgew AS ntgew,
  a.gewei AS gewei,
  a.volum AS volum,
  a.voleh AS voleh,
  a.behvo AS behvo,
  a.raube AS raube,
  a.tempb AS tempb,
  a.disst AS disst,
  a.tragr AS tragr,
  a.stoff AS stoff,
  a.spart AS spart,
  a.kunnr AS kunnr,
  a.eannr AS eannr,
  a.wesch AS wesch,
  a.bwvor AS bwvor,
  a.saiso AS saiso,
  a.etiar AS etiar,
  a.etifo AS etifo,
  a.entar AS entar,
  a.ean11 AS ean11,
  a.numtp AS numtp,
  a.laeng AS laeng,
  a.breit AS breit,
  a.hoehe AS hoehe,
  a.meabm AS meabm,
  a.prdha AS prdha,
  a.aeklk AS aeklk,
  a.cadkz AS cadkz,
  a.qmpur AS qmpur,
  a.ergew AS ergew,
  a.ergei AS ergei,
  a.ervol AS ervol,
  a.ervoe AS ervoe,
  a.gewto AS gewto,
  a.volto AS volto,
  a.vabme AS vabme,
  a.kzrev AS kzrev,
  a.kzkfg AS kzkfg,
  a.vhart AS vhart,
  a.fuelg AS fuelg,
  a.stfak AS stfak,
  a.magrv AS magrv,
  a.begru AS begru,
  a.datab AS datab,
  a.liqdt AS liqdt,
  a.saisj AS saisj,
  a.plgtp AS plgtp,
  a.mlgut AS mlgut,
  a.extwg AS extwg,
  a.satnr AS satnr,
  a.attyp AS attyp,
  a.kznfm AS kznfm,
  a.pmata AS pmata,
  a.mstae AS mstae,
  a.mstav AS mstav,
  a.mstde AS mstde,
  a.mstdv AS mstdv,
  a.taklv AS taklv,
  a.rbnrm AS rbnrm,
  a.mhdrz AS mhdrz,
  a.mhdhb AS mhdhb,
  a.mhdlp AS mhdlp,
  a.inhme AS inhme,
  a.inhal AS inhal,
  a.vpreh AS vpreh,
  a.etiag AS etiag,
  a.inhbr AS inhbr,
  a.cmeth AS cmeth,
  a.cuobf AS cuobf,
  a.kzumw AS kzumw,
  a.kosch AS kosch,
  a.sprof AS sprof,
  a.nrfhg AS nrfhg,
  a.mfrpn AS mfrpn,
  a.mfrnr AS mfrnr,
  a.bmatn AS bmatn,
  a.mprof AS mprof,
  a.kzwsm AS kzwsm,
  a.saity AS saity,
  a.profl AS profl,
  a.ihivi AS ihivi,
  a.iloos AS iloos,
  a.serlv AS serlv,
  a.kzgvh AS kzgvh,
  a.xgchp AS xgchp,
  a.kzeff AS kzeff,
  a.iprkz AS iprkz,
  a.rdmhd AS rdmhd,
  a.przus AS przus,
  a.mtpos_mara AS mtpos_mara,
  a.bflme AS bflme,
  a.matfi AS matfi,
  a.cmrel AS cmrel,
  a.bbtyp AS bbtyp,
  a.sled_bbd AS sled_bbd,
  a.gtin_variant AS gtin_variant,
  a.gennr AS gennr,
  a.rmatp AS rmatp,
  b.werks AS werks,
  b.pstat AS pstat,
  b.lvorm AS lvorm,
  b.bwtty AS bwtty,
  b.xchar AS xchar,
  b.mmsta AS mmsta,
  b.mmstd AS mmstd,
  b.maabc AS maabc,
  b.kzkri AS kzkri,
  b.ekgrp AS ekgrp,
  b.ausme AS ausme,
  b.dispr AS dispr,
  b.dismm AS dismm,
  b.dispo AS dispo,
  b.kzdie AS kzdie,
  b.plifz AS plifz,
  b.webaz AS webaz,
  b.perkz AS perkz,
  b.ausss AS ausss,
  b.disls AS disls,
  b.beskz AS beskz,
  b.sobsl AS sobsl,
  b.minbe AS minbe,
  b.eisbe AS eisbe,
  b.bstmi AS bstmi,
  b.bstma AS bstma,
  b.bstfe AS bstfe,
  b.bstrf AS bstrf,
  b.mabst AS mabst,
  b.losfx AS losfx,
  b.sbdkz AS sbdkz,
  b.lagpr AS lagpr,
  b.altsl AS altsl,
  b.kzaus AS kzaus,
  b.ausdt AS ausdt,
  b.nfmat AS nfmat,
  b.kzbed AS kzbed,
  b.miskz AS miskz,
  b.fhori AS fhori,
  b.pfrei AS pfrei,
  b.ffrei AS ffrei,
  b.rgekz AS rgekz,
  b.fevor AS fevor,
  b.bearz AS bearz,
  b.ruezt AS ruezt,
  b.tranz AS tranz,
  b.basmg AS basmg,
  b.dzeit AS dzeit,
  b.maxlz AS maxlz,
  b.lzeih AS lzeih,
  b.kzpro AS kzpro,
  b.gpmkz AS gpmkz,
  b.ueeto AS ueeto,
  b.ueetk AS ueetk,
  b.uneto AS uneto,
  b.wzeit AS wzeit,
  b.atpkz AS atpkz,
  b.vzusl AS vzusl,
  b.herbl AS herbl,
  b.insmk AS insmk,
  b.sproz AS sproz,
  b.quazt AS quazt,
  b.ssqss AS ssqss,
  b.mpdau AS mpdau,
  b.kzppv AS kzppv,
  b.kzdkz AS kzdkz,
  b.wstgh AS wstgh,
  b.prfrq AS prfrq,
  b.nkmpr AS nkmpr,
  b.umlmc AS umlmc,
  b.ladgr AS ladgr,
  b.xchpf AS xchpf,
  b.usequ AS usequ,
  b.lgrad AS lgrad,
  b.auftl AS auftl,
  b.plvar AS plvar,
  b.otype AS otype,
  b.objid AS objid,
  b.mtvfp AS mtvfp,
  b.periv AS periv,
  b.kzkfk AS kzkfk,
  b.vrvez AS vrvez,
  b.vbamg AS vbamg,
  b.vbeaz AS vbeaz,
  b.lizyk AS lizyk,
  b.bwscl AS bwscl,
  b.kautb AS kautb,
  b.kordb AS kordb,
  b.stawn AS stawn,
  b.herkl AS herkl,
  b.herkr AS herkr,
  b.expme AS expme,
  b.mtver AS mtver,
  b.prctr AS prctr,
  b.trame AS trame,
  b.mrppp AS mrppp,
  b.sauft AS sauft,
  b.fxhor AS fxhor,
  b.vrmod AS vrmod,
  b.vint1 AS vint1,
  b.vint2 AS vint2,
  b.verkz AS verkz,
  b.stlal AS stlal,
  b.stlan AS stlan,
  b.plnnr AS plnnr,
  b.aplal AS aplal,
  b.losgr AS losgr,
  b.sobsk AS sobsk,
  b.frtme AS frtme,
  b.lgpro AS lgpro,
  b.disgr AS disgr,
  b.kausf AS kausf,
  b.qzgtp AS qzgtp,
  b.qmatv AS qmatv,
  b.takzt AS takzt,
  b.rwpro AS rwpro,
  b.copam AS copam,
  b.abcin AS abcin,
  b.awsls AS awsls,
  b.sernp AS sernp,
  b.cuobj AS cuobj,
  b.stdpd AS stdpd,
  b.sfepr AS sfepr,
  b.xmcng AS xmcng,
  b.qssys AS qssys,
  b.lfrhy AS lfrhy,
  b.rdprf AS rdprf,
  b.vrbmt AS vrbmt,
  b.vrbwk AS vrbwk,
  b.vrbdt AS vrbdt,
  b.vrbfk AS vrbfk,
  b.autru AS autru,
  b.prefe AS prefe,
  b.prenc AS prenc,
  b.preno AS preno,
  b.prend AS prend,
  b.prene AS prene,
  b.preng AS preng,
  b.itark AS itark,
  b.servg AS servg,
  b.kzkup AS kzkup,
  b.strgr AS strgr,
  b.cuobv AS cuobv,
  b.lgfsb AS lgfsb,
  b.schgt AS schgt,
  b.ccfix AS ccfix,
  b.eprio AS eprio,
  b.qmata AS qmata,
  b.resvp AS resvp,
  b.plnty AS plnty,
  b.uomgr AS uomgr,
  b.umrsl AS umrsl,
  b.abfac AS abfac,
  b.sfcpf AS sfcpf,
  b.shflg AS shflg,
  b.shzet AS shzet,
  b.mdach AS mdach,
  b.kzech AS kzech,
  b.megru AS megru,
  b.mfrgr AS mfrgr,
  b.vkumc AS vkumc,
  b.vktrw AS vktrw,
  b.kzagl AS kzagl,
  b.fvidk AS fvidk,
  b.fxpru AS fxpru,
  b.loggr AS loggr,
  b.fprfm AS fprfm,
  b.glgmg AS glgmg,
  b.vkglg AS vkglg,
  b.indus AS indus,
  b.mownr AS mownr,
  b.mogru AS mogru,
  b.casnr AS casnr,
  b.gpnum AS gpnum,
  b.steuc AS steuc,
  b.fabkz AS fabkz,
  b.matgr AS matgr,
  b.vspvb AS vspvb,
  b.dplfs AS dplfs,
  b.dplpu AS dplpu,
  b.dplho AS dplho,
  b.minls AS minls,
  b.maxls AS maxls,
  b.fixls AS fixls,
  b.ltinc AS ltinc,
  b.compl AS compl,
  b.convt AS convt,
  b.shpro AS shpro,
  b.ahdis AS ahdis,
  b.diber AS diber,
  b.kzpsp AS kzpsp,
  b.ocmpf AS ocmpf,
  b.apokz AS apokz,
  b.mcrue AS mcrue,
  b.lfmon AS lfmon,
  b.lfgja AS lfgja,
  b.eislo AS eislo,
  b.ncost AS ncost,
  b.uchkz AS uchkz,
  b.ucmat AS ucmat
FROM mara AS a
INNER JOIN nsdm_e_marc AS b ON /* join condition not captured in parsed metadata */
;

Learn More