topic Re: Delivery Pick Quantity in Application Development and Automation Discussions

Delivery Pick Quantity

Former Member — Sat, 10 Mar 2007 00:38:34 GMT

Hi All,

Can anyone please tell me from which table I can get the pick quantity for a delivery?

In a delivery, under picking tab we have the field pick quantity ( it refers to LIPSD-PIKMG).

Please help me with this?

Thanks

Vinod

Re: Delivery Pick Quantity

Former Member — Sat, 10 Mar 2007 01:13:42 GMT

Hi,

Check the table VBFA-RFMNG..

Give the delivery number in VBELV - delivery number

VBTYP_N = Q

Thanks,

Naren

Re: Delivery Pick Quantity

Former Member — Sat, 10 Mar 2007 01:27:56 GMT

Actually SAP in VL0xN transactions does not store pick quantity PIKMG in database, this is because it is a calculated value.

One straight way you can calculate a pick quantity that will always agree with what is shown in VL03N is to use the below FM

CALL FUNCTION 'RV_DELIVERY_PICK_VIEW'
EXPORTING
VBELN = XVBELN
ZWECK = 'A'
SPRAS = NAST-SPRAS
IMPORTING
VBLKK_WA = VBLKK
TABLES
VBLKP_TAB = TVBLKP
EXCEPTIONS
OTHERS = 1.

Here XVBELN = delivery number, SPRAS = 'E'

Picked Qty. =

TVBLKP-LGMNG - TVBLKP-KOMNG

Actual quantity delivered - Quantity to be picked

Re: Delivery Pick Quantity

Former Member — Sat, 10 Mar 2007 05:12:34 GMT

HI, Vishnu

I try it by your method of using 'RV_DELIVERY_PICK_VIEW' in ECC.

But the VBLKP_TAB is space?

Re: Delivery Pick Quantity

Former Member — Sat, 10 Mar 2007 09:59:23 GMT

Pick quantity is never maintained for the items in the delivery.In sap delivery tables this value is not stored .

When u see this in the tcode it is holding in a structure in Vl03n or vl02n.

The pick quantity is assumed to be < or = deliver quantity .

So u need to refer to LIPS-LFIMG for the pick quantity .

regards,

vijay

Re: Delivery Pick Quantity

Former Member — Mon, 12 Mar 2007 00:38:39 GMT

Hi Vishnu,

I tried using the FM.

But the table VBLKP_TAB is empty.

Can you please suggest if I am missing anything?

Thanks

Sandeep