Skip to Content
avatar image
Former Member

Report on Sales Tax charged by vendors

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 04, 2015 at 06:52 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • avatar image
    Former Member
    Nov 03, 2015 at 08:07 AM

    Check the report J_1IST3 report.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • avatar image
    Former Member
    Nov 03, 2015 at 06:31 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 03, 2015 at 04:24 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded