FINS_IC_SPL_LD

DDL: FINS_IC_SPL_LD SQL: FINSV_IC_SPL_LD Type: view Package: FINS_FI_IC

IC: Split line items with ledger

FINS_IC_SPL_LD is a CDS View that provides data about "IC: Split line items with ledger" in SAP S/4HANA. It reads from 1 data source (acdoca) and exposes 12 fields with key fields mandt, rldnr, bukrs, gjahr, belnr. Part of development package FINS_FI_IC.

Data Sources (1)

SourceAliasJoin Type
acdoca a inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FINSV_IC_SPL_LD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
AbapCatalog.preserveKey true view
EndUserText.label IC: Split line items with ledger view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY mandt s mandt Editing Client
KEY rldnr acdoca rldnr Ledger (Compat.)
KEY bukrs s bukrs Value
KEY gjahr s gjahr Settlement Year
KEY belnr s belnr SD Document
KEY buzei s buzei Posting View Item
KEY spl_no s spl_no Sequence Number
KEY curtp s curtp Valuation Area
waers s waers Transaction Currency
wrbtr s wrbtr Gross Amount
currtyp s currtyp Currency Type
_dataaging s _dataaging Data Aging

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view FINS_IC_SPL_LD.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: FINSV_IC_SPL_LD

CREATE VIEW FINS_IC_SPL_LD AS
SELECT
  s.mandt AS mandt,
  a.rldnr AS rldnr,
  s.bukrs AS bukrs,
  s.gjahr AS gjahr,
  s.belnr AS belnr,
  s.buzei AS buzei,
  s.spl_no AS spl_no,
  s.curtp AS curtp,
  s.waers AS waers,
  s.wrbtr AS wrbtr,
  s.currtyp AS currtyp,
  s._dataaging AS _dataaging
INNER JOIN acdoca AS a ON /* join condition not captured in parsed metadata */
;