SAP ABAP Table MHNK_TRLO (Include for MHNK Treasury Loans)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ TR (Application Component) Treasury
     ⤷ FVVD_CORE (Package) TR-CORE: Former Objects from FVVD (TR Loans)

Basic Data

Table Category	INTTAB	Structure
Structure	MHNK_TRLO	Table Relationship Diagram
Short Description	Include for MHNK Treasury Loans

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	RKLAMMER	☐	RKLAMMER	RANL	CHAR	13	0	Classification Number for Finance Projects
2	SDUNNCMP	☐	SDUNNCMP	SDUNNCMP	CHAR	2	0	Summarization Level for Dunning Letter
3	SDUNNDOC	☐	SDUNNDOC	SDUNNDOC	CHAR	1	0	Type of Dunning Letter
4	.INCLU-REC	☐				0	0	Address formating function module transfer structure
5	ANREDREC	☐	ANRED	TEXT15	CHAR	15	0	Title
6	NAME1REC	☐	NAME1_ADRS	TEXT40	CHAR	40	0	Name 1 of an address
7	NAME2REC	☐	NAME2_ADRS	TEXT40	CHAR	40	0	Name 2 of an address
8	NAME3REC	☐	NAME3_ADRS	TEXT40	CHAR	40	0	Name 3 of an address
9	NAME4REC	☐	NAME4_ADRS	TEXT40	CHAR	40	0	Name 4 of an address
10	STRASREC	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
11	PFACHREC	☐	PFACH_BAS	PFACH	CHAR	10	0	PO box
12	PSTL2REC	☐	PSTL2_BAS	PSTLZ	CHAR	10	0	PO Box postal code
13	PFORTREC	☐	PFORT_ADRS	TEXT40	CHAR	40	0	PO Box city
14	LAND1REC	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
15	PSTLZREC	☐	PSTLZ_BAS	PSTLZ	CHAR	10	0	Postal code
16	ORT01REC	☐	ORT01_GP	TEXT35	CHAR	35	0	City
17	ORT02REC	☐	ORT01_GP	TEXT35	CHAR	35	0	City
18	REGIOREC	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
19	SPRASREC	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
20	INLNDREC	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
21	ANZZLREC	☐	ANZEI	ANZEI	DEC	2	0	Number of lines in address
22	PRIORREC	☐	PRITY_ADRS	CHAR9	CHAR	9	0	Address lines priority
23	WARENREC	☐	WAREN	WAREN	CHAR	1	0	Delivery address ID
24	LINE0REC	☐	LINES	LINES	CHAR	80	0	Address line
25	LINE1REC	☐	LINES	LINES	CHAR	80	0	Address line
26	LINE2REC	☐	LINES	LINES	CHAR	80	0	Address line
27	LINE3REC	☐	LINES	LINES	CHAR	80	0	Address line
28	LINE4REC	☐	LINES	LINES	CHAR	80	0	Address line
29	LINE5REC	☐	LINES	LINES	CHAR	80	0	Address line
30	LINE6REC	☐	LINES	LINES	CHAR	80	0	Address line
31	LINE7REC	☐	LINES	LINES	CHAR	80	0	Address line
32	LINE8REC	☐	LINES	LINES	CHAR	80	0	Address line
33	LINE9REC	☐	LINES	LINES	CHAR	80	0	Address line
34	LINEKREC	☐	LINES	LINES	CHAR	80	0	Address line
35	LINEDREC	☐	LINES	LINES	CHAR	80	0	Address line
36	LINED0REC	☐	LINES	LINES	CHAR	80	0	Address line
37	PO_BOX_LOBBYREC	☐	AD_PO_BOX_LBY	TEXT40	CHAR	40	0	PO Box Lobby
38	DELI_SERV_TYPEREC	☐	AD_DELIVERY_SERVICE_TYPE	AD_DELIVERY_SERVICE_TYPE	CHAR	4	0	Type of Delivery Service
39	DELI_SERV_NUMBERREC	☐	AD_DELIVERY_SERVICE_NUMBER	CHAR10	CHAR	10	0	Number of Delivery Service
40	COUNTYREC	☐	AD_COUNTY	TEXT40	CHAR	40	0	County
41	TOWNSHIPREC	☐	AD_TOWNSHIP	TEXT40	CHAR	40	0	Township
42	TITLE_LE_T	☐	BP_T_LET_T	TEXT30	CHAR	30	0	Salutation
43	.INCLU-SBE	☐				0	0	Address formating function module transfer structure
44	ANREDSBE	☐	ANRED	TEXT15	CHAR	15	0	Title
45	NAME1SBE	☐	NAME1_ADRS	TEXT40	CHAR	40	0	Name 1 of an address
46	NAME2SBE	☐	NAME2_ADRS	TEXT40	CHAR	40	0	Name 2 of an address
47	NAME3SBE	☐	NAME3_ADRS	TEXT40	CHAR	40	0	Name 3 of an address
48	NAME4SBE	☐	NAME4_ADRS	TEXT40	CHAR	40	0	Name 4 of an address
49	STRASSBE	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
50	PFACHSBE	☐	PFACH_BAS	PFACH	CHAR	10	0	PO box
51	PSTL2SBE	☐	PSTL2_BAS	PSTLZ	CHAR	10	0	PO Box postal code
52	PFORTSBE	☐	PFORT_ADRS	TEXT40	CHAR	40	0	PO Box city
53	LAND1SBE	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
54	PSTLZSBE	☐	PSTLZ_BAS	PSTLZ	CHAR	10	0	Postal code
55	ORT01SBE	☐	ORT01_GP	TEXT35	CHAR	35	0	City
56	ORT02SBE	☐	ORT01_GP	TEXT35	CHAR	35	0	City
57	REGIOSBE	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
58	SPRASSBE	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
59	INLNDSBE	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
60	ANZZLSBE	☐	ANZEI	ANZEI	DEC	2	0	Number of lines in address
61	PRIORSBE	☐	PRITY_ADRS	CHAR9	CHAR	9	0	Address lines priority
62	WARENSBE	☐	WAREN	WAREN	CHAR	1	0	Delivery address ID
63	LINE0SBE	☐	LINES	LINES	CHAR	80	0	Address line
64	LINE1SBE	☐	LINES	LINES	CHAR	80	0	Address line
65	LINE2SBE	☐	LINES	LINES	CHAR	80	0	Address line
66	LINE3SBE	☐	LINES	LINES	CHAR	80	0	Address line
67	LINE4SBE	☐	LINES	LINES	CHAR	80	0	Address line
68	LINE5SBE	☐	LINES	LINES	CHAR	80	0	Address line
69	LINE6SBE	☐	LINES	LINES	CHAR	80	0	Address line
70	LINE7SBE	☐	LINES	LINES	CHAR	80	0	Address line
71	LINE8SBE	☐	LINES	LINES	CHAR	80	0	Address line
72	LINE9SBE	☐	LINES	LINES	CHAR	80	0	Address line
73	LINEKSBE	☐	LINES	LINES	CHAR	80	0	Address line
74	LINEDSBE	☐	LINES	LINES	CHAR	80	0	Address line
75	LINED0SBE	☐	LINES	LINES	CHAR	80	0	Address line
76	PO_BOX_LOBBYSBE	☐	AD_PO_BOX_LBY	TEXT40	CHAR	40	0	PO Box Lobby
77	DELI_SERV_TYPESBE	☐	AD_DELIVERY_SERVICE_TYPE	AD_DELIVERY_SERVICE_TYPE	CHAR	4	0	Type of Delivery Service
78	DELI_SERV_NUMBERSBE	☐	AD_DELIVERY_SERVICE_NUMBER	CHAR10	CHAR	10	0	Number of Delivery Service
79	COUNTYSBE	☐	AD_COUNTY	TEXT40	CHAR	40	0	County
80	TOWNSHIPSBE	☐	AD_TOWNSHIP	TEXT40	CHAR	40	0	Township
81	.INCLU-BP0	☐				0	0	Business Partner Master (General Data)
82	MANDTBP0	☐	MANDT	MANDT	CLNT	3	0	Client	T000
83	PARTNRBP0	☐	BP_PARTNR_OLD	BP_PARTNR	CHAR	10	0	Business Partner Number	*
84	PARTNR_OLDBP0	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
85	.INCLUDE	☐				0	0	BP: Attributes of General Business Partner
86	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
87	PERSNUMBER	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	ADRP
88	BU_GROUP	☐	BU_GROUP	BU_GROUP	CHAR	4	0	Business Partner Grouping	*
89	EXTPARTNR	☐	BP_EXT_PNR	CHAR15	CHAR	15	0	External Business Partner ID
90	CUSTOMER	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
91	TYPE	☐	BP_TYPE_OLD	BP_TYPE	CHAR	1	0	Partner category
92	BP_GROUP	☐	BP_GROUP	XFELD	CHAR	1	0	BP: Collective Business Partner Indicator
93	GROUP_ID	☐	BP_GRP_ID_OLD	BP_GRP_ID	CHAR	4	0	Business Partner Grouping	TPZ2
94	NAME1	☐	BP_NAME1	TEXT40	CHAR	40	0	Name 1 (surname for persons, otherwise company name)
95	NAME2	☐	BP_NAME2	TEXT40	CHAR	40	0	Name 2 (Continuation of NAME 1)
96	LANGU	☐	LANGU	SPRAS	LANG	1	0	Language Key	T002
97	TITLE	☐	BP_TITLE_OLD	BP_TITLE	NUMC	2	0	Form of Address (Key)	TP01
98	TITLE_LET	☐	BP_TITL_LT	BP_TITL_LT	NUMC	2	0	Salutation	TP02
99	ADR_REF	☐	BP_ADR_REF_OLD	BP_ADR_REF	CHAR	10	0	Address ID	TP14
100	SORT1	☐	BP_SORT1	CHAR20	CHAR	20	0	Sort Field 1
101	SORT2	☐	BP_SORT2	CHAR20	CHAR	20	0	Sort Field 2
102	SORT_PHON	☐	BP_SORT_PH	CHAR20	CHAR	20	0	Sort Field for Phonetic Search; Obsolete
103	MC_NAME1	☐	BP_MC_NAM1	CHAR25	CHAR	25	0	Field NAME1 in Upper Case
104	MC_NAME2	☐	BP_MC_NAM2	CHAR25	CHAR	25	0	Field NAME2 in Upper Case
105	SOURCE	☐	BP_SOURCE	BP_SOURCE	CHAR	4	0	Source Key of Business Partner Data
106	CRUSER	☐	BP_CRUSER	SYCHAR12	CHAR	12	0	Entered by
107	CRDAT	☐	BP_CRDAT	DATUM	DATS	8	0	Creation Date
108	VIP	☐	BP_VIP	PAVIP	CHAR	1	0	Business Partner: VIP Partner	TVIP
109	GROUP_D	☐	BP_GROUP_D	BP_GROUP_D	CHAR	4	0	Target Group	TP13
110	DEL_IND	☐	BP_DEL_IND	XFELD	CHAR	1	0	Deletion Flag
111	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
112	XTITLE	☐	BP_XTITLE	TEXT50	CHAR	50	0	Text of Form of Address
113	XTIT_LE	☐	BP_XTIT_LE	TEXT50	CHAR	50	0	Salutation
114	PAR_REL	☐	BP_PAR_REL	BP_PAR_REL	CHAR	1	0	Business Partner Released
115	.INCLUDE	☐				0	0	BP: Attributes of Natural Persons
116	NAME_LAST	☐	BP_NAMLAST	TEXT40	CHAR	40	0	Last Name
117	NAME_FIRST	☐	BP_NAMFRST	TEXT40	CHAR	40	0	First Name
118	TITLE_AC	☐	BP_TITL_AC_OLD	TEXT20	CHAR	20	0	Academic Title
119	N_PREFIX	☐	BP_PREFIX_OLD	TEXT20	CHAR	20	0	Name Prefix
120	N_ADDITION	☐	BP_ADDITN_OLD	TEXT20	CHAR	20	0	Name Affix
121	NICKNAME	☐	BP_NICKNAM	TEXT20	CHAR	20	0	Known As
122	SEX	☐	BP_SEX_OLD	BP_SEX	CHAR	1	0	Gender of Business Partner
123	PROFESSION	☐	BP_PROFESS_OLD	TEXT40	CHAR	40	0	Description of Occupation for Business Partner
124	NATION	☐	BP_CNTR_N	LAND1	CHAR	3	0	Nationality	T005
125	STATE	☐	BP_CNTR_ST	LAND1	CHAR	3	0	Citizenship	T005
126	BIRTH_DATE	☐	BP_BIRTHD	DATUM	DATS	8	0	Date of Birth of Business Partner
127	BIRTH_PLAC	☐	BP_BIRTHPL	TEXT40	CHAR	40	0	Birthplace
128	BIRTH_NAME	☐	BP_BIRTHNA	TEXT40	CHAR	40	0	Name at Birth
129	BIRTH_N_AD	☐	BP_BIRTH_A	TEXT40	CHAR	40	0	Name at Birth Affix
130	DEATH_DATE	☐	BP_DEATH_D	DATUM	DATS	8	0	Date of Death
131	MARITAL_ST	☐	BP_MARITAL_OLD	BP_MARITAL	NUMC	2	0	Marital Status	TP03
132	PROPRTY_ST	☐	BP_PROPRTY_OLD	BP_PROPRTY	NUMC	2	0	Marital property regime	TP04
133	CHILDREN	☐	BP_CHILDRN	DEC2	DEC	2	0	Number of Children Belonging to the Business Partner
134	MEM_HOUSE	☐	BP_MEM_HOU	DEC2	DEC	2	0	Number of People Living in the Household
135	INCOME_CUR	☐	BP_INC_CUR	WAERS	CUKY	5	0	Currency of Net Income	TCURC
136	NET_INCOME	☐	BP_NET_INC	WERTV8	CURR	15	2	Net Annual Income
137	MO_NET_INC	☐	BP_MO_INC	WERTV8	CURR	15	2	Monthly Net Income of Business Partner
138	NET_INC_Y	☐	BP_N_INC_Y	GJAHR	NUMC	4	0	Year of Net Annual Income
139	MO_INC_M	☐	BP_M_INC_M	BP_M_INC_M	NUMC	2	0	Calendar Month of Monthly Net Income
140	MO_INC_Y	☐	BP_M_INC_Y	GJAHR	NUMC	4	0	Year of Monthly Net Income
141	PERS_NR	☐	BP_PERS_NR	CHAR15	CHAR	15	0	Personnel Number
142	STAFF_GRP	☐	BP_STAFF_G	BP_STAFF_G	CHAR	4	0	Employee Group	TP05
143	HR_ORG_REF	☐	HR_ORG_REF	XFELD	CHAR	1	0	HR Org. Link
144	XUBNAME	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	USR02
145	STAFF_REF	☐	BP_STAFF_R	XFELD	CHAR	1	0	Employee
146	.INCLUDE	☐				0	0	BP: Attributes of Organizations
147	ORG_NAME	☐	BP_NAME1	TEXT40	CHAR	40	0	Name 1 (surname for persons, otherwise company name)
148	ORG_NAME2	☐	BP_NAME2	TEXT40	CHAR	40	0	Name 2 (Continuation of NAME 1)
149	CALENDARID	☐	BP_CAL_ID	WFCID	CHAR	2	0	Factory calendar	TFACD
150	LEGAL_ENTY	☐	BP_LEG_ETY_OLD	BP_LEG_ETY	NUMC	2	0	Legal Form of Organization	TP08
151	LEGAL_ORG	☐	BP_LEG_ORG_OLD	BP_LEG_ORG	NUMC	2	0	Legal Entity of Organization	TP09
152	BALANCE_FL	☐	BP_BAL_FLG	BP_BAL_FLG	CHAR	1	0	Balance Sheet Display
153	FOUND_YEAR	☐	BP_FOUND_Y	GJAHR	NUMC	4	0	Foundation Year of Organization
154	COMM_REGIS	☐	BP_COM_REG	TEXT50	CHAR	50	0	Entry in Commercial Register
155	COMM_REG_D	☐	BP_COM_R_D	DATUM	DATS	8	0	Date of Entry in Commercial Register
156	CNTRY_COMP	☐	BP_CNTR_HD	LAND1	CHAR	3	0	Country of Organization's Registered Office	T005
157	REGIO	☐	BP_REGIO_HD	REGIO	CHAR	3	0	Region of Registered Office	T005S
158	COMP_HEAD	☐	BP_COMP_HD	TEXT35	CHAR	35	0	Registered Office
159	LIQUID_DAT	☐	BP_LIQUI_D	DATUM	DATS	8	0	Date of Liquidation
160	COMP_NR	☐	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
161	COMP_NR_AD	☐	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
162	BUBKZ	☐	BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
163	IND_SECTOR	☐	BP_BRSCH_OLD	BRSCH	CHAR	4	0	Industry Keys	T016
164	MIN_RESERV	☐	BP_MIN_RSV	XFELD	CHAR	1	0	Bank Subject to Minimum Reserve Requirement
165	BAL_SH_CUR	☐	BP_BAL_CUR	WAERS	CUKY	5	0	Balance Sheet Currency	TCURC
166	CAP_INCR_A	☐	BP_CA_IN_A	WERTV8	CURR	15	2	Amount of last capital increase
167	CAP_INCR_Y	☐	BP_CA_IN_Y	GJAHR	NUMC	4	0	Year of Last Capital Increase
168	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
169	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	*
170	.INCLU--AP	☐				0	0	BP: Attribute switch-off parallel maintenance
171	NO_CONVBP0	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
172	NAME1ORG	☐	NAME1_ADRS	TEXT40	CHAR	40	0	Name 1 of an address
173	NAME2ORG	☐	NAME2_ADRS	TEXT40	CHAR	40	0	Name 2 of an address
174	STRASORG	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
175	PSTLZORG	☐	PSTLZ_BAS	PSTLZ	CHAR	10	0	Postal code
176	ORT01ORG	☐	ORT01_GP	TEXT35	CHAR	35	0	City
177	TELF1SBE	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
178	TELF2SBE	☐	TELF2	TEXT16	CHAR	16	0	Second telephone number
179	.INCLU--AP	☐				0	0	Append Structure for MHNK_TRLO
180	DUNNING_COUNT	☐	TB_DUNNING_COUNT	NUM3	NUMC	3	0	No.of Dunning Notices Since Dunning Level 0 (Correspondence)
181	DUNNING_HIGHEST	☐	TB_DUNNING_HIGHEST	CHAR1	CHAR	1	0	Highest Dunning Level Since Dunning Level 0 (for Corresp.)
182	DUNNING_LST_LVL	☐	TB_DUNNING_LAST_LEVEL	CHAR1	CHAR	1	0	Last Dunning Level (for Correspondence)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MHNK_TRLO	ADR_REF	TP14	ADR_REF
2	MHNK_TRLO	BAL_SH_CUR	TCURC	WAERS
3	MHNK_TRLO	CALENDARID	TFACD	IDENT
4	MHNK_TRLO	CNTRY_COMP	T005	LAND1
5	MHNK_TRLO	GROUP_D	TP13	GROUP_D	KEY	1	CN
6	MHNK_TRLO	GROUP_ID	TPZ2	GROUP_ID	KEY	1	CN
7	MHNK_TRLO	INCOME_CUR	TCURC	WAERS	KEY	1	CN
8	MHNK_TRLO	IND_SECTOR	T016	BRSCH
9	MHNK_TRLO	LANGU	T002	SPRAS	KEY	1	CN
10	MHNK_TRLO	LEGAL_ENTY	TP08	LEGAL_ENTY
11	MHNK_TRLO	LEGAL_ORG	TP09	LEGAL_ORG
12	MHNK_TRLO	MANDTBP0	T000	MANDT	KEY	1	CN
13	MHNK_TRLO	MARITAL_ST	TP03	MARITAL_ST	KEY	1	CN
14	MHNK_TRLO	NATION	T005	LAND1	KEY	1	CN
15	MHNK_TRLO	PERSNUMBER	ADRP	PERSNUMBER	KEY
16	MHNK_TRLO	PROPRTY_ST	TP04	PROPRTY_ST	KEY	1	CN
17	MHNK_TRLO	REGIO	T005S	BLAND	KEY
18	MHNK_TRLO	STAFF_GRP	TP05	STAFF_GRP	KEY	1	CN
19	MHNK_TRLO	STATE	T005	LAND1	KEY	1	CN
20	MHNK_TRLO	TITLE	TP01	TITLE	KEY	1	CN
21	MHNK_TRLO	TITLE_LET	TP02	TITLE_LET	KEY	1	CN
22	MHNK_TRLO	VIP	TVIP	PAVIP	KEY	1	CN
23	MHNK_TRLO	XUBNAME	USR02	BNAME	KEY	1	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in