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
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

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

44 columns | Print definition?ERP 6.0  | PRSDT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000178000PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item126PRSDTnvarchar80
2/BIC/B0000179000PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule106PRSDTnvarchar80
3/BIC/B0000181000PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond.71PRSDTnvarchar80
4/BIC/B0000185000PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item77PRSDTnvarchar80
5/BIC/B0000186000PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond.57PRSDTnvarchar80
TOPAdvertising Management
6JHAGAIS-M/AM: Order-Publishing-Media Billing Dataset157PRSDTDate for pricing and exchange ratenvarchar80
7JHFREV2IS-M/AM: Key Dates for Billing Document Revenue Recognition63PRSDTDate for pricing and exchange ratenvarchar80
8JHFREV4IS-M/AM: Billing Document Revenue Recognition Key Date Qties60PRSDTDate for pricing and exchange ratenvarchar80
9JHTFPIS-M/AM: Billing/Settlement Documents - Item47PRSDTDate for pricing and exchange ratenvarchar80
TOPAgency Business Global Trade
10WBRPAgency business: Item9PRSDTDate for pricing and exchange ratenvarchar80
TOPBilling
11VBRPBilling Document: Item Data19PRSDTDate for pricing and exchange ratenvarchar80
TOPContract Accounts Receivable and Payable
12FKK_JFRP_SHORTItem Data for IS-M/SD Billing Document - Extracts13PRSDTDate for pricing and exchange ratenvarchar80
13FKK_JLRPCM_SHORTItem Data for IS-M/SD Commission Settlement - Extracts10PRSDTDate for pricing and exchange ratenvarchar80
TOPCosting
14COERSales Order Value Revenue88PRSDTDate for pricing and exchange ratenvarchar80
TOPCross-Application Components
15VVBKDSales Document: Business Data21PRSDTDate for pricing and exchange ratenvarchar80
TOPData Collection
16S008Communications Table SD -> CO/Projects46PRSDTDate for pricing and exchange ratenvarchar80
17S260SD - Sales order69PRSDTDate for pricing and exchange ratenvarchar80
18S260BIW1SD - Sales order69PRSDTDate for pricing and exchange ratenvarchar80
19S260BIW2SD - Sales order69PRSDTDate for pricing and exchange ratenvarchar80
20S262SD - Billing document37PRSDTDate for pricing and exchange ratenvarchar80
21S262BIW1SD - Billing document37PRSDTDate for pricing and exchange ratenvarchar80
22S262BIW2SD - Billing document37PRSDTDate for pricing and exchange ratenvarchar80
23S264SD- Offer71PRSDTDate for pricing and exchange ratenvarchar80
24S264BIW1S264BIW1 * SD - Quotation71PRSDTDate for pricing and exchange ratenvarchar80
25S264BIW2S264BIW2 * SD - Quotation71PRSDTDate for pricing and exchange ratenvarchar80
TOPData Retention Tool
26TXW_S_VBRPRetrieve VBRP from archive31PRSDTDate for pricing and exchange ratenvarchar80
TOPFreight Processing
27VFKKShipment Costs: Header Data6PRSDTPricing datenvarchar80
28VFKPShipment Costs: Item Data10PRSDTPricing datenvarchar80
TOPIntegration
29FKK_VBRP_SHORTItem Data for SD Billing Document - Extracts27PRSDTDate for pricing and exchange ratenvarchar80
TOPMedia Product Sales and Distribution
30JKSDORDERINDEXIndex Table for IS-M Orders23PRSDTDate for pricing and exchange ratenvarchar80
31JKSDRETURNCHECKIS-M: Quantity Check on Return21PRSDTDate for pricing and exchange ratenvarchar80
32JKSDUNSOLDITEMIS-M: Item Data on Unsold Copies/Credit Memos75PRSDTDate for pricing and exchange ratenvarchar80
TOPPatient Accounting
33NVBRPIS-H: Billing document item data8PRSDTDate for pricing and exchange ratenvarchar80
TOPPeriodical Sales and Distribution
34JFDFSIS-M/SD: Billing/Settlement Index52PRSDTDate for pricing and exchange ratenvarchar80
35JFRPIS-M/SD: Billing Document - Item Data8PRSDTDate for pricing and exchange ratenvarchar80
36JKEPSales Order: Schedule Line Data33PRSDTDate for pricing and exchange ratenvarchar80
37JLRPIS-M/SD: Item Data for Settlement9PRSDTDate for pricing and exchange ratenvarchar80
TOPPricing
38PRCD_HEADPrice Condition Set (Header)12PRSDTCondition Pricing Datenvarchar80
TOPProduction and Revenue Accounting
39OIUCM_CONTRACTPRA Contracts35PRSDTDate for pricing and exchange ratenvarchar80
TOPReal Estate Management
40VIAKBSEGDocument Line Item from SCS for Interface150PRSDTDate for pricing and exchange ratenvarchar80
TOPRevenues and Earnings
41VPKHEADSales Pricing Header Data29PRSDTPricing datenvarchar80
TOPSales
42VBKDSales Document: Business Data21PRSDTDate for pricing and exchange ratenvarchar80
TOPSimulation
43VSVBKD_CNVersion: Sales document - commercial data22PRSDTDate for pricing and exchange ratenvarchar80
TOPWarranty Claim Processing
44PNWTYVWarranty Claim Version (PVS Node)16PRSDTDate for Pricing and Exchange Ratenvarchar80