I_CnsldtnAddlCharcs

DDL: I_CNSLDTNADDLCHARCS SQL: ICCADDLCHARCS Type: view BASIC
16 Fields 1 Data Sources

I_CnsldtnAddlCharcs is a Basic CDS View (Dimension) in SAP S/4HANA. It reads from 1 data source (fincs_addlcharc) and exposes 16 fields with key field CnsldtnAddlCharcUUID.

Data Sources (1)

SourceAliasJoin Type
fincs_addlcharc fincs_addlcharc from

Annotations (15)

NameValueLevelField
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName ICCADDLCHARCS view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.representativeKey CnsldtnAddlCharcUUID view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY CnsldtnAddlCharcUUID cnsldtnaddlcharcuuid UUID
AdditionalCharacteristicUUID cnsldtnaddlcharcuuid UUID
AdditionalCharcFieldName cnsldtnaddlcharcfldname Field Name
AdditionalMasterDataIsPossible cnsldtnaddlmdispossible Master Data Possible
AdditionalCharcIsInUse cnsldtnaddlcharcisinuse Enable Inputs
AdditionalMasterDataIsInUse cnsldtnaddlmdisinuse Enable Master Data
AdditionalMasterDataSuprordFld cnsldtnaddlmdsuprordfld Suprord. Field
AdditionalMasterDataPairedFld cnsldtnaddlmdpairedfld Reference Field
NumberOfAdditionalMasterData
NumberOfAccountingMasterData
TotalNumberOfMasterData
AdditionalMasterDataHasHier cnsldtnaddlmdhashier Hierarchy Possible
AdditionalMDHierarchyIsInUse cnsldtnaddlmdhierisinuse Enable Hierarchy
ConsolidationMDCharcsIntID
ConsolidationMDSuprordIntID
ConsolidationMDPairedFldIntID

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_CnsldtnAddlCharcs.
-- 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.
-- SQL view name: ICCADDLCHARCS

CREATE VIEW I_CnsldtnAddlCharcs AS
SELECT
  CnsldtnAddlCharcUUID,
  cnsldtnaddlcharcuuid AS AdditionalCharacteristicUUID,
  cnsldtnaddlcharcfldname AS AdditionalCharcFieldName,
  cnsldtnaddlmdispossible AS AdditionalMasterDataIsPossible,
  cnsldtnaddlcharcisinuse AS AdditionalCharcIsInUse,
  cnsldtnaddlmdisinuse AS AdditionalMasterDataIsInUse,
  cnsldtnaddlmdsuprordfld AS AdditionalMasterDataSuprordFld,
  cnsldtnaddlmdpairedfld AS AdditionalMasterDataPairedFld,
  cast(0 as fincs_number_count) AS NumberOfAdditionalMasterData,
  cast(0 as fincs_number_count) AS NumberOfAccountingMasterData,
  cast(0 as fincs_number_count) AS TotalNumberOfMasterData,
  cnsldtnaddlmdhashier AS AdditionalMasterDataHasHier,
  cnsldtnaddlmdhierisinuse AS AdditionalMDHierarchyIsInUse,
  cast('' as fincs_external_field_name) AS ConsolidationMDCharcsIntID,
  cast('' as fincs_external_field_name) AS ConsolidationMDSuprordIntID,
  cast('' as fincs_external_field_name) AS ConsolidationMDPairedFldIntID
FROM fincs_addlcharc
;

Learn More