SAP ABAP Table J11SPA1 (Send Structure for TR-EDT Receiver Structure JBIUPA1)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CML (Application Component) Loans Management
     ⤷ FVVD (Package) Treasury Loans

Basic Data

Table Category	INTTAB	Structure
Structure	J11SPA1	Table Relationship Diagram
Short Description	Send Structure for TR-EDT Receiver Structure JBIUPA1

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

History

Last changed by/on	SAP	20130529
SAP Release Created in