I_BreakdownCategory

DDL: I_BREAKDOWNCATEGORY Type: view BASIC
15 Fields 1 Data Sources 2 Associations

Breakdown Category

I_BreakdownCategory is a Basic CDS View (Dimension) that provides data about "Breakdown Category" in SAP S/4HANA. It reads from 1 data source (P_CnsldtnBreakdownCategory) and exposes 15 fields with key fields ConsolidationChartOfAccounts, BreakdownCategory. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_CnsldtnBreakdownCategory P_CnsldtnBreakdownCategory from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_BreakdownCategoryText _Text $projection.ConsolidationChartOfAccounts = _Text.ConsolidationChartOfAccounts and $projection.BreakdownCategory = _Text.BreakdownCategory
[0..*] I_BreakdownCategoryField _Field $projection.ConsolidationChartOfAccounts = _Field.ConsolidationChartOfAccounts and $projection.BreakdownCategory = _Field.BreakdownCategory

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IBRKDWNCAT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
Analytics.dataCategory #DIMENSION view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.representativeKey BreakdownCategory view
ObjectModel.compositionRoot true view
VDM.viewType #BASIC view
EndUserText.label Breakdown Category view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationChartOfAccounts ConsolidationChartOfAccounts Cons. COA
KEY BreakdownCategory ConsolidationBreakdownCategory Breakdown Cat.
PartnerUnitBreakdownType
PartnerUnitSelection
TransactionCrcyBreakdownType
TransactionCurrencySelection
SubitemCategoryBreakdownType
SubitemCategoryFixedValue
SubitemBreakdownType
SubitemSelection
BaseUnitBreakdownType
BaseUnitFixedValue
_Text _Text
_ChartOfAccounts _CnsldtnChartOfAccounts
_Field _Field

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_BreakdownCategory.
-- 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_BreakdownCategory AS
SELECT
  ConsolidationChartOfAccounts,
  ConsolidationBreakdownCategory AS BreakdownCategory,
  _Field[1:BreakdownCatFieldName = 'RBUPTR'].BreakdownType AS PartnerUnitBreakdownType,
  _Field[1:BreakdownCatFieldName = 'RBUPTR'].SelectionItemMaxVal AS PartnerUnitSelection,
  _Field[1:BreakdownCatFieldName = 'RTCUR'].BreakdownType AS TransactionCrcyBreakdownType,
  _Field[1:BreakdownCatFieldName = 'RTCUR'].SelectionItemMaxVal AS TransactionCurrencySelection,
  _Field[1:BreakdownCatFieldName = 'SITYP'].BreakdownType AS SubitemCategoryBreakdownType,
  _Field[1:BreakdownCatFieldName = 'SITYP'].BreakdownCategoryFixedValue AS SubitemCategoryFixedValue,
  _Field[1:BreakdownCatFieldName = 'SUBIT'].BreakdownType AS SubitemBreakdownType,
  _Field[1:BreakdownCatFieldName = 'SUBIT'].SelectionItemMaxVal AS SubitemSelection,
  _Field[1:BreakdownCatFieldName = 'RUNIT'].BreakdownType AS BaseUnitBreakdownType,
  _Field[1:BreakdownCatFieldName = 'RUNIT'].BreakdownCategoryFixedValue AS BaseUnitFixedValue
FROM P_CnsldtnBreakdownCategory
LEFT OUTER JOIN I_BreakdownCategoryText AS _Text ON ConsolidationChartOfAccounts = _Text.ConsolidationChartOfAccounts AND BreakdownCategory = _Text.BreakdownCategory  -- association [0..*]
LEFT OUTER JOIN I_BreakdownCategoryField AS _Field ON ConsolidationChartOfAccounts = _Field.ConsolidationChartOfAccounts AND BreakdownCategory = _Field.BreakdownCategory  -- association [0..*]
;

Learn More