Inward material report with PO including tax code

[Former Member]

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

[BijayKumarBarik]

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

[Former Member]

Hi,

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

using table WB2_V_MKPF_MSEG2, and J_1IEXCDTL.

[former_member187965]

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.

[Former Member]

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