TB039A

Transparent Table Customizing Table
9 Fields 5 CDS Views

BP ID Types

TB039A is an SAP database table in S/4HANA. BP ID Types. It contains 9 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_BuPaIdentificationType view from BASIC CDS View for BP Identification Types
I_BusPartIdentificationType view from COMPOSITE Business Partner identification Type View
I_BusPartIdentificationType view union COMPOSITE Business Partner identification Type View
P_BPUsrPersonExternalIDCust view_entity from BASIC BP Person External ID Cust.(TB039A)
R_BPUsrPersonExternalID view_entity inner COMPOSITE Business User Person External ID

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY type BU_ID_TYPE ID Type
category BU_ID_CATEGORY ID Categ.
xpropose BU_ID_XPROPOSE Default
xperson BU_ID_XPERSON Persons
xorganisation BU_ID_XORGANISATION Organizations
xgroup BU_ID_XGROUP Groups
xspd_relevant BU_ID_XSPD Sensitive Pers. Data
xvalidate BU_ID_XVALIDATE Validate ID

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 Types
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TB039A (
    CLIENT,         -- Client [MANDT]
    TYPE,           -- ID Type [BU_ID_TYPE]
    CATEGORY,       -- ID Categ. [BU_ID_CATEGORY]
    XPROPOSE,       -- Default [BU_ID_XPROPOSE]
    XPERSON,        -- Persons [BU_ID_XPERSON]
    XORGANISATION,  -- Organizations [BU_ID_XORGANISATION]
    XGROUP,         -- Groups [BU_ID_XGROUP]
    XSPD_RELEVANT,  -- Sensitive Pers. Data [BU_ID_XSPD]
    XVALIDATE,      -- Validate ID [BU_ID_XVALIDATE]
    PRIMARY KEY (CLIENT, TYPE)
);

Learn More