I_OrderMissingPartBasic

DDL: I_ORDERMISSINGPARTBASIC Type: view_entity BASIC
8 Fields 1 Data Sources 1 Associations

Missing Parts of Orders

I_OrderMissingPartBasic is a Basic CDS View that provides data about "Missing Parts of Orders" in SAP S/4HANA. It reads from 1 data source (ftind) and exposes 8 fields with key fields Plant, Material, Reservation, ReservationItem, ReservationRecordType. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
ftind ftind from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_LogisticsOrder _Order $projection.OrderID = _Order.OrderID

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view
EndUserText.label Missing Parts of Orders view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Plant ftind werks Receiving Plant
KEY Material ftind matnr Vehicle Model
KEY Reservation ftind rsnum Reservation
KEY ReservationItem
KEY ReservationRecordType
RequirementDate
OrderID ftind aufnr SettlementOrder
_Order _Order

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_OrderMissingPartBasic.
-- 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_OrderMissingPartBasic AS
SELECT
  ftind.werks AS Plant,
  ftind.matnr AS Material,
  ftind.rsnum AS Reservation,
  cast(ftind.rspos as pph_rspos preserving type) AS ReservationItem,
  cast(ftind.rsart as pph_rsart preserving type) AS ReservationRecordType,
  cast(ftind.bdter as pph_bdter preserving type) AS RequirementDate,
  ftind.aufnr AS OrderID
FROM ftind
LEFT OUTER JOIN I_LogisticsOrder AS _Order ON OrderID = _Order.OrderID  -- association [1..1]
;

Learn More