ICA_RECON_CASE

Transparent Table Customizing Table
17 Fields 2 CDS Views

Reconciliation Case

ICA_RECON_CASE is an SAP database table in S/4HANA. Reconciliation Case. It contains 17 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

Fields (17)

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
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.

-- 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]
    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, RECON_CASE_ID)
);

Learn More