cancel
Showing results for 
Search instead for 
Did you mean: 

HANA view: merge an accountnumber to an intervall (expression editor / filter / inputparameter?)

Former Member
0 Kudos

Hi SCN,

hopefully someone has a clue.

The situation:

- having 2 tables (FAGLFLEXA and FAGL_011ZC)
- a field called RACCT in FAGLFLEXA (containing Account) number)

- two fields VONKT (account from) and BISKT (account to) representing an intervall in between the account is

The problem is that I want to know to which intervall a specific account (RACCT) belongs. For every matching entry I would write the financial statement item (ERGSL) into the calculated column .

The idea is to use a expression to validate the RACCT entry is >= VONKT and <= BISKT.  The expression : IF("RACCT">="VONKT", IF("RACCT" <="BISKT", "ERGSL",0),0)

Any idea why I always get an error by validating and activing this view?

Thanks in advance,

Jonathan

Accepted Solutions (1)

Accepted Solutions (1)

lbreddemann
Active Contributor
0 Kudos

Why don't you just join on RACCT to be in between those two columns?

Either plain SQL or analytic view lets you do that.

- Lars

Former Member
0 Kudos

Thanks a lot!

The referrential join with these properties fits perfect:

Answers (0)