Delivery Pick Quantity

[Former Member]

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

[Former Member]

Hi,

Check the table VBFA-RFMNG..

Give the delivery number in VBELV - delivery number

VBTYP_N = Q

Thanks,

Naren

[Former Member]

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

[Former Member]

HI, Vishnu

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

But the VBLKP_TAB is space?

[Former Member]

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

[Former Member]

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