ICA_RECON_CASE

Transparent Table Customizing Table
13 Fields 2 CDS Views

Reconciliation Case

ICA_RECON_CASE is an SAP database table in S/4HANA. Reconciliation Case. It contains 13 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ReconciliationCase view from BASIC Reconciliation Case Master Data
P_CnsldtnInterCoRecnclnCase view_entity from BASIC Cnsldtn intercompany reconciliation case

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY rclnt mandt Client
KEY recon_case_id ica_recon_case_id Reconciliation Case
method_id ica_method_id Matching Method
hier_id hryid Hierarchy ID
c_hier_id ica_lunit_c_hryid Hierarchy of Superordinate Unit
same_fyv ica_same_fyv Same Fiscal Year Variant
ad_hoc ica_ad_hoc Is Master Data
logsys logsys Logical system
hide_col_amt1 ica_hide_col_amt1 Hide - Up to Now (YTD)
hide_col_amt2 ica_hide_col_amt2 Hide - Up to Last Matching (YTD)
hide_col_amt3 ica_hide_col_amt3 Hide - Up to Now (Period)
hide_col_amt4 ica_hide_col_amt4 Hide - Up to Last Matching (Period)
orig_langu ica_origin_language Original Lanugage

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.

-- Reconciliation Case
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICA_RECON_CASE (
    RCLNT,          -- Client [mandt]
    RECON_CASE_ID,  -- Reconciliation Case [ica_recon_case_id]
    METHOD_ID,      -- Matching Method [ica_method_id]
    HIER_ID,        -- Hierarchy ID [hryid]
    C_HIER_ID,      -- Hierarchy of Superordinate Unit [ica_lunit_c_hryid]
    SAME_FYV,       -- Same Fiscal Year Variant [ica_same_fyv]
    AD_HOC,         -- Is Master Data [ica_ad_hoc]
    LOGSYS,         -- Logical system [logsys]
    HIDE_COL_AMT1,  -- Hide - Up to Now (YTD) [ica_hide_col_amt1]
    HIDE_COL_AMT2,  -- Hide - Up to Last Matching (YTD) [ica_hide_col_amt2]
    HIDE_COL_AMT3,  -- Hide - Up to Now (Period) [ica_hide_col_amt3]
    HIDE_COL_AMT4,  -- Hide - Up to Last Matching (Period) [ica_hide_col_amt4]
    ORIG_LANGU,     -- Original Lanugage [ica_origin_language]
    PRIMARY KEY (RCLNT, RECON_CASE_ID)
);

Learn More