cancel
Showing results for 
Search instead for 
Did you mean: 

Finding Sales Order Number from Handling Unit

Former Member
0 Kudos

Hi Gurus,

I have to provide search query to my ABAP developer for finding sales order number from handling unit number. We have RF transaction which will scan any existing HU and display associated sales order. I check in HUMO that under tab "Const" we have Special Stock Number" this number is made up of 16 digits(numeric) which basically represent sales order number (first 10 digits) and sales order item number (last 6 digits). I can get that special stock number value from field LSONR in table HUMV4. Now my probelm starts that how can I tell ABAP developer to use this special stock number (16 digits) to search for sales order number (10 digits) - field VBELN in table VBAK.

I tried to look for HUMV4 but system said its not table its structure so now please tell me how can I get special stock number from HU number by field & table reference??

Please provide help as after finding sales order I have to provide him lot of other queries to find other sales order data. Your quick response will be very helpful.

Thanks

Jess

Accepted Solutions (1)

Accepted Solutions (1)

former_member211462
Active Participant
0 Kudos

Dear Jessica Alison

                             If you have your HU's number you could surely find out the delivery number or even the material document number , by the help of VBFA you could surely get the sales order number

HUMV4 is a structure , if you could explore table HUINV_ITEM you could get your special stock number and indicator also instead of trying in HUMV4 . You could get the material document number from this table . Even try table HUINV_HDR.

Regards

JNM

Former Member
0 Kudos

Can try VEPO or VEKP to get the delivery number and from this number thru VBFA can locate sales order numbers.

Thanks

Rajesh

Answers (1)

Answers (1)

former_member184701
Active Contributor
0 Kudos

Jess, look at table VEPO

the 'bridge' is your delivery number VEPO-VBELN

(and pick up sales order via VBFA where VBFA-VBELV is your delivery, VBFA-VBTYP_N = 'Q' (or 'C' -please check out your self) and VBFA-VBELN is your order

regards,