Register Login

HOW CAN WE RETRIVE DATA FROM TEXT TABLES

Updated May 18, 2018

Hi,

How can we retrive data from text table.
for example: for table MARA , text table is ZST_MAKT ,from these text table how can we retrive data.
out put will we like these ,
 
MATNR        MTART         MAKTX
697               FERT            MONITOR
688               FERT            PENDRIVE
658               FERT            COMPACT DISK
 
pls any one send me the code to this program.pls don't use inner joins,bcoz it didn't accept joins,pls any one send me the code........
 
thanks.


Comments

  • 27 Nov 2010 10:02 am Guest
    Text table for MARA is MAKT.

    select single * from MAKT where MATNR eq MARA-MATNR
    and SPRAS eq 'EN'.
  • 02 Dec 2010 7:26 pm Jon Jourdonnais
    where can I find the Text Table schema for the SAP tables... i.e. Table MARA is Material Master and as stated above the text table is ZST_MAKT, how can I get a listing of all text tables and what they are associated with.
  • 15 Feb 2011 8:25 am rekha
    simply use the join to fetch both information


    select mara~matnr zst_makt~maktx
    into (your feilds comma separated )
    from mara inner join makt on mara~matnr = zst_makt~mara and
    zst_makt-spras = 'EN' --> Language key if available

    This should do.
  • 15 Feb 2011 8:25 am rekha
    If u want to retrieve an SAPScript text implemented u can use function module READ_TEXT.
  • 13 Sep 2016 3:24 pm Guest

    how to get field description for pa0001 table.?

    pa0001- pernr, werks, persg, persk

    ​where 

    werks - t500p

    persg - t501t

    persk - t503k

    ​can any one please give me sample program or same program for tis table fields..


×