topic Re: Logic for adding... in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/logic-for-adding/m-p/3878478#M932291 <HTML><HEAD></HEAD><BODY><P>Cheers mate....points awarded...</P></BODY></HTML> Thu, 29 May 2008 12:19:17 GMT Former Member 2008-05-29T12:19:17Z Logic for adding... https://community.sap.com/t5/application-development-and-automation-discussions/logic-for-adding/m-p/3878476#M932289 <HTML><HEAD></HEAD><BODY><P>hkont waers shkzg wrbtr </P><TABLE><TBODY><TR><TD><P>0001200120</P></TD><TD><P>USD</P></TD><TD><P>H</P></TD><TD><P>6688.96</P></TD></TR></TBODY></TABLE><P> </P><TABLE><TBODY><TR><TD><P>0001000100</P></TD><TD><P>USD</P></TD><TD><P>S</P></TD><TD><P>6688.96</P></TD></TR></TBODY></TABLE><P> </P><TABLE><TBODY><TR><TD><P>0001200105</P></TD><TD><P>EUR</P></TD><TD><P>H</P></TD><TD><P>6688.96</P></TD></TR></TBODY></TABLE><P> </P><TABLE><TBODY><TR><TD><P>0001000250</P></TD><TD><P>EUR</P></TD><TD><P>S</P></TD><TD><P>100000.00</P></TD></TR></TBODY></TABLE><P> </P><TABLE><TBODY><TR><TD><P>0007991110</P></TD><TD><P>EUR</P></TD><TD><P>H</P></TD><TD><P>100000.00</P></TD></TR></TBODY></TABLE><P> </P><TABLE><TBODY><TR><TD><P>0001000100</P></TD><TD><P>CAD</P></TD><TD><P>S</P></TD><TD><P>100000.00</P></TD></TR></TBODY></TABLE><P> </P><TABLE><TBODY><TR><TD><P>0007991300</P></TD><TD><P>CAD</P></TD><TD><P>H</P></TD><TD><P>100000.00</P></TD></TR></TBODY></TABLE><P> </P><TABLE><TBODY><TR><TD><P>0001000250</P></TD><TD><P>EUR</P></TD><TD><P>S</P></TD><TD><P>20000.00</P></TD></TR></TBODY></TABLE><P> </P><TABLE><TBODY><TR><TD><P>0007991110</P></TD><TD><P>EUR</P></TD><TD><P>H</P></TD><TD><P>20000.00</P></TD></TR></TBODY></TABLE><P> </P><P>|0001000100|GBP |S | 20000.00 </P><P></P><P>hi,</P><P></P><P>Have an requirement to add the wrbtr field based on the gl account number(HKONT)</P><P>Currency(WAERS) and debit/credit indicator(SHKZG).</P><P></P><P>If the accounts are same then currency needs to be checked and it the currency is also the same </P><P>then the indicator has to be checked and the wrbtr value has to be calulated... WRBTR = S - H.</P><P></P><P>Example: For a glaccount if there are 4 currencies with 3s and 1H then the final record will be a single </P><P>record with the gl account number, currency and debit indicator and WRBTR = S<EM>S</EM>S-H.</P><P></P><P></P><P>if the account and currency are not similar ...the values can be appended direclty...</P><P>..was trying to use field-symbols..please help on this ...how to do it.</P></BODY></HTML> Thu, 29 May 2008 09:41:21 GMT https://community.sap.com/t5/application-development-and-automation-discussions/logic-for-adding/m-p/3878476#M932289 Former Member 2008-05-29T09:41:21Z Re: Logic for adding... https://community.sap.com/t5/application-development-and-automation-discussions/logic-for-adding/m-p/3878477#M932290 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Do something like this (itab1 has your 4 fields, itab2 has 3 fields - doesn't have shkzg):</P><PRE><CODE> LOOP AT itab1 INTO wa_1. CLEAR wa_2. wa_2-hkont = wa_1-hkont. wa_2-waers = wa_1-waers. IF wa_1-shkzg EQ 'S'. wa_2-wrbtr = wa_1-wrbtr. ELSE. wa_2-wrbtr = - wa_1-wrbtr. ENDIF. COLLECT wa_2 INTO itab2. ENDLOOP. </CODE></PRE><P>Best regards.</P><P>Valter Oliveira.</P></BODY></HTML> Thu, 29 May 2008 09:55:17 GMT https://community.sap.com/t5/application-development-and-automation-discussions/logic-for-adding/m-p/3878477#M932290 valter_oliveira 2008-05-29T09:55:17Z Re: Logic for adding... https://community.sap.com/t5/application-development-and-automation-discussions/logic-for-adding/m-p/3878478#M932291 <HTML><HEAD></HEAD><BODY><P>Cheers mate....points awarded...</P></BODY></HTML> Thu, 29 May 2008 12:19:17 GMT https://community.sap.com/t5/application-development-and-automation-discussions/logic-for-adding/m-p/3878478#M932291 Former Member 2008-05-29T12:19:17Z