I_CnsldtnUnitByTimeVersionTP

DDL: I_CNSLDTNUNITBYTIMEVERSIONTP Type: view_entity TRANSACTIONAL
17 Fields 1 Data Sources

Cnsldtn Unit by Time and Version - TP

I_CnsldtnUnitByTimeVersionTP is a Transactional CDS View that provides data about "Cnsldtn Unit by Time and Version - TP" in SAP S/4HANA. It reads from 1 data source (R_CnsldtnUnitByTimeVersionTP) and exposes 17 fields with key fields ConsolidationUnit, ConsolidationVersion, FromFiscalYearPeriod.

Data Sources (1)

SourceAliasJoin Type
R_CnsldtnUnitByTimeVersionTP R_CnsldtnUnitByTimeVersionTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view
Search.searchable true view
EndUserText.label Cnsldtn Unit by Time and Version - TP view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationUnit
KEY ConsolidationVersion
KEY FromFiscalYearPeriod _Source FromFiscalYearPeriod
ToFiscalYearPeriod _Source ToFiscalYearPeriod
ConsolidationUnitIsPartnerOnly
CnsldtnCrcyTranslationMethod _Source CnsldtnCrcyTranslationMethod
CnsldtnTaxRate
FiscalYearVariant _Source FiscalYearVariant FY Variant
CnsldtnUnivJournalIntegType
CnsldtnGroupCrcyIsLeadingCrcy
CnsldtnUnitLocalCrcySource
CnsldtnUnitGroupCrcySource
CnsldtnUploadMethod _Source CnsldtnUploadMethod
CnsldtnUnitDataCollection _Source CnsldtnUnitDataCollection
ConsolidationUnitPartner _Source ConsolidationUnitPartner
ConsolidationUnitPostingRule _Source ConsolidationUnitPostingRule
ConsolidationUnitValidation _Source ConsolidationUnitValidation

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_CnsldtnUnitByTimeVersionTP.
-- 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_CnsldtnUnitByTimeVersionTP AS
SELECT
  cast ( _Source.ConsolidationUnit as fincs_consolidationunit preserving type ) AS ConsolidationUnit,
  cast ( _Source.ConsolidationVersion as fincs_consolidationversion preserving type ) AS ConsolidationVersion,
  _Source.FromFiscalYearPeriod AS FromFiscalYearPeriod,
  _Source.ToFiscalYearPeriod AS ToFiscalYearPeriod,
  cast ( _Source.ConsolidationUnitIsPartnerOnly as fincs_unitispartneronly preserving type ) AS ConsolidationUnitIsPartnerOnly,
  _Source.CnsldtnCrcyTranslationMethod AS CnsldtnCrcyTranslationMethod,
  cast ( _Source.TaxRate as fincs_taxrate preserving type ) AS CnsldtnTaxRate,
  _Source.FiscalYearVariant AS FiscalYearVariant,
  cast ( _Source.CnsldtnDataTransferMethod as fincs_univjournalintegtype preserving type ) AS CnsldtnUnivJournalIntegType,
  cast ( _Source.DocumentEntryIsInGroupCurrency as fincs_groupcrcyisleadingcrcy preserving type ) AS CnsldtnGroupCrcyIsLeadingCrcy,
  cast ( _Source.CnsldtnUnitLocalCrcySource as fincs_unitlocalcrcysource preserving type ) AS CnsldtnUnitLocalCrcySource,
  cast ( _Source.CnsldtnUnitGroupCrcySource as fincs_unitgroupcrcysource preserving type ) AS CnsldtnUnitGroupCrcySource,
  _Source.CnsldtnUploadMethod AS CnsldtnUploadMethod,
  _Source.CnsldtnUnitDataCollection AS CnsldtnUnitDataCollection,
  _Source.ConsolidationUnitPartner AS ConsolidationUnitPartner,
  _Source.ConsolidationUnitPostingRule AS ConsolidationUnitPostingRule,
  _Source.ConsolidationUnitValidation AS ConsolidationUnitValidation
FROM R_CnsldtnUnitByTimeVersionTP
;

Learn More