on 06-20-2012 2:35 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.