topic Re: How to data base fields values to screen fields in Application Development and Automation Discussions

How to data base fields values to screen fields

Former Member — Mon, 11 May 2009 06:24:29 GMT

hi,

I am working with MIGO goods display.

Initially, I added a three fields to migo screen for example MKPF-Z_NUM.(Z_NUM is append structure to MKPF table).

Now when user enter the document in Migo screen when he says Display document,the field value(mkpf-z_num) has to display on MIGO screen.

thank you to u all.

Anu

Re: How to data base fields values to screen fields

Former Member — Mon, 11 May 2009 06:26:37 GMT

Hi,

You added the fields on the screen but you need to add them also into the data base table then only you can able to display the fields when you are displaying the MIGO

Re: How to data base fields values to screen fields

Former Member — Mon, 11 May 2009 06:27:48 GMT

Hi,

check for some screen exits if they are available to fulfill your requirements...

Regards,

Siddarth

Re: How to data base fields values to screen fields

Former Member — Mon, 11 May 2009 06:27:51 GMT

yes I added field for table already.

Re: How to data base fields values to screen fields

Former Member — Mon, 11 May 2009 06:28:48 GMT

Can u provide me some examples for me

Re: How to data base fields values to screen fields

Former Member — Mon, 11 May 2009 06:36:16 GMT

Hi,

go to the screen where you require the fields value to be displayed and check for any module on the subscreen area...

check in this program LMIGOKL2 for call customer-function and see if this helps you out....

Regards,

Siddarth

Re: How to data base fields values to screen fields

Former Member — Mon, 11 May 2009 06:41:42 GMT

HI,

Please go through the following example

STEPS:

Enhancement used: MM06E005

1. Go to transaction CMOD and create a project as shown below.

2.Give the enhance name as MM06E005 and save.

Click on components button the following screen is displayed.

3.Create the required custom fields using the includes CI_EKKODB and CI_EKPODB

The above 5 fields are added.

4.Screen: 0111 is used for adding custom fields. Design the screen with the above fields.

Code in PBO

if sy-tcode eq 'ME23' OR 'ME23N'.

LOOP AT SCREEN.

IF SCREEN-GROUP1 EQ 'A1'.

SCREEN-INPUT = 0.

MODIFY SCREEN.

ENDIF.

ENDLOOP.

ENDIF.

5.The following two function Exits are used for adding custom fields at item level:

EXIT_SAPMM06E_016 (Export Data to Customer Sub screen for PO)

EXIT_SAPMM06E_018 (Import Data from Customer Sub screen for PO)

Click on the Function Module: EXIT_SAPMM06E_016

The following screen is displayed

Double click on the include and write the following code

FS_EKPO TYPE EKPO_CI "EKPO ADDITIONAL FIELDS.

IF ( SY-TCODE = 'ME23N' OR SY-TCODE ='ME23' OR SY-TCODE ='ME22N' OR SY-TCODE = 'ME22' ).

LOOP AT TEKPO.

IF ( TEKPO-EBELN EQ I_EKPO-EBELN AND TEKPO_EBELP EQ I_EKPO-EBELP.

EKPO_CI-ZMATERIAL = TEKPO-ZMATERIAL.

EKPO_CI-ZQUANTITY = TEKPO-ZQUANTITY.

.....

ENDIF.

ENDLOOP.

ENDIF.

The following is the code for the function module EXIT_SAPMM06E_018

E_CI_EKPO-ZMATERIAL = EKPO_CI-ZMATERIAL.

E_CI_EKPO-ZQUANTITY = EKPO_CI-ZQUANTITY.

6.Go to transaction ME22N and check at item level. Custom tab with custom fields will appear as follow.

Enter some data in the custom fields and save.

7.Go to EKPO table and check the data.

Re: How to data base fields values to screen fields

Former Member — Mon, 11 May 2009 14:01:11 GMT

Hi,

I used Badi(zmb_migo) to assign fields to migo screen,and module program(z_migo_cust) here i maintain the fields which i assigned.

so now suggest me how can send for example field data (mkpf-z_num is appended field) to migo screen.

Thanks in advance.

Anu

Edited by: Anitha Reddy on May 12, 2009 3:23 AM

Re: How to data base fields values to screen fields

Former Member — Tue, 12 May 2009 05:16:41 GMT

Hello Anita,

Use the above mentioned user exit MM06E005 and try putting breakpoints in its components and try to figure out which include gets called during execution of ur transaction.Accordingly,you can code in that particular include and also write code in the PBO of your module pool program in which you have created those fields for display.

Re: How to data base fields values to screen fields

Former Member — Tue, 12 May 2009 05:26:16 GMT

yes i did that but break-point not stopping there because i used badi to assign to MIGO screen.

any suggestions please.

Re: How to data base fields values to screen fields

Former Member — Tue, 12 May 2009 05:34:30 GMT

Hi,

You added your field in the screen & as well as to your data base table also thats fine.

When come to the application like MIGO for to display the application data it will process with the structure.

I hope that you need to add your new field to that structure also.

Please check it.

Regards,

madan mohan.

Re: How to data base fields values to screen fields

Former Member — Thu, 28 May 2009 05:56:21 GMT

hi,

Now I will explain you the actual problem.

I added a screen with two fields to MIGO standard screen through BADI.

the added fields are MKPF-XBLNR and MKPF-BKTXT.

Now MIGO->Display->document history will display,here I want to get the data MKPF-XBLNR and MKPF-BKTXT for that document.

any suggestion plz on this..

Edited by: Anitha Reddy on Jun 5, 2009 9:04 AM

Re: How to data base fields values to screen fields

Former Member — Fri, 05 Jun 2009 07:17:26 GMT

R u added these fields at creation of MIGO?

Re: How to data base fields values to screen fields

Former Member — Fri, 05 Jun 2009 07:58:40 GMT

yes added to migo screen...