SAP ABAP Table ESALES_SETTYPE_PARTNER (Set type for business partner and contract account data)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-CS-CRM (Application Component) Integration: Customer Relationship Management
     ⤷ EE_SALES (Package) IS-U Sales Processing

Basic Data

Table Category	INTTAB	Structure
Structure	ESALES_SETTYPE_PARTNER	Table Relationship Diagram
Short Description	Set type for business partner and contract account data

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	PARTN_ROLE	☐	PARVW	PARVW	CHAR	2	0	Partner Role	*
2	.INCLUDE	☐				0	0	CBP: General Data (Read Transfer Structure)
3	.INCLUDE	☐				0	0	CBP: Read general data plus standard address
4	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
5	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
6	.INCLUDE	☐				0	0	BP: General Data I (Data Fields - External)
7	.INCLUDE	☐				0	0	CBP: General data (independent of partner cat.)
8	.INCLUDE	☐				0	0	CBP: General Data (not dep. on Part. Cat.), Initial Screen
9	TYPE	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
10	BPKIND	☐	BU_BPKIND	BU_KIND	CHAR	4	0	Business Partner Type	TB004
11	BU_GROUP	☐	BU_GROUP	BU_GROUP	CHAR	4	0	Business Partner Grouping	TB001
12	BPEXT	☐	BU_BPEXT	CHAR20	CHAR	20	0	Business Partner Number in External System
13	.INCLUDE	☐				0	0	CBP: General Data (not dep. on Part. Cat.), Data Screens
14	BU_SORT1	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
15	BU_SORT2	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
16	SOURCE	☐	BU_SOURCE	BU_SOURCE	CHAR	4	0	Data Origin Types	TB005
17	TITLE	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	TSAD3
18	XDELE	☐	BU_XDELE	XFELD	CHAR	1	0	Central Archiving Flag
19	XBLCK	☐	BU_XBLCK	XFELD	CHAR	1	0	Central Block for Business Partner
20	AUGRP	☐	BU_AUGRP	BU_AUGRP	CHAR	4	0	Authorization Group	*
21	TITLE_LET	☐	BU_TITLE_LET	TEXT50	CHAR	50	0	Salutation
22	BU_LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
23	CONTACT	☐	BU_CONTACT	BU_CONTACT	CHAR	1	0	Business Partner: Contact Permission
24	NOT_RELEASED	☐	BU_XNOT_RELEASED	XFELD	CHAR	1	0	Indicator: Not Released
25	NOT_LG_COMPETENT	☐	BU_NOT_LEG_COMPETENT	BOOLE	CHAR	1	0	Indicator: Not Legally Competent
26	PRINT_MODE	☐	BU_PRINT_MODE	BU_PRINT_MODE	CHAR	1	0	Business Partner Print Format
27	.INCLUDE	☐				0	0	EEW Extension of BUT000 (Contains CI)
28	BP_EEW_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
29	.INCLUDE	☐				0	0
30	.INCLU--AP	☐				0	0	Cost/Revenue Type in Resource Role
31	RATE	☐	DPR_TV_RATE	DPR_RATE_TYPE	CHAR	15	0	Cost Rate/Revenue Rate for Project Costing	DPR_RATES
32	.INCLUDE	☐				0	0	CBP: General data (Organization)
33	.INCLUDE	☐				0	0	CBP: General Data, Organization (CHAR Fields)
34	NAME_ORG1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
35	NAME_ORG2	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
36	NAME_ORG3	☐	BU_NAMEOR3	BU_NAME	CHAR	40	0	Name 3 of organization
37	NAME_ORG4	☐	BU_NAMEOR4	BU_NAME	CHAR	40	0	Name 4 of organization
38	LEGAL_ENTY	☐	BU_LEGENTY	BU_LEGENTY	CHAR	2	0	BP: Legal form of organization	TB019
39	IND_SECTOR	☐	BU_INDSECT	BU_INDSECT	CHAR	10	0	Industry sector	TB023
40	LEGAL_ORG	☐	BU_LEGAL_ORG	BU_LEGAL_ORG	CHAR	2	0	Legal Entity of Organization	TB032
41	.INCLUDE	☐				0	0	CBP: General Data, Organization (Non CHAR Fields)
42	FOUND_DAT	☐	BU_FOUND_DAT	DATUM	DATS	8	0	Date organization founded
43	LIQUID_DAT	☐	BU_LIQUID_DAT		DATS	8	0	Liquidation date of organization
44	LOCATION_1	☐	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
45	LOCATION_2	☐	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
46	LOCATION_3	☐	BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
47	.INCLUDE	☐				0	0	CBP: General Data, Person
48	.INCLUDE	☐				0	0	CBP: General Data, Person (CHAR Fields)
49	NAME_LAST	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
50	NAME_FIRST	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
51	NAME_LST2	☐	BU_NAMEPL2	BU_NAME	CHAR	40	0	Other Last Name of a Person
52	NAME_LAST2	☐	BU_BIRTHNM	BU_NAME	CHAR	40	0	Name at birth of business partner
53	NAMEMIDDLE	☐	BU_NAMEMID	BU_NAME	CHAR	40	0	Middle name or second forename of a person
54	TITLE_ACA1	☐	AD_TITLE1	AD_TITLE1	CHAR	4	0	Academic Title: Key	TSAD2
55	TITLE_ACA2	☐	AD_TITLE2	AD_TITLE1	CHAR	4	0	Second academic title (key)	TSAD2
56	TITLE_ROYL	☐	AD_TITLES	AD_TITLES	CHAR	4	0	Name supplement, e.g. noble title (key)	TSAD5
57	PREFIX1	☐	AD_PREFIX	AD_PREFIX	CHAR	4	0	Name Prefix (Key)	TSAD4
58	PREFIX2	☐	AD_PREFIX2	AD_PREFIX	CHAR	4	0	2nd name prefix (key)	TSAD4
59	NAME1_TEXT	☐	BU_NAME1TX	TEXT80	CHAR	80	0	Full Name
60	NICKNAME	☐	BU_NICKNAM	BU_NAME	CHAR	40	0	Nickname of Business Partner (Person)
61	INITIALS	☐	AD_INITS	CHAR10	CHAR	10	0	"Middle Initial" or personal initials
62	NAMEFORMAT	☐	AD_FORMAT	AD_NAMFORM	CHAR	2	0	Name format	T005N
63	NAMCOUNTRY	☐	AD_NAMCTRY	LAND1	CHAR	3	0	Country for name format rule	T005
64	LANGU_CORR	☐	BU_LANGU_CORR	SPRAS	LANG	1	0	Business Partner: Correspondence Language	T002
65	XSEXM	☐	BU_XSEXM	XFELD	CHAR	1	0	Selection: Business partner is male
66	XSEXF	☐	BU_XSEXF	XFELD	CHAR	1	0	Selection: Business partner is female
67	BIRTHPL	☐	BU_BIRTHPL	TEXT40	CHAR	40	0	Birthplace of business partner
68	MARST	☐	BU_MARST	BU_MARST	CHAR	1	0	Marital Status of Business Partner	TB027
69	EMPLO	☐	BU_EMPLO	BU_EMPLO	CHAR	35	0	Name of Employer of a Natural Person
70	JOBGR	☐	BU_JOBGR	BU_JOBGR	CHAR	4	0	Occupation/group	TB028
71	NATIO	☐	BU_NATIO	LAND1	CHAR	3	0	Nationality	T005
72	CNTAX	☐	BU_CNTAX	LAND1	CHAR	3	0	Obsolete Field	*
73	CNDSC	☐	BU_CNDSC	LAND1	CHAR	3	0	Ctry of Origin: Non-Res. Companies	T005
74	PERSNUMBER	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
75	XSEXU	☐	BU_XSEXU	XFELD	CHAR	1	0	Selection: Sex of business partner is not known
76	XUBNAME	☐	BU_XUBNAME	XUBNAME	CHAR	12	0	Obsolete Field	USR02
77	BU_LANGU	☐	BU_LANGU	SPRAS	LANG	1	0	Business partner: Language	T002
78	.INCLUDE	☐				0	0	CBP: General Data, Person (Non CHAR Fields)
79	BIRTHDT	☐	BU_BIRTHDT	DATUM	DATS	8	0	Date of Birth of Business Partner
80	DEATHDT	☐	BU_DEATHDT	DATUM	DATS	8	0	Date of death of business partner
81	PERNO	☐	BU_PERNO	PERSONID	NUMC	8	0	Personnel Number
82	CHILDREN	☐	BU_CHILDREN	NUMC2	NUMC	2	0	Obsolete Field
83	MEM_HOUSE	☐	BU_MEM_HOUSE	DEC2	DEC	2	0	Obsolete Field
84	.INCLUDE	☐				0	0	CBP: General data (group of people)
85	PARTGRPTYP	☐	BU_GRPTYP	BU_GRPTYP	CHAR	4	0	Group type	TB025
86	NAME_GRP1	☐	BU_NAMEGR1	BU_NAME	CHAR	40	0	Name 1 (group)
87	NAME_GRP2	☐	BU_NAMEGR2	BU_NAME	CHAR	40	0	Name 2 (group)
88	.INCLUDE	☐				0	0	BP: General data II
89	.INCLUDE	☐				0	0	BP: General Data II (CHAR Fields)
90	LGTYP	☐	BU_LGTYP	BU_LGTYP	CHAR	4	0	Legitimation Type	TB029
91	LGNUM	☐	BU_LGNUM	BU_LGNUM	CHAR	16	0	Identification number of legitimation document
92	INFCT	☐	BU_INFCT	BU_INFCT	CHAR	30	0	Responsible local court
93	COMRG	☐	BU_COMRG	CHAR30	CHAR	30	0	Entry in commercial register
94	CLBRG	☐	BU_CLBRG	CHAR30	CHAR	30	0	BP: Entry in register of associations
95	COPRG	☐	BU_COPRG	CHAR30	CHAR	30	0	Entry in Register of Cooperatives
96	.INCLUDE	☐				0	0	BP: General Data II (Non CHAR Fields)
97	COMREG_DAT	☐	BU_COMREG_DAT	DATUM	DATS	8	0	Date of entry in trade register
98	.INCLUDE	☐				0	0	CBP: Name fields combined (lower case)
99	NAME1	☐	BU_NAME1	BU_NAME	CHAR	40	0	Name field 1 (name1/last name)
100	NAME2	☐	BU_NAME2	BU_NAME	CHAR	40	0	Name field 2 (name2/first name)
101	.INCLUDE	☐				0	0	BP: Address Data (Read)
102	.INCLUDE	☐				0	0	Include structure with ADRC attributes without name fields
103	NAME_CO	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
104	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
105	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
106	CITY_CODE	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file	ADRCITY
107	CITYP_CODE	☐	AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file	ADRCITYPRT
108	HOME_CITY	☐	AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
109	CITYH_CODE	☐	AD_CITYHNM	CITY_CODE	CHAR	12	0	Different city for city/street file	ADRCITY
110	CHCKSTATUS	☐	AD_CHECKST	AD_CHECKST	CHAR	1	0	City file test status
111	REGIOGROUP	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping	ADRREGGRP
112	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
113	POST_CODE2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
114	POST_CODE3	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
115	PCODE1_EXT	☐	AD_PST1XT	CHAR10	CHAR	10	0	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
116	PCODE2_EXT	☐	AD_PST2XT	CHAR10	CHAR	10	0	(Not Supported) PO Box Postal Code Extension
117	PCODE3_EXT	☐	AD_PST3XT	CHAR10	CHAR	10	0	(Not Supported) Major Customer Postal Code Extension
118	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
119	DONT_USE_P	☐	AD_NO_USEP	AD_NO_USE	CHAR	4	0	PO Box Address Undeliverable Flag	TSAD12
120	PO_BOX_NUM	☐	AD_POBXNUM	XFELD	CHAR	1	0	Flag: PO Box without number
121	PO_BOX_LOC	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
122	CITY_CODE2	☐	AD_CIT2NUM	CITY_CODE	CHAR	12	0	City PO box code (City file)	ADRCITY
123	PO_BOX_REG	☐	AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)	T005S
124	PO_BOX_CTY	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country	T005
125	POSTALAREA	☐	AD_PSTLAR	TEXT15	CHAR	15	0	(Not Supported) Post Delivery District
126	TRANSPZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	TZONE
127	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
128	DONT_USE_S	☐	AD_NO_USES	AD_NO_USE	CHAR	4	0	Street Address Undeliverable Flag	TSAD12
129	STREETCODE	☐	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File	ADRSTREET
130	STREETABBR	☐	AD_STRABBR	STRTYPEAB	CHAR	2	0	(Not Supported) Abbreviation of Street Name	ADRSTRTYPE
131	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
132	HOUSE_NUM2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
133	HOUSE_NUM3	☐	AD_HSNM3	TEXT10	CHAR	10	0	(Not supported) House Number Range
134	STR_SUPPL1	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
135	STR_SUPPL2	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
136	STR_SUPPL3	☐	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
137	LOCATION	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
138	BUILDING	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
139	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
140	ROOMNUMBER	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
141	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
142	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
143	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
144	SORT1	☐	AD_SORT1UL	TEXT20	CHAR	20	0	Search Term 1
145	SORT2	☐	AD_SORT2UL	TEXT20	CHAR	20	0	Search Term 2
146	SORT_PHN	☐	AD_SRTPHN	CHAR20	CHAR	20	0	(Not Supported) Phonetic Search Sort Field
147	ADDRORIGIN	☐	AD_ORIGINA	AD_ORIGIN	CHAR	4	0	(Not Supported) Address Data Source (Key)	TSAD6
148	EXTENSION1	☐	AD_EXTENS1	TEXT40	CHAR	40	0	Extension (only for data conversion) (e.g. data line)
149	EXTENSION2	☐	AD_EXTENS2	TEXT40	CHAR	40	0	Extension (only for data conversion) (e.g. telebox)
150	TIME_ZONE	☐	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone	TTZZ
151	TAXJURCODE	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
152	ADDRESS_ID	☐	AD_ADDR_ID	AD_ADDR_ID	CHAR	10	0	(Not supported) Physical address ID
153	REMARK	☐	AD_REMARK1	TEXT50	CHAR	50	0	Address notes
154	LANGU_CREA	☐	AD_LANGUCR	SPRAS	LANG	1	0	Address record creation original language	T002
155	PO_BOX_LOBBY	☐	AD_PO_BOX_LBY	TEXT40	CHAR	40	0	PO Box Lobby
156	DELI_SERV_TYPE	☐	AD_DELIVERY_SERVICE_TYPE	AD_DELIVERY_SERVICE_TYPE	CHAR	4	0	Type of Delivery Service	ADDRC_DELI_SERV
157	DELI_SERV_NUMBER	☐	AD_DELIVERY_SERVICE_NUMBER	CHAR10	CHAR	10	0	Number of Delivery Service
158	COUNTY_CODE	☐	AD_CNTYNUM	CNTY_CODE	CHAR	8	0	County code for county	ADRCOUNTY
159	COUNTY	☐	AD_COUNTY	TEXT40	CHAR	40	0	County
160	TOWNSHIP_CODE	☐	AD_TWSHPNUM	TWSHP_CODE	CHAR	8	0	Township code for Township	ADRTOWNSHIP
161	TOWNSHIP	☐	AD_TOWNSHIP	TEXT40	CHAR	40	0	Township
162	DEFLT_COMM	☐	AD_DFLTCMM	AD_COMTYPE	CHAR	3	0	Standard communication type	TSADC
163	TEL_NUMBER	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
164	TEL_EXTENS	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
165	FAX_NUMBER	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
166	FAX_EXTENS	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
167	VALID_FROM	☐	BU_VALID_FROM_DATS	DATUM	DATS	8	0	Valid From
168	VALID_TO	☐	BU_VALID_TO_DATS	DATUM	DATS	8	0	Valid To
169	.INCLUDE	☐				0	0	BP: Tax Numbers: General Data
170	NATPERS	☐	BU_NATURAL_PERSON	BU_NATURAL_PERSON	CHAR	1	0	Business Partner Is a Natural Person Under the Tax Laws
171	.INCLUDE	☐				0	0	IS-U-Specific Fields for Business Partner
172	WAKLASS	☐	WAKLASS	E_WAKLASS	CHAR	4	0	Employee classification	TE697
173	FIRMART	☐	FIRMART	FIRMART	CHAR	2	0	Type of installation company	TE183
174	ARBFELD	☐	ARBFELD	ARBFELD	CHAR	2	0	Company work field	TE185
175	MITGLIED	☐	MITGLIED	MITGLIED	CHAR	1	0	Membership of installer
176	SPZULASS	☐	SPZULASS	SPZULASS	CHAR	20	0	Division license of installer
177	ARTZULASS	☐	ARTZULASS	ARTZULASS	CHAR	2	0	Installer license type	TE189
178	AUSWANZ	☐	AUSWANZ	AUSWANZ	NUMC	2	0	Number of identifications
179	PLOMBENZ	☐	PLOMBENZ	PLOMBENZ	CHAR	10	0	Sealing pliers number
180	FREMDEVU	☐	FREMDEVU	EVU	CHAR	3	0	Main utility company	TE187
181	STATINS	☐	STATINS	STATINS	CHAR	2	0	Valid status of installer in supply area	TE061
182	STATDATUM	☐	STATDATUM	STATDATUM	DATS	8	0	Date on which status of installer comes into effect
183	ERSTZUL	☐	ERSTZUL	ERSTZUL	DATS	8	0	Date of initial license of installer
184	WERKSTATT	☐	WERKSTATT	WERKSTATT	DATS	8	0	Date of workshop inspection
185	VERLZUL	☐	VERLZUL	VERLZUL	DATS	8	0	Date of license renewal
186	ENDEZUL	☐	ENDEZUL	ENDEZUL	DATS	8	0	Date until which license is renewed
187	ANZEVU	☐	ANZEVU	ANZEVU	NUMC	2	0	Number of utility companies
188	ANZFIL	☐	ANZFIL	ANZFIL	NUMC	2	0	Number of branches supported by an installionr company
189	AUSW_INST	☐	AUSW_INST	AUSW_INST	CHAR	10	0	Identification number for installer license
190	DR_LICENSE_LAND1	☐	DR_LICENSE_LAND1	LAND1	CHAR	3	0	Country in which driver's license was acquired	T005
191	DR_LICENSE_REGIO	☐	DR_LICENSE_REGIO	REGIO	CHAR	3	0	Region in which driver's license was acquired	T005S
192	DR_LICENSE	☐	DR_LICENSE	DR_LICENSE	CHAR	20	0	Driver's license number
193	SOC_SECURE	☐	E_SOC_SECU	E_SOC_SECU	CHAR	12	0	Social Insurance Number
194	WELFARE	☐	WELFARE	WELFARE	CHAR	9	0	Welfare office
195	PLACE_EMPL	☐	PLACE_EMPL	CHAR40	CHAR	40	0	Work center
196	KTOKLASSE	☐	KTOKLASSE	KTOKLASSE	CHAR	4	0	Account class	KONTOKLASSE
197	BUPINFOREL	☐	BUPINFOREL	BUPINFOREL	CHAR	2	0	Information release for business partner data	TEBUPINFOREL
198	CLERK_ID	☐	E_CLERK_ID	E_CLERK_ID	CHAR	8	0	Business partner-specific criteria for agent determination	TECLERK_ID
199	RECPTYPE	☐	E_RECPTYPE	E_RECPTYPE	CHAR	1	0	Category for Alternate Payee
200	PYMET	☐	E_PYMET_DON	PYMET_KK	CHAR	1	0	Payment method for donations/fund payments	TFK042Z
201	EMBVT	☐	E_EMBVT_DON	CHAR4	CHAR	4	0	Bank details ID for donations/fund payments
202	HKONT	☐	E_HKONT_DON	SAKNR	CHAR	10	0	G/L accounts for donations/fund payments	SKA1
203	CLASSIFICATION	☐	E_CLASSIFICATION	CHAR4	CHAR	4	0	Classification of Business Partner	TE181
204	VIP	☐	E_VIP	KENNZX	CHAR	1	0	Indicate Very Important Business Partner
205	IDENT_INST	☐	IDENT_INST	IDENT_INST	CHAR	18	0	Identification Number for Installer License
206	.INCLUDE	☐				0	0
207	MUSTER_KUN	☐	MUSTER_KUN	KUNNR	CHAR	10	0	Reference for creating a standard customer for bus. partner	*
208	TEL_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
209	FAX_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
210	SMTP_ADDR	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
211	SMTP_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
212	BKVID	☐	BU_BKVID	CHAR4	CHAR	4	0	Bank details ID
213	.INCLUDE	☐				0	0	BP: Bank Details (Data Fields - External)
214	.INCLUDE	☐				0	0	BP: Bank Details (CHAR Data Fields External)
215	BANKS	☐	BU_BANKS	LAND1	CHAR	3	0	Bank Country Key	T005
216	BANKL	☐	BU_BANKK	CHAR15	CHAR	15	0	Bank Key
217	BANKN	☐	BU_BANKN	CHAR18	CHAR	18	0	Bank Account Number
218	BKONT	☐	BU_BKONT	CHAR2	CHAR	2	0	Bank Control Key
219	BKREF	☐	BU_BKREF	CHAR20	CHAR	20	0	Reference Details for Bank Details
220	KOINH	☐	BU_KOINH	BU_KOINH	CHAR	60	0	Account Holder Name
221	BKEXT	☐	BU_BKEXT	CHAR20	CHAR	20	0	Bank details ID in external system
222	XEZER	☐	BU_XEZER	XFELD	CHAR	1	0	Indicator: Collection Authorization
223	ACCNAME	☐	BU_BANKACCNAME	BU_BKCCNAME	CHAR	40	0	Name of Bank Account
224	MOVE_BKVID	☐	BU_MOVE_BKVID	CHAR4	CHAR	4	0	ID of Target Details for Change of Bank Details (BP)
225	.INCLUDE	☐				0	0	BP: Bank Details (Non-CHAR Data Fields External)
226	BK_VALID_FROM	☐	BU_BK_VALID_FROM	TZNTSTMPS	DEC	15	0	Validity Start of Business Partner Bank Details
227	BK_VALID_TO	☐	BU_BK_VALID_TO	TZNTSTMPS	DEC	15	0	Validity End of Business Partner Bank Details
228	BK_MOVE_DATE	☐	BU_BK_MOVE_DATE	TZNTSTMPS	DEC	15	0	Date of Change to Bank Details (BP)
229	.INCLUDE	☐				0	0	BP: Bank Details (External Bank Data)
230	IBAN	☐	BU_IBAN	CHAR34	CHAR	34	0	IBAN (International Bank Account Number)
231	BANK_GUID	☐	BU_BANK_GUID	UUID	RAW	16	0	Bank GUID
232	ACCOUNT_ID	☐	BU_ACCOUNT_ID	CHAR35	CHAR	35	0	Bank Account Number (New)
233	CHECK_DIGIT	☐	BU_ACCOUNT_CHECK	CHAR2	CHAR	2	0	Bank Account Check Digit
234	ACCOUNT_TYPE	☐	BU_ACCOUNT_TYPE	CHAR3	CHAR	3	0	Bank Account Type
235	.INCLU-A	☐				0	0	Contract accounts (help structure for view)
236	MANDTA	☐	MANDT	MANDT	CLNT	3	0	Client	*
237	VKONTA	☐	VKONT_KK	VKONT_KK	CHAR	12	0	Contract Account Number	*
238	GPARTA	☐	GPART_KK	BU_PARTNER	CHAR	10	0	Business Partner Number	*
239	VKBEZA	☐	VKBEZ_KK	TEXT35	CHAR	35	0	Contract account name
240	.INCLUDE	☐				0	0	Data include for table FKKVKP
241	ERDATA	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
242	ERNAMA	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
243	AEDATPA	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
244	AENAMPA	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
245	FDZTGA	☐	FDZTG_KK	NUM2	NUMC	2	0	Additional Days for Cash Management
246	STOPDA	☐	STOPD_KK	STOPD_KK	DATS	8	0	Processing lock until
247	QSZDTA	☐	QSZDT	DATUM	DATS	8	0	Validity Date for Withholding Tax Exemption Certificate
248	GUIDA	☐	BUAG_GUID	SYSUUID	RAW	16	0	Business Agreement GUID
249	.INCLUDE	☐				0	0	Data Include for Table FKKVKP (Char.Fields Only)
250	EXVKOA	☐	EXVKO_KK	CHAR25	CHAR	25	0	Reference number for business partner
251	OPBUKA	☐	OPBUK_KK	OPBUK_KK	CHAR	4	0	Company Code Group	TFK001G
252	STDBKA	☐	STDBK_KK	BUKRS	CHAR	4	0	Standard Company Code	*
253	ABWREA	☐	ABWRE_KK	BU_PARTNER	CHAR	10	0	Alternative Payer	BUT000
254	ABWRAA	☐	ABWRA_KK	BU_PARTNER	CHAR	10	0	Alternative Payee	BUT000
255	ABWMAA	☐	ABWMA_KK	BU_PARTNER	CHAR	10	0	Alternative dunning recipient	BUT000
256	EBVTYA	☐	EBVTY_KK	CHAR4	CHAR	4	0	Bank Details ID for Incoming Payments
257	ABVTYA	☐	ABVTY_KK	CHAR4	CHAR	4	0	Bank Details ID for Outgoing Payments
258	EZAWEA	☐	EZAWE_KK	CHAR1	CHAR	1	0	Incoming Payment Method
259	EZASPA	☐	EZASP_OLD_KK	SPZAH_KK	CHAR	1	0	Lock Reason for Incoming Payments	TFK008
260	AZAWEA	☐	AZAWE_KK	CHAR5	CHAR	5	0	Outgoing Payment Methods
261	AZASPA	☐	AZASP_OLD_KK	SPZAH_KK	CHAR	1	0	Lock Reason for Outgoing Payments	TFK008
262	EIGBVA	☐	EIGBV_KK	EIGBV_KK	CHAR	25	0	Own Bank Details	*
263	VWNZAA	☐	VWNZA_KK	VWNZA_KK	CHAR	1	0	Create Where-Used List For Line Items
264	LOEVMA	☐	LOEVM_KK	LOEVM_KK	CHAR	1	0	Mark Contract Account for Deletion
265	ABWVKA	☐	ABWVK_KK	VKONT_KK	CHAR	12	0	Alternative contract account for collective bills	FKKVK
266	IKEYA	☐	IKEY_KK	IKEY_KK	CHAR	2	0	Interest Key	TFK056A
267	MAHNVA	☐	MAHNV_KK	MAHNV_KK	CHAR	2	0	Dunning Procedure	TFK047A
268	MANSPA	☐	MANSP_OLD_KK	MANSP_KK	CHAR	1	0	Dunning Lock Reason	TFK047S
269	MGRUPA	☐	MGRUP_KK	MGRUP_KK	CHAR	2	0	Grouping fur Dunning Notices	TFK047F
270	FDGRPA	☐	FDGRP_KK	FDGRP	CHAR	10	0	Planning Group	T035
271	VKPBZA	☐	VKPBZ_KK	VKPBZ_KK	CHAR	2	0	Relationship of Business Partner to Contract Account	TFK002F
272	ADRNBA	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
273	VKONVA	☐	VKONV_KK	VKONT_KK	CHAR	12	0	Contract account used for payment transactions	FKKVK
274	GPARVA	☐	GPARV_KK	BU_PARTNER	CHAR	10	0	Business Partner Acting as Payer in Payment Transactions	BUT000
275	ADRREA	☐	ADRRE_KK	AD_ADDRNUM	CHAR	10	0	Address Number for Alternative Payer	*
276	ADRRAA	☐	ADRRA_KK	AD_ADDRNUM	CHAR	10	0	Address Number for Alternative Payee	*
277	ADRMAA	☐	ADRMA_KK	AD_ADDRNUM	CHAR	10	0	Address number for alternative dunning notice recipient	*
278	ABWRHA	☐	ABWRH_KK	BU_PARTNER	CHAR	10	0	Alternative Invoice Recipient	BUT000
279	ADRRHA	☐	ADRRH_KK	AD_ADDRNUM	CHAR	10	0	Address number for alternative bill recipient	*
280	ADRJDCA	☐	ADRJDC_KK	AD_ADDRNUM	CHAR	10	0	Address Number for Jurisdiction Code Address	*
281	BEGRUA	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
282	TOGRUA	☐	TOGRU_KK	TOGRU_KK	CHAR	4	0	Tolerance group for contract account	TFK043
283	STOPGA	☐	STOPG_KK	STOPG_KK	CHAR	1	0	Reason for Processing Lock	TFK001S
284	TXJCDA	☐	TXJCD_NOCD_KK	TXJCD	CHAR	15	0	Jurisdiction for Tax Calculation - Tax Jurisdiction Code	*
285	COPRCA	☐	COPRC_KK	COPRC_KK	CHAR	4	0	Correspondence Variant	TFK070B
286	VBUNDA	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
287	CCARD_IDA	☐	CCID_IN_KK	CHAR6	CHAR	6	0	Payment Card ID for Incoming Payments
288	CCARD_OUTA	☐	CCID_OUT_KK	CHAR6	CHAR	6	0	Payment Card ID for Outgoing Payments
289	UEBTRA	☐	XUEBTR_KK	XFELD	CHAR	1	0	Items Transferred To Another Account
290	DEF_RECA	☐	DEF_CORR_PARTNER_KK	BU_PARTNER	CHAR	10	0	Alternative Correspondence Recipient for Standard Case	BUT000
291	DEF_REC_INDA	☐	DEF_CORR_ACKEY_KK	CORR_ACKEY_KK	CHAR	4	0	FI-CA correspondence - activity key	TFK070L
292	QSSKZ_AA	☐	QSSKZ_A_KK	QSSKZ	CHAR	2	0	Witholding Tax Code For Outgoing Payments	*
293	QSSKZ_EA	☐	QSSKZ_E_KK	QSSKZ	CHAR	2	0	Withholding Tax Code For Incoming Payments	*
294	QSZNRA	☐	QSZNR	CHAR10	CHAR	10	0	Certificate Number of the Withholding Tax Exemption
295	CORR_MAHNVA	☐	CORR_MAHNV_KK	MAHNV_KK	CHAR	2	0	Correspondence Dunning Procedure	*
296	FITYPA	☐	J_1AFITP_D	J_1AFITP	CHAR	2	0	Tax type	J_1AFITPV
297	PROVINCEA	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
298	COUNTYA	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
299	VERTYPA	☐	VERTYP_KK	VERTYP_KK	CHAR	4	0	Clearing Category For Clearing Postings	TFK111
300	AUGRS_DEFA	☐	AUGRS_DEF_KK	AUGRS_DEF_KK	CHAR	1	0	Clearing Restriction
301	LANDLA	☐	LANDL_KK	LAND1	CHAR	3	0	Country Supplied (for Tax Notifications)	T005
302	BUPLAA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	J_1BBRANCH
303	BPTAXTYPE1A	☐	BPTAXTYPE1	BPTAXTYPE	CHAR	4	0	Tax Number Type 1 for Business Partner
304	BPTAXTYPE2A	☐	BPTAXTYPE2	BPTAXTYPE	CHAR	4	0	Tax Number type 2 for Business Partner
305	PERSRA	☐	PERSR_KK	BU_PARTNER	CHAR	10	0	Clerk Responsible	BUT000
306	INV_CATEGORYA	☐	INV_CATEGORY_KK	INV_CATEGORY_KK	CHAR	4	0	Invoicing Category	TFK2604
307	BPCL_SUCCA	☐	BPCL_SUCC_KK	BPCL_SUCC_KK	CHAR	1	0	Duplicates Processing: BP Predecessor/Successor
308	MNDIDA	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
309	.INCLUDE	☐				0	0	Data include for table FKKVK
310	APPLKA	☐	APPLK_KK	APPLK_KK	CHAR	1	0	Application area
311	VKTYPA	☐	VKTYP_KK	VKTYP_KK	CHAR	2	0	Contract Account Category	TFK002A
312	VKONAA	☐	VKONA_KK	CHAR20	CHAR	20	0	Contract account number in legacy system
313	.INCLUDE	☐				0	0	IS-U Contract Acc.
314	.INCLUDE	☐				0	0	Include for Person Acct
315	.INCLUDE	☐				0	0
316	.INCLUDE	☐				0	0	Common Fields for IS-U/T/M Contract A/R & A/P
317	.INCLUDE	☐				0	0	Include for Acct Header
318	.INCLUDE	☐				0	0
319	.INCLUDE	☐				0	0
320	.INCLUDE	☐				0	0
321	.INCLUDE	☐				0	0
322	.INCLUDE	☐				0	0
323	.INCLUDE	☐				0	0
324	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ESALES_SETTYPE_PARTNER	ABWMAA	BUT000	PARTNER		1	CN
2	ESALES_SETTYPE_PARTNER	ABWRAA	BUT000	PARTNER		1	CN
3	ESALES_SETTYPE_PARTNER	ABWREA	BUT000	PARTNER		1	CN
4	ESALES_SETTYPE_PARTNER	ABWRHA	BUT000	PARTNER
5	ESALES_SETTYPE_PARTNER	ABWVKA	FKKVK	VKONT
6	ESALES_SETTYPE_PARTNER	ADDRORIGIN	TSAD6	ORIGIN	REF	C	CN
7	ESALES_SETTYPE_PARTNER	ARBFELD	TE185	ARBFELD
8	ESALES_SETTYPE_PARTNER	ARTZULASS	TE189	ARTZULASS
9	ESALES_SETTYPE_PARTNER	AZASPA	TFK008	ZAHLS	REF	1	CN
10	ESALES_SETTYPE_PARTNER	BANKS	T005	LAND1	REF	1	CN
11	ESALES_SETTYPE_PARTNER	BPKIND	TB004	BPKIND	REF	1	CN
12	ESALES_SETTYPE_PARTNER	BUPINFOREL	TEBUPINFOREL	INFOREL
13	ESALES_SETTYPE_PARTNER	BUPLAA	J_1BBRANCH	BRANCH	REF
14	ESALES_SETTYPE_PARTNER	BU_GROUP	TB001	BU_GROUP	REF	1	CN
15	ESALES_SETTYPE_PARTNER	BU_LANGU	T002	SPRAS	REF	1	CN
16	ESALES_SETTYPE_PARTNER	BU_LOGSYS	TBDLS	LOGSYS		1	CN
17	ESALES_SETTYPE_PARTNER	CITYH_CODE	ADRCITY	CITY_CODE	REF	C	CN
18	ESALES_SETTYPE_PARTNER	CITYP_CODE	ADRCITYPRT	CITYP_CODE	REF	C	CN
19	ESALES_SETTYPE_PARTNER	CITY_CODE	ADRCITY	CITY_CODE	REF	C	CN
20	ESALES_SETTYPE_PARTNER	CITY_CODE2	ADRCITY	CITY_CODE	REF	C	CN
21	ESALES_SETTYPE_PARTNER	CLASSIFICATION	TE181	CLASSIFICATION
22	ESALES_SETTYPE_PARTNER	CLERK_ID	TECLERK_ID	CLERK_ID
23	ESALES_SETTYPE_PARTNER	CNDSC	T005	LAND1	REF	1	CN
24	ESALES_SETTYPE_PARTNER	COPRCA	TFK070B	COPRC	REF	1	CN
25	ESALES_SETTYPE_PARTNER	COUNTRY	T005	LAND1
26	ESALES_SETTYPE_PARTNER	COUNTYA	T005E	COUNC
27	ESALES_SETTYPE_PARTNER	COUNTY_CODE	ADRCOUNTY	COUNTY_CODE	REF	C	CN
28	ESALES_SETTYPE_PARTNER	DEFLT_COMM	TSADC	COMINT	REF	C	CN
29	ESALES_SETTYPE_PARTNER	DEF_RECA	BUT000	PARTNER	REF	1	CN
30	ESALES_SETTYPE_PARTNER	DEF_REC_INDA	TFK070L	CORR_ACKEY	REF	1	CN
31	ESALES_SETTYPE_PARTNER	DELI_SERV_TYPE	ADDRC_DELI_SERV	DELI_SERV_TYPE		1	CN
32	ESALES_SETTYPE_PARTNER	DONT_USE_P	TSAD12	UNDELIVER	KEY	C	CN
33	ESALES_SETTYPE_PARTNER	DONT_USE_S	TSAD12	UNDELIVER	KEY	C	CN
34	ESALES_SETTYPE_PARTNER	DR_LICENSE_LAND1	T005	LAND1
35	ESALES_SETTYPE_PARTNER	DR_LICENSE_REGIO	T005S	BLAND
36	ESALES_SETTYPE_PARTNER	EZASPA	TFK008	ZAHLS
37	ESALES_SETTYPE_PARTNER	FDGRPA	T035	GRUPP
38	ESALES_SETTYPE_PARTNER	FIRMART	TE183	FIRMART
39	ESALES_SETTYPE_PARTNER	FITYPA	J_1AFITPV	J_1AFITP
40	ESALES_SETTYPE_PARTNER	FREMDEVU	TE187	EVU
41	ESALES_SETTYPE_PARTNER	GPARVA	BUT000	PARTNER	REF
42	ESALES_SETTYPE_PARTNER	HKONT	SKA1	SAKNR
43	ESALES_SETTYPE_PARTNER	IKEYA	TFK056A	IKEY
44	ESALES_SETTYPE_PARTNER	IND_SECTOR	TB023	IND_SECTOR	REF	1	CN
45	ESALES_SETTYPE_PARTNER	INV_CATEGORYA	TFK2604	INV_CATEGORY	REF
46	ESALES_SETTYPE_PARTNER	JOBGR	TB028	JOBGR	REF	1	CN
47	ESALES_SETTYPE_PARTNER	KTOKLASSE	KONTOKLASSE	KTOKL
48	ESALES_SETTYPE_PARTNER	LANDLA	T005	LAND1
49	ESALES_SETTYPE_PARTNER	LANGU	T002	SPRAS	KEY	1	CN
50	ESALES_SETTYPE_PARTNER	LANGU_CORR	T002	SPRAS	REF	C	CN
51	ESALES_SETTYPE_PARTNER	LANGU_CREA	T002	SPRAS	REF	C	CN
52	ESALES_SETTYPE_PARTNER	LEGAL_ENTY	TB019	LEGAL_ENTY	KEY	1	CN
53	ESALES_SETTYPE_PARTNER	LEGAL_ORG	TB032	LEGAL_ORG	REF	1	CN
54	ESALES_SETTYPE_PARTNER	LGTYP	TB029	LGTYP
55	ESALES_SETTYPE_PARTNER	MAHNVA	TFK047A	MAHNV
56	ESALES_SETTYPE_PARTNER	MANSPA	TFK047S	MANSP
57	ESALES_SETTYPE_PARTNER	MARST	TB027	MARST		1	CN
58	ESALES_SETTYPE_PARTNER	MGRUPA	TFK047F	MGRUP
59	ESALES_SETTYPE_PARTNER	NAMCOUNTRY	T005	LAND1	REF	C	CN
60	ESALES_SETTYPE_PARTNER	NAMEFORMAT	T005N	NAMEFORMAT	REF	C	CN
61	ESALES_SETTYPE_PARTNER	NATIO	T005	LAND1		1	CN
62	ESALES_SETTYPE_PARTNER	OPBUKA	TFK001G	OPBUK
63	ESALES_SETTYPE_PARTNER	PARTGRPTYP	TB025	PARTGRPTYP	KEY	1	CN
64	ESALES_SETTYPE_PARTNER	PARTNER	BUT000	PARTNER	KEY	1	C
65	ESALES_SETTYPE_PARTNER	PERSRA	BUT000	PARTNER	REF	1	CN
66	ESALES_SETTYPE_PARTNER	PO_BOX_CTY	T005	LAND1	REF	C	CN
67	ESALES_SETTYPE_PARTNER	PO_BOX_REG	T005S	BLAND	REF	C	CN
68	ESALES_SETTYPE_PARTNER	PREFIX1	TSAD4	PREFIX_KEY	KEY	1	CN
69	ESALES_SETTYPE_PARTNER	PREFIX2	TSAD4	PREFIX_KEY	KEY	1	CN
70	ESALES_SETTYPE_PARTNER	PROVINCEA	T005S	BLAND
71	ESALES_SETTYPE_PARTNER	PYMET	TFK042Z	ZLSCH
72	ESALES_SETTYPE_PARTNER	RATE	DPR_RATES	RATE	KEY
73	ESALES_SETTYPE_PARTNER	REGIOGROUP	ADRREGGRP	REGIOGROUP	REF	C	CN
74	ESALES_SETTYPE_PARTNER	REGION	T005S	BLAND	REF	C	CN
75	ESALES_SETTYPE_PARTNER	SOURCE	TB005	SOURCE	KEY	1	CN
76	ESALES_SETTYPE_PARTNER	STATINS	TE061	STATINS
77	ESALES_SETTYPE_PARTNER	STOPGA	TFK001S	STOPG
78	ESALES_SETTYPE_PARTNER	STREETABBR	ADRSTRTYPE	STRTYPEAB	REF	C	CN
79	ESALES_SETTYPE_PARTNER	STREETCODE	ADRSTREET	STRT_CODE	REF	C	CN
80	ESALES_SETTYPE_PARTNER	TIME_ZONE	TTZZ	TZONE	REF	C	CN
81	ESALES_SETTYPE_PARTNER	TITLE	TSAD3	TITLE	KEY	1	CN
82	ESALES_SETTYPE_PARTNER	TITLE_ACA1	TSAD2	TITLE_KEY	KEY	1	CN
83	ESALES_SETTYPE_PARTNER	TITLE_ACA2	TSAD2	TITLE_KEY	KEY	1	CN
84	ESALES_SETTYPE_PARTNER	TITLE_ROYL	TSAD5	TITLE_KEY	KEY	1	CN
85	ESALES_SETTYPE_PARTNER	TOGRUA	TFK043	TOGRU		1	CN
86	ESALES_SETTYPE_PARTNER	TOWNSHIP_CODE	ADRTOWNSHIP	TOWNSHIP_CODE	REF	C	CN
87	ESALES_SETTYPE_PARTNER	TRANSPZONE	TZONE	ZONE1	REF	C	CN
88	ESALES_SETTYPE_PARTNER	VERTYPA	TFK111	VERTYP	REF
89	ESALES_SETTYPE_PARTNER	VKONVA	FKKVK	VKONT
90	ESALES_SETTYPE_PARTNER	VKPBZA	TFK002F	VKPBZ
91	ESALES_SETTYPE_PARTNER	VKTYPA	TFK002A	VKTYP
92	ESALES_SETTYPE_PARTNER	WAKLASS	TE697	WAKLASS
93	ESALES_SETTYPE_PARTNER	XUBNAME	USR02	BNAME	KEY	1	CN

History

Last changed by/on	SAP	20141109
SAP Release Created in	462