topic Re: Re: Select Options in Application Development and Automation Discussions

Re: Select Options

Former Member — Thu, 05 Oct 2006 07:22:57 GMT

Hi All,

We have created two select option fields for Billing Documnet(VBRP-VBELN) and Billing document Item (VBRP-POSNR).

SELECT-OPTIONS : V_VBELN FOR VBRP-VBELN , "Billing Document Number

V_POSNR FOR VBRP-POSNR . "Billing Document Line Item Number

But when the report is run and if we use the search help option it is displaying the Sales document numbers instead of Billing document number in the list.

Is there anyway this situation can be resolved.

Help and Suggestion will be much appreciated.

Regards.

Ramesh.

Re: Re: Select Options

Former Member — Thu, 05 Oct 2006 07:24:57 GMT

Hi,

Check you have used VBELN Billing Documnet which is Sales Order number(VBRP-VBELN).

Cheers,

Prashanth

Re: Re: Select Options

Former Member — Thu, 05 Oct 2006 07:25:55 GMT

Hi,

VBELN is sales document number.

To get Billing document number you have to create search help in SE11.

Regards

Divakar

Re: Re: Select Options

Former Member — Thu, 05 Oct 2006 07:26:44 GMT

Because the check table of VBRP-VBELN is VBUK table and here you can find all SD documents so sales document too.

You have to manage an search help in the AT SELECTION-SCREEN ON VALUE-REQUEST event:

TABLES VBRP

SELECT-OPTIONS: SO_VBELN FOR VBRP-VBELN.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR SO_VBELN-LOW.

PERFORM CALL_SEARCH_HELP USING 'SO_VBELN-LOW'.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR SO_VBELN-HIGH.

PERFORM CALL_SEARCH_HELP USING 'SO_VBELN-HIGH'.

FORM CALL_SEARCH_HELP USING P_FIELD TYPE HELP_INFO-DYNPROFLD.

DATA: DYNPPROG TYPE SY-REPID,

DYNPNR TYPE SY-DYNNR.

DYNPPROG = SY-REPID.

DYNPNR = SY-DYNNR.

CALL FUNCTION 'F4IF_FIELD_VALUE_REQUEST'

EXPORTING

TABNAME = 'VBRP'

FIELDNAME = 'VBELN'

SEARCHHELP = 'VMCF'

DYNPPROG = DYNPPROG

DYNPNR = DYNPNR

DYNPROFIELD = P_FIELD

EXCEPTIONS

FIELD_NOT_FOUND = 1

NO_HELP_FOR_FIELD = 2

INCONSISTENT_HELP = 3

NO_VALUES_FOUND = 4

OTHERS = 5.

IF SY-SUBRC <> 0.

EXIT.

ENDIF.

ENDFORM. " CALL_SEARCH_HELP

You can try to use MATCHCODE OBJECT

SELECT-OPTIONS : V_VBELN FOR VBRP-VBELN MATCHCODE OBJECT VMCF.

but I don't remember from which release works correctly if there's the search help and not the matchcode

Max

Re: Re: Select Options

Former Member — Thu, 05 Oct 2006 07:27:15 GMT

Hi ramesh,

1. do like this

2. attach the required search help for billing document

SELECT-OPTIONS : V_VBELN FOR VBRP-VBELN MATCHCODE OBJECT VMCF.

regards,

amit m.

Re: Re: Select Options

Former Member — Thu, 05 Oct 2006 07:28:33 GMT

You have to use Search Help VMCF

Regards.

Jose.

Re: Re: Select Options

Former Member — Thu, 05 Oct 2006 07:31:42 GMT

Hi,

If you check this from SE11->VBRP->Table entries, f4 help on the item number displays the sales document number with the combination, this is something strange, to overcome this issue, you need to have your own search help created and attached as match code id in the program,

Hope this helps,

Rgds,

Re: Re: Select Options

Former Member — Thu, 05 Oct 2006 07:32:06 GMT

Hi Jose..

How did you come to know about this search help name?

Thanks

Re: Re: Select Options

Former Member — Thu, 05 Oct 2006 07:42:28 GMT

An simple way is to check in which view a table (in this case VBRK) is used and then in which search help that view is used as method.

Or you can check directly in which search help the table is used.

Max

Re: Re: Select Options

Former Member — Thu, 05 Oct 2006 08:45:17 GMT

Hi Max,

If we use " MATCHCODE OBJECT VMCF " in our coding we are getting the Billing document number but not the corresponding Items list for that particular Billing document selected.

But previously we use to get the Items list for that particular Billing document given in the field.

Actually our requirement is to get the corresponding Customer and the Item level list of the Billing document selected from the search list at each field.

i.e. if item is selected only the items for that particular Billing Document and in Customer field search help only the corresponding customer name n number.

Is that we have to specifcly define or use select statement to get those values for that particular Billing Document selected from the search help. Because if we use the search help for line item its again showing the Sales document list only

Thanks & Regards for ur Help and Suggestion.

Ramesh.

Re: Re: Select Options

Former Member — Thu, 05 Oct 2006 08:46:51 GMT

Hi Amit Mittal,

If we use " MATCHCODE OBJECT VMCF " in our coding we are getting the Billing document number but not the corresponding Items list for that particular Billing document selected.

But previously we use to get the Items list for that particular Billing document given in the field.

Actually our requirement is to get the corresponding Customer and the Item level list of the Billing document selected from the search list at each field.

i.e. if item is selected only the items for that particular Billing Document and in Customer field search help only the corresponding customer name n number.

Thanks & Regards for ur Help and Suggestion.

Ramesh.

Re: Re: Select Options

Former Member — Thu, 05 Oct 2006 08:49:34 GMT

Hi again,

1. For your requirement,

if some standard search help is not available,

2. then we have make our own search help,

which will also show the line items.

3. then we can attach it to our program code.

regards,

amit m.