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