Material price report only for one item category

[venu_ch8]

Dear sd experts

may i know this si possible by abap query report?

my business want to know the price list based on only perticuler item category

ex: with ZTAN Item cat we have created so many materials

now they want to know the price list only againest ZTAN Item category

could you share your knowledge it is posible by ABAP Query ?

Thanks a lot

[former_member182378]

venu,

Generally, from customer the price list flows to the header and all the line items in a sales order. Please check in some orders, if indeed the PLTYP is different at header and item level (item category with ZTAN).

If possible, ask the business, during creation of order, do they change the PLTYP at item level, when the item category is ZTAN? or is there any logic in a userexit to this?

TW

[former_member182378]

venu,

As you know,

1. In VBAP, give item category PSTYV = ZTAN, get the document nos. and item nos. (VBELN, POSNR)

2. In VBKD, give document no and item no. and find price list (PLTYP)

In the selection screen date could be made mandatory, or else it will load the system to search for all the document nos. with PSTYV = ZTAN.

TW

[siva_vasireddy2]

Hi,

item category is only visible in the transaction Data so you can take logical Data Base-VAV  and generate a report by yourself under-SQVI

VAV contains the Pricing data which is flown in transactions