BUT000_TD SAP (BP: General Data I, Shadow Table Time Dependency) Table details

Dictionary Type: Table
Description: BP: General Data I, Shadow Table Time Dependency




ABAP Code to SELECT data from BUT000_TD
Related tables to BUT000_TD
Access table BUT000_TD




Table field list including key, data, relationships and ABAP select examples

BUT000_TD is a standard SAP Table which is used to store BP: General Data I, Shadow Table Time Dependency data and is available within R/3 SAP systems depending on the version and release level.

The BUT000_TD table consists of various fields, each holding specific information or linking keys about BP: General Data I, Shadow Table Time Dependency data available in SAP. These include PARTNER (Business Partner Number), VALID_TO (Validity End BUT000 BP Data), TYPE (Business partner category), BPKIND (Business Partner Type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP BUT000_TD table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CLIENTClient MANDTCLNT3T000MANDT
PARTNERBusiness Partner Number BU_PARTNERCHAR10BUT000ALPHABU_PARTNERBPABUPA
VALID_TOValidity End BUT000 BP Data BU_BP_VALID_TODEC15TZNTSTMPS
TYPEBusiness partner category BU_TYPECHAR1BU_TYPEBPY
BPKINDBusiness Partner Type BU_BPKINDCHAR4TB004BU_KIND
BU_GROUPBusiness Partner Grouping BU_GROUPCHAR4TB001BU_GROUPBPP
BPEXTBusiness Partner Number in External System BU_BPEXTCHAR20CHAR20
BU_SORT1Search term 1 for business partner BU_SORT1CHAR20BU_SORT1
BU_SORT2Search term 2 for business partner BU_SORT2CHAR20BU_SORT1
SOURCEData Origin Types BU_SOURCECHAR4TB005BU_SOURCE
TITLEForm-of-Address Key AD_TITLECHAR4TSAD3AD_TITLE
XDELECentral Archiving Flag BU_XDELECHAR1XFELD
XBLCKCentral Block for Business Partner BU_XBLCKCHAR1XFELD
AUGRPAuthorization Group BU_AUGRPCHAR4Assigned to domainBU_AUGRP
TITLE_LETSalutation BU_TITLE_LETCHAR50TEXT50
BU_LOGSYSLogical system LOGSYSCHAR10TBDLSALPHALOGSYS
CONTACTBusiness Partner: Contact Permission BU_CONTACTCHAR1BU_CONTACT
NOT_RELEASEDIndicator: Not Released BU_XNOT_RELEASEDCHAR1XFELD
NOT_LG_COMPETENTIndicator: Not Legally Competent BU_NOT_LEG_COMPETENTCHAR1BOOLE
PRINT_MODEBusiness Partner Print Format BU_PRINT_MODECHAR1BU_PRINT_MODE
BP_EEW_DUMMYDummy function in length 1 DUMMYCHAR1DUMMY
.INCLU--AP 0
NAPRBusiness Partner Is a Natural Person Under the Tax Laws BU_NATURAL_PERSONCHAR1BU_NATURAL_PERSON
BBP_IPISPTax Split BBP_J_1BINDEQUCHAR1XFELD
.INCLU--AP 0
RATECost Rate/Revenue Rate for Project Costing DPR_TV_RATECHAR15DPR_RATESDPR_RATE_TYPE
NAME_ORG1Name 1 of organization BU_NAMEOR1CHAR40BU_NAME
NAME_ORG2Name 2 of organization BU_NAMEOR2CHAR40BU_NAME
NAME_ORG3Name 3 of organization BU_NAMEOR3CHAR40BU_NAME
NAME_ORG4Name 4 of organization BU_NAMEOR4CHAR40BU_NAME
LEGAL_ENTYBP: Legal form of organization BU_LEGENTYCHAR2TB019BU_LEGENTYH_TB019
IND_SECTORIndustry sector BU_INDSECTCHAR10TB023BU_INDSECTH_TB023
LEGAL_ORGLegal Entity of Organization BU_LEGAL_ORGCHAR2TB032BU_LEGAL_ORG
FOUND_DATDate organization founded BU_FOUND_DATDATS8DATUM
LIQUID_DATLiquidation date of organization BU_LIQUID_DATDATS8
LOCATION_1International location number (part 1) BBBNRNUMC7NUM07
LOCATION_2International location number (Part 2) BBSNRNUMC5NUM05
LOCATION_3Check digit for the international location number BUBKZNUMC1NUM01
NAME_LASTLast name of business partner (person) BU_NAMEP_LCHAR40BU_NAME
NAME_FIRSTFirst name of business partner (person) BU_NAMEP_FCHAR40BU_NAME
NAME_LST2Other Last Name of a Person BU_NAMEPL2CHAR40BU_NAME
NAME_LAST2Name at birth of business partner BU_BIRTHNMCHAR40BU_NAME
NAMEMIDDLEMiddle name or second forename of a person BU_NAMEMIDCHAR40BU_NAME
TITLE_ACA1Academic Title: Key AD_TITLE1CHAR4TSAD2AD_TITLE1AD_TITLE1
TITLE_ACA2Second academic title (key) AD_TITLE2CHAR4TSAD2AD_TITLE1
TITLE_ROYLName supplement, e.g. noble title (key) AD_TITLESCHAR4TSAD5AD_TITLES
PREFIX1Name Prefix (Key) AD_PREFIXCHAR4TSAD4AD_PREFIX
PREFIX22nd name prefix (key) AD_PREFIX2CHAR4TSAD4AD_PREFIX
NAME1_TEXTFull Name BU_NAME1TXCHAR80TEXT80
NICKNAMENickname of Business Partner (Person) BU_NICKNAMCHAR40BU_NAME
INITIALS'Middle Initial' or personal initials AD_INITSCHAR10CHAR10
NAMEFORMATName format AD_FORMATCHAR2T005NAD_NAMFORM
NAMCOUNTRYCountry for name format rule AD_NAMCTRYCHAR3T005LAND1
LANGU_CORRBusiness Partner: Correspondence Language BU_LANGU_CORRLANG1T002ISOLASPRAS
XSEXMSelection: Business partner is male BU_XSEXMCHAR1XFELD
XSEXFSelection: Business partner is female BU_XSEXFCHAR1XFELD
BIRTHPLBirthplace of business partner BU_BIRTHPLCHAR40TEXT40
MARSTMarital Status of Business Partner BU_MARSTCHAR1TB027BU_MARST
EMPLOName of Employer of a Natural Person BU_EMPLOCHAR35BU_EMPLO
JOBGROccupation/group BU_JOBGRCHAR4TB028BU_JOBGR
NATIONationality BU_NATIOCHAR3T005LAND1
CNTAXObsolete Field BU_CNTAXCHAR3Assigned to domainLAND1
CNDSCCtry of Origin: Non-Res. Companies BU_CNDSCCHAR3T005LAND1
PERSNUMBERPerson number AD_PERSNUMCHAR10Assigned to domainALPHAAD_PERSNUMCDTADDRESS
XSEXUSelection: Sex of business partner is not known BU_XSEXUCHAR1XFELD
XUBNAMEObsolete Field BU_XUBNAMECHAR12USR02XUBNAME
BU_LANGUBusiness partner: Language BU_LANGULANG1T002ISOLASPRAS
BIRTHDTDate of Birth of Business Partner BU_BIRTHDTDATS8DATUM
DEATHDTDate of death of business partner BU_DEATHDTDATS8DATUM
PERNOPersonnel Number BU_PERNONUMC8PERSONID
CHILDRENObsolete Field BU_CHILDRENNUMC2NUMC2
MEM_HOUSEObsolete Field BU_MEM_HOUSEDEC2DEC2
PARTGRPTYPGroup type BU_GRPTYPCHAR4TB025BU_GRPTYPH_TB025
NAME_GRP1Name 1 (group) BU_NAMEGR1CHAR40BU_NAME
NAME_GRP2Name 2 (group) BU_NAMEGR2CHAR40BU_NAME
MC_NAME1Search Help Field 1 (Name 1/Last Name) BU_MCNAME1CHAR35CHAR35
MC_NAME2Search Help Field 2 (Name 2/First Name) BU_MCNAME2CHAR35CHAR35
CRUSRUser who created the object BU_CRUSRCHAR12USNAM
CRDATDate on which the object was created BU_CRDATDATS8DATUM
CRTIMTime at which the object was created BU_CRTIMTIMS6UZEIT
CHUSRLast user to change object BU_CHUSRCHAR12USNAM
CHDATDate when object was last changed BU_CHDATDATS8DATUM
CHTIMTime at which object was last changed BU_CHTIMTIMS6UZEIT
PARTNER_GUIDBusiness Partner GUID BU_PARTNER_GUIDRAW16SYSUUID
ADDRCOMMAddress Number BU_ADDRCOMMCHAR10Assigned to domainALPHAAD_ADDRNUMADR
TD_SWITCHPlanned Change Documents for Partner Were Converted BU_TD_SWITCHCHAR1CHAR1
IS_ORG_CENTREIndicator: Business Partner Is Also an Organizational Center BU_IS_ORG_CENTRECHAR1BU_IS_ORG_CENTRE
DB_KEYUUID in X form (binary) SYSUUID_XRAW16SYSUUID
VALID_FROMValidity Start BUT000 BP Data BU_BP_VALID_FROMDEC15TZNTSTMPS
.INCLU--AP 0
NATPERSBusiness Partner Is a Natural Person Under the Tax Laws BU_NATURAL_PERSONCHAR1BU_NATURAL_PERSON
NAME_ORG1Name 1 of organization BU_NAMEOR1CHAR40BU_NAME
NAME_ORG2Name 2 of organization BU_NAMEOR2CHAR40BU_NAME
NAME_ORG3Name 3 of organization BU_NAMEOR3CHAR40BU_NAME
NAME_ORG4Name 4 of organization BU_NAMEOR4CHAR40BU_NAME
LEGAL_ENTYBP: Legal form of organization BU_LEGENTYCHAR2TB019BU_LEGENTYH_TB019
IND_SECTORIndustry sector BU_INDSECTCHAR10TB023BU_INDSECTH_TB023
LEGAL_ORGLegal Entity of Organization BU_LEGAL_ORGCHAR2TB032BU_LEGAL_ORG
FOUND_DATDate organization founded BU_FOUND_DATDATS8DATUM
LIQUID_DATLiquidation date of organization BU_LIQUID_DATDATS8
LOCATION_1International location number (part 1) BBBNRNUMC7NUM07
LOCATION_2International location number (Part 2) BBSNRNUMC5NUM05
LOCATION_3Check digit for the international location number BUBKZNUMC1NUM01
NAME_LASTLast name of business partner (person) BU_NAMEP_LCHAR40BU_NAME
NAME_FIRSTFirst name of business partner (person) BU_NAMEP_FCHAR40BU_NAME
NAME_LST2Other Last Name of a Person BU_NAMEPL2CHAR40BU_NAME
NAME_LAST2Name at birth of business partner BU_BIRTHNMCHAR40BU_NAME
NAMEMIDDLEMiddle name or second forename of a person BU_NAMEMIDCHAR40BU_NAME
TITLE_ACA1Academic Title: Key AD_TITLE1CHAR4TSAD2AD_TITLE1AD_TITLE1
TITLE_ACA2Second academic title (key) AD_TITLE2CHAR4TSAD2AD_TITLE1
TITLE_ROYLName supplement, e.g. noble title (key) AD_TITLESCHAR4TSAD5AD_TITLES
PREFIX1Name Prefix (Key) AD_PREFIXCHAR4TSAD4AD_PREFIX
PREFIX22nd name prefix (key) AD_PREFIX2CHAR4TSAD4AD_PREFIX
NAME1_TEXTFull Name BU_NAME1TXCHAR80TEXT80
NICKNAMENickname of Business Partner (Person) BU_NICKNAMCHAR40BU_NAME
INITIALS'Middle Initial' or personal initials AD_INITSCHAR10CHAR10
NAMEFORMATName format AD_FORMATCHAR2T005NAD_NAMFORM
NAMCOUNTRYCountry for name format rule AD_NAMCTRYCHAR3T005LAND1
LANGU_CORRBusiness Partner: Correspondence Language BU_LANGU_CORRLANG1T002ISOLASPRAS
XSEXMSelection: Business partner is male BU_XSEXMCHAR1XFELD
XSEXFSelection: Business partner is female BU_XSEXFCHAR1XFELD
BIRTHPLBirthplace of business partner BU_BIRTHPLCHAR40TEXT40
MARSTMarital Status of Business Partner BU_MARSTCHAR1TB027BU_MARST
EMPLOName of Employer of a Natural Person BU_EMPLOCHAR35BU_EMPLO
JOBGROccupation/group BU_JOBGRCHAR4TB028BU_JOBGR
NATIONationality BU_NATIOCHAR3T005LAND1
CNTAXObsolete Field BU_CNTAXCHAR3Assigned to domainLAND1
CNDSCCtry of Origin: Non-Res. Companies BU_CNDSCCHAR3T005LAND1
PERSNUMBERPerson number AD_PERSNUMCHAR10Assigned to domainALPHAAD_PERSNUMCDTADDRESS
XSEXUSelection: Sex of business partner is not known BU_XSEXUCHAR1XFELD
XUBNAMEObsolete Field BU_XUBNAMECHAR12USR02XUBNAME
BU_LANGUBusiness partner: Language BU_LANGULANG1T002ISOLASPRAS
BIRTHDTDate of Birth of Business Partner BU_BIRTHDTDATS8DATUM
DEATHDTDate of death of business partner BU_DEATHDTDATS8DATUM
PERNOPersonnel Number BU_PERNONUMC8PERSONID
CHILDRENObsolete Field BU_CHILDRENNUMC2NUMC2
MEM_HOUSEObsolete Field BU_MEM_HOUSEDEC2DEC2
PARTGRPTYPGroup type BU_GRPTYPCHAR4TB025BU_GRPTYPH_TB025
NAME_GRP1Name 1 (group) BU_NAMEGR1CHAR40BU_NAME
NAME_GRP2Name 2 (group) BU_NAMEGR2CHAR40BU_NAME
MC_NAME1Search Help Field 1 (Name 1/Last Name) BU_MCNAME1CHAR35CHAR35
MC_NAME2Search Help Field 2 (Name 2/First Name) BU_MCNAME2CHAR35CHAR35
CRUSRUser who created the object BU_CRUSRCHAR12USNAM
CRDATDate on which the object was created BU_CRDATDATS8DATUM
CRTIMTime at which the object was created BU_CRTIMTIMS6UZEIT
CHUSRLast user to change object BU_CHUSRCHAR12USNAM
CHDATDate when object was last changed BU_CHDATDATS8DATUM
CHTIMTime at which object was last changed BU_CHTIMTIMS6UZEIT
PARTNER_GUIDBusiness Partner GUID BU_PARTNER_GUIDRAW16SYSUUID
ADDRCOMMAddress Number BU_ADDRCOMMCHAR10Assigned to domainALPHAAD_ADDRNUMADR
TD_SWITCHPlanned Change Documents for Partner Were Converted BU_TD_SWITCHCHAR1CHAR1
VALID_FROMValidity Start BUT000 BP Data BU_BP_VALID_FROMDEC15TZNTSTMPS
.INCLU--AP 0
NATPERSBusiness Partner Is a Natural Person Under the Tax Laws BU_NATURAL_PERSONCHAR1BU_NATURAL_PERSON

Key field Non-key field



How do I retrieve data from SAP table BUT000_TD using ABAP code

The following ABAP code Example will allow you to do a basic selection on BUT000_TD to SELECT all data from the table
DATA: WA_BUT000_TD TYPE BUT000_TD.

SELECT SINGLE *
FROM BUT000_TD
INTO CORRESPONDING FIELDS OF WA_BUT000_TD
WHERE...

How to access SAP table BUT000_TD

Within an ECC or HANA version of SAP you can also view further information about BUT000_TD and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!