SAP table TZZTG (Transaction code - Correspondence activity allocation)

SAP table TZZTG has 6 primary key fields being MANDT,RANTYP,SATZTYP,CODE,PROGRAMM,KORRVORF.

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
RANTYP Contract Type CHAR 1 0 RANTYP
1 Loans
2 Securities
3 Lease-Out - Real Estate
4 Foreign Exchange
5 Money Market
6 Derivatives
7 Open Item Transactions
8 Administration Contract - Real Estate
9 General Contract - Real Estate
A Internal use only
B Bank Accounts
E Exposures
T Trade Finance
V Contract Management - Consumer Products
X External Accounts
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
SATZTYP Record Cat. in Allocation Table Code -> Corr.Activity CHAR 1 0 VVSATZTYP
1 Transaction code - correspondence activity
2 OK code - correspondence activity
3 Function code/program - correspondence activity
CODE OK code CHAR 20 0 OK
PROGRAMM ABAP Program Name CHAR 40 0 TRDIR PROGNAME
KORRVORF Correspondence activity NUMC 4 0 TZKV KORRVORF

TZZTG foreign key relationships

Table Field Check Table Check Field
0 TZZTG KORRVORF TZKV Correspondence activities MANDT
1 TZZTG PROGRAMM TRDIR Generated Table for View NAME