I_MfgGoodsMovementExcptnTP

DDL: I_MFGGOODSMOVEMENTEXCPTNTP SQL: IMFGGMETP Type: view TRANSACTIONAL
101 Fields 1 Data Sources 1 Associations

Goods Movement Exception

I_MfgGoodsMovementExcptnTP is a Transactional CDS View that provides data about "Goods Movement Exception" in SAP S/4HANA. It reads from 1 data source (I_FailedGoodsMovementItem) and exposes 101 fields with key fields GoodsMovementException, GoodsMovementExceptionItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_FailedGoodsMovementItem igmei from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ShopFloorItem _ShopFloorItem $projection.ShopFloorItem = _ShopFloorItem.ShopFloorItem

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName IMFGGMETP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.draftEnabled true view
ObjectModel.writeDraftPersistence MPEGMETPDRAFT view
EndUserText.label Goods Movement Exception view

Fields (101)

KeyFieldSource TableSource FieldDescription
KEY GoodsMovementException I_FailedGoodsMovementItem FailedGoodsMovement
KEY GoodsMovementExceptionItem I_FailedGoodsMovementItem FailedGoodsMovementItem
CreationDate I_FailedGoodsMovementItem CreationDate Time Stamp
CreationTime I_FailedGoodsMovementItem CreationTime Time of Change
CreatedByUser I_FailedGoodsMovementItem CreatedByUser User Name
LastChangeDate I_FailedGoodsMovementItem LastChangeDate Time Stamp
LastChangedByUser I_FailedGoodsMovementItem LastChangedByUser User Name
Material I_FailedGoodsMovementItem Material Vehicle Model
MaterialName
Plant I_FailedGoodsMovementItem Plant Valuation Area
StorageLocation I_FailedGoodsMovementItem StorageLocation StorageLocation
StorageLocationName
Batch I_FailedGoodsMovementItem Batch Lot No.
GoodsMovementType I_FailedGoodsMovementItem GoodsMovementType Movement Type
GoodsMovementReasonCode I_FailedGoodsMovementItem GoodsMovementReasonCode Reason for Mvmt
InventorySpecialStockType I_FailedGoodsMovementItem InventorySpecialStockType Special Stock Type
InventoryUsabilityCode I_FailedGoodsMovementItem InventoryUsabilityCode Stock Type
GoodsMovementRefDocType I_FailedGoodsMovementItem GoodsMovementRefDocType Reference Doc. Type
DebitCreditCode I_FailedGoodsMovementItem DebitCreditCode Single-Character Flag
ConsumptionPosting I_FailedGoodsMovementItem ConsumptionPosting Consumption Posting
InventoryValuationType I_FailedGoodsMovementItem InventoryValuationType Valuation Type
SalesOrder I_FailedGoodsMovementItem SalesOrder SD Document
SalesOrderItem I_FailedGoodsMovementItem SalesOrderItem Sales Order Item
WBSElementInternalID I_FailedGoodsMovementItem WBSElementInternalID WBS Internal ID
Supplier I_FailedGoodsMovementItem Supplier Supplier
Customer I_FailedGoodsMovementItem Customer Sold-to Party
GoodsRecipientName I_FailedGoodsMovementItem GoodsRecipientName Recipient Name
UnloadingPointName I_FailedGoodsMovementItem UnloadingPointName Unloading Point Name
IsCompletelyDelivered I_FailedGoodsMovementItem IsCompletelyDelivered Is completely delivered
ReservationIsFinallyIssued I_FailedGoodsMovementItem ReservationIsFinallyIssued Res Final Issue
SupplyArea I_FailedGoodsMovementItem ProductionSupplyArea Supply Area
MaterialStaging I_FailedGoodsMovementItem MaterialStaging
Warehouse I_FailedGoodsMovementItem Warehouse Warehouse No.
StorageType I_FailedGoodsMovementItem StorageType Storage Type
StorageBin I_FailedGoodsMovementItem StorageBin Storage Bin
ErrorOccurrenceDate I_FailedGoodsMovementItem ErrorOccurrenceDate
ErrorOccurrenceTime I_FailedGoodsMovementItem ErrorOccurrenceTime
SystemMessageIdentification I_FailedGoodsMovementItem SystemMessageIdentification Message ID
SystemMessageNumber I_FailedGoodsMovementItem SystemMessageNumber Message Number
SystemMessageType I_FailedGoodsMovementItem SystemMessageType Message type
SystemMessageVariable1 I_FailedGoodsMovementItem SystemMessageVariable1 Variable 1
SystemMessageVariable2 I_FailedGoodsMovementItem SystemMessageVariable2 Variable 2
SystemMessageVariable3 I_FailedGoodsMovementItem SystemMessageVariable3 Variable 3
SystemMessageVariable4 I_FailedGoodsMovementItem SystemMessageVariable4 Variable 4
OrderID I_FailedGoodsMovementItem OrderID Order ID
OrderCategory I_FailedGoodsMovementItem OrderCategory Order Category
Reservation I_FailedGoodsMovementItem Reservation Reservation
ReservationItem I_FailedGoodsMovementItem ReservationItem Reservation Item
RecordType I_FailedGoodsMovementItem RecordType Reservation Record Type
ConfirmationGroup I_FailedGoodsMovementItem ConfirmationGroup
ConfirmationCount I_FailedGoodsMovementItem ConfirmationCount
OrderInternalBillOfOperations I_FailedGoodsMovementItem OrderInternalID Plan No.f.Oper.
OrderIntBillOfOperationsItem I_FailedGoodsMovementItem OrderOperationInternalID Order Internal Bill of Operations Item
RepetitiveMfgConfirmation I_FailedGoodsMovementItem RepetitiveMfgConfirmation
MRPController I_FailedGoodsMovementItem MRPController MRP Controller
ProductionSupervisor I_FailedGoodsMovementItem ProductionSupervisor Prodn Supervisor
RecordIsFromMfgProcgExec I_FailedGoodsMovementItem RecordIsFromMfgProcgExec
SerialNumberAssgmtProfile I_FailedGoodsMovementItem SerialNumberAssgmtProfile
NumberOfSerialNumbers I_FailedGoodsMovementItem NumberOfSerialNumbers No.serial no.
ShopFloorItem I_FailedGoodsMovementItem ShopFloorItem Serial.Mat. ID
SerialNumber I_FailedGoodsMovementItem SerialNumber Serial Number
GdsMvtExcptnDepdntItemGroup I_FailedGoodsMovementItem GdsMvtExcptnDepdntItemGroup
PostingDate I_FailedGoodsMovementItem PostingDate Posting Date for GR
DocumentDate I_FailedGoodsMovementItem DocumentDate Journal Entry Date
GoodsMovementEntryUnit I_FailedGoodsMovementItem GoodsMovementEntryUnit Unit of Entry
GoodsMovementEntryQty I_FailedGoodsMovementItem GoodsMovementEntryQty
_GoodsMovementException _GoodsMovementException
_CreatedByUser _CreatedByUser
_ChangedByUser _ChangedByUser
_LogisticsOrder _LogisticsOrder
_OrderCategory _OrderCategory
_OrderInternalID _OrderInternalID
_MRPController _MRPController
_ProductionSupervisor _ProductionSupervisor
_ShopFloorItem _ShopFloorItem
_ConfirmationGroup _ConfirmationGroup
_ConfirmationCount _ConfirmationCount
_RepetitiveMfgConfirmation _RepetitiveMfgConfirmation
_Reservation _Reservation
_Material _Material
_Plant _Plant
_StorageLocation _StorageLocation
_Batch _Batch
_GoodsMovementType _GoodsMovementType
_GoodsMovementReasonCode _GoodsMovementReasonCode
_InventorySpecialStockType _InventorySpecialStockType
_InventoryValuationType _InventoryValuationType
_InventoryUsabilityCode _InventoryUsabilityCode
_DebitCreditCode _DebitCreditCode
_SalesOrder _SalesOrder
_SalesOrderItem _SalesOrderItem
_WBSElement _WBSElement
_Supplier _Supplier
_Customer _Customer
_SupplierCompanyByPlant _SupplierCompanyByPlant
_CustomerCompanyByPlant _CustomerCompanyByPlant
_SupplyArea _ProductionSupplyArea
_Warehouse _Warehouse
_PostingDate _PostingDate
_DocumentDate _DocumentDate
_EntryUnit _EntryUnit

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_MfgGoodsMovementExcptnTP.
-- 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.
-- SQL view name: IMFGGMETP

CREATE VIEW I_MfgGoodsMovementExcptnTP AS
SELECT
  igmei.FailedGoodsMovement AS GoodsMovementException,
  igmei.FailedGoodsMovementItem AS GoodsMovementExceptionItem,
  igmei.CreationDate AS CreationDate,
  igmei.CreationTime AS CreationTime,
  igmei.CreatedByUser AS CreatedByUser,
  igmei.LastChangeDate AS LastChangeDate,
  igmei.LastChangedByUser AS LastChangedByUser,
  igmei.Material AS Material,
  igmei._Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  igmei.Plant AS Plant,
  igmei.StorageLocation AS StorageLocation,
  igmei._StorageLocation.StorageLocationName AS StorageLocationName,
  igmei.Batch AS Batch,
  igmei.GoodsMovementType AS GoodsMovementType,
  igmei.GoodsMovementReasonCode AS GoodsMovementReasonCode,
  igmei.InventorySpecialStockType AS InventorySpecialStockType,
  igmei.InventoryUsabilityCode AS InventoryUsabilityCode,
  igmei.GoodsMovementRefDocType AS GoodsMovementRefDocType,
  igmei.DebitCreditCode AS DebitCreditCode,
  igmei.ConsumptionPosting AS ConsumptionPosting,
  igmei.InventoryValuationType AS InventoryValuationType,
  igmei.SalesOrder AS SalesOrder,
  igmei.SalesOrderItem AS SalesOrderItem,
  igmei.WBSElementInternalID AS WBSElementInternalID,
  igmei.Supplier AS Supplier,
  igmei.Customer AS Customer,
  igmei.GoodsRecipientName AS GoodsRecipientName,
  igmei.UnloadingPointName AS UnloadingPointName,
  igmei.IsCompletelyDelivered AS IsCompletelyDelivered,
  igmei.ReservationIsFinallyIssued AS ReservationIsFinallyIssued,
  igmei.ProductionSupplyArea AS SupplyArea,
  igmei.MaterialStaging AS MaterialStaging,
  igmei.Warehouse AS Warehouse,
  igmei.StorageType AS StorageType,
  igmei.StorageBin AS StorageBin,
  igmei.ErrorOccurrenceDate AS ErrorOccurrenceDate,
  igmei.ErrorOccurrenceTime AS ErrorOccurrenceTime,
  igmei.SystemMessageIdentification AS SystemMessageIdentification,
  igmei.SystemMessageNumber AS SystemMessageNumber,
  igmei.SystemMessageType AS SystemMessageType,
  igmei.SystemMessageVariable1 AS SystemMessageVariable1,
  igmei.SystemMessageVariable2 AS SystemMessageVariable2,
  igmei.SystemMessageVariable3 AS SystemMessageVariable3,
  igmei.SystemMessageVariable4 AS SystemMessageVariable4,
  igmei.OrderID AS OrderID,
  igmei.OrderCategory AS OrderCategory,
  igmei.Reservation AS Reservation,
  igmei.ReservationItem AS ReservationItem,
  igmei.RecordType AS RecordType,
  igmei.ConfirmationGroup AS ConfirmationGroup,
  igmei.ConfirmationCount AS ConfirmationCount,
  igmei.OrderInternalID AS OrderInternalBillOfOperations,
  igmei.OrderOperationInternalID AS OrderIntBillOfOperationsItem,
  igmei.RepetitiveMfgConfirmation AS RepetitiveMfgConfirmation,
  igmei.MRPController AS MRPController,
  igmei.ProductionSupervisor AS ProductionSupervisor,
  igmei.RecordIsFromMfgProcgExec AS RecordIsFromMfgProcgExec,
  igmei.SerialNumberAssgmtProfile AS SerialNumberAssgmtProfile,
  igmei.NumberOfSerialNumbers AS NumberOfSerialNumbers,
  igmei.ShopFloorItem AS ShopFloorItem,
  igmei.SerialNumber AS SerialNumber,
  igmei.GdsMvtExcptnDepdntItemGroup AS GdsMvtExcptnDepdntItemGroup,
  igmei.PostingDate AS PostingDate,
  igmei.DocumentDate AS DocumentDate,
  igmei.GoodsMovementEntryUnit AS GoodsMovementEntryUnit,
  igmei.GoodsMovementEntryQty AS GoodsMovementEntryQty
FROM I_FailedGoodsMovementItem AS igmei
LEFT OUTER JOIN I_ShopFloorItem AS _ShopFloorItem ON ShopFloorItem = _ShopFloorItem.ShopFloorItem  -- association [0..1]
;

Learn More