I_CnsldtnFSItemByTimeVersion

DDL: I_CNSLDTNFSITEMBYTIMEVERSION Type: view BASIC
29 Fields 1 Data Sources 5 Associations

Consolidation FS Item by Time Version

I_CnsldtnFSItemByTimeVersion (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

CnsldtnFSItemByTimeVersion · Group Reporting

I_CnsldtnFSItemByTimeVersion is a Basic CDS View that provides data about "Consolidation FS Item by Time Version" in SAP S/4HANA. It reads from 1 data source (P_CnsldtnFSItemByTimeVersion) and exposes 29 fields with key fields ConsolidationChartOfAccounts, CnsldtnFinancialStatementItem, ConsolidationVersion, FromFiscalYearPeriod. It has 5 associations to related views.

SAP API Hub

StateC1
Line of BusinessGroup Reporting
Application ComponentFIN-CS-MD
CapabilitiesAnalytical Dimension, Data Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Data Extraction, Data Source for Defining CDS Entities
PackageGroup Reporting for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view represents the time- and version-dependent attributes of the financial statement (FS) item. The attributes can be used to define selections and validation rules as well as to define targets, such as planning targets.</p> <p>This CDS view can be used for extensibility.</p> This CDS view provides the data to answer the following business questions:<ul> <li><p>What are the FS items characterized by a specific target FS item?</p></li> <li><p>What are the target FS items defined for fiscal years and periods?</p></li> <li><p>What are the target FS items defined by version?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
P_CnsldtnFSItemByTimeVersion _ByTimeVersion from

Associations (5)

CardinalityTargetAliasCondition
[1..1] E_CnsldtnFSItemByTimeVersion _Extension _ByTimeVersion.ConsolidationChartOfAccounts = _Extension.ConsolidationChartOfAccounts and _ByTimeVersion.CnsldtnFinancialStatementItem = _Extension.CnsldtnFinancialStatementItem and _ByTimeVersion.CnsldtnFSItemAttributeVersion = _Extension.CnsldtnFSItemAttributeVersion and _ByTimeVersion.FromFiscalYearPeriod = _Extension.FromFiscalYearPeriod
[0..1] I_CnsldtnFSItem_2 _CnsldtnElimTargetFSItem _CnsldtnElimTargetFSItem.ConsolidationChartOfAccounts = $projection.ConsolidationChartOfAccounts and _CnsldtnElimTargetFSItem.CnsldtnFinancialStatementItem = $projection.CnsldtnEliminationTargetFSItem
[0..1] I_CnsldtnFSItem_2 _CnsldtnNCITargetFSItem _CnsldtnNCITargetFSItem.ConsolidationChartOfAccounts = $projection.ConsolidationChartOfAccounts and _CnsldtnNCITargetFSItem.CnsldtnFinancialStatementItem = $projection.CnsldtnNCITargetFSItem
[0..1] I_CnsldtnFSItem_2 _CnsldtnPlanningTargetFSItem _CnsldtnPlanningTargetFSItem.ConsolidationChartOfAccounts = $projection.ConsolidationChartOfAccounts and _CnsldtnPlanningTargetFSItem.CnsldtnFinancialStatementItem = $projection.CnsldtnPlanningTargetFSItem
[0..1] I_CnsldtnFSItem_2 _CnsldtnOffsettingTargetFSItem _CnsldtnOffsettingTargetFSItem.ConsolidationChartOfAccounts = $projection.ConsolidationChartOfAccounts and _CnsldtnOffsettingTargetFSItem.CnsldtnFinancialStatementItem = $projection.CnsldtnOffsettingTargetFSItem

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName ICSFSITEMATVD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.representativeKey CnsldtnFinancialStatementItem view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
Search.searchable true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Consolidation FS Item by Time Version view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationChartOfAccounts P_CnsldtnFSItemByTimeVersion ConsolidationChartOfAccounts Consolidation Chart of Accounts
KEY CnsldtnFinancialStatementItem P_CnsldtnFSItemByTimeVersion CnsldtnFinancialStatementItem Consolidation Financial Statement Item
KEY ConsolidationVersion P_CnsldtnFSItemByTimeVersion ConsolidationVersion Consolidation Version
KEY FromFiscalYearPeriod P_CnsldtnFSItemByTimeVersion FromFiscalYearPeriod From Fiscal Year Period
ToFiscalYearPeriod P_CnsldtnFSItemByTimeVersion ToFiscalYearPeriod To Fiscal Year Period
CnsldtnFSItemRole P_CnsldtnFSItemByTimeVersion CnsldtnFSItemRole FS Item Role
CnsldtnFSItemDataCollection P_CnsldtnFSItemByTimeVersion CnsldtnFSItemDataCollection Data Collection Selection Attribute
CnsldtnFSItemCrcyTranslation P_CnsldtnFSItemByTimeVersion CnsldtnFSItemCrcyTranslation Currency Translation Selection Attribute
CnsldtnFSItemElimination P_CnsldtnFSItemByTimeVersion CnsldtnFSItemElimination Elimination Selection Attribute
CnsldtnFSItemCashFlow P_CnsldtnFSItemByTimeVersion CnsldtnFSItemCashFlow Cash Flow Selection Attribute
CnsldtnFSItemScope P_CnsldtnFSItemByTimeVersion CnsldtnFSItemScope Scope Selection Attribute
CnsldtnFSItemCustomerSpecific P_CnsldtnFSItemByTimeVersion CnsldtnFSItemCustomerSpecific Other Selection Attribute
CnsldtnEliminationTargetFSItem P_CnsldtnFSItemByTimeVersion CnsldtnEliminationTargetFSItem Elimination Target
CnsldtnNCITargetFSItem P_CnsldtnFSItemByTimeVersion CnsldtnNCITargetFSItem Non-Controlling Interest Target
CnsldtnPlanningTargetFSItem P_CnsldtnFSItemByTimeVersion CnsldtnPlanningTargetFSItem Planning Target
CnsldtnOffsettingTargetFSItem P_CnsldtnFSItemByTimeVersion CnsldtnOffsettingTargetFSItem Offsetting Target
_CnsldtnChartOfAccounts P_CnsldtnFSItemByTimeVersion _CnsldtnChartOfAccounts
_CnsldtnVersion P_CnsldtnFSItemByTimeVersion _CnsldtnVersion
_CnsldtnElimTargetFSItem _CnsldtnElimTargetFSItem
_CnsldtnNCITargetFSItem _CnsldtnNCITargetFSItem
_CnsldtnPlanningTargetFSItem _CnsldtnPlanningTargetFSItem
_CnsldtnOffsettingTargetFSItem _CnsldtnOffsettingTargetFSItem
_CnsldtnFSItemRole P_CnsldtnFSItemByTimeVersion _CnsldtnFSItemRole
_CnsldtnFSItemDataColl P_CnsldtnFSItemByTimeVersion _CnsldtnFSItemDataColl
_CnsldtnFSItemCrcyTrnsltn P_CnsldtnFSItemByTimeVersion _CnsldtnFSItemCrcyTrnsltn
_CnsldtnFSItemElimination P_CnsldtnFSItemByTimeVersion _CnsldtnFSItemElimination
_CnsldtnFSItemCashFlow P_CnsldtnFSItemByTimeVersion _CnsldtnFSItemCashFlow
_CnsldtnFSItemScope P_CnsldtnFSItemByTimeVersion _CnsldtnFSItemScope
_CnsldtnFSItemCustSpcfc P_CnsldtnFSItemByTimeVersion _CnsldtnFSItemCustSpcfc

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_CnsldtnFSItemByTimeVersion.
-- 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.

CREATE VIEW I_CnsldtnFSItemByTimeVersion AS
SELECT
  _ByTimeVersion.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  _ByTimeVersion.CnsldtnFinancialStatementItem AS CnsldtnFinancialStatementItem,
  _ByTimeVersion.ConsolidationVersion AS ConsolidationVersion,
  _ByTimeVersion.FromFiscalYearPeriod AS FromFiscalYearPeriod,
  _ByTimeVersion.ToFiscalYearPeriod AS ToFiscalYearPeriod,
  _ByTimeVersion.CnsldtnFSItemRole AS CnsldtnFSItemRole,
  _ByTimeVersion.CnsldtnFSItemDataCollection AS CnsldtnFSItemDataCollection,
  _ByTimeVersion.CnsldtnFSItemCrcyTranslation AS CnsldtnFSItemCrcyTranslation,
  _ByTimeVersion.CnsldtnFSItemElimination AS CnsldtnFSItemElimination,
  _ByTimeVersion.CnsldtnFSItemCashFlow AS CnsldtnFSItemCashFlow,
  _ByTimeVersion.CnsldtnFSItemScope AS CnsldtnFSItemScope,
  _ByTimeVersion.CnsldtnFSItemCustomerSpecific AS CnsldtnFSItemCustomerSpecific,
  _ByTimeVersion.CnsldtnEliminationTargetFSItem AS CnsldtnEliminationTargetFSItem,
  _ByTimeVersion.CnsldtnNCITargetFSItem AS CnsldtnNCITargetFSItem,
  _ByTimeVersion.CnsldtnPlanningTargetFSItem AS CnsldtnPlanningTargetFSItem,
  _ByTimeVersion.CnsldtnOffsettingTargetFSItem AS CnsldtnOffsettingTargetFSItem,
  _ByTimeVersion._CnsldtnChartOfAccounts AS _CnsldtnChartOfAccounts,
  _ByTimeVersion._CnsldtnVersion AS _CnsldtnVersion,
  _ByTimeVersion._CnsldtnFSItemRole AS _CnsldtnFSItemRole,
  _ByTimeVersion._CnsldtnFSItemDataColl AS _CnsldtnFSItemDataColl,
  _ByTimeVersion._CnsldtnFSItemCrcyTrnsltn AS _CnsldtnFSItemCrcyTrnsltn,
  _ByTimeVersion._CnsldtnFSItemElimination AS _CnsldtnFSItemElimination,
  _ByTimeVersion._CnsldtnFSItemCashFlow AS _CnsldtnFSItemCashFlow,
  _ByTimeVersion._CnsldtnFSItemScope AS _CnsldtnFSItemScope,
  _ByTimeVersion._CnsldtnFSItemCustSpcfc AS _CnsldtnFSItemCustSpcfc
FROM P_CnsldtnFSItemByTimeVersion AS _ByTimeVersion
LEFT OUTER JOIN E_CnsldtnFSItemByTimeVersion AS _Extension ON _ByTimeVersion.ConsolidationChartOfAccounts = _Extension.ConsolidationChartOfAccounts AND _ByTimeVersion.CnsldtnFinancialStatementItem = _Extension.CnsldtnFinancialStatementItem AND _ByTimeVersion.CnsldtnFSItemAttributeVersion = _Extension.CnsldtnFSItemAttributeVersion AND _ByTimeVersion.FromFiscalYearPeriod = _Extension.FromFiscalYearPeriod  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnFSItem_2 AS _CnsldtnElimTargetFSItem ON _CnsldtnElimTargetFSItem.ConsolidationChartOfAccounts = ConsolidationChartOfAccounts AND _CnsldtnElimTargetFSItem.CnsldtnFinancialStatementItem = CnsldtnEliminationTargetFSItem  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFSItem_2 AS _CnsldtnNCITargetFSItem ON _CnsldtnNCITargetFSItem.ConsolidationChartOfAccounts = ConsolidationChartOfAccounts AND _CnsldtnNCITargetFSItem.CnsldtnFinancialStatementItem = CnsldtnNCITargetFSItem  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFSItem_2 AS _CnsldtnPlanningTargetFSItem ON _CnsldtnPlanningTargetFSItem.ConsolidationChartOfAccounts = ConsolidationChartOfAccounts AND _CnsldtnPlanningTargetFSItem.CnsldtnFinancialStatementItem = CnsldtnPlanningTargetFSItem  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFSItem_2 AS _CnsldtnOffsettingTargetFSItem ON _CnsldtnOffsettingTargetFSItem.ConsolidationChartOfAccounts = ConsolidationChartOfAccounts AND _CnsldtnOffsettingTargetFSItem.CnsldtnFinancialStatementItem = CnsldtnOffsettingTargetFSItem  -- association [0..1]
;

Learn More