on 11-02-2015 7:19 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Check the report J_1IST3 report.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.