How to use GOS attachment URL in CDS view

[S0026746840]

I want to use GOS attachment URL in CDS View.

However, URL attached in GOS is stored in SOFFCONT1 as binery data, so that it cannot be used directly.

1, Can I use Function Module in CDS View?
    CDS View is used by DataSphere, so maybe I cannot use Virtual Element.

2, Is there any table that store URL text as text data?

[RobertVit]

Hi, ususally you store here some documents like PDF. Therefore i don't think it is stored other than as a binary.

[S0026746840]

If URL is stored as a binary, how to get data from S/4 to Datasphere?

Convert binery to text, must I use function mudule?

[RobertVit]

Hi, for PDF there is no text stored; you need a OCR software for this. Data Sphere is for BI, isn't it? Attachements ar documents which normaly are stored in a optical archive system

[S0026746840]

I wanna use URL itself in Datasphere.

Datasphere makes report including URL, therefore CDS View must include URLs as text.

(Create external document(PDF))

[juveria_sap_integrity]

In S/4 systems, GOS doesn’t really distinguish between “URL” and “file” at storage level. Even when you attach a URL via GOS, it’s still persisted as SAPoffice content and ends up in SOFFCONT1 as binary, not as plain text. This is often missed.

You can’t call function modules or do binary‑to‑text conversion inside a CDS view, especially if the consumer is Datasphere. CDS is deliberately restricted, and virtual elements won’t help here either.

Be careful here: there is no standard table where GOS URLs are stored as clean text you can just select. If you need URLs in Datasphere, the usual approach is to change how they are created in the first place (store the URL as application data in your own table, not as a GOS attachment), or extract and convert them outside CDS (ABAP layer, ODP, or custom extraction). Otherwise you’re looking at a design limitation, not a missing join