I_GHOThrtclOvrrdeExpanded

DDL: I_GHOTHRTCLOVRRDEEXPANDED Type: view_entity COMPOSITE
16 Fields 1 Data Sources

Theoretical Override with Items

I_GHOThrtclOvrrdeExpanded is a Composite CDS View that provides data about "Theoretical Override with Items" in SAP S/4HANA. It reads from 1 data source (I_GHOTheoreticalOverride) and exposes 16 fields with key fields GHOTheoreticalOverrideUUID, AllocationRuleUnitOfMsmt.

Data Sources (1)

SourceAliasJoin Type
I_GHOTheoreticalOverride I_GHOTheoreticalOverride from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Theoretical Override with Items 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 (16)

KeyFieldSource TableSource FieldDescription
KEY GHOTheoreticalOverrideUUID GHOTheoreticalOverrideUUID Theoretical Ovr ID
KEY AllocationRuleUnitOfMsmt _TheoreticalOverrideItems AllocationRuleUnitOfMsmt
GHONetworkID GHONetworkID Netw Object ID
GHONetworkObjectID GHONetworkObjectID
NetworkMedium NetworkMedium Medium ID
AllocationFrequencyCode AllocationFrequencyCode Frequency ID
ValidFromDateTime ValidFromDateTime Time Stamp
ValidToDateTime ValidToDateTime Time Stamp
NtwkObjIsNonAdjustable NtwkObjIsNonAdjustable Node Non Adjustable
GHOQuantityType GHOQuantityType Quantity Type
AllocationRuleMsmtValue _TheoreticalOverrideItems AllocationRuleMsmtValue
TheoreticalIsAdjustable TheoreticalIsAdjustable Non Adjustable Theo
_NtwkObjects _NtwkObjects
_NtwkAllocRuleQtyType _NtwkAllocRuleQtyType
_ProductionNetworkDetails _ProductionNetworkDetails
_QuantityType _QuantityType

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_GHOThrtclOvrrdeExpanded.
-- 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_GHOThrtclOvrrdeExpanded AS
SELECT
  GHOTheoreticalOverrideUUID,
  _TheoreticalOverrideItems.AllocationRuleUnitOfMsmt AS AllocationRuleUnitOfMsmt,
  GHONetworkID,
  GHONetworkObjectID,
  NetworkMedium,
  AllocationFrequencyCode,
  ValidFromDateTime,
  ValidToDateTime,
  NtwkObjIsNonAdjustable,
  GHOQuantityType,
  _TheoreticalOverrideItems.AllocationRuleMsmtValue AS AllocationRuleMsmtValue,
  TheoreticalIsAdjustable
FROM I_GHOTheoreticalOverride
;

Learn More