SAP BBP_CT_PARTNER Partner Table data and field list

BBP_CT_PARTNER is a standard SAP Table which is used to store Partner data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The BBP_CT_PARTNER table consists of various fields, each holding specific information or linking keys about Partner data available in SAP. These include CLIENT (Client), PARTNER_GUID (GUID Partner), HEADER_GUID (GUID Header), PARTNER_STATUS (Partner Status)... 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. .

BBP_CT_PARTNER table Technical Details:

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 BBP_CT_PARTNER table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the BBP_CT_PARTNER table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CLIENTClient MANDTCLNT3Assigned to domainMANDT
PARTNER_GUIDGUID Partner BBPT_CT_PARTNER_GUIDRAW16SYSUUID
HEADER_GUIDGUID Header BBPT_CT_HEADER_GUIDRAW16SYSUUID
PARTNER_STATUSPartner Status BBPT_CT_PARTNER_STATUSCHAR1BBP_CT_OBJECT_STATUS
PARTNER_TYPEPartner Type BBPT_CT_PARTNER_TYPECHAR2BBP_CT_PARTNER_TYPE
XML_DUNS_IDPartner ID DUNS BBPT_CT_PARTNER_ID_DUNSCHAR10Assigned to domainALPHABU_PARTNER
XML_BUYER_IDPartner ID (Buyer) BBPT_CT_PARTNER_ID_BUYERCHAR10Assigned to domainALPHABU_PARTNER
XML_SELLER_IDPartner ID (Seller) BBPT_CT_PARTNER_ID_SELLERCHAR60CHAR60
XML_COMPNAME1Company Name 1 BBPT_CT_COMPANY_NAME1CHAR40TEXT40
XML_COMPNAME2Company Name 2 BBPT_CT_COMPANY_NAME2CHAR40TEXT40
XML_STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
XML_HOUSENUMHouse Number AD_HSNM1CHAR10TEXT10
XML_CITYCity AD_CITY1CHAR40TEXT40CLCITYNAME
XML_POSTALCODECity postal code AD_PSTCD1CHAR10CHAR10
XML_REGIONSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
XML_COUNTRYCountry Key LAND1CHAR3Assigned to domainLAND1LND
XML_PERSONTITLEAcademic Title: Written Form AD_TITLE1TCHAR20TEXT20
XML_FIRSTNAMEFirst name AD_NAMEFIRCHAR40TEXT40
XML_LASTNAMELast name AD_NAMELASCHAR40TEXT40
XML_DEPARTMENTDepartment AD_DPRTMNTCHAR40TEXT40
XML_BUILDINGBuilding (number or code) AD_BLDNG_PCHAR10TEXT10
XML_ROOMNUMRoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
XML_TELNUMFirst telephone no.: dialling code+number AD_TLNMBR1CHAR30CHAR30
XML_TELNUMEXTFirst Telephone No.: Extension AD_TLXTNS1CHAR10CHAR10
XML_FAXNUMFirst fax no.: dialling code+number AD_FXNMBR1CHAR30CHAR30
XML_FAXNUMEXTFirst fax no.: extension AD_FXXTNS1CHAR10CHAR10
XML_EMAILE-Mail Address AD_SMTPADRCHAR241SXIDNAD_SMTPADR
MY_PARTNER_GUIDBusiness Partner GUID BU_PARTNER_GUIDRAW16SYSUUID
COMPNAME1_LARGECompany Name 1 in Uppercase BBPT_CT_COMPANY_NAME1_LARGECHAR40CHAR40
COMPNAME2_LARGECompany Name 2 in Uppercase BBPT_CT_COMPANY_NAME2_LARGECHAR40CHAR40

Key field Non-key field



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

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

SELECT SINGLE *
FROM BBP_CT_PARTNER
INTO CORRESPONDING FIELDS OF WA_BBP_CT_PARTNER
WHERE...

How to access SAP table BBP_CT_PARTNER

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

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