what is the table which stores all the adobe forms in sap

[Former Member]

    hello experts,

      what is the table which stores all the adobe form details like smart forms will be stored in TNAPR.

Thanks in advance,

  Krishnaveni.

[former_member230486 · Accepted solution]

Hi,

The adobe forms stored in the Transparent Table: FPCONTEXT

[Former Member · Accepted solution]

hi, thanks for your answer. its correct answer.

[stephenl1]

The main table is FPCONTEXT, as others have said, however this contains all the context you would see when looking at the form in SFP, so multiple rows per form.  If you only want to see the form once in the output then you need to INNER JOIN this table with FPCONTEXTT and select where the ID is blank (as this represents the description for the form, rather than a context list item).  Once you have this you can join to table EFRM to get the application form name associated with the Adobe Form and its interface.

 

The following SQL select statement might be useful to you, just change to match your client number where client is referenced in the joins (mine is 220) and add your own selection value in the Where clause.

select 

-- form data as shown under transaction code SFP

fcon.name as Form
, cont.text as Form_description
, case fcon.state
when 'A' then 'Active'
when 'I' then 'Inactive'
else 'Unknown'
end as State
, fcon.interface
, fcon.firstuser as Creator_ID
, crby.name_text as Creator_Name
, fcon.firstdate as Created_on
, fcon.lastuser as Changer_ID
, chby.name_text as Changer_Name
, fcon.lastdate as Changed_on

-- form data from transaction code EFRM

, efrm.formkey
, ftxt.descript
, ttxt.ddtext as FormType

, efrm.ernam as Creator_ID
, ecrby.name_text as Creator_Name
, efrm.erdat as Created_on
, efrm.aenam as Changer_ID
, echby.name_text as Changer_Name
, efrm.aedat as Changed_on

, efrm.formclass
, ctxt.descript as FormClassDescr


-- form data as shown under transaction code SFP

from fpcontext as fcon -- Form context

inner join fpcontextt as cont -- context description
on cont.name = fcon.name
and cont.state = fcon.state
and cont.id = ''
and cont.language = 'E'

left outer join v_usr_name as crby -- Created by
on crby.mandt = '220'
and crby.bname = fcon.firstuser

left outer join v_usr_name as chby -- Changed by
on chby.mandt = '220'
and chby.bname = fcon.lastuser

-- form data from transaction code EFRM

left outer join efrm as efrm
on efrm.client = '220'
and efrm.ADFORM = fcon.name --cont.name

left outer join efrmte as ftxt-- Form description
on ftxt.client = efrm.client
and ftxt.langu = 'E'
and ftxt.formkey = efrm.formkey

left outer join efclt as ctxt -- Class description
on ctxt.langu = 'E'
and ctxt.formclass = efrm.formclass

left outer join v_usr_name as ecrby -- Created by
on ecrby.mandt = efrm.client
and ecrby.bname = efrm.ernam

left outer join v_usr_name as echby -- Changed by
on echby.mandt = efrm.client
and echby.bname = efrm.aenam

left outer join dd07t as ttxt -- Form type description
on ttxt.domname = 'EFG_FORMTYPE'
and ttxt.ddlanguage = 'E'
and ttxt.domvalue_l = efrm.formtype

where fcon.name like 'Z%'

order by fcon.name