topic Re: how to use offset for select-option parameter ? in Application Development and Automation Discussions

how to use offset for select-option parameter ?

satish_kumar127 — Tue, 13 May 2014 10:09:53 GMT

Hi experts

could anybody please let me know how to use offset for select-option parameter. i can able to use offset for table fields, variabiles and all , but don't know how to use for parameters.

following is my code

SELECT-OPTIONS: s_prctr FOR vbsegs-prctr OBLIGATORY.

here "prctr" length is 10.

i'm using two tables 1. vbsegd-bupla

2. vbsegs-prctr

here prctr+6(4) = bupla.

"Bupla" length is 4

SELECT belnr gjahr bukrs bupla sgtxt buzei FROM vbsegd INTO CORRESPONDING FIELDS OF TABLE it_vbsegd FOR ALL ENTRIES IN it_vbkpf

WHERE belnr = it_vbkpf-belnr

AND gjahr = it_vbkpf-gjahr

AND bukrs = it_vbkpf-bukrs

AND bupla IN s_prctr.

the above statement is not working as prctr and bupla lenths are different. here i want to use offset.

SELECT belnr gjahr bukrs prctr sgtxt buzei FROM vbsegs INTO CORRESPONDING FIELDS OF TABLE it_vbsegs FOR ALL ENTRIES IN it_vbkpf

WHERE belnr = it_vbkpf-belnr

AND gjahr = it_vbkpf-gjahr

AND bukrs = it_vbkpf-bukrs

AND prctr IN s_prctr.

this is working as prctr and s_prctr lengths are equal.

could anybody please help me out in this.

Thanks in advance.

regards

satish

Re: how to use offset for select-option parameter ?

Former Member — Tue, 13 May 2014 10:24:04 GMT

Hi Satish,

You can write following logic:

1. Define new range table r_itab of BUPLA type.

2. If S_PRCTR-high is initial then go to step-3 else go to step-4

3. Loop on S_PRCTR and then offset the PRCTR value, further append it to range table r_itab(fiel-Low)

4. Append S_PRCTR-low, S_PRCTR-high value into range table-low,high value after offsetting the value

3. Further use the range table r_itab in Select query.

Regards,

Sudeesh Soni

Re: how to use offset for select-option parameter ?

Former Member — Tue, 13 May 2014 10:27:41 GMT

Below code will work for you.

SELECT-OPTIONS: s_prctr FOR vbsegs-prctr OBLIGATORY.

RANGES: s_bupla FOR vbsegd-bupla.

s_bupla[] = s_prctr[].

DELETE ADJACENT DUPLICATES FROM s_bupla.

SELECT belnr gjahr bukrs bupla sgtxt buzei FROM vbsegd INTO CORRESPONDING FIELDS OF TABLE it_vbsegd FOR ALL ENTRIES IN it_vbkpf

WHERE belnr = it_vbkpf-belnr

AND gjahr = it_vbkpf-gjahr

AND bukrs = it_vbkpf-bukrs

AND bupla IN s_bupla.

Re: how to use offset for select-option parameter ?

satish_kumar127 — Tue, 13 May 2014 10:44:07 GMT

Hi Digesh,

Thank you for your valuable time . my issue has been resolved with your helpful reply.

Thanks a lot again.

regards

satish

Re: how to use offset for select-option parameter ?

satish_kumar127 — Tue, 13 May 2014 11:23:23 GMT

Hi sudeesh,

Thanks for your kt. your post was helped me to resolve my issue.

Thanks for the prompt reply.

Regards

satish

Re: how to use offset for select-option parameter ?

Former Member — Tue, 13 May 2014 11:33:33 GMT

Instead of s_bupla[] = s_prctr[].

Use below logic.

LOOP AT s_prctr.

s_bupla-sign = s_prctr-sign.

s_bupla-option = s_prctr-option.

s_bupla-low = s_prctr-low+6(4).

s_bupla-high = s_prctr-high+6(4).

APPEND s_bupla.

ENDLOOP.