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

Former Member — Sat, 24 Jun 2006 01:24:20 GMT

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

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

Former Member — Sat, 24 Jun 2006 02:54:56 GMT

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

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

Former Member — Sat, 24 Jun 2006 11:24:50 GMT

Hi,

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

<b>Reward if helpful</b>

Rgds,

Shakuntala

topic Re: Upload program to load data from 2 custom tables to 3rd table in Application Development and Automation Discussions

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

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

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