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 | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||
|
||||||||||||
|
NOT_BP_REL
Indicator: ID Number Not Relevant for Business Partner
|
BU_ID_NOT_BP_RELEVANT |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
PROTECT
BP: 'Protect Data' Indicator
|
BU_PROTECT |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
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 | ||||||||
|
||||||||||||