DFMCA_RETURN

Transparent Table Application Table
57 Fields 2 CDS Views

Data Table for Tax Returns

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_PublicSectorFormBundle view from EXTENSION Form Bundle Extension
I_PublicSectorFormBundle view from BASIC Form Bundle

Fields (57)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY case_guid FMCA_RETURN_GUID Carrying Object
fbnum FBNUM_PS FormB. Number
revenue_type ABTYP_PS Revenue Type
taxpayer GPART_KK Bus. Partner
joint_filer GPART_KK Bus. Partner
bu_id_type BU_ID_TYPE ID Type
taxpayer_id BU_ID_NUMBER ID Number
joint_id_type BU_ID_TYPE ID Type
joint_filer_id BU_ID_NUMBER ID Number
account VKONT_KK Contract Acct
reg_id VTREF_KK Contract
reg_type SUBAP_KK Subapplication
joint_account VKONT_KK Contract Acct
joint_reg_id VTREF_KK Contract
joint_reg_type SUBAP_KK Subapplication
apply_from ABRZU_KK Billing Period
apply_to ABRZO_KK Bill Period
period_key PERSL_KK Period Key
begru BEGRU AuthorizGroup
consolidated_by SCMG_CASE_GUID Case Key
duplicate_to SCMG_CASE_GUID Case Key
formproc FORMPROC_PS Form-Based Prcs
x_cons FMCA_CONSOLIDATING_PS Consolidating
x_estimated FB_ESTIMATED_PS Estimated
fbtyp FBTYP_PS Form Bundle Type
betrw AMOUNT_RET_PS Amount
waers CURRENCY_RET_PS Currency
ernam ERNAM Created By
ertsp ERTSP Created At
aenam AENAM Changed By
aetsp AETSP Changed At
keydt KEYDT_PS Key Date for BRF
fbsta FBSTA_PS Status 1
fbstb FBSTB_PS Status 2
fbust FBUST_PS Status
fbstz FBSTZ_PS Completed
validation VALIDATION_PS Validation
postmark POSTMARK_PS Postmark
receipt RECEIPT_PS Receipt
due_date DUE_DATE_PS Due On
deferral_date DEFERRAL_DATE_PS Deferral Date
refund_complete REFUND_COMPLETE_PS Ref. Complete Date
postmark_ext POSTMARK_EXT_PS PstmkExtnsn Dte
reconciliation RECONCILIATION_DATE_PS Checked on
last_filing LAST_FILING_PS Last Filing Date
as_filed_ext AS_FILED_EXT_PS As Filed Extensn
date_sol DATE_SOL_PS Date
batch_id BATCH_ID_KK Lot ID
locator_number LOCATOR_NUMBER_KK Location
transaction_type FMCA_TRANSACTION_TYPE_PS Transaction Type
in_channel INPCH_KK Channel
tax_preparer TAX_PREPARER_PS Tax Adviser
indpr INDPR_PS Indicator
keypp KEYPP_KK Subarea
current_version FMCA_TTF_CURRENT_VERSION Current Form Version
dummy_psformbundle_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 Returns
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFMCA_RETURN (
    MANDT,                      -- Client [MANDT]
    CASE_GUID,                  -- Carrying Object [FMCA_RETURN_GUID]
    FBNUM,                      -- FormB. Number [FBNUM_PS]
    REVENUE_TYPE,               -- Revenue Type [ABTYP_PS]
    TAXPAYER,                   -- Bus. Partner [GPART_KK]
    JOINT_FILER,                -- Bus. Partner [GPART_KK]
    BU_ID_TYPE,                 -- ID Type [BU_ID_TYPE]
    TAXPAYER_ID,                -- ID Number [BU_ID_NUMBER]
    JOINT_ID_TYPE,              -- ID Type [BU_ID_TYPE]
    JOINT_FILER_ID,             -- ID Number [BU_ID_NUMBER]
    ACCOUNT,                    -- Contract Acct [VKONT_KK]
    REG_ID,                     -- Contract [VTREF_KK]
    REG_TYPE,                   -- Subapplication [SUBAP_KK]
    JOINT_ACCOUNT,              -- Contract Acct [VKONT_KK]
    JOINT_REG_ID,               -- Contract [VTREF_KK]
    JOINT_REG_TYPE,             -- Subapplication [SUBAP_KK]
    APPLY_FROM,                 -- Billing Period [ABRZU_KK]
    APPLY_TO,                   -- Bill Period [ABRZO_KK]
    PERIOD_KEY,                 -- Period Key [PERSL_KK]
    BEGRU,                      -- AuthorizGroup [BEGRU]
    CONSOLIDATED_BY,            -- Case Key [SCMG_CASE_GUID]
    DUPLICATE_TO,               -- Case Key [SCMG_CASE_GUID]
    FORMPROC,                   -- Form-Based Prcs [FORMPROC_PS]
    X_CONS,                     -- Consolidating [FMCA_CONSOLIDATING_PS]
    X_ESTIMATED,                -- Estimated [FB_ESTIMATED_PS]
    FBTYP,                      -- Form Bundle Type [FBTYP_PS]
    BETRW,                      -- Amount [AMOUNT_RET_PS]
    WAERS,                      -- Currency [CURRENCY_RET_PS]
    ERNAM,                      -- Created By [ERNAM]
    ERTSP,                      -- Created At [ERTSP]
    AENAM,                      -- Changed By [AENAM]
    AETSP,                      -- Changed At [AETSP]
    KEYDT,                      -- Key Date for BRF [KEYDT_PS]
    FBSTA,                      -- Status 1 [FBSTA_PS]
    FBSTB,                      -- Status 2 [FBSTB_PS]
    FBUST,                      -- Status [FBUST_PS]
    FBSTZ,                      -- Completed [FBSTZ_PS]
    VALIDATION,                 -- Validation [VALIDATION_PS]
    POSTMARK,                   -- Postmark [POSTMARK_PS]
    RECEIPT,                    -- Receipt [RECEIPT_PS]
    DUE_DATE,                   -- Due On [DUE_DATE_PS]
    DEFERRAL_DATE,              -- Deferral Date [DEFERRAL_DATE_PS]
    REFUND_COMPLETE,            -- Ref. Complete Date [REFUND_COMPLETE_PS]
    POSTMARK_EXT,               -- PstmkExtnsn Dte [POSTMARK_EXT_PS]
    RECONCILIATION,             -- Checked on [RECONCILIATION_DATE_PS]
    LAST_FILING,                -- Last Filing Date [LAST_FILING_PS]
    AS_FILED_EXT,               -- As Filed Extensn [AS_FILED_EXT_PS]
    DATE_SOL,                   -- Date [DATE_SOL_PS]
    BATCH_ID,                   -- Lot ID [BATCH_ID_KK]
    LOCATOR_NUMBER,             -- Location [LOCATOR_NUMBER_KK]
    TRANSACTION_TYPE,           -- Transaction Type [FMCA_TRANSACTION_TYPE_PS]
    IN_CHANNEL,                 -- Channel [INPCH_KK]
    TAX_PREPARER,               -- Tax Adviser [TAX_PREPARER_PS]
    INDPR,                      -- Indicator [INDPR_PS]
    KEYPP,                      -- Subarea [KEYPP_KK]
    CURRENT_VERSION,            -- Current Form Version [FMCA_TTF_CURRENT_VERSION]
    DUMMY_PSFORMBUNDLE_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, CASE_GUID)
);

Learn More