MMPUR_EXT_SKAT

Transparent Table Application Table

Maintain Extracted Master Data for G/L Account Description

MMPUR_EXT_SKAT is an SAP database table in S/4HANA. Maintain Extracted Master Data for G/L Account Description. It contains 6 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProcmtHubGLAccountText view from BASIC Basic View for G/L Account Description from Back-End System

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY extsourcesystem MMPUR_D_SOURCE_SYS Connected System ID
KEY chartofaccounts KTOPL Chart of Accts
KEY glaccount SAKNR G/L Account
KEY language SPRAS Language
glaccountlongname TXT50_SKAT Long Text

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.

-- Maintain Extracted Master Data for G/L Account Description
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_EXT_SKAT (
    MANDT,              -- Client [MANDT]
    EXTSOURCESYSTEM,    -- Connected System ID [MMPUR_D_SOURCE_SYS]
    CHARTOFACCOUNTS,    -- Chart of Accts [KTOPL]
    GLACCOUNT,          -- G/L Account [SAKNR]
    LANGUAGE,           -- Language [SPRAS]
    GLACCOUNTLONGNAME,  -- Long Text [TXT50_SKAT]
    PRIMARY KEY (MANDT, EXTSOURCESYSTEM, CHARTOFACCOUNTS, GLACCOUNT, LANGUAGE)
);