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

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?