SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6/1RA/0SD010MI170Items for Class SD01 - Raw Data
7/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
8AUDLORIPR7KPro: Logical Information Object Attribute Values
9BSEG345Accounting Document Segment
10/OPT/Z1344Reporting table: Text table for exception definitions

B1 9.2: Top 10 requests

TableColumnsDescription
1OINV386A/R Invoice
2OITM299Items
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OACT114G/L Accounts

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OIVL77Whse Journal
6OPCH268A/P Invoice
7OOCR9Loading Factors
8JDT1110Journal Entry - Rows
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool
1ERP EHP76.0/SMERP/STG_MM0014293Data staging - Material master plant view complex table
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, DSF_GUID, DSF_DSTORE_ID, USER_GUID, DSF_RECORD_ID, DSF_CHANGED_BY, DSF_CHANGED_TS, MATNR, VPSTA, 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, KUNNR, EANNR, WESCH, BWVOR, SAISO, ETIAR, ETIFO, ENTAR, EAN11, NUMTP, LAENG, BREIT, HOEHE, MEABM, PRDHA, AEKLK, CADKZ, QMPUR, ERGEW, ERGEI, ERVOL, ERVOE, GEWTO, VOLTO, VABME, KZREV, KZKFG, VHART, FUELG, STFAK, MAGRV, BEGRU, DATAB, LIQDT, SAISJ, PLGTP, MLGUT, EXTWG, SATNR, ATTYP, KZNFM, PMATA, MSTAE, MSTAV, MSTDE, MSTDV, TAKLV, RBNRM, MHDRZ, MHDHB, MHDLP, INHME, INHAL, VPREH, ETIAG, INHBR, CMETH, CUOBF, KZUMW, KOSCH, SPROF, NRFHG, MFRPN, MFRNR, BMATN, MPROF, KZWSM, SAITY, PROFL, IHIVI, ILOOS, SERLV, KZGVH, XGCHP, KZEFF, 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, QQTIME, QQTIMEUOM, QGRP, SERIAL, PS_SMARTFORM, LOGUNIT, CWQREL, CWQPROC, CWQTOLGR, /BEV1/LULEINH, /BEV1/LULDEGRP, /DSD/VC_GROUP, /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, MCOND, RETDELC, LOGLEV_RETO, NSNID, 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, MAKTX, WERKS, PSTAT, LVORM, BWTTY, XCHAR, MMSTA, MMSTD, MAABC, KZKRI, EKGRP, AUSME, DISPR, DISMM, DISPO, KZDIE, PLIFZ, WEBAZ, PERKZ, AUSSS, DISLS, BESKZ, SOBSL, MINBE, EISBE, BSTMI, BSTMA, BSTFE, BSTRF, MABST, LOSFX, SBDKZ, LAGPR, ALTSL, KZAUS, AUSDT, NFMAT, KZBED, MISKZ, FHORI, PFREI, FFREI, RGEKZ, FEVOR, BEARZ, RUEZT, TRANZ, BASMG, DZEIT, MAXLZ, LZEIH, KZPRO, GPMKZ, UEETO, UEETK, UNETO, WZEIT, ATPKZ, VZUSL, HERBL, INSMK, SPROZ, QUAZT, SSQSS, MPDAU, KZPPV, KZDKZ, WSTGH, PRFRQ, NKMPR, UMLMC, LADGR, XCHPF, USEQU, LGRAD, AUFTL, PLVAR, OTYPE, OBJID, MTVFP, PERIV, KZKFK, VRVEZ, VBAMG, VBEAZ, LIZYK, BWSCL, KAUTB, KORDB, STAWN, HERKL, HERKR, EXPME, MTVER, PRCTR, TRAME, MRPPP, SAUFT, FXHOR, VRMOD, VINT1, VINT2, VERKZ, STLAL, STLAN, PLNNR, APLAL, LOSGR, SOBSK, FRTME, LGPRO, DISGR, KAUSF, QZGTP, QMATV, TAKZT, RWPRO, COPAM, ABCIN, AWSLS, SERNP, CUOBJ, STDPD, SFEPR, XMCNG, QSSYS, LFRHY, RDPRF, VRBMT, VRBWK, VRBDT, VRBFK, AUTRU, PREFE, PRENC, PRENO, PREND, PRENE, PRENG, ITARK, SERVG, KZKUP, STRGR, CUOBV, LGFSB, SCHGT, CCFIX, EPRIO, QMATA, RESVP, PLNTY, UOMGR, UMRSL, ABFAC, SFCPF, SHFLG, SHZET, MDACH, KZECH, MEGRU, MFRGR, VKUMC, VKTRW, KZAGL, FVIDK, FXPRU, LOGGR, FPRFM, GLGMG, VKGLG, INDUS, MOWNR, MOGRU, CASNR, GPNUM, STEUC, FABKZ, MATGR, VSPVB, DPLFS, DPLPU, DPLHO, MINLS, MAXLS, FIXLS, LTINC, COMPL, CONVT, SHPRO, AHDIS, DIBER, KZPSP, OCMPF, APOKZ, MCRUE, LFMON, LFGJA, EISLO, NCOST, ROTATION_DATE, UCHKZ, UCMAT, BWESB, SGT_COVS, SGT_STATC, SGT_SCOPE, SGT_MRPSI, SGT_PRCM, SGT_CHINT, SGT_STK_PRT, SGT_DEFSC, FSH_MG_ARUN_REQ, FSH_SEAIM, /MRSS/PROF_GUID, /MRSS/PROF_KEY, /MRSS/DATACHANGE, /SAPMP/TOLPRPL, /SAPMP/TOLPRMI, /VSO/R_PKGRP, /VSO/R_LANE_NUM, /VSO/R_PAL_VEND, /VSO/R_FORK_DIR, IUID_RELEVANT, IUID_TYPE, UID_IEA, CONS_PROCG, GI_PR_TIME, MULTIPLE_EKGRP, REF_SCHEMA, MIN_TROC, MAX_TROC, TARGET_STOCK FROM /SMERP/STG_MM001
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2DSF_GUIDDSF GUIDnvarchar320CHAR(N' ')No/SMFND/DSF_GUID_DTE Allow NULL? 
3DSF_DSTORE_IDData Store IDnvarchar400CHAR(N' ')Yes*/SMFND/DSF_DSTORE_ID_DTE Allow NULL? 
4USER_GUIDUser GUIDnvarchar320CHAR(N' ')Yes/SYCLO/CORE_USER_GUID_DTE Allow NULL? 
5DSF_RECORD_IDDSF Record IDnvarchar100NUMC(N'0000000000')Yes/SMFND/DSF_RECORD_ID_DTE Allow NULL? 
6DSF_CHANGED_BYLast Changed Bynvarchar120CHAR(N' ')Yes/SYCLO/CORE_CHANGEDBY_DTE Allow NULL? 
7DSF_CHANGED_TSChanged time stampdecimal150DEC((0))Yes/SYCLO/CORE_CHANGEDTS_DTE
8MATNRMaterial Numbernvarchar180CHAR(N' ')Yes*MATNR Allow NULL? 
9VPSTAMaintenance status of complete materialnvarchar150CHAR(N' ')YesVPSTA Allow NULL? 
10MTARTMaterial Typenvarchar40CHAR(N' ')YesT134MTART Allow NULL? 
11MBRSHIndustry sectorchar10CHAR(N' ')YesT137MBRSH Allow NULL? 
12MATKLMaterial Groupnvarchar90CHAR(N' ')YesT023MATKL Allow NULL? 
13BISMTOld material numbernvarchar180CHAR(N' ')YesBISMT Allow NULL? 
14MEINSBase Unit of Measurenvarchar30UNIT(N' ')YesT006MEINS Allow NULL? 
15BSTMEPurchase Order Unit of Measurenvarchar30UNIT(N' ')YesT006BSTME Allow NULL? 
16ZEINRDocument number (without document management system)nvarchar220CHAR(N' ')YesDZEINR Allow NULL? 
17ZEIARDocument type (without Document Management system)nvarchar30CHAR(N' ')YesDZEIAR Allow NULL? 
18ZEIVRDocument version (without Document Management system)nvarchar20CHAR(N' ')YesDZEIVR Allow NULL? 
19ZEIFOPage format of document (without Document Management system)nvarchar40CHAR(N' ')YesDZEIFO Allow NULL? 
20AESZNDocument change number (without document management system)nvarchar60CHAR(N' ')YesAESZN Allow NULL? 
21BLATTPage number of document (without Document Management system)nvarchar30CHAR(N' ')YesBLATT Allow NULL? 
22BLANZNumber of sheets (without Document Management system)nvarchar30NUMC(N'000')YesBLANZ Allow NULL? 
23FERTHProduction/inspection memonvarchar180CHAR(N' ')YesFERTH Allow NULL? 
24FORMTPage Format of Production Memonvarchar40CHAR(N' ')YesFORMT Allow NULL? 
25GROESSize/dimensionsnvarchar320CHAR(N' ')YesGROES Allow NULL? 
26WRKSTBasic Materialnvarchar480CHAR(N' ')YesTWSPRWRKST Allow NULL? 
27NORMTIndustry Standard Description (such as ANSI or ISO)nvarchar180CHAR(N' ')YesNORMT Allow NULL? 
28LABORLaboratory/design officenvarchar30CHAR(N' ')YesT024LLABOR Allow NULL? 
29EKWSLPurchasing Value Keynvarchar40CHAR(N' ')YesT405EKWSL Allow NULL? 
30BRGEWGross Weightdecimal133QUAN((0))YesBRGEW
31NTGEWNet Weightdecimal133QUAN((0))YesNTGEW
32GEWEIWeight Unitnvarchar30UNIT(N' ')YesT006GEWEI Allow NULL? 
33VOLUMVolumedecimal133QUAN((0))YesVOLUM
34VOLEHVolume unitnvarchar30UNIT(N' ')YesT006VOLEH Allow NULL? 
35BEHVOContainer requirementsnvarchar20CHAR(N' ')YesT144BEHVO Allow NULL? 
36RAUBEStorage conditionsnvarchar20CHAR(N' ')YesT142RAUBE Allow NULL? 
37TEMPBTemperature conditions indicatornvarchar20CHAR(N' ')YesT143TEMPB Allow NULL? 
38DISSTLow-Level Codenvarchar30CHAR(N' ')YesDISST Allow NULL? 
39TRAGRTransportation Groupnvarchar40CHAR(N' ')YesTTGRTRAGR Allow NULL? 
40STOFFHazardous material numbernvarchar180CHAR(N' ')YesMGEFSTOFF Allow NULL? 
41SPARTDivisionnvarchar20CHAR(N' ')YesTSPASPART Allow NULL? 
42KUNNRCompetitornvarchar100CHAR(N' ')YesV_KNA1WETTWETTB Allow NULL? 
43EANNREuropean Article Number (EAN) - obsolete!!!!!nvarchar130CHAR(N' ')YesEANNR Allow NULL? 
44WESCHQuantity: Number of GR/GI slips to be printeddecimal133QUAN((0))YesWESCH
45BWVORProcurement rulechar10CHAR(N' ')YesT6WP1BWVOR Allow NULL? 
46SAISOSeason Categorynvarchar40CHAR(N' ')YesT6WSPSAISO Allow NULL? 
47ETIARLabel typenvarchar20CHAR(N' ')YesT6WP3ETIAR Allow NULL? 
48ETIFOLabel formnvarchar20CHAR(N' ')YesT6WP4ETIFO Allow NULL? 
49ENTARDeactivatedchar10CHAR(N' ')YesDUMMYENTAR Allow NULL? 
50EAN11International Article Number (EAN/UPC)nvarchar180CHAR(N' ')YesEAN11 Allow NULL? 
51NUMTPCategory of International Article Number (EAN)nvarchar20CHAR(N' ')YesTNTPNUMTP Allow NULL? 
52LAENGLengthdecimal133QUAN((0))YesLAENG
53BREITWidthdecimal133QUAN((0))YesBREIT
54HOEHEHeightdecimal133QUAN((0))YesHOEHE
55MEABMUnit of Dimension for Length/Width/Heightnvarchar30UNIT(N' ')YesT006MEABM Allow NULL? 
56PRDHAProduct hierarchynvarchar180CHAR(N' ')YesT179PRODH_D Allow NULL? 
57AEKLKStock Transfer Net Change Costingchar10CHAR(N' ')YesCK_AEKLK Allow NULL? 
58CADKZCAD Indicatorchar10CHAR(N' ')YesCADKZ Allow NULL? 
59QMPURQM in Procurement is Activechar10CHAR(N' ')YesQMPUR Allow NULL? 
60ERGEWAllowed packaging weightdecimal133QUAN((0))YesERGEW
61ERGEIUnit of weight (allowed packaging weight)nvarchar30UNIT(N' ')YesT006ERGEI Allow NULL? 
62ERVOLAllowed packaging volumedecimal133QUAN((0))YesERVOL
63ERVOEVolume unit (allowed packaging volume)nvarchar30UNIT(N' ')YesT006ERVOE Allow NULL? 
64GEWTOExcess Weight Tolerance for Handling unitdecimal31DEC((0))YesGEWTO
65VOLTOExcess Volume Tolerance of the Handling Unitdecimal31DEC((0))YesVOLTO
66VABMEVariable Purchase Order Unit Activechar10CHAR(N' ')YesVABME Allow NULL? 
67KZREVRevision Level Has Been Assigned to the Materialchar10CHAR(N' ')YesKZREV Allow NULL? 
68KZKFGConfigurable Materialchar10CHAR(N' ')YesKZKFG Allow NULL? 
69VHARTPackaging Material Typenvarchar40CHAR(N' ')YesTVTYVHIART Allow NULL? 
70FUELGMaximum level (by volume)decimal30DEC((0))YesFUELG
71STFAKStacking factorsmallint50INT2((0))YesSTFAK
72MAGRVMaterial Group: Packaging Materialsnvarchar40CHAR(N' ')YesTVEGRMAGRV Allow NULL? 
73BEGRUAuthorization Groupnvarchar40CHAR(N' ')YesBEGRU Allow NULL? 
74DATABValid-From Datenvarchar80DATS(N'00000000')YesDATAB Allow NULL? 
75LIQDTDeletion datenvarchar80DATS(N'00000000')YesLIQDT Allow NULL? 
76SAISJSeason Yearnvarchar40CHAR(N' ')YesSAISJ Allow NULL? 
77PLGTPPrice Band Categorynvarchar20CHAR(N' ')YesTWPTPLGTP Allow NULL? 
78MLGUTEmpties Bill of Materialchar10CHAR(N' ')YesW_MITLEERG Allow NULL? 
79EXTWGExternal Material Groupnvarchar180CHAR(N' ')YesTWEWEXTWG Allow NULL? 
80SATNRCross-Plant Configurable Materialnvarchar180CHAR(N' ')YesMARASATNR Allow NULL? 
81ATTYPMaterial Categorynvarchar20CHAR(N' ')YesATTYP Allow NULL? 
82KZNFMIndicator: The material has a follow-up materialchar10CHAR(N' ')YesKZNFM Allow NULL? 
83PMATAPricing Reference Materialnvarchar180CHAR(N' ')YesMARAPMATN Allow NULL? 
84MSTAECross-Plant Material Statusnvarchar20CHAR(N' ')YesT141MSTAE Allow NULL? 
85MSTAVCross-distribution-chain material statusnvarchar20CHAR(N' ')YesTVMSMSTAV Allow NULL? 
86MSTDEDate from which the cross-plant material status is validnvarchar80DATS(N'00000000')YesMSTDE Allow NULL? 
87MSTDVDate from which the X-distr.-chain material status is validnvarchar80DATS(N'00000000')YesMSTDV Allow NULL? 
88TAKLVTax classification of the materialchar10CHAR(N' ')YesTSKMTAKLV Allow NULL? 
89RBNRMCatalog Profilenvarchar90CHAR(N' ')YesT352BRBNR Allow NULL? 
90MHDRZMinimum Remaining Shelf Lifedecimal40DEC((0))YesMHDRZ
91MHDHBTotal shelf lifedecimal40DEC((0))YesMHDHB
92MHDLPStorage percentagedecimal30DEC((0))YesMHDLP
93INHMEContent unitnvarchar30UNIT(N' ')YesT006INHME Allow NULL? 
94INHALNet contentsdecimal133QUAN((0))YesINHAL
95VPREHComparison price unitdecimal50DEC((0))YesVPREH
96ETIAGIS-R Labeling: material grouping (deactivated in 4.0)nvarchar180CHAR(N' ')Yes*ETIAG Allow NULL? 
97INHBRGross contentsdecimal133QUAN((0))YesINHBR
98CMETHQuantity Conversion Methodchar10CHAR(N' ')YesOIB_CMETH Allow NULL? 
99CUOBFInternal object numbernvarchar180NUMC(N'000000000000000000')YesCUOBM Allow NULL? 
100KZUMWEnvironmentally Relevantchar10CHAR(N' ')YesKZUMW Allow NULL? 
101KOSCHProduct allocation determination procedurenvarchar180CHAR(N' ')YesT190SKOSCH Allow NULL? 
102SPROFPricing profile for variantschar10CHAR(N' ')YesSPROF Allow NULL? 
103NRFHGMaterial qualifies for discount in kindchar10CHAR(N' ')YesNRFHG Allow NULL? 
104MFRPNManufacturer Part Numbernvarchar400CHAR(N' ')YesMFRPN Allow NULL? 
105MFRNRNumber of a Manufacturernvarchar100CHAR(N' ')YesLFA1MFRNR Allow NULL? 
106BMATNNumber of firm's own (internal) inventory-managed materialnvarchar180CHAR(N' ')YesMARAMPMAT Allow NULL? 
107MPROFManufacturer Part Profilenvarchar40CHAR(N' ')YesTMPPFMPROF Allow NULL? 
108KZWSMUnits of measure usagechar10CHAR(N' ')YesKZWSO Allow NULL? 
109SAITYRollout in a Seasonnvarchar20CHAR(N' ')YesT6WSASAITY Allow NULL? 
110PROFLDangerous Goods Indicator Profilenvarchar30CHAR(N' ')YesTDG41ADGE_PROFL Allow NULL? 
111IHIVIIndicator: Highly Viscouschar10CHAR(N' ')YesADGE_IHIVI Allow NULL? 
112ILOOSIndicator: In Bulk/Liquidchar10CHAR(N' ')YesADGE_ILOOS Allow NULL? 
113SERLVLevel of Explicitness for Serial Numberchar10CHAR(N' ')YesSERLV Allow NULL? 
114KZGVHPackaging Material is Closed Packagingchar10CHAR(N' ')YesKZGVH Allow NULL? 
115XGCHPIndicator: Approved batch record requiredchar10CHAR(N' ')YesXGCHP Allow NULL? 
116KZEFFAssign effectivity parameter values/ override change numberschar10CHAR(N' ')YesCC_MTEFF Allow NULL? 
117IPRKZPeriod Indicator for Shelf Life Expiration Datechar10CHAR(N' ')YesDATTP Allow NULL? 
118RDMHDRounding rule for calculation of SLEDchar10CHAR(N' ')YesRDMHD Allow NULL? 
119PRZUSIndicator: Product composition printed on packagingchar10CHAR(N' ')YesPRZUS Allow NULL? 
120MTPOS_MARAGeneral item category groupnvarchar40CHAR(N' ')YesTPTMMTPOS_MARA Allow NULL? 
121BFLMEGeneric Material with Logistical Variantschar10CHAR(N' ')YesBFLME Allow NULL? 
122MATFIMaterial Is Lockedchar10CHAR(N' ')YesMATFI Allow NULL? 
123CMRELRelevant for Configuration Managementchar10CHAR(N' ')YesDE_CM_RELEVANCE_FLAG Allow NULL? 
124BBTYPAssortment List Typechar10CHAR(N' ')Yes*BBTYP Allow NULL? 
125SLED_BBDExpiration Datechar10CHAR(N' ')YesSLED_BBD Allow NULL? 
126GTIN_VARIANTGlobal Trade Item Number Variantnvarchar20CHAR(N' ')YesGTIN_VARIANT Allow NULL? 
127GENNRMaterial Number of the Generic Material in Prepack Materialsnvarchar180CHAR(N' ')YesMARAWSTR_SATNR_PP Allow NULL? 
128RMATPReference material for materials packed in same waynvarchar180CHAR(N' ')YesMARAPL_RMATP Allow NULL? 
129GDS_RELEVANTIndicator: Global Data Synchronization-Relevantchar10CHAR(N' ')YesGDS_RELEVANT Allow NULL? 
130WEORAAcceptance At Originchar10CHAR(N' ')YesWEORA Allow NULL? 
131HUTYP_DFLTStandard HU Typenvarchar40CHAR(N' ')YesTHUTYPCIFHUTYPDF Allow NULL? 
132PILFERABLEPilferablechar10CHAR(N' ')YesCIFPILFRBL Allow NULL? 
133WHSTCWarehouse Storage Conditionnvarchar20CHAR(N' ')YesTWHSTCCIFWHSTC Allow NULL? 
134WHMATGRWarehouse Material Groupnvarchar40CHAR(N' ')YesTWHMATGRCIFWHMATGR Allow NULL? 
135HNDLCODEHandling Indicatornvarchar40CHAR(N' ')YesTHNDLCDCIFHDLCODE Allow NULL? 
136HAZMATRelevant for Hazardous Substanceschar10CHAR(N' ')YesCIFHAZMAT Allow NULL? 
137HUTYPHandling Unit Typenvarchar40CHAR(N' ')YesTHUTYPCIFHUTYP Allow NULL? 
138TARE_VARVariable Tare Weightchar10CHAR(N' ')YesCIFTAREVAR Allow NULL? 
139MAXCMaximum Allowed Capacity of Packaging Materialdecimal153DEC((0))YesCIFMAXC
140MAXC_TOLOvercapacity Tolerance of the Handling Unitdecimal31DEC((0))YesCIFMAXCTOL
141MAXLMaximum Packing Length of Packaging Materialdecimal153QUAN((0))YesCIFMAXL
142MAXBMaximum Packing Width of Packaging Materialdecimal153QUAN((0))YesCIFMAXB
143MAXHMaximum Packing Height of Packaging Materialdecimal153QUAN((0))YesCIFMAXH
144MAXDIM_UOMUnit of Measure for Maximum Packing Length/Width/Heightnvarchar30UNIT(N' ')YesT006CIFMAXDUOM Allow NULL? 
145QQTIMEQuarantine Perioddecimal30QUAN((0))YesCIFQQTIME
146QQTIMEUOMTime Unit for Quarantine Periodnvarchar30UNIT(N' ')YesT006CIFQQTIMEUOM Allow NULL? 
147QGRPQuality Inspection Groupnvarchar40CHAR(N' ')YesTQGRPCIFQGRP Allow NULL? 
148SERIALSerial Number Profilenvarchar40CHAR(N' ')YesTSERIALCIFSERIAL Allow NULL? 
149PS_SMARTFORMForm Namenvarchar300CHAR(N' ')YesSTXFADMCIFPSSFNAME Allow NULL? 
150LOGUNITEWM CW: Logistics Unit of Measurenvarchar30UNIT(N' ')YesMARMCIFLOGUNIT Allow NULL? 
151CWQRELEWM CW: Material Is a Catch Weight Materialchar10CHAR(N' ')YesCIFCWQREL Allow NULL? 
152CWQPROCEWM CW: Catch Weight Profile for Entering CW Quantitynvarchar20CHAR(N' ')YesTCWQPROCCIFCWQPROC Allow NULL? 
153CWQTOLGREWM-CW: Catch Weight Tolerance Group for EWMnvarchar90CHAR(N' ')YesTCWQTOLGRCIFCWQTOLGR Allow NULL? 
154/BEV1/LULEINHLoading Unitsnvarchar80NUMC(N'00000000')Yes/BEV1/LULEINH Allow NULL? 
155/BEV1/LULDEGRPLoading Unit Group: IS Beveragenvarchar30CHAR(N' ')Yes/BEV1/LUT906/BEV1/LULDEGRP Allow NULL? 
156/DSD/VC_GROUPDSD Groupingnvarchar60CHAR(N' ')Yes/DSD/VC_GRP/DSD/VC_GROUP Allow NULL? 
157/VSO/R_TILT_INDMaterial may be Tilted (Vehicle Space Optimization)char10CHAR(N' ')Yes/VSO/M_TILT_IND Allow NULL? 
158/VSO/R_STACK_INDStacking not Allowed (VSO)char10CHAR(N' ')Yes/VSO/M_STACK_IND Allow NULL? 
159/VSO/R_BOT_INDBottom Layer (Vehicle Space Optimization)char10CHAR(N' ')Yes/VSO/M_BOTTOM_IND Allow NULL? 
160/VSO/R_TOP_INDTop Layer (VSO)char10CHAR(N' ')Yes/VSO/M_TOP_IND Allow NULL? 
161/VSO/R_STACK_NOStacking Factor (Vehicle Space Optimization)nvarchar30NUMC(N'000')Yes/VSO/M_STACK_NO Allow NULL? 
162/VSO/R_PAL_INDLoad without Packaging Material (VSO)char10CHAR(N' ')Yes/VSO/M_PALLET_IND Allow NULL? 
163/VSO/R_PAL_OVR_DPermissible Overhang (Depth) of Packaging Material (VSO)decimal133QUAN((0))Yes/VSO/R_PAL_OVR_D
164/VSO/R_PAL_OVR_WPermissible Overhang (Width) of Shipping Material (VSO)decimal133QUAN((0))Yes/VSO/R_PAL_OVR_W
165/VSO/R_PAL_B_HTMaximum Stacking Height of the Packaging Material (VSO)decimal133QUAN((0))Yes/VSO/R_PAL_BIN_HGT
166/VSO/R_PAL_MIN_HMinimum Stacking Height of the Packaging Material (VSO)decimal133QUAN((0))Yes/VSO/R_PAL_MIN_HT
167/VSO/R_TOL_B_HTTolerance to Exceed the Max. Stacking Height (VSO)decimal133QUAN((0))Yes/VSO/R_TOL_BIN_HT
168/VSO/R_NO_P_GVHNumber of Materials for each Closed PKM (VSO)nvarchar20NUMC(N'00')Yes/VSO/M_ANZ_PER_GVH Allow NULL? 
169/VSO/R_QUAN_UNITUnit of Measure Vehicle Space Optimizationnvarchar30UNIT(N' ')Yes/VSO/R_QUAN_UNIT Allow NULL? 
170/VSO/R_KZGVH_INDClosed Packaging Material Required (VSO)char10CHAR(N' ')Yes/VSO/M_KZGVH_IND Allow NULL? 
171MCONDMaterial Condition Managementchar10CHAR(N' ')YesDFPS_MCOND Allow NULL? 
172RETDELCReturn Codechar10CHAR(N' ')YesDFPS_RETDELC Allow NULL? 
173LOGLEV_RETOReturn to Logistics Levelchar10CHAR(N' ')YesDFPS_LOGLEV_RETO Allow NULL? 
174NSNIDNATO Item Identification Numbernvarchar90CHAR(N' ')YesDFPS_NSNID Allow NULL? 
175IMATNFFF classnvarchar180CHAR(N' ')Yes*IMATN Allow NULL? 
176PICNUMSupersession chain numbernvarchar180CHAR(N' ')YesPIC_PICNUM_SUS Allow NULL? 
177BSTATCreation Status - Seasonal Procurementnvarchar20CHAR(N' ')Yes*WRFBSTAT Allow NULL? 
178COLOR_ATINNInternal Charactieristic Number for Color Characteristicsnvarchar100NUMC(N'0000000000')Yes*WRF_COLOR_ATINN Allow NULL? 
179SIZE1_ATINNInternal Char. Number for Characteristics for Main Sizesnvarchar100NUMC(N'0000000000')Yes*WRF_SIZE1_ATINN Allow NULL? 
180SIZE2_ATINNInternal Char. Number for Characteristics for Second Sizesnvarchar100NUMC(N'0000000000')Yes*WRF_SIZE2_ATINN Allow NULL? 
181COLORCharacteristic Value for Colors of Variantsnvarchar180CHAR(N' ')YesWRF_COLOR Allow NULL? 
182SIZE1Characteristic Value for Main Sizes of Variantsnvarchar180CHAR(N' ')YesWRF_SIZE1 Allow NULL? 
183SIZE2Characteristic Value for Second Size for Variantsnvarchar180CHAR(N' ')YesWRF_SIZE2 Allow NULL? 
184FREE_CHARCharacteristic Value for Evaluation Purposesnvarchar180CHAR(N' ')YesWRF_FREE_CHAR Allow NULL? 
185CARE_CODECare Codes (such as Washing Code, Ironing Code, etc.)nvarchar160CHAR(N' ')YesWRF_CARE_CODE Allow NULL? 
186BRAND_IDBrandnvarchar40CHAR(N' ')YesWRF_BRANDSWRF_BRAND_ID Allow NULL? 
187FIBER_CODE1Fiber Code for Textiles (Component 1)nvarchar30CHAR(N' ')YesWRF_FIBER_CODESWRF_FIBER_CODE_1 Allow NULL? 
188FIBER_PART1Percentage Share of Fiber (Component 1)nvarchar30NUMC(N'000')YesWRF_FIBER_PART_1 Allow NULL? 
189FIBER_CODE2Fiber Code for Textiles (Component 2)nvarchar30CHAR(N' ')YesWRF_FIBER_CODESWRF_FIBER_CODE_2 Allow NULL? 
190FIBER_PART2Percentage Share of Fiber (Component 2)nvarchar30NUMC(N'000')YesWRF_FIBER_PART_2 Allow NULL? 
191FIBER_CODE3Fiber Code for Textiles (Component 3)nvarchar30CHAR(N' ')YesWRF_FIBER_CODESWRF_FIBER_CODE_3 Allow NULL? 
192FIBER_PART3Percentage Share of Fiber (Component 3)nvarchar30NUMC(N'000')YesWRF_FIBER_PART_3 Allow NULL? 
193FIBER_CODE4Fiber Code for Textiles (Component 4)nvarchar30CHAR(N' ')YesWRF_FIBER_CODESWRF_FIBER_CODE_4 Allow NULL? 
194FIBER_PART4Percentage Share of Fiber (Component 4)nvarchar30NUMC(N'000')YesWRF_FIBER_PART_4 Allow NULL? 
195FIBER_CODE5Fiber Code for Textiles (Component 5)nvarchar30CHAR(N' ')YesWRF_FIBER_CODESWRF_FIBER_CODE_5 Allow NULL? 
196FIBER_PART5Percentage Share of Fiber (Component 5)nvarchar30NUMC(N'000')YesWRF_FIBER_PART_5 Allow NULL? 
197FASHGRDFashion Gradenvarchar40CHAR(N' ')YesFASHGRD Allow NULL? 
198MAKTXMaterial Description (Short Text)nvarchar400CHAR(N' ')YesMAKTX Allow NULL? 
199WERKSPlantnvarchar40CHAR(N' ')Yes*WERKS_D Allow NULL? 
200PSTATMaintenance statusnvarchar150CHAR(N' ')YesPSTAT_D Allow NULL? 
201LVORMFlag Material for Deletion at Plant Levelchar10CHAR(N' ')YesLVOWK Allow NULL? 
202BWTTYValuation Categorychar10CHAR(N' ')YesT149CBWTTY_D Allow NULL? 
203XCHARBatch management indicator (internal)char10CHAR(N' ')YesXCHAR Allow NULL? 
204MMSTAPlant-Specific Material Statusnvarchar20CHAR(N' ')YesT141MMSTA Allow NULL? 
205MMSTDDate from which the plant-specific material status is validnvarchar80DATS(N'00000000')YesMMSTD Allow NULL? 
206MAABCABC Indicatorchar10CHAR(N' ')YesTMABCMAABC Allow NULL? 
207KZKRIIndicator: Critical partchar10CHAR(N' ')YesKZKRI Allow NULL? 
208EKGRPPurchasing Groupnvarchar30CHAR(N' ')YesT024EKGRP Allow NULL? 
209AUSMEUnit of issuenvarchar30UNIT(N' ')YesT006AUSME Allow NULL? 
210DISPRMaterial: MRP profilenvarchar40CHAR(N' ')YesMDIPDISPR Allow NULL? 
211DISMMMRP Typenvarchar20CHAR(N' ')YesT438ADISMM Allow NULL? 
212DISPOMRP Controller (Materials Planner)nvarchar30CHAR(N' ')YesT024DDISPO Allow NULL? 
213KZDIEIndicator: MRP controller is buyer (deactivated)char10CHAR(N' ')YesKZDIE Allow NULL? 
214PLIFZPlanned Delivery Time in Daysdecimal30DEC((0))YesPLIFZ
215WEBAZGoods Receipt Processing Time in Daysdecimal30DEC((0))YesWEBAZ
216PERKZPeriod Indicatorchar10CHAR(N' ')YesPERKZ Allow NULL? 
217AUSSSAssembly scrap in percentdecimal52DEC((0))YesAUSSS
218DISLSLot size (materials planning)nvarchar20CHAR(N' ')YesT439ADISLS Allow NULL? 
219BESKZProcurement Typechar10CHAR(N' ')YesBESKZ Allow NULL? 
220SOBSLSpecial procurement typenvarchar20CHAR(N' ')YesT460ASOBSL Allow NULL? 
221MINBEReorder Pointdecimal133QUAN((0))YesMINBE
222EISBESafety Stockdecimal133QUAN((0))YesEISBE
223BSTMIMinimum Lot Sizedecimal133QUAN((0))YesBSTMI
224BSTMAMaximum Lot Sizedecimal133QUAN((0))YesBSTMA
225BSTFEFixed lot sizedecimal133QUAN((0))YesBSTFE
226BSTRFRounding value for purchase order quantitydecimal133QUAN((0))YesBSTRF
227MABSTMaximum stock leveldecimal133QUAN((0))YesMABST
228LOSFXOrdering costsdecimal112CURR((0))YesLOSFX
229SBDKZDependent requirements ind. for individual and coll. reqmtschar10CHAR(N' ')YesSBDKZ Allow NULL? 
230LAGPRStorage costs indicatorchar10CHAR(N' ')YesT439LLAGPR Allow NULL? 
231ALTSLMethod for Selecting Alternative Bills of Materialchar10CHAR(N' ')YesALTSL Allow NULL? 
232KZAUSDiscontinuation indicatorchar10CHAR(N' ')YesKZAUS Allow NULL? 
233AUSDTEffective-Out Datenvarchar80DATS(N'00000000')YesAUSDT Allow NULL? 
234NFMATFollow-Up Materialnvarchar180CHAR(N' ')YesMARANFMAT Allow NULL? 
235KZBEDIndicator for Requirements Groupingchar10CHAR(N' ')YesKZBED Allow NULL? 
236MISKZMixed MRP indicatorchar10CHAR(N' ')YesMISKZ Allow NULL? 
237FHORIScheduling Margin Key for Floatsnvarchar30CHAR(N' ')YesT436AFHORI Allow NULL? 
238PFREIIndicator: automatic fixing of planned orderschar10CHAR(N' ')YesPFREI Allow NULL? 
239FFREIRelease indicator for production orderschar10CHAR(N' ')YesFFREI Allow NULL? 
240RGEKZIndicator: Backflushchar10CHAR(N' ')YesRGEKM Allow NULL? 
241FEVORProduction Supervisornvarchar30CHAR(N' ')YesT024FFEVOR Allow NULL? 
242BEARZProcessing timedecimal52DEC((0))YesBEARZ
243RUEZTSetup and teardown timedecimal52DEC((0))YesRUEZT
244TRANZInteroperation timedecimal52DEC((0))YesTRANZ
245BASMGBase quantitydecimal133QUAN((0))YesBASMG
246DZEITIn-house production timedecimal30DEC((0))YesDZEIT
247MAXLZMaximum Storage Perioddecimal50DEC((0))YesMAXLZ
248LZEIHUnit for maximum storage periodnvarchar30UNIT(N' ')YesT006LZEIH Allow NULL? 
249KZPROIndicator: withdrawal of stock from production binchar10CHAR(N' ')YesKZPRO Allow NULL? 
250GPMKZIndicator: Material Included in Rough-Cut Planningchar10CHAR(N' ')YesGPMKZ Allow NULL? 
251UEETOOverdelivery tolerance limitdecimal31DEC((0))YesUEETO
252UEETKIndicator: Unlimited Overdelivery Allowedchar10CHAR(N' ')YesUEETK Allow NULL? 
253UNETOUnderdelivery tolerance limitdecimal31DEC((0))YesUNETO
254WZEITTotal replenishment lead time (in workdays)decimal30DEC((0))YesWZEIT
255ATPKZReplacement partchar10CHAR(N' ')YesATPKZ Allow NULL? 
256VZUSLSurcharge factor for cost in percentdecimal52DEC((0))YesVZUSL
257HERBLState of manufacturenvarchar20CHAR(N' ')YesHERBL Allow NULL? 
258INSMKPost to Inspection Stockchar10CHAR(N' ')YesINSMK_MAT Allow NULL? 
259SPROZSample for quality inspection (in %) (deactivated)decimal31DEC((0))YesSPROZ
260QUAZTQuarantine period (deactivated)decimal30DEC((0))YesQUAZT
261SSQSSControl Key for Quality Management in Procurementnvarchar80CHAR(N' ')YesTQ08QSSPUR Allow NULL? 
262MPDAUMean inspection duration (deactivated)decimal50DEC((0))YesMPDAU
263KZPPVIndicator for inspection plan (deactivated)char10CHAR(N' ')YesKZPPV Allow NULL? 
264KZDKZDocumentation required indicatorchar10CHAR(N' ')YesKZDKZ Allow NULL? 
265WSTGHActive substance content (deactivated)decimal90DEC((0))YesWSTGH
266PRFRQInterval until next recurring inspectiondecimal50DEC((0))YesPRFRQ
267NKMPRDate according to check sampling inspection (deactivated)nvarchar80DATS(N'00000000')YesNKMPR Allow NULL? 
268UMLMCStock in Transfer (Plant to Plant)decimal133QUAN((0))YesUMLME
269LADGRLoading Groupnvarchar40CHAR(N' ')YesTLGRLADGR Allow NULL? 
270XCHPFBatch management requirement indicatorchar10CHAR(N' ')YesXCHPF Allow NULL? 
271USEQUQuota arrangement usagechar10CHAR(N' ')YesTMQ2USEQU Allow NULL? 
272LGRADService leveldecimal31DEC((0))YesLGRAD
273AUFTLSplitting Indicatorchar10CHAR(N' ')YesT439PAUFTL Allow NULL? 
274PLVARPlan Versionnvarchar20CHAR(N' ')YesT778PPLVAR Allow NULL? 
275OTYPEObject Typenvarchar20CHAR(N' ')YesT778OOTYPE Allow NULL? 
276OBJIDObject IDnvarchar80NUMC(N'00000000')YesOBJEKTID Allow NULL? 
277MTVFPChecking Group for Availability Checknvarchar20CHAR(N' ')YesTMVFMTVFP Allow NULL? 
278PERIVFiscal Year Variantnvarchar20CHAR(N' ')YesT009PERIV Allow NULL? 
279KZKFKIndicator: take correction factors into accountchar10CHAR(N' ')YesKZKFK Allow NULL? 
280VRVEZShipping setup timedecimal52DEC((0))YesVRVEZ
281VBAMGBase quantity for capacity planning in shippingdecimal133QUAN((0))YesVBAMG
282VBEAZShipping processing timedecimal52DEC((0))YesVBEAZ
283LIZYKDeactivatednvarchar40CHAR(N' ')YesDUMMYLIZYK Allow NULL? 
284BWSCLSource of Supplychar10CHAR(N' ')YesTMBW1BWSCL Allow NULL? 
285KAUTBIndicator: "automatic purchase order allowed"char10CHAR(N' ')YesKAUTB Allow NULL? 
286KORDBIndicator: Source list requirementchar10CHAR(N' ')YesKORDB Allow NULL? 
287STAWNCommodity Code/Import Code Number for Foreign Tradenvarchar170CHAR(N' ')YesT604STAWN Allow NULL? 
288HERKLCountry of origin of the materialnvarchar30CHAR(N' ')YesT005HERKL Allow NULL? 
289HERKRRegion of origin of material (non-preferential origin)nvarchar30CHAR(N' ')YesT005SHERKR Allow NULL? 
290EXPMEUnit of measure for commodity code (foreign trade)nvarchar30UNIT(N' ')YesT006EXPME Allow NULL? 
291MTVERExport/import material groupnvarchar40CHAR(N' ')YesTVFMMTVER Allow NULL? 
292PRCTRProfit Centernvarchar100CHAR(N' ')Yes*PRCTR Allow NULL? 
293TRAMEStock in Transitdecimal133QUAN((0))YesTRAME
294MRPPPPPC planning calendarnvarchar30CHAR(N' ')YesT439GMRPPP Allow NULL? 
295SAUFTInd.: Repetitive mfg allowedchar10CHAR(N' ')YesSA_SAUFT Allow NULL? 
296FXHORPlanning time fencenvarchar30NUMC(N'000')YesFXHOR Allow NULL? 
297VRMODConsumption modechar10CHAR(N' ')YesVRMOD Allow NULL? 
298VINT1Consumption period: backwardnvarchar30NUMC(N'000')YesVINT1 Allow NULL? 
299VINT2Consumption period: forwardnvarchar30NUMC(N'000')YesVINT2 Allow NULL? 
300VERKZVersion Indicatorchar10CHAR(N' ')YesCK_VERK1 Allow NULL? 
301STLALAlternative BOMnvarchar20CHAR(N' ')YesSTALT Allow NULL? 
302STLANBOM Usagechar10CHAR(N' ')YesT416STLAN Allow NULL? 
303PLNNRKey for Task List Groupnvarchar80CHAR(N' ')YesPLNNR Allow NULL? 
304APLALGroup Counternvarchar20CHAR(N' ')YesPLNAL Allow NULL? 
305LOSGRLot Size for Product Costingdecimal133QUAN((0))YesCK_LOSGR
306SOBSKSpecial Procurement Type for Costingnvarchar20CHAR(N' ')YesT460ACK_SOBSL Allow NULL? 
307FRTMEProduction unitnvarchar30UNIT(N' ')YesT006FRTME Allow NULL? 
308LGPROIssue Storage Locationnvarchar40CHAR(N' ')YesT001LLGPRO Allow NULL? 
309DISGRMRP Groupnvarchar40CHAR(N' ')YesT438MDISGR Allow NULL? 
310KAUSFComponent scrap in percentdecimal52DEC((0))YesKAUSF
311QZGTPCertificate Typenvarchar40CHAR(N' ')YesTQ05QZGTYP Allow NULL? 
312QMATVInspection Setup Exists for Material/Plantchar10CHAR(N' ')YesQMATV Allow NULL? 
313TAKZTTakt timedecimal30DEC((0))YesTAKZT
314RWPRORange of coverage profilenvarchar30CHAR(N' ')YesT438RRWPRO Allow NULL? 
315COPAMLocal field name for CO/PA link to SOPnvarchar100CHAR(N' ')YesCOPAM Allow NULL? 
316ABCINPhysical inventory indicator for cycle countingchar10CHAR(N' ')YesT159CABCIN Allow NULL? 
317AWSLSVariance Keynvarchar60CHAR(N' ')YesTKV01AWSLS Allow NULL? 
318SERNPSerial Number Profilenvarchar40CHAR(N' ')YesT377PSERAIL Allow NULL? 
319CUOBJInternal object numbernvarchar180NUMC(N'000000000000000000')YesCUOBM Allow NULL? 
320STDPDConfigurable materialnvarchar180CHAR(N' ')YesMARASTDPD Allow NULL? 
321SFEPRRepetitive manufacturing profilenvarchar40CHAR(N' ')YesT437SSFEPR Allow NULL? 
322XMCNGNegative stocks allowed in plantchar10CHAR(N' ')YesXMCNG Allow NULL? 
323QSSYSRequired QM System for Vendornvarchar40CHAR(N' ')YesTQ02QSSYS_SOLL Allow NULL? 
324LFRHYPlanning cyclenvarchar30CHAR(N' ')YesT439GLFRHY Allow NULL? 
325RDPRFRounding Profilenvarchar40CHAR(N' ')YesRDPRRDPRF Allow NULL? 
326VRBMTReference material for consumptionnvarchar180CHAR(N' ')YesMARAVRBMT Allow NULL? 
327VRBWKReference plant for consumptionnvarchar40CHAR(N' ')YesT001WVRBWK Allow NULL? 
328VRBDTTo date of the material to be copied for consumptionnvarchar80DATS(N'00000000')YesVRBDT Allow NULL? 
329VRBFKMultiplier for reference material for consumptiondecimal42DEC((0))YesVRBFK
330AUTRUReset Forecast Model Automaticallychar10CHAR(N' ')YesAUTRU Allow NULL? 
331PREFEPreference indicator in export/importchar10CHAR(N' ')YesPREFE Allow NULL? 
332PRENCExemption certificate: Indicator for legal controlchar10CHAR(N' ')YesPRENC Allow NULL? 
333PRENOExemption certificate number for legal controlnvarchar80CHAR(N' ')YesPRENN Allow NULL? 
334PRENDExemption certificate: Issue date of exemption certificatenvarchar80DATS(N'00000000')YesPREND Allow NULL? 
335PRENEIndicator: Vendor declaration existschar10CHAR(N' ')YesPRENE Allow NULL? 
336PRENGValidity date of vendor declarationnvarchar80DATS(N'00000000')YesPRENG Allow NULL? 
337ITARKIndicator: Military goodschar10CHAR(N' ')YesITARK Allow NULL? 
338SERVGIS-R service levelchar10CHAR(N' ')YesTWSGW_SERVGRD Allow NULL? 
339KZKUPIndicator: Material can be co-productchar10CHAR(N' ')YesKZKUPMAT Allow NULL? 
340STRGRPlanning strategy groupnvarchar20CHAR(N' ')YesT461PSTRGR Allow NULL? 
341CUOBVInternal object number of configurable material for planningnvarchar180NUMC(N'000000000000000000')YesCUOBV Allow NULL? 
342LGFSBDefault storage location for external procurementnvarchar40CHAR(N' ')YesT001LLGFSB Allow NULL? 
343SCHGTIndicator: Bulk Materialchar10CHAR(N' ')YesSCHGT Allow NULL? 
344CCFIXCC indicator is fixedchar10CHAR(N' ')YesCCFIX Allow NULL? 
345EPRIOStock determination groupnvarchar40CHAR(N' ')YesT434GBF_GROUP Allow NULL? 
346QMATAMaterial Authorization Group for Activities in QMnvarchar60CHAR(N' ')YesTQ01BQMATAUTH Allow NULL? 
347RESVPPeriod of adjustment for planned independent requirementsdecimal30DEC((0))YesRESVP
348PLNTYTask List Typechar10CHAR(N' ')YesTCA01PLNTY Allow NULL? 
349UOMGRUnit of Mearsure Group (Oil, Natural Gas,...)nvarchar30CHAR(N' ')YesOIB06OIB_UOMGR Allow NULL? 
350UMRSLConversion Group (Oil, Natural Gas,..)nvarchar40CHAR(N' ')YesOIB01OIB_UMRSL Allow NULL? 
351ABFACAir Bouyancy Factordecimal21DEC((0))Yes*OIL_ABFAC
352SFCPFProduction Scheduling Profilenvarchar60CHAR(N' ')YesTCO43CO_PRODPRF Allow NULL? 
353SHFLGSafety time indicator (with or without safety time)char10CHAR(N' ')YesSHFLG Allow NULL? 
354SHZETSafety time (in workdays)nvarchar20NUMC(N'00')YesSHZET Allow NULL? 
355MDACHAction control: planned order processingnvarchar20CHAR(N' ')YesT46ACMDACH Allow NULL? 
356KZECHDetermination of batch entry in the production/process orderchar10CHAR(N' ')YesKZECH Allow NULL? 
357MEGRUUnit of Measure Groupnvarchar40CHAR(N' ')YesTWMEGMEGRU Allow NULL? 
358MFRGRMaterial freight groupnvarchar80CHAR(N' ')YesTMFGMFRGR Allow NULL? 
359VKUMCStock transfer sales value (plant to plant) for VO materialdecimal132CURR((0))YesVKUMC
360VKTRWTransit value at sales price for value-only materialdecimal132CURR((0))YesVKTRW
361KZAGLIndicator: smooth promotion consumptionchar10CHAR(N' ')YesKZAGL Allow NULL? 
362FVIDKProduction Version To Be Costednvarchar40CHAR(N' ')Yes*CK_VERID Allow NULL? 
363FXPRUFixed-Price Co-Productchar10CHAR(N' ')YesCK_FIXPRKU Allow NULL? 
364LOGGRLogistics handling group for workload calculationnvarchar40CHAR(N' ')YesTLOGLOGGR Allow NULL? 
365FPRFMDistribution profile of material in plantnvarchar30CHAR(N' ')Yes*FPRFM Allow NULL? 
366GLGMGTied Empties Stockdecimal133QUAN((0))YesGLGMG
367VKGLGSales value of tied empties stockdecimal132CURR((0))YesVKGLG
368INDUSMaterial CFOP categorynvarchar20CHAR(N' ')YesJ_1BINDUS3 Allow NULL? 
369MOWNRCAP: Number of CAP products listnvarchar120CHAR(N' ')YesT618MMOWNR Allow NULL? 
370MOGRUCommon Agricultural Policy: CAP products group-Foreign Tradenvarchar60CHAR(N' ')YesT618GMOGRU Allow NULL? 
371CASNRCAS number for pharmaceutical products in foreign tradenvarchar150CHAR(N' ')YesT610CCASNR Allow NULL? 
372GPNUMProduction statistics: PRODCOM number for foreign tradenvarchar90CHAR(N' ')YesT609GGPNUM Allow NULL? 
373STEUCControl code for consumption taxes in foreign tradenvarchar160CHAR(N' ')YesT604FSTEUC Allow NULL? 
374FABKZIndicator: Item Relevant to JIT Delivery Scheduleschar10CHAR(N' ')YesFABKZ Allow NULL? 
375MATGRGroup of Materials for Transition Matrixnvarchar200CHAR(N' ')YesMATNRGROUP Allow NULL? 
376VSPVBProposed Supply Area in Material Master Recordnvarchar100CHAR(N' ')YesPVBEVSPVB Allow NULL? 
377DPLFSFair share rulenvarchar20CHAR(N' ')YesDPLFS Allow NULL? 
378DPLPUIndicator: push distributionchar10CHAR(N' ')YesDPLPU Allow NULL? 
379DPLHODeployment horizon in daysdecimal30DEC((0))YesDPLHO
380MINLSMinimum lot size for Supply Demand Matchdecimal133QUAN((0))YesCSCP_MINLOTSIZE
381MAXLSMaximum lot size for Supply Demand Matchdecimal133QUAN((0))YesCSCP_MAXLOTSIZE
382FIXLSFixed lot size for Supply Demand Matchdecimal133QUAN((0))YesCSCP_FIXLOTSIZE
383LTINCLot size increment for Supply Demand Matchdecimal133QUAN((0))YesCSCP_LOTINCREMENT
384COMPLThis field is no longer usednvarchar20NUMC(N'00')YesTCSCP_COMP_LVLCSCP_DUMMY Allow NULL? 
385CONVTConversion types for production figuresnvarchar20CHAR(N' ')YesTCSCP_CONV_TYPECSCP_CONV_TYPE Allow NULL? 
386SHPROPeriod Profile for Safety Timenvarchar30CHAR(N' ')YesT438VSHPRO Allow NULL? 
387AHDISMRP relevancy for dependent requirementschar10CHAR(N' ')YesAHDIS Allow NULL? 
388DIBERIndicator: MRP area existschar10CHAR(N' ')YesDIBER Allow NULL? 
389KZPSPIndicator for cross-project materialchar10CHAR(N' ')YesKZPSP Allow NULL? 
390OCMPFOverall profile for order change managementnvarchar60CHAR(N' ')YesTCO48OCM_GPROFILE Allow NULL? 
391APOKZIndicator: Is material relevant for APOchar10CHAR(N' ')YesAPOKZ Allow NULL? 
392MCRUEMARDH rec. already exists for per. before last of MARD per.char10CHAR(N' ')YesMCRUE Allow NULL? 
393LFMONCurrent period (posting period)nvarchar20NUMC(N'00')YesLFMON Allow NULL? 
394LFGJAFiscal Year of Current Periodnvarchar40NUMC(N'0000')YesLFGJA Allow NULL? 
395EISLOMinimum Safety Stockdecimal133QUAN((0))YesEISLO
396NCOSTDo Not Costchar10CHAR(N' ')YesCK_NO_COSTING Allow NULL? 
397ROTATION_DATEStrategy for Putaway and Stock Removalchar10CHAR(N' ')YesROTATION_DATE Allow NULL? 
398UCHKZIndicator for Original Batch Managementchar10CHAR(N' ')YesUCHKZ Allow NULL? 
399UCMATReference Material for Original Batchesnvarchar180CHAR(N' ')YesMARAVBOB_OB_RFMAT Allow NULL? 
400BWESBValuated Goods Receipt Blocked Stockdecimal133QUAN((0))YesBWESB
401SGT_COVSSegmentation Strategynvarchar80CHAR(N' ')YesSGT_COVS_TSGT_COVS Allow NULL? 
402SGT_STATCSegmentation Statuschar10CHAR(N' ')YesSGT_STATC Allow NULL? 
403SGT_SCOPESegmentation Strategy Scopechar10CHAR(N' ')YesSGT_SCOPE Allow NULL? 
404SGT_MRPSISort Stock based on Segmentchar10CHAR(N' ')YesSGT_SRT_STK Allow NULL? 
405SGT_PRCMConsumption Prioritychar10CHAR(N' ')YesSGT_PRCM Allow NULL? 
406SGT_CHINTDiscrete Batch Numberchar10CHAR(N' ')YesSGT_CHINT Allow NULL? 
407SGT_STK_PRTStock Protection Indicatorchar10CHAR(N' ')YesSGT_STK_PRT Allow NULL? 
408SGT_DEFSCDefault Stock Segment valuenvarchar160CHAR(N' ')YesSGT_DEFSC Allow NULL? 
409FSH_MG_ARUN_REQOrder Allocation Runchar10CHAR(N' ')YesFSH_MG_ARUN_REQ Allow NULL? 
410FSH_SEAIMIndicator: Season Active in Inventory Managementchar10CHAR(N' ')YesFSH_SEAIM Allow NULL? 
411/MRSS/PROF_GUIDGUID in 'CHAR' Format in Uppercasenvarchar320CHAR(N' ')YesGUID_32 Allow NULL? 
412/MRSS/PROF_KEYProfile Keynvarchar100CHAR(N' ')Yes/MRSS/T_RSG_REQUID Allow NULL? 
413/MRSS/DATACHANGEData was changed in the controls on the user screenchar10CHAR(N' ')Yes/MRSS/T_USCREENCTL_DATACHANGED Allow NULL? 
414/SAPMP/TOLPRPLPercentage Tolerance Plusdecimal31DEC((0))Yes/SAPMP/TOLPRPL
415/SAPMP/TOLPRMIPercentage Tolerance Minusdecimal31DEC((0))Yes/SAPMP/TOLPRMI
416/VSO/R_PKGRPPacking Group of the Material (VSO)nvarchar180CHAR(N' ')Yes/VSO/M_PKG/VSO/M_PKGRP Allow NULL? 
417/VSO/R_LANE_NUMLine within the Automatic Picking Zone (VSO)nvarchar30CHAR(N' ')Yes/VSO/M_LANE_NUM Allow NULL? 
418/VSO/R_PAL_VENDMaterial No. of the Packaging Material of the Vendor (VSO)nvarchar180CHAR(N' ')Yes*/VSO/R_MATNR_PAL_VEND Allow NULL? 
419/VSO/R_FORK_DIRPick Packaging Materials only Lengthwise (VSO)char10CHAR(N' ')Yes/VSO/M_FORK_DIR Allow NULL? 
420IUID_RELEVANTIUID-Relevantchar10CHAR(N' ')YesIUID_RELEVANT Allow NULL? 
421IUID_TYPEStructure Type of UIInvarchar100CHAR(N' ')YesTIUID_TYPEIUID_TYPE Allow NULL? 
422UID_IEAExternal Allocation of UIIchar10CHAR(N' ')YesUID_IEA Allow NULL? 
423CONS_PROCGConsignment Controlchar10CHAR(N' ')YesWRFT_CONS_PROCGWRF_CONS_PROCG Allow NULL? 
424GI_PR_TIMEGoods Issue Processing Time in Daysdecimal30DEC((0))YesWRF_PSCD_WABAZ
425MULTIPLE_EKGRPPurchasing Across Purchasing Groupchar10CHAR(N' ')YesWRF_POHF_OTHER_EKGRP_ALLOW Allow NULL? 
426REF_SCHEMAReference Determination Schemanvarchar20CHAR(N' ')YesWRF_REF_RFSWRF_REF_SCHEMA Allow NULL? 
427MIN_TROCMinimum Target Range of Coveragenvarchar30NUMC(N'000')YesWRF_FRE_TROC_MIN Allow NULL? 
428MAX_TROCMaximum Target Range of Coveragenvarchar30NUMC(N'000')YesWRF_FRE_TROC_MAX Allow NULL? 
429TARGET_STOCKTarget Stockdecimal133QUAN((0))YesWRF_FRE_TARGET_STOCK
NamePrimaryUniqueTypeColumns
/SMERP/STG_MM00100NoNoNONCLUSTEREDDSF_RECORD_ID, MANDT
/SMERP/STG_MM001A0NoNoNONCLUSTEREDDSF_DSTORE_ID, MANDT
/SMERP/STG_MM001~0YesYesCLUSTEREDDSF_GUID, MANDT