DFMCA_FORMS

Transparent Table Application Table
18 Fields 2 CDS Views

Data Table for Tax Forms

DFMCA_FORMS is an SAP database table in S/4HANA. Data Table for Tax Forms. It contains 18 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_PublicSectorForm view from EXTENSION Form Extension
I_PublicSectorForm view from BASIC Public Sector Form

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY return_id FMCA_RETURN_GUID Carrying Object
KEY form QISR_TEMPLATE Form
KEY form_number FORM_NUMBER_PS Form Number
case_guid FMCA_FORM_GUID Form GUID
timestamp FORM_TS_PS Last Time Stamp
x_amendment XFELD Checkbox
form_class FORM_CLASS_PS Form Class
form_status FORM_STATUS_PS Form Status
form_status_ts FORM_STATUS_TS_PS Status Time Stamp
superseded_by FMCA_FORM_GUID Form GUID
supersede_to FMCA_FORM_GUID Form GUID
receipt_ts FORM_RECEIPT_TS_PS Receipt Timestamp
template_ver FORM_TMPL_VER_PS Template Version
doguid DOGUID_KK Document ID
batch_id BATCH_ID_KK Lot ID
locator_number LOCATOR_NUMBER_KK Location
dummy_psform_eew_ps CFD_DUMMY Dummy

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.

-- Data Table for Tax Forms
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFMCA_FORMS (
    MANDT,                -- Client [MANDT]
    RETURN_ID,            -- Carrying Object [FMCA_RETURN_GUID]
    FORM,                 -- Form [QISR_TEMPLATE]
    FORM_NUMBER,          -- Form Number [FORM_NUMBER_PS]
    CASE_GUID,            -- Form GUID [FMCA_FORM_GUID]
    TIMESTAMP,            -- Last Time Stamp [FORM_TS_PS]
    X_AMENDMENT,          -- Checkbox [XFELD]
    FORM_CLASS,           -- Form Class [FORM_CLASS_PS]
    FORM_STATUS,          -- Form Status [FORM_STATUS_PS]
    FORM_STATUS_TS,       -- Status Time Stamp [FORM_STATUS_TS_PS]
    SUPERSEDED_BY,        -- Form GUID [FMCA_FORM_GUID]
    SUPERSEDE_TO,         -- Form GUID [FMCA_FORM_GUID]
    RECEIPT_TS,           -- Receipt Timestamp [FORM_RECEIPT_TS_PS]
    TEMPLATE_VER,         -- Template Version [FORM_TMPL_VER_PS]
    DOGUID,               -- Document ID [DOGUID_KK]
    BATCH_ID,             -- Lot ID [BATCH_ID_KK]
    LOCATOR_NUMBER,       -- Location [LOCATOR_NUMBER_KK]
    DUMMY_PSFORM_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, RETURN_ID, FORM, FORM_NUMBER)
);

Learn More