https://community.sap.com/t5/application-development-and-automation-discussions/how-to-create-a-simple-abap-program-for-validation-purposes/m-p/10558183#M1858010 <HTML><HEAD></HEAD><BODY><P>define your 3 internal table</P><P>loop at it_header.</P><P>loop at it_config where&nbsp; Header_ID = it_header-Header_ID.</P><P>..................your code here.</P><P>endloop.</P><P>endloop.</P></BODY></HTML> Thu, 04 Sep 2014 13:08:16 GMT Former Member 2014-09-04T13:08:16Z https://community.sap.com/t5/application-development-and-automation-discussions/how-to-create-a-simple-abap-program-for-validation-purposes/m-p/10558182#M1858009 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">Hi Experts,</SPAN></P><P></P><P>For my internship assignment I am currently assigned to create a simple ABAP program.</P><P></P><P>The requirements are :</P><P></P><P>We have Formula.scv, Mapping,csv and config.scv</P><P></P><P></P><P><STRONG>Formula.csv contains</STRONG></P><P></P><TABLE><TBODY><TR><TD>Header ID</TD><TD>RECORDMODE</TD><TD>FORMULA</TD><TD>code</TD><TD>UOM</TD></TR><TR><TD>1</TD><TD></TD><TD>([SEL1])/([SEL2])</TD><TD>cod1</TD><TD>AMT</TD></TR><TR><TD>2</TD><TD></TD><TD>(([SEL3]/1000))/([SEL4])</TD><TD>cod2</TD><TD>AMT</TD></TR><TR><TD>3</TD><TD></TD><TD>([SEL5])+([SEL6])</TD><TD>cod3</TD><TD>AMT</TD></TR><TR><TD>4</TD><TD></TD><TD>([SEL5])-([SEL7])</TD><TD>cod4</TD><TD>AMT</TD></TR><TR><TD>5</TD><TD></TD><TD>([SEL8])/([SEL9])</TD><TD>cod5</TD><TD>AMT</TD></TR></TBODY></TABLE><P></P><P><STRONG>Mapping,csv <STRONG>contains</STRONG></STRONG></P><P></P><P></P><TABLE><TBODY><TR><TD>Data Record Number</TD><TD>Selection ID</TD><TD>Dim</TD><TD>Attr</TD><TD>BW Delta Process: Record Mode</TD><TD>Sign</TD><TD>Option</TD><TD>Low</TD><TD>High</TD><TD>Valid From</TD><TD>Valid To</TD></TR><TR><TD>1</TD><TD>SEL1</TD><TD>ACCOUNT</TD><TD>ACCOUNT</TD><TD></TD><TD>I</TD><TD>EQ</TD><TD>100</TD><TD></TD><TD>20010101</TD><TD>99991231</TD></TR><TR><TD>2</TD><TD>SEL1</TD><TD>SUBANALYSIS</TD><TD>SUBANALYSIS</TD><TD></TD><TD>I</TD><TD>EQ</TD><TD>101</TD><TD></TD><TD>20010101</TD><TD>99991231</TD></TR><TR><TD>3</TD><TD>SEL1</TD><TD>SUBANALYSIS</TD><TD>SUBANALYSIS</TD><TD></TD><TD>I</TD><TD>EQ</TD><TD>102</TD><TD></TD><TD>20010101</TD><TD>99991231</TD></TR><TR><TD>4</TD><TD>SEL1</TD><TD>SUBANALYSIS</TD><TD>SUBANALYSIS</TD><TD></TD><TD>I</TD><TD>EQ</TD><TD>103</TD><TD></TD><TD>20010101</TD><TD>99991231</TD></TR><TR><TD>5</TD><TD>SEL1</TD><TD>SUBANALYSIS</TD><TD>SUBANALYSIS</TD><TD></TD><TD>I</TD><TD>EQ</TD><TD>104</TD><TD></TD><TD>20010101</TD><TD>99991231</TD></TR><TR><TD>6</TD><TD>SEL1</TD><TD>SUBANALYSIS</TD><TD>SUBANALYSIS</TD><TD></TD><TD>I</TD><TD>EQ</TD><TD>105</TD><TD></TD><TD>20010101</TD><TD>99991231</TD></TR><TR><TD>1</TD><TD>SEL2</TD><TD>ACCOUNT</TD><TD>ACCOUNT</TD><TD></TD><TD>I</TD><TD>EQ</TD><TD>106</TD><TD></TD><TD>20010101</TD><TD>99991231</TD></TR><TR><TD>2</TD><TD>SEL2</TD><TD>SUBANALYSIS</TD><TD>SUBANALYSIS</TD><TD></TD><TD>I</TD><TD>EQ</TD><TD>107</TD><TD></TD><TD>20010101</TD><TD>99991231</TD></TR><TR><TD>3</TD><TD>SEL2</TD><TD>SUBANALYSIS</TD><TD>SUBANALYSIS</TD><TD></TD><TD>I</TD><TD>EQ</TD><TD>108</TD><TD></TD><TD>20010101</TD><TD>99991231</TD></TR><TR><TD>4</TD><TD>SEL2</TD><TD>SUBANALYSIS</TD><TD>SUBANALYSIS</TD><TD></TD><TD>I</TD><TD>EQ</TD><TD>109</TD><TD></TD><TD>20010101</TD><TD>99991231</TD></TR><TR><TD>5</TD><TD>SEL2</TD><TD>SUBANALYSIS</TD><TD>SUBANALYSIS</TD><TD></TD><TD>I</TD><TD>EQ</TD><TD>110</TD><TD></TD><TD>20010101</TD><TD>99991231</TD></TR><TR><TD>6</TD><TD>SEL2</TD><TD>SUBANALYSIS</TD><TD>SUBANALYSIS</TD><TD></TD><TD>I</TD><TD>EQ</TD><TD>111</TD><TD></TD><TD>20010101</TD><TD>99991231</TD></TR><TR><TD>1</TD><TD>SEL3</TD><TD>ACCOUNT</TD><TD>ACCOUNT</TD><TD></TD><TD>I</TD><TD>EQ</TD><TD>112</TD><TD></TD><TD>20010101</TD><TD>99991231</TD></TR><TR><TD>2</TD><TD>SEL3</TD><TD>SUBANALYSIS</TD><TD>SUBANALYSIS</TD><TD></TD><TD>I</TD><TD>EQ</TD><TD>113</TD><TD></TD><TD>20010101</TD><TD>99991231</TD></TR><TR><TD>3</TD><TD>SEL3</TD><TD>SUBANALYSIS</TD><TD>SUBANALYSIS</TD><TD></TD><TD>I</TD><TD>EQ</TD><TD>114</TD><TD></TD><TD>20010101</TD><TD>99991231</TD></TR><TR><TD>4</TD><TD>SEL3</TD><TD>SUBANALYSIS</TD><TD>SUBANALYSIS</TD><TD></TD><TD>I</TD><TD>EQ</TD><TD>115</TD><TD></TD><TD>20010101</TD><TD>99991231</TD></TR><TR><TD>5</TD><TD>SEL3</TD><TD>SUBANALYSIS</TD><TD>SUBANALYSIS</TD><TD></TD><TD>I</TD><TD>EQ</TD><TD>116</TD><TD></TD><TD>20010101</TD><TD>99991231</TD></TR><TR><TD>6</TD><TD>SEL3</TD><TD>SUBANALYSIS</TD><TD>SUBANALYSIS</TD><TD></TD><TD>I</TD><TD>EQ</TD><TD>117</TD><TD></TD><TD>20010101</TD><TD>99991231</TD></TR><TR><TD>1</TD><TD>SEL4</TD><TD>ACCOUNT</TD><TD>ACCOUNT</TD><TD></TD><TD>I</TD><TD>EQ</TD><TD>118</TD><TD></TD><TD>20010101</TD><TD>99991231</TD></TR><TR><TD>2</TD><TD>SEL4</TD><TD>SUBANALYSIS</TD><TD>SUBANALYSIS</TD><TD></TD><TD>I</TD><TD>EQ</TD><TD>119</TD><TD></TD><TD>20010101</TD><TD>99991231</TD></TR><TR><TD>3</TD><TD>SEL4</TD><TD>SUBANALYSIS</TD><TD>SUBANALYSIS</TD><TD></TD><TD>I</TD><TD>EQ</TD><TD>120</TD><TD></TD><TD>20010101</TD><TD>99991231</TD></TR><TR><TD>4</TD><TD>SEL4</TD><TD>SUBANALYSIS</TD><TD>SUBANALYSIS</TD><TD></TD><TD>I</TD><TD>EQ</TD><TD>121</TD><TD></TD><TD>20010101</TD><TD>99991231</TD></TR><TR><TD>5</TD><TD>SEL4</TD><TD>SUBANALYSIS</TD><TD>SUBANALYSIS</TD><TD></TD><TD>I</TD><TD>EQ</TD><TD>122</TD><TD></TD><TD>20010101</TD><TD>99991231</TD></TR><TR><TD>6</TD><TD>SEL4</TD><TD>SUBANALYSIS</TD><TD>SUBANALYSIS</TD><TD></TD><TD>I</TD><TD>EQ</TD><TD>123</TD><TD></TD><TD>20010101</TD><TD>99991231</TD></TR><TR><TD>1</TD><TD>SEL5</TD><TD>CASHFLOW</TD><TD>CASHFLOW</TD><TD></TD><TD>I</TD><TD>EQ</TD><TD>124</TD><TD></TD><TD>20010101</TD><TD>99991231</TD></TR><TR><TD>1</TD><TD>SEL6</TD><TD>CASHFLOW</TD><TD>CASHFLOW</TD><TD></TD><TD>I</TD><TD>EQ</TD><TD>125</TD><TD></TD><TD>20010101</TD><TD>99991231</TD></TR><TR><TD>1</TD><TD>SEL7</TD><TD>CASHFLOW</TD><TD>CASHFLOW</TD><TD></TD><TD>I</TD><TD>EQ</TD><TD>126</TD><TD></TD><TD>20010101</TD><TD>99991231</TD></TR><TR><TD>1</TD><TD>SEL8</TD><TD>ACCOUNT</TD><TD>ACCOUNT</TD><TD></TD><TD>I</TD><TD>EQ</TD><TD>127</TD><TD></TD><TD>20010101</TD><TD>99991231</TD></TR><TR><TD>1</TD><TD>SEL9</TD><TD>ACCOUNT</TD><TD>ACCOUNT</TD><TD></TD><TD>I</TD><TD>EQ</TD><TD>128</TD><TD></TD><TD>20010101</TD><TD>99991231</TD></TR></TBODY></TABLE><P></P><P><STRONG>config.scv Contains</STRONG></P><P></P><TABLE><TBODY><TR><TD>Calculation Name</TD><TD>Header ID</TD><TD>Area</TD><TD>Calculation Type (KPI/DVA)</TD><TD>Recordmode</TD><TD>Sequence</TD></TR><TR><TD>test1</TD><TD>1</TD><TD>EUR</TD><TD>KPI</TD><TD></TD><TD>1</TD></TR><TR><TD>test2</TD><TD>2</TD><TD>EUR</TD><TD>KPI</TD><TD></TD><TD>1</TD></TR><TR><TD>test3</TD><TD>3</TD><TD>EUR</TD><TD>KPI</TD><TD></TD><TD>1</TD></TR><TR><TD>test4</TD><TD>4</TD><TD>EUR</TD><TD>KPI</TD><TD></TD><TD>1</TD></TR><TR><TD>test5</TD><TD>5</TD><TD>EUR</TD><TD>KPI</TD><TD></TD><TD>1</TD></TR></TBODY></TABLE><P></P><P>I need to create a ABAP program which validates if Header ID in Header table matches&nbsp; the Header ID in config table</P><P>so, for instance if there is header id 1 in header table config table should also contain header id 1.</P><P>if mapping table contains SEL1 for example header table should also contain SEL1.</P><P></P><P>can you advise me where to start?</P><P></P><P>Thanks in advance,</P><P></P><P>Rabie</P></BODY></HTML> Thu, 04 Sep 2014 12:41:44 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-create-a-simple-abap-program-for-validation-purposes/m-p/10558182#M1858009 Former Member 2014-09-04T12:41:44Z https://community.sap.com/t5/application-development-and-automation-discussions/how-to-create-a-simple-abap-program-for-validation-purposes/m-p/10558183#M1858010 <HTML><HEAD></HEAD><BODY><P>define your 3 internal table</P><P>loop at it_header.</P><P>loop at it_config where&nbsp; Header_ID = it_header-Header_ID.</P><P>..................your code here.</P><P>endloop.</P><P>endloop.</P></BODY></HTML> Thu, 04 Sep 2014 13:08:16 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-create-a-simple-abap-program-for-validation-purposes/m-p/10558183#M1858010 Former Member 2014-09-04T13:08:16Z https://community.sap.com/t5/application-development-and-automation-discussions/how-to-create-a-simple-abap-program-for-validation-purposes/m-p/10558184#M1858011 <HTML><HEAD></HEAD><BODY><P>Any other suggestions?</P><P></P><P>Best Regards,</P><P></P><P>Rabie Hamidi</P></BODY></HTML> Wed, 24 Sep 2014 11:21:32 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-create-a-simple-abap-program-for-validation-purposes/m-p/10558184#M1858011 Former Member 2014-09-24T11:21:32Z