TB039

Transparent Table Control Table (SAP+Cust)
14 Fields 1 CDS Views

BP ID Categories

TB039 is an SAP database table in S/4HANA. BP ID Categories. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BPIdentificationCategory view from BASIC BP Identification Categories

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY category BU_ID_CATEGORY ID Categ.
id_unique BU_ID_UNIQUE ID Unique
id_display_only BU_ID_DISPLAY Display Only
one_id_per_bp BU_ONE_ID_PER_BP One ID per BP
scheme_id BU_SCHEME_ID Identificatn Schema
scheme_agency_id BU_SCHEME_AGENCY_ID Agency
sa_scheme_id BU_SA_SCHEME_ID Context for Agency
sa_s_agency_id BU_SA_S_AGENCY_ID Agency
org_centre_rel BU_ID_ORGCENTRE_RELEVANT Org.Cent.Relvnt
not_bp_rel BU_ID_NOT_BP_RELEVANT Not BP-Relevant
protect BU_PROTECT Protect
owner_bo BU_SESF_BUSINESS_OBJECT Business Object
casetype BU_IDENT_CASETYPE Upper/Lowercase
alpha BU_IDENT_ALPHA Alpha Conv.

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- BP ID Categories
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TB039 (
    CATEGORY,          -- ID Categ. [BU_ID_CATEGORY]
    ID_UNIQUE,         -- ID Unique [BU_ID_UNIQUE]
    ID_DISPLAY_ONLY,   -- Display Only [BU_ID_DISPLAY]
    ONE_ID_PER_BP,     -- One ID per BP [BU_ONE_ID_PER_BP]
    SCHEME_ID,         -- Identificatn Schema [BU_SCHEME_ID]
    SCHEME_AGENCY_ID,  -- Agency [BU_SCHEME_AGENCY_ID]
    SA_SCHEME_ID,      -- Context for Agency [BU_SA_SCHEME_ID]
    SA_S_AGENCY_ID,    -- Agency [BU_SA_S_AGENCY_ID]
    ORG_CENTRE_REL,    -- Org.Cent.Relvnt [BU_ID_ORGCENTRE_RELEVANT]
    NOT_BP_REL,        -- Not BP-Relevant [BU_ID_NOT_BP_RELEVANT]
    PROTECT,           -- Protect [BU_PROTECT]
    OWNER_BO,          -- Business Object [BU_SESF_BUSINESS_OBJECT]
    CASETYPE,          -- Upper/Lowercase [BU_IDENT_CASETYPE]
    ALPHA,             -- Alpha Conv. [BU_IDENT_ALPHA]
    PRIMARY KEY (CATEGORY)
);

Learn More