ESH_ACTIVITYTYPE_BASIS

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_BASIS.
-- 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: ESHACTIVITYTYPEB

CREATE VIEW ESH_ACTIVITYTYPE_BASIS AS
SELECT
  ControllingArea,
  CostCtrActivityType,
  ValidityEndDate,
  ValidityStartDate,
  _Text[ 1:Language = $session.system_language ].CostCtrActivityTypeName AS CostCtrActivityTypeName,
  _Text[1:Language = $session.system_language].CostCtrActivityTypeDesc AS CostCtrActivityTypeDesc,
  CostCtrActivityTypeQtyUnit,
  _UnitOfMeasure._Text[1:Language = $session.system_language].UnitOfMeasureName AS UnitOfMeasureName,
  CostCtrActivityTypeValidCat,
  CostCtrActivityTypeCategory,
  _CostCenterActivityTypeCatText[1:ddlanguage = $session.system_language].ddtext AS CostCtrActivityTypeCatName,
  AllocationCostElement,
  _ControllingArea.ktopl AS ChartOfAccounts,
  CreationDate,
  EnteredByUser,
  _EnteredByUser._TO_USER_NAME.name_text AS FullName,
  PriceAllocationMethod,
  ActualPriceAllocationMethod,
  ActivityTypeIsBlocked,
  _ActivityTypeIsBlockedText[ 1: DOMALANGU = $session.system_language ].VALUE_TEXT AS ActivityTypeIsBlockedName,
  CostCtrActivityTypeOutpQtyUnit,
  _CostCtrActyTypeOutpQtyUnit._Text[1:Language = $session.system_language].UnitOfMeasureName AS CostCtrActyTypeOutpQtyUnitName,
  OutputQuantityFactor
FROM I_CostCenterActivityType
LEFT OUTER JOIN ESH_N_USER_USER AS _EnteredByUser ON EnteredByUser = _EnteredByUser.bname  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CostCtrActyTypeOutpQtyUnit ON CostCtrActivityTypeOutpQtyUnit = _CostCtrActyTypeOutpQtyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN ESH_N_XFELD_3_XFELD AS _ActivityTypeIsBlockedText ON ActivityTypeIsBlocked = _ActivityTypeIsBlockedText.domvalue_l  -- association [0..*]
LEFT OUTER JOIN dd07t AS _CostCenterActivityTypeCatText ON CostCtrActivityTypeCategory = _CostCenterActivityTypeCatText.domvalue_l AND _CostCenterActivityTypeCatText.domname = 'LATYP'  -- association [0..1]
LEFT OUTER JOIN tka01 AS _ControllingArea ON ControllingArea = _ControllingArea.kokrs  -- association [1..1]
;