Skip to Content
0
Former Member
Jan 28, 2009 at 11:08 PM

Optimizing SQL script logic

23 Views

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