ICA_DS

Transparent Table Customizing Table
10 Fields 1 CDS Views

Data Source

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_CnsldtnInterCoRecnclnCase view_entity inner BASIC Cnsldtn intercompany reconciliation case

Fields (10)

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

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]
    PRIMARY KEY (RCLNT, DS_NAME)
);

Learn More