I_ProcOrdFailedGoodsMovement

DDL: I_PROCORDFAILEDGOODSMOVEMENT Type: view_entity COMPOSITE
31 Fields 2 Data Sources 2 Associations

Process Orders Failed Goods Movement

I_ProcOrdFailedGoodsMovement is a Composite CDS View that provides data about "Process Orders Failed Goods Movement" in SAP S/4HANA. It reads from 2 data sources (I_GoodsMovementExceptionItem, I_LogisticsOrder) and exposes 31 fields with key fields GoodsMovementException, GoodsMovementExceptionItem, OrderID. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_GoodsMovementExceptionItem _Exception from
I_LogisticsOrder _ManufacturingOrder inner

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_MaterialText _MaterialText $projection.Material = _MaterialText.Material and _MaterialText.Language = $session.system_language
[0..1] I_GoodsMovementTypeT _GoodsMovementTypeText $projection.GoodsMovementType = _GoodsMovementTypeText.GoodsMovementType and _GoodsMovementTypeText.Language = $session.system_language

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Process Orders Failed Goods Movement view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY GoodsMovementException I_GoodsMovementExceptionItem GoodsMovementException
KEY GoodsMovementExceptionItem I_GoodsMovementExceptionItem GoodsMovementExceptionItem
KEY OrderID I_GoodsMovementExceptionItem OrderID Order ID
OrderType I_LogisticsOrder OrderType Order Type
CreationDate I_GoodsMovementExceptionItem CreationDate Time Stamp
CreationTime I_GoodsMovementExceptionItem CreationTime Time of Change
CreatedByUser I_GoodsMovementExceptionItem CreatedByUser User Name
LastChangeDate I_GoodsMovementExceptionItem LastChangeDate Time Stamp
LastChangedByUser I_GoodsMovementExceptionItem LastChangedByUser User Name
Material I_GoodsMovementExceptionItem Material Vehicle Model
MaterialName _MaterialText MaterialName Material Description
Plant I_GoodsMovementExceptionItem Plant Valuation Area
PlantName
StorageLocation I_GoodsMovementExceptionItem StorageLocation StorageLocation
Batch I_GoodsMovementExceptionItem Batch Lot No.
GoodsMovementType I_GoodsMovementExceptionItem GoodsMovementType Movement Type
GoodsMovementTypeName _GoodsMovementTypeText GoodsMovementTypeName
GoodsMovementReasonCode I_GoodsMovementExceptionItem GoodsMovementReasonCode Reason for Mvmt
ErrorOccurrenceDate I_GoodsMovementExceptionItem ErrorOccurrenceDate Error Date
ErrorOccurrenceTime I_GoodsMovementExceptionItem ErrorOccurrenceTime Error Time
SystemMessageIdentification I_GoodsMovementExceptionItem SystemMessageIdentification Message ID
SystemMessageNumber I_GoodsMovementExceptionItem SystemMessageNumber Message Number
SystemMessageType I_GoodsMovementExceptionItem SystemMessageType Message type
SystemMessageVariable1 I_GoodsMovementExceptionItem SystemMessageVariable1 Variable 1
SystemMessageVariable2 I_GoodsMovementExceptionItem SystemMessageVariable2 Variable 2
SystemMessageVariable3 I_GoodsMovementExceptionItem SystemMessageVariable3 Variable 3
SystemMessageVariable4 I_GoodsMovementExceptionItem SystemMessageVariable4 Variable 4
SystemMessageText
GoodsMovementEntryUnit I_GoodsMovementExceptionItem GoodsMovementEntryUnit Unit of Entry
GoodsMovementEntryQty I_GoodsMovementExceptionItem GoodsMovementEntryQty
_ProcOrdMgmt _ProcOrdMgmt

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_ProcOrdFailedGoodsMovement.
-- 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_ProcOrdFailedGoodsMovement AS
SELECT
  _Exception.GoodsMovementException AS GoodsMovementException,
  _Exception.GoodsMovementExceptionItem AS GoodsMovementExceptionItem,
  _Exception.OrderID AS OrderID,
  _ManufacturingOrder.OrderType AS OrderType,
  _Exception.CreationDate AS CreationDate,
  _Exception.CreationTime AS CreationTime,
  _Exception.CreatedByUser AS CreatedByUser,
  _Exception.LastChangeDate AS LastChangeDate,
  _Exception.LastChangedByUser AS LastChangedByUser,
  _Exception.Material AS Material,
  _MaterialText.MaterialName AS MaterialName,
  _Exception.Plant AS Plant,
  _ManufacturingOrder._Plant.PlantName AS PlantName,
  _Exception.StorageLocation AS StorageLocation,
  _Exception.Batch AS Batch,
  _Exception.GoodsMovementType AS GoodsMovementType,
  _GoodsMovementTypeText.GoodsMovementTypeName AS GoodsMovementTypeName,
  _Exception.GoodsMovementReasonCode AS GoodsMovementReasonCode,
  _Exception.ErrorOccurrenceDate AS ErrorOccurrenceDate,
  _Exception.ErrorOccurrenceTime AS ErrorOccurrenceTime,
  _Exception.SystemMessageIdentification AS SystemMessageIdentification,
  _Exception.SystemMessageNumber AS SystemMessageNumber,
  _Exception.SystemMessageType AS SystemMessageType,
  _Exception.SystemMessageVariable1 AS SystemMessageVariable1,
  _Exception.SystemMessageVariable2 AS SystemMessageVariable2,
  _Exception.SystemMessageVariable3 AS SystemMessageVariable3,
  _Exception.SystemMessageVariable4 AS SystemMessageVariable4,
  cast('' as char255) AS SystemMessageText,
  _Exception.GoodsMovementEntryUnit AS GoodsMovementEntryUnit,
  _Exception.GoodsMovementEntryQty AS GoodsMovementEntryQty
FROM I_GoodsMovementExceptionItem AS _Exception
INNER JOIN I_LogisticsOrder AS _ManufacturingOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GoodsMovementTypeT AS _GoodsMovementTypeText ON GoodsMovementType = _GoodsMovementTypeText.GoodsMovementType AND _GoodsMovementTypeText.Language = $session.system_language  -- association [0..1]
;

Learn More