Question:
I am retreiving some fields like Company code,Internal Order,G/L A/c and A/c type from the table BSEG. I am using only one index of BSEG ie BUKRS. So this is creating a performance issue.
So can please anyone give the alternate tables through which we can retreive Company code,Internal Order,G/L A/c, A/L type.Such that i can avoid hitting a huge table BSEG.
Thanks in advance.
Answer:
For any GL posting, take a look at BSIS/BSAS tables .. for AR - BSID/BSAD and for AP - BSIK/BSAK .. check the following tables relationship diagrams:
http://www.sapgenie.com/abap/tables_fi.htm