SAP ABAP Table /IPRO/TTEMPL (Document Builder Templates)

Hierarchy

☛ SAP_BS_FND (Software Component) SAP Business Suite Foundation
   ⤷ CA-GTF-DOB (Application Component) Document Builder
     ⤷ /IPRO/BASIS (Package) Tables, Structures, general Infrastruktur

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	/IPRO/TTEMPL	Table Relationship Diagram
Short Description	Document Builder Templates

Delivery and Maintenance

Pool/cluster
Delivery Class	E	Control table, SAP and customer have separate key areas
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	CONTENT	☑	/IPRO/CONTENT	/IPRO/CONTENT	CHAR	10	0	Content	/IPRO/TCONTENT
3	TMPL	☑	/IPRO/TMPL	CHAR40	CHAR	40	0	System Template Name
4	VERSION	☑	/IPRO/ELEMENT_VERSION	NUM5	NUMC	5	0	Version Number
5	ID	☐	/IPRO/TEMPLATE_ID	CHAR15	CHAR	15	0	Template Number
6	CMODIF	☐	/IPRO/CMODIF	CHAR3	CHAR	3	0	Content Modifier	/IPRO/TCMODIF
7	USR	☐	/IPRO/CREATEDBY	/IPRO/CREATEDBY	CHAR	20	0	Created by
8	DOCSL	☐	/IPRO/DOCSL	CHAR20	CHAR	20	0	Document Selection	/IPRO/TDOCSL
9	DFLT_STYLE	☐	/IPRO/STYLE	CHAR20	CHAR	20	0	Document Style	/IPRO/TSTYL
10	NOTE	☐	/IPRO/TMPL_NOTE		STRG	0	0	Template Note
11	EFFT_DTE	☐	/IPRO/EFFT_DTE	DATS	DATS	8	0	Effective Date
12	OWNER	☐	/IPRO/TMPLOWNER	XUBNAME	CHAR	12	0	Owner	*
13	CATEGORY	☐	/IPRO/TEMPLATE_CATEGORY	CHAR10	CHAR	10	0	Template Category	/IPRO/TTMPL_CAT
14	DOCMNT	☐	/IPRO/TMPL_GUID	/IPRO/GUID	RAW	16	0	Template GUID
15	STATUS	☐	/IPRO/TMPLSTAT	/IPRO/TMPLSTAT	CHAR	1	0	Template Status
16	RESP_ORG	☐	/IPRO/PORG	/IPRO/PORG	CHAR	14	0	Purchasing Organization
17	RESP_GRP	☐	/IPRO/PORG	/IPRO/PORG	CHAR	14	0	Purchasing Organization
18	CONFIDENTIAL	☐	/IPRO/CONFIDENTIAL	XFELD	CHAR	1	0	Confidential
19	LAST_CHANGED	☐	/IPRO/TIMESTAMP	/IPRO/TIMESTAMP	DEC	15	0	Timestamp
20	CHANGED_BY	☐	/IPRO/CREATEDBY	/IPRO/CREATEDBY	CHAR	20	0	Created by
21	CHANGE_REASON	☐	/IPRO/CHANGE_REASON		STRG	0	0	Change Reason
22	INTENDED_USE	☐	/IPRO/INTENDED_USE		STRG	0	0	Intended Use
23	NAME	☐	/IPRO/TMPL_NAME	TEXT40	CHAR	40	0	Template Name
24	COLLAB_INT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
25	DATE_FORMAT	☐	XUDATFM	XUDATFM	CHAR	1	0	Date format
26	DEC_FORMAT	☐	XUDCPFM	XUDCPFM	CHAR	1	0	Decimal Format
27	LOCKED_BY	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
28	LOCKED_ON	☐	/IPRO/TIMESTAMP	/IPRO/TIMESTAMP	DEC	15	0	Timestamp
29	USRSTAT	☐	J_ESTAT	J_ESTAT	CHAR	5	0	User Status	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/IPRO/TTEMPL	CATEGORY	/IPRO/TTMPL_CAT	CATEGORY
2	/IPRO/TTEMPL	CMODIF	/IPRO/TCMODIF	CMODIF
3	/IPRO/TTEMPL	CONTENT	/IPRO/TCONTENT	CONTENT	KEY	1	CN
4	/IPRO/TTEMPL	DFLT_STYLE	/IPRO/TSTYL	STYLE	REF	1	CN
5	/IPRO/TTEMPL	DOCSL	/IPRO/TDOCSL	DOCSL	KEY	1	CN
6	/IPRO/TTEMPL	MANDT	T000	MANDT	KEY	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in	10A