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

Home | ERP 6.0  | MEV_D_WL_ITEM
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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
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
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

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

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

SELECT MANDT, GUID_ITEM, OBJ_TYPE, OBJ_ID, OBJ_ITEM, LIFECYCLE_STATUS, USER_VERIF_STATUS, CALC_RESULT_STATUS, POPER, GJAHR, VAL_DATE, ERNAM, CRTSP, AENAM, CHTSP, CHTSPL, TEST_DATA_IND, BUKRS, MATNR, MATKL, CHARG, WERKS, ANTICIP_AMOUNT, POSTED_AMOUNT, WAERS, ANTICIP_QUANTITY, POSTED_QUANTITY, ORDER_UOM, GUID_TEXT, NOT_EFFECTIVE, HWAER, OBJ_ITEM_HL, EKORG, EKGRP, LIFNR, VKORG, VTWEG, SPART, VKGRP, VKBUR, KUNAG, PRE_OBJ_TYPE, PRE_OBJ_ID, PRE_OBJ_ITEM, PRE_OBJ_DOC_TYPE, PRE_OBJ_DOC_CAT, START_OBJ_TYPE, START_OBJ_ID, START_OBJ_ITEM, START_OBJ_DOC_TYPE, START_OBJ_DOC_CAT, START_OBJ_EXT_ID FROM MEV_D_WL_ITEM
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2GUID_ITEMPeriod-End Valuation: GUID as RAW 16varbinary160
3OBJ_TYPECommodity Management: Object Typenvarchar100 Allow NULL? 
4OBJ_IDCommodity Management: ID of Reference Documentnvarchar350 Allow NULL? 
5OBJ_ITEMCommodity Management: Item Number of Reference Documentnvarchar60 Allow NULL? 
6LIFECYCLE_STATUSLifecycle Status of Valuation Resultsnvarchar20 Allow NULL? 
7USER_VERIF_STATUSVerification Status of Valuation Resultsnvarchar20 Allow NULL? 
8CALC_RESULT_STATUSCalculation Result Status of Valuation Resultnvarchar20 Allow NULL? 
9POPERPosting periodnvarchar30 Allow NULL? 
10GJAHRFiscal Yearnvarchar40 Allow NULL? 
11VAL_DATEValuation Key Date for Worklistnvarchar80 Allow NULL? 
12ERNAMName of Person who Created the Objectnvarchar120 Allow NULL? 
13CRTSPUTC Time Stamp When Object Was Addeddecimal150
14AENAMName of Person Who Changed Objectnvarchar120 Allow NULL? 
15CHTSPUTC Time Stamp When Object Was Changeddecimal150
16CHTSPLUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
17TEST_DATA_INDPeriod-end Valuation: Test data indicatorchar10 Allow NULL? 
18BUKRSCompany Codenvarchar40 Allow NULL? 
19MATNRMaterial Numbernvarchar180 Allow NULL? 
20MATKLMaterial Groupnvarchar90 Allow NULL? 
21CHARGBatch Numbernvarchar100 Allow NULL? 
22WERKSPlantnvarchar40 Allow NULL? 
23ANTICIP_AMOUNTAnticipated Final Invoice Item Amountdecimal152
24POSTED_AMOUNTAmount Posted by GR or Provisional/Differential Invoicedecimal152
25WAERSCurrency Keynvarchar50 Allow NULL? 
26ANTICIP_QUANTITYAnticipated Final Invoice Item Quantitydecimal133
27POSTED_QUANTITYQuantity Posted by Goods Movement or Prov. / Diff. Invoicedecimal133
28ORDER_UOMOrder Unit of Measurenvarchar30 Allow NULL? 
29GUID_TEXTGUID for SAPScript Textnvarchar320 Allow NULL? 
30NOT_EFFECTIVEValuation Result/Accrual Doc. Item without Accr. Postingchar10 Allow NULL? 
31HWAERLocal Currencynvarchar50 Allow NULL? 
32OBJ_ITEM_HLCommodity Management: High Level Number of Object Itemnvarchar60 Allow NULL? 
33EKORGPurchasing Organizationnvarchar40 Allow NULL? 
34EKGRPPurchasing Groupnvarchar30 Allow NULL? 
35LIFNRAccount Number of Vendor or Creditornvarchar100 Allow NULL? 
36VKORGSales Organizationnvarchar40 Allow NULL? 
37VTWEGDistribution Channelnvarchar20 Allow NULL? 
38SPARTDivisionnvarchar20 Allow NULL? 
39VKGRPSales Groupnvarchar30 Allow NULL? 
40VKBURSales Officenvarchar40 Allow NULL? 
41KUNAGSold-to partynvarchar100 Allow NULL? 
42PRE_OBJ_TYPECommodity Management: Object Typenvarchar100 Allow NULL? 
43PRE_OBJ_IDCommodity Management: ID of Reference Documentnvarchar350 Allow NULL? 
44PRE_OBJ_ITEMCommodity Management: Item Number of Reference Documentnvarchar60 Allow NULL? 
45PRE_OBJ_DOC_TYPECommodity Management: Document Typenvarchar40 Allow NULL? 
46PRE_OBJ_DOC_CATCommodity Management: Document Categorynvarchar20 Allow NULL? 
47START_OBJ_TYPECommodity Management: Object Typenvarchar100 Allow NULL? 
48START_OBJ_IDCommodity Management: ID of Reference Documentnvarchar350 Allow NULL? 
49START_OBJ_ITEMCommodity Management: Item Number of Reference Documentnvarchar60 Allow NULL? 
50START_OBJ_DOC_TYPECommodity Management: Document Typenvarchar40 Allow NULL? 
51START_OBJ_DOC_CATCommodity Management: Document Categorynvarchar20 Allow NULL? 
52START_OBJ_EXT_IDCommodity Management: External IDnvarchar350 Allow NULL? 
NamePrimaryUniqueTypeColumns
MEV_D_WL_ITEM~0YesYesCLUSTEREDGUID_ITEM, MANDT
MEV_D_WL_ITEM~PRENoNoNONCLUSTEREDPRE_OBJ_ITEM, PRE_OBJ_ID, PRE_OBJ_TYPE
MEV_D_WL_ITEM~SKNoNoNONCLUSTEREDOBJ_ITEM, OBJ_ID, OBJ_TYPE, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy