cancel
Showing results for 
Search instead for 
Did you mean: 

How to read saved data in BPC 7 Nw Script Logic

Former Member
0 Kudos

Hi all,

I am trying to write the logic for Price*Quantity Calculation. This logic should be executed whenever user saves the data for either Quantity or Price.

For this i created a Implementation on BADI "UJ_CUSTOM_LOGIC". But i am struck on how to read the data from InfoCube ,Like if user saves "Quantity",logic should read "Price" from the cube and calculate the result, Which is equivalent to GET(------) statement in SQL script Logic. Which method should i call to read the saved data in cube.

Appreciate if someone can help me on this.

Thanks&Regards,

Ashok Kumar.

Accepted Solutions (0)

Answers (2)

Answers (2)

i045436
Advisor
Advisor
0 Kudos

Sorry, I didn;t see you are using NW version.

i045436
Advisor
Advisor
0 Kudos

Hi,

You can use the LOOKUP instruction like:

*LOOKUP RATE

*DIM ENTITY2="DEFAULT"

*DIM SOURCECURR:INPUTCURRENCY=ENTITY.CURR

*DIM DESTCURR1:INPUTCURRENCY="USD"

*DIM DESTCURR2:INPUTCURRENCY="EURO"

*DIM RATE=ACCOUNT.RATETYPE

*ENDLOOKUP

Best regards,

Mihaela