cancel
Showing results for 
Search instead for 
Did you mean: 

Report on Sales Tax charged by vendors

Former Member
0 Kudos

Hello Friends,


How to create report to extract the amount of sales tax charged by vendors? The vendor invoice management is inserting tax to the tax amount field (Vendor charged Tax Amount).


Any advise to simple way to generate report.


Thanks,

Kishor

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Kishore,

The following logic can be put in place to fetch the required data.

Can create FS using below logic, assign a developer and he would take care of the rest.

Tables needed in the program -> BKPF,BSET,BSEG,BSAK(Reversed invoice details),BSIP,LFA1 for vendor details, You also can use J_1IMOVEND table to get the service tax registration number.

Selection-screen parameters:

Company Code:

Posting    Date:<Mandatory>

Tax         Code:

Data fetch sequence:

1. Get BELNR(Accounting Document number) and BUKRS(Company code) and GJAHR(Fiscal Year) from the table BKPF(Accounting Document Header Table) based on the input provided on the selection screen which is (Company code and Posting Date).

2. Get Tax related details like MWSKZ(Tax on sales/purchases code), HKONT ( Tax G/L Account), HWBAS(Tax Base Amount in local currency), HWSTE(Tax amount in local currency) and any other required fields as per your requirement from the table BSET(Tax Data Document Segement) table "For all the entries in the BKPF table".

- Consider BSET as the base table to get the additional data such as BSIP,BSAK,BSEG,LFA1,J_1IMOVEND tables data.

3. Combine all the data based upon the business logic to get your desired output which is "report to extract the amount of sales tax charged by vendors".

--

With Regards,

Anirudh Vishwamithra.

Former Member
0 Kudos

Hi Anirudh,

Appreciated all detailed information and would like to have offline discussion. Once the solution is comes up, i want to post here with step-by-step instruction to create report. May be other people especially Tax team looking for such kind of reports.

< contact informations removed by moderator, make it visible in your profile´>.

Thanks,

Kishor

Message was edited by: Jürgen L

Answers (3)

Answers (3)

jagdeepsingh83
Active Contributor
0 Kudos

You can look in making query SQVI or follow the path of SQ01, SQ02, SQ03.. You can join the different table involved. to start with Look into RBKP and RSEG.

Former Member
0 Kudos

Check the report J_1IST3 report.

Former Member
0 Kudos

Thanks Ram and Mallinath. Those are good report but i learn the requirement and looking below fields/data in report.

1. Company code,

2. Date,

3. Invoice Document Number,

4. Vendor Number and Name,

5. Total Invoice Amount,

6. Total sales tax,

7. GL Account Number,

8. Cost Center/Plant

Is there way to extract data from SAP tables or back-end (database)? Appreciate your help.

Thanks,

Kishor

former_member192540
Discoverer
0 Kudos

Hi Kishore,

It is possible through ABAP program, I think with using query you will not fetch the records through posting date. Create FS and get assigned developer so that they can help you....

By using table BKPF, BSET and BSEG

Regards,

Bharath

Former Member
0 Kudos

Hi kishor ,

you can check in FBL1N  with tax amount or

Should develop  a programme  based on you requirement for particular tax type with your abaper