R_CnsldtnBalVaPerdAssgmtTP

DDL: R_CNSLDTNBALVAPERDASSGMTTP Type: view_entity TRANSACTIONAL Package: FIN_CS_BALVAL_RULEGRP_ASGMT
9 Fields 1 Data Sources 2 Associations

Fiscal Period Assignment

R_CnsldtnBalVaPerdAssgmtTP is a Transactional CDS View that provides data about "Fiscal Period Assignment" in SAP S/4HANA. It reads from 1 data source (I_CnsldtnBalVaPerdAssgmt) and exposes 9 fields with key fields ConsolidationVersion, ConsolidationTask, ConsolidationDataEntryVersion, FromFiscalYearPeriod, CnsldtnBalVaRlGrpAssgmtItmUUID. It has 2 associations to related views. Part of development package FIN_CS_BALVAL_RULEGRP_ASGMT.

Data Sources (1)

SourceAliasJoin Type
I_CnsldtnBalVaPerdAssgmt I_CnsldtnBalVaPerdAssgmt from

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_CnsldtnVersion _Version $projection.ConsolidationDataEntryVersion = _Version.ConsolidationDataEntryVersion
[0..1] I_CnsldtnFsclPerdForVersionVH _FiscalPeriodVH $projection.consolidationversion = _FiscalPeriodVH.ConsolidationVersion and $projection.FiscalPeriod = _FiscalPeriodVH.FiscalPeriod

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name CnsldtnBalValdtnPeriodAssgmt view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
EndUserText.label Fiscal Period Assignment view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationVersion _Version ConsolidationVersion Version
KEY ConsolidationTask ConsolidationTask Task
KEY ConsolidationDataEntryVersion ConsolidationDataEntryVersion Version
KEY FromFiscalYearPeriod FromFiscalYearPeriod Valid-From Date
KEY CnsldtnBalVaRlGrpAssgmtItmUUID CnsldtnBalVaRlGrpAssgmtItmUUID
KEY FiscalPeriod FiscalPeriod Tax period
ChangedDateTime ChangedDateTime Time Stamp
_FiscalPeriodVH _FiscalPeriodVH
_Assignment _Assignment

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_CnsldtnBalVaPerdAssgmtTP.
-- 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_CnsldtnBalVaPerdAssgmtTP AS
SELECT
  _Version.ConsolidationVersion AS ConsolidationVersion,
  ConsolidationTask,
  ConsolidationDataEntryVersion,
  FromFiscalYearPeriod,
  CnsldtnBalVaRlGrpAssgmtItmUUID,
  FiscalPeriod,
  ChangedDateTime
FROM I_CnsldtnBalVaPerdAssgmt
LEFT OUTER JOIN I_CnsldtnVersion AS _Version ON ConsolidationDataEntryVersion = _Version.ConsolidationDataEntryVersion  -- association [1..*]
LEFT OUTER JOIN I_CnsldtnFsclPerdForVersionVH AS _FiscalPeriodVH ON consolidationversion = _FiscalPeriodVH.ConsolidationVersion AND FiscalPeriod = _FiscalPeriodVH.FiscalPeriod  -- association [0..1]
;

Learn More