How to find Delivery Qty

[Former Member]

Hi Gurus,

I want to find the Delivered Quantity i.e Displayed in Schedule lines per item ,i.e tcode va02->Click on any material no and then select tabe schdule lines.

There is one FM named as 'RV_SCHEDULE_CHECK_DELIVERIES'' how i use that FM to retrieve the values. This FM uses vbeln and posnr as import parameters but when i pass it it doesn't show me the corrrect output.

Any suggestions welcome.

Thanks

[Former Member]

Hi Singh,

I am not expert abaper but this seems to be right for me, Pls look at this.

types : begin of ty_out ,

vbeln like vbap-vbeln,

posnr like vbap-posnr,

matnr like vbap-matnr,

lfimg like lips-lfimg,

meins like lips-meins,

end of ty_out.

data : it_out type standard table of ty_out,

wa_out type ty_out.

select VBAP_{VBELN VBAP}POSNR VBAP~MATNR

LIPS_{LFIMG LIPS}MEINS

INTO TABLE IT_OUT

FROM

VBAP INNER JOIN

LIPS ON

VBAP_{VBELN = LIPS}VGBEL AND

VBAP_{POSNR = LIPS}VGPOS

up to 10 rows.

IF SY-SUBRC = 0.

LOOP AT IT_OUT INTO WA_OUT.

WRITE : / WA_OUT-MATNR, WA_OUT-LFIMG, WA_OUT-MEINS.

ENDLOOP.

endif.

Award me with points.

regards

madhu

[Former Member]

Hi,

The scheduled quantity which shows in sales order is generally sit in structure and not show in any of the table, as per my solution why you want to go to FM and all, can go to LIPS-VGBEL, LIPS-VGPOS based on VBAP-VBEL, VBAP-POSNR and check the delivery qty. or if require the PGI qty den check the status through VBUK-GBSTK=C.

Rewards if helps

Rgds

Gautam

[Former Member]

Thanks , As i already tested it with the VBAK-VBELN and POSNR but no fruitful,you have some code and give me some more clear idea please.

Thanks

[Former Member]

Hi,

I dont have present, as i explained previous just explore the logic and give to the Technical consultant. I iwll give some info

based on VBAP-VBELN & VBAP-POSNR goto table LIPS as VGBEL & VGPOS and pick all the values line VBELN,POSNR,MATNR, LFIMG, MEINS and the same way just explore the logic, if you want to check weather PGI is happend or not can check through LIPS,

Rgds

GAUTAM

Rgds

GAUTAM

[Former Member]

Hi All ,

Thanks for your responses just see the code below for the correct techincal answer .

Data:

lT_VBFA type VBFA occurs 0 with header line,

lT_VBUP type VBUP occurs 0 with header line,

lT_VBEP type VBEPVB occurs 0 with header line,

lT_VBAP type VBAPVB occurs 0 with header line,

l_vsmng like vbepvb-vsmng.

DATA: lv_vbeln TYPE vbak-vbeln,

my_posnr TYPE vbap-posnr.

SELECT * FROM vbup INTO TABLE lt_vbup

WHERE vbeln EQ lv_vbeln AND

posnr EQ my_posnr.

SELECT * FROM vbfa INTO TABLE lt_vbfa

WHERE vbelv EQ lv_vbeln AND

posnv EQ my_posnr.

SELECT * FROM vbep INTO TABLE lt_vbep

WHERE vbeln EQ lv_vbeln AND

posnr EQ my_posnr .

SELECT * FROM vbap INTO TABLE lt_vbap

WHERE vbeln EQ lv_vbeln AND

posnr EQ my_posnr .

call function 'RV_SCHEDULE_CHECK_DELIVERIES'

exporting

fbeleg = lv_vbeln

fposnr = my_posnr

tables

fvbfa = lt_vbfa

fvbup = lt_vbup

fxvbep = lt_vbep

fvbap = lt_vbap.

if lt_vbep-vsmng > 0 .

write: lt_vbep-vsmng. " tot.deliv.quan

endif.

Thanks

Navdeep singh