Skip to Content

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

SAP query with FI-SD details

Hi all,

I need a report for open items between 2 dates (1.1.08 to 31.1.08) along with the details of billing document number and Sales order number.

Can you tell me whether any std. t code provdes these details..!?

If no, Can I create query for the same..!? what tables should I consider for this and in which order I should join them...!?

Actually, I have tried SQ01, 02 and 03 but when i executing the report, the system is given no items.

Br..........AJ

Edited by: Anil Jonnalagadda on Oct 20, 2008 8:19 AM

Former Member
Former Member replied

Hello,

I am not sure if there is standard transaction code that solves thi problem. But you can create report wit sql query tool to join these data.

I did something simmilar once. I used tables BSID, VBRK and KNA1. Table VBRK contains the information about billing document. I have document for this in details and screens but it is not in english....

I am not sure why you can't see any data...Try to be more specific with your question and problems that occurs, maybe I could help.

Regards.

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