ICA_GR_FSIASSGMT

DDL: ICA_GR_FSIASSGMT SQL: ICAGRFSIASSGMT Type: view Package: FIN_ICA_MATCH
8 Fields 2 Data Sources

ICA: FS Item Assignment

ICA_GR_FSIASSGMT is a CDS View that provides data about "ICA: FS Item Assignment" in SAP S/4HANA. It reads from 2 data sources (ICA_FS_ITEM, tf200) and exposes 8 fields with key fields itclg, item, vers. Part of development package FIN_ICA_MATCH.

Data Sources (2)

SourceAliasJoin Type
ICA_FS_ITEM ICA_FS_ITEM from
tf200 tf200 inner

Parameters (4)

NameTypeDefault
P_RYEAR fc_ryear
P_POPER fc_perid
P_RVERS fc_rvers
P_ITCLG fc_itclg

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName ICAGRFSIASSGMT view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
AbapCatalog.preserveKey true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY itclg ICA_FS_ITEM itclg Consolidation COA
KEY item ICA_FS_ITEM item Task ID
KEY vers tf200 rvers Version: Tax rt
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_GR_FSIASSGMT.
-- 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: ICAGRFSIASSGMT
-- Parameters: P_RYEAR : fc_ryear, P_POPER : fc_perid, P_RVERS : fc_rvers, P_ITCLG : fc_itclg

CREATE VIEW ICA_GR_FSIASSGMT AS
SELECT
  ICA_FS_ITEM.itclg AS itclg,
  ICA_FS_ITEM.item AS item,
  tf200.rvers AS vers,
  sa_role,
  sa_cash_flow,
  sa_scope,
  ta_nci,
  ta_planning
FROM ICA_FS_ITEM
INNER JOIN tf200 ON /* join condition not captured in parsed metadata */
;

Learn More