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)
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
5OVPM154Outgoing Payments
6OINM101Whse Journal
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Industry Specific :: Mill Products Industry Solution :: Sales and Distribution SD enhancements
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/SAPMP/SD_LGST181Control Table for Rental FeesSales and Distribution SD enhancements
SQL:  selectupdate insert create

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

SELECT MANDT, VKORG, /SAPMP/ABAR_ZW, /SAPMP/ABAR_RE, /SAPMP/PRTAG, /SAPMP/RVGART, /SAPMP/VGPRVKW, WAERS, /SAPMP/FSRVG, /SAPMP/PRKLG, /SAPMP/UEBVRG, /SAPMP/AUSGUT, /SAPMP/STTAG, /SAPMP/LGFRZ, /SAPMP/ALS, /SAPMP/AGS, /SAPMP/AKO, /SAPMP/PKO FROM /SAPMP/SD_LGST
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2VKORGSales Organizationnvarchar40 Allow NULL? 
3/SAPMP/ABAR_ZWSettlement Type for Interim Settlementchar10 Allow NULL? 
4/SAPMP/ABAR_RESettlement Type for Remaining Periodchar10 Allow NULL? 
5/SAPMP/PRTAGPercentage for Daily Settlementdecimal74
6/SAPMP/RVGARTReimbursement Typechar10 Allow NULL? 
7/SAPMP/VGPRVKWRefund Percentage of Sales Valuedecimal74
8WAERSCurrency Keynvarchar50 Allow NULL? 
9/SAPMP/FSRVGFixed Amount for Reimbursementdecimal92
10/SAPMP/PRKLGPercentage Discount on Cumulated Rental Feedecimal74
11/SAPMP/UEBVRGReimburse Overpaymentchar10 Allow NULL? 
12/SAPMP/AUSGUTAutomatic Creation of Credit Memo When Booked Outchar10 Allow NULL? 
13/SAPMP/STTAGKey Date Up to Which No Fees Duenvarchar20 Allow NULL? 
14/SAPMP/LGFRZFree Rental Period in Monthsnvarchar20 Allow NULL? 
15/SAPMP/ALSReturnable Packaging Processing Order Type for Debit Memosnvarchar40 Allow NULL? 
16/SAPMP/AGSReturnable Packaging Processing Order Type for Vouchersnvarchar40 Allow NULL? 
17/SAPMP/AKOReturnable Packaging Condition Key for Credit/Debit Memonvarchar40 Allow NULL? 
18/SAPMP/PKOReturn.Pack.Percentage Condition Key for Credit/Debit Memosnvarchar40 Allow NULL? 
NamePrimaryUniqueTypeColumns
/SAPMP/SD_LGST~0YesYesCLUSTEREDVKORG, MANDT