C_PostgPerdBusTransTypeHierVH

DDL: C_POSTGPERDBUSTRANSTYPEHIERVH SQL: CPOPERBTTHIERVH Type: view CONSUMPTION
5 Fields 1 Data Sources

Business Transaction Type Hierarchy

C_PostgPerdBusTransTypeHierVH is a Consumption CDS View that provides data about "Business Transaction Type Hierarchy" in SAP S/4HANA. It reads from 1 data source (I_BusTransacTypeHier) and exposes 5 fields with key fields BusTransacTypeHier, ValidityEndDate.

Data Sources (1)

SourceAliasJoin Type
I_BusTransacTypeHier I_BusTransacTypeHier from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CPOPERBTTHIERVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey BusTransacTypeHier view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
Consumption.ranked true view
EndUserText.label Business Transaction Type Hierarchy view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY BusTransacTypeHier BusTransacTypeHier Hierarchy ID
KEY ValidityEndDate ValidityEndDate ValidTo
ValidityStartDate ValidityStartDate Validity Start Date
BusTransacTypeHierName
_Text _Text

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 C_PostgPerdBusTransTypeHierVH.
-- 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: CPOPERBTTHIERVH

CREATE VIEW C_PostgPerdBusTransTypeHierVH AS
SELECT
  BusTransacTypeHier,
  ValidityEndDate,
  ValidityStartDate,
  _Text[1:Language=$session.system_language].BusTransacTypeHierName AS BusTransacTypeHierName
FROM I_BusTransacTypeHier
;

Learn More