SAP Knowledge Base Article - Public

2796654 - CDS View for Long Text not available in S4HANA Cloud

Symptom

  • CDS view for Long Text ( tables STXH , STXL ) is not available in the SAP API HUB https://api.sap.com/ or app "View Browser"
  • An object , for example Sales Order , Material , Purchase Order has Header Long Text maintained that we need to consume in a custom CDS view but there is no way to extract it

Environment

  • SAP S/4HANA Cloud - All Versions

Cause

Missing Functionality .

The Long Text for an object ( Sales Order Header Text , Purchase Order Header Text , Material long text , Etc ) are saved in the tables SXTH/SXTL

Text content are stored in table STXH and STXL using the ABAP command EXPORT TO DATABASE.

Therefore, the texts can only be read using the ABAP command IMPORT FROM DATABASE.

It is not possible to read the texts via CDS views as CDS views cannot use ABAP commands

Please also check the information outlined in the KBA  2508133

Resolution

Please check the help.sap.com cloud documentation CDS Views for a list of views released for each Line of Business with fields that can be used as alternatives

For the latest updates on the planned function capabilities, please refer to the SAP S/4HANA Cloud roadmap. Available under https://www.sap.com/roadmaps, the roadmap is updated quarterly.

Please use the SAP Customer Influence Program as outlined in the KBA  2780129 for functionality to be included

Keywords

PO Texts , Header text , Header note ,'SAPscript text file header' , 'SAPscript text file lines' , "View Browser" , "Query Browser" . , KBA , read_text , text object" object id eina , "record text" , BC-SRV-APS-GKE , Generic CDS Key User Editor , LO-MD-FIO , Fiori UI for Logistics Basic Data , MM-FIO-PUR-PO , Fiori UI for Purchase Orders , SD-FIO , Fiori User Interface , Problem

Product

SAP S/4HANA Cloud all versions