topic Re: Create simple program for starter in Application Development and Automation Discussions

Create simple program for starter

Garcia — Wed, 09 Jul 2008 19:08:03 GMT

Hello,

I'm a functional consultant and I want to create a program.

Here's the deal: I know basic code functions (select, where, if's...), break and debbug But nothing else.

My client doesn´t want to install LSMW on the server, and the deal is pretty simple so I guess with your help it will be easy.

DATA: field A links table 1 and 2. Field B is from table 1. Field C is from table 2 and can be loaded with field B (field C is blank so far).

My program needs to:

If field A in table 2 has an entry in table B, field C (for that line) should take the value of field B.

Can you help up on this? I know it's pretty simple... Do I start in SE38?

Regards.

Re: Create simple program for starter

Former Member — Wed, 09 Jul 2008 19:15:07 GMT

yes,

u can start writing code in se38.

select fieldA from table 1 into table itab

where <condition>

select field b, c from table 2 into table jtab

for all entries in itab

where fieldA = itab-fieldA

loop on jtab.

read itab..

append final table.

endloop.

select a_{fieldA b}fieldB b~fieldC from ( table 1 as a inner join table 2 as b

on a_{filedA = b}fieldB )

into table itab

where <condition>

loop on itab.

write 😕 your fields.

endloop.

This is rough program, u can start working like this.

all the best

Re: Create simple program for starter

Former Member — Wed, 09 Jul 2008 19:22:38 GMT

Hello,

There are lot of demo programs provided by SAP.

You can start with the 'Hello World' program DEMO_HELLO_WORLD in se38.

hope this helps.

cheers,

Sushil Joshi

Re: Create simple program for starter

Former Member — Wed, 09 Jul 2008 19:28:48 GMT

Hello Gonçalo Garcia ,

This can be achieved using select statement with innerjoin as follows:

select single TABLE-1~FIELD-B

into FIELD-C

from TABLE1 as TABLE-1

INNER JOIN TABLE1-FIELD-B = TABLE2-FIELD_ON-TABLEB

where .

Above select is an example for your situation.

Thanks,

Greetson

Re: Create simple program for starter

Garcia — Sat, 12 Jul 2008 14:54:08 GMT

Thank you!