topic Re: How to select data from sub Text Table in Application Development and Automation Discussions

How to select data from sub Text Table

former_member805784 — Thu, 24 Mar 2022 19:32:49 GMT

I am new to SAP programming and trying to pull data from this table AGR_DEFINE which has a Text Table AGR_TEXTS apart of it. The data I need is the Role(AGR_NAME) and Short Description(TEXT), which the Role I have no problem grabbing but the Description is causing problems. I defined my types:

TYPES: BEGIN OF TY_AGR,<br>        AGR_NAME LIKE AGR_DEFINE-AGR_NAME,<br>        TEXT LIKE AGR_TEXTS-TEXT,<br>  END OF TY_AGR.

But selecting the data gives me the error "Unknown column name "Text". until runtime, you cannot specify a field list"

SELECT AGR_NAME<br>         TEXT<br>  FROM AGR_DEFINE INTO CORRESPONDING FIELDS OF TABLE ITAB_AGR.

How am I able to grab this data?

Re: How to select data from sub Text Table

jerryjanda — Thu, 24 Mar 2022 19:33:45 GMT

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members. Feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html as well, as that will help you when submitting questions to the community.

I also recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

Kind regards,

--Jerry

Moderation Lead

Re: How to select data from sub Text Table

shivakrishna1507 — Fri, 25 Mar 2022 03:06:51 GMT

Hi,

Use Inner join instead. This code should work.

Types: Begin of ty_agr,
       agr_name Like agr_define-agr_name,
       text Like agr_texts-text,
      End of ty_agr.
Data: itab type standard table of ty_agr.

Select from agr_define as a 
       inner join agr_texts as b on a~agr_name = b~agr_name 
       fields a~agr_name as a1,
              b~text as b1 into Table @itab.

Note: Specify your Condition in select Statement.

Re: How to select data from sub Text Table

RaymondGiuseppi — Fri, 25 Mar 2022 16:23:10 GMT

You have to read the text table too, use some JOIN option in the SELECT, don't forget the language field.

(You may have been tricked by SE16 or SE16n which autimatically add the text table)