What is A_CnsldtnSubItem in SAP S/4HANA?

A_CnsldtnSubItem is a basic CDS view in SAP S/4HANA. Subitem It contains 12 fields.

Which tables does A_CnsldtnSubItem read from?

A_CnsldtnSubItem reads data from: I_CnsldtnSubItemEnhcd.

What VDM layer is A_CnsldtnSubItem?

A_CnsldtnSubItem is classified as a Basic (interface) view providing a 1:1 representation of a database table.

A_CnsldtnSubItem

DDL: A_CNSLDTNSUBITEM SQL: ACSSUBITEM Type: view BASIC

12 Fields 1 Data Sources 7 Associations

Subitem

A_CnsldtnSubItem is a Basic CDS View that provides data about "Subitem" in SAP S/4HANA. It reads from 1 data source (I_CnsldtnSubItemEnhcd) and exposes 12 fields with key fields SubItemCategory, SubItem. It has 7 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_CnsldtnSubItemEnhcd	I_CnsldtnSubItemEnhcd	from

Associations (7)

Cardinality	Target	Alias	Condition
[0..*]	A_CnsldtnSubItemT	_CnsldtnSubItemT	`$projection.SubItemCategory = _CnsldtnSubItemT.SubItemCategory and $projection.SubItem = _CnsldtnSubItemT.SubItem`
[0..*]	A_CnsldtnSubItemT	_SubitemCarryForwardDestT	`$projection.SubItemCategory = _SubitemCarryForwardDestT.SubItemCategory and $projection.SubitemCarryForwardDestination = _SubitemCarryForwardDestT.SubItem`
[0..*]	A_CnsldtnSubItemT	_SubitemRtrmtDivestitureDestT	`$projection.SubItemCategory = _SubitemRtrmtDivestitureDestT.SubItemCategory and $projection.SubitemRtrmtDivestitureDest = _SubitemRtrmtDivestitureDestT.SubItem`
[0..*]	A_CnsldtnSubItemT	_SubitemAcquisitionDestT	`$projection.SubItemCategory = _SubitemAcquisitionDestT.SubItemCategory and $projection.SubitemAcquisitionDestination = _SubitemAcquisitionDestT.SubItem`
[0..1]	A_CnsldtnSubitemCategory	_CnsldtnSubItemCategory	`$projection.SubItemCategory = _CnsldtnSubItemCategory.SubItemCategory`
[0..*]	A_CnsldtnSubitemCategoryT	_CnsldtnSubItemCategoryT	`$projection.SubItemCategory = _CnsldtnSubItemCategoryT.SubItemCategory`
[0..*]	A_CnsldtnSubitemHier	_CnsldtnSubitemHier	`$projection.SubItemCategory = _CnsldtnSubitemHier.SubItemCategory`

Annotations (14)

Name	Value	Level
AbapCatalog.sqlViewName	ACSSUBITEM	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.dataClass	#CUSTOMIZING	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.representativeKey	SubItem	view
ObjectModel.sapObjectNodeType.name	ConsolidationSubitem	view
VDM.viewType	#BASIC	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view
EndUserText.label	Subitem	view
OData.entitySet.name	SubItem	view

Fields (12)

Key	Field	Source Field	Description
KEY	SubItemCategory	SubItemCategory	Subitem Category
KEY	SubItem	SubItem	Subitem Number
	SubitemCarryForwardDestination	SubitemCarryForwardDestination	CarFwd Subitem
	SubitemRtrmtDivestitureDest	SubitemRtrmtDivestitureDest	Divest. subitem
	SubitemAcquisitionDestination	SubitemAcquisitionDestination	Acquisition subitem
	_SubitemCarryForwardDestT	_SubitemCarryForwardDestT
	_SubitemRtrmtDivestitureDestT	_SubitemRtrmtDivestitureDestT
	_SubitemAcquisitionDestT	_SubitemAcquisitionDestT
	_CnsldtnSubItemCategoryT	_CnsldtnSubItemCategoryT
	_CnsldtnSubItemCategory	_CnsldtnSubItemCategory
	_CnsldtnSubItemT	_CnsldtnSubItemT
	_CnsldtnSubitemHier	_CnsldtnSubitemHier

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 A_CnsldtnSubItem.
-- 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: ACSSUBITEM

CREATE VIEW A_CnsldtnSubItem AS
SELECT
  SubItemCategory,
  SubItem,
  SubitemCarryForwardDestination,
  SubitemRtrmtDivestitureDest,
  SubitemAcquisitionDestination
FROM I_CnsldtnSubItemEnhcd
LEFT OUTER JOIN A_CnsldtnSubItemT AS _CnsldtnSubItemT ON SubItemCategory = _CnsldtnSubItemT.SubItemCategory AND SubItem = _CnsldtnSubItemT.SubItem  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnSubItemT AS _SubitemCarryForwardDestT ON SubItemCategory = _SubitemCarryForwardDestT.SubItemCategory AND SubitemCarryForwardDestination = _SubitemCarryForwardDestT.SubItem  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnSubItemT AS _SubitemRtrmtDivestitureDestT ON SubItemCategory = _SubitemRtrmtDivestitureDestT.SubItemCategory AND SubitemRtrmtDivestitureDest = _SubitemRtrmtDivestitureDestT.SubItem  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnSubItemT AS _SubitemAcquisitionDestT ON SubItemCategory = _SubitemAcquisitionDestT.SubItemCategory AND SubitemAcquisitionDestination = _SubitemAcquisitionDestT.SubItem  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnSubitemCategory AS _CnsldtnSubItemCategory ON SubItemCategory = _CnsldtnSubItemCategory.SubItemCategory  -- association [0..1]
LEFT OUTER JOIN A_CnsldtnSubitemCategoryT AS _CnsldtnSubItemCategoryT ON SubItemCategory = _CnsldtnSubItemCategoryT.SubItemCategory  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnSubitemHier AS _CnsldtnSubitemHier ON SubItemCategory = _CnsldtnSubitemHier.SubItemCategory  -- association [0..*]
;

Depth:

A_CnsldtnSubItem view

I_CnsldtnSubItemEnhcd view