TE097T

Transparent Table Customizing Table
6 Fields 2 CDS Views

Account Determ. IDs - Texts

TE097T is an SAP database table in S/4HANA. Account Determ. IDs - Texts. It contains 6 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_UtilsAccountDetnCodeText view from BASIC Account Determination Code - Text
ISU_C4C_PREMISE_CONTRACTS_V view_entity left_outer Contracts details in premise

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY spras SPRAS Language
KEY bukrs BUKRS Company Code
KEY sparte SPARTE Division
KEY kofiz E_KOFIZ Acct Determ. ID
text50 TEXT50 Explanation

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.

-- Account Determ. IDs - Texts
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TE097T (
    MANDT,   -- Client [MANDT]
    SPRAS,   -- Language [SPRAS]
    BUKRS,   -- Company Code [BUKRS]
    SPARTE,  -- Division [SPARTE]
    KOFIZ,   -- Acct Determ. ID [E_KOFIZ]
    TEXT50,  -- Explanation [TEXT50]
    PRIMARY KEY (MANDT, SPRAS, BUKRS, SPARTE, KOFIZ)
);

Learn More