I_ProcOrdOpsMgmtGoodsMovement

DDL: I_PROCORDOPSMGMTGOODSMOVEMENT SQL: IPRCORDOPMTGDSMT Type: view COMPOSITE Package: VDM_PP_PROC_ORD_MNG
31 Fields 1 Data Sources 1 Associations

Process Order Operation Goods Movement

I_ProcOrdOpsMgmtGoodsMovement is a Composite CDS View that provides data about "Process Order Operation Goods Movement" in SAP S/4HANA. It reads from 1 data source (P_ProcOrdOpsMgmtGoodsMovement) and exposes 31 fields with key fields MaterialDocument, MaterialDocumentYear, MaterialDocumentItem. It has 1 association to related views. Part of development package VDM_PP_PROC_ORD_MNG.

Data Sources (1)

SourceAliasJoin Type
P_ProcOrdOpsMgmtGoodsMovement _Document from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Batch _Batch $projection.Material = _Batch.Material and $projection.Plant = _Batch.Plant and $projection.Batch = _Batch.Batch

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IPRCORDOPMTGDSMT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Process Order Operation Goods Movement view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #CLIENT_DEPENDENT view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocument MaterialDocument Material Doc.
KEY MaterialDocumentYear MaterialDocumentYear Material Document Year
KEY MaterialDocumentItem MaterialDocumentItem Material Document Item
OrderInternalBillOfOperations OrderInternalBillOfOperations Order Internal Bill of Operations
ManufacturingOrderOperation
ProcessOrder ProcessOrder Order
ManufacturingOrderItem ManufacturingOrderItem Manufacturing Order Item
ManufacturingOrderCategory P_ProcOrdOpsMgmtGoodsMovement ManufacturingOrderCategory
ManufacturingOrderType P_ProcOrdOpsMgmtGoodsMovement ManufacturingOrderType
ProductionPlant P_ProcOrdOpsMgmtGoodsMovement ProductionPlant Prod plnt
ProductionSupervisor _Op ProductionSupervisor Prodn Supervisor
Plant P_ProcOrdOpsMgmtGoodsMovement Plant Valuation Area
PlantName PlantName Plant Name
GoodsMovementType GoodsMovementType Movement Type
GoodsMovementTypeName GoodsMovementTypeName
Material P_ProcOrdOpsMgmtGoodsMovement Material Vehicle Model
MaterialName MaterialName Material Description
PostingDate PostingDate Posting Date for GR
QuantityInBaseUnit QuantityInBaseUnit Quantity
BaseUnit BaseUnit Unit of Measure
EntryUnit EntryUnit Unit of Entry
QuantityInEntryUnit QuantityInEntryUnit Quantity in Unit of Entry
Batch Batch Lot No.
BatchShortDescription
BatchForEdit BatchForEdit Lot No.
MaterialForEdit MaterialForEdit Product
PlantForEdit PlantForEdit Plant ID
DefinitionOfBatchLevel _Batch DefinitionOfBatchLevel
StorageLocation StorageLocation StorageLocation
StorageLocationName StorageLocationName Storage Loc. Name
toparent_ProcOrdOpMgmt

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_ProcOrdOpsMgmtGoodsMovement.
-- 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: IPRCORDOPMTGDSMT

CREATE VIEW I_ProcOrdOpsMgmtGoodsMovement AS
SELECT
  MaterialDocument,
  MaterialDocumentYear,
  MaterialDocumentItem,
  OrderInternalBillOfOperations,
  cast(_Op.ManufacturingOrderOperation as text4 preserving type ) AS ManufacturingOrderOperation,
  ProcessOrder,
  ManufacturingOrderItem,
  _Document.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  _Document.ManufacturingOrderType AS ManufacturingOrderType,
  _Document.ProductionPlant AS ProductionPlant,
  _Op.ProductionSupervisor AS ProductionSupervisor,
  _Document.Plant AS Plant,
  PlantName,
  GoodsMovementType,
  GoodsMovementTypeName,
  _Document.Material AS Material,
  MaterialName,
  PostingDate,
  QuantityInBaseUnit,
  BaseUnit,
  EntryUnit,
  QuantityInEntryUnit,
  Batch,
  cast(' ' as kztxt_batch preserving type) AS BatchShortDescription,
  BatchForEdit,
  MaterialForEdit,
  PlantForEdit,
  _Batch.DefinitionOfBatchLevel AS DefinitionOfBatchLevel,
  StorageLocation,
  StorageLocationName
FROM P_ProcOrdOpsMgmtGoodsMovement AS _Document
LEFT OUTER JOIN I_Batch AS _Batch ON Material = _Batch.Material AND Plant = _Batch.Plant AND Batch = _Batch.Batch  -- association [0..1]
;

Learn More