I_GHOQuantityType

DDL: I_GHOQUANTITYTYPE Type: view_entity BASIC

Quantity Type

I_GHOQuantityType is a Basic CDS View that provides data about "Quantity Type" in SAP S/4HANA. It reads from 1 data source (gho_disposition) and exposes 4 fields with key field GHOQuantityType. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
gho_disposition gho_disposition from

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_GHONtwkAllocRuleQtyType _QuantityTypeText $projection.GHOQuantityType = _QuantityTypeText.NtwkAllocQtyType
[1..*] I_ReadDomainFixedValues _QuantityCategoryText $projection.GHOQuantityCategory = _QuantityCategoryText.DomainValue and _QuantityCategoryText.SAPDataDictionaryDomain = 'GHO_QUANTITY_CATEGORY'

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Quantity Type view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
VDM.viewType #BASIC view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY GHOQuantityType qty_type Quantity Type
GHOQuantityCategory qty_category UoM Category
_QuantityTypeText _QuantityTypeText
_QuantityCategoryText _QuantityCategoryText

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_GHOQuantityType.
-- 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_GHOQuantityType AS
SELECT
  qty_type AS GHOQuantityType,
  qty_category AS GHOQuantityCategory
FROM gho_disposition
LEFT OUTER JOIN I_GHONtwkAllocRuleQtyType AS _QuantityTypeText ON GHOQuantityType = _QuantityTypeText.NtwkAllocQtyType  -- association [1..*]
LEFT OUTER JOIN I_ReadDomainFixedValues AS _QuantityCategoryText ON GHOQuantityCategory = _QuantityCategoryText.DomainValue AND _QuantityCategoryText.SAPDataDictionaryDomain = 'GHO_QUANTITY_CATEGORY'  -- association [1..*]
;