BUT051S SAP (Shadow Table BP Relationship: Contact Person Relationship) Table details

Dictionary Type: Table
Description: Shadow Table BP Relationship: Contact Person Relationship




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




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

BUT051S is a standard SAP Table which is used to store Shadow Table BP Relationship: Contact Person Relationship data and is available within R/3 SAP systems depending on the version and release level.

The BUT051S table consists of various fields, each holding specific information or linking keys about Shadow Table BP Relationship: Contact Person Relationship data available in SAP. These include TRKORR (Request/Task), RELNR (BP Relationship Number), PARTNER1 (Business Partner Number), PARTNER2 (Business Partner Number).. 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 BUT051S 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
TRKORRRequest/Task TRKORRCHAR20Assigned to domainTRKORR
RELNRBP Relationship Number BU_RELNRCHAR12BUT050ALPHABU_RELNR
PARTNER1Business Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
PARTNER2Business Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
DATE_TOValidity Date (Valid To) BU_DATTODATS8DATUM
RELTYPBusiness Partner Relationship Category BU_RELTYPCHAR6TBZ9BU_RELTYP
XRFBusiness partner role definition instead of BP relationship BU_XRFCHAR1XFELD
FNCTNFunction name of partner BU_FNCTNCHAR40TEXT40
PAFKTFunction of partner BU_PAFKTCHAR4TB912BU_PAFKT
DPRTMNTDepartment at business partner BU_DPRTMNTCHAR40TEXT40
ABTNRDepartment BU_ABTNRCHAR4TB910BU_ABTNR
PAAUTHPartner's Authority BU_PAAUTHCHAR1TB914BU_PAAUTH
PAVIPVIP Partner BU_PAVIPCHAR1TB916BU_PAVIP
PAREMNotes for Partner BU_PAREMCHAR40TEXT40
TEL_NUMBERTelephone no.: dialling code+number AD_TLNMBRCHAR30CHAR30
TEL_EXTENSTelephone no.: Extension AD_TLXTNSCHAR10CHAR10
FAX_NUMBERFax number: dialling code+number AD_FXNMBRCHAR30CHAR30
FAX_EXTENSFax no.: Extension AD_FXXTNSCHAR10CHAR10
SMTP_ADDRESSE-Mail Address AD_SMTPADRCHAR241SXIDNAD_SMTPADR
REL_PERObsolete: Percentage of Capital Interest BU_REL_PERDEC10(7) DEC3_7
REL_AMOObsolete: Amount of Capital Interest BU_REL_AMOCURR13(2) WERT7V
REL_CURCurrency Key BU_CURRIDCUKY5Assigned to domainWAERS
CALL_RULEIDIdentification Rule for Periodic Appointments: Calling Hours BU_RULEID_CCHAR25BU_SC_RULEID
VISIT_RULEIDIdentification Rule for Periodic Appointments:Visiting Hours BU_RULEID_VCHAR25BU_SC_RULEID
CALL_GUIDSAP BP: Calendar Schema GUID, Calling Hours BU_CALENDAR_SCHEME_CALL_GUIDRAW16SYSUUID
VISIT_GUIDSAP BP: Calendar Schema GUID, Visiting Hours BU_CALENDAR_SCHEME_VISIT_GUIDRAW16SYSUUID
BP_EEW_BUT051Dummy function in length 1 DUMMYCHAR1DUMMY

Key field Non-key field



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

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

SELECT SINGLE *
FROM BUT051S
INTO CORRESPONDING FIELDS OF WA_BUT051S
WHERE...

How to access SAP table BUT051S

Within an ECC or HANA version of SAP you can also view further information about BUT051S 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!