I_GHOAllocResultsWithoutVolDoc

DDL: I_GHOALLOCRESULTSWITHOUTVOLDOC Type: view_entity COMPOSITE
8 Fields 1 Data Sources

Allocated Results without WC Vol Doc

I_GHOAllocResultsWithoutVolDoc is a Composite CDS View that provides data about "Allocated Results without WC Vol Doc" in SAP S/4HANA. It reads from 1 data source (I_GHOAllocRsltsAllcdThrtcl) and exposes 8 fields with key fields AllocationRunID, GHOQuantityCategory, AllocationRuleUnitOfMsmt.

Data Sources (1)

SourceAliasJoin Type
I_GHOAllocRsltsAllcdThrtcl I_GHOAllocRsltsAllcdThrtcl from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Allocated Results without WC Vol Doc view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY AllocationRunID AllocationRunID
KEY GHOQuantityCategory GHOQuantityCategory
KEY AllocationRuleUnitOfMsmt AllocationRuleUnitOfMsmt
GHONetworkID GHONetworkID Netw Object ID
NetworkMedium NetworkMedium Medium ID
ProductionAllocationType ProductionAllocationType Allocation Type
AllocationFrequencyCode AllocationFrequencyCode Frequency ID
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_GHOAllocResultsWithoutVolDoc.
-- 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_GHOAllocResultsWithoutVolDoc AS
SELECT
  AllocationRunID,
  GHOQuantityCategory,
  AllocationRuleUnitOfMsmt,
  GHONetworkID,
  NetworkMedium,
  ProductionAllocationType,
  AllocationFrequencyCode,
  sum(AllocationRuleMsmtValue) AS AllocationRuleMsmtValue
FROM I_GHOAllocRsltsAllcdThrtcl
;

Learn More