FICODIAND_EMPSRI

Transparent Table Application Table
12 Fields 1 CDS Views

Employees selected per report run for DIAN

FICODIAND_EMPSRI is an SAP database table in S/4HANA. Employees selected per report run for DIAN. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CO_DIANStRpEmplAggrgdPyrlLg view from BASIC All Empl. Aggrgd Pyrl for CO DIAN

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY client 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 payrollyear gjahr Fiscal Year
KEY co_dianreportformat ficodian_report_format Report Format
KEY co_dianreportitemtype ficodian_concept_code Item Type
KEY co_diantaxnumbertype ficodian_doc_type DIAN Doc. Type
KEY taxnumber1 stcd1 Tax Number 1
KEY creationutcdatetime timestamp Time Stamp
_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.

-- Employees selected per report run for DIAN
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FICODIAND_EMPSRI (
    CLIENT,                 -- 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]
    PAYROLLYEAR,            -- Fiscal Year [gjahr]
    CO_DIANREPORTFORMAT,    -- Report Format [ficodian_report_format]
    CO_DIANREPORTITEMTYPE,  -- Item Type [ficodian_concept_code]
    CO_DIANTAXNUMBERTYPE,   -- DIAN Doc. Type [ficodian_doc_type]
    TAXNUMBER1,             -- Tax Number 1 [stcd1]
    CREATIONUTCDATETIME,    -- Time Stamp [timestamp]
    _DATAAGING,             -- Data Aging [data_temperature]
    PRIMARY KEY (CLIENT, STATRYRPTGENTITY, STATRYRPTCATEGORY, STATRYRPTRUNID, COMPANYCODE, PAYROLLYEAR, CO_DIANREPORTFORMAT, CO_DIANREPORTITEMTYPE, CO_DIANTAXNUMBERTYPE, TAXNUMBER1, CREATIONUTCDATETIME)
);

Learn More