SAP Table BUT000_TD - BP: General Data I, Shadow Table Time Dependency

Field Key Data Element Type Offset Leng Decimals Check Table Text
CLIENT X MANDT CLNT 0 3 0 T000 Client
PARTNER X BU_PARTNER CHAR 3 10 0 Business Partner Number
VALID_TO X BU_BP_VALID_TO DEC 13 15 0 Validity End BUT000 BP Data
TYPE BU_TYPE CHAR 21 1 0 Business partner category
BPKIND BU_BPKIND CHAR 22 4 0 TB004 Business Partner Type
BU_GROUP BU_GROUP CHAR 26 4 0 TB001 Business Partner Grouping
BPEXT BU_BPEXT CHAR 30 20 0 Business Partner Number in External System
BU_SORT1 BU_SORT1 CHAR 50 20 0 Search term 1 for business partner
BU_SORT2 BU_SORT2 CHAR 70 20 0 Search term 2 for business partner
SOURCE BU_SOURCE CHAR 90 4 0 Data Origin Types
TITLE AD_TITLE CHAR 94 4 0 TSAD3 Form-of-Address Key
XDELE BU_XDELE CHAR 98 1 0 Central Archiving Flag
XBLCK BU_XBLCK CHAR 99 1 0 Central Block for Business Partner
AUGRP BU_AUGRP CHAR 100 4 0 Authorization Group
TITLE_LET BU_TITLE_LET CHAR 104 50 0 Salutation
BU_LOGSYS LOGSYS CHAR 154 10 0 Logical system
CONTACT BU_CONTACT CHAR 164 1 0 Business Partner: Contact Permission
NOT_RELEASED BU_XNOT_RELEASED CHAR 165 1 0 Indicator: Not Released
PRINT_MODE BU_PRINT_MODE CHAR 166 1 0 Business Partner Print Format
BP_EEW_DUMMY DUMMY CHAR 167 1 0 Dummy function in length 1
NAME_ORG1 BU_NAMEOR1 CHAR 187 40 0 Name 1 of organization
NAME_ORG2 BU_NAMEOR2 CHAR 227 40 0 Name 2 of organization
NAME_ORG3 BU_NAMEOR3 CHAR 267 40 0 Name 3 of organization
NAME_ORG4 BU_NAMEOR4 CHAR 307 40 0 Name 4 of organization
LEGAL_ENTY BU_LEGENTY CHAR 347 2 0 TB019 BP: Legal form of organization
IND_SECTOR BU_INDSECT CHAR 349 10 0 TB023 Industry sector
LEGAL_ORG BU_LEGAL_ORG CHAR 359 2 0 TB032 Legal Entity of Organization
FOUND_DAT BU_FOUND_DAT DATS 361 8 0 Date organization founded
LIQUID_DAT BU_LIQUID_DAT CHAR 369 1 0 Liquidation date of organization
LOCATION_1 BBBNR NUMC 377 7 0 International location number (part 1)
LOCATION_2 BBSNR NUMC 384 5 0 International location number (Part 2)
LOCATION_3 BUBKZ NUMC 389 1 0 Check digit for the international location number
NAME_LAST BU_NAMEP_L CHAR 390 40 0 Last name of business partner (person)
NAME_FIRST BU_NAMEP_F CHAR 430 40 0 First name of business partner (person)
NAME_LST2 BU_NAMEPL2 CHAR 470 40 0 Other Last Name of a Person
NAME_LAST2 BU_BIRTHNM CHAR 510 40 0 Name at birth of business partner
NAMEMIDDLE BU_NAMEMID CHAR 550 40 0 Middle name or second forename of a person
TITLE_ACA1 AD_TITLE1 CHAR 590 4 0 Academic Title: Key
TITLE_ACA2 AD_TITLE2 CHAR 594 4 0 Second academic title (key)
TITLE_ROYL AD_TITLES CHAR 598 4 0 Name supplement, e.g. noble title (key)
PREFIX1 AD_PREFIX CHAR 602 4 0 Name Prefix (Key)
PREFIX2 AD_PREFIX2 CHAR 606 4 0 2nd name prefix (key)
NAME1_TEXT BU_NAME1TX CHAR 610 80 0 Full Name
NICKNAME BU_NICKNAM CHAR 690 40 0 Nickname of Business Partner (Person)
INITIALS AD_INITS CHAR 730 10 0 "Middle Initial" or personal initials
NAMEFORMAT AD_FORMAT CHAR 740 2 0 T005N Name format
NAMCOUNTRY AD_NAMCTRY CHAR 742 3 0 T005 Country for name format rule
LANGU_CORR BU_LANGU_CORR LANG 745 1 0 T002 Business Partner: Correspondence Language
XSEXM BU_XSEXM CHAR 746 1 0 Selection: Business partner is male
XSEXF BU_XSEXF CHAR 747 1 0 Selection: Business partner is female
BIRTHPL BU_BIRTHPL CHAR 748 40 0 Birthplace of business partner
MARST BU_MARST CHAR 788 1 0 TB027 Marital Status of Business Partner
EMPLO BU_EMPLO CHAR 789 35 0 Employer of business partner
JOBGR BU_JOBGR CHAR 824 4 0 TB028 Occupation/group
NATIO BU_NATIO CHAR 828 3 0 T005 Nationality
CNTAX BU_CNTAX CHAR 831 3 0 T005 Obsolete Field
CNDSC BU_CNDSC CHAR 834 3 0 T005 Ctry of Origin: Non-Res. Companies
PERSNUMBER AD_PERSNUM CHAR 837 10 0 ADRP Person number
XSEXU BU_XSEXU CHAR 847 1 0 Selection: Sex of business partner is not known
XUBNAME BU_XUBNAME CHAR 848 12 0 USR02 Obsolete Field
BU_LANGU BU_LANGU LANG 860 1 0 T002 Business partner: Language
BIRTHDT BU_BIRTHDT DATS 861 8 0 Date of birth of business partner
DEATHDT BU_DEATHDT DATS 869 8 0 Date of death of business partner
PERNO BU_PERNO NUMC 877 8 0 Personnel Number
CHILDREN BU_CHILDREN NUMC 885 2 0 Obsolete Field
MEM_HOUSE BU_MEM_HOUSE DEC 887 2 0 Obsolete Field
PARTGRPTYP BU_GRPTYP CHAR 889 4 0 Group type
NAME_GRP1 BU_NAMEGR1 CHAR 893 40 0 Name 1 (group)
NAME_GRP2 BU_NAMEGR2 CHAR 933 40 0 Name 2 (group)
MC_NAME1 BU_MCNAME1 CHAR 973 35 0 Search Help Field 1 (Name 1/Last Name)
MC_NAME2 BU_MCNAME2 CHAR 1008 35 0 Search Help Field 2 (Name 2/First Name)
CRUSR BU_CRUSR CHAR 1043 12 0 User who created the object
CRDAT BU_CRDAT DATS 1055 8 0 Date on which the object was created
CRTIM BU_CRTIM TIMS 1063 6 0 Time at which the object was created
CHUSR BU_CHUSR CHAR 1069 12 0 Last user to change object
CHDAT BU_CHDAT DATS 1081 8 0 Date on which the object was last changed
CHTIM BU_CHTIM TIMS 1089 6 0 Time at which object was last changed
PARTNER_GUID BU_PARTNER_GUID RAW 1095 16 0 Business Partner GUID
ADDRCOMM BU_ADDRCOMM CHAR 1111 10 0 Address Number
TD_SWITCH BU_TD_SWITCH CHAR 1121 1 0 Planned Change Documents for Partner Were Converted
VALID_FROM BU_BP_VALID_FROM DEC 1122 15 0 Validity Start BUT000 BP Data
NATPERS BU_NATURAL_PERSON CHAR 1130 1 0 Business Partner Is a Natural Person Under the Tax Laws

949259BP_ALL: Time-dep. general data in EA-FINSERV not permitted
1077616Business Partner Upgrade FAQ
595442Poor performance for 'Partner by Address' search help