Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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


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,


Former Member

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

0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question