SAP-tabelreferentie

BUT000

BP: General data I

Bekijk een andere tabel

Vul een tabelcode of zoekwoord in om verder te zoeken.

Bekijk de structuur, velden en relaties van SAP-tabel BUT000.

SAP-tabel BUT000 heeft 2 primaire sleutelvelden: CLIENT,PARTNER.

/ Velden

BUT000 velden.

95 velden
VeldOmschrijvingDatatypeLengteDecimalenChecktabelData-element
Sleutel CLIENT ClientCLNT30 T000 MANDT
Sleutel PARTNER Business Partner NumberCHAR100 BU_PARTNER
TYPE Business Partner CategoryCHAR10 BU_TYPE
BPKIND Business Partner TypeCHAR40 TB004 BU_BPKIND
BU_GROUP Business Partner GroupingCHAR40 TB001 BU_GROUP
BPEXT Business Partner Number in External SystemCHAR200 BU_BPEXT
BU_SORT1 Search Term 1 for Business PartnerCHAR200 BU_SORT1
BU_SORT2 Search Term 2 for Business PartnerCHAR200 BU_SORT2
SOURCE Data Origin TypesCHAR40 TB005 BU_SOURCE
TITLE Form-of-Address KeyCHAR40 TSAD3 AD_TITLE
XDELE Central Archiving FlagCHAR10 BU_XDELE
XBLCK Central Block for Business PartnerCHAR10 BU_XBLCK
AUGRP Authorization GroupCHAR40 TB037 BU_AUGRP
TITLE_LET SalutationCHAR500 BU_TITLE_LET
BU_LOGSYS Logical systemCHAR100 TBDLS LOGSYS
CONTACT Business Partner: Contact PermissionCHAR10 BU_CONTACT
NOT_RELEASED Indicator: Not ReleasedCHAR10 BU_XNOT_RELEASED
NOT_LG_COMPETENT Indicator: Not Legally CompetentCHAR10 BU_NOT_LEG_COMPETENT
PRINT_MODE Business Partner Print FormatCHAR10 BU_PRINT_MODE
BP_EEW_DUMMY Dummy function in length 1CHAR10 DUMMY
RATE Cost Rate/Revenue Rate for Project CostingCHAR150 DPR_RATES DPR_TV_RATE
NAME_ORG1 Name 1 of organizationCHAR400 BU_NAMEOR1
NAME_ORG2 Name 2 of organizationCHAR400 BU_NAMEOR2
NAME_ORG3 Name 3 of organizationCHAR400 BU_NAMEOR3
NAME_ORG4 Name 4 of organizationCHAR400 BU_NAMEOR4
LEGAL_ENTY BP: Legal form of organizationCHAR20 TB019 BU_LEGENTY
IND_SECTOR Industry sectorCHAR100 TB023 BU_INDSECT
LEGAL_ORG Legal Entity of OrganizationCHAR20 TB032 BU_LEGAL_ORG
FOUND_DAT Date organization foundedDATS80 BU_FOUND_DAT
LIQUID_DAT Liquidation date of organizationDATS80 BU_LIQUID_DAT
LOCATION_1 International location number (part 1)NUMC70 BBBNR
LOCATION_2 International location number (Part 2)NUMC50 BBSNR
LOCATION_3 Check digit for the international location numberNUMC10 BUBKZ
NAME_LAST Last name of business partner (person)CHAR400 BU_NAMEP_L
NAME_FIRST First name of business partner (person)CHAR400 BU_NAMEP_F
NAME_LST2 Other Last Name of a PersonCHAR400 BU_NAMEPL2
NAME_LAST2 Name at birth of business partnerCHAR400 BU_BIRTHNM
NAMEMIDDLE Middle name or second forename of a personCHAR400 BU_NAMEMID
TITLE_ACA1 Academic Title: KeyCHAR40 TSAD2 AD_TITLE1
TITLE_ACA2 Second academic title (key)CHAR40 TSAD2 AD_TITLE2
TITLE_ROYL Name supplement, e.g. noble title (key)CHAR40 TSAD5 AD_TITLES
PREFIX1 Name Prefix (Key)CHAR40 TSAD4 AD_PREFIX
PREFIX2 2nd name prefix (key)CHAR40 TSAD4 AD_PREFIX2
NAME1_TEXT Full NameCHAR800 BU_NAME1TX
NICKNAME Nickname of Business Partner (Person)CHAR400 BU_NICKNAM
INITIALS "Middle Initial" or personal initialsCHAR100 AD_INITS
NAMEFORMAT Name formatCHAR20 T005N AD_FORMAT
NAMCOUNTRY Country/Region for Name Format RuleCHAR30 T005 AD_NAMCTRY
LANGU_CORR Business Partner: Correspondence LanguageLANG10 T002 BU_LANGU_CORR
XSEXM Selection: Business partner is maleCHAR10 BU_XSEXM
XSEXF Selection: Business partner is femaleCHAR10 BU_XSEXF
BIRTHPL Birthplace of business partnerCHAR400 BU_BIRTHPL
MARST Marital Status of Business PartnerCHAR10 TB027 BU_MARST
EMPLO Name of Employer of a Natural PersonCHAR350 BU_EMPLO
JOBGR Occupation/groupCHAR40 TB028 BU_JOBGR
NATIO NationalityCHAR30 T005 BU_NATIO
CNTAX Obsolete FieldCHAR30 * BU_CNTAX
CNDSC Country/Region of Origin: Non-Resident CompaniesCHAR30 T005 BU_CNDSC
PERSNUMBER Person NumberCHAR100 AD_PERSNUM
XSEXU Selection: Sex of business partner is not knownCHAR10 BU_XSEXU
XUBNAME Obsolete FieldCHAR120 USR02 BU_XUBNAME
BU_LANGU Business partner: LanguageLANG10 T002 BU_LANGU
GENDER Sex of business partner (person)CHAR10 TB995 BU_SEXID
BIRTHDT Date of Birth of Business PartnerDATS80 BU_BIRTHDT
DEATHDT Date of death of business partnerDATS80 BU_DEATHDT
PERNO Personnel NumberNUMC80 BU_PERNO
CHILDREN Obsolete FieldNUMC20 BU_CHILDREN
MEM_HOUSE Obsolete FieldDEC20 BU_MEM_HOUSE
BIRTHDT_STATUS Date of Birth: StatusCHAR10 BU_BIRTHDT_STATUS
PARTGRPTYP Group typeCHAR40 TB025 BU_GRPTYP
NAME_GRP1 Name 1 (group)CHAR400 BU_NAMEGR1
NAME_GRP2 Name 2 (group)CHAR400 BU_NAMEGR2
MC_NAME1 Search Help Field 1 (Name 1/Last Name)CHAR350 BU_MCNAME1
MC_NAME2 Search Help Field 2 (Name 2/First Name)CHAR350 BU_MCNAME2
CRUSR User who created the objectCHAR120 BU_CRUSR
CRDAT Date on which the object was createdDATS80 BU_CRDAT
CRTIM Time at which the object was createdTIMS60 BU_CRTIM
CHUSR Last user to change objectCHAR120 BU_CHUSR
CHDAT Date when object was last changedDATS80 BU_CHDAT
CHTIM Time at which object was last changedTIMS60 BU_CHTIM
PARTNER_GUID Business Partner GUIDRAW160 BU_PARTNER_GUID
ADDRCOMM Address NumberCHAR100 * BU_ADDRCOMM
TD_SWITCH Planned Change Documents for Partner Were ConvertedCHAR10 BU_TD_SWITCH
IS_ORG_CENTRE Indicator: Business Partner Is Also an Organizational CenterCHAR10 BU_IS_ORG_CENTRE
DB_KEY UUID in X form (binary)RAW160 SYSUUID_X
VALID_FROM Validity Start BUT000 BP DataDEC150 BU_BP_VALID_FROM
VALID_TO Validity End BUT000 BP DataDEC150 BU_BP_VALID_TO
XPCPT Business Purpose Completed FlagCHAR10 BU_XPCPT
NATPERS Business Partner Is a Natural Person Under the Tax LawsCHAR10 BU_NATURAL_PERSON
MILVE ID for mainly military useCHAR10 MILVE
NUC_SEC Nuclear Sector (Indicator)CHAR10 NUC_SEC
PAR_REL Business Partner ReleasedCHAR10 BP_PAR_REL
BP_SORT Sort Field for Phonetic Search; ObsoleteCHAR200 BP_SORT_PH
KBANKS Country/Region Key of BankCHAR30 * BANKS
KBANKL Bank KeysCHAR150 BANKK
/ Relaties

BUT000 relaties.

35 relaties
TabelVeldChecktabelOmschrijvingCheckveld
BUT000BPKINDTB004BP typesBPKIND
BUT000BU_GROUPTB001BP groupingsMANDT
BUT000BU_GROUPTB001BP groupingsBU_GROUP
BUT000BU_LANGUT002Language Keys (Component BC-I18)SPRAS
BUT000BU_LOGSYSTBDLSLogical systemLOGSYS
BUT000CLIENTT000ClientsMANDT
BUT000CNDSCT005CountriesMANDT
BUT000CNDSCT005CountriesLAND1
BUT000GENDERTB995BP GenderGENDER
BUT000JOBGRTB028OccupationsJOBGR
BUT000LANGU_CORRT002Language Keys (Component BC-I18)SPRAS
BUT000LEGAL_ENTYTB019BP legal formsLEGAL_ENTY
BUT000LEGAL_ORGTB032BP Legal EntityLEGAL_ORG
BUT000MARSTTB027BP marital statusMARST
BUT000NAMCOUNTRYT005CountriesMANDT
BUT000NAMCOUNTRYT005CountriesLAND1
BUT000NAMEFORMATT005NName formatsMANDT
BUT000NAMEFORMATT005NName formatsLAND1
BUT000NAMEFORMATT005NName formatsNAMEFORMAT
BUT000NATIOT005CountriesMANDT
BUT000NATIOT005CountriesLAND1
BUT000PARTGRPTYPTB025BP group typesPARTGRPTYP
BUT000PREFIX1TSAD4Name Prefixes (Business Address Services)CLIENT
BUT000PREFIX1TSAD4Name Prefixes (Business Address Services)PREFIX_KEY
BUT000PREFIX2TSAD4Name Prefixes (Business Address Services)CLIENT
BUT000PREFIX2TSAD4Name Prefixes (Business Address Services)PREFIX_KEY
BUT000SOURCETB005BP data sourcesSOURCE
BUT000TITLETSAD3Forms of Address (Key) (Business Address Services)TITLE
BUT000TITLE_ACA1TSAD2Academic Title (Business Address Services)CLIENT
BUT000TITLE_ACA1TSAD2Academic Title (Business Address Services)TITLE_KEY
BUT000TITLE_ACA2TSAD2Academic Title (Business Address Services)CLIENT
BUT000TITLE_ACA2TSAD2Academic Title (Business Address Services)TITLE_KEY
BUT000TITLE_ROYLTSAD5Name Suffixes/Title (Key) (Business Address Services)CLIENT
BUT000TITLE_ROYLTSAD5Name Suffixes/Title (Key) (Business Address Services)TITLE_KEY
BUT000XUBNAMEUSR02Logon Data (Kernel-Side Use)BNAME