Hi,
I've just created a custom package with script logic to post data from application sales to application finance. It is working fine (eureka :-)...), but I was just wondering whether my coding could be written in a better way. Probably I do not have to repeat each section per account ... Since I have no (correction, a little) knowledge of SQL statements + this language is not teached at the SAP courses of CPM, I am learning SQL just from SDN. I also have read the how to papers (part I - III) (but if you know other and more detailed documents on SQL statements, please give me the link as well).
*XDIM_MEMBERSET ENTITY = E_DLW_BE
*XDIM_MEMBERSET CATEGORY=ACTUAL
*XDIM_MEMBERSET ACCOUNT=PL100,PL200,PL210,PL220
*Destination_app = FINANCE
*SKIP_DIM = CUSTOMER
*SKIP_DIM = PRODUCT_GRP
*ADD_DIM COSTCENTER = CC1010
*WHEN ACCOUNT
*IS PL100
*REC(Account="700")
*ENDWHEN
*COMMIT
*Destination_app = FINANCE
*SKIP_DIM = CUSTOMER
*SKIP_DIM = PRODUCT_GRP
*ADD_DIM COSTCENTER = CC1051
*WHEN ACCOUNT
*IS PL200
*REC(FACTOR=-1,Account="7131")
*ENDWHEN
*COMMIT
*Destination_app = FINANCE
*SKIP_DIM = CUSTOMER
*SKIP_DIM = PRODUCT_GRP
*ADD_DIM COSTCENTER = CC1052
*WHEN ACCOUNT
*IS PL210
*REC(FACTOR=-1,Account="7132")
*ENDWHEN
*COMMIT
*Destination_app = FINANCE
*SKIP_DIM = CUSTOMER
*SKIP_DIM = PRODUCT_GRP
*ADD_DIM COSTCENTER = CC1053
*WHEN ACCOUNT
*IS PL220
*REC(FACTOR=-1,Account="7133")
*ENDWHEN
*COMMIT
regards
Dries