SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

BUT000 Table in SAP | BP: General data I Table & Fields List

BUT000 is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of BUT000 in SAP.

  • Table description : BP: General data I
  • Module : BC-SRV-BP
  • Parent Module : BC
  • Package : S_BUPA_GENERAL
  • Software Component : SAP_BASIS
BUT000 table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP BUT000 Table Fields structure

FieldNoteData ElementDomain
CLIENTClientMANDTMANDT
PARTNERBusiness Partner NumberBU_PARTNERBU_PARTNER
.INCLUDEBP: General Data I (Data Fields - External)    
.INCLUDECBP: General data (independent of partner cat.)    
.INCLUDECBP: General Data (not dep. on Part. Cat.), Initial Screen    
TYPEBusiness partner categoryBU_TYPEBU_TYPE
BPKINDBusiness Partner TypeBU_BPKINDBU_KIND
BU_GROUPBusiness Partner GroupingBU_GROUPBU_GROUP
BPEXTBusiness Partner Number in External SystemBU_BPEXTCHAR20
.INCLUDECBP: General Data (not dep. on Part. Cat.), Data Screens    
BU_SORT1Search term 1 for business partnerBU_SORT1BU_SORT1
BU_SORT2Search term 2 for business partnerBU_SORT2BU_SORT1
SOURCEData Origin TypesBU_SOURCEBU_SOURCE
TITLEForm-of-Address KeyAD_TITLEAD_TITLE
XDELECentral Archiving FlagBU_XDELEXFELD
XBLCKCentral Block for Business PartnerBU_XBLCKXFELD
AUGRPAuthorization GroupBU_AUGRPBU_AUGRP
TITLE_LETSalutationBU_TITLE_LETTEXT50
BU_LOGSYSLogical systemLOGSYSLOGSYS
CONTACTBusiness Partner: Contact PermissionBU_CONTACTBU_CONTACT
NOT_RELEASEDIndicator: Not ReleasedBU_XNOT_RELEASEDXFELD
NOT_LG_COMPETENTIndicator: Not Legally CompetentBU_NOT_LEG_COMPETENTBOOLE
PRINT_MODEBusiness Partner Print FormatBU_PRINT_MODEBU_PRINT_MODE
.INCLUDEEEW Extension of BUT000 (Contains CI)    
BP_EEW_DUMMYDummy function in length 1DUMMYDUMMY
.INCLUDE   
.INCLUDECBP: General data (Organization)    
.INCLUDECBP: General Data, Organization (CHAR Fields)    
NAME_ORG1Name 1 of organizationBU_NAMEOR1BU_NAME
NAME_ORG2Name 2 of organizationBU_NAMEOR2BU_NAME
NAME_ORG3Name 3 of organizationBU_NAMEOR3BU_NAME
NAME_ORG4Name 4 of organizationBU_NAMEOR4BU_NAME
LEGAL_ENTYBP: Legal form of organizationBU_LEGENTYBU_LEGENTY
IND_SECTORIndustry sectorBU_INDSECTBU_INDSECT
LEGAL_ORGLegal Entity of OrganizationBU_LEGAL_ORGBU_LEGAL_ORG
.INCLUDECBP: General Data, Organization (Non CHAR Fields)    
FOUND_DATDate organization foundedBU_FOUND_DATDATUM
LIQUID_DATLiquidation date of organizationBU_LIQUID_DAT  
LOCATION_1International location number (part 1)BBBNRNUM07
LOCATION_2International location number (Part 2)BBSNRNUM05
LOCATION_3Check digit for the international location numberBUBKZNUM01
.INCLUDECBP: General Data, Person    
.INCLUDECBP: General Data, Person (CHAR Fields)    
NAME_LASTLast name of business partner (person)BU_NAMEP_LBU_NAME
NAME_FIRSTFirst name of business partner (person)BU_NAMEP_FBU_NAME
NAME_LST2Other Last Name of a PersonBU_NAMEPL2BU_NAME
NAME_LAST2Name at birth of business partnerBU_BIRTHNMBU_NAME
NAMEMIDDLEMiddle name or second forename of a personBU_NAMEMIDBU_NAME
TITLE_ACA1Academic Title: KeyAD_TITLE1AD_TITLE1
TITLE_ACA2Second academic title (key)AD_TITLE2AD_TITLE1
TITLE_ROYLName supplement, e.g. noble title (key)AD_TITLESAD_TITLES
PREFIX1Name Prefix (Key)AD_PREFIXAD_PREFIX
PREFIX22nd name prefix (key)AD_PREFIX2AD_PREFIX
NAME1_TEXTFull NameBU_NAME1TXTEXT80
NICKNAMENickname of Business Partner (Person)BU_NICKNAMBU_NAME
INITIALS"Middle Initial" or personal initialsAD_INITSCHAR10
NAMEFORMATName formatAD_FORMATAD_NAMFORM
NAMCOUNTRYCountry for name format ruleAD_NAMCTRYLAND1
LANGU_CORRBusiness Partner: Correspondence LanguageBU_LANGU_CORRSPRAS
XSEXMSelection: Business partner is maleBU_XSEXMXFELD
XSEXFSelection: Business partner is femaleBU_XSEXFXFELD
BIRTHPLBirthplace of business partnerBU_BIRTHPLTEXT40
MARSTMarital Status of Business PartnerBU_MARSTBU_MARST
EMPLOName of Employer of a Natural PersonBU_EMPLOBU_EMPLO
JOBGROccupation/groupBU_JOBGRBU_JOBGR
NATIONationalityBU_NATIOLAND1
CNTAXObsolete FieldBU_CNTAXLAND1
CNDSCCtry of Origin: Non-Res. CompaniesBU_CNDSCLAND1
PERSNUMBERPerson numberAD_PERSNUMAD_PERSNUM
XSEXUSelection: Sex of business partner is not knownBU_XSEXUXFELD
XUBNAMEObsolete FieldBU_XUBNAMEXUBNAME
BU_LANGUBusiness partner: LanguageBU_LANGUSPRAS
.INCLUDECBP: General Data, Person (Non CHAR Fields)    
BIRTHDTDate of Birth of Business PartnerBU_BIRTHDTDATUM
DEATHDTDate of death of business partnerBU_DEATHDTDATUM
PERNOPersonnel NumberBU_PERNOPERSONID
CHILDRENObsolete FieldBU_CHILDRENNUMC2
MEM_HOUSEObsolete FieldBU_MEM_HOUSEDEC2
.INCLUDECBP: General data (group of people)    
PARTGRPTYPGroup typeBU_GRPTYPBU_GRPTYP
NAME_GRP1Name 1 (group)BU_NAMEGR1BU_NAME
NAME_GRP2Name 2 (group)BU_NAMEGR2BU_NAME
.INCLUDEBP: General Data I (Data Fields - Internal)    
.INCLUDECBP: Internal general data (not dependent on partner cat.)    
MC_NAME1Search Help Field 1 (Name 1/Last Name)BU_MCNAME1CHAR35
MC_NAME2Search Help Field 2 (Name 2/First Name)BU_MCNAME2CHAR35
CRUSRUser who created the objectBU_CRUSRUSNAM
CRDATDate on which the object was createdBU_CRDATDATUM
CRTIMTime at which the object was createdBU_CRTIMUZEIT
CHUSRLast user to change objectBU_CHUSRUSNAM
CHDATDate when object was last changedBU_CHDATDATUM
CHTIMTime at which object was last changedBU_CHTIMUZEIT
PARTNER_GUIDBusiness Partner GUIDBU_PARTNER_GUIDSYSUUID
ADDRCOMMAddress NumberBU_ADDRCOMMAD_ADDRNUM
TD_SWITCHPlanned Change Documents for Partner Were ConvertedBU_TD_SWITCHCHAR1
IS_ORG_CENTREIndicator: Business Partner Is Also an Organizational CenterBU_IS_ORG_CENTREBU_IS_ORG_CENTRE
DB_KEYUUID in X form (binary)SYSUUID_XSYSUUID
VALID_FROMValidity Start BUT000 BP DataBU_BP_VALID_FROMTZNTSTMPS
VALID_TOValidity End BUT000 BP DataBU_BP_VALID_TOTZNTSTMPS
XPCPTBusiness Purpose Completed FlagBU_XPCPTBU_XPCPT
.INCLU--APAppend BUT000: Indicator Natural Person for Taxes    
NATPERSBusiness Partner Is a Natural Person Under the Tax LawsBU_NATURAL_PERSONBU_NATURAL_PERSON

BUT000 related tables

TableNote
DFKKORDERASSIGNAssignment of ORDNR for General Requests (General Object)
JGTBP00IS-M: Business Partner Master Data (General Data)
J_7LV01REA Packaging Master Data: General Data
SATC_AC_RESULTGTransaction data: 'Display Load' backpack / general data
/BEV3/CHCDPCTR1CDP: Contract Data 1 - General Contract Data
AFWBM_ATT_BMTRM: Key Table for Benchmark Master Data(General Attributes)
AGS_JOB_GENSTGeneral Data Repository
AGS_JOB_GENST_HGeneral Repository Header Data
ALDBSMTECCMS Monitoring Arch.: Database Segment: General MTE Data
ANGAAsset catalog general data
ANKAAsset classes: general data
BANK_PP_PARUNHDGeneral Data on Mass Runs (Header)
BBPD_BWREP_HDRBW Reports: General Data
BBPM_BUT_FRG0010Business Partner: General BBP Data (Administration)
BBPM_BUT_FRG0011Business Partner: General BBP Data
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com