problems RDL and autogenerated tables

[Former Member]

Hi,

I have a question and problems.

Why the tables self-generated in RDL is different in every environment?

right now, SAP build a query using the tables self-generated in RDL but when we try to transport to QA, we get an error, when I see the customizing by SPRO I found the table's name is different in DEV, QAS and PRD.

When I saw the query they used the tables in RDL, See the picture in the red box

[Former Member · Accepted solution]

maybe, if I use the field data table instead header table  and version table, it can work in query???

[former_member493148]

Hi Maria,

RDL Tables are generated within the after import in each client to ensure unique name.

This include all RDL tables (header, version, data). So the DB table names will always be different in each clients.

This is anyway not recommended to address directly with SQL statement the RDL to avoid wrong usage of the versioning and special RDL features.

The only option you have is to create an ABAP program in order to retrieve the name of the DB table of your system and generate your SQL statement within the report.

Kind regards,

Florent.

[Former Member]

Hi Florent,

Thank You very much for your help.