Skip to Content
author's profile photo Former Member
Former Member

Inward material report with PO including tax code

Hi Experts,

i need a report in respect to inward materials receiving with PO, bill and tax code.

we have all these thing in standard MB51 with variant but tax code is missing in this variant.

please help us to over come this problem

Thanks in Advance

INDO FARM

MB51.JPG (85.6 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 27, 2012 at 10:39 AM

    Hi,

    The reason why Tax Code is not present in MB51 report is because tax codes are not carried while posting the material document of the GR from the PO. It is only carried during the accounting document generation of the PO.

    So there really isn't a report to fetch the contents what you require in a single report.

    So, you really need to create a customized report for fetch these details in a single document which shouldn't be a difficult task as you can fetch all these details in the following tables:

    BKPF

    BSEG

    MSEG

    /Manoj

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 27, 2012 at 11:32 AM

    Hi,

    In standard MB51 report, tax code is not there because tax code is not allowed for 101 mvt type.You can go for an Enhancement. Add 'Tax Code' field in standard MB51 report with an abap development.

    Now, for populating tax code in that field,

    You get PO and PO line item number in MSEG table for material document. Pass this PO and PO line item number to EKPO table and pick tax code. Display this tax code into the new added tax code field in the MB51 report for respective material documents.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 27, 2012 at 11:41 AM

    Hi,

    Standard report not available, But can archive this through Query report ,

    using table WB2_V_MKPF_MSEG2, and J_1IEXCDTL.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 29, 2012 at 09:31 AM

    Hi,

    You can check following standard report with t.codes:

    1. J2I9

    2. J1I2

    But you can check and customize your own report using report with t.code:MIR5 and rename with a t.code Z**** with adding tax details from table:BSET where your new report have purchase order number with line items, material number ,tax components details with GR document and IR document details.

    Refer link for similar type for your quick reference:

    http://scn.sap.com/message/10378221

    Regards,

    Biju K

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.