on 05-12-2009 11:33 PM
Hi All,
We want to know the Database Field for Picked quantity in a delivery. We checked the help for the field and it points to the LIPSD structure and the field PIKMG. However I could not find it in LIPS table or any other table. Could somebody please help me locate this field in the database ?
Thanks,
Amit
Hi Amit,
LGMNG in LIPS represents the picked quantity (Actual quantity Delivered).
Regards,
Sai
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Amit,
Its stored in document flow VBFA for your delivery number. VBTYP Q. RFMNG is the picked quantity.
Cheers,
John
Hi, This is late response i know, but maybe someone else is looking for same and needs code for same. Please keep in mind that you also need to check if users have done LT0G return from GI are back to picking bin. In this case you need minus the TO from total picking qty.
ABAP routine:
form LIPS_PICKED using LS_LIPS type LIPS.
data: LT_VBFA type table of VBFA,
LS_VBFA type VBFA,
LS_LTAP type LTAP.
select * from VBFA into table LT_VBFA "Fetch to data from doc flow and count picked
where VBELV = LS_LIPS-VBELN
and POSNV = LS_LIPS-POSNR
and VBTYP_N = 'Q'.
clear LS_LIPS-LFIMG.
loop at LT_VBFA into LS_VBFA.
select single * from LTAP into LS_LTAP
where LGNUM = GS_SCREEN_100-LGNUM
and TANUM = LS_VBFA-VBELN
and TAPOS = LS_VBFA-POSNN
and PQUIT = 'X'. "Picked!
if SY-SUBRC = 0.
if ls_ltap-vltyp = '916'. "Source is GI area => LT0g done, it is minus!
LS_LIPS-LFIMG = LS_LIPS-LFIMG - LS_LTAP-VISTA.
ELSE.
LS_LIPS-LFIMG = LS_LIPS-LFIMG + LS_LTAP-VISTA.
endif.
endif.
endloop.
endform. "lips_picked
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear John,
You have given a technically right answer. Congrats!!
But this forum is not a place for you to show your temper. Request the moderator to block abusive messages like this .
Murali
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This is not abusive. Some people are quite clearly abusing this forum by giving completely wrong anwers. I work with a lot of people who use this forum and they continuously to me with clearly wrong answers. This is creating a big problem for my organisation.
If you dont know anwer 100% then please dont offer it to everyone. If you are unsure about and answer qualify it. Dont just simply put it on the forum stating it is true and fact when it is not.
Some people are just trying to randomly answer questions to gain points.
Hi ,
Picked quantity filed is structure LIPSD:PIKMG .It is a structure field and not used in any tables .You can check the same by going in to SE11 -Enter the structure name as LIPSD--Then click on field PIKMG -Click on where else used-Select Table fields .
Hope it helps.
Regards,
Pasapula.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pasapula,
Are you really that stupid? Stop giving rubbish answers. What are you trying to do, gain rew ard points? Because you are just confusing things.
Who cares what the structure field is called? The question is what database table/field is the pick quantity is and I have provided the answer to this.
How can you seriously suggest this is only a sturcture field and the entry value is not stored anywere? When you save an pick quantity in a delivery and then display the document afterwards and the quantity is still there, so you thing it reappears by magic? Or maybe perhaps it is reading it from the database even quite possibly from the table/field I have specfied!!!
Please stop answering with your rubbish answers.
John
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.