Hi Experts,
For my internship assignment I am currently assigned to create a simple ABAP program.
The requirements are :
We have Formula.scv, Mapping,csv and config.scv
Formula.csv contains
| Header ID | RECORDMODE | FORMULA | code | UOM |
| 1 | | ([SEL1])/([SEL2]) | cod1 | AMT |
| 2 | | (([SEL3]/1000))/([SEL4]) | cod2 | AMT |
| 3 | | ([SEL5])+([SEL6]) | cod3 | AMT |
| 4 | | ([SEL5])-([SEL7]) | cod4 | AMT |
| 5 | | ([SEL8])/([SEL9]) | cod5 | AMT |
Mapping,csv contains
| Data Record Number | Selection ID | Dim | Attr | BW Delta Process: Record Mode | Sign | Option | Low | High | Valid From | Valid To |
| 1 | SEL1 | ACCOUNT | ACCOUNT | | I | EQ | 100 | | 20010101 | 99991231 |
| 2 | SEL1 | SUBANALYSIS | SUBANALYSIS | | I | EQ | 101 | | 20010101 | 99991231 |
| 3 | SEL1 | SUBANALYSIS | SUBANALYSIS | | I | EQ | 102 | | 20010101 | 99991231 |
| 4 | SEL1 | SUBANALYSIS | SUBANALYSIS | | I | EQ | 103 | | 20010101 | 99991231 |
| 5 | SEL1 | SUBANALYSIS | SUBANALYSIS | | I | EQ | 104 | | 20010101 | 99991231 |
| 6 | SEL1 | SUBANALYSIS | SUBANALYSIS | | I | EQ | 105 | | 20010101 | 99991231 |
| 1 | SEL2 | ACCOUNT | ACCOUNT | | I | EQ | 106 | | 20010101 | 99991231 |
| 2 | SEL2 | SUBANALYSIS | SUBANALYSIS | | I | EQ | 107 | | 20010101 | 99991231 |
| 3 | SEL2 | SUBANALYSIS | SUBANALYSIS | | I | EQ | 108 | | 20010101 | 99991231 |
| 4 | SEL2 | SUBANALYSIS | SUBANALYSIS | | I | EQ | 109 | | 20010101 | 99991231 |
| 5 | SEL2 | SUBANALYSIS | SUBANALYSIS | | I | EQ | 110 | | 20010101 | 99991231 |
| 6 | SEL2 | SUBANALYSIS | SUBANALYSIS | | I | EQ | 111 | | 20010101 | 99991231 |
| 1 | SEL3 | ACCOUNT | ACCOUNT | | I | EQ | 112 | | 20010101 | 99991231 |
| 2 | SEL3 | SUBANALYSIS | SUBANALYSIS | | I | EQ | 113 | | 20010101 | 99991231 |
| 3 | SEL3 | SUBANALYSIS | SUBANALYSIS | | I | EQ | 114 | | 20010101 | 99991231 |
| 4 | SEL3 | SUBANALYSIS | SUBANALYSIS | | I | EQ | 115 | | 20010101 | 99991231 |
| 5 | SEL3 | SUBANALYSIS | SUBANALYSIS | | I | EQ | 116 | | 20010101 | 99991231 |
| 6 | SEL3 | SUBANALYSIS | SUBANALYSIS | | I | EQ | 117 | | 20010101 | 99991231 |
| 1 | SEL4 | ACCOUNT | ACCOUNT | | I | EQ | 118 | | 20010101 | 99991231 |
| 2 | SEL4 | SUBANALYSIS | SUBANALYSIS | | I | EQ | 119 | | 20010101 | 99991231 |
| 3 | SEL4 | SUBANALYSIS | SUBANALYSIS | | I | EQ | 120 | | 20010101 | 99991231 |
| 4 | SEL4 | SUBANALYSIS | SUBANALYSIS | | I | EQ | 121 | | 20010101 | 99991231 |
| 5 | SEL4 | SUBANALYSIS | SUBANALYSIS | | I | EQ | 122 | | 20010101 | 99991231 |
| 6 | SEL4 | SUBANALYSIS | SUBANALYSIS | | I | EQ | 123 | | 20010101 | 99991231 |
| 1 | SEL5 | CASHFLOW | CASHFLOW | | I | EQ | 124 | | 20010101 | 99991231 |
| 1 | SEL6 | CASHFLOW | CASHFLOW | | I | EQ | 125 | | 20010101 | 99991231 |
| 1 | SEL7 | CASHFLOW | CASHFLOW | | I | EQ | 126 | | 20010101 | 99991231 |
| 1 | SEL8 | ACCOUNT | ACCOUNT | | I | EQ | 127 | | 20010101 | 99991231 |
| 1 | SEL9 | ACCOUNT | ACCOUNT | | I | EQ | 128 | | 20010101 | 99991231 |
config.scv Contains
| Calculation Name | Header ID | Area | Calculation Type (KPI/DVA) | Recordmode | Sequence |
| test1 | 1 | EUR | KPI | | 1 |
| test2 | 2 | EUR | KPI | | 1 |
| test3 | 3 | EUR | KPI | | 1 |
| test4 | 4 | EUR | KPI | | 1 |
| test5 | 5 | EUR | KPI | | 1 |
I need to create a ABAP program which validates if Header ID in Header table matches the Header ID in config table
so, for instance if there is header id 1 in header table config table should also contain header id 1.
if mapping table contains SEL1 for example header table should also contain SEL1.
can you advise me where to start?
Thanks in advance,
Rabie
Bluesky
