Showing results for 
Search instead for 
Did you mean: 

How to apply Excel formula in BPS layout

Former Member
0 Kudos

Hi ,

I need to apply the following logic in my BPS layout.

There are three data columns called C,D,E respectivelt

redord 1 user input data for all the columns,

Record 2 C2 = D1 + E2.

Record 3 C3 = D2 + E3.


Record n Cn = D(n-1) + En.

n is the number of record in teh layout.

1: Can we use Excel formula to achive this?

2: If the anser is yes, how can we configure the BPS layout? I am not sure if we can do it at the last step of change layout.

3: If the answer is no, what is the other choice? I have tried to use user exit, but had some problem in passing the data to xth_data table in the orginal order sequence.

thanks in advance.

Accepted Solutions (1)

Accepted Solutions (1)

Active Contributor
0 Kudos


please see my answer to your original post "data in BPS layout columns"



SAP NetWeaver RIG

Answers (0)