VAT Return Schedule

[Former Member]

Hi gurus

I am a newbie in abap programming and i need assistance from you.My client wants me to develop a program that enables them to extract data for input tax and output tax  by business area so that the difference from the two will provide  Tax to be returned to the revenue authority.Firstly i noticed that when items are being posted the tax line item component does not have the business area in BSEG.but i later realized that table FAGLFLEXA contains the correct details for tax . it has the line item component for tax with business area.

However    1) i am confused as on how to build the select statement that is to fetch the data from the tables since some items which feed the input or output tax can be items neither from a vendor or customer such as items bought through petty cash .

2)    I need to use alv grid concept in my report but i am not sure as on how to use it because i only have theoretical knowledge maybe a code snippet might help with comments on it so that i can follow.

Regards

Rejoice

Moderator Message - Spoon feeding is not allowed in the forums.

Message was edited by: Suhas Saha

[VXLozano]

Maybe you need some additional formation... a small course about SQL could be a good idea.

About the ALV thing, SAP has some *ALV* sample programs. Check them and start from there.

[Former Member]

thanks