SAP ABAP Table FICA_TAXEXEMPT_STR_CONT_ACCT (Contract Account)

Hierarchy

☛ FI-CA (Software Component) FI-CA
   ⤷ FI-CA (Application Component) Contract Accounts Receivable and Payable
     ⤷ FKKC (Package) Contract Accounts Receivable and Payable: Correspondence

Basic Data

Table Category	INTTAB	Structure
Structure	FICA_TAXEXEMPT_STR_CONT_ACCT	Table Relationship Diagram
Short Description	Contract Account

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	WA_CONT_ACCT	☐	FKKVKP1		STRU	0	0
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
3	VKONT	☐	VKONT_KK	VKONT_KK	CHAR	12	0	Contract Account Number
4	GPART	☐	GPART_KK	BU_PARTNER	CHAR	10	0	Business Partner Number
5	VKBEZ	☐	VKBEZ_KK	TEXT35	CHAR	35	0	Contract account name
6	.INCLUDE	☐				0	0	Data include for table FKKVKP
7	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
8	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
9	AEDATP	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
10	AENAMP	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
11	FDZTG	☐	FDZTG_KK	NUM2	NUMC	2	0	Additional Days for Cash Management
12	STOPD	☐	STOPD_KK	STOPD_KK	DATS	8	0	Processing lock until
13	QSZDT	☐	QSZDT	DATUM	DATS	8	0	Validity Date for Withholding Tax Exemption Certificate
14	GUID	☐	BUAG_GUID	SYSUUID	RAW	16	0	Business Agreement GUID
15	.INCLUDE	☐				0	0	Data Include for Table FKKVKP (Char.Fields Only)
16	EXVKO	☐	EXVKO_KK	CHAR25	CHAR	25	0	Reference number for business partner
17	OPBUK	☐	OPBUK_KK	OPBUK_KK	CHAR	4	0	Company Code Group
18	STDBK	☐	STDBK_KK	BUKRS	CHAR	4	0	Standard Company Code
19	ABWRE	☐	ABWRE_KK	BU_PARTNER	CHAR	10	0	Alternative Payer
20	ABWRA	☐	ABWRA_KK	BU_PARTNER	CHAR	10	0	Alternative Payee
21	ABWMA	☐	ABWMA_KK	BU_PARTNER	CHAR	10	0	Alternative dunning recipient
22	EBVTY	☐	EBVTY_KK	CHAR4	CHAR	4	0	Bank Details ID for Incoming Payments
23	ABVTY	☐	ABVTY_KK	CHAR4	CHAR	4	0	Bank Details ID for Outgoing Payments
24	EZAWE	☐	EZAWE_KK	CHAR1	CHAR	1	0	Incoming Payment Method
25	EZASP	☐	EZASP_OLD_KK	SPZAH_KK	CHAR	1	0	Lock Reason for Incoming Payments
26	AZAWE	☐	AZAWE_KK	CHAR5	CHAR	5	0	Outgoing Payment Methods
27	AZASP	☐	AZASP_OLD_KK	SPZAH_KK	CHAR	1	0	Lock Reason for Outgoing Payments
28	EIGBV	☐	EIGBV_KK	EIGBV_KK	CHAR	25	0	Own Bank Details
29	VWNZA	☐	VWNZA_KK	VWNZA_KK	CHAR	1	0	Create Where-Used List For Line Items
30	LOEVM	☐	LOEVM_KK	LOEVM_KK	CHAR	1	0	Mark Contract Account for Deletion
31	ABWVK	☐	ABWVK_KK	VKONT_KK	CHAR	12	0	Alternative contract account for collective bills
32	IKEY	☐	IKEY_KK	IKEY_KK	CHAR	2	0	Interest Key
33	MAHNV	☐	MAHNV_KK	MAHNV_KK	CHAR	2	0	Dunning Procedure
34	MANSP	☐	MANSP_OLD_KK	MANSP_KK	CHAR	1	0	Dunning Lock Reason
35	MGRUP	☐	MGRUP_KK	MGRUP_KK	CHAR	2	0	Grouping fur Dunning Notices
36	FDGRP	☐	FDGRP_KK	FDGRP	CHAR	10	0	Planning Group
37	VKPBZ	☐	VKPBZ_KK	VKPBZ_KK	CHAR	2	0	Relationship of Business Partner to Contract Account
38	ADRNB	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number
39	VKONV	☐	VKONV_KK	VKONT_KK	CHAR	12	0	Contract account used for payment transactions
40	GPARV	☐	GPARV_KK	BU_PARTNER	CHAR	10	0	Business Partner Acting as Payer in Payment Transactions
41	ADRRE	☐	ADRRE_KK	AD_ADDRNUM	CHAR	10	0	Address Number for Alternative Payer
42	ADRRA	☐	ADRRA_KK	AD_ADDRNUM	CHAR	10	0	Address Number for Alternative Payee
43	ADRMA	☐	ADRMA_KK	AD_ADDRNUM	CHAR	10	0	Address number for alternative dunning notice recipient
44	ABWRH	☐	ABWRH_KK	BU_PARTNER	CHAR	10	0	Alternative Invoice Recipient
45	ADRRH	☐	ADRRH_KK	AD_ADDRNUM	CHAR	10	0	Address number for alternative bill recipient
46	ADRJDC	☐	ADRJDC_KK	AD_ADDRNUM	CHAR	10	0	Address Number for Jurisdiction Code Address
47	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
48	TOGRU	☐	TOGRU_KK	TOGRU_KK	CHAR	4	0	Tolerance group for contract account
49	STOPG	☐	STOPG_KK	STOPG_KK	CHAR	1	0	Reason for Processing Lock
50	TXJCD	☐	TXJCD_NOCD_KK	TXJCD	CHAR	15	0	Jurisdiction for Tax Calculation - Tax Jurisdiction Code
51	COPRC	☐	COPRC_KK	COPRC_KK	CHAR	4	0	Correspondence Variant
52	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner
53	CCARD_ID	☐	CCID_IN_KK	CHAR6	CHAR	6	0	Payment Card ID for Incoming Payments
54	CCARD_OUT	☐	CCID_OUT_KK	CHAR6	CHAR	6	0	Payment Card ID for Outgoing Payments
55	UEBTR	☐	XUEBTR_KK	XFELD	CHAR	1	0	Items Transferred To Another Account
56	DEF_REC	☐	DEF_CORR_PARTNER_KK	BU_PARTNER	CHAR	10	0	Alternative Correspondence Recipient for Standard Case
57	DEF_REC_IND	☐	DEF_CORR_ACKEY_KK	CORR_ACKEY_KK	CHAR	4	0	FI-CA correspondence - activity key
58	QSSKZ_A	☐	QSSKZ_A_KK	QSSKZ	CHAR	2	0	Witholding Tax Code For Outgoing Payments
59	QSSKZ_E	☐	QSSKZ_E_KK	QSSKZ	CHAR	2	0	Withholding Tax Code For Incoming Payments
60	QSZNR	☐	QSZNR	CHAR10	CHAR	10	0	Certificate Number of the Withholding Tax Exemption
61	CORR_MAHNV	☐	CORR_MAHNV_KK	MAHNV_KK	CHAR	2	0	Correspondence Dunning Procedure
62	FITYP	☐	J_1AFITP_D	J_1AFITP	CHAR	2	0	Tax type
63	PROVINCE	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
64	COUNTY	☐	COUNC	COUNC	CHAR	3	0	County Code
65	VERTYP	☐	VERTYP_KK	VERTYP_KK	CHAR	4	0	Clearing Category For Clearing Postings
66	AUGRS_DEF	☐	AUGRS_DEF_KK	AUGRS_DEF_KK	CHAR	1	0	Clearing Restriction
67	LANDL	☐	LANDL_KK	LAND1	CHAR	3	0	Country Supplied (for Tax Notifications)
68	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place
69	BPTAXTYPE1	☐	BPTAXTYPE1	BPTAXTYPE	CHAR	4	0	Tax Number Type 1 for Business Partner
70	BPTAXTYPE2	☐	BPTAXTYPE2	BPTAXTYPE	CHAR	4	0	Tax Number type 2 for Business Partner
71	PERSR	☐	PERSR_KK	BU_PARTNER	CHAR	10	0	Clerk Responsible
72	INV_CATEGORY	☐	INV_CATEGORY_KK	INV_CATEGORY_KK	CHAR	4	0	Invoicing Category
73	BPCL_SUCC	☐	BPCL_SUCC_KK	BPCL_SUCC_KK	CHAR	1	0	Duplicates Processing: BP Predecessor/Successor
74	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
75	.INCLUDE	☐				0	0	Data include for table FKKVK
76	APPLK	☐	APPLK_KK	APPLK_KK	CHAR	1	0	Application area
77	VKTYP	☐	VKTYP_KK	VKTYP_KK	CHAR	2	0	Contract Account Category
78	VKONA	☐	VKONA_KK	CHAR20	CHAR	20	0	Contract account number in legacy system
79	.INCLUDE	☐				0	0	IS-U Contract Acc.
80	.INCLUDE	☐				0	0	Include for Person Acct
81	.INCLUDE	☐				0	0
82	.INCLUDE	☐				0	0	Common Fields for IS-U/T/M Contract A/R & A/P
83	.INCLUDE	☐				0	0	Include for Acct Header
84	.INCLUDE	☐				0	0
85	.INCLUDE	☐				0	0
86	.INCLUDE	☐				0	0
87	.INCLUDE	☐				0	0
88	.INCLUDE	☐				0	0
89	.INCLUDE	☐				0	0
90	.INCLUDE	☐				0	0
91	WA_RECEIVER	☐	BUS000_EXT		STRU	0	0
92	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
93	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number
94	.INCLUDE	☐				0	0	BP: General Data I (Data Fields - External)
95	.INCLUDE	☐				0	0	CBP: General data (independent of partner cat.)
96	.INCLUDE	☐				0	0	CBP: General Data (not dep. on Part. Cat.), Initial Screen
97	TYPE	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
98	BPKIND	☐	BU_BPKIND	BU_KIND	CHAR	4	0	Business Partner Type
99	BU_GROUP	☐	BU_GROUP	BU_GROUP	CHAR	4	0	Business Partner Grouping
100	BPEXT	☐	BU_BPEXT	CHAR20	CHAR	20	0	Business Partner Number in External System
101	.INCLUDE	☐				0	0	CBP: General Data (not dep. on Part. Cat.), Data Screens
102	BU_SORT1	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
103	BU_SORT2	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
104	SOURCE	☐	BU_SOURCE	BU_SOURCE	CHAR	4	0	Data Origin Types
105	TITLE	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key
106	XDELE	☐	BU_XDELE	XFELD	CHAR	1	0	Central Archiving Flag
107	XBLCK	☐	BU_XBLCK	XFELD	CHAR	1	0	Central Block for Business Partner
108	AUGRP	☐	BU_AUGRP	BU_AUGRP	CHAR	4	0	Authorization Group
109	TITLE_LET	☐	BU_TITLE_LET	TEXT50	CHAR	50	0	Salutation
110	BU_LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system
111	CONTACT	☐	BU_CONTACT	BU_CONTACT	CHAR	1	0	Business Partner: Contact Permission
112	NOT_RELEASED	☐	BU_XNOT_RELEASED	XFELD	CHAR	1	0	Indicator: Not Released
113	NOT_LG_COMPETENT	☐	BU_NOT_LEG_COMPETENT	BOOLE	CHAR	1	0	Indicator: Not Legally Competent
114	PRINT_MODE	☐	BU_PRINT_MODE	BU_PRINT_MODE	CHAR	1	0	Business Partner Print Format
115	.INCLUDE	☐				0	0	EEW Extension of BUT000 (Contains CI)
116	BP_EEW_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
117	.INCLUDE	☐				0	0
118	.INCLU--AP	☐				0	0	Cost/Revenue Type in Resource Role
119	RATE	☐	DPR_TV_RATE	DPR_RATE_TYPE	CHAR	15	0	Cost Rate/Revenue Rate for Project Costing
120	.INCLUDE	☐				0	0	CBP: General data (Organization)
121	.INCLUDE	☐				0	0	CBP: General Data, Organization (CHAR Fields)
122	NAME_ORG1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
123	NAME_ORG2	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
124	NAME_ORG3	☐	BU_NAMEOR3	BU_NAME	CHAR	40	0	Name 3 of organization
125	NAME_ORG4	☐	BU_NAMEOR4	BU_NAME	CHAR	40	0	Name 4 of organization
126	LEGAL_ENTY	☐	BU_LEGENTY	BU_LEGENTY	CHAR	2	0	BP: Legal form of organization
127	IND_SECTOR	☐	BU_INDSECT	BU_INDSECT	CHAR	10	0	Industry sector
128	LEGAL_ORG	☐	BU_LEGAL_ORG	BU_LEGAL_ORG	CHAR	2	0	Legal Entity of Organization
129	.INCLUDE	☐				0	0	CBP: General Data, Organization (Non CHAR Fields)
130	FOUND_DAT	☐	BU_FOUND_DAT	DATUM	DATS	8	0	Date organization founded
131	LIQUID_DAT	☐	BU_LIQUID_DAT		DATS	8	0	Liquidation date of organization
132	LOCATION_1	☐	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
133	LOCATION_2	☐	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
134	LOCATION_3	☐	BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
135	.INCLUDE	☐				0	0	CBP: General Data, Person
136	.INCLUDE	☐				0	0	CBP: General Data, Person (CHAR Fields)
137	NAME_LAST	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
138	NAME_FIRST	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
139	NAME_LST2	☐	BU_NAMEPL2	BU_NAME	CHAR	40	0	Other Last Name of a Person
140	NAME_LAST2	☐	BU_BIRTHNM	BU_NAME	CHAR	40	0	Name at birth of business partner
141	NAMEMIDDLE	☐	BU_NAMEMID	BU_NAME	CHAR	40	0	Middle name or second forename of a person
142	TITLE_ACA1	☐	AD_TITLE1	AD_TITLE1	CHAR	4	0	Academic Title: Key
143	TITLE_ACA2	☐	AD_TITLE2	AD_TITLE1	CHAR	4	0	Second academic title (key)
144	TITLE_ROYL	☐	AD_TITLES	AD_TITLES	CHAR	4	0	Name supplement, e.g. noble title (key)
145	PREFIX1	☐	AD_PREFIX	AD_PREFIX	CHAR	4	0	Name Prefix (Key)
146	PREFIX2	☐	AD_PREFIX2	AD_PREFIX	CHAR	4	0	2nd name prefix (key)
147	NAME1_TEXT	☐	BU_NAME1TX	TEXT80	CHAR	80	0	Full Name
148	NICKNAME	☐	BU_NICKNAM	BU_NAME	CHAR	40	0	Nickname of Business Partner (Person)
149	INITIALS	☐	AD_INITS	CHAR10	CHAR	10	0	"Middle Initial" or personal initials
150	NAMEFORMAT	☐	AD_FORMAT	AD_NAMFORM	CHAR	2	0	Name format
151	NAMCOUNTRY	☐	AD_NAMCTRY	LAND1	CHAR	3	0	Country for name format rule
152	LANGU_CORR	☐	BU_LANGU_CORR	SPRAS	LANG	1	0	Business Partner: Correspondence Language
153	XSEXM	☐	BU_XSEXM	XFELD	CHAR	1	0	Selection: Business partner is male
154	XSEXF	☐	BU_XSEXF	XFELD	CHAR	1	0	Selection: Business partner is female
155	BIRTHPL	☐	BU_BIRTHPL	TEXT40	CHAR	40	0	Birthplace of business partner
156	MARST	☐	BU_MARST	BU_MARST	CHAR	1	0	Marital Status of Business Partner
157	EMPLO	☐	BU_EMPLO	BU_EMPLO	CHAR	35	0	Name of Employer of a Natural Person
158	JOBGR	☐	BU_JOBGR	BU_JOBGR	CHAR	4	0	Occupation/group
159	NATIO	☐	BU_NATIO	LAND1	CHAR	3	0	Nationality
160	CNTAX	☐	BU_CNTAX	LAND1	CHAR	3	0	Obsolete Field
161	CNDSC	☐	BU_CNDSC	LAND1	CHAR	3	0	Ctry of Origin: Non-Res. Companies
162	PERSNUMBER	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number
163	XSEXU	☐	BU_XSEXU	XFELD	CHAR	1	0	Selection: Sex of business partner is not known
164	XUBNAME	☐	BU_XUBNAME	XUBNAME	CHAR	12	0	Obsolete Field
165	BU_LANGU	☐	BU_LANGU	SPRAS	LANG	1	0	Business partner: Language
166	.INCLUDE	☐				0	0	CBP: General Data, Person (Non CHAR Fields)
167	BIRTHDT	☐	BU_BIRTHDT	DATUM	DATS	8	0	Date of Birth of Business Partner
168	DEATHDT	☐	BU_DEATHDT	DATUM	DATS	8	0	Date of death of business partner
169	PERNO	☐	BU_PERNO	PERSONID	NUMC	8	0	Personnel Number
170	CHILDREN	☐	BU_CHILDREN	NUMC2	NUMC	2	0	Obsolete Field
171	MEM_HOUSE	☐	BU_MEM_HOUSE	DEC2	DEC	2	0	Obsolete Field
172	.INCLUDE	☐				0	0	CBP: General data (group of people)
173	PARTGRPTYP	☐	BU_GRPTYP	BU_GRPTYP	CHAR	4	0	Group type
174	NAME_GRP1	☐	BU_NAMEGR1	BU_NAME	CHAR	40	0	Name 1 (group)
175	NAME_GRP2	☐	BU_NAMEGR2	BU_NAME	CHAR	40	0	Name 2 (group)
176	.INCLUDE	☐				0	0	BP: General data II
177	.INCLUDE	☐				0	0	BP: General Data II (CHAR Fields)
178	LGTYP	☐	BU_LGTYP	BU_LGTYP	CHAR	4	0	Legitimation Type
179	LGNUM	☐	BU_LGNUM	BU_LGNUM	CHAR	16	0	Identification number of legitimation document
180	INFCT	☐	BU_INFCT	BU_INFCT	CHAR	30	0	Responsible local court
181	COMRG	☐	BU_COMRG	CHAR30	CHAR	30	0	Entry in commercial register
182	CLBRG	☐	BU_CLBRG	CHAR30	CHAR	30	0	BP: Entry in register of associations
183	COPRG	☐	BU_COPRG	CHAR30	CHAR	30	0	Entry in Register of Cooperatives
184	.INCLUDE	☐				0	0	BP: General Data II (Non CHAR Fields)
185	COMREG_DAT	☐	BU_COMREG_DAT	DATUM	DATS	8	0	Date of entry in trade register
186	.INCLUDE	☐				0	0	CBP: Name fields combined (lower case)
187	NAME1	☐	BU_NAME1	BU_NAME	CHAR	40	0	Name field 1 (name1/last name)
188	NAME2	☐	BU_NAME2	BU_NAME	CHAR	40	0	Name field 2 (name2/first name)
189	.INCLUDE	☐				0	0	BP: Address Data (Read)
190	.INCLUDE	☐				0	0	Include structure with ADRC attributes without name fields
191	NAME_CO	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
192	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
193	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
194	CITY_CODE	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file
195	CITYP_CODE	☐	AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file
196	HOME_CITY	☐	AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
197	CITYH_CODE	☐	AD_CITYHNM	CITY_CODE	CHAR	12	0	Different city for city/street file
198	CHCKSTATUS	☐	AD_CHECKST	AD_CHECKST	CHAR	1	0	City file test status
199	REGIOGROUP	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping
200	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
201	POST_CODE2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
202	POST_CODE3	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
203	PCODE1_EXT	☐	AD_PST1XT	CHAR10	CHAR	10	0	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
204	PCODE2_EXT	☐	AD_PST2XT	CHAR10	CHAR	10	0	(Not Supported) PO Box Postal Code Extension
205	PCODE3_EXT	☐	AD_PST3XT	CHAR10	CHAR	10	0	(Not Supported) Major Customer Postal Code Extension
206	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
207	DONT_USE_P	☐	AD_NO_USEP	AD_NO_USE	CHAR	4	0	PO Box Address Undeliverable Flag
208	PO_BOX_NUM	☐	AD_POBXNUM	XFELD	CHAR	1	0	Flag: PO Box without number
209	PO_BOX_LOC	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
210	CITY_CODE2	☐	AD_CIT2NUM	CITY_CODE	CHAR	12	0	City PO box code (City file)
211	PO_BOX_REG	☐	AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)
212	PO_BOX_CTY	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country
213	POSTALAREA	☐	AD_PSTLAR	TEXT15	CHAR	15	0	(Not Supported) Post Delivery District
214	TRANSPZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered
215	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
216	DONT_USE_S	☐	AD_NO_USES	AD_NO_USE	CHAR	4	0	Street Address Undeliverable Flag
217	STREETCODE	☐	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File
218	STREETABBR	☐	AD_STRABBR	STRTYPEAB	CHAR	2	0	(Not Supported) Abbreviation of Street Name
219	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
220	HOUSE_NUM2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
221	HOUSE_NUM3	☐	AD_HSNM3	TEXT10	CHAR	10	0	(Not supported) House Number Range
222	STR_SUPPL1	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
223	STR_SUPPL2	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
224	STR_SUPPL3	☐	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
225	LOCATION	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
226	BUILDING	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
227	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
228	ROOMNUMBER	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
229	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key
230	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key
231	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
232	SORT1	☐	AD_SORT1UL	TEXT20	CHAR	20	0	Search Term 1
233	SORT2	☐	AD_SORT2UL	TEXT20	CHAR	20	0	Search Term 2
234	SORT_PHN	☐	AD_SRTPHN	CHAR20	CHAR	20	0	(Not Supported) Phonetic Search Sort Field
235	ADDRORIGIN	☐	AD_ORIGINA	AD_ORIGIN	CHAR	4	0	(Not Supported) Address Data Source (Key)
236	EXTENSION1	☐	AD_EXTENS1	TEXT40	CHAR	40	0	Extension (only for data conversion) (e.g. data line)
237	EXTENSION2	☐	AD_EXTENS2	TEXT40	CHAR	40	0	Extension (only for data conversion) (e.g. telebox)
238	TIME_ZONE	☐	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone
239	TAXJURCODE	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
240	ADDRESS_ID	☐	AD_ADDR_ID	AD_ADDR_ID	CHAR	10	0	(Not supported) Physical address ID
241	REMARK	☐	AD_REMARK1	TEXT50	CHAR	50	0	Address notes
242	LANGU_CREA	☐	AD_LANGUCR	SPRAS	LANG	1	0	Address record creation original language
243	PO_BOX_LOBBY	☐	AD_PO_BOX_LBY	TEXT40	CHAR	40	0	PO Box Lobby
244	DELI_SERV_TYPE	☐	AD_DELIVERY_SERVICE_TYPE	AD_DELIVERY_SERVICE_TYPE	CHAR	4	0	Type of Delivery Service
245	DELI_SERV_NUMBER	☐	AD_DELIVERY_SERVICE_NUMBER	CHAR10	CHAR	10	0	Number of Delivery Service
246	COUNTY_CODE	☐	AD_CNTYNUM	CNTY_CODE	CHAR	8	0	County code for county
247	COUNTY	☐	AD_COUNTY	TEXT40	CHAR	40	0	County
248	TOWNSHIP_CODE	☐	AD_TWSHPNUM	TWSHP_CODE	CHAR	8	0	Township code for Township
249	TOWNSHIP	☐	AD_TOWNSHIP	TEXT40	CHAR	40	0	Township
250	DEFLT_COMM	☐	AD_DFLTCMM	AD_COMTYPE	CHAR	3	0	Standard communication type
251	TEL_NUMBER	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
252	TEL_EXTENS	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
253	FAX_NUMBER	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
254	FAX_EXTENS	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
255	VALID_FROM	☐	BU_VALID_FROM_DATS	DATUM	DATS	8	0	Valid From
256	VALID_TO	☐	BU_VALID_TO_DATS	DATUM	DATS	8	0	Valid To
257	.INCLUDE	☐				0	0	BP: Tax Numbers: General Data
258	NATPERS	☐	BU_NATURAL_PERSON	BU_NATURAL_PERSON	CHAR	1	0	Business Partner Is a Natural Person Under the Tax Laws
259	WA_REC_ADRESS	☐	BUS020_EXT		STRU	0	0
260	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
261	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number
262	.INCLUDE	☐				0	0	BP: Addresses (Data Fields Ext.)
263	.INCLUDE	☐				0	0	BP: Addresses (CHAR Data Fields External)
264	XDFADR	☐	BU_XDFADR	XFELD	CHAR	1	0	Indicator: Address is standard address
265	ADEXT	☐	BU_ADEXT	BU_ADEXT	CHAR	20	0	Address number in external system
266	NATION	☐	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses
267	GUID	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
268	MOVE_ADDR	☐	BU_MOVE_ADDR	AD_ADDRNUM	CHAR	10	0	Number of Move Target Address for Address Moves
269	.INCLUDE	☐				0	0	BP: Addresses (Non-CHAR Data Fields External)
270	DATE_FROM	☐	BU_DATE_OBSOLETE	DATUM	DATS	8	0	Date Obsolete
271	ADDRESS_GUID	☐	BU_ADDRESS_GUID	SYSUUID	RAW	16	0	GUID of a Business Partner Address
272	ADDR_VALID_FROM	☐	BU_ADDR_VALID_FROM	TZNTSTMPS	DEC	15	0	Validity Start of a Business Partner Address
273	ADDR_VALID_TO	☐	BU_ADDR_VALID_TO	TZNTSTMPS	DEC	15	0	Validity End of a Business Partner Address
274	ADDR_MOVE_DATE	☐	BU_ADDR_MOVE_DATE	TZNTSTMPS	DEC	15	0	Date of Move for Address Moves
275	.INCLUDE	☐				0	0	BP: Address Data (Read)
276	.INCLUDE	☐				0	0	Include structure with ADRC attributes without name fields
277	NAME_CO	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
278	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
279	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
280	CITY_CODE	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file
281	CITYP_CODE	☐	AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file
282	HOME_CITY	☐	AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
283	CITYH_CODE	☐	AD_CITYHNM	CITY_CODE	CHAR	12	0	Different city for city/street file
284	CHCKSTATUS	☐	AD_CHECKST	AD_CHECKST	CHAR	1	0	City file test status
285	REGIOGROUP	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping
286	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
287	POST_CODE2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
288	POST_CODE3	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
289	PCODE1_EXT	☐	AD_PST1XT	CHAR10	CHAR	10	0	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
290	PCODE2_EXT	☐	AD_PST2XT	CHAR10	CHAR	10	0	(Not Supported) PO Box Postal Code Extension
291	PCODE3_EXT	☐	AD_PST3XT	CHAR10	CHAR	10	0	(Not Supported) Major Customer Postal Code Extension
292	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
293	DONT_USE_P	☐	AD_NO_USEP	AD_NO_USE	CHAR	4	0	PO Box Address Undeliverable Flag
294	PO_BOX_NUM	☐	AD_POBXNUM	XFELD	CHAR	1	0	Flag: PO Box without number
295	PO_BOX_LOC	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
296	CITY_CODE2	☐	AD_CIT2NUM	CITY_CODE	CHAR	12	0	City PO box code (City file)
297	PO_BOX_REG	☐	AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)
298	PO_BOX_CTY	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country
299	POSTALAREA	☐	AD_PSTLAR	TEXT15	CHAR	15	0	(Not Supported) Post Delivery District
300	TRANSPZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered
301	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
302	DONT_USE_S	☐	AD_NO_USES	AD_NO_USE	CHAR	4	0	Street Address Undeliverable Flag
303	STREETCODE	☐	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File
304	STREETABBR	☐	AD_STRABBR	STRTYPEAB	CHAR	2	0	(Not Supported) Abbreviation of Street Name
305	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
306	HOUSE_NUM2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
307	HOUSE_NUM3	☐	AD_HSNM3	TEXT10	CHAR	10	0	(Not supported) House Number Range
308	STR_SUPPL1	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
309	STR_SUPPL2	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
310	STR_SUPPL3	☐	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
311	LOCATION	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
312	BUILDING	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
313	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
314	ROOMNUMBER	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
315	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key
316	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key
317	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
318	SORT1	☐	AD_SORT1UL	TEXT20	CHAR	20	0	Search Term 1
319	SORT2	☐	AD_SORT2UL	TEXT20	CHAR	20	0	Search Term 2
320	SORT_PHN	☐	AD_SRTPHN	CHAR20	CHAR	20	0	(Not Supported) Phonetic Search Sort Field
321	ADDRORIGIN	☐	AD_ORIGINA	AD_ORIGIN	CHAR	4	0	(Not Supported) Address Data Source (Key)
322	EXTENSION1	☐	AD_EXTENS1	TEXT40	CHAR	40	0	Extension (only for data conversion) (e.g. data line)
323	EXTENSION2	☐	AD_EXTENS2	TEXT40	CHAR	40	0	Extension (only for data conversion) (e.g. telebox)
324	TIME_ZONE	☐	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone
325	TAXJURCODE	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
326	ADDRESS_ID	☐	AD_ADDR_ID	AD_ADDR_ID	CHAR	10	0	(Not supported) Physical address ID
327	REMARK	☐	AD_REMARK1	TEXT50	CHAR	50	0	Address notes
328	LANGU_CREA	☐	AD_LANGUCR	SPRAS	LANG	1	0	Address record creation original language
329	PO_BOX_LOBBY	☐	AD_PO_BOX_LBY	TEXT40	CHAR	40	0	PO Box Lobby
330	DELI_SERV_TYPE	☐	AD_DELIVERY_SERVICE_TYPE	AD_DELIVERY_SERVICE_TYPE	CHAR	4	0	Type of Delivery Service
331	DELI_SERV_NUMBER	☐	AD_DELIVERY_SERVICE_NUMBER	CHAR10	CHAR	10	0	Number of Delivery Service
332	COUNTY_CODE	☐	AD_CNTYNUM	CNTY_CODE	CHAR	8	0	County code for county
333	COUNTY	☐	AD_COUNTY	TEXT40	CHAR	40	0	County
334	TOWNSHIP_CODE	☐	AD_TWSHPNUM	TWSHP_CODE	CHAR	8	0	Township code for Township
335	TOWNSHIP	☐	AD_TOWNSHIP	TEXT40	CHAR	40	0	Township
336	DEFLT_COMM	☐	AD_DFLTCMM	AD_COMTYPE	CHAR	3	0	Standard communication type
337	TEL_NUMBER	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
338	TEL_EXTENS	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
339	FAX_NUMBER	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
340	FAX_EXTENS	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
341	VALID_FROM	☐	BU_VALID_FROM_DATS	DATUM	DATS	8	0	Valid From
342	VALID_TO	☐	BU_VALID_TO_DATS	DATUM	DATS	8	0	Valid To
343	WA_SENDER	☐	BUS000_EXT		STRU	0	0
344	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
345	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number
346	.INCLUDE	☐				0	0	BP: General Data I (Data Fields - External)
347	.INCLUDE	☐				0	0	CBP: General data (independent of partner cat.)
348	.INCLUDE	☐				0	0	CBP: General Data (not dep. on Part. Cat.), Initial Screen
349	TYPE	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
350	BPKIND	☐	BU_BPKIND	BU_KIND	CHAR	4	0	Business Partner Type
351	BU_GROUP	☐	BU_GROUP	BU_GROUP	CHAR	4	0	Business Partner Grouping
352	BPEXT	☐	BU_BPEXT	CHAR20	CHAR	20	0	Business Partner Number in External System
353	.INCLUDE	☐				0	0	CBP: General Data (not dep. on Part. Cat.), Data Screens
354	BU_SORT1	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
355	BU_SORT2	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
356	SOURCE	☐	BU_SOURCE	BU_SOURCE	CHAR	4	0	Data Origin Types
357	TITLE	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key
358	XDELE	☐	BU_XDELE	XFELD	CHAR	1	0	Central Archiving Flag
359	XBLCK	☐	BU_XBLCK	XFELD	CHAR	1	0	Central Block for Business Partner
360	AUGRP	☐	BU_AUGRP	BU_AUGRP	CHAR	4	0	Authorization Group
361	TITLE_LET	☐	BU_TITLE_LET	TEXT50	CHAR	50	0	Salutation
362	BU_LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system
363	CONTACT	☐	BU_CONTACT	BU_CONTACT	CHAR	1	0	Business Partner: Contact Permission
364	NOT_RELEASED	☐	BU_XNOT_RELEASED	XFELD	CHAR	1	0	Indicator: Not Released
365	NOT_LG_COMPETENT	☐	BU_NOT_LEG_COMPETENT	BOOLE	CHAR	1	0	Indicator: Not Legally Competent
366	PRINT_MODE	☐	BU_PRINT_MODE	BU_PRINT_MODE	CHAR	1	0	Business Partner Print Format
367	.INCLUDE	☐				0	0	EEW Extension of BUT000 (Contains CI)
368	BP_EEW_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
369	.INCLUDE	☐				0	0
370	.INCLU--AP	☐				0	0	Cost/Revenue Type in Resource Role
371	RATE	☐	DPR_TV_RATE	DPR_RATE_TYPE	CHAR	15	0	Cost Rate/Revenue Rate for Project Costing
372	.INCLUDE	☐				0	0	CBP: General data (Organization)
373	.INCLUDE	☐				0	0	CBP: General Data, Organization (CHAR Fields)
374	NAME_ORG1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
375	NAME_ORG2	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
376	NAME_ORG3	☐	BU_NAMEOR3	BU_NAME	CHAR	40	0	Name 3 of organization
377	NAME_ORG4	☐	BU_NAMEOR4	BU_NAME	CHAR	40	0	Name 4 of organization
378	LEGAL_ENTY	☐	BU_LEGENTY	BU_LEGENTY	CHAR	2	0	BP: Legal form of organization
379	IND_SECTOR	☐	BU_INDSECT	BU_INDSECT	CHAR	10	0	Industry sector
380	LEGAL_ORG	☐	BU_LEGAL_ORG	BU_LEGAL_ORG	CHAR	2	0	Legal Entity of Organization
381	.INCLUDE	☐				0	0	CBP: General Data, Organization (Non CHAR Fields)
382	FOUND_DAT	☐	BU_FOUND_DAT	DATUM	DATS	8	0	Date organization founded
383	LIQUID_DAT	☐	BU_LIQUID_DAT		DATS	8	0	Liquidation date of organization
384	LOCATION_1	☐	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
385	LOCATION_2	☐	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
386	LOCATION_3	☐	BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
387	.INCLUDE	☐				0	0	CBP: General Data, Person
388	.INCLUDE	☐				0	0	CBP: General Data, Person (CHAR Fields)
389	NAME_LAST	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
390	NAME_FIRST	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
391	NAME_LST2	☐	BU_NAMEPL2	BU_NAME	CHAR	40	0	Other Last Name of a Person
392	NAME_LAST2	☐	BU_BIRTHNM	BU_NAME	CHAR	40	0	Name at birth of business partner
393	NAMEMIDDLE	☐	BU_NAMEMID	BU_NAME	CHAR	40	0	Middle name or second forename of a person
394	TITLE_ACA1	☐	AD_TITLE1	AD_TITLE1	CHAR	4	0	Academic Title: Key
395	TITLE_ACA2	☐	AD_TITLE2	AD_TITLE1	CHAR	4	0	Second academic title (key)
396	TITLE_ROYL	☐	AD_TITLES	AD_TITLES	CHAR	4	0	Name supplement, e.g. noble title (key)
397	PREFIX1	☐	AD_PREFIX	AD_PREFIX	CHAR	4	0	Name Prefix (Key)
398	PREFIX2	☐	AD_PREFIX2	AD_PREFIX	CHAR	4	0	2nd name prefix (key)
399	NAME1_TEXT	☐	BU_NAME1TX	TEXT80	CHAR	80	0	Full Name
400	NICKNAME	☐	BU_NICKNAM	BU_NAME	CHAR	40	0	Nickname of Business Partner (Person)
401	INITIALS	☐	AD_INITS	CHAR10	CHAR	10	0	"Middle Initial" or personal initials
402	NAMEFORMAT	☐	AD_FORMAT	AD_NAMFORM	CHAR	2	0	Name format
403	NAMCOUNTRY	☐	AD_NAMCTRY	LAND1	CHAR	3	0	Country for name format rule
404	LANGU_CORR	☐	BU_LANGU_CORR	SPRAS	LANG	1	0	Business Partner: Correspondence Language
405	XSEXM	☐	BU_XSEXM	XFELD	CHAR	1	0	Selection: Business partner is male
406	XSEXF	☐	BU_XSEXF	XFELD	CHAR	1	0	Selection: Business partner is female
407	BIRTHPL	☐	BU_BIRTHPL	TEXT40	CHAR	40	0	Birthplace of business partner
408	MARST	☐	BU_MARST	BU_MARST	CHAR	1	0	Marital Status of Business Partner
409	EMPLO	☐	BU_EMPLO	BU_EMPLO	CHAR	35	0	Name of Employer of a Natural Person
410	JOBGR	☐	BU_JOBGR	BU_JOBGR	CHAR	4	0	Occupation/group
411	NATIO	☐	BU_NATIO	LAND1	CHAR	3	0	Nationality
412	CNTAX	☐	BU_CNTAX	LAND1	CHAR	3	0	Obsolete Field
413	CNDSC	☐	BU_CNDSC	LAND1	CHAR	3	0	Ctry of Origin: Non-Res. Companies
414	PERSNUMBER	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number
415	XSEXU	☐	BU_XSEXU	XFELD	CHAR	1	0	Selection: Sex of business partner is not known
416	XUBNAME	☐	BU_XUBNAME	XUBNAME	CHAR	12	0	Obsolete Field
417	BU_LANGU	☐	BU_LANGU	SPRAS	LANG	1	0	Business partner: Language
418	.INCLUDE	☐				0	0	CBP: General Data, Person (Non CHAR Fields)
419	BIRTHDT	☐	BU_BIRTHDT	DATUM	DATS	8	0	Date of Birth of Business Partner
420	DEATHDT	☐	BU_DEATHDT	DATUM	DATS	8	0	Date of death of business partner
421	PERNO	☐	BU_PERNO	PERSONID	NUMC	8	0	Personnel Number
422	CHILDREN	☐	BU_CHILDREN	NUMC2	NUMC	2	0	Obsolete Field
423	MEM_HOUSE	☐	BU_MEM_HOUSE	DEC2	DEC	2	0	Obsolete Field
424	.INCLUDE	☐				0	0	CBP: General data (group of people)
425	PARTGRPTYP	☐	BU_GRPTYP	BU_GRPTYP	CHAR	4	0	Group type
426	NAME_GRP1	☐	BU_NAMEGR1	BU_NAME	CHAR	40	0	Name 1 (group)
427	NAME_GRP2	☐	BU_NAMEGR2	BU_NAME	CHAR	40	0	Name 2 (group)
428	.INCLUDE	☐				0	0	BP: General data II
429	.INCLUDE	☐				0	0	BP: General Data II (CHAR Fields)
430	LGTYP	☐	BU_LGTYP	BU_LGTYP	CHAR	4	0	Legitimation Type
431	LGNUM	☐	BU_LGNUM	BU_LGNUM	CHAR	16	0	Identification number of legitimation document
432	INFCT	☐	BU_INFCT	BU_INFCT	CHAR	30	0	Responsible local court
433	COMRG	☐	BU_COMRG	CHAR30	CHAR	30	0	Entry in commercial register
434	CLBRG	☐	BU_CLBRG	CHAR30	CHAR	30	0	BP: Entry in register of associations
435	COPRG	☐	BU_COPRG	CHAR30	CHAR	30	0	Entry in Register of Cooperatives
436	.INCLUDE	☐				0	0	BP: General Data II (Non CHAR Fields)
437	COMREG_DAT	☐	BU_COMREG_DAT	DATUM	DATS	8	0	Date of entry in trade register
438	.INCLUDE	☐				0	0	CBP: Name fields combined (lower case)
439	NAME1	☐	BU_NAME1	BU_NAME	CHAR	40	0	Name field 1 (name1/last name)
440	NAME2	☐	BU_NAME2	BU_NAME	CHAR	40	0	Name field 2 (name2/first name)
441	.INCLUDE	☐				0	0	BP: Address Data (Read)
442	.INCLUDE	☐				0	0	Include structure with ADRC attributes without name fields
443	NAME_CO	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
444	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
445	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
446	CITY_CODE	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file
447	CITYP_CODE	☐	AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file
448	HOME_CITY	☐	AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
449	CITYH_CODE	☐	AD_CITYHNM	CITY_CODE	CHAR	12	0	Different city for city/street file
450	CHCKSTATUS	☐	AD_CHECKST	AD_CHECKST	CHAR	1	0	City file test status
451	REGIOGROUP	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping
452	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
453	POST_CODE2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
454	POST_CODE3	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
455	PCODE1_EXT	☐	AD_PST1XT	CHAR10	CHAR	10	0	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
456	PCODE2_EXT	☐	AD_PST2XT	CHAR10	CHAR	10	0	(Not Supported) PO Box Postal Code Extension
457	PCODE3_EXT	☐	AD_PST3XT	CHAR10	CHAR	10	0	(Not Supported) Major Customer Postal Code Extension
458	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
459	DONT_USE_P	☐	AD_NO_USEP	AD_NO_USE	CHAR	4	0	PO Box Address Undeliverable Flag
460	PO_BOX_NUM	☐	AD_POBXNUM	XFELD	CHAR	1	0	Flag: PO Box without number
461	PO_BOX_LOC	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
462	CITY_CODE2	☐	AD_CIT2NUM	CITY_CODE	CHAR	12	0	City PO box code (City file)
463	PO_BOX_REG	☐	AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)
464	PO_BOX_CTY	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country
465	POSTALAREA	☐	AD_PSTLAR	TEXT15	CHAR	15	0	(Not Supported) Post Delivery District
466	TRANSPZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered
467	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
468	DONT_USE_S	☐	AD_NO_USES	AD_NO_USE	CHAR	4	0	Street Address Undeliverable Flag
469	STREETCODE	☐	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File
470	STREETABBR	☐	AD_STRABBR	STRTYPEAB	CHAR	2	0	(Not Supported) Abbreviation of Street Name
471	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
472	HOUSE_NUM2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
473	HOUSE_NUM3	☐	AD_HSNM3	TEXT10	CHAR	10	0	(Not supported) House Number Range
474	STR_SUPPL1	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
475	STR_SUPPL2	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
476	STR_SUPPL3	☐	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
477	LOCATION	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
478	BUILDING	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
479	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
480	ROOMNUMBER	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
481	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key
482	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key
483	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
484	SORT1	☐	AD_SORT1UL	TEXT20	CHAR	20	0	Search Term 1
485	SORT2	☐	AD_SORT2UL	TEXT20	CHAR	20	0	Search Term 2
486	SORT_PHN	☐	AD_SRTPHN	CHAR20	CHAR	20	0	(Not Supported) Phonetic Search Sort Field
487	ADDRORIGIN	☐	AD_ORIGINA	AD_ORIGIN	CHAR	4	0	(Not Supported) Address Data Source (Key)
488	EXTENSION1	☐	AD_EXTENS1	TEXT40	CHAR	40	0	Extension (only for data conversion) (e.g. data line)
489	EXTENSION2	☐	AD_EXTENS2	TEXT40	CHAR	40	0	Extension (only for data conversion) (e.g. telebox)
490	TIME_ZONE	☐	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone
491	TAXJURCODE	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
492	ADDRESS_ID	☐	AD_ADDR_ID	AD_ADDR_ID	CHAR	10	0	(Not supported) Physical address ID
493	REMARK	☐	AD_REMARK1	TEXT50	CHAR	50	0	Address notes
494	LANGU_CREA	☐	AD_LANGUCR	SPRAS	LANG	1	0	Address record creation original language
495	PO_BOX_LOBBY	☐	AD_PO_BOX_LBY	TEXT40	CHAR	40	0	PO Box Lobby
496	DELI_SERV_TYPE	☐	AD_DELIVERY_SERVICE_TYPE	AD_DELIVERY_SERVICE_TYPE	CHAR	4	0	Type of Delivery Service
497	DELI_SERV_NUMBER	☐	AD_DELIVERY_SERVICE_NUMBER	CHAR10	CHAR	10	0	Number of Delivery Service
498	COUNTY_CODE	☐	AD_CNTYNUM	CNTY_CODE	CHAR	8	0	County code for county
499	COUNTY	☐	AD_COUNTY	TEXT40	CHAR	40	0	County
500	TOWNSHIP_CODE	☐	AD_TWSHPNUM	TWSHP_CODE	CHAR	8	0	Township code for Township
501	TOWNSHIP	☐	AD_TOWNSHIP	TEXT40	CHAR	40	0	Township
502	DEFLT_COMM	☐	AD_DFLTCMM	AD_COMTYPE	CHAR	3	0	Standard communication type
503	TEL_NUMBER	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
504	TEL_EXTENS	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
505	FAX_NUMBER	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
506	FAX_EXTENS	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
507	VALID_FROM	☐	BU_VALID_FROM_DATS	DATUM	DATS	8	0	Valid From
508	VALID_TO	☐	BU_VALID_TO_DATS	DATUM	DATS	8	0	Valid To
509	.INCLUDE	☐				0	0	BP: Tax Numbers: General Data
510	NATPERS	☐	BU_NATURAL_PERSON	BU_NATURAL_PERSON	CHAR	1	0	Business Partner Is a Natural Person Under the Tax Laws
511	WA_SEN_ADRESS	☐	BUS020_EXT		STRU	0	0
512	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
513	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number
514	.INCLUDE	☐				0	0	BP: Addresses (Data Fields Ext.)
515	.INCLUDE	☐				0	0	BP: Addresses (CHAR Data Fields External)
516	XDFADR	☐	BU_XDFADR	XFELD	CHAR	1	0	Indicator: Address is standard address
517	ADEXT	☐	BU_ADEXT	BU_ADEXT	CHAR	20	0	Address number in external system
518	NATION	☐	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses
519	GUID	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
520	MOVE_ADDR	☐	BU_MOVE_ADDR	AD_ADDRNUM	CHAR	10	0	Number of Move Target Address for Address Moves
521	.INCLUDE	☐				0	0	BP: Addresses (Non-CHAR Data Fields External)
522	DATE_FROM	☐	BU_DATE_OBSOLETE	DATUM	DATS	8	0	Date Obsolete
523	ADDRESS_GUID	☐	BU_ADDRESS_GUID	SYSUUID	RAW	16	0	GUID of a Business Partner Address
524	ADDR_VALID_FROM	☐	BU_ADDR_VALID_FROM	TZNTSTMPS	DEC	15	0	Validity Start of a Business Partner Address
525	ADDR_VALID_TO	☐	BU_ADDR_VALID_TO	TZNTSTMPS	DEC	15	0	Validity End of a Business Partner Address
526	ADDR_MOVE_DATE	☐	BU_ADDR_MOVE_DATE	TZNTSTMPS	DEC	15	0	Date of Move for Address Moves
527	.INCLUDE	☐				0	0	BP: Address Data (Read)
528	.INCLUDE	☐				0	0	Include structure with ADRC attributes without name fields
529	NAME_CO	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
530	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
531	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
532	CITY_CODE	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file
533	CITYP_CODE	☐	AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file
534	HOME_CITY	☐	AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
535	CITYH_CODE	☐	AD_CITYHNM	CITY_CODE	CHAR	12	0	Different city for city/street file
536	CHCKSTATUS	☐	AD_CHECKST	AD_CHECKST	CHAR	1	0	City file test status
537	REGIOGROUP	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping
538	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
539	POST_CODE2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
540	POST_CODE3	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
541	PCODE1_EXT	☐	AD_PST1XT	CHAR10	CHAR	10	0	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
542	PCODE2_EXT	☐	AD_PST2XT	CHAR10	CHAR	10	0	(Not Supported) PO Box Postal Code Extension
543	PCODE3_EXT	☐	AD_PST3XT	CHAR10	CHAR	10	0	(Not Supported) Major Customer Postal Code Extension
544	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
545	DONT_USE_P	☐	AD_NO_USEP	AD_NO_USE	CHAR	4	0	PO Box Address Undeliverable Flag
546	PO_BOX_NUM	☐	AD_POBXNUM	XFELD	CHAR	1	0	Flag: PO Box without number
547	PO_BOX_LOC	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
548	CITY_CODE2	☐	AD_CIT2NUM	CITY_CODE	CHAR	12	0	City PO box code (City file)
549	PO_BOX_REG	☐	AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)
550	PO_BOX_CTY	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country
551	POSTALAREA	☐	AD_PSTLAR	TEXT15	CHAR	15	0	(Not Supported) Post Delivery District
552	TRANSPZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered
553	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
554	DONT_USE_S	☐	AD_NO_USES	AD_NO_USE	CHAR	4	0	Street Address Undeliverable Flag
555	STREETCODE	☐	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File
556	STREETABBR	☐	AD_STRABBR	STRTYPEAB	CHAR	2	0	(Not Supported) Abbreviation of Street Name
557	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
558	HOUSE_NUM2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
559	HOUSE_NUM3	☐	AD_HSNM3	TEXT10	CHAR	10	0	(Not supported) House Number Range
560	STR_SUPPL1	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
561	STR_SUPPL2	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
562	STR_SUPPL3	☐	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
563	LOCATION	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
564	BUILDING	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
565	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
566	ROOMNUMBER	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
567	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key
568	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key
569	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
570	SORT1	☐	AD_SORT1UL	TEXT20	CHAR	20	0	Search Term 1
571	SORT2	☐	AD_SORT2UL	TEXT20	CHAR	20	0	Search Term 2
572	SORT_PHN	☐	AD_SRTPHN	CHAR20	CHAR	20	0	(Not Supported) Phonetic Search Sort Field
573	ADDRORIGIN	☐	AD_ORIGINA	AD_ORIGIN	CHAR	4	0	(Not Supported) Address Data Source (Key)
574	EXTENSION1	☐	AD_EXTENS1	TEXT40	CHAR	40	0	Extension (only for data conversion) (e.g. data line)
575	EXTENSION2	☐	AD_EXTENS2	TEXT40	CHAR	40	0	Extension (only for data conversion) (e.g. telebox)
576	TIME_ZONE	☐	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone
577	TAXJURCODE	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
578	ADDRESS_ID	☐	AD_ADDR_ID	AD_ADDR_ID	CHAR	10	0	(Not supported) Physical address ID
579	REMARK	☐	AD_REMARK1	TEXT50	CHAR	50	0	Address notes
580	LANGU_CREA	☐	AD_LANGUCR	SPRAS	LANG	1	0	Address record creation original language
581	PO_BOX_LOBBY	☐	AD_PO_BOX_LBY	TEXT40	CHAR	40	0	PO Box Lobby
582	DELI_SERV_TYPE	☐	AD_DELIVERY_SERVICE_TYPE	AD_DELIVERY_SERVICE_TYPE	CHAR	4	0	Type of Delivery Service
583	DELI_SERV_NUMBER	☐	AD_DELIVERY_SERVICE_NUMBER	CHAR10	CHAR	10	0	Number of Delivery Service
584	COUNTY_CODE	☐	AD_CNTYNUM	CNTY_CODE	CHAR	8	0	County code for county
585	COUNTY	☐	AD_COUNTY	TEXT40	CHAR	40	0	County
586	TOWNSHIP_CODE	☐	AD_TWSHPNUM	TWSHP_CODE	CHAR	8	0	Township code for Township
587	TOWNSHIP	☐	AD_TOWNSHIP	TEXT40	CHAR	40	0	Township
588	DEFLT_COMM	☐	AD_DFLTCMM	AD_COMTYPE	CHAR	3	0	Standard communication type
589	TEL_NUMBER	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
590	TEL_EXTENS	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
591	FAX_NUMBER	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
592	FAX_EXTENS	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
593	VALID_FROM	☐	BU_VALID_FROM_DATS	DATUM	DATS	8	0	Valid From
594	VALID_TO	☐	BU_VALID_TO_DATS	DATUM	DATS	8	0	Valid To
595	WA_ACCRUAL	☐	FKKR_LAUFD		STRU	0	0
596	SIGN	☐	S_SIGN	S_SIGN	CHAR	1	0	Sign (like RANGES table)
597	OPTION	☐	S_OPTION	S_OPTION	CHAR	2	0	Option (like RANGES table)
598	LOW	☐	LAUFD_KK	DATUM	DATS	8	0	Date ID
599	HIGH	☐	LAUFD_KK	DATUM	DATS	8	0	Date ID
600	T_TAX_EXEMPT	☐	FICA_TAXEXEMPT_TAB_TAX_EXEMPT		TTYP	0	0

History

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