C_DspDocFlwMfgOrderVH

DDL: C_DSPDOCFLWMFGORDERVH Type: view_entity CONSUMPTION

Manufacturing Order VH for DDF

C_DspDocFlwMfgOrderVH is a Consumption CDS View that provides data about "Manufacturing Order VH for DDF" in SAP S/4HANA. It reads from 1 data source (I_ManufacturingOrder) and exposes 9 fields with key field ManufacturingOrder.

Data Sources (1)

SourceAliasJoin Type
I_ManufacturingOrder I_ManufacturingOrder from

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Manufacturing Order VH for DDF view
Search.searchable true view
Consumption.ranked true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ManufacturingOrder Order
ManufacturingOrderTypeName
ControllingArea ControllingArea Controlling Area
ProductionPlant ProductionPlant Prod plnt
AnchorDocument Order
ReferenceDocumentType
ManufacturingOrderType ManufacturingOrderType Order Type
ManufacturingOrderCategory ManufacturingOrderCategory Order Category
_ProductionPlant _ProductionPlant

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 C_DspDocFlwMfgOrderVH.
-- 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 C_DspDocFlwMfgOrderVH AS
SELECT
  cast( ManufacturingOrder as fac_ddf_manufacturing_order preserving type ) AS ManufacturingOrder,
  _MfgOrderType._Text[1:Language = $session.system_language].ManufacturingOrderTypeName AS ManufacturingOrderTypeName,
  ControllingArea,
  ProductionPlant,
  cast( ManufacturingOrder as fac_ddf_anchor_document ) AS AnchorDocument,
  cast( 'BUS2005' as swo_objtyp) AS ReferenceDocumentType,
  ManufacturingOrderType,
  ManufacturingOrderCategory
FROM I_ManufacturingOrder
;