about "Pick quantity".

[Former Member]

t-code:vl03n -> Goto Item -> Picking -> Pick quantity

how can i find its Field name in related Transparent table. thanks alot !

[Simha_]

Hi amao,

Ur Functional Consultant can help u in this matter.

Even if u want to know that field in the table.

Go to its data element and see where-used in tables..

U can able to pick up the table u want..

Cheers,

Simha.

[Former Member]

Hi Amao,

The following link wil help you in finding any table field name used in transaction.

Thanks,

Vinay

[Former Member]

Hai Amao

there place the cursor on Pick Quantity press F1 and F9

Field Name 'PIKMG' double click on this field and place the cursor on it

then choose Where used List

and select Database Tables

That will solved your problem

Thanks & regards

Sreenivasulu P

[Former Member]

Hi,

LIPMG is not assigned to any transparent table, since this is quantity field which will be filled dynamically.

If found useful, please award points.

Thanks,

Bharadwaj

[Former Member]

i can only find :

<b>Struct</b> LIPSD

Field name PIKMG

Data element PIKMG

but i want to know which <b>Transparent</b> table contains this information .

any body knows a universal way to solved this problem?

thanks!

by the way, i've tried using 'sto5'. but i don't know how to find it.lol

[Simha_]

Hi,

Use the ST05 transaction.

click on the trace on.

then goto ur transaction and do the steps u normally do.

After that Off the trace.

and then display the trace.

There u can able to see many fields and their tables.

Now u search for ur field and which table it is getting updated.

May be the same dataelement will be as other name also.

Just check patiently...

Cheers,

Simha.

[Former Member]

when u get the field PIKMG , try F1 help on that field and check out the Technical info if u can find out that table

[Former Member]

haha.i find it by using 'st05'.

thanks!

[Former Member]

Hai Amao

vbapf-qmenge is equals to your PIKMG Field

Thanks & regards

Sreenivasulu P

[Former Member]

Pick qty is stored in VBFA table. You can retrieve it as follows by linking LIPS with VBFA.

SELECT A_{VBELN A}POSNR A_{MATNR A}CHARG A~LFIMG

A_{MEINS A}VRKME A_{UMVKZ A}UMVKN A~UECHA

B_{POSNN B}RFMNG

INTO CORRESPONDING FIELDS OF TABLE I_PICKREC

FROM LIPS AS A

LEFT OUTER JOIN VBFA AS B ON A_{VBELN = B}VBELV AND

A_{POSNR = B}POSNV

WHERE A~VBELN = Input-VBELN

AND A~POSNR = Input-POSNR.

The pick qty is stored in base uom in this table. You may need to convert it to sales uom.

[Former Member]

hi bala.

your reply is very helpful.

but why you use "LEFT OUT JOIN " not "INNER JOIN"?

can you tell me .

[Former Member]

At a given point in time, not all items are picked. For analysis, I want to build an internal table with all the entries from LIPS table whether it is picked or not. If picked, pick qty is populated from the VBFA table.

Very glad, I am able to help you on this.

Regards

-Bala Pattabiraman

[Former Member]

HI,

I KNOW TOO LATE BUT EKBE-MENGE MIGHT SOLVE THE SAME PURPOSE.

rGDS,

aNUPMA cHANDRA.

[Former Member]

you can use this function.

XVBELN = NAST-OBJKY.

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.

*Picked Qty. = TVBLKP-LGMNG - TVBLKP-KOMNG

[Former Member]

the function module 'RV_DELIVERY_PICK_VIEW' was very very useful and all u need to do for conversion is

Picked Qty =( TVBLKP-LGMNG - TVBLKP-KOMNG ) * lips-umvkn / lips-umvkz