Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Upload program to load data from 2 custom tables to 3rd table

Former Member
0 Kudos

Hi Friends,

I need to write a program to upload data from two custom tables into 3rd custom table. below are the tables

1.ZCASALLFACT

Client 125

Fiscal Year 2006

Period block 6

CO Area 7000

Value Type 4

Version 0

PLvl2 01

Function Code 39

cal mode P

Stat. key fig. PEPREM

Total Cost $ 0.00

IT Cost in $ 0.00

T Cost% 12.390

IT Cost% 1.300

2.ZCASALLINPUT

Client 125

Fiscal Year 2006

Period block 6

CO Area 7000

Value Type 4

Version 0

Company Code L005

Profit Center P103

LineOfBusiness L101L005

Stat. key fig. PEPREM

Amount $ 100,000.00

Total Quantity 0.000

3.ZCASALLPRCNG

MANDT 125

FYEAR 2006

PERIOD 6

CTRLAREA 7000

VALTYPE 4

VERSION 0

LEGALENTITY L005

PROFITCENTER 103

LOB L101L005

FUNCTION 39

TOTALCOST 12,390

ITCOST 1,300

if calmode in table 1 is eq to p

then table3-totalcost = table1-totcost% * table2-amount

similarly for table3-itcost.

if calmode in table is eq to u

then table3-totalcost = table1-totalcost * table2-quanty

similarly for table3-itcost

There is another custom table which is used as reference table to link Plvl in table 1 and LOB in table 2.

table4:ZCASRLOB2LVL2

Client 125

CO Area 7000

LineOfBusiness L101L005

PLvl 01

Please suggest.....if anyone has any code related to this please send me.

Thanks

2 REPLIES 2

Former Member
0 Kudos

Why don't you try writing the code? If you run into problems, send the problem to the forum and we'll help you out.

Rob

Former Member
0 Kudos

Hi,

You will find your solution in below <b>thread</b>:

<b>Reward if helpful</b>

Rgds,

Shakuntala