I_GHOProdAllocationResConsQty

DDL: I_GHOPRODALLOCATIONRESCONSQTY Type: view_entity COMPOSITE
27 Fields 1 Data Sources

Alloc Results for Consumption Qty Types

I_GHOProdAllocationResConsQty is a Composite CDS View that provides data about "Alloc Results for Consumption Qty Types" in SAP S/4HANA. It reads from 1 data source (I_GHOProdnAllocationResults) and exposes 27 fields with key field AllocationRunID.

Data Sources (1)

SourceAliasJoin Type
I_GHOProdnAllocationResults I_GHOProdnAllocationResults from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Alloc Results for Consumption Qty Types view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY AllocationRunID AllocationRunID
GHONetworkID GHONetworkID Netw Object ID
NetworkMedium NetworkMedium Medium ID
ProductionAllocationType ProductionAllocationType Allocation Type
AllocationFrequencyCode AllocationFrequencyCode Frequency ID
ProdnAllocUTCDteTme ProdnAllocUTCDteTme
ProductionAllocationDate ProductionAllocationDate
ProductionAllocationTime ProductionAllocationTime
NetworkAllocationStatus NetworkAllocationStatus
AllocationResultIsFinal AllocationResultIsFinal
ProdnAllocBusinessStatus ProdnAllocBusinessStatus
NetworkAllocationPurpose NetworkAllocationPurpose Allocation Purpose
AllocationRuleUnitOfMsmt _AllocatedTheo AllocationRuleUnitOfMsmt
GHOChangedOnDateTime GHOChangedOnDateTime
GHOCreatedOnDateTime GHOCreatedOnDateTime
GHOStatusObjectNumberUUID GHOStatusObjectNumberUUID
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
_MediumText _MediumText
_FrequencyText _FrequencyText
_FrequencyDetails _FrequencyDetails
_ProdnAllocResStatusPrfl _ProdnAllocResStatusPrfl
_AllocationStatus _AllocationStatus
_AllocResultCount _AllocResultCount
_AllocRsltsItems _AllocRsltsItems
_MsmtRuleExpanded _MsmtRuleExpanded
_ProdnDatesAndObjectDetails _ProdnDatesAndObjectDetails

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_GHOProdAllocationResConsQty.
-- 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_GHOProdAllocationResConsQty AS
SELECT
  AllocationRunID,
  GHONetworkID,
  NetworkMedium,
  ProductionAllocationType,
  AllocationFrequencyCode,
  ProdnAllocUTCDteTme,
  ProductionAllocationDate,
  ProductionAllocationTime,
  NetworkAllocationStatus,
  AllocationResultIsFinal,
  ProdnAllocBusinessStatus,
  NetworkAllocationPurpose,
  _AllocatedTheo.AllocationRuleUnitOfMsmt AS AllocationRuleUnitOfMsmt,
  GHOChangedOnDateTime,
  GHOCreatedOnDateTime,
  GHOStatusObjectNumberUUID,
  CreatedByUser,
  LastChangedByUser
FROM I_GHOProdnAllocationResults
;

Learn More