Extract data from S4 going to Azure Data Factory (ADF) using CDS View

[Loed]

Hi guys,

We are trying to extract data using CDS view from S4 to Azure Data Factory.

Just wanted to check is there a specific notation needed to be applied in the CDS view for it to show in the Azure Data Factory?

We can the CDS views below in the screenshot but we can't see the following:

IFIPRFTCTRHT - not found
ISDSALESAREA - not found
CSDTYPEVH - not found

I already tried to compare these CDS views with the ones which are showing but can't find any significant difference.

Is there a setting or something which needs to be set?

Thanks a lot!

Loed

[JulianoRomanato]

Hello striker_wbb.

How are you? I have excluded the Tag "SAP S/4HANA Cloud" and included the Tag "SAP S/4HANA Cloud Extensibility" for this question, as it is related to Data Extraction.

Regards.

Juliano Romanato.

[former_member6443]

Hi Loed,

The note 2689191 says the below annotations are required

@Analytics: { dataCategory: #DIMENSION(or #CUBE), dataExtraction.enabled: true }

Please feel free to reach out if you have any further questions.

Thanks

Afshin

[Loed]

Thanks for the reply Afshin.

Unfortunately there really is no “NOT FOUND” error in azure data factory (ADF) side. I just can’t find those sql view names I have mentioned.

I checked these CDS views with #DIMENSION or #CUBE tagging but they are both not showing as well in ADF.

I_GLAaccountLineItemCube

I_OperationalAcctgDocItem

Thank you.

Loed