topic Re: Passing select-options values using call transaction method in Application Development and Automation Discussions

Passing select-options values using call transaction method

Former Member — Thu, 10 Jul 2008 04:11:53 GMT

Hi Experts,

I have a scenario in which i have three fields BUKRS,WERKS and MATKL in an internal table i_tab and I have MATNR as a selection-option.

After this I have to use call transaction <tcode> for all the line items in the internal table and the MATNR select-option values I have to pass directly for each line of i_tab using call transaction method.

TYPES: BEGIN OF t_tab,

bukrs TYPE bukrs,

werks TYPE werks_d,

matkl TYPE matkl,

END OF t_tab.

DATA: w_tab TYPE t_tab,

i_tab TYPE STANDARD TABLE OF t_tab.

SELECT-OPTIONS: s_matnr FOR marc-matnr.

Now I am putting a loop at i_tab and have to use CALL TRANSACTION <TCODE> for each line with the SELECT-OPTIONS for MATNR.

Please tell me whether we can pass multiple ranges for MATNR using call transcation method.

for example there can be multiple single values/multiple ranges/excluded ranges for MATNR. so please suggest me how tho achieve this sceanrio using CALL transaction method of BDC.

Thanks a lot.

Regards,

Krishan

Re: Passing select-options values using call transaction method

Former Member — Thu, 10 Jul 2008 04:25:18 GMT

Hi Krishan,

For the Call transaction TCODE there is extension ....OPTIONS from OPT. Just Check it out. I think it is possible like this.

... OPTIONS FROM opt 


*Effect* 
This addition gives you control using the values of the components of the structure opt, which must be of the Dictionary type CTU_PARAMS. The components have the following meaning: 

DISMODE
Processing mode (comparable with the MODE addition) 

UPDMODE
Update mode (comparable with the UPDATE addition) 

CATTMODE
CATT mode (controlling a CATT procedure) 


The CATT mode can have the following values: 

' ' No CATT procedure active 
'N' CATT procedure without single screen control 
'A' CATT procedure with single screen control 

DEFSIZE
Use standard window size 

RACOMMIT
COMMIT WORK does not end CATT procedure 

NOBINPT
No batch input mode, that s SY-BINPT = SPACE. 

NOBIEND
No batch input mode after BDC data has been read 

The components DEFSIZE , RACOMMIT, NOBINPT, NOBIEND always take the following values: 
'X' Yes 
' ' No 

If the OPTIONS addition is omitted, the following settings are valid for the control parameters: 

DISMODE from the MODE addition 

UPDMODE
from the UPDATE addition 

CATTMODE
No CATT procedure active 

DEFSIZE
Do not use standard window size 

RACOMMIT
COMMIT WORK ends procedure successfully 

NOBINPT

Batch input mode, that is SY-BINPT =X. 

NOBIEND
Batch input mode also active after BDC data has been read

Regards,

Swapna.

Re: Passing select-options values using call transaction method

Former Member — Thu, 10 Jul 2008 04:35:32 GMT

hi,

i think you are using the z transaction i mean the screens are developed by you .

as you are getting the data from the flat file

and it is stored in internal table.

now filter the fields of internal table using the select-option.

that is filter all the three fields such that those fields must satisfy the select-option criteria.

after that put those data only in other internal table.

then upload the data using:

loop

perform bdcdata.(logic to fill bdcdata)

call transaction .

endloop.

i think it will work fine.

reward me if it is useful.

thanks

Re: Passing select-options values using call transaction method

Former Member — Fri, 11 Jul 2008 16:40:31 GMT

Hi AM,

Thanks for useful answers.

I m facing a new problem while passing values of select-options S_MATNR..while using multple selection (Arrow button after S_matnr

see the explanation:

I have to pass value of a selection option MATNR to a transaction using BDC.

please see the code i m using

tables: marc.

select-options: s_matnr for marc-matnr.

When I m running my progarm and If I m putting multiple values in the matnr ,

the values i m getting on the tcode screen are the value of the last s_matnr-low.

Please tell me how to use s_matnr in the code

How to differentiate s_matnr-low so that my values are not overwritten

Is there any index values which are being used with s_matnr-low(index)

Please help me.

Thnaks

Krishan

Edited by: Krishan Kumar on Jul 12, 2008 3:05 PM