topic Two field value in a single parameter statement in Application Development and Automation Discussions

Two field value in a single parameter statement

Former Member — Thu, 09 Aug 2007 11:58:47 GMT

Hi all,

am using the below statement and selecting the document number that i need over a range of document numbers.

PARAMETERS:BELNR1 LIKE BSID-BELNR OBLIGATORY.

I have an issue here i also want the display of documents numbers(BELNR) of BSAD table and am not supposed to use one more parameters statement.So in the display i want document numbers of both the table BSAD & BSID..Please help

With Regards

Vijay

Re: Two field value in a single parameter statement

Former Member — Thu, 09 Aug 2007 12:05:07 GMT

Hi Vijay

use two parameter statements.

PARAMETERS:BELNR1 LIKE BSID-BELNR OBLIGATORY.

PARAMETERS:BELNR LIKE BSAD-BELNR OBLIGATORY.

R U GETTING ANY ERROR?

Message was edited by:

KIRAN KUMAR

Re: Two field value in a single parameter statement

Former Member — Thu, 09 Aug 2007 12:09:42 GMT

Hi Kiran

If thats the case i will get two separate fields in the output which i dont want.i want all the documents numbers to be from the same field

with regards

vijy

Re: Two field value in a single parameter statement

Former Member — Thu, 09 Aug 2007 12:23:50 GMT

in that case create internal table with one field belnr,

and pass the values between belnr and belnr1

revert back if u have doubts if i am wrong clearly explain what exactly do u want

reward points to all helpful answers

kiran.M

Re: Two field value in a single parameter statement

Former Member — Thu, 09 Aug 2007 12:59:16 GMT

Hello vijay,

You can get belnr common to BSAD & BSID through the following process

summary: Create a database view...and assign the view in Selection method for a search help and write the code

PARAMETERS BELNR1 TYPE BELNR_D MATCHCODE OBJECT searchhelp name.

Explanation :::Please do the following

**********************************************

se11 -> create a view 'ZBELNR' -> Database view -> enter text

in the TAB Table/join conditions

in tables write

BSAD

BSID

in join /Table conditions

BSAD MANDT = BSID MANDT

BSAD BELNR = BSID BELNR

****so the common Belnr will get selected

in the tab view fields

enter the field name you want to see on search help being clicked

save and activate

create a search help in se11 -> elementary help -> Zsearchhelp

in tab definition -> selection method enter the name of the view created ZBELNR

in the search help parameter..enter the name of the fields which are there in the "view fields" of the the database projection which you have created,ie fields which needs to come on search help(some people add text also with search help)

once the object is created use the following code

PARAMETERS BELNR1 TYPE BELNR_D MATCHCODE OBJECT Zsearchhelp (searchhelp name).

Hope it proved useful(i have tried out myself sucessfully),

Reward if useful

Regards

Byju

Re: Two field value in a single parameter statement

Former Member — Fri, 10 Aug 2007 10:31:11 GMT

Hi , u can use only one parameter statement if u need to input only one value that is applicable to field belnr of both tables .

Because belnr field is same in both bsad and bsid so u can use only on parameter to feed value belnt to both tables .

Ex:

parameter a type belnr_d .

belnr_d is a data element iused for belnr field in both tables .Then u can use ur select statement accordingly .

select --- from bsad into table itab where belnr = a .

Regards