<span id="hs_cos_wrapper_name" class="hs_cos_wrapper hs_cos_wrapper_meta_field hs_cos_wrapper_type_text" style="" data-hs-cos-general-type="meta_field" data-hs-cos-type="text" >SAP Business One Common Table Names and Queries</span>

SAP Business One Common Table Names and Queries

/* Business Partners */
SELECT * FROM OCRD

 

/* Chart of Accounts */
SELECT * FROM OACT

 

/* Item Master */
SELECT * FROM OITM

 

/* Terms Codes */
SELECT * FROM OCTG

 

/* Business Partners and their assigned payment terms */
SELECT OCTG.PymntGroup, OCRD.* FROM OCRD
LEFT OUTER JOIN OCTG ON OCRD.GroupNum = OCTG.GroupNum

 

/* Employee Master (HR) */
SELECT * FROM OHEM

 

/* Sales Quotations and their Line Items */
SELECT * FROM OQUT

INNER JOIN QUT1 ON OQUT.DocEntry = QUT1.DocEntry

 

/* Sales Orders and the Line Items */
SELECT * FROM ORDR
INNER JOIN RDR1 ON ORDR.DocEntry = RDR1.DocEntry

 

/* Credit Memos and the Line Items */
SELECT * FROM ORIN
INNER JOIN RIN1 ON ORIN.DocEntry = RIN1.DocEntry

 

/* Incomming Payments and the line level Information */

/* I have not validated this link */
SELECT * FROM ORCT

INNER JOIN RCT1 ON ORCT.DocNum = RCT1.DocNum

 

Thanks to Ed Monk of SBOnotes.com

Photo of Technical Team at Clients First Business Solutions

About the Author

Technical Team at Clients First Business Solutions

This article was developed by the technical team at Clients First Business Solutions, drawing on hands-on experience with ERP, business applications, integrations, and process improvement. The team works with clients to solve practical technology challenges and help them get more value from their systems.

View all posts by Technical Team at Clients First Business Solutions