SAP Table TB039

BP ID Categories

TB039 (BP ID Categories) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TB039 to other SAP tables.

TB039 table fields

Field Data element Checktable Datatype Length Decimals
CATEGORY BP Identification Category BU_ID_CATEGORY CHAR 6 0
ID_UNIQUE Indicator 'Identification Numbers for Category Are Unique' BU_ID_UNIQUE CHAR 1 0
ID_DISPLAY_ONLY Indicator'ID No.s for Categ. in Dialog Cannot Be Maintained BU_ID_DISPLAY CHAR 1 0
ONE_ID_PER_BP Indicator: Only One ID Number of this Type Permitted per BP BU_ONE_ID_PER_BP CHAR 1 0
SCHEME_ID Identification Schema BU_SCHEME_ID CHAR 60 0
SCHEME_AGENCY_ID Agency that Manages an Identification Schema BU_SCHEME_AGENCY_ID CHAR 60 0
SA_SCHEME_ID Context for Identifying Agency BU_SA_SCHEME_ID CHAR 60 0
SA_S_AGENCY_ID Agency that Manages the SchemeAgencySchemeID BU_SA_S_AGENCY_ID CHAR 3 0
ORG_CENTRE_REL Indicator: ID Number Relevant for Organizational Center BU_ID_ORGCENTRE_RELEVANT CHAR 1 0
X TRUE
NULL FALSE
NOT_BP_REL Indicator: ID Number Not Relevant for Business Partner BU_ID_NOT_BP_RELEVANT CHAR 1 0
X TRUE
NULL FALSE
PROTECT BP: 'Protect Data' Indicator BU_PROTECT CHAR 1 0
X Yes
NULL No
OWNER_BO ESF: Name of a Business Object BU_SESF_BUSINESS_OBJECT CHAR 30 0
CASETYPE SAP BP: Uppercase and Lowercase Attribute for ID Types BU_IDENT_CASETYPE CHAR 1 0
ALPHA SAP BP: Alpha Conversion for ID Type (X = Yes, Space = No) BU_IDENT_ALPHA CHAR 1 0
X Yes
NULL No