SAP query with FI-SD details
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.
Edited by: Anil Jonnalagadda on Oct 20, 2008 8:19 AM
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.