TB027

Transparent Table Customizing Table
2 Fields 4 CDS Views

BP marital status

TB027 is an SAP database table in S/4HANA. BP marital status. It contains 2 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
CUAN_Freetext_Mapping view_entity union View for freetext mapping
cuan_marital_status_search view_entity from Marital Status Search
I_BusPartMaritalStatus view from BASIC BUPA Marital Status
I_MKT_Marital view_entity from BASIC Marketing: Marital Status

Fields (2)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY marst BU_MARST Marital Status

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 marital status
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TB027 (
    CLIENT,  -- Client [MANDT]
    MARST,   -- Marital Status [BU_MARST]
    PRIMARY KEY (CLIENT, MARST)
);

Learn More