I_CN_CADEFinStatementLeafItem

DDL: I_CN_CADEFINSTATEMENTLEAFITEM SQL: ICADEFSLEAFITM Type: view BASIC Package: GLO_FIN_CADE_CN
18 Fields 2 Data Sources 1 Associations

FS Leaf Item for CADE

I_CN_CADEFinStatementLeafItem is a Basic CDS View that provides data about "FS Leaf Item for CADE" in SAP S/4HANA. It reads from 2 data sources (fagl_011fc, fagl_011zc) and exposes 18 fields with key fields FinancialStatementVariant, FinancialStatementItem, ChartOfAccounts, LowerBoundaryAccount, LowerBoundaryFunctionalArea. It has 1 association to related views. Part of development package GLO_FIN_CADE_CN.

Data Sources (2)

SourceAliasJoin Type
fagl_011fc fagl_011fc union_all
fagl_011zc fagl_011zc from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_FinancialStatementItem _FinancialStatementItem $projection.FinancialStatementVariant = _FinancialStatementItem.FinancialStatementVariant and $projection.FinancialStatementItem = _FinancialStatementItem.FinancialStatementItem

Annotations (11)

NameValueLevelField
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName ICADEFSLEAFITM view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
EndUserText.label FS Leaf Item for CADE view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY FinancialStatementVariant versn Version
KEY FinancialStatementItem ergsl FS Item
KEY ChartOfAccounts ktopl G/L Chart of Accounts
KEY LowerBoundaryAccount vonkt Account From
KEY LowerBoundaryFunctionalArea Func. Area From
UpperBoundaryAccount biskt Account To
UpperBoundaryFunctionalArea Functl. Area To
IsDebitBalanceRelevant xsoll Debit Balance
IsCreditBalanceRelevant xhabn Credit Balance
KEY FinancialStatementItem ergsl FS Item
KEY ChartOfAccounts G/L Chart of Accounts
KEY LowerBoundaryAccount Account From
KEY LowerBoundaryFunctionalArea vonfb Func. Area From
UpperBoundaryAccount Account To
UpperBoundaryFunctionalArea bisfb Functl. Area To
IsDebitBalanceRelevant Debit Balance
IsCreditBalanceRelevant Credit Balance
_FinancialStatementItem _FinancialStatementItem

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 I_CN_CADEFinStatementLeafItem.
-- 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: ICADEFSLEAFITM

CREATE VIEW I_CN_CADEFinStatementLeafItem AS
SELECT
  versn AS FinancialStatementVariant,
  ergsl AS FinancialStatementItem,
  ktopl AS ChartOfAccounts,
  vonkt AS LowerBoundaryAccount,
  cast('' as abap.char( 16 )) AS LowerBoundaryFunctionalArea,
  biskt AS UpperBoundaryAccount,
  cast('' as abap.char( 16 )) AS UpperBoundaryFunctionalArea,
  xsoll AS IsDebitBalanceRelevant,
  xhabn AS IsCreditBalanceRelevant
FROM fagl_011zc
LEFT OUTER JOIN I_FinancialStatementItem AS _FinancialStatementItem ON FinancialStatementVariant = _FinancialStatementItem.FinancialStatementVariant AND FinancialStatementItem = _FinancialStatementItem.FinancialStatementItem  -- association [0..1]
-- UNION ALL with additional select branch(es): fagl_011fc
;

Learn More