SAP Tables - SAP Business One/ERP Table Definition reference


icon of database logic symbol SAP  TABLESv1Made in Britain - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OOCR9Loading Factors
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

About us originally started life back in the June 2012, as, a basic online list of JDE table names and schemas. The site was created simply because we identified the large lack of inforation out on the internet relating to obtaining schema inforamation regarding JD Edwards Enterprise One ERP system, something we were using daily as a company employee.

This lack of information made working with these systems quite challenging and unnecassaryily frustrating - so the idea was born to help many other thousands of developers/users/report writers etc and offer a simply and free technical reference online.

The site quickly attracted traffic as its value proliferated within the JDE community. We were inundated with e-mails of congratulations and consolidarity.

Over time, we added adverts to the site to generate a revenue stream to support running costs (server hosting) as well as establish social media presense and a few site make-overs.

Since then, the site as grown from stength to strength, with the additions of multiple schemas, and more recently, the inclusion of SAP ERP data and the JDE Demo VM offerings.

Finally, to aid with SEO and adhere to common web standards, the sites ( and were moved to subdomains of a new domain, - so that we could use a single wildcard SSL certificate to cover both domains.

We are not a company, we are not many, we are not big. We are one. One father, one wife, 2 girls, who created this side hustle back in 2012 (when I was free and single) that now helpfully goes a small way to support his family along side his main employment. Our primary aim was, and still remains, to create something that many will hopefully find useful and valuable.

Contact us

We've love to hear your views, good or bad on the site - we're always looking to improve. You can get in touch with us directly if you like: or via our Facebook page.