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