topic Re: About fumction module in Application Development and Automation Discussions

About fumction module

Former Member — Thu, 05 Oct 2006 05:47:32 GMT

i am using the fun mod 'CTWUL_CHARACT_USAGE' and i need to pass the values like

CHARACT_NAME = 'TANK_SERIAL_NUM',

CHARCT_VALUE = MCH1-CHARG ,

CLASS_TYPE = '023',

CLASSIFICATION = 'X',

Retrieved batch numbers are in ET_CLASSIFICATION-OBJEK1_INTERNAL+18(10) (Offest 18 characters and read next 10 characters)

how to catch the batch no.

how to define in data

can anyone help me out

Re: About fumction module

Former Member — Thu, 05 Oct 2006 08:42:50 GMT

Hi Raju ,

Declare the data value

data : material(10) type c.

loop at ET_CLASSIFICATION

material = OBJEK1_INTERNAL+18(10).

endloop

you will get the value of batch numbers

Please award if useful

Re: About fumction module

Former Member — Fri, 06 Oct 2006 09:55:19 GMT

hi yar

thanks alot.

it helped me alot.

i want to award u, but i dont know how to do that .

could u plz help me out.

and do u know how to inner join tables

raju

Re: About fumction module

Former Member — Fri, 06 Oct 2006 10:03:58 GMT

Hello Raju,

Inner Joins - U can join two or more database tables via inner join...basically it would extract data from both tables where the fields are equal as mentioned in the join condition.

Example :

SELECT a_{matnr c}werks into table itab

from mara as a inner join marc as c

on a_{matnr = c}matnr

where a~matnr in s_matnr.

Here it fetches data from mara and marc table. The tables are joined on the field material number matnr.

As for points..if you have posted the topic as question there would be icons(stars with different colors) on the left of the topic to assign points...

yellow - helpful answer

green - very helpful answer

blue - solved problem.

Re: About fumction module

Former Member — Fri, 06 Oct 2006 10:16:12 GMT

ok thanku..

i given u the points

and i have posted my inner joins problem. can u solve it

raju