Question Re: ABAP CDS View showing different data as compared to SQL Console in Technology Q&A

ABAP CDS View showing different data as compared to SQL Console

former_member820215 — Tue, 06 Sep 2022 09:53:49 GMT

We have a requirement to get TEXT1 for T012T table with SKB1 table.

Select SKB1~BUKRS,SKB1~saknr,SKB1~HBKID,SKB1~HKTID,T012T~text1 from SKB1

LEFT OUTER JOIN T012T On SKB1~BUKRS = T012T~BUKRS AND

SKB1~HBKID = T012T~HBKID AND

SKB1~HKTID = T012T~HKTID

The above code is working fine in SQL Console.

But while below code is being written for CDS View.Its not working i.e. T012T.TEXT1 is not getting populated.

@AbapCatalog.sqlViewName: 'ZBW_C1'

@AbapCatalog.compiler.compareFilter: true

@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK

@EndUserText.label: 'ZBW_HBD_CDS3'

@Analytics.dataExtraction:{enabled: true}

@Analytics.dataCategory: #DIMENSION

define view ZBW_HBD_CDS3 as select distinct from

skb1

left outer join t012t on skb1.bukrs = t012t.bukrs and

skb1.hbkid = t012t.hbkid and

skb1.hktid = t012t.hktid

{

key skb1.saknr as GL_Account,

skb1.bukrs as CompanyCode,

skb1.hbkid as HouseBank_ID,

skb1.hktid as BankAccount_ID,

t012t.text1 as HouseBank_Text,

}

Re: ABAP CDS View showing different data as compared to SQL Console

MKreitlein — Tue, 06 Sep 2022 11:17:50 GMT

Hi Alok,

did you recognize that in your first SQL there is no DISTINCT, whereas in the CDS there is?!

I did not check these tables, this was just obvious.

BR, Martin

Re: ABAP CDS View showing different data as compared to SQL Console

former_member820215 — Tue, 06 Sep 2022 11:31:07 GMT

Even removing distinct doesn't change the output...

Re: ABAP CDS View showing different data as compared to SQL Console

Christophe_SW — Tue, 18 Oct 2022 12:47:07 GMT

Hi Alok,

There might be a compatibility view in your case replacing the old table content with newer content based on a CDS.
check your table via SE11 --> extras --> Replacement object
if there is a replacement object available, try selecting the data from there instead.
Some interesting Facts of Compatibility Views in SAP BW/4HANA and SAP S/4HANA | SAP Blogs

Re: ABAP CDS View showing different data as compared to SQL Console

Marcelo_Rodrigues1 — Tue, 11 Feb 2025 19:01:30 GMT

Hi my friend, thanks for this information.