SAP table TTXERN (Text Processing: Text ID Groups covers ttxs & ttxer)

SAP table TTXERN has 6 primary key fields being MANDT,TDOBJECT,TXTOB,TXTGR,TDID,LFDTX.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 * MANDT
TDOBJECT Texts: application object CHAR 10 0 TTXOB TDOBJECT
TXTOB Object for which the text group is created CHAR 1 0 TXTOB
A Sales Document Header
B Delivery Header
C Billing Header
D Sales Document Item
E Delivery item
F Billing item
G Customer: Central texts
H Customer: Accounting texts (obsolete)
I Customer: Contact person texts
J Customer: Sales texts
K Sales activities
L Transportation header
M Agreements
N Conditions
O Cust./Material info record
P Settlement Management Document Header
Q Settlement Management Document Item
W Documentary payments
X Legal control
Y Trading Contract Header
Z Trading Contract Item
TXTGR Text Determination Procedure CHAR 2 0 TTXG TXTGR
TDID Text ID CHAR 4 0 TTXID TDID
LFDTX Sequential number of text ID group NUMC 3 0 LFDTX
REDUP Reference/duplication indicator for copying texts CHAR 1 0 REDUP
FEHGR Incompleteness Procedure for Sales Document CHAR 2 0 TVUV FEHGR
TXPFL Text is mandatory or should be displayed CHAR 1 0 TXPFL
Text is not obligatory
X Text is obligatory
Y Text will be displayed during copying
Z Text is obligatory and is displayed when transferring
TXZUF Access sequence for word processing in sales and distibution NUMC 4 0 TTXZ TXZUF

TTXERN foreign key relationships

Table Field Check Table Check Field
0 TTXERN FEHGR TVUV Incompletion Control: Procedures MANDT
0 TTXERN FEHGR TVUV Incompletion Control: Procedures FEHGR
1 TTXERN TDOBJECT TTXOB Valid text objects TDOBJECT
0 TTXERN TXTGR TTXG Text Processing: Text ID Groups MANDT
1 TTXERN TXZUF TTXZ SD Text Processing: Access Sequences MANDT
1 TTXERN TXZUF TTXZ SD Text Processing: Access Sequences TXZUF