on 07-03-2015 7:26 AM
Hi All,
I want to get all the serial/equipment number associated with a billing doc number.
Could you please help me?
rgds,
Rathinakumar
Hi If you can pass Billing number into VBRP fetch reference Delivery number.....Pass Delivery number into LIEF_NR field of SER01 table fetch OKBNR....... PASS OKBNR into OBJK table fetch EQUNR(equipment number). you can this logic to get equipment number specific to billing number.
Hope this helps...
Regards,
Surendra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Surendra,
below is my code. here, i am getting only one equipment number. But in table objk, it has 2 records. is my code correct?
select single vbelv posnv from vbfa into (lv_vbelv, lv_posnv )
where vbtyp_v = 'J'
and vbeln = i_bill_itm-vbeln
AND posnn = i_bill_itm-posnr.
if sy-subrc = 0.
SELECT SINGLE obknr FROM ser01 into l_obknr
WHERE lief_nr = lv_vbelv
And posnr = lv_posnv.
if sy-subrc = 0.
SELECT SINGLE equnr FROM objk into i_bill_itm-zzequnr
WHERE obknr = l_obknr.
ENDIF.
endif.
rgds,
Rathinakumar
User | Count |
---|---|
91 | |
11 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.