ICA_FS_ITEM

DDL: ICA_FS_ITEM SQL: ICAFSITEM Type: view Package: FIN_ICA_MATCH
10 Fields 1 Data Sources

ICA - FS Item Access

ICA_FS_ITEM is a CDS View that provides data about "ICA - FS Item Access" in SAP S/4HANA. It reads from 1 data source (fincs_fsiassgmt) and exposes 10 fields with key fields itclg, item, iatvs, fromyearper. Part of development package FIN_ICA_MATCH.

Data Sources (1)

SourceAliasJoin Type
fincs_fsiassgmt fincs_fsiassgmt from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName ICAFSITEM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY itclg itclg Consolidation COA
KEY item item Task ID
KEY iatvs iatvs FS Item Attributes Version
KEY fromyearper
toyearper toyearper To Fiscal Year Period
sa_role sa_role FS Item Role
sa_cash_flow sa_cash_flow Cash Flow Attribute
sa_scope sa_scope Scope Attribute
ta_nci ta_nci Target Item
ta_planning ta_planning Target Item

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 ICA_FS_ITEM.
-- 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: ICAFSITEM

CREATE VIEW ICA_FS_ITEM AS
SELECT
  itclg,
  item,
  iatvs,
  cast(concat(left(fromyearper,4), replace(right(fromyearper,3), '001', '000')) as fincs_fiscalyearper preserving type ) AS fromyearper,
  toyearper,
  sa_role,
  sa_cash_flow,
  sa_scope,
  ta_nci,
  ta_planning
FROM fincs_fsiassgmt
;

Learn More