I_GHOAllocRsltsAllcdThrtcl

DDL: I_GHOALLOCRSLTSALLCDTHRTCL Type: view_entity COMPOSITE
11 Fields 1 Data Sources

Allocation Results Allocated Thrtcls

I_GHOAllocRsltsAllcdThrtcl is a Composite CDS View that provides data about "Allocation Results Allocated Thrtcls" in SAP S/4HANA. It reads from 1 data source (I_GHOProdnAllocationResults) and exposes 11 fields with key fields AllocationRunID, GHOQuantityCategory, AllocationRuleUnitOfMsmt, AllocRsltsThrtclOrActual.

Data Sources (1)

SourceAliasJoin Type
I_GHOProdnAllocationResults I_GHOProdnAllocationResults from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Allocation Results Allocated Thrtcls view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY AllocationRunID AllocationRunID Allocation Run ID
KEY GHOQuantityCategory _AllocatedTheo GHOQuantityCategory
KEY AllocationRuleUnitOfMsmt _AllocatedTheo AllocationRuleUnitOfMsmt
KEY AllocRsltsThrtclOrActual _AllocatedTheo AllocRsltsThrtclOrActual
GHONetworkID GHONetworkID Netw Object ID
NetworkMedium NetworkMedium Medium ID
ProductionAllocationType ProductionAllocationType Allocation Type
AllocationFrequencyCode AllocationFrequencyCode Frequency ID
AllocationResultIsFinal AllocationResultIsFinal Final Ind Alloc Rest
ProdnAllocDateTime Production UTC Date Time
AllocationRuleMsmtValue

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 I_GHOAllocRsltsAllcdThrtcl.
-- 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.

CREATE VIEW I_GHOAllocRsltsAllcdThrtcl AS
SELECT
  AllocationRunID,
  _AllocatedTheo.GHOQuantityCategory AS GHOQuantityCategory,
  _AllocatedTheo.AllocationRuleUnitOfMsmt AS AllocationRuleUnitOfMsmt,
  _AllocatedTheo.AllocRsltsThrtclOrActual AS AllocRsltsThrtclOrActual,
  GHONetworkID,
  NetworkMedium,
  ProductionAllocationType,
  AllocationFrequencyCode,
  AllocationResultIsFinal,
  cast(ProdnAllocUTCDteTme as gho_prodalloc_datetime preserving type ) AS ProdnAllocDateTime,
  cast(sum(_AllocatedTheo.AllocationRuleMsmtValue) as gho_quantity_in_dec) AS AllocationRuleMsmtValue
FROM I_GHOProdnAllocationResults
;

Learn More