Online Tutorials & Training Materials | STechies.com
Register Login

HOW CAN WE RETRIVE DATA FROM TEXT TABLES

|| || 5

HOW CAN WE RETRIVE DATA FROM TEXT TABLES
Stechies

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
    Text table for MARA is MAKT.

    select single * from MAKT where MATNR eq MARA-MATNR
    and SPRAS eq 'EN'.
  • Jon Jourdonnais
    02 Dec 2010 7:26 pm
    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
    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
    If u want to retrieve an SAPScript text implemented u can use function module READ_TEXT.
  • 13 Sep 2016 3:24 pm

    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..