FIKZD_CDEC_RPITM

Transparent Table Application Table
11 Fields 1 CDS Views

Data selection for KZ VAT Return Section 03

FIKZD_CDEC_RPITM is an SAP database table in S/4HANA. Data selection for KZ VAT Return Section 03. It contains 11 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_KZ_VATCstmDeclnItemLog view from BASIC Read log table for KZ VAT Custom Decl

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY statryrptgentity srf_reporting_entity Reporting Entity
KEY statryrptcategory srf_rep_cat_id Report ID
KEY statryrptrunid srf_report_run_id Report Run ID
KEY companycode bukrs Company Code
KEY fiscalyear gjahr Fiscal Year
KEY fiscalperiod j_3rf_quarters Quarters
KEY cdec_num fikz_cdec_num CDec External Number
KEY sectionnum j_3rvatdsection VAT Return Section
KEY lineitem fikz_vatline VAT Return Line Item
_dataaging data_temperature Data Aging

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 selection for KZ VAT Return Section 03
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FIKZD_CDEC_RPITM (
    MANDT,              -- Client [mandt]
    STATRYRPTGENTITY,   -- Reporting Entity [srf_reporting_entity]
    STATRYRPTCATEGORY,  -- Report ID [srf_rep_cat_id]
    STATRYRPTRUNID,     -- Report Run ID [srf_report_run_id]
    COMPANYCODE,        -- Company Code [bukrs]
    FISCALYEAR,         -- Fiscal Year [gjahr]
    FISCALPERIOD,       -- Quarters [j_3rf_quarters]
    CDEC_NUM,           -- CDec External Number [fikz_cdec_num]
    SECTIONNUM,         -- VAT Return Section [j_3rvatdsection]
    LINEITEM,           -- VAT Return Line Item [fikz_vatline]
    _DATAAGING,         -- Data Aging [data_temperature]
    PRIMARY KEY (MANDT, STATRYRPTGENTITY, STATRYRPTCATEGORY, STATRYRPTRUNID, COMPANYCODE, FISCALYEAR, FISCALPERIOD, CDEC_NUM, SECTIONNUM, LINEITEM)
);

Learn More