NSDM_E_MARC

CDS View
236 Fields 62 CDS Views

Extension View for Append /SAPMP/EMARC

NSDM_E_MARC is a CDS View in S/4HANA. Extension View for Append /SAPMP/EMARC. It contains 236 fields. 62 CDS views read from this table.

CDS Views using this table (62)

ViewTypeJoinVDMDescription
/merp/mm_Material_Plant view inner CDS View: Material Plant View
/merp/pm_Wo_Component view left_outer CDS View: Maintenance Order Components
/SAPAPO/CDPS_CURTORUL_SEL view inner Selection of Resource Usage
/SAPAPO/SDM_PLSTA_DD view from CDS-View: Migration Status PPSKZ to /SAPAPO/MATPLSTA for SDM
Arun_Conf_Lines view inner Supply Assignment confirmations
arun_i_batch_lines view inner Batch Stock selection at storage level
ARUN_I_F_LINE view inner Production Order Item level selection
arun_i_plaf view inner Planned order selection
Arun_I_So_1 view inner SO Item level Data selection
arun_i_so_arun_check view inner Select SalesOrder Items for ARun Article
Arun_I_Sto_1 view inner STO Item level Data selection
ARUN_I_STOCK_LINES view inner Physical Stock selection aggregation
arun_i_stora_line view inner Storage location stock aggregation
Arun_Open_Delivery_C view inner Supply Assignment open deliveries
ARUN_PROD_REQMT view left_outer Production order components
Arun_Purchord_Aggr view inner Supply Assignment PO aggregate
Arun_Reqsrt_Mm view inner Requirement sorting - MM
Arun_Reqsrt_Sd view inner Requirement sorting - SD
ARUN_SO_ITEM_QTY view inner Fetch Sup Assgmt status of a sales order
Arun_So_Req1 view inner Sales Order Requirement - Initial join
Arun_Spo_Reqmt view inner Subcontracting PO Requirement
Arun_Sto_Req1 view inner STO Requirement - Initial join
Arun_Stock_Lines view inner Aggregate stock for Supply Assignment
ARun_ValAddedSrvcMatlPlant view inner
ARUNI_CONF_LINE view inner Confirmations selection at date level
ARUNI_EBAN_SEL view inner Get Purchase Requisition data
aruni_po_line view inner PO selection at date level
aruni_sto_line view inner PO selection at date level
ARUNI_STO_LINE_STK view inner STO as stock
C_PurOrdMaintainMatlValHelp view inner CONSUMPTION PO Maintenance: Value Help for Material
FAC_AUDIT_Z3_MATERIAL_MASTER_B view inner Material Master based CDS View
FINOC_RULE_MAT_BASE view from Orgl Change-Rule: Materials Base
FPC_EBEW_ETC_VIEW view inner Projection on MM data for PCP
FPC_MBEW_ETC_VIEW view inner Projection on MM data for PCP
FPC_QBEW_ETC_VIEW view inner Projection on MM data for PCP
I_FldLogsPlntPerCustSlsArea view_entity inner BASIC Plant wise Customer Sales Area
I_ProductPlant view from BASIC Product Plant
I_ProductPlantVH view from COMPOSITE Product Plant Value Help
NSDM_e_J_3RM_MARCMARA_B view from J_3RM_MARCMARA_B Compatibility View
NSDM_e_J_3RM_MARCMARA_W_w view from J_3RM_MARCMARA_W Compatibility View
NSDM_E_MA07V view inner MA07V Compatibility View
NSDM_E_MA61V view inner MA61V Compatibility View
NSDM_E_MAWEV view inner MAWEV Compatibility View
NSDM_E_MCON view inner MCON Compatibility View
NSDM_E_MFAUF view inner MFAUF Compatibility View
NSDM_E_MMBE_MARC_V view inner MMBE_MARC_V Compatibility View
NSDM_E_V_MMIM_EN view inner V_MMIM_EN Compatibility View
NSDM_E_V_MMIM_EN2 view inner V_MMIM_EN2 Compatibility View
NSDM_E_V_MMIM_KN view inner V_MMIM_KN Compatibility View
NSDM_E_V_MMIM_LB view inner V_MMIM_LB Compatibility View
NSDM_E_V_MMIM_LC view inner V_MMIM_LC Compatibility View
NSDM_E_V_MMIM_LC_MB5M view inner V_MMIM_LC_MB5M Compatibility View
NSDM_E_V_MMIM_LN view inner V_MMIM_LN Compatibility View
NSDM_E_V_MMIM_ON view inner V_MMIM_ON Compatibility View
NSDM_E_V_MMIM_QN view inner V_MMIM_QN Compatibility View
NSDM_E_V_MMIM_VW view inner V_MMIM_VW Compatibility View
NSDM_e_v_OLR3_MARX view inner V_OLR3_MARX Compatibility View
NSDM_e_V_SLGH_1 view inner V_SLGH_1 Compatibility View
NSDM_e_V_SLGH_2 view inner V_SLGH_2 Compatibility View
P_Stockmaterial view inner COMPOSITE
pph_mrp_afpo view inner
SDM_MARC_APS_EXT_DD view inner CDS view: migration status for marc_aps_ext for SDM

Fields (236)

KeyField CDS FieldsUsed in Views
KEY altsl altsl 4
KEY ausdt ausdt 4
KEY ausme ausme,GoodsIssueUnit 7
KEY ausss ausss 4
KEY awsls awsls 3
KEY basmg basmg 5
KEY bearz bearz 5
KEY beskz beskz,ProcurementType 9
KEY bstfe bstfe,FixedLotSizeQuantity 6
KEY bstrf bstrf 4
KEY bwtty bwtty 9
KEY cuobj cuobj,ProductConfiguration 7
KEY disgr disgr 6
KEY dismm dismm,MRPType 13
KEY dispo dispo,MRPResponsible 9
KEY dzeit dzeit 6
KEY eisbe eisbe,SafetyStockQuantity 10
KEY ekgrp ekgrp,PurchasingGroup 9
KEY eprio eprio,StockDeterminationGroup 8
KEY fevor fevor,ProductionSupervisor 6
KEY ffrei ffrei 3
KEY fhori fhori 4
KEY frtme frtme 4
KEY fxpru fxpru 3
KEY insmk insmk 4
KEY kausf kausf 4
KEY kzaus kzaus 4
KEY kzbed kzbed 4
KEY kzdkz kzdkz 3
KEY kzech kzech 3
KEY kzkri kzkri,ProductIsCriticalPrt 5
KEY kzpro kzpro 3
KEY ladgr ladgr,LoadingGroup 5
KEY lgpro lgpro,ProductionInvtryManagedLoc 6
KEY lvorm IsMarkedForDeletion,lvorm 12
KEY maabc ABCIndicator,maabc 8
KEY mandt mandt 3
KEY matnr Material,matnr,Product 9
KEY miskz miskz 7
KEY mmsta mmsta,ProfileCode 8
KEY mmstd mmstd,ProfileValidityStartDate 8
KEY mtvfp AvailabilityCheckType,mtvfp 9
KEY nfmat nfmat 4
KEY ocmpf ocmpf 3
KEY plifz PlannedDeliveryDurationInDays,plifz 8
KEY prctr prctr,ProfitCenter 9
KEY pstat MaintenanceStatusName,pstat 8
KEY qmatv qmatv 6
KEY rgekz rgekz 3
KEY ruezt ruezt 5
KEY sauft sauft 4
KEY sbdkz sbdkz 5
KEY schgt schgt 5
KEY scm_matlocid_guid22 scm_matlocid_guid22 1
KEY sernp SerialNumberProfile,sernp 10
KEY sfcpf ProductionSchedulingProfile,sfcpf 5
KEY sfepr sfepr 4
KEY sgt_covs SegmentStrategy,sgt_covs 13
KEY sgt_scope sgt_scope 5
KEY sgt_statc sgt_statc 5
KEY sobsk sobsk 3
KEY sobsl sobsl,SpecialProcurementType 8
KEY stdpd ConfigurableProduct,stdpd 9
KEY strgr strgr 6
KEY tranz tranz 5
KEY uchkz OriglBatchManagementIsRequired,uchkz 6
KEY ueetk ueetk 3
KEY ueeto OverDelivToleranceLimit,ueeto 5
KEY umlmc StockInTransferQuantity,umlmc 11
KEY uneto uneto 3
KEY usequ usequ 4
KEY verkz verkz 3
KEY vspvb vspvb 4
KEY webaz GoodsReceiptDuration,webaz 8
KEY werks Plant,werks 17
KEY wzeit wzeit 6
KEY xchar IsInternalBatchManaged,xchar 11
KEY xchpf IsBatchManagementRequired,xchpf 20
/cwm/bwesb cwmbwesb 1
/cwm/trame cwmtrame 1
/cwm/umlmc cwmumlmc 1
/vso/r_fork_dir vsor_fork_dir 1
/vso/r_lane_num vsor_lane_num 1
/vso/r_pal_vend vsor_pal_vend 1
/vso/r_pkgrp vsor_pkgrp 1
abcin abcin 13
abfac abfac 2
ahdis ahdis 3
aplal aplal 2
apokz apokz 5
arun_fix_batch arun_fix_batch,ArunFixBatch,IsInternalBatchManaged 7
atpkz atpkz 4
auftl auftl 3
autru autru 2
bstma bstma,MaximumLotSizeQuantity 5
bstmi bstmi,MinimumLotSizeQuantity 5
bwesb bwesb,GoodsReceiptBlockedStockQty 7
bwscl bwscl,SourceOfSupplyCategory 5
casnr casnr 3
ccfix ccfix 4
compl compl 2
cons_procg cons_procg,ConsignmentControl,HasConsignmentCtrl 3
convt convt 2
copam copam 3
cuobv cuobv 3
diber diber 5
disls disls 3
dispr dispr 2
dplfs dplfs 3
dplho dplho 3
dplpu dplpu 3
eislo eislo 3
excise_tax_rlvnce ProductIsExciseTaxRelevant 1
expme expme 4
fabkz fabkz 3
fixls fixls 2
fprfm DistrCntrDistributionProfile,fprfm 5
fsh_calendar_group fsh_calendar_group 1
fsh_mg_arun_req fsh_mg_arun_req,RqmtIsSupAssgmtRelevant 5
fsh_seaim fsh_seaim 2
fvidk fvidk 2
fxhor fxhor 3
gi_pr_time gi_pr_time,GoodIssueProcessingDays 3
glgmg glgmg 4
gpmkz gpmkz 2
gpnum gpnum 2
herbl herbl 3
herkl CountryOfOrigin,herkl 5
herkr herkr,RegionOfOrigin 6
indus indus,ProductCFOPCategory 4
itark itark 2
iuid_relevant iuid_relevant 1
iuid_type iuid_type 1
kautb kautb 2
kordb kordb 2
kzagl kzagl 2
kzdie kzdie 3
kzkfk kzkfk 2
kzkup IsCoProduct,kzkup 4
kzppv kzppv 2
kzpsp kzpsp 3
lagpr lagpr 3
lfgja FiscalYearCurrentPeriod,lfgja 4
lfmon FiscalMonthCurrentPeriod,lfmon 4
lfrhy lfrhy 3
lgfsb lgfsb 3
lgrad lgrad 2
lizyk lizyk 2
loggr loggr,ProductLogisticsHandlingGroup 3
losfx losfx 3
losgr losgr 2
ltinc ltinc 2
lzeih lzeih 2
mabst mabst 3
matgr matgr 2
max_troc max_troc 1
maxls maxls 2
maxlz maxlz 2
mcrue mcrue 3
mdach mdach 3
megru megru,ProductUnitGroup 4
mfrgr MaterialFreightGroup,mfrgr 4
min_troc min_troc 1
minbe minbe 5
minls minls 2
mogru mogru 2
mownr mownr 2
mpdau mpdau 2
mrppp mrppp 3
mtver mtver 4
multiple_ekgrp IsPurgAcrossPurgGroup,multiple_ekgrp 3
ncost ncost 2
nkmpr nkmpr 2
objid objid 3
otype otype 3
periv FiscalYearVariant,perim,periv 7
perkz PeriodType,perkz 7
pfrei pfrei 3
plnnr plnnr 2
plnty plnty 2
plvar plvar 2
ppskz ppskz 2
prefe prefe 3
prenc prenc 3
prend prend 3
prene prene 3
preng preng 3
preno preno 3
prfrq prfrq 3
qmata qmata 2
qssys qssys 2
quazt quazt 2
qzgtp qzgtp 2
rdprf rdprf 3
ref_schema ref_schema 1
resvp resvp 3
rotation_date rotation_date 2
rwpro rwpro 3
servg servg 3
sfty_stk_meth sfty_stk_meth 1
sgt_chint sgt_chint 1
sgt_mrpsi sgt_mrpsi 3
sgt_prcm sgt_prcm 2
sgt_stk_prt sgt_stk_prt 9
shflg shflg 3
shpro shpro 3
shzet shzet 4
sproz sproz 2
ssqss ssqss 3
stawn stawn 3
steuc ConsumptionTaxCtrlCode,steuc 5
stlal stlal 2
stlan stlan 2
takzt takzt 3
target_stock target_stock 1
trame StockInTransitQuantity,trame 9
ucmat OriginalBatchReferenceMaterial,ucmat 3
uid_iea uid_iea 1
umrsl umrsl 2
uomgr uomgr 2
vbamg vbamg 3
vbeaz vbeaz 3
vint1 vint1 5
vint2 vint2 5
vkglg vkglg 3
vktrw vktrw 3
vkumc vkumc 3
vrbdt ConsumptionRefUsageEndDate,vrbdt 4
vrbfk ConsumptionQtyMultiplier,vrbfk 4
vrbmt ConsumptionReferenceProduct,vrbmt 4
vrbwk ConsumptionReferencePlant,vrbwk 4
vrmod vrmod 5
vrvez vrvez 3
vzusl vzusl 2
wstgh wstgh 2
xmcng IsNegativeStockAllowed,xmcng 5

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Extension View for Append /SAPMP/EMARC
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE NSDM_E_MARC (
    ALTSL,
    AUSDT,
    AUSME,
    AUSSS,
    AWSLS,
    BASMG,
    BEARZ,
    BESKZ,
    BSTFE,
    BSTRF,
    BWTTY,
    CUOBJ,
    DISGR,
    DISMM,
    DISPO,
    DZEIT,
    EISBE,
    EKGRP,
    EPRIO,
    FEVOR,
    FFREI,
    FHORI,
    FRTME,
    FXPRU,
    INSMK,
    KAUSF,
    KZAUS,
    KZBED,
    KZDKZ,
    KZECH,
    KZKRI,
    KZPRO,
    LADGR,
    LGPRO,
    LVORM,
    MAABC,
    MANDT,
    MATNR,
    MISKZ,
    MMSTA,
    MMSTD,
    MTVFP,
    NFMAT,
    OCMPF,
    PLIFZ,
    PRCTR,
    PSTAT,
    QMATV,
    RGEKZ,
    RUEZT,
    SAUFT,
    SBDKZ,
    SCHGT,
    SCM_MATLOCID_GUID22,
    SERNP,
    SFCPF,
    SFEPR,
    SGT_COVS,
    SGT_SCOPE,
    SGT_STATC,
    SOBSK,
    SOBSL,
    STDPD,
    STRGR,
    TRANZ,
    UCHKZ,
    UEETK,
    UEETO,
    UMLMC,
    UNETO,
    USEQU,
    VERKZ,
    VSPVB,
    WEBAZ,
    WERKS,
    WZEIT,
    XCHAR,
    XCHPF,
    /CWM/BWESB,
    /CWM/TRAME,
    /CWM/UMLMC,
    /VSO/R_FORK_DIR,
    /VSO/R_LANE_NUM,
    /VSO/R_PAL_VEND,
    /VSO/R_PKGRP,
    ABCIN,
    ABFAC,
    AHDIS,
    APLAL,
    APOKZ,
    ARUN_FIX_BATCH,
    ATPKZ,
    AUFTL,
    AUTRU,
    BSTMA,
    BSTMI,
    BWESB,
    BWSCL,
    CASNR,
    CCFIX,
    COMPL,
    CONS_PROCG,
    CONVT,
    COPAM,
    CUOBV,
    DIBER,
    DISLS,
    DISPR,
    DPLFS,
    DPLHO,
    DPLPU,
    EISLO,
    EXCISE_TAX_RLVNCE,
    EXPME,
    FABKZ,
    FIXLS,
    FPRFM,
    FSH_CALENDAR_GROUP,
    FSH_MG_ARUN_REQ,
    FSH_SEAIM,
    FVIDK,
    FXHOR,
    GI_PR_TIME,
    GLGMG,
    GPMKZ,
    GPNUM,
    HERBL,
    HERKL,
    HERKR,
    INDUS,
    ITARK,
    IUID_RELEVANT,
    IUID_TYPE,
    KAUTB,
    KORDB,
    KZAGL,
    KZDIE,
    KZKFK,
    KZKUP,
    KZPPV,
    KZPSP,
    LAGPR,
    LFGJA,
    LFMON,
    LFRHY,
    LGFSB,
    LGRAD,
    LIZYK,
    LOGGR,
    LOSFX,
    LOSGR,
    LTINC,
    LZEIH,
    MABST,
    MATGR,
    MAX_TROC,
    MAXLS,
    MAXLZ,
    MCRUE,
    MDACH,
    MEGRU,
    MFRGR,
    MIN_TROC,
    MINBE,
    MINLS,
    MOGRU,
    MOWNR,
    MPDAU,
    MRPPP,
    MTVER,
    MULTIPLE_EKGRP,
    NCOST,
    NKMPR,
    OBJID,
    OTYPE,
    PERIV,
    PERKZ,
    PFREI,
    PLNNR,
    PLNTY,
    PLVAR,
    PPSKZ,
    PREFE,
    PRENC,
    PREND,
    PRENE,
    PRENG,
    PRENO,
    PRFRQ,
    QMATA,
    QSSYS,
    QUAZT,
    QZGTP,
    RDPRF,
    REF_SCHEMA,
    RESVP,
    ROTATION_DATE,
    RWPRO,
    SERVG,
    SFTY_STK_METH,
    SGT_CHINT,
    SGT_MRPSI,
    SGT_PRCM,
    SGT_STK_PRT,
    SHFLG,
    SHPRO,
    SHZET,
    SPROZ,
    SSQSS,
    STAWN,
    STEUC,
    STLAL,
    STLAN,
    TAKZT,
    TARGET_STOCK,
    TRAME,
    UCMAT,
    UID_IEA,
    UMRSL,
    UOMGR,
    VBAMG,
    VBEAZ,
    VINT1,
    VINT2,
    VKGLG,
    VKTRW,
    VKUMC,
    VRBDT,
    VRBFK,
    VRBMT,
    VRBWK,
    VRMOD,
    VRVEZ,
    VZUSL,
    WSTGH,
    XMCNG,
    PRIMARY KEY (ALTSL, AUSDT, AUSME, AUSSS, AWSLS, BASMG, BEARZ, BESKZ, BSTFE, BSTRF, BWTTY, CUOBJ, DISGR, DISMM, DISPO, DZEIT, EISBE, EKGRP, EPRIO, FEVOR, FFREI, FHORI, FRTME, FXPRU, INSMK, KAUSF, KZAUS, KZBED, KZDKZ, KZECH, KZKRI, KZPRO, LADGR, LGPRO, LVORM, MAABC, MANDT, MATNR, MISKZ, MMSTA, MMSTD, MTVFP, NFMAT, OCMPF, PLIFZ, PRCTR, PSTAT, QMATV, RGEKZ, RUEZT, SAUFT, SBDKZ, SCHGT, SCM_MATLOCID_GUID22, SERNP, SFCPF, SFEPR, SGT_COVS, SGT_SCOPE, SGT_STATC, SOBSK, SOBSL, STDPD, STRGR, TRANZ, UCHKZ, UEETK, UEETO, UMLMC, UNETO, USEQU, VERKZ, VSPVB, WEBAZ, WERKS, WZEIT, XCHAR, XCHPF)
);

Learn More