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_MM0042223Data staging - Material warehouse 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, LGNUM, LVORM, LGBKZ, LTKZE, LTKZA, LHMG1, LHMG2, LHMG3, LHME1, LHME2, LHME3, LETY1, LETY2, LETY3, LVSME, KZZUL, BLOCK, KZMBF, BSSKZ, MKAPV, BEZME, PLKPT, VOMEM, L2SKR FROM /SMERP/STG_MM004
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? 
199LGNUMWarehouse Number / Warehouse Complexnvarchar30CHAR(N' ')Yes*LGNUM Allow NULL? 
200LVORMDeletion flag for all material data of a warehouse numberchar10CHAR(N' ')YesLVOLN Allow NULL? 
201LGBKZStorage Section Indicatorsnvarchar30CHAR(N' ')YesT304LVS_LGBKZ Allow NULL? 
202LTKZEStorage type indicator for stock placementnvarchar30CHAR(N' ')YesT305MLGN_LTKZE Allow NULL? 
203LTKZAStorage type indicator for stock removalnvarchar30CHAR(N' ')YesT305MLGN_LTKZA Allow NULL? 
204LHMG1Loading equipment quantity 1decimal133QUAN((0))YesLVS_LHMNG1
205LHMG2Loading equipment quantity 2decimal133QUAN((0))YesLVS_LHMNG2
206LHMG3Loading equipment quantity 3decimal133QUAN((0))YesLVS_LHMNG3
207LHME1Unit of measure for loading equipment quantity 1nvarchar30UNIT(N' ')YesT006LHMEH1 Allow NULL? 
208LHME2Unit of measure for loading equipment quantity 2nvarchar30UNIT(N' ')YesT006LHMEH2 Allow NULL? 
209LHME3Unit of measure for loading equipment quantity 3nvarchar30UNIT(N' ')YesT006LHMEH3 Allow NULL? 
210LETY11st storage unit typenvarchar30CHAR(N' ')YesT307LVS_LETYP1 Allow NULL? 
211LETY22nd storage unit typenvarchar30CHAR(N' ')YesT307LVS_LETYP2 Allow NULL? 
212LETY33rd storage unit typenvarchar30CHAR(N' ')YesT307LVS_LETYP3 Allow NULL? 
213LVSMEWarehouse Management Unit of Measurenvarchar30UNIT(N' ')YesT006LVS_LVSME Allow NULL? 
214KZZULIndicator: Allow addition to existing stockchar10CHAR(N' ')YesMLGN_KZZUL Allow NULL? 
215BLOCKBulk storage indicatornvarchar20CHAR(N' ')YesT338LVS_BLOCK2 Allow NULL? 
216KZMBFIndicator: Message to inventory managementchar10CHAR(N' ')YesKZMBF Allow NULL? 
217BSSKZSpecial movement indicator for warehouse managementchar10CHAR(N' ')YesT306LVS_BSSKZ Allow NULL? 
218MKAPVCapacity usagedecimal113DEC((0))YesMLGN_MKAPV
219BEZMEUnit of measure for capacity consumptionnvarchar30UNIT(N' ')YesT006MLGN_BEZME Allow NULL? 
220PLKPTPicking storage type for rough-cut and detailed planningnvarchar30CHAR(N' ')YesT301MLGN_PLKPT Allow NULL? 
221VOMEMDefault for unit of measure from material master recordchar10CHAR(N' ')YesMLGN_VOMEM Allow NULL? 
222L2SKRMaterial relevance for 2-step pickingchar10CHAR(N' ')YesMLGN_L2SKR Allow NULL? 
NamePrimaryUniqueTypeColumns
/SMERP/STG_MM00400NoNoNONCLUSTEREDDSF_RECORD_ID, MANDT
/SMERP/STG_MM004A0NoNoNONCLUSTEREDDSF_DSTORE_ID, MANDT
/SMERP/STG_MM004~0YesYesCLUSTEREDDSF_GUID, MANDT