12-14-2006 8:08 AM
hi guys,
can any one tell me in which table, Material price details are stored.
thank you and waiting for ur reply
pavan
12-14-2006 8:19 AM
12-14-2006 8:19 AM
12-14-2006 8:27 AM
Hi Pavan,
i use this to show the Materialprices (Kondition).
SELECT-OPTIONS: S_MATNR FOR A004-MATNR.
SELECT * FROM A004 WHERE KAPPL = 'V'
AND KSCHL = 'ZR00'
AND VKORG = '1000'
AND VTWEG = '01'
AND MATNR IN S_MATNR.
SELECT SINGLE * FROM KONH WHERE KNUMH = A004-KNUMH.
SELECT SINGLE * FROM KONP WHERE KNUMH = A004-KNUMH.
Our Prices are only Materia-dependet.
Perhaps you have to use A005 or A006 instead of A004. But the logic is the same.
Hope it helps.
Regards, Dieter
12-14-2006 8:28 AM