P_ActyTypeGlobAcctgHier

DDL: P_ACTYTYPEGLOBACCTGHIER SQL: PATGAH Type: view CONSUMPTION Package: ODATA_WHERE_USED_ACTIVITY_TYPE
25 Fields 1 Data Sources

Global Accounting Hierarchies

P_ActyTypeGlobAcctgHier is a Consumption CDS View that provides data about "Global Accounting Hierarchies" in SAP S/4HANA. It reads from 1 data source (C_ActyTypeWhereUsedObjTypeVH) and exposes 25 fields with key fields ActyTypeWhereUsedObjType, ControllingArea, CostCtrActivityType, CostCtrActyTypeValdtyEndDate, ValidityEndDate. Part of development package ODATA_WHERE_USED_ACTIVITY_TYPE.

Data Sources (1)

SourceAliasJoin Type
C_ActyTypeWhereUsedObjTypeVH C_ActyTypeWhereUsedObjTypeVH from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PATGAH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
VDM.private true view
EndUserText.label Global Accounting Hierarchies view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY ActyTypeWhereUsedObjType ActyTypeWhereUsedObjType
KEY ControllingArea
KEY CostCtrActivityType
KEY CostCtrActyTypeValdtyEndDate
KEY ValidityEndDate
KEY ActyTypeWhereUsdHierID
KEY HierarchyVersion
KEY HierarchyNodeClass
KEY HierarchyNode
KEY HierarchyParentNode
CostCtrActivityTypeName
CostCtrActyTypeValdtyStartDate
ActyTypeWhereUsdActyTpHier
ActyTypeWhereUsdHierName
ActyTypeWhereUsdHierType
ActyTypeWhereUsdHierSemLnk
ActyTypeWhereUsdSrceHier
ActyTypeWhereUsdSrceHierSemLnk
ValidityStartDate
CreatedByUser
CreationDate
LastChangedByUser
LastChangedDate
ActyTypeWhereUsdHierStatus
ActyTypeWhereUsdHierStsTxt

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 P_ActyTypeGlobAcctgHier.
-- 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: PATGAH

CREATE VIEW P_ActyTypeGlobAcctgHier AS
SELECT
  ActyTypeWhereUsedObjType,
  cast('' as fis_kokrs) AS ControllingArea,
  cast('' as lstar) AS CostCtrActivityType,
  cast('' as activitytypevalidityenddate) AS CostCtrActyTypeValdtyEndDate,
  cast('' as actytypewhereusedrtgvalidto) AS ValidityEndDate,
  cast('' as hryid) AS ActyTypeWhereUsdHierID,
  cast('' as hryversn) AS HierarchyVersion,
  cast('' as nodecls) AS HierarchyNodeClass,
  cast('' as hrynode) AS HierarchyNode,
  cast('' as parnode) AS HierarchyParentNode,
  cast('' as actytypename) AS CostCtrActivityTypeName,
  cast('' as activitytypevaliditystartdate) AS CostCtrActyTypeValdtyStartDate,
  cast('' as actytypewhereusedgah) AS ActyTypeWhereUsdActyTpHier,
  cast('' as actytypewhereusedgahname) AS ActyTypeWhereUsdHierName,
  cast('' as actytypewhereusedgahtype) AS ActyTypeWhereUsdHierType,
  cast('' as actytypewhereusedgah) AS ActyTypeWhereUsdHierSemLnk,
  cast('' as actytypewhereusedgahsource) AS ActyTypeWhereUsdSrceHier,
  cast('' as actytypewhereusedgahsource) AS ActyTypeWhereUsdSrceHierSemLnk,
  cast('' as actytypewhereusedrtgvalidfrom) AS ValidityStartDate,
  cast('' as crnam) AS CreatedByUser,
  cast('' as fco_cc_createdon) AS CreationDate,
  cast('' as fco_cc_changedby) AS LastChangedByUser,
  cast('' as changedon) AS LastChangedDate,
  cast('' as vrsst) AS ActyTypeWhereUsdHierStatus,
  cast('' as actytypewhereusedgahstatustxt) AS ActyTypeWhereUsdHierStsTxt
FROM C_ActyTypeWhereUsedObjTypeVH
;

Learn More