ICA_RECON_CS
Reconciliation Close
ICA_RECON_CS is an SAP database table in S/4HANA. Reconciliation Close. It contains 32 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_RecnclnCloseReqForAcctg | view | inner | BASIC | Reconciliation Close Request for Accounting |
| I_RecnclnCloseReqForCnsldtn | view | inner | BASIC | Reconciliation Close Request for Consolidation Unit |
Fields (32)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | rclnt | MANDT | Client | |||
| KEY | close_uuid | ICA_RECON_CLOSE_UUID | Recon. Close UUID | |||
| recon_case_id | ICA_RECON_CASE_ID | Reconciliation Case | ||||
| period_status | ICA_RECON_PERIOD_STATUS | Reconciliation Period Close Status | ||||
| periv | PERIV | FY Variant | ||||
| ryear | RYEAR | Fiscal Year | ||||
| poper | POPER | Posting Period | ||||
| fiscyearper | JAHRPER | Period/Year | ||||
| rldnr | RLDNR | Ledger | ||||
| rvers | FC_RVERS | Version | ||||
| ritclg | FC_ITCLG | Cons. COA | ||||
| rbukrs | BUKRS | Company Code | ||||
| rcomp | RCOMP_D | Company | ||||
| rcntr | KOSTL | Cost Center | ||||
| prctr | PRCTR | Profit Center | ||||
| rfarea | FKBER | Functional Area | ||||
| rbusa | GSBER | Business Area | ||||
| kokrs | KOKRS | CO Area | ||||
| segment | FB_SEGMENT | Segment | ||||
| rbunit | FC_BUNIT | Cons. Unit | ||||
| pbukrs | PBUKRS | Partner CoCode | ||||
| rassc | RASSC | Trading Partner | ||||
| scntr | SKOST | Sender Cost Ctr | ||||
| pprctr | PPRCTR | Partner PC | ||||
| sfarea | SFKBER | Partner FArea | ||||
| sbusa | PARGB | Trdg Part.BA | ||||
| psegment | FB_PSEGMENT | Partner Segment | ||||
| rbuptr | FC_BUPTR | Partner 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.
-- Reconciliation Close
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICA_RECON_CS (
RCLNT, -- Client [MANDT]
CLOSE_UUID, -- Recon. Close UUID [ICA_RECON_CLOSE_UUID]
RECON_CASE_ID, -- Reconciliation Case [ICA_RECON_CASE_ID]
PERIOD_STATUS, -- Reconciliation Period Close Status [ICA_RECON_PERIOD_STATUS]
PERIV, -- FY Variant [PERIV]
RYEAR, -- Fiscal Year [RYEAR]
POPER, -- Posting Period [POPER]
FISCYEARPER, -- Period/Year [JAHRPER]
RLDNR, -- Ledger [RLDNR]
RVERS, -- Version [FC_RVERS]
RITCLG, -- Cons. COA [FC_ITCLG]
RBUKRS, -- Company Code [BUKRS]
RCOMP, -- Company [RCOMP_D]
RCNTR, -- Cost Center [KOSTL]
PRCTR, -- Profit Center [PRCTR]
RFAREA, -- Functional Area [FKBER]
RBUSA, -- Business Area [GSBER]
KOKRS, -- CO Area [KOKRS]
SEGMENT, -- Segment [FB_SEGMENT]
RBUNIT, -- Cons. Unit [FC_BUNIT]
PBUKRS, -- Partner CoCode [PBUKRS]
RASSC, -- Trading Partner [RASSC]
SCNTR, -- Sender Cost Ctr [SKOST]
PPRCTR, -- Partner PC [PPRCTR]
SFAREA, -- Partner FArea [SFKBER]
SBUSA, -- Trdg Part.BA [PARGB]
PSEGMENT, -- Partner Segment [FB_PSEGMENT]
RBUPTR, -- Partner Unit [FC_BUPTR]
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, CLOSE_UUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA