ICA_DS

Transparent Table Customizing Table
14 Fields 1 CDS Views

Data Source

ICA_DS is an SAP database table in S/4HANA. Data Source. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_CnsldtnInterCoRecnclnCase view_entity inner BASIC

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY rclnt MANDT Client
KEY ds_name ICA_DS_NAME Data Source
cds_name ICA_CDS_NAME Main CDS View
lunit_field ICA_LUNIT_FIELD Leading Unit Field
lunit_c_field ICA_LUNIT_C_FIELD Leading Unit Superordinate Field
punit_field ICA_PUNIT_FIELD Partner Unit Field
punit_c_field ICA_PUNIT_C_FIELD Partner Unit Superordinate Field
periv PERIV FY Variant
lunit_entity_cds ICA_UNIT_CDS Unit Entity CDS View
lunit_ao ICA_LUNIT_AO Authorization Object of Unit
createdby ICA_CREATOR Created By
createdat ICA_TIMESTAMP_C Created On
changedby ICA_MODIFIER Changed By
changedat ICA_TIMESTAMP_M Changed On

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 Source
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICA_DS (
    RCLNT,             -- Client [MANDT]
    DS_NAME,           -- Data Source [ICA_DS_NAME]
    CDS_NAME,          -- Main CDS View [ICA_CDS_NAME]
    LUNIT_FIELD,       -- Leading Unit Field [ICA_LUNIT_FIELD]
    LUNIT_C_FIELD,     -- Leading Unit Superordinate Field [ICA_LUNIT_C_FIELD]
    PUNIT_FIELD,       -- Partner Unit Field [ICA_PUNIT_FIELD]
    PUNIT_C_FIELD,     -- Partner Unit Superordinate Field [ICA_PUNIT_C_FIELD]
    PERIV,             -- FY Variant [PERIV]
    LUNIT_ENTITY_CDS,  -- Unit Entity CDS View [ICA_UNIT_CDS]
    LUNIT_AO,          -- Authorization Object of Unit [ICA_LUNIT_AO]
    CREATEDBY,         -- Created By [ICA_CREATOR]
    CREATEDAT,         -- Created On [ICA_TIMESTAMP_C]
    CHANGEDBY,         -- Changed By [ICA_MODIFIER]
    CHANGEDAT,         -- Changed On [ICA_TIMESTAMP_M]
    PRIMARY KEY (RCLNT, DS_NAME)
);

Learn More