R_CnsldtnFSItemByTimeVersionTP

DDL: R_CNSLDTNFSITEMBYTIMEVERSIONTP Type: view_entity TRANSACTIONAL
30 Fields 2 Data Sources 1 Associations

Cnsldtn FS Item by Time and Version - TP

R_CnsldtnFSItemByTimeVersionTP is a Transactional CDS View that provides data about "Cnsldtn FS Item by Time and Version - TP" in SAP S/4HANA. It reads from 2 data sources (I_CnsldtnFSItemByTimeVersion, I_CnsldtnVersion) and exposes 30 fields with key fields ConsolidationChartOfAccounts, CnsldtnFinancialStatementItem, ConsolidationVersion, FromFiscalYearPeriod. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_CnsldtnFSItemByTimeVersion _Source from
I_CnsldtnVersion _Version inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_CnsldtnFSItemByTimeVersion _Extension $projection.ConsolidationChartOfAccounts = _Extension.ConsolidationChartOfAccounts and $projection.CnsldtnFinancialStatementItem = _Extension.CnsldtnFinancialStatementItem and _Version.ConsolidationVersion = _Extension.CnsldtnFSItemAttributeVersion and $projection.FromFiscalYearPeriod = _Extension.FromFiscalYearPeriod

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
EndUserText.label Cnsldtn FS Item by Time and Version - TP view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationChartOfAccounts I_CnsldtnFSItemByTimeVersion ConsolidationChartOfAccounts Cons. COA
KEY CnsldtnFinancialStatementItem I_CnsldtnFSItemByTimeVersion CnsldtnFinancialStatementItem
KEY ConsolidationVersion I_CnsldtnFSItemByTimeVersion ConsolidationVersion Version
KEY FromFiscalYearPeriod I_CnsldtnFSItemByTimeVersion FromFiscalYearPeriod
ToFiscalYearPeriod I_CnsldtnFSItemByTimeVersion ToFiscalYearPeriod
CnsldtnFSItemRole I_CnsldtnFSItemByTimeVersion CnsldtnFSItemRole
CnsldtnFSItemDataCollection I_CnsldtnFSItemByTimeVersion CnsldtnFSItemDataCollection
CnsldtnFSItemCrcyTranslation I_CnsldtnFSItemByTimeVersion CnsldtnFSItemCrcyTranslation
CnsldtnFSItemElimination I_CnsldtnFSItemByTimeVersion CnsldtnFSItemElimination
CnsldtnFSItemCashFlow I_CnsldtnFSItemByTimeVersion CnsldtnFSItemCashFlow
CnsldtnFSItemScope I_CnsldtnFSItemByTimeVersion CnsldtnFSItemScope
CnsldtnFSItemCustomerSpecific I_CnsldtnFSItemByTimeVersion CnsldtnFSItemCustomerSpecific
CnsldtnEliminationTargetFSItem I_CnsldtnFSItemByTimeVersion CnsldtnEliminationTargetFSItem
CnsldtnNCITargetFSItem I_CnsldtnFSItemByTimeVersion CnsldtnNCITargetFSItem
CnsldtnPlanningTargetFSItem I_CnsldtnFSItemByTimeVersion CnsldtnPlanningTargetFSItem
CnsldtnOffsettingTargetFSItem I_CnsldtnFSItemByTimeVersion CnsldtnOffsettingTargetFSItem
ETag _CnsldtnFSItem ETag Update Token
_CnsldtnVersion I_CnsldtnFSItemByTimeVersion _CnsldtnVersion
_CnsldtnFSItemCashFlow I_CnsldtnFSItemByTimeVersion _CnsldtnFSItemCashFlow
_CnsldtnFSItemCrcyTrnsltn I_CnsldtnFSItemByTimeVersion _CnsldtnFSItemCrcyTrnsltn
_CnsldtnFSItemCustSpcfc I_CnsldtnFSItemByTimeVersion _CnsldtnFSItemCustSpcfc
_CnsldtnFSItemDataColl I_CnsldtnFSItemByTimeVersion _CnsldtnFSItemDataColl
_CnsldtnFSItemElimination I_CnsldtnFSItemByTimeVersion _CnsldtnFSItemElimination
_CnsldtnFSItemRole I_CnsldtnFSItemByTimeVersion _CnsldtnFSItemRole
_CnsldtnFSItemScope I_CnsldtnFSItemByTimeVersion _CnsldtnFSItemScope
_CnsldtnElimTargetFSItem I_CnsldtnFSItemByTimeVersion _CnsldtnElimTargetFSItem
_CnsldtnNCITargetFSItem I_CnsldtnFSItemByTimeVersion _CnsldtnNCITargetFSItem
_CnsldtnOffsettingTargetFSItem I_CnsldtnFSItemByTimeVersion _CnsldtnOffsettingTargetFSItem
_CnsldtnPlanningTargetFSItem I_CnsldtnFSItemByTimeVersion _CnsldtnPlanningTargetFSItem
_CnsldtnFSItem _CnsldtnFSItem

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 R_CnsldtnFSItemByTimeVersionTP.
-- 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 R_CnsldtnFSItemByTimeVersionTP AS
SELECT
  _Source.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  _Source.CnsldtnFinancialStatementItem AS CnsldtnFinancialStatementItem,
  _Source.ConsolidationVersion AS ConsolidationVersion,
  _Source.FromFiscalYearPeriod AS FromFiscalYearPeriod,
  _Source.ToFiscalYearPeriod AS ToFiscalYearPeriod,
  _Source.CnsldtnFSItemRole AS CnsldtnFSItemRole,
  _Source.CnsldtnFSItemDataCollection AS CnsldtnFSItemDataCollection,
  _Source.CnsldtnFSItemCrcyTranslation AS CnsldtnFSItemCrcyTranslation,
  _Source.CnsldtnFSItemElimination AS CnsldtnFSItemElimination,
  _Source.CnsldtnFSItemCashFlow AS CnsldtnFSItemCashFlow,
  _Source.CnsldtnFSItemScope AS CnsldtnFSItemScope,
  _Source.CnsldtnFSItemCustomerSpecific AS CnsldtnFSItemCustomerSpecific,
  _Source.CnsldtnEliminationTargetFSItem AS CnsldtnEliminationTargetFSItem,
  _Source.CnsldtnNCITargetFSItem AS CnsldtnNCITargetFSItem,
  _Source.CnsldtnPlanningTargetFSItem AS CnsldtnPlanningTargetFSItem,
  _Source.CnsldtnOffsettingTargetFSItem AS CnsldtnOffsettingTargetFSItem,
  _CnsldtnFSItem.ETag AS ETag,
  _Source._CnsldtnVersion AS _CnsldtnVersion,
  _Source._CnsldtnFSItemCashFlow AS _CnsldtnFSItemCashFlow,
  _Source._CnsldtnFSItemCrcyTrnsltn AS _CnsldtnFSItemCrcyTrnsltn,
  _Source._CnsldtnFSItemCustSpcfc AS _CnsldtnFSItemCustSpcfc,
  _Source._CnsldtnFSItemDataColl AS _CnsldtnFSItemDataColl,
  _Source._CnsldtnFSItemElimination AS _CnsldtnFSItemElimination,
  _Source._CnsldtnFSItemRole AS _CnsldtnFSItemRole,
  _Source._CnsldtnFSItemScope AS _CnsldtnFSItemScope,
  _Source._CnsldtnElimTargetFSItem AS _CnsldtnElimTargetFSItem,
  _Source._CnsldtnNCITargetFSItem AS _CnsldtnNCITargetFSItem,
  _Source._CnsldtnOffsettingTargetFSItem AS _CnsldtnOffsettingTargetFSItem,
  _Source._CnsldtnPlanningTargetFSItem AS _CnsldtnPlanningTargetFSItem
FROM I_CnsldtnFSItemByTimeVersion AS _Source
INNER JOIN I_CnsldtnVersion AS _Version ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_CnsldtnFSItemByTimeVersion AS _Extension ON ConsolidationChartOfAccounts = _Extension.ConsolidationChartOfAccounts AND CnsldtnFinancialStatementItem = _Extension.CnsldtnFinancialStatementItem AND _Version.ConsolidationVersion = _Extension.CnsldtnFSItemAttributeVersion AND FromFiscalYearPeriod = _Extension.FromFiscalYearPeriod  -- association [1..1]
;

Learn More