Push BW query data build on Transient provider (CDS view) to AL11 in S/4

[former_member604709]

Hello Everybody,

I have custom BW queries built over transient provider (CDS view ) which I want to push to AL11 . These queries are built in embedded BW(7.52) S/4 HANA 1709 system

I have checked using APD but due to length of of the field in CDS view the APD activation dumps with message SY-MSGV4: "TRUNCATE DETECTED - FIELD NAME TOO LONG"

I also checked via Open hub but for that source query built on transient provider is not allowed to be converted to query provider. The check box is missing.

How do I push the query data on cds view to AL11?

[bhavinvyas]

Check if this sort of thing is useful to you,Very well written program by former scn member.

https://blogs.sap.com/2013/11/27/program-to-archive-the-bex-report-output-to-al11-with-header/

Thanks,

Bhavin Vyas