TB039

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

GP-Identifikationstypen

TB039 is an SAP database table in S/4HANA. GP-Identifikationstypen. 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.

-- GP-Identifikationstypen
-- 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