How AI is applied across API Evangelist and APIs.io. Read my AI disclosure →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

SM30 maintenance view on tables ZZZB ZZZA, where clause on ZZZA field doesn't filter out ZZZB lines

calendar_today September 8, 2026 person Sandra_Rossi domain sap-bi-tools

I’ve got two tables ZZZA and ZZZB. ZZZA has just 3 columns CLIENT, OBJTYPE, OBJKEY, nothing else special. ZZZB has columns CLIENT and OBJKEY with a foreign key to ZZZA as follows: I have created this maintenance view ZZZV (NB: I have defined the tables ZZZB and ZZZA in this order, via the button “Relationships”, ZZZA appearing in the section “Referenced tables”, because it wasn’t possible to define ZZZA then ZZZB, because ZZZB was listed in the section “Relationships with unsuitable cardinality”, I’m not sure if the order of tables is important or not): Note that the foreign key constant selec

open_in_new Read original post