FINS_SL_IMP_IT
Subledger Impairment Item
FINS_SL_IMP_IT is an SAP database table in S/4HANA. Subledger Impairment Item. It contains 30 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CAImpairmentLineItem | view | from | BASIC | FI-CA Impairment Aggregated Line Items |
Fields (30)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| racct | racct | Account Number | ||||
| kunnr | kunnr | Customer | ||||
| partner | bu_partner | Busn. Partner | ||||
| country | land1_gp | Country/Region Key | ||||
| risk_class | ukm_risk_class | Risk Class | ||||
| aging | fins_aging | Aging | ||||
| incrmnt | fins_incrmnt | Increment | ||||
| slalittype | slalittype | SLALineItemType | ||||
| hsl | fins_vhcur12 | Amnt in Comp Cd Crcy | ||||
| ksl | fins_vkcur12 | Amnt in Global Crcy | ||||
| osl | fins_vocur12 | Amount in Currency 1 | ||||
| vsl | fins_vvcur12 | Amount in Currency 2 | ||||
| bsl | fins_vbcur12 | Amount in Currency 3 | ||||
| csl | fins_vccur12 | Amount in Currency 4 | ||||
| dsl | fins_vdcur12 | Amount in Currency 5 | ||||
| esl | fins_vecur12 | Amount in Currency 6 | ||||
| fsl | fins_vfcur12 | Amount in Currency 7 | ||||
| gsl | fins_vgcur12 | Amount in Currency 8 | ||||
| rhcur | fins_currh | CompanyCode Currency | ||||
| rkcur | fins_currk | Global Currency | ||||
| rocur | fins_curr1 | Free Defined Crcy 1 | ||||
| rvcur | fins_curr2 | Free Defined Crcy 2 | ||||
| rbcur | fins_curr3 | Free Defined Crcy 3 | ||||
| rccur | fins_curr4 | Free Defined Crcy 4 | ||||
| rdcur | fins_curr5 | Free Defined Crcy 5 | ||||
| recur | fins_curr6 | Free Defined Crcy 6 | ||||
| rfcur | fins_curr7 | Free Defined Crcy 7 | ||||
| rgcur | fins_curr8 | Free Defined Crcy 8 | ||||
| awsys | awsys | Logical System | ||||
| _dataaging | data_temperature | Data Aging |
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.
-- Subledger Impairment Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINS_SL_IMP_IT (
RACCT, -- Account Number [racct]
KUNNR, -- Customer [kunnr]
PARTNER, -- Busn. Partner [bu_partner]
COUNTRY, -- Country/Region Key [land1_gp]
RISK_CLASS, -- Risk Class [ukm_risk_class]
AGING, -- Aging [fins_aging]
INCRMNT, -- Increment [fins_incrmnt]
SLALITTYPE, -- SLALineItemType [slalittype]
HSL, -- Amnt in Comp Cd Crcy [fins_vhcur12]
KSL, -- Amnt in Global Crcy [fins_vkcur12]
OSL, -- Amount in Currency 1 [fins_vocur12]
VSL, -- Amount in Currency 2 [fins_vvcur12]
BSL, -- Amount in Currency 3 [fins_vbcur12]
CSL, -- Amount in Currency 4 [fins_vccur12]
DSL, -- Amount in Currency 5 [fins_vdcur12]
ESL, -- Amount in Currency 6 [fins_vecur12]
FSL, -- Amount in Currency 7 [fins_vfcur12]
GSL, -- Amount in Currency 8 [fins_vgcur12]
RHCUR, -- CompanyCode Currency [fins_currh]
RKCUR, -- Global Currency [fins_currk]
ROCUR, -- Free Defined Crcy 1 [fins_curr1]
RVCUR, -- Free Defined Crcy 2 [fins_curr2]
RBCUR, -- Free Defined Crcy 3 [fins_curr3]
RCCUR, -- Free Defined Crcy 4 [fins_curr4]
RDCUR, -- Free Defined Crcy 5 [fins_curr5]
RECUR, -- Free Defined Crcy 6 [fins_curr6]
RFCUR, -- Free Defined Crcy 7 [fins_curr7]
RGCUR, -- Free Defined Crcy 8 [fins_curr8]
AWSYS, -- Logical System [awsys]
_DATAAGING -- Data Aging [data_temperature]
);
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