Witholding tax report with expense GL account

[govind_gogate2]

Dear All,

The issue relates to presentation of accounting data as desired by the user.

Following is the data from the Witholding Tax account as we get.

The user wants following details to be added to the report.

The document data is available in BSEG anyway. If we check the document there, we can get Vendor code & witholding tax base amount, but the Expense GL code in another line item and it is not available anywhere on the fist line item.

Has anybody tried to do this?

Please advice,

Gov

[Former Member]

Hi Govind,

This output an be achieved pragmatically. The ABAPer would need the functional consultant to guide the logic and the tables involved in fetching the data. Probably most of it can be fetched through BSEG. If there is any other table which stores the data then we should consider that instead of BSEG since its a cluster table.

Regards,

Aashika Agarwal

[Former Member]

for vendor we can have tables bsik &  bsak  and

for GL  we have tables Bsis and bsas.

its possible  by abap development if functional possible by customizing can save abap development.

[Former Member]

hi..

it can be developed in ZReport with help of ABAPer it easy for him...

For vendor can be picked by posting key as vendor assigned to 31 or 29A  for advance payment using sp gl.

even expense wil can get but its depends upon the entry.

for ex:

31 vendor a/c

40 transportation expense alc

40 Service tax

40 service tax hcess

40 service tax ecess

50 Tds  .

abaper have to check for correct possibilities and develop accordingly.