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_MM0032173Data staging - Material UoM 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, MEINH, 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, LVORM, UMREZ, UMREN, MESUB, ATINN, MESRT, XFHDW, XBEWW, KZWSO, MSEHI, BFLME_MARM, NEST_FTR, MAX_STACK, CAPAUSE, TY2TQ, FLAG_BASE_UOM, CONV_FACTOR, BASE_UOM FROM /SMERP/STG_MM003
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? 
9MEINHUnit of Measure for Displaynvarchar30UNIT(N' ')Yes*MEINH Allow NULL? 
10VPSTAMaintenance status of complete materialnvarchar150CHAR(N' ')YesVPSTA Allow NULL? 
11MTARTMaterial Typenvarchar40CHAR(N' ')YesT134MTART Allow NULL? 
12MBRSHIndustry sectorchar10CHAR(N' ')YesT137MBRSH Allow NULL? 
13MATKLMaterial Groupnvarchar90CHAR(N' ')YesT023MATKL Allow NULL? 
14BISMTOld material numbernvarchar180CHAR(N' ')YesBISMT Allow NULL? 
15MEINSBase Unit of Measurenvarchar30UNIT(N' ')YesT006MEINS Allow NULL? 
16BSTMEPurchase Order Unit of Measurenvarchar30UNIT(N' ')YesT006BSTME Allow NULL? 
17ZEINRDocument number (without document management system)nvarchar220CHAR(N' ')YesDZEINR Allow NULL? 
18ZEIARDocument type (without Document Management system)nvarchar30CHAR(N' ')YesDZEIAR Allow NULL? 
19ZEIVRDocument version (without Document Management system)nvarchar20CHAR(N' ')YesDZEIVR Allow NULL? 
20ZEIFOPage format of document (without Document Management system)nvarchar40CHAR(N' ')YesDZEIFO Allow NULL? 
21AESZNDocument change number (without document management system)nvarchar60CHAR(N' ')YesAESZN Allow NULL? 
22BLATTPage number of document (without Document Management system)nvarchar30CHAR(N' ')YesBLATT Allow NULL? 
23BLANZNumber of sheets (without Document Management system)nvarchar30NUMC(N'000')YesBLANZ Allow NULL? 
24FERTHProduction/inspection memonvarchar180CHAR(N' ')YesFERTH Allow NULL? 
25FORMTPage Format of Production Memonvarchar40CHAR(N' ')YesFORMT Allow NULL? 
26GROESSize/dimensionsnvarchar320CHAR(N' ')YesGROES Allow NULL? 
27WRKSTBasic Materialnvarchar480CHAR(N' ')YesTWSPRWRKST Allow NULL? 
28NORMTIndustry Standard Description (such as ANSI or ISO)nvarchar180CHAR(N' ')YesNORMT Allow NULL? 
29LABORLaboratory/design officenvarchar30CHAR(N' ')YesT024LLABOR Allow NULL? 
30EKWSLPurchasing Value Keynvarchar40CHAR(N' ')YesT405EKWSL Allow NULL? 
31BRGEWGross Weightdecimal133QUAN((0))YesBRGEW
32NTGEWNet Weightdecimal133QUAN((0))YesNTGEW
33GEWEIWeight Unitnvarchar30UNIT(N' ')YesT006GEWEI Allow NULL? 
34VOLUMVolumedecimal133QUAN((0))YesVOLUM
35VOLEHVolume unitnvarchar30UNIT(N' ')YesT006VOLEH Allow NULL? 
36BEHVOContainer requirementsnvarchar20CHAR(N' ')YesT144BEHVO Allow NULL? 
37RAUBEStorage conditionsnvarchar20CHAR(N' ')YesT142RAUBE Allow NULL? 
38TEMPBTemperature conditions indicatornvarchar20CHAR(N' ')YesT143TEMPB Allow NULL? 
39DISSTLow-Level Codenvarchar30CHAR(N' ')YesDISST Allow NULL? 
40TRAGRTransportation Groupnvarchar40CHAR(N' ')YesTTGRTRAGR Allow NULL? 
41STOFFHazardous material numbernvarchar180CHAR(N' ')YesMGEFSTOFF Allow NULL? 
42SPARTDivisionnvarchar20CHAR(N' ')YesTSPASPART Allow NULL? 
43KUNNRCompetitornvarchar100CHAR(N' ')YesV_KNA1WETTWETTB Allow NULL? 
44EANNREuropean Article Number (EAN) - obsolete!!!!!nvarchar130CHAR(N' ')YesEANNR Allow NULL? 
45WESCHQuantity: Number of GR/GI slips to be printeddecimal133QUAN((0))YesWESCH
46BWVORProcurement rulechar10CHAR(N' ')YesT6WP1BWVOR Allow NULL? 
47SAISOSeason Categorynvarchar40CHAR(N' ')YesT6WSPSAISO Allow NULL? 
48ETIARLabel typenvarchar20CHAR(N' ')YesT6WP3ETIAR Allow NULL? 
49ETIFOLabel formnvarchar20CHAR(N' ')YesT6WP4ETIFO Allow NULL? 
50ENTARDeactivatedchar10CHAR(N' ')YesDUMMYENTAR Allow NULL? 
51EAN11International Article Number (EAN/UPC)nvarchar180CHAR(N' ')YesEAN11 Allow NULL? 
52NUMTPCategory of International Article Number (EAN)nvarchar20CHAR(N' ')YesTNTPNUMTP Allow NULL? 
53LAENGLengthdecimal133QUAN((0))YesLAENG
54BREITWidthdecimal133QUAN((0))YesBREIT
55HOEHEHeightdecimal133QUAN((0))YesHOEHE
56MEABMUnit of Dimension for Length/Width/Heightnvarchar30UNIT(N' ')YesT006MEABM Allow NULL? 
57PRDHAProduct hierarchynvarchar180CHAR(N' ')YesT179PRODH_D Allow NULL? 
58AEKLKStock Transfer Net Change Costingchar10CHAR(N' ')YesCK_AEKLK Allow NULL? 
59CADKZCAD Indicatorchar10CHAR(N' ')YesCADKZ Allow NULL? 
60QMPURQM in Procurement is Activechar10CHAR(N' ')YesQMPUR Allow NULL? 
61ERGEWAllowed packaging weightdecimal133QUAN((0))YesERGEW
62ERGEIUnit of weight (allowed packaging weight)nvarchar30UNIT(N' ')YesT006ERGEI Allow NULL? 
63ERVOLAllowed packaging volumedecimal133QUAN((0))YesERVOL
64ERVOEVolume unit (allowed packaging volume)nvarchar30UNIT(N' ')YesT006ERVOE Allow NULL? 
65GEWTOExcess Weight Tolerance for Handling unitdecimal31DEC((0))YesGEWTO
66VOLTOExcess Volume Tolerance of the Handling Unitdecimal31DEC((0))YesVOLTO
67VABMEVariable Purchase Order Unit Activechar10CHAR(N' ')YesVABME Allow NULL? 
68KZREVRevision Level Has Been Assigned to the Materialchar10CHAR(N' ')YesKZREV Allow NULL? 
69KZKFGConfigurable Materialchar10CHAR(N' ')YesKZKFG Allow NULL? 
70VHARTPackaging Material Typenvarchar40CHAR(N' ')YesTVTYVHIART Allow NULL? 
71FUELGMaximum level (by volume)decimal30DEC((0))YesFUELG
72STFAKStacking factorsmallint50INT2((0))YesSTFAK
73MAGRVMaterial Group: Packaging Materialsnvarchar40CHAR(N' ')YesTVEGRMAGRV Allow NULL? 
74BEGRUAuthorization Groupnvarchar40CHAR(N' ')YesBEGRU Allow NULL? 
75DATABValid-From Datenvarchar80DATS(N'00000000')YesDATAB Allow NULL? 
76LIQDTDeletion datenvarchar80DATS(N'00000000')YesLIQDT Allow NULL? 
77SAISJSeason Yearnvarchar40CHAR(N' ')YesSAISJ Allow NULL? 
78PLGTPPrice Band Categorynvarchar20CHAR(N' ')YesTWPTPLGTP Allow NULL? 
79MLGUTEmpties Bill of Materialchar10CHAR(N' ')YesW_MITLEERG Allow NULL? 
80EXTWGExternal Material Groupnvarchar180CHAR(N' ')YesTWEWEXTWG Allow NULL? 
81SATNRCross-Plant Configurable Materialnvarchar180CHAR(N' ')YesMARASATNR Allow NULL? 
82ATTYPMaterial Categorynvarchar20CHAR(N' ')YesATTYP Allow NULL? 
83KZNFMIndicator: The material has a follow-up materialchar10CHAR(N' ')YesKZNFM Allow NULL? 
84PMATAPricing Reference Materialnvarchar180CHAR(N' ')YesMARAPMATN Allow NULL? 
85MSTAECross-Plant Material Statusnvarchar20CHAR(N' ')YesT141MSTAE Allow NULL? 
86MSTAVCross-distribution-chain material statusnvarchar20CHAR(N' ')YesTVMSMSTAV Allow NULL? 
87MSTDEDate from which the cross-plant material status is validnvarchar80DATS(N'00000000')YesMSTDE Allow NULL? 
88MSTDVDate from which the X-distr.-chain material status is validnvarchar80DATS(N'00000000')YesMSTDV Allow NULL? 
89TAKLVTax classification of the materialchar10CHAR(N' ')YesTSKMTAKLV Allow NULL? 
90RBNRMCatalog Profilenvarchar90CHAR(N' ')YesT352BRBNR Allow NULL? 
91MHDRZMinimum Remaining Shelf Lifedecimal40DEC((0))YesMHDRZ
92MHDHBTotal shelf lifedecimal40DEC((0))YesMHDHB
93MHDLPStorage percentagedecimal30DEC((0))YesMHDLP
94INHMEContent unitnvarchar30UNIT(N' ')YesT006INHME Allow NULL? 
95INHALNet contentsdecimal133QUAN((0))YesINHAL
96VPREHComparison price unitdecimal50DEC((0))YesVPREH
97ETIAGIS-R Labeling: material grouping (deactivated in 4.0)nvarchar180CHAR(N' ')Yes*ETIAG Allow NULL? 
98INHBRGross contentsdecimal133QUAN((0))YesINHBR
99CMETHQuantity Conversion Methodchar10CHAR(N' ')YesOIB_CMETH Allow NULL? 
100CUOBFInternal object numbernvarchar180NUMC(N'000000000000000000')YesCUOBM Allow NULL? 
101KZUMWEnvironmentally Relevantchar10CHAR(N' ')YesKZUMW Allow NULL? 
102KOSCHProduct allocation determination procedurenvarchar180CHAR(N' ')YesT190SKOSCH Allow NULL? 
103SPROFPricing profile for variantschar10CHAR(N' ')YesSPROF Allow NULL? 
104NRFHGMaterial qualifies for discount in kindchar10CHAR(N' ')YesNRFHG Allow NULL? 
105MFRPNManufacturer Part Numbernvarchar400CHAR(N' ')YesMFRPN Allow NULL? 
106MFRNRNumber of a Manufacturernvarchar100CHAR(N' ')YesLFA1MFRNR Allow NULL? 
107BMATNNumber of firm's own (internal) inventory-managed materialnvarchar180CHAR(N' ')YesMARAMPMAT Allow NULL? 
108MPROFManufacturer Part Profilenvarchar40CHAR(N' ')YesTMPPFMPROF Allow NULL? 
109KZWSMUnits of measure usagechar10CHAR(N' ')YesKZWSO Allow NULL? 
110SAITYRollout in a Seasonnvarchar20CHAR(N' ')YesT6WSASAITY Allow NULL? 
111PROFLDangerous Goods Indicator Profilenvarchar30CHAR(N' ')YesTDG41ADGE_PROFL Allow NULL? 
112IHIVIIndicator: Highly Viscouschar10CHAR(N' ')YesADGE_IHIVI Allow NULL? 
113ILOOSIndicator: In Bulk/Liquidchar10CHAR(N' ')YesADGE_ILOOS Allow NULL? 
114SERLVLevel of Explicitness for Serial Numberchar10CHAR(N' ')YesSERLV Allow NULL? 
115KZGVHPackaging Material is Closed Packagingchar10CHAR(N' ')YesKZGVH Allow NULL? 
116XGCHPIndicator: Approved batch record requiredchar10CHAR(N' ')YesXGCHP Allow NULL? 
117KZEFFAssign effectivity parameter values/ override change numberschar10CHAR(N' ')YesCC_MTEFF Allow NULL? 
118IPRKZPeriod Indicator for Shelf Life Expiration Datechar10CHAR(N' ')YesDATTP Allow NULL? 
119RDMHDRounding rule for calculation of SLEDchar10CHAR(N' ')YesRDMHD Allow NULL? 
120PRZUSIndicator: Product composition printed on packagingchar10CHAR(N' ')YesPRZUS Allow NULL? 
121MTPOS_MARAGeneral item category groupnvarchar40CHAR(N' ')YesTPTMMTPOS_MARA Allow NULL? 
122BFLMEGeneric Material with Logistical Variantschar10CHAR(N' ')YesBFLME Allow NULL? 
123MATFIMaterial Is Lockedchar10CHAR(N' ')YesMATFI Allow NULL? 
124CMRELRelevant for Configuration Managementchar10CHAR(N' ')YesDE_CM_RELEVANCE_FLAG Allow NULL? 
125BBTYPAssortment List Typechar10CHAR(N' ')Yes*BBTYP Allow NULL? 
126SLED_BBDExpiration Datechar10CHAR(N' ')YesSLED_BBD Allow NULL? 
127GTIN_VARIANTGlobal Trade Item Number Variantnvarchar20CHAR(N' ')YesGTIN_VARIANT Allow NULL? 
128GENNRMaterial Number of the Generic Material in Prepack Materialsnvarchar180CHAR(N' ')YesMARAWSTR_SATNR_PP Allow NULL? 
129RMATPReference material for materials packed in same waynvarchar180CHAR(N' ')YesMARAPL_RMATP Allow NULL? 
130GDS_RELEVANTIndicator: Global Data Synchronization-Relevantchar10CHAR(N' ')YesGDS_RELEVANT Allow NULL? 
131WEORAAcceptance At Originchar10CHAR(N' ')YesWEORA Allow NULL? 
132HUTYP_DFLTStandard HU Typenvarchar40CHAR(N' ')YesTHUTYPCIFHUTYPDF Allow NULL? 
133PILFERABLEPilferablechar10CHAR(N' ')YesCIFPILFRBL Allow NULL? 
134WHSTCWarehouse Storage Conditionnvarchar20CHAR(N' ')YesTWHSTCCIFWHSTC Allow NULL? 
135WHMATGRWarehouse Material Groupnvarchar40CHAR(N' ')YesTWHMATGRCIFWHMATGR Allow NULL? 
136HNDLCODEHandling Indicatornvarchar40CHAR(N' ')YesTHNDLCDCIFHDLCODE Allow NULL? 
137HAZMATRelevant for Hazardous Substanceschar10CHAR(N' ')YesCIFHAZMAT Allow NULL? 
138HUTYPHandling Unit Typenvarchar40CHAR(N' ')YesTHUTYPCIFHUTYP Allow NULL? 
139TARE_VARVariable Tare Weightchar10CHAR(N' ')YesCIFTAREVAR Allow NULL? 
140MAXCMaximum Allowed Capacity of Packaging Materialdecimal153DEC((0))YesCIFMAXC
141MAXC_TOLOvercapacity Tolerance of the Handling Unitdecimal31DEC((0))YesCIFMAXCTOL
142MAXLMaximum Packing Length of Packaging Materialdecimal153QUAN((0))YesCIFMAXL
143MAXBMaximum Packing Width of Packaging Materialdecimal153QUAN((0))YesCIFMAXB
144MAXHMaximum Packing Height of Packaging Materialdecimal153QUAN((0))YesCIFMAXH
145MAXDIM_UOMUnit of Measure for Maximum Packing Length/Width/Heightnvarchar30UNIT(N' ')YesT006CIFMAXDUOM Allow NULL? 
146QQTIMEQuarantine Perioddecimal30QUAN((0))YesCIFQQTIME
147QQTIMEUOMTime Unit for Quarantine Periodnvarchar30UNIT(N' ')YesT006CIFQQTIMEUOM Allow NULL? 
148QGRPQuality Inspection Groupnvarchar40CHAR(N' ')YesTQGRPCIFQGRP Allow NULL? 
149SERIALSerial Number Profilenvarchar40CHAR(N' ')YesTSERIALCIFSERIAL Allow NULL? 
150PS_SMARTFORMForm Namenvarchar300CHAR(N' ')YesSTXFADMCIFPSSFNAME Allow NULL? 
151LOGUNITEWM CW: Logistics Unit of Measurenvarchar30UNIT(N' ')YesMARMCIFLOGUNIT Allow NULL? 
152CWQRELEWM CW: Material Is a Catch Weight Materialchar10CHAR(N' ')YesCIFCWQREL Allow NULL? 
153CWQPROCEWM CW: Catch Weight Profile for Entering CW Quantitynvarchar20CHAR(N' ')YesTCWQPROCCIFCWQPROC Allow NULL? 
154CWQTOLGREWM-CW: Catch Weight Tolerance Group for EWMnvarchar90CHAR(N' ')YesTCWQTOLGRCIFCWQTOLGR Allow NULL? 
155/BEV1/LULEINHLoading Unitsnvarchar80NUMC(N'00000000')Yes/BEV1/LULEINH Allow NULL? 
156/BEV1/LULDEGRPLoading Unit Group: IS Beveragenvarchar30CHAR(N' ')Yes/BEV1/LUT906/BEV1/LULDEGRP Allow NULL? 
157/DSD/VC_GROUPDSD Groupingnvarchar60CHAR(N' ')Yes/DSD/VC_GRP/DSD/VC_GROUP Allow NULL? 
158/VSO/R_TILT_INDMaterial may be Tilted (Vehicle Space Optimization)char10CHAR(N' ')Yes/VSO/M_TILT_IND Allow NULL? 
159/VSO/R_STACK_INDStacking not Allowed (VSO)char10CHAR(N' ')Yes/VSO/M_STACK_IND Allow NULL? 
160/VSO/R_BOT_INDBottom Layer (Vehicle Space Optimization)char10CHAR(N' ')Yes/VSO/M_BOTTOM_IND Allow NULL? 
161/VSO/R_TOP_INDTop Layer (VSO)char10CHAR(N' ')Yes/VSO/M_TOP_IND Allow NULL? 
162/VSO/R_STACK_NOStacking Factor (Vehicle Space Optimization)nvarchar30NUMC(N'000')Yes/VSO/M_STACK_NO Allow NULL? 
163/VSO/R_PAL_INDLoad without Packaging Material (VSO)char10CHAR(N' ')Yes/VSO/M_PALLET_IND Allow NULL? 
164/VSO/R_PAL_OVR_DPermissible Overhang (Depth) of Packaging Material (VSO)decimal133QUAN((0))Yes/VSO/R_PAL_OVR_D
165/VSO/R_PAL_OVR_WPermissible Overhang (Width) of Shipping Material (VSO)decimal133QUAN((0))Yes/VSO/R_PAL_OVR_W
166/VSO/R_PAL_B_HTMaximum Stacking Height of the Packaging Material (VSO)decimal133QUAN((0))Yes/VSO/R_PAL_BIN_HGT
167/VSO/R_PAL_MIN_HMinimum Stacking Height of the Packaging Material (VSO)decimal133QUAN((0))Yes/VSO/R_PAL_MIN_HT
168/VSO/R_TOL_B_HTTolerance to Exceed the Max. Stacking Height (VSO)decimal133QUAN((0))Yes/VSO/R_TOL_BIN_HT
169/VSO/R_NO_P_GVHNumber of Materials for each Closed PKM (VSO)nvarchar20NUMC(N'00')Yes/VSO/M_ANZ_PER_GVH Allow NULL? 
170/VSO/R_QUAN_UNITUnit of Measure Vehicle Space Optimizationnvarchar30UNIT(N' ')Yes/VSO/R_QUAN_UNIT Allow NULL? 
171/VSO/R_KZGVH_INDClosed Packaging Material Required (VSO)char10CHAR(N' ')Yes/VSO/M_KZGVH_IND Allow NULL? 
172MCONDMaterial Condition Managementchar10CHAR(N' ')YesDFPS_MCOND Allow NULL? 
173RETDELCReturn Codechar10CHAR(N' ')YesDFPS_RETDELC Allow NULL? 
174LOGLEV_RETOReturn to Logistics Levelchar10CHAR(N' ')YesDFPS_LOGLEV_RETO Allow NULL? 
175NSNIDNATO Item Identification Numbernvarchar90CHAR(N' ')YesDFPS_NSNID Allow NULL? 
176IMATNFFF classnvarchar180CHAR(N' ')Yes*IMATN Allow NULL? 
177PICNUMSupersession chain numbernvarchar180CHAR(N' ')YesPIC_PICNUM_SUS Allow NULL? 
178BSTATCreation Status - Seasonal Procurementnvarchar20CHAR(N' ')Yes*WRFBSTAT Allow NULL? 
179COLOR_ATINNInternal Charactieristic Number for Color Characteristicsnvarchar100NUMC(N'0000000000')Yes*WRF_COLOR_ATINN Allow NULL? 
180SIZE1_ATINNInternal Char. Number for Characteristics for Main Sizesnvarchar100NUMC(N'0000000000')Yes*WRF_SIZE1_ATINN Allow NULL? 
181SIZE2_ATINNInternal Char. Number for Characteristics for Second Sizesnvarchar100NUMC(N'0000000000')Yes*WRF_SIZE2_ATINN Allow NULL? 
182COLORCharacteristic Value for Colors of Variantsnvarchar180CHAR(N' ')YesWRF_COLOR Allow NULL? 
183SIZE1Characteristic Value for Main Sizes of Variantsnvarchar180CHAR(N' ')YesWRF_SIZE1 Allow NULL? 
184SIZE2Characteristic Value for Second Size for Variantsnvarchar180CHAR(N' ')YesWRF_SIZE2 Allow NULL? 
185FREE_CHARCharacteristic Value for Evaluation Purposesnvarchar180CHAR(N' ')YesWRF_FREE_CHAR Allow NULL? 
186CARE_CODECare Codes (such as Washing Code, Ironing Code, etc.)nvarchar160CHAR(N' ')YesWRF_CARE_CODE Allow NULL? 
187BRAND_IDBrandnvarchar40CHAR(N' ')YesWRF_BRANDSWRF_BRAND_ID Allow NULL? 
188FIBER_CODE1Fiber Code for Textiles (Component 1)nvarchar30CHAR(N' ')YesWRF_FIBER_CODESWRF_FIBER_CODE_1 Allow NULL? 
189FIBER_PART1Percentage Share of Fiber (Component 1)nvarchar30NUMC(N'000')YesWRF_FIBER_PART_1 Allow NULL? 
190FIBER_CODE2Fiber Code for Textiles (Component 2)nvarchar30CHAR(N' ')YesWRF_FIBER_CODESWRF_FIBER_CODE_2 Allow NULL? 
191FIBER_PART2Percentage Share of Fiber (Component 2)nvarchar30NUMC(N'000')YesWRF_FIBER_PART_2 Allow NULL? 
192FIBER_CODE3Fiber Code for Textiles (Component 3)nvarchar30CHAR(N' ')YesWRF_FIBER_CODESWRF_FIBER_CODE_3 Allow NULL? 
193FIBER_PART3Percentage Share of Fiber (Component 3)nvarchar30NUMC(N'000')YesWRF_FIBER_PART_3 Allow NULL? 
194FIBER_CODE4Fiber Code for Textiles (Component 4)nvarchar30CHAR(N' ')YesWRF_FIBER_CODESWRF_FIBER_CODE_4 Allow NULL? 
195FIBER_PART4Percentage Share of Fiber (Component 4)nvarchar30NUMC(N'000')YesWRF_FIBER_PART_4 Allow NULL? 
196FIBER_CODE5Fiber Code for Textiles (Component 5)nvarchar30CHAR(N' ')YesWRF_FIBER_CODESWRF_FIBER_CODE_5 Allow NULL? 
197FIBER_PART5Percentage Share of Fiber (Component 5)nvarchar30NUMC(N'000')YesWRF_FIBER_PART_5 Allow NULL? 
198FASHGRDFashion Gradenvarchar40CHAR(N' ')YesFASHGRD Allow NULL? 
199MAKTXMaterial Description (Short Text)nvarchar400CHAR(N' ')YesMAKTX Allow NULL? 
200LVORMDeletion Indicatorchar10CHAR(N' ')YesLVORM Allow NULL? 
201UMREZNumerator for Conversion to Base Units of Measuredecimal50DEC((0))YesUMREZ
202UMRENDenominator for conversion to base units of measuredecimal50DEC((0))YesUMREN
203MESUBLower-Level Unit of Measure in a Packing Hierarchynvarchar30UNIT(N' ')Yes*MESUB Allow NULL? 
204ATINNInternal characteristicnvarchar100NUMC(N'0000000000')Yes*ATINN Allow NULL? 
205MESRTUnit of measure sort numbernvarchar20NUMC(N'00')YesMESRT Allow NULL? 
206XFHDWLeading batch-specific unit of measurechar10CHAR(N' ')YesXFHDW Allow NULL? 
207XBEWWValuation based on the batch-specific unit of measurechar10CHAR(N' ')YesXBEWW Allow NULL? 
208KZWSOUnits of measure usagechar10CHAR(N' ')YesKZWSO Allow NULL? 
209MSEHIUnit of Measurement of Characteristicnvarchar30UNIT(N' ')Yes*MSEHI_WS Allow NULL? 
210BFLME_MARMGeneric Material with Logistical Variantschar10CHAR(N' ')YesBFLME Allow NULL? 
211NEST_FTRRemaining Volume after Nesting (in Percentage)decimal30DEC((0))YesCIFNESTFTR
212MAX_STACKMaximum Stacking Factortinyint30INT1((0))YesCIFMXSTACK
213CAPAUSECapacity Usagedecimal153DEC((0))YesCIFCAPAUSE
214TY2TQEWM-CW: Category of Unit of Measurechar10CHAR(N' ')YesDE_EWMTY2TQ Allow NULL? 
215FLAG_BASE_UOMReplacement for Real Boolean Type: 'X' == True '' == Falsechar10CHAR(N' ')YesWDY_BOOLEAN Allow NULL? 
216CONV_FACTORNumber of Lower-Level Units of Measuredecimal83DEC((0))YesMEANZSUB
217BASE_UOMUnit of Measure for Displaynvarchar30UNIT(N' ')Yes*MEINH Allow NULL? 
NamePrimaryUniqueTypeColumns
/SMERP/STG_MM00300NoNoNONCLUSTEREDDSF_RECORD_ID, MANDT
/SMERP/STG_MM003A0NoNoNONCLUSTEREDDSF_DSTORE_ID, MANDT
/SMERP/STG_MM003~0YesYesCLUSTEREDDSF_GUID, MANDT