SAP Table MARC stores Plant Data for Materialdata

  

In this post, I will try and describe everything you need to know about the SAP marc table. What it is, including what type of data it stores.

A list of fields which make up the table structure and on an S/4Hana System for MARC what does this table look like.

And what relationships it has with other SAP tables.

Also see here for example ABAP code to select data from MARC....Right lets get started!


SAP MARC dictionary attributes

Object Name: MARC
Dictionary Type: Transparent table
Description: Plant Data for Material


MARC field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
MANDTMANDTCLNT3(0) T000ClientMANDTTEST
MATNRMATNRCHAR18(0) MARAMaterial NumberMATNRMATMGS_MAT1MATNR
WERKSWERKS_DCHAR4(0) T001WPlantWERKSWRKKCH_T001W_CWERKS
PSTATPSTAT_DCHAR15(0) Maintenance statusPSTATMG
LVORMLVOWKCHAR1(0) Flag Material for Deletion at Plant LevelXFELDMG
BWTTYBWTTY_DCHAR1(0) T149CValuation CategoryBWTTYMG
XCHARXCHARCHAR1(0) Batch management indicator (internal)XFELDMG
MMSTAMMSTACHAR2(0) T141Plant-Specific Material StatusMMSTAMG
MMSTDMMSTDDATS8(0) Date from which the plant-specific material status is validDATUMMG
MAABCMAABCCHAR1(0) TMABCABC IndicatorMAABCMG
KZKRIKZKRICHAR1(0) Indicator: Critical partXFELDMG
EKGRPEKGRPCHAR3(0) T024Purchasing GroupEKGRPEKGMG
AUSMEAUSMEUNIT3(0) T006Unit of issueMEINSMG
DISPRDISPRCHAR4(0) MDIPMaterial: MRP profileDISPRDPRMG
DISMMDISMMCHAR2(0) T438AMRP TypeDISMMMG
DISPODISPOCHAR3(0) T024DMRP Controller (Materials Planner)DISPODGRMGHS_T024DDISPO
KZDIEKZDIECHAR1(0) Indicator: MRP controller is buyer (deactivated)XFELDMG
PLIFZPLIFZDEC3(0) Planned Delivery Time in DaysDEC3MG
WEBAZWEBAZDEC3(0) Goods Receipt Processing Time in DaysDEC3MG
PERKZPERKZCHAR1(0) Period IndicatorPERKZPKZMP
AUSSSAUSSSDEC5(2) Assembly scrap in percentDEC3_2MG
DISLSDISLSCHAR2(0) T439ALot size (materials planning)DISLSMG
BESKZBESKZCHAR1(0) Procurement TypeBESKZMBSMD
SOBSLSOBSLCHAR2(0) T460ASpecial procurement typeSOBSLMG
MINBEMINBEQUAN13(3) Reorder PointMENG13MG
EISBEEISBEQUAN13(3) Safety StockMENG13MG
BSTMIBSTMIQUAN13(3) Minimum Lot SizeMENG13MG
BSTMABSTMAQUAN13(3) Maximum Lot SizeMENG13MG
BSTFEBSTFEQUAN13(3) Fixed lot sizeMENG13MG
BSTRFBSTRFQUAN13(3) Rounding value for purchase order quantityMENG13MG
MABSTMABSTQUAN13(3) Maximum stock levelMENG13MG
LOSFXLOSFXCURR11(2) Ordering costsWERT11MG
SBDKZSBDKZCHAR1(0) Dependent requirements ind. for individual and coll. reqmtsSBDKZMG
LAGPRLAGPRCHAR1(0) T439LStorage costs indicatorLAGPRMG
ALTSLALTSLCHAR1(0) Method for Selecting Alternative Bills of MaterialALTSLMG
KZAUSKZAUSCHAR1(0) Discontinuation indicatorKZAUSMG
AUSDTAUSDTDATS8(0) Effective-Out DateDATUMMG
NFMATNFMATCHAR18(0) MARAFollow-Up MaterialMATNRMATMG
KZBEDKZBEDCHAR1(0) Indicator for Requirements GroupingKZBEDMG
MISKZMISKZCHAR1(0) Mixed MRP indicatorMISKZMG
FHORIFHORICHAR3(0) T436AScheduling Margin Key for FloatsFHORIMG
PFREIPFREICHAR1(0) Indicator: automatic fixing of planned ordersXFELDMG
FFREIFFREICHAR1(0) Release indicator for production ordersXFELDMG
RGEKZRGEKMCHAR1(0) Indicator: BackflushRGEKM
FEVORFEVORCHAR3(0) T024FProduction SupervisorFEVORCFV
BEARZBEARZDEC5(2) Processing timeDEC3_2MG
RUEZTRUEZTDEC5(2) Setup and teardown timeDEC3_2MG
TRANZTRANZDEC5(2) Interoperation timeDEC3_2MG
BASMGBASMGQUAN13(3) Base quantityMENG13MG
DZEITDZEITDEC3(0) In-house production timeDEC3MG
MAXLZMAXLZDEC5(0) Maximum Storage PeriodDEC5MG
LZEIHLZEIHUNIT3(0) T006Unit for maximum storage periodMEINSMG
KZPROKZPROCHAR1(0) Indicator: withdrawal of stock from production binXFELDMG
GPMKZGPMKZCHAR1(0) Indicator: Material Included in Rough-Cut PlanningXFELDMG
UEETOUEETODEC3(1) Overdelivery tolerance limitDEC2_1MG
UEETKUEETKCHAR1(0) Indicator: Unlimited Overdelivery AllowedXFELDMG
UNETOUNETODEC3(1) Underdelivery tolerance limitDEC2_1MG
WZEITWZEITDEC3(0) Total replenishment lead time (in workdays)DEC3MG
ATPKZATPKZCHAR1(0) Replacement partATPKZMG
VZUSLVZUSLDEC5(2) Surcharge factor for cost in percentDEC3_2MG
HERBLHERBLCHAR2(0) State of manufactureHERBLMG
INSMKINSMK_MATCHAR1(0) Post to Inspection StockQKZMG
SPROZSPROZDEC3(1) Sample for quality inspection (in %) (deactivated)DEC2_1MG
QUAZTQUAZTDEC3(0) Quarantine period (deactivated)DEC3MG
SSQSSQSSPURCHAR8(0) TQ08Control Key for Quality Management in ProcurementQSSPURQSS
MPDAUMPDAUDEC5(0) Mean inspection duration (deactivated)DEC5MG
KZPPVKZPPVCHAR1(0) Indicator for inspection plan (deactivated)KZPPVMG
KZDKZKZDKZCHAR1(0) Documentation required indicatorXFELDMG
WSTGHWSTGHDEC9(0) Active substance content (deactivated)DEC9MG
PRFRQPRFRQDEC5(0) Interval until next recurring inspectionDEC5MG
NKMPRNKMPRDATS8(0) Date according to check sampling inspection (deactivated)DATUMMG
UMLMCUMLMEQUAN13(3) Stock in Transfer (Plant to Plant)MENG13VMG
LADGRLADGRCHAR4(0) TLGRLoading GroupLADGRVV
XCHPFXCHPFCHAR1(0) Batch management requirement indicatorXFELDMG
USEQUUSEQUCHAR1(0) TMQ2Quota arrangement usageUSEQUME
LGRADLGRADDEC3(1) Service levelDEC2_1MG
AUFTLAUFTLCHAR1(0) T439PSplitting IndicatorAUFTLMG
PLVARPLVARCHAR2(0) T778PPlan VersionPLVARPOPPP
OTYPEOTYPECHAR2(0) T778OObject TypeOTYPEPOTPP
OBJIDOBJEKTIDNUMC8(0) Object IDNUM08PONPP
MTVFPMTVFPCHAR2(0) TMVFChecking Group for Availability CheckMTVFPVA
PERIVPERIVCHAR2(0) T009Fiscal Year VariantPERIVSAP
KZKFKKZKFKCHAR1(0) Indicator: take correction factors into accountXFELDMP
VRVEZVRVEZDEC5(2) Shipping setup timeDEC3_2MG
VBAMGVBAMGQUAN13(3) Base quantity for capacity planning in shippingMENG13MG
VBEAZVBEAZDEC5(2) Shipping processing timeDEC3_2MG
LIZYKDUMMYLIZYKCHAR4(0) *DeactivatedCHAR4
BWSCLBWSCLCHAR1(0) TMBW1Source of SupplyBQSCLMW
KAUTBKAUTBCHAR1(0) Indicator: 'automatic purchase order allowed'FLAGMW
KORDBKORDBCHAR1(0) Indicator: Source list requirementXFELDME
STAWNSTAWNCHAR17(0) T604Commodity Code/Import Code Number for Foreign TradeSTAWNVV
HERKLHERKLCHAR3(0) T005Country of origin of the materialLAND1LNDMG
HERKRHERKRCHAR3(0) T005SRegion of origin of material (non-preferential origin)REGIOVV
EXPMEEXPMEUNIT3(0) T006Unit of measure for commodity code (foreign trade)MEINSMG
MTVERMTVERCHAR4(0) TVFMExport/import material groupMTVERVV
PRCTRPRCTRCHAR10(0) *Profit CenterPRCTRPRCKEPRCTR_EMPTYPRCTR
TRAMETRAMEQUAN13(3) Stock in TransitMENG13VMG
MRPPPMRPPPCHAR3(0) T439GPPC planning calendarMRPPPMD
SAUFTSA_SAUFTCHAR1(0) Ind.: Repetitive mfg allowedXFELDMG
FXHORFXHORNUMC3(0) Planning time fenceFXHORMD
VRMODVRMODCHAR1(0) Consumption modeVRMODMD
VINT1VINT1NUMC3(0) Consumption period: backwardVRINTMD
VINT2VINT2NUMC3(0) Consumption period: forwardVRINTMD
VERKZCK_VERK1CHAR1(0) Version IndicatorXFELDCK
STLALSTALTCHAR2(0) Alternative BOMALTNRCS
STLANSTLANCHAR1(0) T416BOM UsageSTLANCSVCS
PLNNRPLNNRCHAR8(0) Key for Task List GroupPLNNRPLNCPPLKSPLNNR
APLALPLNALCHAR2(0) Group CounterALTNRPALCP
LOSGRCK_LOSGRQUAN13(3) Lot Size for Product CostingMENG13CK
SOBSKCK_SOBSLCHAR2(0) T460ASpecial Procurement Type for CostingSOBSLMG
FRTMEFRTMEUNIT3(0) T006Production unitMEINSMG
LGPROLGPROCHAR4(0) T001LIssue Storage LocationLGORT
DISGRDISGRCHAR4(0) T438MMRP GroupDISGRMD
KAUSFKAUSFDEC5(2) Component scrap in percentDEC3_2
QZGTPQZGTYPCHAR4(0) TQ05Certificate TypeQZGTYPQCTQSS
QMATVQMATVCHAR1(0) Inspection Setup Exists for Material/PlantXFELD
TAKZTTAKZTDEC3(0) Takt timeDEC3MG
RWPRORWPROCHAR3(0) T438RRange of coverage profileRWPRO
COPAMCOPAMCHAR10(0) Local field name for CO/PA link to SOPOLD_FDNAMEDFDSDIC
ABCINABCINCHAR1(0) T159CPhysical inventory indicator for cycle countingABCIN
AWSLSAWSLSCHAR6(0) TKV01Variance KeyAWSLSKV
SERNPSERAILCHAR4(0) T377PSerial Number ProfileSERAIL
CUOBJCUOBMNUMC18(0) Internal object numberCUOBJ
STDPDSTDPDCHAR18(0) MARAConfigurable materialMATNRMG
SFEPRSFEPRCHAR4(0) T437SRepetitive manufacturing profileSFEPR
XMCNGXMCNGCHAR1(0) Negative stocks allowed in plantXFELD
QSSYSQSSYS_SOLLCHAR4(0) TQ02Required QM System for VendorQSSYS
LFRHYLFRHYCHAR3(0) T439GPlanning cycleMRPPP
RDPRFRDPRFCHAR4(0) RDPRRounding ProfileRDPRF
VRBMTVRBMTCHAR18(0) MARAReference material for consumptionMATNR
VRBWKVRBWKCHAR4(0) T001WReference plant for consumptionWERKS
VRBDTVRBDTDATS8(0) To date of the material to be copied for consumptionDATUM
VRBFKVRBFKDEC4(2) Multiplier for reference material for consumptionDEC2_2
AUTRUAUTRUCHAR1(0) Reset Forecast Model AutomaticallyXFELD
PREFEPREFECHAR1(0) Preference indicator in export/importPREFE
PRENCPRENCCHAR1(0) Exemption certificate: Indicator for legal controlPRENC
PRENOPRENNCHAR8(0) Exemption certificate number for legal controlPRENN
PRENDPRENDDATS8(0) Exemption certificate: Issue date of exemption certificatePREND
PRENEPRENECHAR1(0) Indicator: Vendor declaration existsPRENEPNE
PRENGPRENGDATS8(0) Validity date of vendor declarationPRENGPNG
ITARKITARKCHAR1(0) Indicator: Military goodsXFELD
SERVGW_SERVGRDCHAR1(0) TWSGIS-R service levelW_SERVGRD
KZKUPKZKUPMATCHAR1(0) Indicator: Material can be co-productFLAG
STRGRSTRGRCHAR2(0) T461PPlanning strategy groupSTRGR
CUOBVCUOBVNUMC18(0) Internal object number of configurable material for planningCUOBJ
LGFSBLGFSBCHAR4(0) T001LDefault storage location for external procurementLGORT
SCHGTSCHGTCHAR1(0) Indicator: Bulk MaterialXFELDCS
CCFIXCCFIXCHAR1(0) CC indicator is fixedXFELD
EPRIOBF_GROUPCHAR4(0) T434GStock determination groupBF_GROUP
QMATAQMATAUTHCHAR6(0) TQ01BMaterial Authorization Group for Activities in QMQMATAUTH
RESVPRESVPDEC3(0) Period of adjustment for planned independent requirementsRESVP
PLNTYPLNTYCHAR1(0) TCA01Task List TypePLNTYPTYCNH_TCA01PLNTY
UOMGROIB_UOMGRCHAR3(0) OIB06Unit of Mearsure Group (Oil, Natural Gas,...)OIB_UOMGR
UMRSLOIB_UMRSLCHAR4(0) OIB01Conversion Group (Oil, Natural Gas,..)OIB_UMRSL
ABFACOIL_ABFACDEC2(1) *Air Bouyancy FactorOIL_ABFACOIL_ABFAC_VALUESOIL_ABFAC
SFCPFCO_PRODPRFCHAR6(0) TCO43Production Scheduling ProfileCO_PRODPRF
SHFLGSHFLGCHAR1(0) Safety time indicator (with or without safety time)SHFLG
SHZETSHZETNUMC2(0) Safety time (in workdays)NUMC2
MDACHMDACHCHAR2(0) T46ACAction control: planned order processingMDACH
KZECHKZECHCHAR1(0) Determination of batch entry in the production/process orderKZECH
MEGRUMEGRUCHAR4(0) TWMEGUnit of Measure GroupMEGRU
MFRGRMFRGRCHAR8(0) TMFGMaterial freight groupMFRGR
.INCLU--AP0(0)
PROFILPPC_PROFILE_NAMECHAR4(0) PPC_PROFILEName of Backflush ProfilePPC_PROFILE_NAME
VERS_CSEGVERS_CSEGCHAR1(0) Plant Data for Material Versions ActiveVERS_CSEG
VERS_ACTIVEVERS_ACTIVECHAR1(0) Material Versions Logistic Switch / Version LevelVERS_ACTIVE
VKUMCVKUMCCURR13(2) Stock transfer sales value (plant to plant) for VO materialWERT13N
VKTRWVKTRWCURR13(2) Transit value at sales price for value-only materialWERT13N
KZAGLKZAGLCHAR1(0) Indicator: smooth promotion consumptionKZAGL
FVIDKCK_VERIDCHAR4(0) *Production Version To Be CostedVERID
FXPRUCK_FIXPRKUCHAR1(0) Fixed-Price Co-ProductXFELD
LOGGRLOGGRCHAR4(0) TLOGLogistics handling group for workload calculationLOGGR
FPRFMFPRFMCHAR3(0) TMFPFDistribution profile of material in plantMPPRF
GLGMGGLGMGQUAN13(3) Tied Empties StockMENG13V
VKGLGVKGLGCURR13(2) Sales value of tied empties stockWERT13N
INDUSJ_1BINDUS3CHAR2(0) Material CFOP categoryJ_1BINDUS3
MOWNRMOWNRCHAR12(0) T618MCAP: Number of CAP products listMOWNR
MOGRUMOGRUCHAR6(0) T618GCommon Agricultural Policy: CAP products group-Foreign TradeMOGRU
CASNRCASNRCHAR15(0) T610CCAS number for pharmaceutical products in foreign tradeCASNR
GPNUMGPNUMCHAR9(0) T609GProduction statistics: PRODCOM number for foreign tradeGPNUM
STEUCSTEUCCHAR16(0) T604FControl code for consumption taxes in foreign tradeSTEUC
FABKZFABKZCHAR1(0) Indicator: Item Relevant to JIT Delivery SchedulesFABKZ
MATGRMATNRGROUPCHAR20(0) Group of Materials for Transition MatrixCHAR20
VSPVBVSPVBCHAR10(0) PVBEProposed Supply Area in Material Master RecordPRVBE
DPLFSDPLFSCHAR2(0) Fair share ruleDPLFS
DPLPUDPLPUCHAR1(0) Indicator: push distributionDPLPU
DPLHODPLHODEC3(0) Deployment horizon in daysDEC3
MINLSCSCP_MINLOTSIZEQUAN13(3) Minimum lot size for Supply Demand MatchMENG13
MAXLSCSCP_MAXLOTSIZEQUAN13(3) Maximum lot size for Supply Demand MatchMENG13
FIXLSCSCP_FIXLOTSIZEQUAN13(3) Fixed lot size for Supply Demand MatchMENG13
LTINCCSCP_LOTINCREMENTQUAN13(3) Lot size increment for Supply Demand MatchMENG13
COMPLCSCP_DUMMYNUMC2(0) TCSCP_COMP_LVLThis field is no longer usedCSCP_COMP_LVL
CONVTCSCP_CONV_TYPECHAR2(0) TCSCP_CONV_TYPEConversion types for production figuresCSCP_CONV_TYPE
SHPROSHPROCHAR3(0) T438VPeriod Profile for Safety TimeSHPRO
AHDISAHDISCHAR1(0) MRP relevancy for dependent requirementsAHDIS
DIBERDIBERCHAR1(0) Indicator: MRP area existsXFELD
KZPSPKZPSPCHAR1(0) Indicator for cross-project materialKZPSP
OCMPFOCM_GPROFILECHAR6(0) TCO48Overall profile for order change managementCHAR6
APOKZAPOKZCHAR1(0) Indicator: Is material relevant for APOAPOKZ
MCRUEMCRUECHAR1(0) MARDH rec. already exists for per. before last of MARD per.XFELD
LFMONLFMONNUMC2(0) Current period (posting period)MONATMG
LFGJALFGJANUMC4(0) Fiscal Year of Current PeriodGJAHRMG
EISLOEISLOQUAN13(3) Minimum Safety StockMENG13
NCOSTCK_NO_COSTINGCHAR1(0) Do Not CostCK_NO_COSTING
ROTATION_DATEROTATION_DATECHAR1(0) Strategy for Putaway and Stock RemovalROTATION_DATE
UCHKZUCHKZCHAR1(0) Indicator for Original Batch ManagementUCHKZ
UCMATVBOB_OB_RFMATCHAR18(0) MARAReference Material for Original BatchesMATNRMAT1MATNR
BWESBBWESBQUAN13(3) Valuated Goods Receipt Blocked StockMENG13V
.INCLU--AP0(0)
/MRSS/PROF_GUIDGUID_32CHAR32(0) GUID in 'CHAR' Format in UppercaseSYSUUID_C
/MRSS/PROF_KEY/MRSS/T_RSG_REQUIDCHAR10(0) Profile Key/MRSS/RSG_REQUID
/MRSS/DATACHANGE/MRSS/T_USCREENCTL_DATACHANGEDCHAR1(0) Data was changed in the controls on the user screenFLAG
.INCLU--AP0(0)
NF_FLAG/NFM/NFMATCHAR1(0) Indicator: Material Contains NF MetalsFLAG
.INCLU--AP0(0)
/SAPMP/TOLPRPL/SAPMP/TOLPRPLDEC3(1) Percentage Tolerance PlusPRZ21
/SAPMP/TOLPRMI/SAPMP/TOLPRMIDEC3(1) Percentage Tolerance MinusPRZ21
.INCLU--AP0(0)
/VSO/R_PKGRP/VSO/M_PKGRPCHAR18(0) /VSO/M_PKGPacking Group of the Material (VSO)/VSO/M_PKGRP
/VSO/R_LANE_NUM/VSO/M_LANE_NUMCHAR3(0) Line within the Automatic Picking Zone (VSO)/VSO/M_LANE_NUM
/VSO/R_PAL_VEND/VSO/R_MATNR_PAL_VENDCHAR18(0) *Material No. of the Packaging Material of the Vendor (VSO)MATNR/VSO/R_SH_PALMATNR
/VSO/R_FORK_DIR/VSO/M_FORK_DIRCHAR1(0) Pick Packaging Materials only Lengthwise (VSO)/VSO/M_XFIELD
.INCLU--AP0(0)
IUID_RELEVANTIUID_RELEVANTCHAR1(0) IUID-RelevantUID_RELEVANT
IUID_TYPEIUID_TYPECHAR10(0) TIUID_TYPEStructure Type of UIIIUID_TYPEH_IUID_TYPEIUID_TYPE
UID_IEAUID_IEACHAR1(0) External Allocation of UIIUID_IEA
.INCLU--AP0(0)
DPCBTMILL_DPCBTCHAR1(0) Single-Unit Batch Def. ValueMILL_DPCBT
.INCLU--AP0(0)
CONS_PROCGWRF_CONS_PROCGCHAR1(0) WRFT_CONS_PROCGConsignment ControlWRF_CONS_PROCG
GI_PR_TIMEWRF_PSCD_WABAZDEC3(0) Goods Issue Processing Time in DaysDEC3
MULTIPLE_EKGRPWRF_POHF_OTHER_EKGRP_ALLOWCHAR1(0) Purchasing Across Purchasing GroupCHAR1_X
REF_SCHEMAWRF_REF_SCHEMACHAR2(0) WRF_REF_RFSReference Determination SchemaWRF_REF_SCHEMA
MIN_TROCWRF_FRE_TROC_MINNUMC3(0) Minimum Target Range of CoverageWRF_FRE_TROC
MAX_TROCWRF_FRE_TROC_MAXNUMC3(0) Maximum Target Range of CoverageWRF_FRE_TROC
TARGET_STOCKWRF_FRE_TARGET_STOCKQUAN13(3) Target StockMENG13
.INCLU--AP0(0)
OITAXGRPOIH_TAXGRPCHAR2(0) OIH2Excise Duty GroupOIH_TAXGRP
OIOILCONOIH_OILCONDEC5(2) Oil content in a material as a percentageOIH_OILCON
OIEDCODEOIH_EDCODECHAR12(0) Customs tariff numberOIH_EDCODE
FDICHOIB_FDICHFLTP16(16) Fixed DensityOIB_DICHT
COEFFOIB_COEFFFLTP16(16) Quantity Conversion CoefficientOIB_COEFF