on 10-29-2010 6:00 AM
Hello folks,
I am trying to generate list output for POS data like daily billing qty , price , docket counts and margin price of article.
I amathering info from VBRP, but which table-field i can find markup/mark down price, margin price, docketnumbers??
Thanks.
Hi,
In KONV table you will find the value based on your Condition Types.
From VBRK table fetch the KNUMV value and pass it to KONV table to get the desired data
Regards
GK.
Edited by: Gnana Kumar on Oct 29, 2010 8:48 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello GK,
I am developg report to get daily sales qty/curr at COB.
select VBELN from VBRK into table it_vbrk where fktyp = 'W' and KALSM = 'ZPOS00' and fkdat = l_date.
if sy-subrc = 0.
select VBELN POSNR FKIMG FBUDA NETWR MATNR ARKTX MATKL WERKS
from VBRP into table it_vbrp
for all entries in it_vbrk
where vbeln = it_vbrk-vbeln and matkl in s_matkl and werks eq p_werks.
if sy-subrc = 0.
select MATKL MATNR WERKS AUFSG SPABR
from WKBP into table it_wkbp
for all entries in it_vbrp
where matkl eq it_vbrp-matkl and matnr eq it_vbrp-matnr.
I found Docket counts is the Billing item value from VBRP-POSNR based on VBELN.
Good day!
Thanks.
Edited by: uma maheswari on Nov 10, 2010 2:21 AM
Edited by: uma maheswari on Nov 10, 2010 2:22 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.