cancel
Showing results for 
Search instead for 
Did you mean: 

Retail - Docket number / Margin price

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hello GK,

I could get Markup and Margin data from WKBP (Pricing item data), still looking for table to obtain docket counts.

Thanks for your time.

Former Member
0 Kudos

Hi,

If you want a Report for Billing Document Generated.

Then From VBRK table you can get the Billing Document Number (VBELN) ,KNUMV (document condition no.)

Then pass KNUMV to Table KONV and get the condition values from KSCHL Field.

Please give some inputs on "docket counts"?

Regards

GK.

Former Member
0 Kudos

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

Answers (0)