FIKZD_ACCT_RPITM

Transparent Table Application Table
14 Fields 1 CDS Views

Data selection for KZ VAT Return Section 00,01,02

FIKZD_ACCT_RPITM is an SAP database table in S/4HANA. Data selection for KZ VAT Return Section 00,01,02. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_KZ_VATItemLog view from BASIC Read log table for KZ VAT Decl

Fields (14)

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 accountingdocument belnr_d Document Number
KEY accountingdocumentitem buzei Item
KEY version j_3rvatdversion VAT Return Version
KEY sectionnum fikz_vatsectype Form Type
KEY lineitem fikz_vatline VAT Return Line Item
KEY operationcode fikz_vatopertype Operation Code
KEY columnnum j_3rvatdcolumn Column Number
_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 00,01,02
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FIKZD_ACCT_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]
    ACCOUNTINGDOCUMENT,      -- Document Number [belnr_d]
    ACCOUNTINGDOCUMENTITEM,  -- Item [buzei]
    VERSION,                 -- VAT Return Version [j_3rvatdversion]
    SECTIONNUM,              -- Form Type [fikz_vatsectype]
    LINEITEM,                -- VAT Return Line Item [fikz_vatline]
    OPERATIONCODE,           -- Operation Code [fikz_vatopertype]
    COLUMNNUM,               -- Column Number [j_3rvatdcolumn]
    _DATAAGING,              -- Data Aging [data_temperature]
    PRIMARY KEY (MANDT, STATRYRPTGENTITY, STATRYRPTCATEGORY, STATRYRPTRUNID, COMPANYCODE, FISCALYEAR, ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, VERSION, SECTIONNUM, LINEITEM, OPERATIONCODE, COLUMNNUM)
);

Learn More