Former Member
Jan 09, 2012 at 08:27 AM

# How to Avoid Override of values

16 Views

Hi,

wat should i mention in my rec statemnt to avoid override of value...

suppose m sending data frm revenue app to finance app for the first time...

(entering data against 5 product out of 10 and sending it to db)

if i again do this exercise for 2nd time (for the rest 5 product)...the data gets override...my p n l report shows me the new value..

which i want to avoid.

i want the values to get sumed up..

Immediate response will b appreciated..

```*DESTINATION_APP = FINANCE
*XDIM_MEMBERSET P_Category = budver1
*XDIM_FILTER P_ENTITY = [P_ENTITY].properties("GROUPTYPE")="T"
*XDIM_FILTER P_DistChannel = [P_DistChannel].properties("GROUP")="REVENUE"
*XDIM_MEMBERSET P_RevAccount = 3000000 ,3000002 , 4000000
*XDIM_FILTER P_PRODUCTS = [P_PRODUCTS].properties("TRANSFER")="Y"
*XDIM_FILTER P_COUNTRY = [P_COUNTRY].properties("TRANSFER")="Y"
*SKIP_DIM = P_PLANT,P_VENDOR,P_RevInpCurrency
*RENAME_DIM P_Products = P_CostCenter, P_Country = P_Region, P_RevAccount =P_COA
*XDIM_MEMBERSET RPTCURRENCY = LC, INR,EUR,GBP

*WHEN P_REVACCOUNT
*IS "3000000"
*REC(FACTOR =1, P_COUNTRY=P_COUNTRY.FINACCOUNT , P_PRODUCTS = P_PRODUCTS.FINACCOUNT, P_REVACCOUNT = P_REVACCOUNT.FINACCOUNT)
*REC(FACTOR =1, P_COUNTRY=P_COUNTRY.FINACCOUNT , P_PRODUCTS = P_PRODUCTS.FINACCOUNT, P_REVACCOUNT = P_REVACCOUNT.FINACCOUNT2)
*REC(FACTOR =1, P_COUNTRY=P_COUNTRY.FINACCOUNT , P_PRODUCTS = P_PRODUCTS.FINACCOUNT, P_REVACCOUNT = P_REVACCOUNT.FINACCOUNT4)

*ENDWHEN

*WHEN P_REVACCOUNT
*IS "3000002"
*REC(FACTOR =1, P_COUNTRY=P_COUNTRY.FINACCOUNT , P_PRODUCTS = P_PRODUCTS.FINACCOUNT, P_REVACCOUNT = P_REVACCOUNT.FINACCOUNT)
*REC(FACTOR =1, P_COUNTRY=P_COUNTRY.FINACCOUNT , P_PRODUCTS = P_PRODUCTS.FINACCOUNT, P_REVACCOUNT = P_REVACCOUNT.FINACCOUNT2)
*REC(FACTOR =1, P_COUNTRY=P_COUNTRY.FINACCOUNT , P_PRODUCTS = P_PRODUCTS.FINACCOUNT, P_REVACCOUNT = P_REVACCOUNT.FINACCOUNT4)

*ENDWHEN
```
{"ft_lang_label":"__label__en","ft_lang_prob":0.7397892,"math_prob":0.96574956,"size":1866,"snap":"2021-43-2021-49","text_gpt3_token_len":552,"char_repetition_ratio":0.25241676,"word_repetition_ratio":0.26865673,"special_character_ratio":0.27063236,"punctuation_ratio":0.23630136,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.97986925,"pos_list":[0],"im_url_duplicate_count":[null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2021-11-29T17:29:45Z\",\"WARC-Record-ID\":\"<urn:uuid:2531ffad-8234-4a76-ab90-1cd751132ea2>\",\"Content-Length\":\"54817\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:a064d688-fa62-478c-9ed5-41f12c5ebc30>\",\"WARC-Concurrent-To\":\"<urn:uuid:2098f928-be86-467f-81f6-f7b90471052a>\",\"WARC-IP-Address\":\"18.158.207.124\",\"WARC-Target-URI\":\"https://answers.sap.com/questions/8985331/how-to-avoid-override-of-values.html\",\"WARC-Payload-Digest\":\"sha1:PN43ZDHEYGH26OYYZEXUE2PURVFKQE4Z\",\"WARC-Block-Digest\":\"sha1:6XZ7CWYBVZHFAAZDJYJVAJ7OE5WVXHVA\",\"WARC-Identified-Payload-Type\":\"text/html\",\"warc_filename\":\"/cc_download/warc_2021/CC-MAIN-2021-49/CC-MAIN-2021-49_segments_1637964358786.67_warc_CC-MAIN-20211129164711-20211129194711-00086.warc.gz\"}"}