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
Bluesky
