SAP ABAP Table JBIUPA1 (TR Business partner transfer - external fields (3.0 BP))

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	JBIUPA1	Table Relationship Diagram
Short Description	TR Business partner transfer - external fields (3.0 BP)

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
2	PARTNR	☐	BP_PARTNR_OLD	BP_PARTNR	CHAR	10	0	Business Partner Number	BP000
3	STYPE	☐	STYPEGP	STYPEGP	CHAR	1	0	Record Type for TR External Data Transfer: Business Partner
4	SFEMODE	☐	TRUBMODE	TRUBMODE	CHAR	1	0	Transfer mode
5	KLASSE	☐	BP_TYPE_OLD	BP_TYPE	CHAR	1	0	Partner category
6	MIGDATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
7	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
8	AKONT	☐	AKONT	SAKNR	CHAR	10	0	Reconciliation Account in General Ledger	SKA1
9	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
10	STRA1	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
11	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
12	ORT02	☐	ORT02_GP	TEXT35	CHAR	35	0	District
13	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
14	PSTBZ	☐	PSTBZ	PSTBZ	CHAR	15	0	Post delivery district
15	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
16	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
17	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
18	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
19	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
20	XEZER	☐	XEZER	XFELD	CHAR	1	0	Indicator: Is there collection authorization ?
21	BKREF	☐	BKREF	CHAR20	CHAR	20	0	Reference specifications for bank details
22	KOINH	☐	KOINH_FI	KOINH	CHAR	60	0	Account Holder Name
23	ADR_REF_K	☐	BP_ADR_REF_OLD	BP_ADR_REF	CHAR	10	0	Address ID	TP14
24	ADR_DAT	☐	BP_ADR_DAT	DATUM	DATS	8	0	Business partner address relationship valid from
25	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
26	ROLE	☐	BP_ROLE	BP_ROLE	CHAR	4	0	Business Partner Role Type	TPZ6
27	ROLETYP	☐	BP_ROLETYP_OLD	BP_ROLETYP	CHAR	4	0	Business Partner Role Category	TPZ3
28	AUTHORITY	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group	TBRG
29	DEL_INDRO	☐	BP_DEL_IND	XFELD	CHAR	1	0	Deletion Flag
30	ERDAT	☐	ERDAT_RF	DATUM	DATS	8	0	Date on which the Record Was Created
31	ERNAM	☐	ERNAM_RF	USNAM	CHAR	12	0	Name of Person who Created the Object
32	BANKA	☐	BANKA	TEXT60	CHAR	60	0	Name of bank
33	PROVZ	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
34	SWIFT	☐	SWIFT	SWIFT	CHAR	11	0	SWIFT/BIC for International Payments
35	BGRUP	☐	BGRUP	BGRUP	CHAR	2	0	Bank group (bank network)
36	XPGRO	☐	XPGRO	XFELD	CHAR	1	0	Post Office Bank Current Account
37	LOEVM	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator
38	BNKLZ	☐	BANKL	BANKL	CHAR	15	0	Bank number
39	PSKTO	☐	PSKTO_CH	PSKTO	CHAR	16	0	Post office bank current account number
40	BRNCH	☐	BRNCH	TEXT40	CHAR	40	0	Bank Branch
41	KNRZB	☐	KNRZB	KUNNR	CHAR	10	0	Account number of an alternative payer	KNA1
42	ZWELS	☐	DZWELS	ZWELS	CHAR	10	0	List of the Payment Methods to be Considered
43	ZAHLS	☐	DZAHLS	ZAHLS	CHAR	1	0	Block Key for Payment	T008
44	WEBTR	☐	UB_WEBTR	NUM13	NUMC	13	0	Bill of Exchange Limit (in Local Currency)
45	N_WEBTR	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
46	REMIT	☐	REMIT	KUNNR	CHAR	10	0	Next payee	KNA1
47	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	T012
48	XPORE	☐	XPORE	XFELD	CHAR	1	0	Indicator: Pay all items separately ?
49	ZGRUP	☐	DZGRUP	ZGRUP	CHAR	2	0	Key for Payment Grouping	TZGR
50	LOCKB	☐	LOCKB	LCKID	CHAR	7	0	Key of the Lockbox to Which the Customer Is To Pay	T049L
51	UZAWE	☐	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	T042F
52	EXTPARTNR	☐	BP_EXT_PNR	CHAR15	CHAR	15	0	External Business Partner ID
53	TYPE	☐	BP_TYPE_OLD	BP_TYPE	CHAR	1	0	Partner category
54	GROUP_ID	☐	BP_GRP_ID_OLD	BP_GRP_ID	CHAR	4	0	Business Partner Grouping	TPZ2
55	NAME1	☐	BP_NAME1	TEXT40	CHAR	40	0	Name 1 (surname for persons, otherwise company name)
56	NAME2	☐	BP_NAME2	TEXT40	CHAR	40	0	Name 2 (Continuation of NAME 1)
57	LANGU	☐	UB_LANGU	CHAR1	CHAR	1	0	Language Key
58	TITLE	☐	BP_TITLE_OLD	BP_TITLE	NUMC	2	0	Form of Address (Key)	TP01
59	TITLE_LET	☐	BP_TITL_LT	BP_TITL_LT	NUMC	2	0	Salutation	TP02
60	ADR_REF	☐	BP_ADR_REF_OLD	BP_ADR_REF	CHAR	10	0	Address ID	TP14
61	SORT1	☐	BP_SORT1	CHAR20	CHAR	20	0	Sort Field 1
62	SORT2	☐	BP_SORT2	CHAR20	CHAR	20	0	Sort Field 2
63	SORT_PHON	☐	BP_SORT_PH	CHAR20	CHAR	20	0	Sort Field for Phonetic Search; Obsolete
64	MC_NAME1	☐	BP_MC_NAM1	CHAR25	CHAR	25	0	Field NAME1 in Upper Case
65	MC_NAME2	☐	BP_MC_NAM2	CHAR25	CHAR	25	0	Field NAME2 in Upper Case
66	SOURCE	☐	BP_SOURCE	BP_SOURCE	CHAR	4	0	Source Key of Business Partner Data
67	CRUSER	☐	BP_CRUSER	SYCHAR12	CHAR	12	0	Entered by
68	CRDAT	☐	BP_CRDAT	DATUM	DATS	8	0	Creation Date
69	VIP	☐	BP_VIP	PAVIP	CHAR	1	0	Business Partner: VIP Partner	TVIP
70	GROUP_D	☐	BP_GROUP_D	BP_GROUP_D	CHAR	4	0	Target Group	TP13
71	DEL_IND	☐	BP_DEL_IND	XFELD	CHAR	1	0	Deletion Flag
72	ZUAWA	☐	DZUAWA	ZUAWA	CHAR	3	0	Key for sorting according to assignment numbers	TZUN
73	FDGRV	☐	FDGRV	FDGRP	CHAR	10	0	Planning group	T035
74	BLNKZ	☐	BLNKZ	BLNKZ	CHAR	2	0	Subsidy Indicator for Determining the Reduction Rates	T057
75	KNRZE	☐	KNRZE	KUNNR	CHAR	10	0	Head office account number (in branch accounts)	KNA1
76	XTITLE	☐	BP_XTITLE	TEXT50	CHAR	50	0	Text of Form of Address
77	XTIT_LE	☐	BP_XTIT_LE	TEXT50	CHAR	50	0	Salutation
78	PAR_REL	☐	BP_PAR_REL	BP_PAR_REL	CHAR	1	0	Business Partner Released
79	NAME_LAST	☐	BP_NAMLAST	TEXT40	CHAR	40	0	Last Name
80	NAME_FIRST	☐	BP_NAMFRST	TEXT40	CHAR	40	0	First Name
81	TITLE_AC	☐	BP_TITL_AC	TEXT20	CHAR	20	0	Academic Title
82	N_PREFIX	☐	BP_PREFIX	TEXT20	CHAR	20	0	Name Prefix
83	N_ADDITION	☐	BP_ADDITN	TEXT20	CHAR	20	0	Name Affix
84	NICKNAME	☐	BP_NICKNAM	TEXT20	CHAR	20	0	Known As
85	SEX	☐	BP_SEX_OLD	BP_SEX	CHAR	1	0	Gender of Business Partner
86	PROFESSION	☐	BP_PROFESS	TEXT40	CHAR	40	0	Description of Occupation for Business Partner
87	NATION	☐	BP_CNTR_N	LAND1	CHAR	3	0	Nationality	T005
88	STATE	☐	BP_CNTR_ST	LAND1	CHAR	3	0	Citizenship	T005
89	BIRTH_DATE	☐	BP_BIRTHD	DATUM	DATS	8	0	Date of Birth of Business Partner
90	BIRTH_PLAC	☐	BP_BIRTHPL	TEXT40	CHAR	40	0	Birthplace
91	BIRTH_NAME	☐	BP_BIRTHNA	TEXT40	CHAR	40	0	Name at Birth
92	BIRTH_N_AD	☐	BP_BIRTH_A	TEXT40	CHAR	40	0	Name at Birth Affix
93	DEATH_DATE	☐	BP_DEATH_D	DATUM	DATS	8	0	Date of Death
94	MARITAL_ST	☐	BP_MARITAL	BU_MARST	CHAR	1	0	Marital Status	TB027
95	PROPRTY_ST	☐	BP_PROPRTY	BP_PROPRTY	NUMC	2	0	Marital Property Regime	TP04
96	CHILDREN	☐	UB_CHILDRN	NUMC2	NUMC	2	0	Number of Children (External Data Transfer)
97	MEM_HOUSE	☐	UB_MEM_HOU	NUMC2	NUMC	2	0	Number of Household Members (External Data Transfer)
98	INCOME_CUR	☐	UB_BP_INC_CUR	CHAR5	CHAR	5	0	Currency of Net Income
99	NET_INCOME	☐	UB_NET_INC	NUM15	NUMC	15	0	Annual Net Income (External Data Transfer)
100	N_NET_INCOME	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
101	MO_NET_INC	☐	UB_MO_INC	NUM15	NUMC	15	0	Monthly Net Income of Business Partner
102	N_MO_NET_INC	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
103	NET_INC_Y	☐	BP_N_INC_Y	GJAHR	NUMC	4	0	Year of Net Annual Income
104	MO_INC_M	☐	BP_M_INC_M	BP_M_INC_M	NUMC	2	0	Calendar Month of Monthly Net Income
105	MO_INC_Y	☐	BP_M_INC_Y	GJAHR	NUMC	4	0	Year of Monthly Net Income
106	PERS_NR	☐	BP_PERS_NR	CHAR15	CHAR	15	0	Personnel Number
107	STAFF_GRP	☐	BP_STAFF_G	BP_STAFF_G	CHAR	4	0	Employee Group	TP05
108	HR_ORG_REF	☐	HR_ORG_REF	XFELD	CHAR	1	0	HR Org. Link
109	XUBNAME	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	USR02
110	STAFF_REF	☐	BP_STAFF_R	XFELD	CHAR	1	0	Employee
111	ORG_NAME	☐	BP_NAME1	TEXT40	CHAR	40	0	Name 1 (surname for persons, otherwise company name)
112	ORG_NAME2	☐	BP_NAME2	TEXT40	CHAR	40	0	Name 2 (Continuation of NAME 1)
113	CALENDARID	☐	BP_CAL_ID	WFCID	CHAR	2	0	Factory calendar	TFACD
114	LEGAL_ENTY	☐	BP_LEG_ETY_OLD	BP_LEG_ETY	NUMC	2	0	Legal Form of Organization	TP08
115	LEGAL_ORG	☐	BP_LEG_ORG_OLD	BP_LEG_ORG	NUMC	2	0	Legal Entity of Organization	TP09
116	BALANCE_FL	☐	BP_BAL_FLG	BP_BAL_FLG	CHAR	1	0	Balance Sheet Display
117	FOUND_YEAR	☐	BP_FOUND_Y	GJAHR	NUMC	4	0	Foundation Year of Organization
118	COMM_REGIS	☐	BP_COM_REG	TEXT50	CHAR	50	0	Entry in Commercial Register
119	COMM_REG_D	☐	BP_COM_R_D	DATUM	DATS	8	0	Date of Entry in Commercial Register
120	CNTRY_COMP	☐	BP_CNTR_HD	LAND1	CHAR	3	0	Country of Organization's Registered Office	T005
121	COMP_HEAD	☐	BP_COMP_HD	TEXT35	CHAR	35	0	Registered Office
122	LIQUID_DAT	☐	BP_LIQUI_D	DATUM	DATS	8	0	Date of Liquidation
123	COMP_NR	☐	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
124	COMP_NR_AD	☐	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
125	BUBKZ	☐	BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
126	IND_SECTOR	☐	BP_SECTOR	BU_INDSECT	CHAR	10	0	Business Partner: Industry (Organization)	TB023
127	MIN_RESERV	☐	BP_MIN_RSV	XFELD	CHAR	1	0	Bank Subject to Minimum Reserve Requirement
128	BAL_SH_CUR	☐	UB_BP_BAL_CUR	CHAR5	CHAR	5	0	Balance Sheet Currency
129	CAP_INCR_A	☐	UB_CA_IN_A	NUM15	NUMC	15	0	Amount of Last Capital Increase
130	N_CAP_INCR_A	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
131	CAP_INCR_Y	☐	BP_CA_IN_Y	GJAHR	NUMC	4	0	Year of Last Capital Increase
132	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
133	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
134	ADRNR	☐	BP_ADRNR	SADRNR	CHAR	10	0	Address Number	SANS1
135	ADR_D_E	☐	BP_ADR_D_E	DATUM	DATS	8	0	Business Partner Address Relationship Valid Until
136	ADR_LOC	☐	BP_ADR_LOC	CHAR20	CHAR	20	0	Building
137	FLOOR	☐	BP_FLOOR	CHAR10	CHAR	10	0	Floor
138	ROOM_NR	☐	BP_ROOM_NR	CHAR10	CHAR	10	0	Room Number
139	NAME3	☐	BP_NAME3	TEXT40	CHAR	40	0	Name 3
140	NAME4	☐	BP_NAME4	TEXT40	CHAR	40	0	Name 4
141	NAME_CO	☐	BP_NAME_CO	TEXT40	CHAR	40	0	c/o Name
142	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
143	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
144	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
145	TELF2	☐	TELF2	TEXT16	CHAR	16	0	Second telephone number
146	TELFX1	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
147	TELFX2	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
148	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
149	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
150	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
151	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
152	EMPL_SINCE	☐	EMPL_DATE	DATUM	DATS	8	0	Employed from
153	EMPL_UNTIL	☐	BP_EMP_UNT	DATUM	DATS	8	0	Employed Until
154	EMPLOYMENT	☐	BP_EMPLOYM	BP_EMPLOYM	NUMC	2	0	Employment Status	TP11
155	EMP_SECTOR	☐	EMP_SECTOR	BU_INDSECT	CHAR	10	0	Industry; Only Relevant for Real Estate Business Partner	TB023
156	EMPLOYER	☐	EMPLOYER	TEXT35	CHAR	35	0	Employer
157	BUSINESS_Y	☐	BP_BUSIN_Y	GJAHR	NUMC	4	0	Fiscal year
158	GEN_MEET_D	☐	BP_GE_ME_D	DATUM	DATS	8	0	Date of Annual Stockholders Meeting
159	BU_Y_BEGIN	☐	BP_B_Y_BEG	DATUM	DATS	8	0	Fiscal Year Start Date
160	BU_Y_END	☐	BP_B_Y_END	DATUM	DATS	8	0	Fiscal Year End Date
161	ANNUAL_ACC	☐	BP_ANN_ACC	XFELD	CHAR	1	0	Year-End Closing
162	ANNU_ACC_D	☐	BP_A_ACC_D	DATUM	DATS	8	0	Year-End Closing Date for Fiscal Year
163	CONS_FST_D	☐	BP_C_FST_D	DATUM	DATS	8	0	Date of Consolidated Financial Statements of Group Company
164	CAPI_STOCK	☐	UB_CAP_STK	NUM15	NUMC	15	0	Authorized Capital Stock (External Data Transfer)
165	N_CAPI_STOCK	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
166	SHAR_STOCK	☐	UB_SHA_STK	NUM15	NUMC	15	0	Stock Capital Issued (External Data Transfer)
167	N_SHAR_STOCK	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
168	PRSH_STOCK	☐	UB_PRS_STK	NUM15	NUMC	15	0	Participation Certificates Outstanding (Ext. Data Transfer)
169	N_PRSH_STOCK	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
170	EQUITY	☐	UB_EQUITY	NUM15	NUMC	15	0	Equity Capital
171	N_EQUITY	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
172	GROSS_AMNT	☐	UB_GROSS_A	NUM15	NUMC	15	0	Gross Contribution
173	N_GROSS_AMNT	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
174	NET_AMOUNT	☐	UB_NET_A	NUM15	NUMC	15	0	Net Contribution
175	N_NET_AMOUNT	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
176	TURNOVER	☐	UB_TURNOVR	NUM15	NUMC	15	0	Annual Sales
177	N_TURNOVER	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
178	DIV_DIS_AM	☐	UB_DIV_DIS	NUM15	NUMC	15	0	Dividend/Profit Distribution Amount
179	N_DIV_DIS_AM	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
180	DEBTS_FACT	☐	UB_DEBTS_F	NUM06	NUMC	6	0	Debt Ratio
181	N_DEBTS_FACT	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
182	DIS_PROFIT	☐	UB_PROFIT	NUM15	NUMC	15	0	Profit Reported by Organization
183	N_DIS_PROFIT	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
184	BAL_AMOUNT	☐	UB_BAL_AMT	NUM15	NUMC	15	0	Balance Sheet Total
185	N_BAL_AMOUNT	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
186	REL_TYP	☐	BP_REL_TYP_OLD	BP_REL_TYP	CHAR	4	0	Business Partner Relationship Category	TPZ7
187	PARTNR2	☐	BP_PARTNR_OLD	BP_PARTNR	CHAR	10	0	Business Partner Number	BP000
188	DIF_TYP1	☐	BP_DIF_TYP	BP_DIF_TYP	CHAR	4	0	Business Partner - Differentiation Category	TPZ8
189	DIF_TYP2	☐	BP_DIF_TYP	BP_DIF_TYP	CHAR	4	0	Business Partner - Differentiation Category	TPZ8
190	REL_DAT	☐	BP_REL_DAT	DATUM	DATS	8	0	Start of Validity of BP-BP Relationship
191	RELAT	☐	BP_RELAT_OLD	BP_RELAT	CHAR	4	0	Relationship Type	TPZ11
192	REL_END	☐	BP_REL_END	DATUM	DATS	8	0	End of Validity of BP-BP Relationship
193	REL_PER	☐	UB_REL_PER	NUM10	NUMC	10	0	Percentage Rate of Relationship
194	N_REL_PER	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
195	REL_AMO	☐	UB_REL_AMO	NUM13	NUMC	13	0	Relationship Amount
196	N_REL_AMO	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
197	REL_CUR	☐	UB_WHR	CHAR5	CHAR	5	0	Currency ISO code
198	FUNCTN	☐	BP_FUNCTN	BU_PAFKT	CHAR	4	0	Partner Function	TB912
199	DEPART	☐	BP_DEPART	BU_ABTNR	CHAR	4	0	Business Partner's Department	TB910
200	.INCLUDE	☐				0	0	BP: Attributes of Account Control (Subledger)
201	KONZS	☐	KONZS	KONZS	CHAR	10	0	Group key
202	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
203	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
204	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group	TBRG
205	.INCLUDE	☐				0	0	BP: Attributes of Payment Control
206	XZEMP	☐	XZEMP	XFELD	CHAR	1	0	Indicator: Alternative payee in document allowed ?
207	KNRZA	☐	KNRZA	KUNNR	CHAR	10	0	Account number of an alternative payer	*
208	DTAMS	☐	DTAMS	DTAMS	CHAR	1	0	Report key for data medium exchange
209	DTAWS	☐	DTAWS	DTAWS	CHAR	2	0	Instruction key for data medium exchange	*
210	ESRNR	☐	ESRNR	ESRNR	CHAR	11	0	POR subscriber number
211	.INCLUDE	☐				0	0	BP: Attributes of General Control Data
212	PART_CO	☐	BP_PART_CO	BUKRS	CHAR	4	0	Partner-Company Code Allocation	*
213	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
214	MAHNA	☐	MAHNA	MAHNA	CHAR	4	0	Dunning Procedure	T047A
215	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
216	MADAT	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
217	MAHNS	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
218	KNRMA	☐	KNRMA	KUNNR	CHAR	10	0	Account number of the dunning recipient	KNA1
219	GMVDT	☐	GMVDT	DATUM	DATS	8	0	Date of the legal dunning proceedings
220	BUSAB	☐	BUSAB_MA	BUSAB	CHAR	2	0	Dunning clerk	T001S
221	MGRUP	☐	MGRUP	MGRUP	CHAR	2	0	Key for dunning notice grouping	T047R
222	.INCLUDE	☐				0	0	BP: Attributes of Credit Standing Data
223	DE_OATH	☐	BP_DE_OATH	XFELD	CHAR	1	0	Affidavit
224	DE_OA_D	☐	BP_DE_OA_D	DATUM	DATS	8	0	Date of affidavit
225	BANKRUP	☐	BP_BANKRUP	XFELD	CHAR	1	0	Launch Bankruptcy Proceedings
226	BNKRY_D	☐	BP_BNKRY_D	DATUM	DATS	8	0	Commencement Date of Bankruptcy Proceedings
227	FORECLO	☐	BP_FORECLO	XFELD	CHAR	1	0	Foreclosure
228	FORCL_D	☐	BP_FORCL_D	DATUM	DATS	8	0	Date of foreclosure
229	SOLVNCY	☐	BP_SOLVNCY	BP_SOLVNCY	CHAR	1	0	Credit Standing
230	SOL_INS	☐	BP_SOL_INS	BP_SOL_INS	CHAR	4	0	Institute Providing Credit Standing Information	*
231	SOL_INF	☐	BP_SOL_INF	BP_SOL_INF	CHAR	1	0	Status of Credit Standing Information
232	SOL_TXT	☐	BP_SOL_TXT	TEXT50	CHAR	50	0	Additional Credit Standing Information
233	SOL_I_D	☐	BP_SOL_I_D	DATUM	DATS	8	0	Date of Credit Standing Information
234	RATING	☐	BP_RATING	BP_RATING	CHAR	3	0	Rating	*
235	.INCLUDE	☐				0	0	BP: Attributes of Reporting Data
236	NRESIDT	☐	BP_NRESIDT	XFELD	CHAR	1	0	Non-Resident According to Paragraph 4 AWG
237	NRESI_D	☐	BP_NRESI_D	DATUM	DATS	8	0	Start of Non-Residency According to Paragraph 4 AWG
238	KWG_RLV	☐	BP_KWG_RLV	XFELD	CHAR	1	0	Recipient of Multimillion Loan According to Paragraph 14 GBA
239	KWG_NR	☐	BP_KWG_NR	CHAR8	CHAR	8	0	Borrower Number for Reporting a Loan According to GBA
240	KWG_ENR	☐	BP_KWG_ENR	CHAR8	CHAR	8	0	Borrower Entity Number Used to Report Loan acc. to GBA
241	KWG_CRE	☐	BP_KWG_CRE	BP_KWG_CRE	NUMC	2	0	Credit Standing Review According to Paragraph 18 GBA	TP12
242	KWG_CRE_D	☐	BP_KWG_CRE_D	DATUM	DATS	8	0	Date of Credit Standing Review According to Paragraph 18 GBA
243	KWG_ORG	☐	BP_KWG_ORG	BP_KWG_ORG	NUMC	2	0	Loan to Manager According to Paragraph 15 German Banking Act	*
244	COMP_RE	☐	BP_COMP_RE	BP_COMP_RE	CHAR	1	0	Organization Relationship
245	.INCLUDE	☐				0	0	Business Partner: Reporting Data Austria
246	XID_AT	☐	VVXID_AT_FS	VVXID_AT_FS	CHAR	11	0	(OeNB) Ident Number
247	SZG_AT	☐	VVSZG_AT_FS	VVSZG_AT_FS	CHAR	2	0	Target Group According to OeNB	TD05_AT_FS
248	SID_AT	☐	VVSID_AT_FS	BP_JANEI	CHAR	1	0	Assign (OeNB) Ident Number
249	SINLZ_AT	☐	VVSINLZ_AT	VVSINLZ_AT	CHAR	7	0	Institute Number According to OeNB
250	SINME_AT	☐	VVSINME_AT	XFELD	CHAR	1	0	Institute Subject to Austrian Reg. Reporting Requirements
251	GID_AT	☐	VVGID_AT		CHAR	15	0	Group ID
252	GIDTYPE_AT	☐	VVGIDTYPE_AT	VVGIDTYPE_AT	CHAR	1	0	Group Assignment Category
253	GNAME_AT	☐	VVGNAME_AT	TEXT50	CHAR	50	0	Group Name
254	BAL_SH	☐	BP_BAL_SH	BP_BAL_SH	CHAR	1	0	Balance Sheet Display
255	.INCLUDE	☐				0	0	BP: Atttributes of Int. Calculation (Company Code)
256	VZSKZ	☐	VZSKZ	VZSKZ	CHAR	2	0	Interest calculation indicator	*
257	ZINDT	☐	DZINDT	DATUM	DATS	8	0	Key date of the last interest calculation
258	ZINRT	☐	DZINRT	ZINRT	NUMC	2	0	Interest calculation frequency in months
259	DATLZ	☐	DATLZ	DATUM	DATS	8	0	Date of the last interest calculation run
260	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
261	WAKON	☐	WAKON	ZTERM	CHAR	4	0	Terms of payment key for bill of exchange charges
262	XZVER	☐	XZVER	XFELD	CHAR	1	0	Indicator: Record Payment History ?
263	TOGRU	☐	TOGRU	TOGRU	CHAR	4	0	Tolerance group for the business partner/G/L account	*
264	KULTG	☐	UB_KULTG	NUMC3	NUMC	3	0	Probable Time Until Check Is Encashed
265	URLID	☐	URLID	URLID	CHAR	4	0	Short Key for Known/Negotiated Leave	*
266	.INCLUDE	☐				0	0	BP: Attributes of Fiscal Data
267	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
268	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
269	TAX_RES	☐	BP_TAX_RES	XFELD	CHAR	1	0	Tax Non-Resident Indicator
270	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	*
271	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	*
272	STKZA	☐	STKZA	STKZA	CHAR	1	0	Indicator: Business Partner Subject to Equalization Tax?
273	STKZU	☐	STKZU	XFELD	CHAR	1	0	Liable for VAT
274	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
275	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
276	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
277	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
278	FISKN	☐	FISKN_D	KUNNR	CHAR	10	0	Account number of the master record with the fiscal address	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JBIUPA1	ADRNR	SANS1	ADRNR		1	CN
2	JBIUPA1	ADR_REF	TP14	ADR_REF
3	JBIUPA1	ADR_REF_K	TP14	ADR_REF
4	JBIUPA1	AKONT	SKA1	SAKNR
5	JBIUPA1	AUTHORITY	TBRG	BRGRU
6	JBIUPA1	BANKS	T005	LAND1
7	JBIUPA1	BEGRU	TBRG	BRGRU	KEY	1	CN
8	JBIUPA1	BLNKZ	T057	BLNKZ
9	JBIUPA1	BUKRS	T001	BUKRS
10	JBIUPA1	BUSAB	T001S	BUSAB
11	JBIUPA1	CALENDARID	TFACD	IDENT
12	JBIUPA1	CNTRY_COMP	T005	LAND1
13	JBIUPA1	DEPART	TB910	ABTNR
14	JBIUPA1	DIF_TYP1	TPZ8	DIF_TYP
15	JBIUPA1	DIF_TYP2	TPZ8	DIF_TYP
16	JBIUPA1	EMPLOYMENT	TP11	EMPLOYMENT	KEY	1	CN
17	JBIUPA1	EMP_SECTOR	TB023	IND_SECTOR	KEY	1	CN
18	JBIUPA1	FDGRV	T035	GRUPP
19	JBIUPA1	FUNCTN	TB912	PAFKT
20	JBIUPA1	GROUP_D	TP13	GROUP_D	KEY	1	CN
21	JBIUPA1	GROUP_ID	TPZ2	GROUP_ID
22	JBIUPA1	HBKID	T012	HBKID
23	JBIUPA1	IND_SECTOR	TB023	IND_SECTOR
24	JBIUPA1	KNRMA	KNA1	KUNNR
25	JBIUPA1	KNRZB	KNA1	KUNNR
26	JBIUPA1	KNRZE	KNA1	KUNNR
27	JBIUPA1	KUNNR	KNA1	KUNNR
28	JBIUPA1	KWG_CRE	TP12	KWG_CRE
29	JBIUPA1	LAND1	T005	LAND1
30	JBIUPA1	LEGAL_ENTY	TP08	LEGAL_ENTY
31	JBIUPA1	LEGAL_ORG	TP09	LEGAL_ORG
32	JBIUPA1	LOCKB	T049L	LOCKB
33	JBIUPA1	MABER	T047M	MABER
34	JBIUPA1	MAHNA	T047A	MAHNA
35	JBIUPA1	MANDT	T000	MANDT		1	CN
36	JBIUPA1	MANSP	T040S	MANSP
37	JBIUPA1	MARITAL_ST	TB027	MARST	KEY	1	CN
38	JBIUPA1	MGRUP	T047R	MGRUP
39	JBIUPA1	NATION	T005	LAND1	KEY	1	CN
40	JBIUPA1	PARTNR	BP000	PARTNR
41	JBIUPA1	PARTNR2	BP000	PARTNR
42	JBIUPA1	PROPRTY_ST	TP04	PROPRTY_ST	KEY	1	CN
43	JBIUPA1	PROVZ	T005S	BLAND
44	JBIUPA1	REGIO	T005S	BLAND
45	JBIUPA1	RELAT	TPZ11	RELAT
46	JBIUPA1	REL_TYP	TPZ7	REL_TYP
47	JBIUPA1	REMIT	KNA1	KUNNR
48	JBIUPA1	ROLE	TPZ6	ROLE
49	JBIUPA1	ROLETYP	TPZ3	ROLETYP
50	JBIUPA1	STAFF_GRP	TP05	STAFF_GRP	KEY	1	CN
51	JBIUPA1	STATE	T005	LAND1	KEY	1	CN
52	JBIUPA1	SZG_AT	TD05_AT_FS	SZG_AT	REF	1	CN
53	JBIUPA1	TITLE	TP01	TITLE
54	JBIUPA1	TITLE_LET	TP02	TITLE_LET	KEY	1	CN
55	JBIUPA1	UZAWE	T042F	UZAWE
56	JBIUPA1	VIP	TVIP	PAVIP	KEY	1	CN
57	JBIUPA1	XUBNAME	USR02	BNAME
58	JBIUPA1	ZAHLS	T008	ZAHLS
59	JBIUPA1	ZGRUP	TZGR	ZGRUP
60	JBIUPA1	ZUAWA	TZUN	ZUAWA

History

Last changed by/on	SAP	20130529
SAP Release Created in