I_CnsldtnDocumentType

DDL: I_CNSLDTNDOCUMENTTYPE Type: view BASIC
9 Fields 1 Data Sources 4 Associations

Consolidation Document Type

I_CnsldtnDocumentType (Basic)

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

Group Reporting

I_CnsldtnDocumentType is a Basic CDS View (Dimension) that provides data about "Consolidation Document Type" in SAP S/4HANA. It reads from 1 data source (tf500) and exposes 9 fields with key fields ConsolidationDimension, ConsolidationDocumentType. It has 4 associations to related views.

SAP API Hub

StateC1
Line of BusinessGroup Reporting
Application ComponentFIN-CS-MD
CapabilitiesData Source for Defining CDS Entities, Association Target for Defining CDS Entities, Data Source in SQL Select, Analytical Dimension
PackageGroup Reporting for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view differentiates financial documents in group reporting that are generated by various consolidation tasks, such as currency translation, data collection, and data transfer. </p> This CDS view provides the data to answer the following business questions:<ul> <li><p>What is the posting level of the document type? </p></li> <li><p>Is only manual posting allowed for a document type? </p></li> </ul> Here are some example values:<ul> <li><p>00: Uploaded Data</p></li> <li><p>02: Manual Correction of Reported Data </p></li> <li><p>1E: EPU Postings </p></li> <li><p>1U: Revoke EPU Postings </p></li> <li><p>2A: Inter Company Elimination of Cross Profit</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
tf500 tf500 from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_CnsldtnDimension _Dimension $projection.ConsolidationDimension = _Dimension.ConsolidationDimension
[0..1] I_CnsldtnPostingLevel _PostingLevel $projection.PostingLevel = _PostingLevel.PostingLevel
[0..*] I_CnsldtnDocumentTypeT _Text $projection.ConsolidationDimension = _Text.ConsolidationDimension and $projection.ConsolidationDocumentType = _Text.ConsolidationDocumentType
[0..*] I_CnsldtnDocumentTypeHierNode _DocTypeHierNode $projection.ConsolidationDocumentType = _DocTypeHierNode.ConsolidationDocumentType and $projection.ConsolidationDimension = _DocTypeHierNode.ConsolidationDimension

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName ICCDOCTYPE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.representativeKey ConsolidationDocumentType view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
VDM.viewType #BASIC view
EndUserText.label Consolidation Document Type view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationDimension dimen Dimension Unit
KEY ConsolidationDocumentType docty Document Type
PostingLevel rlevl Posting Level
ConsolidationBalanceCheck blchk Balance check for consolidation document
ConsolidationPostgItemAutoFlag mnpos Manual Posting
_Dimension _Dimension
_PostingLevel _PostingLevel
_Text _Text
_DocTypeHierNode _DocTypeHierNode

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_CnsldtnDocumentType.
-- 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_CnsldtnDocumentType AS
SELECT
  dimen AS ConsolidationDimension,
  docty AS ConsolidationDocumentType,
  rlevl AS PostingLevel,
  blchk AS ConsolidationBalanceCheck,
  mnpos AS ConsolidationPostgItemAutoFlag
FROM tf500
LEFT OUTER JOIN I_CnsldtnDimension AS _Dimension ON ConsolidationDimension = _Dimension.ConsolidationDimension  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnPostingLevel AS _PostingLevel ON PostingLevel = _PostingLevel.PostingLevel  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnDocumentTypeT AS _Text ON ConsolidationDimension = _Text.ConsolidationDimension AND ConsolidationDocumentType = _Text.ConsolidationDocumentType  -- association [0..*]
LEFT OUTER JOIN I_CnsldtnDocumentTypeHierNode AS _DocTypeHierNode ON ConsolidationDocumentType = _DocTypeHierNode.ConsolidationDocumentType AND ConsolidationDimension = _DocTypeHierNode.ConsolidationDimension  -- association [0..*]
;

Learn More