PO report by Vendor Type(LV, FM etc...)

[Former Member]

Hi All,

I am looking for PO report having Vendor Type in selection criteria

Thanks

[former_member280154 · Accepted solution]

Farooq,

By vendor type do you mean vendor account group?

There is no standard report for this...you can create an SQVI query by joing EKKO and LFA1 tables.

Thank you.

[Former Member]

Thanks every body, I got it. I am sorry it is supplement  field to indicate that the vendor is

  Local manufacturer

  Local supplier

  Foreign manufacturer

  Foreign Supplier etc.

[BijayKumarBarik]

Hi,

The above four types of vendors are  represents by vendor account groups but PO's report by vendor account group is not available by standard- you can go for development for your report on PO's based on vendor account group.

Regards,

Biju K

[JL23]

You are probably talking about the vendor type in the CIN specific data on the Excise Duty tab.

I have not seen any PO reporting on that field, but I am not familiar with CIN version.

The value is stored in table J_1IMOVEND field J_1IVTYP

[former_member197616]

Hi, What do you mean by type of the vendor LV FM ? Vendor by account group or vendor by the partner function ? normally all reports for the PO function on the basis of the PO vendor only . there are no standard vendors . Regards