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?)

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

Tags:
Former Member
replied

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

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