ESH_ACTIVITYTYPE

DDL: ESH_ACTIVITYTYPE SQL: ESHACTIVITYTYPE Type: view
34 Fields 1 Data Sources 1 Associations

Basis view for ESH ActivityType

ESH_ACTIVITYTYPE is a CDS View that provides data about "Basis view for ESH ActivityType" in SAP S/4HANA. It reads from 1 data source (ESH_ACTIVITYTYPE_BASIS) and exposes 34 fields with key fields ControllingArea, CostCtrActivityType, ValidityEndDate. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
ESH_ACTIVITYTYPE_BASIS ESH_ACTIVITYTYPE_BASIS from

Parameters (1)

NameTypeDefault
P_ReferenceDate abap.dats

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_CostElementOnChartOfAccounts _CostElement $projection.AllocationCostElement = _CostElement.CostElement

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName ESHACTIVITYTYPE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label Basis view for ESH ActivityType view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea ControllingArea Controlling Area
KEY CostCtrActivityType CostCtrActivityType Activity Type
KEY ValidityEndDate ValidityEndDate ValidTo
ValidityStartDate ValidityStartDate Validity Start Date
CostCtrActivityTypeName CostCtrActivityTypeName
CostCtrActivityTypeDesc CostCtrActivityTypeDesc
CostCtrActivityTypeQtyUnit CostCtrActivityTypeQtyUnit
UnitOfMeasureName UnitOfMeasureName Meas. Unit Text
CostCtrActivityTypeValidCat CostCtrActivityTypeValidCat
CostCtrActivityTypeCategory CostCtrActivityTypeCategory
CostCtrActivityTypeCatName CostCtrActivityTypeCatName
AllocationCostElement AllocationCostElement
CostElementName
ChartOfAccounts ChartOfAccounts Node Class
CreationDate CreationDate Time Stamp
EnteredByUser EnteredByUser
FullName FullName Name
PriceAllocationMethod PriceAllocationMethod
ActualPriceAllocationMethod ActualPriceAllocationMethod
ActivityTypeIsBlocked ActivityTypeIsBlocked
ActivityTypeIsBlockedName ActivityTypeIsBlockedName
CostCtrActivityTypeOutpQtyUnit CostCtrActivityTypeOutpQtyUnit
CostCtrActyTypeOutpQtyUnitName CostCtrActyTypeOutpQtyUnitName
OutputQuantityFactor OutputQuantityFactor
_Text _Text
_ControllingArea _ControllingArea
_CostCenterCategory _CostCenterCategory
_CostCtrActivityTypeCategory _CostCtrActivityTypeCategory
_CostCenterActivityTypeCatText _CostCenterActivityTypeCatText
_UnitOfMeasure _UnitOfMeasure
_ControllingAreaText _ControllingAreaText
_EnteredByUser _EnteredByUser
_ActivityTypeIsBlockedText _ActivityTypeIsBlockedText
_CostElement _CostElement

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 ESH_ACTIVITYTYPE.
-- 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: ESHACTIVITYTYPE
-- Parameters: P_ReferenceDate : abap.dats

CREATE VIEW ESH_ACTIVITYTYPE AS
SELECT
  ControllingArea,
  CostCtrActivityType,
  ValidityEndDate,
  ValidityStartDate,
  CostCtrActivityTypeName,
  CostCtrActivityTypeDesc,
  CostCtrActivityTypeQtyUnit,
  UnitOfMeasureName,
  CostCtrActivityTypeValidCat,
  CostCtrActivityTypeCategory,
  CostCtrActivityTypeCatName,
  AllocationCostElement,
  _CostElement[1:ChartOfAccounts = ChartOfAccounts]._Text[1:Language = $session.system_language].CostElementName AS CostElementName,
  ChartOfAccounts,
  CreationDate,
  EnteredByUser,
  FullName,
  PriceAllocationMethod,
  ActualPriceAllocationMethod,
  ActivityTypeIsBlocked,
  ActivityTypeIsBlockedName,
  CostCtrActivityTypeOutpQtyUnit,
  CostCtrActyTypeOutpQtyUnitName,
  OutputQuantityFactor
FROM ESH_ACTIVITYTYPE_BASIS
LEFT OUTER JOIN I_CostElementOnChartOfAccounts AS _CostElement ON AllocationCostElement = _CostElement.CostElement  -- association [0..*]
;

Learn More