FICODIAND_HCM

Transparent Table Application Table
22 Fields 1 CDS Views

HCM information for DIAN

FICODIAND_HCM is an SAP database table in S/4HANA. HCM information for DIAN. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CO_DIANEmplAggregatedPyrl view from BASIC Employee Aggregated Payroll for CO DIAN

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY company_code BUKRS Company Code
KEY payroll_fiscal_year GJAHR Fiscal Year
KEY report_format FICODIAN_REPORT_FORMAT Report Format
KEY concept_code FICODIAN_CONCEPT_CODE Item Type
KEY tax_number_type FICODIAN_DOC_TYPE DIAN Doc. Type
KEY tax_number STCD1 Tax Number 1
KEY creation_timestamp TIMESTAMP Time Stamp
bp_name_1 AD_NAME1 Name
bp_name_2 AD_NAME2 Name 2
bp_name_3 AD_NAME3 Name 3
bp_name_4 AD_NAME4 Name 4
country LAND1 Country/Reg.
address AD_STREET Street
city_code AD_CITYNUM City Code
state REGIO Region
base_amount FICODIAN_AMOUNT Amount
base_amount_currency FICODIAN_CURRENCY Currency
calc_amount FICODIAN_AMOUNT Amount
calc_amount_currency FICODIAN_CURRENCY Currency
created_by SYST_UNAME User Name
_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.

-- HCM information for DIAN
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FICODIAND_HCM (
    MANDT,                 -- Client [MANDT]
    COMPANY_CODE,          -- Company Code [BUKRS]
    PAYROLL_FISCAL_YEAR,   -- Fiscal Year [GJAHR]
    REPORT_FORMAT,         -- Report Format [FICODIAN_REPORT_FORMAT]
    CONCEPT_CODE,          -- Item Type [FICODIAN_CONCEPT_CODE]
    TAX_NUMBER_TYPE,       -- DIAN Doc. Type [FICODIAN_DOC_TYPE]
    TAX_NUMBER,            -- Tax Number 1 [STCD1]
    CREATION_TIMESTAMP,    -- Time Stamp [TIMESTAMP]
    BP_NAME_1,             -- Name [AD_NAME1]
    BP_NAME_2,             -- Name 2 [AD_NAME2]
    BP_NAME_3,             -- Name 3 [AD_NAME3]
    BP_NAME_4,             -- Name 4 [AD_NAME4]
    COUNTRY,               -- Country/Reg. [LAND1]
    ADDRESS,               -- Street [AD_STREET]
    CITY_CODE,             -- City Code [AD_CITYNUM]
    STATE,                 -- Region [REGIO]
    BASE_AMOUNT,           -- Amount [FICODIAN_AMOUNT]
    BASE_AMOUNT_CURRENCY,  -- Currency [FICODIAN_CURRENCY]
    CALC_AMOUNT,           -- Amount [FICODIAN_AMOUNT]
    CALC_AMOUNT_CURRENCY,  -- Currency [FICODIAN_CURRENCY]
    CREATED_BY,            -- User Name [SYST_UNAME]
    _DATAAGING,            -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, COMPANY_CODE, PAYROLL_FISCAL_YEAR, REPORT_FORMAT, CONCEPT_CODE, TAX_NUMBER_TYPE, TAX_NUMBER, CREATION_TIMESTAMP)
);

Learn More