I_GHODefermentDocumentCount

DDL: I_GHODEFERMENTDOCUMENTCOUNT Type: view_entity COMPOSITE
12 Fields 2 Data Sources

Deferment Document Count

I_GHODefermentDocumentCount is a Composite CDS View that provides data about "Deferment Document Count" in SAP S/4HANA. It reads from 2 data sources (gho_dm_results, upot_udm_deferv) and exposes 12 fields with key fields GHONetworkID, ProductionDate, UpstreamProductionTime, AllocationRuleUnitOfMsmt, AllocationFrequencyCode.

Data Sources (2)

SourceAliasJoin Type
gho_dm_results gho_dm_results union
upot_udm_deferv upot_udm_deferv from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Deferment Document Count 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 (12)

KeyFieldSource TableSource FieldDescription
KEY GHONetworkID netid Production Flow NW
KEY ProductionDate prod_date Prod. Start Dt
KEY UpstreamProductionTime prod_time Prod St Tme
KEY AllocationRuleUnitOfMsmt unit UoM
KEY AllocationFrequencyCode alloc_frequency Frequency ID
KEY NetworkMedium medium Medium ID
KEY ProductionDate prod_date Prod. Start Dt
KEY UpstreamProductionTime prod_time Prod St Tme
KEY AllocationRuleUnitOfMsmt unit UoM
KEY AllocationFrequencyCode alloc_frequency Frequency ID
KEY NetworkMedium medium Medium ID
KEY NumberOfDocuments

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_GHODefermentDocumentCount.
-- 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_GHODefermentDocumentCount AS
SELECT
  netid AS GHONetworkID,
  prod_date AS ProductionDate,
  prod_time AS UpstreamProductionTime,
  unit AS AllocationRuleUnitOfMsmt,
  alloc_frequency AS AllocationFrequencyCode,
  medium AS NetworkMedium,
  count(distinct doc_num) AS NumberOfDocuments
FROM upot_udm_deferv
-- UNION with additional select branch(es): gho_dm_results
;

Learn More