Select Options

[Former Member]

Hi All,

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

<b>

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

V_POSNR FOR VBRP-POSNR . "Billing Document Line Item Number</b>

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.

[Former Member]

Hi,

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

Cheers,

Prashanth

[Former Member]

Hi,

VBELN is sales document number.

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

Regards

Divakar

[Former Member]

Hi

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

[Former Member]

Hi ramesh,

1. do like this

2. attach the required search help for billing document

3.

SELECT-OPTIONS : V_VBELN FOR VBRP-VBELN <b>MATCHCODE OBJECT VMCF.</b>

regards,

amit m.

[Former Member]

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.

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.

[Former Member]

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.

[Former Member]

You have to use Search Help VMCF

Regards.

Jose.

[Former Member]

Hi Jose..

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

Thanks

[Former Member]

Hi

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

[Former Member]

Hi Max,

If we use " <b>MATCHCODE OBJECT VMCF</b> " 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.

[Former Member]

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,