topic Re: FM in Application Development and Automation Discussions

FM

Former Member — Fri, 23 Feb 2007 15:47:26 GMT

Hi all,

I am creating a FM which RFC enabled..so when i execute this FM it should only give PO numbers(ebeln) from the ekko table..but while declaring in the table i hve declared lt_ekko as ekko table...now when i execute the FM it is giving ebeln values and other fields are displayed with null values..how to remove those fields other than ebeln..i have decalred as below::

Tables:

LT_EKKO LIKE EKKO

In the source code i have written as ::

select ebeln from ekko into corresponding fields of table lt_ekko

where bsart in ('ECDP','ECPO','EB').

how to get only PO number ???

Re: FM

ferry_lianto — Fri, 23 Feb 2007 15:52:02 GMT

Hi,

Please create structure/tranparent table (SE11) with only field EBELN.

LT_EKKO TYPE ZEKKO.

Regards,

Ferry Lianto

Re: FM

Former Member — Fri, 23 Feb 2007 15:52:18 GMT

Create a structure with single field as EBELN, and use the same in FM Table.

Thanks

Re: FM

Former Member — Fri, 23 Feb 2007 15:56:17 GMT

if you just want to retrieve po values, you've to declare the table like:

lt_ekko type z_t_ekko. (tabletype z_t_ekko has just one column ebeln)

select ebeln from ekko into table lt_ekko

where bsart in ('ECDP','ECPO','EB').

Message was edited by:

Mario Schmidt

Re: FM

Former Member — Fri, 23 Feb 2007 16:00:39 GMT

Hi,

1. In the Function Group i.e Global Data, declare a table as follows.


TYPES : BEGIN OF x_ebeln,
          ebeln TYPE ebeln,
        END    OF  x_ebeln.

DATA : lt_ekko TYPE TABLE OF x_ebeln.

2. In you code, <b>instead of</b>


select ebeln from ekko into corresponding fields of table lt_ekko
where bsart in ('ECDP','ECPO','EB').


select ebeln from ekko into table lt_ekko
where bsart in ('ECDP','ECPO','EB').

Now, your table has only one field therefore it will not display other field with null values.

Reward points if the answer is helpful.

Regards,

Mukul

Re: FM

Former Member — Fri, 23 Feb 2007 16:12:53 GMT

THanks !

Is there any other way without creating the structure????

Re: FM

ferry_lianto — Fri, 23 Feb 2007 16:17:22 GMT

Hi,

That is the only way to create structure unless you only want to get a single PO

then you can use parameter instead table.

Regards,

Ferry Lianto