ICSRESERVE
Single Claim Reserve
ICSRESERVE is an SAP database table in S/4HANA. Single Claim Reserve. It contains 23 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_InsurClmReserveShadow | view | from | BASIC | Einzelfallreserve Schaden |
Fields (23)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | MANDT | Client | |||
| KEY | active | ICL_ACTIVE | Active/Suspense | |||
| KEY | claim | ICL_CLAIM | Claim Number | |||
| KEY | subcl | ICL_SUBCL | Subclaim | |||
| KEY | restype | ICL_RESTYPE | Reserve Type | |||
| KEY | curr | ICL_RESCURR | Currency | |||
| KEY | changetime | ICL_CHANGEUTC1 | Changed On | |||
| changedby | ICL_CHANGEDBY | Changed By | ||||
| deleted | ICL_RECSTATUS | Status | ||||
| grossres | ICL_RESERVEAM | Exptr f.ResType | ||||
| method | ICL_RESMETHOD | Reserving Meth. | ||||
| xapproved | ICL_RESERVE06 | Approved | ||||
| approvedby | ICL_RESERVEAB | Approved By | ||||
| approvedtime | ICL_RESERVE07 | Approval on | ||||
| changereason | ICL_RESCHREASON | Change Reason | ||||
| postdate | ICL_POSTDATE | Posting Date | ||||
| rsamtperunit | ICL_RSAMTPERUNIT | Amount per Unit | ||||
| rsquantity | ICL_RSQUANTITY | Number | ||||
| rsquanunit | ICL_RSQUANUNIT | Unit | ||||
| rspending | ICL_RSPENDING | Pending Reserve | ||||
| rsreason_rej | ICL_REASONREJ | Rejection Reasn | ||||
| assign_guid | ICL_ASSIGN_GUID | Link UUID | ||||
| restype_mi | ICL_RESTYPE | Reserve Type |
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.
-- Single Claim Reserve
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICSRESERVE (
CLIENT, -- Client [MANDT]
ACTIVE, -- Active/Suspense [ICL_ACTIVE]
CLAIM, -- Claim Number [ICL_CLAIM]
SUBCL, -- Subclaim [ICL_SUBCL]
RESTYPE, -- Reserve Type [ICL_RESTYPE]
CURR, -- Currency [ICL_RESCURR]
CHANGETIME, -- Changed On [ICL_CHANGEUTC1]
CHANGEDBY, -- Changed By [ICL_CHANGEDBY]
DELETED, -- Status [ICL_RECSTATUS]
GROSSRES, -- Exptr f.ResType [ICL_RESERVEAM]
METHOD, -- Reserving Meth. [ICL_RESMETHOD]
XAPPROVED, -- Approved [ICL_RESERVE06]
APPROVEDBY, -- Approved By [ICL_RESERVEAB]
APPROVEDTIME, -- Approval on [ICL_RESERVE07]
CHANGEREASON, -- Change Reason [ICL_RESCHREASON]
POSTDATE, -- Posting Date [ICL_POSTDATE]
RSAMTPERUNIT, -- Amount per Unit [ICL_RSAMTPERUNIT]
RSQUANTITY, -- Number [ICL_RSQUANTITY]
RSQUANUNIT, -- Unit [ICL_RSQUANUNIT]
RSPENDING, -- Pending Reserve [ICL_RSPENDING]
RSREASON_REJ, -- Rejection Reasn [ICL_REASONREJ]
ASSIGN_GUID, -- Link UUID [ICL_ASSIGN_GUID]
RESTYPE_MI, -- Reserve Type [ICL_RESTYPE]
PRIMARY KEY (CLIENT, ACTIVE, CLAIM, SUBCL, RESTYPE, CURR, CHANGETIME)
);
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