PARTN_ROLE |
Partner Function |
CHAR |
2 |
0 |
|
PARVW
|
|
PARTNER |
Business Partner Number |
CHAR |
10 |
0 |
BUT000
|
BU_PARTNER
|
|
ADDRNUMBER |
Address Number |
CHAR |
10 |
0 |
*
|
AD_ADDRNUM
|
|
TYPE |
Business Partner Category |
CHAR |
1 |
0 |
|
BU_TYPE
|
1 |
Person |
2 |
Organization |
3 |
Group |
|
BPKIND |
Business Partner Type |
CHAR |
4 |
0 |
TB004
|
BU_BPKIND
|
|
BU_GROUP |
Business Partner Grouping |
CHAR |
4 |
0 |
TB001
|
BU_GROUP
|
|
BPEXT |
Business Partner Number in External System |
CHAR |
20 |
0 |
|
BU_BPEXT
|
|
BU_SORT1 |
Search Term 1 for Business Partner |
CHAR |
20 |
0 |
|
BU_SORT1
|
|
BU_SORT2 |
Search Term 2 for Business Partner |
CHAR |
20 |
0 |
|
BU_SORT2
|
|
SOURCE |
Data Origin Types |
CHAR |
4 |
0 |
TB005
|
BU_SOURCE
|
|
TITLE |
Form-of-Address Key |
CHAR |
4 |
0 |
TSAD3
|
AD_TITLE
|
|
XDELE |
Central Archiving Flag |
CHAR |
1 |
0 |
|
BU_XDELE
|
|
XBLCK |
Central Block for Business Partner |
CHAR |
1 |
0 |
|
BU_XBLCK
|
|
AUGRP |
Authorization Group |
CHAR |
4 |
0 |
*
|
BU_AUGRP
|
|
TITLE_LET |
Salutation |
CHAR |
50 |
0 |
|
BU_TITLE_LET
|
|
BU_LOGSYS |
Logical system |
CHAR |
10 |
0 |
TBDLS
|
LOGSYS
|
|
CONTACT |
Business Partner: Contact Permission |
CHAR |
1 |
0 |
|
BU_CONTACT
|
1 |
Permitted |
2 |
Forbidden |
3 |
Check permission |
|
NOT_RELEASED |
Indicator: Not Released |
CHAR |
1 |
0 |
|
BU_XNOT_RELEASED
|
|
NOT_LG_COMPETENT |
Indicator: Not Legally Competent |
CHAR |
1 |
0 |
|
BU_NOT_LEG_COMPETENT
|
|
PRINT_MODE |
Business Partner Print Format |
CHAR |
1 |
0 |
|
BU_PRINT_MODE
|
|
BP_EEW_DUMMY |
Dummy function in length 1 |
CHAR |
1 |
0 |
|
DUMMY
|
|
RATE |
Cost Rate/Revenue Rate for Project Costing |
CHAR |
15 |
0 |
DPR_RATES
|
DPR_TV_RATE
|
|
NAME_ORG1 |
Name 1 of organization |
CHAR |
40 |
0 |
|
BU_NAMEOR1
|
|
NAME_ORG2 |
Name 2 of organization |
CHAR |
40 |
0 |
|
BU_NAMEOR2
|
|
NAME_ORG3 |
Name 3 of organization |
CHAR |
40 |
0 |
|
BU_NAMEOR3
|
|
NAME_ORG4 |
Name 4 of organization |
CHAR |
40 |
0 |
|
BU_NAMEOR4
|
|
LEGAL_ENTY |
BP: Legal form of organization |
CHAR |
2 |
0 |
TB019
|
BU_LEGENTY
|
|
IND_SECTOR |
Industry sector |
CHAR |
10 |
0 |
TB023
|
BU_INDSECT
|
|
LEGAL_ORG |
Legal Entity of Organization |
CHAR |
2 |
0 |
TB032
|
BU_LEGAL_ORG
|
|
FOUND_DAT |
Date organization founded |
DATS |
8 |
0 |
|
BU_FOUND_DAT
|
|
LIQUID_DAT |
Liquidation date of organization |
DATS |
8 |
0 |
|
BU_LIQUID_DAT
|
|
LOCATION_1 |
International location number (part 1) |
NUMC |
7 |
0 |
|
BBBNR
|
|
LOCATION_2 |
International location number (Part 2) |
NUMC |
5 |
0 |
|
BBSNR
|
|
LOCATION_3 |
Check digit for the international location number |
NUMC |
1 |
0 |
|
BUBKZ
|
|
NAME_LAST |
Last name of business partner (person) |
CHAR |
40 |
0 |
|
BU_NAMEP_L
|
|
NAME_FIRST |
First name of business partner (person) |
CHAR |
40 |
0 |
|
BU_NAMEP_F
|
|
NAME_LST2 |
Other Last Name of a Person |
CHAR |
40 |
0 |
|
BU_NAMEPL2
|
|
NAME_LAST2 |
Name at birth of business partner |
CHAR |
40 |
0 |
|
BU_BIRTHNM
|
|
NAMEMIDDLE |
Middle name or second forename of a person |
CHAR |
40 |
0 |
|
BU_NAMEMID
|
|
TITLE_ACA1 |
Academic Title: Key |
CHAR |
4 |
0 |
TSAD2
|
AD_TITLE1
|
|
TITLE_ACA2 |
Second academic title (key) |
CHAR |
4 |
0 |
TSAD2
|
AD_TITLE2
|
|
TITLE_ROYL |
Name supplement, e.g. noble title (key) |
CHAR |
4 |
0 |
TSAD5
|
AD_TITLES
|
|
PREFIX1 |
Name Prefix (Key) |
CHAR |
4 |
0 |
TSAD4
|
AD_PREFIX
|
|
PREFIX2 |
2nd name prefix (key) |
CHAR |
4 |
0 |
TSAD4
|
AD_PREFIX2
|
|
NAME1_TEXT |
Full Name |
CHAR |
80 |
0 |
|
BU_NAME1TX
|
|
NICKNAME |
Nickname of Business Partner (Person) |
CHAR |
40 |
0 |
|
BU_NICKNAM
|
|
INITIALS |
"Middle Initial" or personal initials |
CHAR |
10 |
0 |
|
AD_INITS
|
|
NAMEFORMAT |
Name format |
CHAR |
2 |
0 |
T005N
|
AD_FORMAT
|
|
NAMCOUNTRY |
Country/Region for Name Format Rule |
CHAR |
3 |
0 |
T005
|
AD_NAMCTRY
|
|
LANGU_CORR |
Business Partner: Correspondence Language |
LANG |
1 |
0 |
T002
|
BU_LANGU_CORR
|
|
XSEXM |
Selection: Business partner is male |
CHAR |
1 |
0 |
|
BU_XSEXM
|
|
XSEXF |
Selection: Business partner is female |
CHAR |
1 |
0 |
|
BU_XSEXF
|
|
BIRTHPL |
Birthplace of business partner |
CHAR |
40 |
0 |
|
BU_BIRTHPL
|
|
MARST |
Marital Status of Business Partner |
CHAR |
1 |
0 |
TB027
|
BU_MARST
|
|
EMPLO |
Name of Employer of a Natural Person |
CHAR |
35 |
0 |
|
BU_EMPLO
|
|
JOBGR |
Occupation/group |
CHAR |
4 |
0 |
TB028
|
BU_JOBGR
|
|
NATIO |
Nationality |
CHAR |
3 |
0 |
T005
|
BU_NATIO
|
|
CNTAX |
Obsolete Field |
CHAR |
3 |
0 |
*
|
BU_CNTAX
|
|
CNDSC |
Country/Region of Origin: Non-Resident Companies |
CHAR |
3 |
0 |
T005
|
BU_CNDSC
|
|
PERSNUMBER |
Person Number |
CHAR |
10 |
0 |
|
AD_PERSNUM
|
|
XSEXU |
Selection: Sex of business partner is not known |
CHAR |
1 |
0 |
|
BU_XSEXU
|
|
XUBNAME |
Obsolete Field |
CHAR |
12 |
0 |
USR02
|
BU_XUBNAME
|
|
BU_LANGU |
Business partner: Language |
LANG |
1 |
0 |
T002
|
BU_LANGU
|
|
GENDER |
Sex of business partner (person) |
CHAR |
1 |
0 |
TB995
|
BU_SEXID
|
|
BIRTHDT |
Date of Birth of Business Partner |
DATS |
8 |
0 |
|
BU_BIRTHDT
|
|
DEATHDT |
Date of death of business partner |
DATS |
8 |
0 |
|
BU_DEATHDT
|
|
PERNO |
Personnel Number |
NUMC |
8 |
0 |
|
BU_PERNO
|
|
CHILDREN |
Obsolete Field |
NUMC |
2 |
0 |
|
BU_CHILDREN
|
|
MEM_HOUSE |
Obsolete Field |
DEC |
2 |
0 |
|
BU_MEM_HOUSE
|
|
BIRTHDT_STATUS |
Date of Birth: Status |
CHAR |
1 |
0 |
|
BU_BIRTHDT_STATUS
|
|
Fully known |
A |
Day and Month Unknown |
B |
Month and Year Unknown |
C |
Day and Year Unknown |
D |
Day Unknown |
K |
Fully Known |
M |
Month Unknown |
U |
Fully Unknown |
Y |
Year Unknown |
|
PARTGRPTYP |
Group type |
CHAR |
4 |
0 |
TB025
|
BU_GRPTYP
|
|
NAME_GRP1 |
Name 1 (group) |
CHAR |
40 |
0 |
|
BU_NAMEGR1
|
|
NAME_GRP2 |
Name 2 (group) |
CHAR |
40 |
0 |
|
BU_NAMEGR2
|
|
LGTYP |
Legitimation Type |
CHAR |
4 |
0 |
TB029
|
BU_LGTYP
|
|
LGNUM |
Identification number of legitimation document |
CHAR |
16 |
0 |
|
BU_LGNUM
|
|
INFCT |
Responsible local court |
CHAR |
30 |
0 |
|
BU_INFCT
|
|
COMRG |
Entry in commercial register |
CHAR |
30 |
0 |
|
BU_COMRG
|
|
CLBRG |
BP: Entry in register of associations |
CHAR |
30 |
0 |
|
BU_CLBRG
|
|
COPRG |
Entry in Register of Cooperatives |
CHAR |
30 |
0 |
|
BU_COPRG
|
|
COMREG_DAT |
Date of entry in trade register |
DATS |
8 |
0 |
|
BU_COMREG_DAT
|
|
M_BONIWERT |
Creditworthiness value set manually |
NUMC |
4 |
0 |
|
BONIWRT_KK
|
|
M_BONIDAT |
Date on Which Creditworthiness was Manually Set |
DATS |
8 |
0 |
|
BONIDAT_KK
|
|
NAME1 |
Name field 1 (name1/last name) |
CHAR |
40 |
0 |
|
BU_NAME1
|
|
NAME2 |
Name field 2 (name2/first name) |
CHAR |
40 |
0 |
|
BU_NAME2
|
|
NAME_CO |
c/o name |
CHAR |
40 |
0 |
|
AD_NAME_CO
|
|
CITY1 |
City |
CHAR |
40 |
0 |
|
AD_CITY1
|
|
CITY2 |
District |
CHAR |
40 |
0 |
|
AD_CITY2
|
|
CITY_CODE |
City code for city/street file |
CHAR |
12 |
0 |
ADRCITY
|
AD_CITYNUM
|
|
CITYP_CODE |
District code for City and Street file |
CHAR |
8 |
0 |
ADRCITYPRT
|
AD_CITYPNM
|
|
HOME_CITY |
City (different from postal city) |
CHAR |
40 |
0 |
|
AD_CITY3
|
|
CITYH_CODE |
Different city for city/street file |
CHAR |
12 |
0 |
ADRCITY
|
AD_CITYHNM
|
|
CHCKSTATUS |
City file test status |
CHAR |
1 |
0 |
|
AD_CHECKST
|
|
Not Checked |
C |
checked against city index |
D |
differs from city index |
|
REGIOGROUP |
Regional structure grouping |
CHAR |
8 |
0 |
ADRREGGRP
|
REGIOGROUP
|
|
POST_CODE1 |
City postal code |
CHAR |
10 |
0 |
|
AD_PSTCD1
|
|
POST_CODE2 |
PO Box Postal Code |
CHAR |
10 |
0 |
|
AD_PSTCD2
|
|
POST_CODE3 |
Company Postal Code (for Large Customers) |
CHAR |
10 |
0 |
|
AD_PSTCD3
|
|
PCODE1_EXT |
(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code |
CHAR |
10 |
0 |
|
AD_PST1XT
|
|
PCODE2_EXT |
(Not Supported) PO Box Postal Code Extension |
CHAR |
10 |
0 |
|
AD_PST2XT
|
|
PCODE3_EXT |
(Not Supported) Major Customer Postal Code Extension |
CHAR |
10 |
0 |
|
AD_PST3XT
|
|
PO_BOX |
PO Box |
CHAR |
10 |
0 |
|
AD_POBX
|
|
DONT_USE_P |
PO Box Address Undeliverable Flag |
CHAR |
4 |
0 |
TSAD12
|
AD_NO_USEP
|
|
PO_BOX_NUM |
Flag: PO Box Without Number |
CHAR |
1 |
0 |
|
AD_POBXNUM
|
|
PO_BOX_LOC |
PO Box city |
CHAR |
40 |
0 |
|
AD_POBXLOC
|
|
CITY_CODE2 |
City PO box code (City file) |
CHAR |
12 |
0 |
ADRCITY
|
AD_CIT2NUM
|
|
PO_BOX_REG |
Region for PO Box (Country/Region, State, Province, ...) |
CHAR |
3 |
0 |
T005S
|
AD_POBXREG
|
|
PO_BOX_CTY |
PO Box of Country/Region |
CHAR |
3 |
0 |
T005
|
AD_POBXCTY
|
|
POSTALAREA |
(Not Supported) Post Delivery District |
CHAR |
15 |
0 |
|
AD_PSTLAR
|
|
TRANSPZONE |
Transportation zone to or from which the goods are delivered |
CHAR |
10 |
0 |
TZONE
|
LZONE
|
|
STREET |
Street |
CHAR |
60 |
0 |
|
AD_STREET
|
|
DONT_USE_S |
Street Address Undeliverable Flag |
CHAR |
4 |
0 |
TSAD12
|
AD_NO_USES
|
|
STREETCODE |
Street Number for City/Street File |
CHAR |
12 |
0 |
ADRSTREET
|
AD_STRNUM
|
|
STREETABBR |
(Not Supported) Abbreviation of Street Name |
CHAR |
2 |
0 |
ADRSTRTYPE
|
AD_STRABBR
|
|
HOUSE_NUM1 |
House Number |
CHAR |
10 |
0 |
|
AD_HSNM1
|
|
HOUSE_NUM2 |
House number supplement |
CHAR |
10 |
0 |
|
AD_HSNM2
|
|
HOUSE_NUM3 |
(Not supported) House Number Range |
CHAR |
10 |
0 |
|
AD_HSNM3
|
|
STR_SUPPL1 |
Street 2 |
CHAR |
40 |
0 |
|
AD_STRSPP1
|
|
STR_SUPPL2 |
Street 3 |
CHAR |
40 |
0 |
|
AD_STRSPP2
|
|
STR_SUPPL3 |
Street 4 |
CHAR |
40 |
0 |
|
AD_STRSPP3
|
|
LOCATION |
Street 5 |
CHAR |
40 |
0 |
|
AD_LCTN
|
|
BUILDING |
Building (Number or Code) |
CHAR |
20 |
0 |
|
AD_BLDNG
|
|
FLOOR |
Floor in building |
CHAR |
10 |
0 |
|
AD_FLOOR
|
|
ROOMNUMBER |
Room or Apartment Number |
CHAR |
10 |
0 |
|
AD_ROOMNUM
|
|
COUNTRY |
Country/Region Key |
CHAR |
3 |
0 |
T005
|
LAND1
|
|
LANGU |
Language Key |
LANG |
1 |
0 |
T002
|
SPRAS
|
|
REGION |
Region (State, Province, County) |
CHAR |
3 |
0 |
T005S
|
REGIO
|
|
SORT1 |
Search Term 1 |
CHAR |
20 |
0 |
|
AD_SORT1UL
|
|
SORT2 |
Search Term 2 |
CHAR |
20 |
0 |
|
AD_SORT2UL
|
|
SORT_PHN |
(Not Supported) Phonetic Search Sort Field |
CHAR |
20 |
0 |
|
AD_SRTPHN
|
|
ADDRORIGIN |
(Not Supported) Address Data Source (Key) |
CHAR |
4 |
0 |
TSAD6
|
AD_ORIGINA
|
|
EXTENSION1 |
Extension (only for data conversion) (e.g. data line) |
CHAR |
40 |
0 |
|
AD_EXTENS1
|
|
EXTENSION2 |
Extension (only for data conversion) (e.g. telebox) |
CHAR |
40 |
0 |
|
AD_EXTENS2
|
|
TIME_ZONE |
Address time zone |
CHAR |
6 |
0 |
TTZZ
|
AD_TZONE
|
|
TAXJURCODE |
Tax Jurisdiction |
CHAR |
15 |
0 |
|
AD_TXJCD
|
|
ADDRESS_ID |
(Not supported) Physical address ID |
CHAR |
10 |
0 |
|
AD_ADDR_ID
|
|
REMARK |
Address notes |
CHAR |
50 |
0 |
|
AD_REMARK1
|
|
LANGU_CREA |
Address record creation original language |
LANG |
1 |
0 |
T002
|
AD_LANGUCR
|
|
PO_BOX_LOBBY |
PO Box Lobby |
CHAR |
40 |
0 |
|
AD_PO_BOX_LBY
|
|
DELI_SERV_TYPE |
Type of Delivery Service |
CHAR |
4 |
0 |
ADDRC_DELI_SERV
|
AD_DELIVERY_SERVICE_TYPE
|
|
DELI_SERV_NUMBER |
Number of Delivery Service |
CHAR |
10 |
0 |
|
AD_DELIVERY_SERVICE_NUMBER
|
|
COUNTY_CODE |
County code for county |
CHAR |
8 |
0 |
ADRCOUNTY
|
AD_CNTYNUM
|
|
COUNTY |
County |
CHAR |
40 |
0 |
|
AD_COUNTY
|
|
TOWNSHIP_CODE |
Township code for Township |
CHAR |
8 |
0 |
ADRTOWNSHIP
|
AD_TWSHPNUM
|
|
TOWNSHIP |
Township |
CHAR |
40 |
0 |
|
AD_TOWNSHIP
|
|
DEFLT_COMM |
Standard communication type |
CHAR |
3 |
0 |
TSADC
|
AD_DFLTCMM
|
|
TEL_NUMBER |
Telephone no.: dialling code+number |
CHAR |
30 |
0 |
|
AD_TLNMBR
|
|
TEL_EXTENS |
Telephone no.: Extension |
CHAR |
10 |
0 |
|
AD_TLXTNS
|
|
FAX_NUMBER |
Fax number: dialling code+number |
CHAR |
30 |
0 |
|
AD_FXNMBR
|
|
FAX_EXTENS |
Fax no.: Extension |
CHAR |
10 |
0 |
|
AD_FXXTNS
|
|
VALID_FROM |
Valid From |
DATS |
8 |
0 |
|
BU_VALID_FROM_DATS
|
|
VALID_TO |
Valid To |
DATS |
8 |
0 |
|
BU_VALID_TO_DATS
|
|
NATPERS |
Business Partner Is a Natural Person Under the Tax Laws |
CHAR |
1 |
0 |
|
BU_NATURAL_PERSON
|
|
Business Person is a Legal Person or Organization |
X |
Business Partner is a Natural Person |
|
WAKLASS |
Employee classification |
CHAR |
4 |
0 |
TE697
|
WAKLASS
|
|
FIRMART |
Type of installation company |
CHAR |
2 |
0 |
TE183
|
FIRMART
|
|
ARBFELD |
Company work field |
CHAR |
2 |
0 |
TE185
|
ARBFELD
|
|
MITGLIED |
Membership of installer |
CHAR |
1 |
0 |
|
MITGLIED
|
|
Not a member |
1 |
Member of gas and electric community |
2 |
Member of electric community |
3 |
Member of natural gas community |
4 |
Member of gas community |
5 |
Guild member |
|
SPZULASS |
Division license of installer |
CHAR |
20 |
0 |
|
SPZULASS
|
|
ARTZULASS |
Installer license type |
CHAR |
2 |
0 |
TE189
|
ARTZULASS
|
|
AUSWANZ |
Number of identifications |
NUMC |
2 |
0 |
|
AUSWANZ
|
|
PLOMBENZ |
Sealing pliers number |
CHAR |
10 |
0 |
|
PLOMBENZ
|
|
FREMDEVU |
Main utility company |
CHAR |
3 |
0 |
TE187
|
FREMDEVU
|
|
STATINS |
Valid status of installer in supply area |
CHAR |
2 |
0 |
TE061
|
STATINS
|
|
STATDATUM |
Date on which status of installer comes into effect |
DATS |
8 |
0 |
|
STATDATUM
|
|
ERSTZUL |
Date of initial license of installer |
DATS |
8 |
0 |
|
ERSTZUL
|
|
WERKSTATT |
Date of workshop inspection |
DATS |
8 |
0 |
|
WERKSTATT
|
|
VERLZUL |
Date of license renewal |
DATS |
8 |
0 |
|
VERLZUL
|
|
ENDEZUL |
Date until which license is renewed |
DATS |
8 |
0 |
|
ENDEZUL
|
|
ANZEVU |
Number of utility companies |
NUMC |
2 |
0 |
|
ANZEVU
|
|
ANZFIL |
Number of branches supported by an installionr company |
NUMC |
2 |
0 |
|
ANZFIL
|
|
AUSW_INST |
Identification number for installer license |
CHAR |
10 |
0 |
|
AUSW_INST
|
|
DR_LICENSE_LAND1 |
Country/Region in Which Driver's License Was Acquired |
CHAR |
3 |
0 |
T005
|
DR_LICENSE_LAND1
|
|
DR_LICENSE_REGIO |
Region in which driver's license was acquired |
CHAR |
3 |
0 |
T005S
|
DR_LICENSE_REGIO
|
|
DR_LICENSE |
Driver's license number |
CHAR |
20 |
0 |
|
DR_LICENSE
|
|
SOC_SECURE |
Social Insurance Number |
CHAR |
12 |
0 |
|
E_SOC_SECU
|
|
WELFARE |
Welfare office |
CHAR |
9 |
0 |
|
WELFARE
|
|
PLACE_EMPL |
Work center |
CHAR |
40 |
0 |
|
PLACE_EMPL
|
|
KTOKLASSE |
Account Class |
CHAR |
4 |
0 |
KONTOKLASSE
|
KTOKLASSE
|
|
BUPINFOREL |
Information release for business partner data |
CHAR |
2 |
0 |
TEBUPINFOREL
|
BUPINFOREL
|
|
CLERK_ID |
Business partner-specific criteria for agent determination |
CHAR |
8 |
0 |
TECLERK_ID
|
E_CLERK_ID
|
|
RECPTYPE |
Category for Alternate Payee |
CHAR |
1 |
0 |
|
E_RECPTYPE
|
1 |
Donations for charity organizations |
2 |
Stock savings plan |
|
PYMET |
Payment method for donations/fund payments |
CHAR |
1 |
0 |
TFK042Z
|
E_PYMET_DON
|
|
EMBVT |
Bank details ID for donations/fund payments |
CHAR |
4 |
0 |
|
E_EMBVT_DON
|
|
HKONT |
G/L accounts for donations/fund payments |
CHAR |
10 |
0 |
SKA1
|
E_HKONT_DON
|
|
CLASSIFICATION |
Classification of Business Partner |
CHAR |
4 |
0 |
TE181
|
E_CLASSIFICATION
|
|
VIP |
Indicate Very Important Business Partner |
CHAR |
1 |
0 |
|
E_VIP
|
|
IDENT_INST |
Identification Number for Installer License |
CHAR |
18 |
0 |
|
IDENT_INST
|
|
MUSTER_KUN |
Reference for creating a standard customer for bus. partner |
CHAR |
10 |
0 |
*
|
MUSTER_KUN
|
|
TEL_CONSNUMBER |
Sequence Number |
NUMC |
3 |
0 |
|
AD_CONSNUM
|
|
FAX_CONSNUMBER |
Sequence Number |
NUMC |
3 |
0 |
|
AD_CONSNUM
|
|
SMTP_ADDR |
E-Mail Address |
CHAR |
241 |
0 |
|
AD_SMTPADR
|
|
SMTP_CONSNUMBER |
Sequence Number |
NUMC |
3 |
0 |
|
AD_CONSNUM
|
|
BKVID |
Bank Details ID |
CHAR |
4 |
0 |
|
BU_BKVID
|
|
BANKS |
Country/Region Key of Bank |
CHAR |
3 |
0 |
T005
|
BU_BANKS
|
|
BANKL |
Bank Key |
CHAR |
15 |
0 |
|
BU_BANKK
|
|
BANKN |
Bank Account Number |
CHAR |
18 |
0 |
|
BU_BANKN
|
|
BKONT |
Bank Control Key |
CHAR |
2 |
0 |
|
BU_BKONT
|
|
BKREF |
Reference Details for Bank Details |
CHAR |
20 |
0 |
|
BU_BKREF
|
|
KOINH |
Account Holder Name |
CHAR |
60 |
0 |
|
BU_KOINH
|
|
BKEXT |
Bank details ID in external system |
CHAR |
20 |
0 |
|
BU_BKEXT
|
|
XEZER |
Indicator: Collection Authorization |
CHAR |
1 |
0 |
|
BU_XEZER
|
|
ACCNAME |
Name of Bank Account |
CHAR |
40 |
0 |
|
BU_BANKACCNAME
|
|
MOVE_BKVID |
ID of Target Details for Change of Bank Details (BP) |
CHAR |
4 |
0 |
|
BU_MOVE_BKVID
|
|
PROTECT |
BP: Sensitivity Indicator |
CHAR |
1 |
0 |
|
BU_PROTECTED
|
|
Not Defined |
E |
Employee-Related Data |
|
ALIAS_IS_USED |
Alias Is Used |
CHAR |
1 |
0 |
|
BU_ALIAS_IS_USED
|
|
BK_VALID_FROM |
Validity Start of Business Partner Bank Details |
DEC |
15 |
0 |
|
BU_BK_VALID_FROM
|
|
BK_VALID_TO |
Validity End of Business Partner Bank Details |
DEC |
15 |
0 |
|
BU_BK_VALID_TO
|
|
BK_MOVE_DATE |
Date of Change to Bank Details (BP) |
DEC |
15 |
0 |
|
BU_BK_MOVE_DATE
|
|
BP_BANK_GUID |
BP: Bank Account Alias GUID |
RAW |
16 |
0 |
|
BU_BP_BANK_GUID
|
|
IBAN |
IBAN (International Bank Account Number) |
CHAR |
34 |
0 |
|
BU_IBAN
|
|
BANK_GUID |
Bank GUID |
RAW |
16 |
0 |
|
BU_BANK_GUID
|
|
ACCOUNT_ID |
Bank Account Number (New) |
CHAR |
35 |
0 |
|
BU_ACCOUNT_ID
|
|
CHECK_DIGIT |
Bank Account Check Digit |
CHAR |
2 |
0 |
|
BU_ACCOUNT_CHECK
|
|
ACCOUNT_TYPE |
Bank Account Type |
CHAR |
3 |
0 |
|
BU_ACCOUNT_TYPE
|
|
MANDTA |
Client |
CLNT |
3 |
0 |
*
|
MANDT
|
|
VKONTA |
Contract Account Number |
CHAR |
12 |
0 |
*
|
VKONT_KK
|
|
GPARTA |
Business Partner Number |
CHAR |
10 |
0 |
*
|
GPART_KK
|
|
VKBEZA |
Contract account name |
CHAR |
35 |
0 |
|
VKBEZ_KK
|
|
ERDATA |
Date on which the record was created |
DATS |
8 |
0 |
|
ERDAT
|
|
ERNAMA |
Name of Person Responsible for Creating the Object |
CHAR |
12 |
0 |
|
ERNAM
|
|
AEDATPA |
Last Changed On |
DATS |
8 |
0 |
|
AEDAT
|
|
AENAMPA |
Name of Person Who Changed Object |
CHAR |
12 |
0 |
|
AENAM
|
|
FDZTGA |
Additional Days for Cash Management |
NUMC |
2 |
0 |
|
FDZTG_KK
|
|
STOPDA |
Processing lock until |
DATS |
8 |
0 |
|
STOPD_KK
|
|
QSZDTA |
Validity Date for Withholding Tax Exemption Certificate |
DATS |
8 |
0 |
|
QSZDT
|
|
GUIDA |
Business Agreement GUID |
RAW |
16 |
0 |
|
BUAG_GUID
|
|
DDLAMA |
Direct Debit Limit |
CURR |
13 |
2 |
|
DDLAM_KK
|
|
DDLCUA |
Currency of Direct Debit Limit |
CUKY |
5 |
0 |
*
|
DDLCU_KK
|
|
DDLNMA |
Number of Months for Calculation of Direct Debit Limit |
NUMC |
2 |
0 |
|
DDLNM_KK
|
|
INV_CYCLE_STARTA |
Start Date of First Billing Period |
DATS |
8 |
0 |
|
CYCLE_STARTDATE_KK
|
|
INV_CHGDISC_XA |
Int: Charges and Discounts Exist for BP-CrtAcct Relations |
CHAR |
1 |
0 |
|
CHGDISC_X_KK
|
|
BPL_XPOCLA |
Business Partner Lock for Postings/Clearing |
CHAR |
1 |
0 |
|
BPL_XPOCL_KK
|
|
No Lock |
1 |
Posting Lock Only |
2 |
Clearing Lock Only |
3 |
Posting and Clearing Lock |
|
BPL_XADDLA |
Business Partner Lock for Dunning / Payment |
CHAR |
1 |
0 |
|
BPL_XADDL_KK
|
|
No Lock |
1 |
Dunning Lock |
2 |
Incoming Payment Lock |
3 |
Outgoing Payment Lock |
A |
Dunning Lock / Incoming Payment Lock / Outgoing Payment Lock |
B |
Dunnning Lock / Outgoing Payment Lock |
C |
Dunning Lock / Outgoing Payment Lock |
D |
Incoming Payment Lock / Outgoing Payment Lock |
|
BPL_FDATEA |
Lock valid from |
DATS |
8 |
0 |
|
FDATE_KK
|
|
BPL_TDATEA |
Lock valid to |
DATS |
8 |
0 |
|
TDATE_KK
|
|
INV_CURRA |
Target Currency of Invoicing |
CUKY |
5 |
0 |
TCURC
|
INV_CURR_KK
|
|
EXVKOA |
Reference number for business partner |
CHAR |
25 |
0 |
|
EXVKO_KK
|
|
OPBUKA |
Company Code Group |
CHAR |
4 |
0 |
TFK001G
|
OPBUK_KK
|
|
STDBKA |
Standard Company Code |
CHAR |
4 |
0 |
*
|
STDBK_KK
|
|
ABWREA |
Alternative Payer |
CHAR |
10 |
0 |
BUT000
|
ABWRE_KK
|
|
ABWRAA |
Alternative Payee |
CHAR |
10 |
0 |
BUT000
|
ABWRA_KK
|
|
ABWMAA |
Alternative Dunning Recipient |
CHAR |
10 |
0 |
BUT000
|
ABWMA_KK
|
|
EBVTYA |
Bank Details ID for Incoming Payments |
CHAR |
4 |
0 |
|
EBVTY_KK
|
|
ABVTYA |
Bank Details ID for Outgoing Payments |
CHAR |
4 |
0 |
|
ABVTY_KK
|
|
EZAWEA |
Incoming Payment Method |
CHAR |
1 |
0 |
|
EZAWE_KK
|
|
EZASPA |
Lock Reason for Incoming Payments |
CHAR |
1 |
0 |
TFK008
|
EZASP_OLD_KK
|
|
AZAWEA |
Outgoing Payment Methods |
CHAR |
5 |
0 |
|
AZAWE_KK
|
|
AZASPA |
Lock Reason for Outgoing Payments |
CHAR |
1 |
0 |
TFK008
|
AZASP_OLD_KK
|
|
EIGBVA |
Own Bank Details |
CHAR |
25 |
0 |
*
|
EIGBV_KK
|
|
VWNZAA |
Create Where-Used List For Line Items |
CHAR |
1 |
0 |
|
VWNZA_KK
|
|
no listing of line items |
X |
line items listed |
|
LOEVMA |
Mark Contract Account for Deletion |
CHAR |
1 |
0 |
|
LOEVM_KK
|
|
ABWVKA |
Alternative Contract Account for Collective Bills |
CHAR |
12 |
0 |
FKKVK
|
ABWVK_KK
|
|
IKEYA |
Interest Key |
CHAR |
2 |
0 |
TFK056A
|
IKEY_KK
|
|
MAHNVA |
Dunning Procedure |
CHAR |
2 |
0 |
TFK047A
|
MAHNV_KK
|
|
MANSPA |
Dunning Lock Reason |
CHAR |
1 |
0 |
TFK047S
|
MANSP_OLD_KK
|
|
MGRUPA |
Grouping fur Dunning Notices |
CHAR |
2 |
0 |
TFK047F
|
MGRUP_KK
|
|
FDGRPA |
Planning Group |
CHAR |
10 |
0 |
T035
|
FDGRP_KK
|
|
VKPBZA |
Relationship of Business Partner to Contract Account |
CHAR |
2 |
0 |
TFK002F
|
VKPBZ_KK
|
|
ADRNBA |
Address Number |
CHAR |
10 |
0 |
*
|
AD_ADDRNUM
|
|
VKONVA |
Contract account used for payment transactions |
CHAR |
12 |
0 |
FKKVK
|
VKONV_KK
|
|
GPARVA |
BP Acting as Payer/Payee in Payment Transactions |
CHAR |
10 |
0 |
BUT000
|
GPARV_KK
|
|
ADRREA |
Address Number for Alternative Payer |
CHAR |
10 |
0 |
*
|
ADRRE_KK
|
|
ADRRAA |
Address Number for Alternative Payee |
CHAR |
10 |
0 |
*
|
ADRRA_KK
|
|
ADRMAA |
Address number for alternative dunning notice recipient |
CHAR |
10 |
0 |
*
|
ADRMA_KK
|
|
ABWRHA |
Alternative Invoice Recipient |
CHAR |
10 |
0 |
BUT000
|
ABWRH_KK
|
|
ADRRHA |
Address number for alternative bill recipient |
CHAR |
10 |
0 |
*
|
ADRRH_KK
|
|
ADRJDCA |
Address Number for Jurisdiction Code Address |
CHAR |
10 |
0 |
*
|
ADRJDC_KK
|
|
BEGRUA |
Authorization Group |
CHAR |
4 |
0 |
TFK_BEGRU
|
BEGRU
|
|
TOGRUA |
Tolerance group for contract account |
CHAR |
4 |
0 |
TFK043
|
TOGRU_KK
|
|
STOPGA |
Reason for Processing Lock |
CHAR |
1 |
0 |
TFK001S
|
STOPG_KK
|
|
TXJCDA |
Jurisdiction for Tax Calculation - Tax Jurisdiction Code |
CHAR |
15 |
0 |
*
|
TXJCD_NOCD_KK
|
|
COPRCA |
Correspondence Variant |
CHAR |
4 |
0 |
TFK070B
|
COPRC_KK
|
|
VBUNDA |
Company ID of Trading Partner |
CHAR |
6 |
0 |
*
|
RASSC
|
|
CCARD_IDA |
Payment Card ID for Incoming Payments |
CHAR |
6 |
0 |
|
CCID_IN_KK
|
|
CCARD_OUTA |
Payment Card ID for Outgoing Payments |
CHAR |
6 |
0 |
|
CCID_OUT_KK
|
|
UEBTRA |
Items Transferred To Another Account |
CHAR |
1 |
0 |
|
XUEBTR_KK
|
|
DEF_RECA |
Alternative Correspondence Recipient for Standard Case |
CHAR |
10 |
0 |
BUT000
|
DEF_CORR_PARTNER_KK
|
|
DEF_REC_INDA |
FI-CA correspondence - activity key |
CHAR |
4 |
0 |
TFK070L
|
DEF_CORR_ACKEY_KK
|
|
DEF_REC_ADRNRA |
Standard Address No. of Alternative Correspondence Recipient |
CHAR |
10 |
0 |
*
|
ADRNR_CORR_DEF_KK
|
|
QSSKZ_AA |
Witholding Tax Code For Outgoing Payments |
CHAR |
2 |
0 |
*
|
QSSKZ_A_KK
|
|
QSSKZ_EA |
Withholding Tax Code For Incoming Payments |
CHAR |
2 |
0 |
*
|
QSSKZ_E_KK
|
|
QSZNRA |
Certificate Number of the Withholding Tax Exemption |
CHAR |
10 |
0 |
|
QSZNR
|
|
CORR_MAHNVA |
Correspondence Dunning Procedure |
CHAR |
2 |
0 |
*
|
CORR_MAHNV_KK
|
|
FITYPA |
Tax type |
CHAR |
2 |
0 |
J_1AFITPV
|
J_1AFITP_D
|
|
PROVINCEA |
Region (State, Province, County) |
CHAR |
3 |
0 |
T005S
|
REGIO
|
|
COUNTYA |
County Code |
CHAR |
3 |
0 |
T005E
|
COUNC
|
|
VERTYPA |
Clearing Category For Clearing Postings |
CHAR |
4 |
0 |
TFK111
|
VERTYP_KK
|
|
AUGRS_DEFA |
Clearing Restriction |
CHAR |
1 |
0 |
|
AUGRS_DEF_KK
|
D |
Deposit: Can only be cleared with open item clearing |
|
LANDLA |
Destination Country/Region (for Tax Reports) |
CHAR |
3 |
0 |
T005
|
LANDL_KK
|
|
BUPLAA |
Business Place |
CHAR |
4 |
0 |
J_1BBRANCH
|
BUPLA
|
|
BPTAXTYPE1A |
Tax Number Type 1 for Business Partner |
CHAR |
4 |
0 |
|
BPTAXTYPE1
|
|
BPTAXTYPE2A |
Tax Number type 2 for Business Partner |
CHAR |
4 |
0 |
|
BPTAXTYPE2
|
|
PERSRA |
Clerk Responsible |
CHAR |
10 |
0 |
BUT000
|
PERSR_KK
|
|
INV_CATEGORYA |
Invoicing Category |
CHAR |
4 |
0 |
TFK2604
|
INV_CATEGORY_KK
|
|
DDLXGA |
Rolling Calculation of Direct Debit Limit |
CHAR |
1 |
0 |
|
DDLXG_KK
|
|
CMGRPA |
Collection Management: Master Data Group |
CHAR |
2 |
0 |
*
|
CMGRP_CM_KK
|
|
STRATA |
Collection Strategy |
CHAR |
2 |
0 |
*
|
STRAT_CM_KK
|
|
CPERSA |
Collections Contact Person |
CHAR |
10 |
0 |
*
|
CPERS_CM_KK
|
|
BPCL_SUCCA |
Duplicate Processing: Predecessor/Successor Business Partner |
CHAR |
1 |
0 |
|
BPCL_SUCC_KK
|
|
No Relationship Exists |
1 |
Predecessor |
2 |
Successor |
3 |
Predecessor and Successor |
|
INV_SCHEDULEA |
Selection Characteristic for Scheduling |
CHAR |
4 |
0 |
TFK2606
|
INV_SCHEDULE_KK
|
|
INV_CYCLEA |
Billing Cycle |
CHAR |
4 |
0 |
TFK2607
|
CYCLE_KK
|
|
INV_CYCLE_RULEA |
Field Is Not Used - CHAR4 |
CHAR |
4 |
0 |
|
CYCLE_RULE_KK
|
|
INV_CYCLE_DAYA |
Day of Period End |
CHAR |
2 |
0 |
|
CYCLE_DAY_KK
|
|
Defaulted Using Billing Cycle |
01 |
1st Day of Month |
02 |
2nd Day of Month |
03 |
3rd Day of Month |
04 |
4th Day of Month |
05 |
5th Day of Month |
06 |
6th Day of Month |
07 |
7th Day of Month |
08 |
8th Day of Month |
09 |
9th Day of Month |
10 |
10th Day of Month |
11 |
11th Day of Month |
12 |
12th Day of Month |
13 |
13th Day of Month |
14 |
14th Day of Month |
15 |
15th Day of Month |
16 |
16th Day of Month |
17 |
17th Day of Month |
18 |
18th Day of Month |
19 |
19th Day of Month |
20 |
20th Day of Month |
21 |
21st Day of Month |
22 |
22nd Day of Month |
23 |
23rd Day of Month |
24 |
24th Day of Month |
25 |
25th Day of Month |
26 |
26th Day of Month |
27 |
27th Day of Month |
28 |
28th Day of Month |
29 |
29th Day of Month |
30 |
30th Day of Month |
31 |
31st Day of Month |
W1 |
Monday |
W2 |
Tuesday |
W3 |
Wednesday |
W4 |
Thursday |
W5 |
Friday |
W6 |
Saturday |
W7 |
Sunday |
|
INV_CYCLE_MONTHA |
Field Is Not Used - CHAR2 |
CHAR |
2 |
0 |
|
NOT_USED_CHAR2_KK
|
|
MNDIDA |
Unique Reference to Mandate for each Payee |
CHAR |
35 |
0 |
|
SEPA_MNDID
|
|
INV_FORM_DET_KEYA |
Determination Characteristic for Alternative Invoice Form |
CHAR |
4 |
0 |
TFK2681
|
FORM_DET_KEY_KK
|
|
GPART_INVA |
Business Partner for Posting of the Invoice |
CHAR |
10 |
0 |
BUT000
|
INVGP_KK
|
|
VKONT_INVA |
Contract Account of Invoice Recipient |
CHAR |
12 |
0 |
FKKVK
|
INVVK_KK
|
|
GPART_INVLISTA |
Recipient of Invoicing List |
CHAR |
10 |
0 |
BUT000
|
INVLR_KK
|
|
VKONT_INVLISTA |
Contract Account of Recipient of Invoicing List |
CHAR |
12 |
0 |
FKKVK
|
INVLK_KK
|
|
MAKEYA |
Identification of Master Agreement |
CHAR |
10 |
0 |
|
MAKEY_KK
|
|
PTSRLA |
Partner Settlement Rule |
CHAR |
4 |
0 |
TFKPS_RULE
|
PTSRL_KK
|
|
TRSLAA |
Subledger Transfer: Application ID |
CHAR |
5 |
0 |
|
TRSLA_KK
|
FI |
Financial Accounting (FI-AR/FI-AP) |
|
TAX_COUNTRYA |
Tax Reporting Country/Region |
CHAR |
3 |
0 |
T005
|
FOT_TAX_COUNTRY
|
|
APPLKA |
Application Area |
CHAR |
1 |
0 |
|
APPLK_KK
|
* |
Valid for all application areas |
C |
Convergent FI-CA |
M |
Media Companies |
P |
Public Administration |
R |
Utility company |
S |
Extended FI-CA |
T |
Telecommunications |
V |
Insurance company |
X |
In-house development |
|
VKTYPA |
Contract Account Category |
CHAR |
2 |
0 |
TFK002A
|
VKTYP_KK
|
|
VKONAA |
Contract account number in legacy system |
CHAR |
20 |
0 |
|
VKONA_KK
|
|
ZAHLKONDA |
Payment Condition |
CHAR |
4 |
0 |
TE052
|
KONDZAHL
|
|
KOFIZ_SDA |
Account determination ID for contract accounts |
CHAR |
2 |
0 |
TE097A
|
E_KOFIZ_SD
|
|
GSBERA |
Business Area |
CHAR |
4 |
0 |
TGSB
|
GSBER
|
|
IPA_CODEA |
eDocumant Italy - IPA Code |
CHAR |
6 |
0 |
|
EDOC_IPACODE_IT
|
|
IPA_BEGDAA |
IPA Start Date |
DATS |
8 |
0 |
|
EDOC_BEGDA_IT
|
|
IPA_CODE_LONGA |
eDocument Italy : IPA_CODE Long for B2B |
CHAR |
7 |
0 |
|
EDOC_IPACODE_LONG_IT_ISU
|
|
/SAPCE/FKRU_FISA |
Financing Source |
NUMC |
1 |
0 |
/SAPCE/FKRU_FIS
|
/SAPCE/FKRU_FI_SOURCE
|
|
/SAPCE/FKRU_FTDA |
Federal Treasury Department |
CHAR |
50 |
0 |
|
/SAPCE/FKRU_FED_TR_DEP
|
|
/SAPCE/FKRU_FTDAA |
Account Number in Federal Treasury Department |
CHAR |
20 |
0 |
|
/SAPCE/FKRU_FED_TR_DEP_ACC
|
|
/SAPCE/FKRU_CTTA |
Contract Type |
NUMC |
2 |
0 |
/SAPCE/FKRU_CTT
|
/SAPCE/FKRU_CONTR_TYPE
|
|
DUMMY_FKKVKP_INCL_EEW_PSA |
Custom Fields: Dummy for Use in Extension Includes |
CHAR |
1 |
0 |
|
CFD_DUMMY
|
|
VBELN |
Sales and Distribution Document Number |
CHAR |
10 |
0 |
|
VBELN
|
|