BBP_CT_PARTNER SAP (Partner) Table details

Dictionary Type: Table
Description: Partner




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




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

BBP_CT_PARTNER is a standard SAP Table which is used to store Partner data and is available within R/3 SAP systems 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. .

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

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).


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!