What is A_CnsldtnPartnerFuncnlArea in SAP S/4HANA?

A_CnsldtnPartnerFuncnlArea is a basic CDS view in SAP S/4HANA. Combined Partner Functional Area It contains 6 fields.

Which tables does A_CnsldtnPartnerFuncnlArea read from?

A_CnsldtnPartnerFuncnlArea reads data from: I_CnsldtnFunctionalArea.

What VDM layer is A_CnsldtnPartnerFuncnlArea?

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

A_CnsldtnPartnerFuncnlArea

DDL: A_CNSLDTNPARTNERFUNCNLAREA Type: view BASIC

6 Fields 1 Data Sources 2 Associations

Combined Partner Functional Area

A_CnsldtnPartnerFuncnlArea is a Basic CDS View that provides data about "Combined Partner Functional Area" in SAP S/4HANA. It reads from 1 data source (I_CnsldtnFunctionalArea) and exposes 6 fields with key field FunctionalArea. It has 2 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_CnsldtnFunctionalArea	I_CnsldtnFunctionalArea	from

Associations (2)

Cardinality	Target	Alias	Condition
[0..*]	A_CnsldtnPartFuncnlAreaT	_CnsldtnPartFuncnlAreaT	`$projection.FunctionalArea = _CnsldtnPartFuncnlAreaT.FunctionalArea`
[0..*]	A_CnsldtnPartFuncnlAreaHier	_CnsldtnPartFuncnlAreaHier	`$projection.MDHierType = _CnsldtnPartFuncnlAreaHier.MDHierType`

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	ACSPARTFUNCAREA	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
VDM.viewType	#BASIC	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view
EndUserText.label	Combined Partner Functional Area	view
OData.entitySet.name	PartnerFunctionalArea	view

Fields (6)

Key	Field	Source Field	Description
KEY	FunctionalArea	FunctionalArea	Partner Functional Area
	AdditionalMasterDataSource	AdditionalMasterDataSource
	MDHierType
	HierarchyType
	_CnsldtnPartFuncnlAreaT	_CnsldtnPartFuncnlAreaT
	_CnsldtnPartFuncnlAreaHier	_CnsldtnPartFuncnlAreaHier

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_CnsldtnPartnerFuncnlArea.
-- 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 A_CnsldtnPartnerFuncnlArea AS
SELECT
  FunctionalArea,
  AdditionalMasterDataSource,
  cast ( 'CS05' as hrytype ) AS MDHierType,
  cast ( 'CS05' as hrytype ) AS HierarchyType
FROM I_CnsldtnFunctionalArea
LEFT OUTER JOIN A_CnsldtnPartFuncnlAreaT AS _CnsldtnPartFuncnlAreaT ON FunctionalArea = _CnsldtnPartFuncnlAreaT.FunctionalArea  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnPartFuncnlAreaHier AS _CnsldtnPartFuncnlAreaHier ON MDHierType = _CnsldtnPartFuncnlAreaHier.MDHierType  -- association [0..*]
;

Depth:

A_CnsldtnPartnerFuncnlArea view

I_CnsldtnFunctionalArea view