SAP BBP_CT_CATEGORY Category Table data and field list

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

The BBP_CT_CATEGORY table consists of various fields, each holding specific information or linking keys about Category data available in SAP. These include CLIENT (Client), CATEGORY_GUID (Category GUID), HEADER_GUID (GUID Header), CATALOG_GUID (Catalog GUID)... 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_CATEGORY 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_CATEGORY 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_CATEGORY 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
CATEGORY_GUIDCategory GUID BBPT_CT_CATEGORY_GUIDRAW16SYSUUID
HEADER_GUIDGUID Header BBPT_CT_HEADER_GUIDRAW16SYSUUID
CATALOG_GUIDCatalog GUID BBPT_CT_CATALOG_GUIDRAW16SYSUUID
CAT_STATUSCategory Status BBPT_CT_CATEGORY_STATUSCHAR1BBP_CT_CATEGORY_STATUS
XML_ID_UNSPSCCategory ID UN/SPSC BBPT_CT_CATEGORY_ID_UNSPSCCHAR20COM_CATEGORY_ID
XML_ID_SELLERCategory ID Seller BBPT_CT_CATEGORY_ID_SELLERCHAR60CHAR60
XML_ID_BUYERCategory ID Buyer BBPT_CT_CATEGORY_ID_BUYERCHAR80CHAR80
XML_PARID_UNSPSCCategory ID UN/SPSC BBPT_CT_CATEGORY_ID_UNSPSCCHAR20COM_CATEGORY_ID
XML_PARID_SELLERCategory ID Seller BBPT_CT_CATEGORY_ID_SELLERCHAR60CHAR60
XML_PARID_BUYERCategory ID Buyer BBPT_CT_CATEGORY_ID_BUYERCHAR80CHAR80
XML_RETAIL_CATTCategory Type Indicator BBPT_CT_RETAIL_CATTYPECHAR1CHAR1
XML_CAT_NUMExternal Category Number BBPT_CT_CATEGORY_NUMCHAR30CHAR30
CATALOG_IDCatalog ID BBPT_CT_CATALOG_IDCHAR40CHAR40

Key field Non-key field



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

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

SELECT SINGLE *
FROM BBP_CT_CATEGORY
INTO CORRESPONDING FIELDS OF WA_BBP_CT_CATEGORY
WHERE...

How to access SAP table BBP_CT_CATEGORY

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

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