Field
Type
Length
Data element
Description
CLIENT
CLNT
000003
Client
PARTNER
CHAR
000010
Business Partner Number
ERFUSER
CHAR
000012
Created By
ERFDATE
DATS
000008
Created On
ERFTIME
TIMS
000006
Time Created
AENUSER
CHAR
000012
Last Changed By
AENDATE
DATS
000008
Date of Last Change
AENTIME
TIMS
000006
Time of Last Change
XVERMSACH
CHAR
000001
IS-M: BP Authorized to Receive Gifts
XMITARB
CHAR
000001
IS-M: Employee Indicator
PERNR
CHAR
000020
IS-M: Personnel Number
XNOWERB
CHAR
000001
IS-M: No Advertising
XVERB
CHAR
000001
IS-M: Association Indicator
XINTERN
CHAR
000001
IS-M: Internal Business Partner Indicator
XSOZIAL
CHAR
000001
IS-M: Social Facility Indicator
XVERLEIG
CHAR
000001
IS-M: Indicator: Owned By Publisher
VERLVKORG
CHAR
000004
IS-M: Publisher's Sales Organization
XINSER
CHAR
000001
IS-M: Selection Indicator for Advertiser
XAGEN
CHAR
000001
IS-M: Agency Indicator
AGEN_ART
CHAR
000001
IS-M: Creative Boutique Indicator
AGEN_STR
CHAR
000001
IS-M: Distribution Agency Indicator
AGEN_PLAN
CHAR
000001
IS-M: Planning Agency Indicator
AGEN_GRU
CHAR
000001
IS-M: Agency Type
GP_DUB
CHAR
000001
IS-M: Credit Query Indicator
BON
CHAR
000002
IS-M: Creditworthiness Indicator
WBZKUNNR
CHAR
000006
IS-M: WBZ, VDZ Number of WBZ Company
RECHZENTNR
CHAR
000002
IS-M: WBZ, Computer Center Number
XWBZFIRMA
CHAR
000001
IS-M: Business Partner Is WBZ Company
WBZZLSCH
CHAR
000001
Payment Method for Billing Documents to WBZ Company
REFBELEG
CHAR
000020
IS-M/SD: Reference Document in Legacy System
J_SOC_SECU
CHAR
000020
Social Insurance Number
SEARCHTERM1
CHAR
000020
Search Term 1 for Business Partner
SEARCHTERM2
CHAR
000020
Search Term 2 for Business Partner
PARTNERTYPE
CHAR
000004
Business Partner Type
AUTHORIZATIONGROUP
CHAR
000004
Authorization Group
PARTNERLANGUAGE
LANG
000001
Business partner: Language
PARTNERLANGUAGEISO
CHAR
000002
2-Character SAP Language Code
DATAORIGINTYPE
CHAR
000004
Data Origin Types
CENTRALARCHIVINGFLAG
CHAR
000001
Central Archiving Flag
CENTRALBLOCK
CHAR
000001
Central Block for Business Partner
TITLE_KEY
CHAR
000004
Form-of-Address Key
CONTACTALLOWANCE
CHAR
000001
Business Partner: Contact Permission
PARTNEREXTERNAL
CHAR
000020
Business Partner Number in External System
TITLELETTER
CHAR
000050
Salutation
NOTRELEASED
CHAR
000001
Indicator: Not Released
COMM_TYPE
CHAR
000003
Communication Method (Key) (Business Address Services)
PRINT_MODE
CHAR
000001
Business Partner Print Format
FIRSTNAME
CHAR
000040
First name of business partner (person)
LASTNAME
CHAR
000040
Last name of business partner (person)
BIRTHNAME
CHAR
000040
Name at birth of business partner
MIDDLENAME
CHAR
000040
Middle name or second forename of a person
SECONDNAME
CHAR
000040
Other Last Name of a Person
TITLE_ACA1
CHAR
000004
Academic Title: Key
TITLE_ACA2
CHAR
000004
Second academic title (key)
TITLE_SPPL
CHAR
000004
Name supplement, e.g. noble title (key)
PREFIX1
CHAR
000004
Name Prefix (Key)
PREFIX2
CHAR
000004
2nd name prefix (key)
NICKNAME
CHAR
000040
Nickname of Business Partner (Person)
INITIALS
CHAR
000010
"Middle Initial" or personal initials
NAMEFORMAT
CHAR
000002
Name format
NAMCOUNTRY
CHAR
000003
Country/Region for Name Format Rule
NAMCOUNTRYISO
CHAR
000002
ISO Code of the Country/Region
SEX
CHAR
000001
Sex of business partner (person)
BIRTHPLACE
CHAR
000040
Birthplace of business partner
BIRTHDATE
DATS
000008
Date of Birth of Business Partner
DEATHDATE
DATS
000008
Date of death of business partner
MARITALSTATUS
CHAR
000001
Marital Status of Business Partner
CORRESPONDLANGUAGE
LANG
000001
Business Partner: Correspondence Language
CORRESPONDLANGUAGEISO
CHAR
000002
2-Character SAP Language Code
FULLNAME
CHAR
000080
Full Name
EMPLOYER
CHAR
000035
Name of Employer of a Natural Person
OCCUPATION
CHAR
000004
Occupation/group
NATIONALITY
CHAR
000003
Nationality
NATIONALITYISO
CHAR
000002
ISO Code of the Country/Region
COUNTRYORIGIN
CHAR
000003
Country/Region of Origin: Non-Resident Companies
NAME1
CHAR
000040
Name 1 of organization
NAME2
CHAR
000040
Name 2 of organization
NAME3
CHAR
000040
Name 3 of organization
NAME4
CHAR
000040
Name 4 of organization
LEGALFORM
CHAR
000002
BP: Legal form of organization
INDUSTRYSECTOR
CHAR
000010
Industry sector
FOUNDATIONDATE
DATS
000008
Date organization founded
LIQUIDATIONDATE
DATS
000008
Liquidation date of organization
LOC_NO_1
NUMC
000007
International location number (part 1)
LOC_NO_2
NUMC
000005
International location number (Part 2)
CHK_DIGIT
NUMC
000001
Check digit for the international location number
LEGALORG
CHAR
000002
Legal Entity of Organization
NAMEGROUP1
CHAR
000040
Name 1 (group)
NAMEGROUP2
CHAR
000040
Name 2 (group)
GROUPTYPE
CHAR
000004
Group type
CREATIONDATE
DATS
000008
Date on which the object was created
CREATIONTIME
TIMS
000006
Time at which the object was created
CREATIONUSER
CHAR
000012
User who created the object
LASTCHANGEDATE
DATS
000008
Date when object was last changed
LASTCHANGETIME
TIMS
000006
Time at which object was last changed
LASTCHANGEUSER
CHAR
000012
Last user to change object
PERS_NO
CHAR
000010
Person Number
STANDARDADDRESS
CHAR
000001
Indicator: Address is standard address
C_O_NAME
CHAR
000040
c/o name
DISTRICT
CHAR
000040
District
REGIOGROUP
CHAR
000008
Regional structure grouping
POSTL_COD1
CHAR
000010
City postal code
POSTL_COD2
CHAR
000010
PO Box Postal Code
POSTL_COD3
CHAR
000010
Company Postal Code (for Large Customers)
PCODE1_EXT
CHAR
000010
(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
PCODE2_EXT
CHAR
000010
(Not Supported) PO Box Postal Code Extension
PCODE3_EXT
CHAR
000010
(Not Supported) Major Customer Postal Code Extension
PO_BOX
CHAR
000010
PO Box
PO_W_O_NO
CHAR
000001
Flag: PO Box Without Number
PO_BOX_CIT
CHAR
000040
PO Box city
PO_BOX_REG
CHAR
000003
Region for PO Box (Country/Region, State, Province, ...)
POBOX_CTRY
CHAR
000003
PO Box of Country/Region
PO_CTRYISO
CHAR
000002
ISO Code of the Country/Region
STREET
CHAR
000060
Street
STR_ABBR
CHAR
000002
(Not Supported) Abbreviation of Street Name
HOUSE_NO
CHAR
000010
House Number
HOUSE_NO2
CHAR
000010
House number supplement
HOUSE_NO3
CHAR
000010
(Not supported) House Number Range
STR_SUPPL1
CHAR
000040
Street 2
STR_SUPPL2
CHAR
000040
Street 3
STR_SUPPL3
CHAR
000040
Street 4
LOCATION
CHAR
000040
Street 5
BUILDING
CHAR
000020
Building (Number or Code)
FLOOR
CHAR
000010
Floor in building
ROOM_NO
CHAR
000010
Room or Apartment Number
COUNTRY
CHAR
000003
Country/Region Key
COUNTRYISO
CHAR
000002
ISO Code of the Country/Region
REGION
CHAR
000003
Region (State, Province, County)
TIME_ZONE
CHAR
000006
Address time zone
TAXJURCODE
CHAR
000015
Tax Jurisdiction
HOME_CITY
CHAR
000040
City (different from postal city)
TRANSPZONE
CHAR
000010
Transportation zone to or from which the goods are delivered
LANGU
LANG
000001
Language Key
LANGUISO
CHAR
000002
2-Character SAP Language Code
EXTADDRESSNUMBER
CHAR
000020
Address number in external system
DONT_USE_P
CHAR
000004
PO Box Address Undeliverable Flag
DONT_USE_S
CHAR
000004
Street Address Undeliverable Flag
TELEPHONE
CHAR
000030
Telephone No.: Dialing Code + Number
EXTENSION
CHAR
000010
Telephone no.: Extension
TEL_NO
CHAR
000030
Complete Number: Dialing Code+Number+Extension
FAX
CHAR
000030
Fax Number: Dialing Code+Number
FAX_EXTENSION
CHAR
000010
Fax no.: Extension
FAX_NO
CHAR
000030
Complete Number: Dialing Code+Number+Extension
E_MAIL
CHAR
000241
E-Mail Address
Length: 40443 Date: 20240419 Time: 202658 sap01-206 ( 98 ms )
