BUT000_SRC - Master Data Consolidation: Source Table for BUT000

Master Data Consolidation: Source Table for BUT000 information is stored in SAP table BUT000_SRC.
It is part of development package MDC_BP_MODEL in software component CA-MDG-CMP-BP. This development package consists of objects that can be grouped under "Master Data Consolidation: Business Partner Data Model".

Fields for table BUT000_SRC

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
CLIENTClientXMANDTCLNT6
.INCLUDESOURCE_KEYXMDC_SOURCE_KEY0
SOURCE_SYSTEMSource SystemXMDC_BUSINESS_SYSTEMCHAR120
SOURCE_IDMaster Data Consolidation: ID of a Source ObjectsXMDC_SOURCE_IDCHAR120
PARTNERBusiness Partner NumberBU_PARTNERCHAR20
.INCLUDEBUS000_DAT0
.INCLUDEINDEPBUS000A0
.INCLUDEBUS000AINI0
TYPEBusiness Partner CategoryBU_TYPECHAR2
BPKINDBusiness Partner TypeBU_BPKINDCHAR8TB004
BU_GROUPBusiness Partner GroupingBU_GROUPCHAR8TB001
BPEXTBusiness Partner Number in External SystemBU_BPEXTCHAR40
.INCLUDEBUS000ADAT0
BU_SORT1Search Term 1 for Business PartnerBU_SORT1CHAR40
BU_SORT2Search Term 2 for Business PartnerBU_SORT2CHAR40
SOURCEData Origin TypesBU_SOURCECHAR8TB005
TITLEForm-of-Address KeyAD_TITLECHAR8TSAD3
XDELECentral Archiving FlagBU_XDELECHAR2
XBLCKCentral Block for Business PartnerBU_XBLCKCHAR2
AUGRPAuthorization GroupBU_AUGRPCHAR8*
TITLE_LETSalutationBU_TITLE_LETCHAR100
BU_LOGSYSLogical systemLOGSYSCHAR20TBDLS
CONTACTBusiness Partner: Contact PermissionBU_CONTACTCHAR2
NOT_RELEASEDIndicator: Not ReleasedBU_XNOT_RELEASEDCHAR2
NOT_LG_COMPETENTIndicator: Not Legally CompetentBU_NOT_LEG_COMPETENTCHAR2
PRINT_MODEBusiness Partner Print FormatBU_PRINT_MODECHAR2
.INCLUDEINCL_EEW_BUT000INCL_EEW_BUT0000
BP_EEW_DUMMYDummy function in length 1DUMMYCHAR2
.INCLUDECICI_EEW_BUT0000
.INCLU--APPRP_BUPA_RATE0
RATECost Rate/Revenue Rate for Project CostingDPR_TV_RATECHAR30DPR_RATES
.INCLUDEORGBUS000O0
.INCLUDEBUS000O_CHAR0
NAME_ORG1Name 1 of organizationBU_NAMEOR1CHAR80
NAME_ORG2Name 2 of organizationBU_NAMEOR2CHAR80
NAME_ORG3Name 3 of organizationBU_NAMEOR3CHAR80
NAME_ORG4Name 4 of organizationBU_NAMEOR4CHAR80
LEGAL_ENTYBP: Legal form of organizationBU_LEGENTYCHAR4TB019
IND_SECTORIndustry sectorBU_INDSECTCHAR20TB023
LEGAL_ORGLegal Entity of OrganizationBU_LEGAL_ORGCHAR4TB032
.INCLUDEBUS000O_NCHR0
FOUND_DATDate organization foundedBU_FOUND_DATDATS16
LIQUID_DATLiquidation date of organizationBU_LIQUID_DATDATS16
LOCATION_1International location number (part 1)BBBNRNUMC14
LOCATION_2International location number (Part 2)BBSNRNUMC10
LOCATION_3Check digit for the international location numberBUBKZNUMC2
.INCLUDEPERSBUS000N0
.INCLUDEBUS000N_CHAR0
NAME_LASTLast name of business partner (person)BU_NAMEP_LCHAR80
NAME_FIRSTFirst name of business partner (person)BU_NAMEP_FCHAR80
NAME_LST2Other Last Name of a PersonBU_NAMEPL2CHAR80
NAME_LAST2Name at birth of business partnerBU_BIRTHNMCHAR80
NAMEMIDDLEMiddle name or second forename of a personBU_NAMEMIDCHAR80
TITLE_ACA1Academic Title: KeyAD_TITLE1CHAR8TSAD2
TITLE_ACA2Second academic title (key)AD_TITLE2CHAR8TSAD2
TITLE_ROYLName supplement, e.g. noble title (key)AD_TITLESCHAR8TSAD5
PREFIX1Name Prefix (Key)AD_PREFIXCHAR8TSAD4
PREFIX22nd name prefix (key)AD_PREFIX2CHAR8TSAD4
NAME1_TEXTFull NameBU_NAME1TXCHAR160
NICKNAMENickname of Business Partner (Person)BU_NICKNAMCHAR80
INITIALS"Middle Initial" or personal initialsAD_INITSCHAR20
NAMEFORMATName formatAD_FORMATCHAR4T005N
NAMCOUNTRYCountry/Region for Name Format RuleAD_NAMCTRYCHAR6T005
LANGU_CORRBusiness Partner: Correspondence LanguageBU_LANGU_CORRLANG2T002
XSEXMSelection: Business partner is maleBU_XSEXMCHAR2
XSEXFSelection: Business partner is femaleBU_XSEXFCHAR2
BIRTHPLBirthplace of business partnerBU_BIRTHPLCHAR80
MARSTMarital Status of Business PartnerBU_MARSTCHAR2TB027
EMPLOName of Employer of a Natural PersonBU_EMPLOCHAR70
JOBGROccupation/groupBU_JOBGRCHAR8TB028
NATIONationalityBU_NATIOCHAR6T005
CNTAXObsolete FieldBU_CNTAXCHAR6*
CNDSCCountry/Region of Origin: Non-Resident CompaniesBU_CNDSCCHAR6T005
PERSNUMBERPerson NumberAD_PERSNUMCHAR20
XSEXUSelection: Sex of business partner is not knownBU_XSEXUCHAR2
XUBNAMEObsolete FieldBU_XUBNAMECHAR24USR02
BU_LANGUBusiness partner: LanguageBU_LANGULANG2T002
GENDERSex of business partner (person)BU_SEXIDCHAR2TB995
.INCLUDEBUS000N_NCHR0
BIRTHDTDate of Birth of Business PartnerBU_BIRTHDTDATS16
DEATHDTDate of death of business partnerBU_DEATHDTDATS16
PERNOPersonnel NumberBU_PERNONUMC16
CHILDRENObsolete FieldBU_CHILDRENNUMC4
MEM_HOUSEObsolete FieldBU_MEM_HOUSEDEC2
BIRTHDT_STATUSDate of Birth: StatusBU_BIRTHDT_STATUSCHAR2
.INCLUDEGROUPBUS000G0
PARTGRPTYPGroup typeBU_GRPTYPCHAR8TB025
NAME_GRP1Name 1 (group)BU_NAMEGR1CHAR80
NAME_GRP2Name 2 (group)BU_NAMEGR2CHAR80
.INCLUDEBUS000_INT0
.INCLUDEBUS000AINT0
MC_NAME1Search Help Field 1 (Name 1/Last Name)BU_MCNAME1CHAR70
MC_NAME2Search Help Field 2 (Name 2/First Name)BU_MCNAME2CHAR70
CRUSRUser who created the objectBU_CRUSRCHAR24
CRDATDate on which the object was createdBU_CRDATDATS16
CRTIMTime at which the object was createdBU_CRTIMTIMS12
CHUSRLast user to change objectBU_CHUSRCHAR24
CHDATDate when object was last changedBU_CHDATDATS16
CHTIMTime at which object was last changedBU_CHTIMTIMS12
PARTNER_GUIDBusiness Partner GUIDBU_PARTNER_GUIDRAW16
ADDRCOMMAddress NumberBU_ADDRCOMMCHAR20*
TD_SWITCHPlanned Change Documents for Partner Were ConvertedBU_TD_SWITCHCHAR2
IS_ORG_CENTREIndicator: Business Partner Is Also an Organizational CenterBU_IS_ORG_CENTRECHAR2
DB_KEYUUID in X form (binary)SYSUUID_XRAW16
VALID_FROMValidity Start BUT000 BP DataBU_BP_VALID_FROMDEC8
VALID_TOValidity End BUT000 BP DataBU_BP_VALID_TODEC8
XPCPTBusiness Purpose Completed FlagBU_XPCPTCHAR2
NATPERSBusiness Partner Is a Natural Person Under the Tax LawsBU_NATURAL_PERSONCHAR2
SOURCE_RECENCYMaster Data Consolidation: RecencyMDC_RECENCYDEC8
SOURCE_FILTERMaster Data Change Process Source FilterMDC_SOURCE_FILTERCHAR80
.INCLU--APBUT000_MILITARYSRC0
MILVEID for mainly military useMILVECHAR2
NUC_SECNuclear Sector (Indicator)NUC_SECCHAR2
.INCLU--APBUT000_TRSRC0
PAR_RELBusiness Partner ReleasedBP_PAR_RELCHAR2
BP_SORTSort Field for Phonetic Search; ObsoleteBP_SORT_PHCHAR40
.INCLU--APIBKK20SRC0
KBANKSCountry/Region Key of BankBANKSCHAR6*
KBANKLBank KeysBANKKCHAR30
Privacy Policy