TVPAT

Transparent Table System Table (SAP only)
4 Fields 1 CDS Views

Business partners: Control in sales documents

TVPAT is an SAP database table in S/4HANA. Business partners: Control in sales documents. It contains 4 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PartnerTypeText view from BASIC Purchasing Document Partner Type Text

Fields (4)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY spras spras Language
KEY nrart nrart Partner Type
vtext bezei20 Description

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.

-- Business partners: Control in sales documents
-- Category TRANSPARENT · Delivery class S
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TVPAT (
    MANDT,  -- Client [mandt]
    SPRAS,  -- Language [spras]
    NRART,  -- Partner Type [nrart]
    VTEXT,  -- Description [bezei20]
    PRIMARY KEY (MANDT, SPRAS, NRART)
);

Learn More