Common Table Names and Queries

 A List of Common Table Names and Queries:

All Marketing Documents (PO, Sales Order, AP Invoice, AR Invoice) have different file/table names, but their field names are the same. You can quickly write a query over the Purchase Order file and then just copy it and change the table names and the query will still work.

/* 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