topic Re: Possible entries, unique in Application Development and Automation Discussions

Possible entries, unique

Former Member — Tue, 02 Jan 2007 17:19:24 GMT

how to give possible entries to particular fields

and also how to make the field unique.

thanks in advance.

Re: Possible entries, unique

Former Member — Tue, 02 Jan 2007 17:20:57 GMT

Hi,

Check the example..For adding F4 help..

TABLES: T005T.

DATA: BEGIN OF t_t005 OCCURS 0,

land1 TYPE t005-land1,

END OF t_t005.

SELECTION-SCREEN BEGIN OF LINE.

SELECTION-SCREEN COMMENT 1(6) v_text FOR FIELD P_LAND1.

PARAMETERS: p_land1 TYPE t005-land1.

SELECTION-SCREEN COMMENT 13(35) v_text1.

SELECTION-SCREEN END OF LINE.

INITIALIZATION.

v_text = 'Country'.

v_text1 = ' '.

AT SELECTION-SCREEN OUTPUT.

IF NOT p_land1 IS INITIAL.

SELECT SINGLE * FROM t005t

WHERE spras = sy-langu

AND land1 = p_land1.

IF sy-subrc = 0.

v_text1 = t005t-landx.

ENDIF.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_land1.

REFRESH: t_t005.

SELECT land1

INTO TABLE t_t005

FROM t005.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

DDIC_STRUCTURE = 'T005'

PVALKEY = ' '

retfield = 'LAND1'

dynpprog = sy-repid

DYNPNR = sy-dynnr

dynprofield = 'P_LAND1'

callback_program = sy-repid

value_org = 'S'

TABLES

value_tab = t_t005

EXCEPTIONS

parameter_error = 1

no_values_found = 2

OTHERS = 3.

IF sy-subrc <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

Thanks,

Naren

Re: Possible entries, unique

Former Member — Tue, 02 Jan 2007 17:26:54 GMT

Hi Hema,

If in your program, you have declared your selection screen variable referencing a DDIC type, and if the DDIC type is associated iwth a check table or a search help, then the search help should be automatically available to you in your program.

Eg.,

select-options:

abc for mara-matnr.

If this is not the case, then ofcourse you can populate the values into an internal table and then call the FM F4IF_INT_TABLE_VALUE_REQUEST.

Rgds,

Prashanth.

SAP India.

Re: Possible entries, unique

Former Member — Tue, 02 Jan 2007 17:29:49 GMT

Hi,

If you have a table name and field name you can use that..

Example.

PARAMETERS: P_VBELN TYPE VBAK-VBELN.

IT will pull the search help automatically..

You can use the match code addition..

Example

PARAMETERS: P_VBELN TYEP VBAK-VBELN MATCHCODE OBJECT VMVA.

Thanks,

Naren

Re: Possible entries, unique

Former Member — Tue, 02 Jan 2007 17:38:41 GMT

I have nt gone to program I'm in Table creation only

in a table for fields

ebelp

menge

brix

bwart

werks

inspso

I have to show possible entries when pressed on them

Re: Possible entries, unique

Former Member — Tue, 02 Jan 2007 17:39:31 GMT

Hi,

For which field you want to have the F4 help..

THanks,

Naren

Re: Possible entries, unique

Former Member — Tue, 02 Jan 2007 17:59:30 GMT

ebelp

menge

brix

bwart

werks

inspso

Re: Possible entries, unique

Former Member — Tue, 02 Jan 2007 18:05:08 GMT

Hi,

When you create the table..You can give a foreign key to the tables mentioned below for each field..So that it will automatically give a possible entries..

ebelp - Not sure

menge - Generally for quantity field you will not get possible entries

brix - Give a description about this field.

bwart - T156

werks - T001W

inspso - Give a description about this field.

Thanks,

Naren

Re: Possible entries, unique

Former Member — Tue, 02 Jan 2007 18:14:53 GMT

brix is a qty field so no need

inspso is a base unit of measure

and one more thing how to create value table or where in domain we can mention

and for a field which was created by me( is abt sequence number ) I have to make it unique field means if same number is entered again it must not take.

Re: Possible entries, unique

Former Member — Tue, 02 Jan 2007 18:27:08 GMT

Hi,

For base unit of measure use the table T006.

Also to define the foreign key..Do the following..

Use the standard sap data element for the fields...This will make easier to define the foreign key.

I have mentioned the data elements for the three fields..

bwart - BWART

werks - WERKS_D

inspso - MEINS

2) Now you have the fields and the correct data elements..

Place the cursor on the field ..let's say BWART..

Press the foreign key button..in the menu..GOTO -> FOREIGN KEY(S)..

Then you will a get message saying..

Foreign key does not exist.

Create a proposal with values table T006 as check table ? "

Press Yes button ..Then automatically the relationship is defined..

Press copy button..

Save and activate..

Do the same for other fields also..

Now you will get F4 on the field..

Thanks,

Naren

Re: Possible entries, unique

Former Member — Tue, 02 Jan 2007 18:36:34 GMT

is foreign key creation and value table same

and for a field which was created by me( is abt sequence number ) I have to make it unique field means if same number is entered again it must not take.

Re: Possible entries, unique

Former Member — Tue, 02 Jan 2007 18:40:48 GMT

Hi,

Check table defines the foreign key for that field value..Example..for BWART..If you enter a value which is not in the table T156..It will give an error..

Value table will not do the foreign key check..

But the system proposes the value table as check table when you try to define a foreign key for this field.

For number sequencing you can create a number range object and interval in the transaction SNRO..And use the function module NUMBER_GET_NEXT to get the next number available..

B.T.W ..

How this new table will be inserted with new records..Is it through SM30??

Thanks,

Naren

Re: Possible entries, unique

Former Member — Tue, 02 Jan 2007 18:51:46 GMT

table maintenace is already done with just 2 fields by other guy now I'm adding new fields and some existing fields tro it

Re: Possible entries, unique

Former Member — Tue, 02 Jan 2007 18:56:04 GMT

Hi,

So using the table maintenance..The table values will be updated??Right??

For the sequence number..Create the number range as I mentioned above..

You might have to use events in the table maintenance to automatically populate the next number in the sequence..

Please reward points for helpful answers..

Thanks,

Naren

Re: Possible entries, unique

Former Member — Tue, 02 Jan 2007 19:30:42 GMT

rt now I'm working with table only I havent started the program so how can i use events

Re: Possible entries, unique

Former Member — Tue, 02 Jan 2007 19:37:27 GMT

Hi,

Check in the following link for the post done by me for getting the next number and using it in SM30.

https://forums.sdn.sap.com/click.jspa?searchID=576841&messageID=2653243

Check in the following links for the posts done by me..This is regarding the SM30 events..

https://forums.sdn.sap.com/click.jspa?searchID=576813&messageID=2403945

https://forums.sdn.sap.com/click.jspa?searchID=576813&messageID=2841130

Thanks,

Naren