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

2018-05-16T14:59:31+00:00 May 16th, 2018|General ERP articles|Comments Off on SAP Business One Common Table Names and Queries