Read a pooled table for Text in CDS View

[anilsuryavansi]

Hi, I am creating a CDS view joining SKA1, SKB1, 2 custom tables (G/L account ranges are maintained here) to give a report using CDS view. There is a need to bring text for field status group but joining T004G gives an error since Pool tables are not allowed in join condition. "The parser produced the error: The view contains a pooled table or cluster table in the definition, or a view of the pooled tables or cluster tables. This means that the view cannot be used.".

Any suggestions how this can be achieved in simple CDS view. In ABAP - I could have read the T004G table in an internal table and used to further populate the value.

Below is simple representation of the code.

define view ZCDS

as select from ska1 as a

left outer join skb1 as b on b.mandt = a.mandt and b.saknr = a.saknr

left outer join t004g as fsg on fsg.spras = t.spras and fsg.bukrs = 'AAA' and fsg.fstag = b.fstag

{

key a.mandt,

key a.ktopl,

key a.saknr,

key b.bukrs,

b.fstag,

fsg.fsttx

}

[Sandra_Rossi]

Pooled and clusters tables don't exist anymore since ABAP 7.53 (and with S/4HANA), so probably they are not handled by CDS.

Don't use them in CDS views.

That's it.

EDIT: concerning how to inject an internal table, you have lots of questions/answers already in the forum, by searching:

CDS views with table as input site:sap.com