TFMCA_REVTYPE

Transparent Table Customizing Table
18 Fields 1 CDS Views

Einnahmearten

TFMCA_REVTYPE is an SAP database table in S/4HANA. Einnahmearten. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PublicSectorRevenueType view from BASIC Revenue Type

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY abtyp abtyp_ps Revenue Type
vktyp vktyp_kk Cont. Acct Cat.
hvorg hvorg_kk Main Trans.
tvorg tvorg_kk Subtransaction
frper frper_kk From Period Key
toper toper_kk To Period Key
xadja xadja_ps Include All COs
doctype doctype_kk Document Type
doctype_simbill doctype_simbill_kk DT Simulatd Doc
wfd_id swd_wfd_id Workflow definition
version swd_versio Version
exetyp swd_exetyp Type
bp_id_type bu_id_type ID Type
fbtax fbtax_ps Form-Based
xsdgis rdi_xsgdis_ps Indiv. Document
xjointf xjointf_ps Joint Tax Return
fbnur fbnur_ps Number Range

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.

-- Einnahmearten
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TFMCA_REVTYPE (
    MANDT,            -- Client [mandt]
    ABTYP,            -- Revenue Type [abtyp_ps]
    VKTYP,            -- Cont. Acct Cat. [vktyp_kk]
    HVORG,            -- Main Trans. [hvorg_kk]
    TVORG,            -- Subtransaction [tvorg_kk]
    FRPER,            -- From Period Key [frper_kk]
    TOPER,            -- To Period Key [toper_kk]
    XADJA,            -- Include All COs [xadja_ps]
    DOCTYPE,          -- Document Type [doctype_kk]
    DOCTYPE_SIMBILL,  -- DT Simulatd Doc [doctype_simbill_kk]
    WFD_ID,           -- Workflow definition [swd_wfd_id]
    VERSION,          -- Version [swd_versio]
    EXETYP,           -- Type [swd_exetyp]
    BP_ID_TYPE,       -- ID Type [bu_id_type]
    FBTAX,            -- Form-Based [fbtax_ps]
    XSDGIS,           -- Indiv. Document [rdi_xsgdis_ps]
    XJOINTF,          -- Joint Tax Return [xjointf_ps]
    FBNUR,            -- Number Range [fbnur_ps]
    PRIMARY KEY (MANDT, ABTYP)
);

Learn More