FAC_CDS_UH_ACTIVITYTYPE_MD

DDL: FAC_CDS_UH_ACTIVITYTYPE_MD SQL: FACV_UH_AT_M Type: view
31 Fields 1 Data Sources

Activity Type Master Data

FAC_CDS_UH_ACTIVITYTYPE_MD is a CDS View that provides data about "Activity Type Master Data" in SAP S/4HANA. It reads from 1 data source (I_CostCenterActivityType) and exposes 31 fields with key fields ControllingArea, CostCtrActivityType, ValidityEndDate.

Data Sources (1)

SourceAliasJoin Type
I_CostCenterActivityType I_CostCenterActivityType from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FACV_UH_AT_M view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Activity Type Master Data view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea ControllingArea Controlling Area
KEY CostCtrActivityType CostCtrActivityType Activity Type
KEY ValidityEndDate ValidityEndDate ValidTo
ValidityStartDate ValidityStartDate Validity Start Date
CostCtrActivityTypeQtyUnit CostCtrActivityTypeQtyUnit Unit
CostCtrActivityTypeCategory CostCtrActivityTypeCategory ATyp category
AllocationCostElement AllocationCostElement Alloc. CElem
CostCtrActivityTypeOutpQtyUnit CostCtrActivityTypeOutpQtyUnit Output Unit
CreationDate CreationDate Time Stamp
EnteredByUser EnteredByUser User Name
CostOriginGroup CostOriginGroup Origin Group
ActlPostgCostCenterActyTypeCat ActlPostgCostCenterActyTypeCat ATyp Cat. Act.
OutputQuantityFactor OutputQuantityFactor Output factor
ActivityTypeIsBlocked ActivityTypeIsBlocked Lock indicator
FixedCostIsPredistributed FixedCostIsPredistributed PreDistFixCosts
PriceAllocationMethod PriceAllocationMethod Price indicator
PeriodPriceIsAverage PeriodPriceIsAverage Average price
ActualPriceAllocationMethod ActualPriceAllocationMethod Act. price ind.
ActualQuantityIsSetManually ActualQuantityIsSetManually Actual qty set
PlanQuantityIsSetManually PlanQuantityIsSetManually Plan qty set
CostCtrActivityTypeValidCat CostCtrActivityTypeValidCat CCtr Categories
CostCtrActyTypeIsCtrlgRlvtComp CostCtrActyTypeIsCtrlgRlvtComp Comp.relev. CO
CostCtrActyTypeIsHumRsceRlvt CostCtrActyTypeIsHumRsceRlvt Comp.relev. HR
CostCtrActivityTypeName_T
_Text _Text
_ControllingArea _ControllingArea
_CostCenterCategory _CostCenterCategory
_CostCtrActivityTypeCategory _CostCtrActivityTypeCategory
_CostCtrActivityTypeHierNode _CostCtrActivityTypeHierNode
_UnitOfMeasure _UnitOfMeasure
_ControllingAreaText _ControllingAreaText

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 FAC_CDS_UH_ACTIVITYTYPE_MD.
-- 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: FACV_UH_AT_M

CREATE VIEW FAC_CDS_UH_ACTIVITYTYPE_MD AS
SELECT
  ControllingArea,
  CostCtrActivityType,
  ValidityEndDate,
  ValidityStartDate,
  CostCtrActivityTypeQtyUnit,
  CostCtrActivityTypeCategory,
  AllocationCostElement,
  CostCtrActivityTypeOutpQtyUnit,
  CreationDate,
  EnteredByUser,
  CostOriginGroup,
  ActlPostgCostCenterActyTypeCat,
  OutputQuantityFactor,
  ActivityTypeIsBlocked,
  FixedCostIsPredistributed,
  PriceAllocationMethod,
  PeriodPriceIsAverage,
  ActualPriceAllocationMethod,
  ActualQuantityIsSetManually,
  PlanQuantityIsSetManually,
  CostCtrActivityTypeValidCat,
  CostCtrActyTypeIsCtrlgRlvtComp,
  CostCtrActyTypeIsHumRsceRlvt,
  _Text[1:Language = $session.system_language].CostCtrActivityTypeName AS CostCtrActivityTypeName_T
FROM I_CostCenterActivityType
;

Learn More