Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to link original document line description to journal line

I am trying to create an XLR report that almost replicates the standard General Ledger Report in SBO,

with the exception of ALSO displaying the Original marketing document line description and row


For Example:

AP Invoice of type Service posted with 2 rows,and description entered into each row on the AP

Invoice. When the document is added, a journal is created but the journal rows number do not

necessarily match the document row numbers (understandable.)

in the XLR report, I am using the parameters and dimensions from 'Financials' and therefore am able to

pick up info from the OJDT and JDT1 tables, and pull this information through onto row expansions of

the journal line details grouped by account number, however I would like also to display the marketing

document line description where appropriate EG info entered into INV1.dscription.

It would appear that I am not able to do this directly on the XLR line expansion, and so I created a view

in SQL listing all the row information from the INV1 table including the INV1.linenum field (with the idea

of bringing in the view into the XLR Report and looking up the information from this view) this is fine,

but in the SQL view I also want to display the corresponding line number from the JDT1 table, and can

not find a way of joining.

Can you help me please

Unable to get the information without returning duplicate results

single line detail for each journal line listing journal details and also the original marketing document line

number and description.

Thank you

Not what you were looking for? View more on this topic or Ask a question