About fumction module

[Former Member]

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

r

[Former Member]

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

r

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

ok thanku..

i given u the points

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

raju