SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

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
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data
Materials Management :: Inventory Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0MWZDM07M12351ZDM07M1Inventory Management
SQL:  selectupdate insert create

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

SELECT MANDT, MBLNR, MJAHR, ZEILE, ZEILD, EXWRT, KONTO, XKMAN, FAUSW, XCHAR, MAKTX, MATKL, TXART, RMBEW, XLORT, KZZDE, KZDRU, XLIFO, VMENG, VERMG, VBSMG, VBPMG, VWERT, VVKWR, VWERR, VWALT, VWERE, BTEXT, XEINK, KTOPL, PERIV, BWMOD, BKLAS, EKLAS, QKLAS, OKLAS, BWTTY, PEINH, STPRS, VERPR, SALKV, VKSAL, VMKUM, VMSAL, VMPEI, VMSTP, VMVER, VMSAV, KZVBL, KZVBU, PERKZ, PERIM, VZBEW, KNTTP, BSTYP, NAME1, ORT01, PSTLZ, INCO1, INCO2, UMREZ, UMREN, BPUMZ, BPUMN, BSMNG, BPBMG, UETMG, UNTMG, WAMNG, WAWRT, WESBS, BPWES, WEMNG, WWMNG, MB_BPRME, BPWEM, BPWWM, WEWRT, REMNG, BPREM, MULKO, REWRT, AREWR, XELIK, SPERQ, SSQSS, ZGTYP, XZGVH, INSNC, KZUML, UMRMB, UMBUK, UMBWK, UMXLI, UMHRK, UMGJA, UMMON, UMXRM, UMXRJ, UMLFG, UMLFM, UMTYP, UMWAE, UMVWE, UMVWR, UMBUA, UMVWA, UMPEI, UMVPR, UMGSB, UMPRC, UMKPL, UMPER, UMBWM, UMBKL, UMEKL, UMQKL, UMOKL, UMLBK, UMSAL, UMSTP, UMVER, UMSAV, UMVKS, UMVKU, UMVSA, UMVPE, UMVSP, UMVVP, UMVMS, UMWER, UMMYK, UMKZV, UMMTV, UMFAB, UMPLI, UMEIS, UMMINBE, UMWEB, UMWZE, UMBES, UMUML, UMXQS, UMSOF, UMSOL, UMSOV, UMARC, UMARD, UMCHB, UMBPR, UMLIB, UMKOL, UMEIK, UMKLK, UMKUB, UEKPO, UFAUP, UMRES, UMSKU, UMSLB, UMSSL, UMSKA, UMSSA, UMSPR, UMSSQ, UMSCA, UMSOA, UMSCP, UMSOP, UMLBB, UMKBB, UMDIS, UMDIT, UMXPB, UMMIS, UMVRM, UMVI1, UMVI2, UMBDT, KZVBP, PLIFZ, UMLMC, WEBAZ, WZEIT, ATPM1, BESKZ, UBFKZ, UMLGN, UMLGT, UMLGP, UMBSQ, UMBLV, UMXBL, UMVOS, UMNAS, UMDYP, UMTBF, UMTRA, UMBTY, UMBEN, UMTBP, UMWKZ, UMBKZ, WENUM, MBLMG, MBLBM, MBBMG, FABKL, RSHKZ, BDMNG, ENMNG, BDART, ENWRT, RLGOR, RCHAR, KONPR, KOPEI, ANZRE, ANBWA, LNRAN, BEWAR, VMVKS, UMVMVKS, UMXHUPF, UMVKORG, UMVSTEL, UMVTWEG, UMSPART, UMSDLIF, UMSDKUN, UISEG, UMIBPOI, IMSEG_ORIGINAL, UMDISMM, PARBW FROM MWZDM07M1
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2MBLNRNumber of Material Documentnvarchar100 Allow NULL? 
3MJAHRMaterial Document Yearnvarchar40 Allow NULL? 
4ZEILEItem in Material Documentnvarchar40 Allow NULL? 
5ZEILDItem in Material Documentnvarchar40 Allow NULL? 
6EXWRTAmount in Local Currencydecimal132
7KONTOG/L Account Numbernvarchar100 Allow NULL? 
8XKMANAccount entered manuallychar10 Allow NULL? 
9FAUSWField Selection Stringnvarchar1280 Allow NULL? 
10XCHARBatch management indicator (internal)char10 Allow NULL? 
11MAKTXMaterial Description (Short Text)nvarchar400 Allow NULL? 
12MATKLMaterial Groupnvarchar90 Allow NULL? 
13TXARTText type in material master record (purchasing/sales)char10 Allow NULL? 
14RMBEWReturn code MBEWchar10 Allow NULL? 
15XLORTStorage location necessarychar10 Allow NULL? 
16KZZDEMaintain status data of a batchchar10 Allow NULL? 
17KZDRUPrinting of document itemchar10 Allow NULL? 
18XLIFOLIFO/FIFO-Relevantchar10 Allow NULL? 
19VMENGQuantitydecimal133
20VERMGQuantity in Unit of Entrydecimal133
21VBSMGGoods receipt quantity in order unitdecimal133
22VBPMGGoods Receipt Quantity in Purchase Order Price Unitdecimal133
23VWERTAmount in Local Currencydecimal132
24VVKWRValue at Sales Prices Including Value-Added Taxdecimal132
25VWERRAmount in Local Currencydecimal132
26VWALTAmount posted in alternative price controldecimal132
27VWEREAmount in Local Currencydecimal132
28BTEXTMovement Type Text (Inventory Management)nvarchar200 Allow NULL? 
29XEINKIndicator: Purchase Account Processing is Activechar10 Allow NULL? 
30KTOPLChart of Accountsnvarchar40 Allow NULL? 
31PERIVFiscal Year Variantnvarchar20 Allow NULL? 
32BWMODValuation Grouping Codenvarchar40 Allow NULL? 
33BKLASValuation Classnvarchar40 Allow NULL? 
34EKLASValuation Class for Sales Order Stocknvarchar40 Allow NULL? 
35QKLASValuation Class for Project Stocknvarchar40 Allow NULL? 
36OKLASValuation Class for Special Stock at the Vendornvarchar40 Allow NULL? 
37BWTTYValuation Categorychar10 Allow NULL? 
38PEINHPrice Unitdecimal50
39STPRSStandard pricedecimal112
40VERPRMoving Average Price/Periodic Unit Pricedecimal112
41SALKVValue based on moving average price (only with price ctrl S)decimal132
42VKSALValue of Total Valuated Stock at Sales Pricedecimal132
43VMKUMTotal valuated stock in previous perioddecimal133
44VMSALValue of total valuated stock in previous perioddecimal132
45VMPEIPrice unit of previous perioddecimal50
46VMSTPStandard price in the previous perioddecimal112
47VMVERMoving Average Price/Periodic Unit Price in Previous Perioddecimal112
48VMSAVValue based on moving average price (previous period)decimal132
49KZVBLArithmeticchar10 Allow NULL? 
50KZVBUConsumption postingchar10 Allow NULL? 
51PERKZPeriod Indicatorchar10 Allow NULL? 
52PERIMFiscal Year Variantnvarchar20 Allow NULL? 
53VZBEWSign (+/-) of Material Postingchar10 Allow NULL? 
54KNTTPAccount Assignment Categorychar10 Allow NULL? 
55BSTYPPurchasing Document Categorychar10 Allow NULL? 
56NAME1Namenvarchar300 Allow NULL? 
57ORT01Citynvarchar250 Allow NULL? 
58PSTLZPostal Codenvarchar100 Allow NULL? 
59INCO1Incoterms (Part 1)nvarchar30 Allow NULL? 
60INCO2Incoterms (Part 2)nvarchar280 Allow NULL? 
61UMREZNumerator for Conversion to Base Units of Measuredecimal50
62UMRENDenominator for conversion to base units of measuredecimal50
63BPUMZNumerator for Conversion of Order Price Unit into Order Unitdecimal50
64BPUMNDenominator for Conv. of Order Price Unit into Order Unitdecimal50
65BSMNGQuantity Ordereddecimal133
66BPBMGPurchase order quantity in order price unitdecimal133
67UETMGOverdelivery tolerance (quantity)decimal133
68UNTMGUnderdelivery Tolerance (Quantity)decimal133
69WAMNGIssued Quantitydecimal133
70WAWRTSum of the values of goods issuesdecimal132
71WESBSGoods Receipt Blocked Stock in Order Unitdecimal133
72BPWESQuantity in GR blocked stock in order price unitdecimal133
73WEMNGQuantity of Goods Receiveddecimal133
74WWMNGValuated goods receipt quantitydecimal133
75MB_BPRMEQuantity in Purchase Order Price Unitnvarchar30 Allow NULL? 
76BPWEMGoods Receipt Quantity in Purchase Order Price Unitdecimal133
77BPWWMValuated Goods Receipt Quantity in Order Unitdecimal133
78WEWRTValue of goods received in local currencydecimal132
79REMNGQuantity invoiceddecimal133
80BPREMInvoice receipt quantity in order price unitdecimal133
81MULKOIndicator: Multiple account assignmentchar10 Allow NULL? 
82REWRTInvoice value in local currencydecimal132
83AREWRGR/IR account clearing value in local currencydecimal132
84XELIKSuggest "delivery completed" indicatorchar10 Allow NULL? 
85SPERQFunction That Will Be Blockednvarchar20 Allow NULL? 
86SSQSSControl Key for Quality Management in Procurementnvarchar80 Allow NULL? 
87ZGTYPCertificate Typenvarchar40 Allow NULL? 
88XZGVHProcessing of certificate in procurement activechar10 Allow NULL? 
89INSNCQuality inspection indicator cannot be changedchar10 Allow NULL? 
90KZUMLStock transfer/transfer postingchar10 Allow NULL? 
91UMRMBReturn code MBEWchar10 Allow NULL? 
92UMBUKCompany Codenvarchar40 Allow NULL? 
93UMBWKValuation Areanvarchar40 Allow NULL? 
94UMXLILIFO/FIFO-Relevantchar10 Allow NULL? 
95UMHRKOrigin Group as Subdivision of Cost Elementnvarchar40 Allow NULL? 
96UMGJAFiscal Yearnvarchar40 Allow NULL? 
97UMMONFiscal Periodnvarchar20 Allow NULL? 
98UMXRMAllow Posting to Previous Period (Backposting)char10 Allow NULL? 
99UMXRJIndicator: post to previous yearchar10 Allow NULL? 
100UMLFGFiscal Year of Current Periodnvarchar40 Allow NULL? 
101UMLFMCurrent period (posting period)nvarchar20 Allow NULL? 
102UMTYPValuation Categorychar10 Allow NULL? 
103UMWAECurrency Keynvarchar50 Allow NULL? 
104UMVWEAmount in Local Currencydecimal132
105UMVWRAmount in Local Currencydecimal132
106UMBUAAmount posted in alternative price controldecimal132
107UMVWAAmount posted in alternative price controldecimal132
108UMPEIPrice Unitdecimal50
109UMVPRPrice control indicatorchar10 Allow NULL? 
110UMGSBBusiness Areanvarchar40 Allow NULL? 
111UMPRCProfit Centernvarchar100 Allow NULL? 
112UMKPLChart of Accountsnvarchar40 Allow NULL? 
113UMPERFiscal Year Variantnvarchar20 Allow NULL? 
114UMBWMValuation Grouping Codenvarchar40 Allow NULL? 
115UMBKLValuation Classnvarchar40 Allow NULL? 
116UMEKLValuation Class for Sales Order Stocknvarchar40 Allow NULL? 
117UMQKLValuation Class for Project Stocknvarchar40 Allow NULL? 
118UMOKLValuation Class for Special Stock at the Vendornvarchar40 Allow NULL? 
119UMLBKTotal Valuated Stockdecimal133
120UMSALValue of Total Valuated Stockdecimal132
121UMSTPStandard pricedecimal112
122UMVERMoving Average Price/Periodic Unit Pricedecimal112
123UMSAVValue based on moving average price (only with price ctrl S)decimal132
124UMVKSValue of Total Valuated Stock at Sales Pricedecimal132
125UMVKUTotal valuated stock in previous perioddecimal133
126UMVSAValue of total valuated stock in previous perioddecimal132
127UMVPEPrice unit of previous perioddecimal50
128UMVSPStandard price in the previous perioddecimal112
129UMVVPMoving Average Price/Periodic Unit Price in Previous Perioddecimal112
130UMVMSValue based on moving average price (previous period)decimal132
131UMWERValue Update in Material Master Recordchar10 Allow NULL? 
132UMMYKLIFO valuation levelnvarchar40 Allow NULL? 
133UMKZV+/- sign for consumption update in material master recordchar10 Allow NULL? 
134UMMTVChecking Group for Availability Checknvarchar20 Allow NULL? 
135UMFABFactory calendar keynvarchar20 Allow NULL? 
136UMPLIPlanned Delivery Time in Daysdecimal30
137UMEISSafety Stockdecimal133
138UMMINBEReorder Pointdecimal133
139UMWEBGoods Receipt Processing Time in Daysdecimal30
140UMWZETotal replenishment lead time (in workdays)decimal30
141UMBESProcurement Typechar10 Allow NULL? 
142UMUMLStock in Transfer (Plant to Plant)decimal133
143UMXQSNo Manual Inventory Posting for QM-Relevant Materialchar10 Allow NULL? 
144UMSOFSpecial stock ind.: Accounting/bookkeeping assignmentchar10 Allow NULL? 
145UMSOLSpecial stock indicator: Logistics assignmentchar10 Allow NULL? 
146UMSOVSpecial stock indicator: Transaction assignmentchar10 Allow NULL? 
147UMARCSegment string MARCnvarchar30 Allow NULL? 
148UMARDSegment string MARDnvarchar30 Allow NULL? 
149UMCHBSegment string MCHBnvarchar30 Allow NULL? 
150UMBPRSegment string MBPRnvarchar30 Allow NULL? 
151UMLIBSegment stringnvarchar30 Allow NULL? 
152UMKOLSegment string MKOLnvarchar30 Allow NULL? 
153UMEIKSegment string MEIKnvarchar30 Allow NULL? 
154UMKLKSegment string MKLKnvarchar30 Allow NULL? 
155UMKUBSegment string MKVBnvarchar30 Allow NULL? 
156UEKPOSegment string EKPOnvarchar30 Allow NULL? 
157UFAUPSegment string FAUPnvarchar30 Allow NULL? 
158UMRESSegment string MRESnvarchar30 Allow NULL? 
159UMSKUSegment string MSKUnvarchar30 Allow NULL? 
160UMSLBSegment string MSLBnvarchar30 Allow NULL? 
161UMSSLSegment string MSSLnvarchar30 Allow NULL? 
162UMSKASegment string MSKAnvarchar30 Allow NULL? 
163UMSSASegment string MSSAnvarchar30 Allow NULL? 
164UMSPRSegment string MSPRnvarchar30 Allow NULL? 
165UMSSQSegment string MSSQnvarchar30 Allow NULL? 
166UMSCASegment string MSCAnvarchar30 Allow NULL? 
167UMSOASegment string MSOAnvarchar30 Allow NULL? 
168UMSCPSegment string MSCPnvarchar30 Allow NULL? 
169UMSOPSegment string MSOPnvarchar30 Allow NULL? 
170UMLBBStock Type of Goods Movement (Primary Posting)nvarchar20 Allow NULL? 
171UMKBBStock Type of Goods Movement (Complementary Posting)nvarchar20 Allow NULL? 
172UMDISStorage location MRP indicatorchar10 Allow NULL? 
173UMDITLow-Level Codenvarchar30 Allow NULL? 
174UMXPBRequirements reduction upon goods movementschar10 Allow NULL? 
175UMMISMixed MRP indicatorchar10 Allow NULL? 
176UMVRMConsumption modechar10 Allow NULL? 
177UMVI1Consumption period: backwardnvarchar30 Allow NULL? 
178UMVI2Consumption period: forwardnvarchar30 Allow NULL? 
179UMBDTRequirement Date for the Componentnvarchar80 Allow NULL? 
180KZVBPDynamic availability check for goods movementchar10 Allow NULL? 
181PLIFZPlanned Delivery Time in Daysdecimal30
182UMLMCQuantitydecimal133
183WEBAZGoods Receipt Processing Time in Daysdecimal30
184WZEITTotal replenishment lead time (in workdays)decimal30
185ATPM1ATP quantitydecimal133
186BESKZProcurement Typechar10 Allow NULL? 
187UBFKZIndicator: Creation of a Posting Change Noticechar10 Allow NULL? 
188UMLGNWarehouse Number / Warehouse Complexnvarchar30 Allow NULL? 
189UMLGTStorage Typenvarchar30 Allow NULL? 
190UMLGPStorage Binnvarchar100 Allow NULL? 
191UMBSQStock Category in the Warehouse Management Systemchar10 Allow NULL? 
192UMBLVMovement Type for Warehouse Managementnvarchar30 Allow NULL? 
193UMXBLIndicator: posting in warehouse management systemchar10 Allow NULL? 
194UMVOSInd: interim storage posting for source stor.type and binchar10 Allow NULL? 
195UMNASInd.: interim storage posting for dest.stor.type and binchar10 Allow NULL? 
196UMDYPIndicator: dynamic storage binchar10 Allow NULL? 
197UMTBFIndicator: Creation/Cancellation of a Transfer Requirementchar10 Allow NULL? 
198UMTRAShipment Typechar10 Allow NULL? 
199UMBTYRequirement Typechar10 Allow NULL? 
200UMBENRequirement Numbernvarchar100 Allow NULL? 
201UMTBPTransfer Prioritychar10 Allow NULL? 
202UMWKZIndicator: generate goods receipt datechar10 Allow NULL? 
203UMBKZPosting change indicator in Warehouse Management (WM)char10 Allow NULL? 
204WENUMGoods Receipt Numbernvarchar100 Allow NULL? 
205MBLMGQuantitydecimal133
206MBLBMQuantity in Purchase Order Price Unitdecimal133
207MBBMGQuantity Ordered Against this Purchase Requisitiondecimal133
208FABKLFactory calendar keynvarchar20 Allow NULL? 
209RSHKZDebit/Credit Indicatorchar10 Allow NULL? 
210BDMNGRequirement Quantitydecimal133
211ENMNGQuantity Withdrawndecimal133
212BDARTRequirement typenvarchar20 Allow NULL? 
213ENWRTValue Withdrawndecimal132
214RLGORStorage Locationnvarchar40 Allow NULL? 
215RCHARBatch Numbernvarchar100 Allow NULL? 
216KONPRConsignment pricedecimal112
217KOPEIPrice unit for consignment pricedecimal50
218ANZRERules for display of goods movementsnvarchar30 Allow NULL? 
219ANBWAAsset Transaction Typenvarchar30 Allow NULL? 
220LNRANSequence number of asset line items in fiscal yearnvarchar50 Allow NULL? 
221BEWARConsolidation Transaction Typenvarchar30 Allow NULL? 
222VMVKSValue of Tot. Valuated Stock at Sales Price in Previous Per.decimal132
223UMVMVKSValue of Tot. Valuated Stock at Sales Price in Previous Per.decimal132
224UMXHUPFHandling unit requirementchar10 Allow NULL? 
225UMVKORGSales Organizationnvarchar40 Allow NULL? 
226UMVSTELShipping Point/Receiving Pointnvarchar40 Allow NULL? 
227UMVTWEGDistribution Channelnvarchar20 Allow NULL? 
228UMSPARTDivisionnvarchar20 Allow NULL? 
229UMSDLIFAccount Number of Vendor or Creditornvarchar100 Allow NULL? 
230UMSDKUNCustomer Numbernvarchar100 Allow NULL? 
231UISEGSegment string ISEGnvarchar30 Allow NULL? 
232UMIBPOIPointer on phys. inv. docmt itemnvarchar100 Allow NULL? 
233IMSEG_ORIGINALItem in Material Documentnvarchar40 Allow NULL? 
234UMDISMMMRP Typenvarchar20 Allow NULL? 
235PARBWValuation Grouping Codenvarchar40 Allow NULL? 
NamePrimaryUniqueTypeColumns
MWZDM07M1~0YesYesCLUSTEREDZEILE, MJAHR, MBLNR, MANDT