P_ProcOrdMgmtGoodsMovement

DDL: P_PROCORDMGMTGOODSMOVEMENT SQL: PPORGDMVMT Type: view COMPOSITE Package: VDM_PP_PROC_ORD_MNG
25 Fields 2 Data Sources

Process order goods movement

P_ProcOrdMgmtGoodsMovement is a Composite CDS View that provides data about "Process order goods movement" in SAP S/4HANA. It reads from 2 data sources (I_MaterialDocumentRecord, I_LogisticsOrder) and exposes 25 fields with key fields MaterialDocument, MaterialDocumentYear, MaterialDocumentItem. Part of development package VDM_PP_PROC_ORD_MNG.

Data Sources (2)

SourceAliasJoin Type
I_MaterialDocumentRecord _Document from
I_LogisticsOrder _ManufacturingOrder inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPORGDMVMT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocument I_MaterialDocumentRecord MaterialDocument Material Doc.
KEY MaterialDocumentYear I_MaterialDocumentRecord MaterialDocumentYear Material Document Year
KEY MaterialDocumentItem I_MaterialDocumentRecord MaterialDocumentItem Material Document Item
ProcessOrder I_MaterialDocumentRecord ManufacturingOrder Order
ManufacturingOrderCategory I_LogisticsOrder OrderCategory Order Category
ManufacturingOrderType I_LogisticsOrder OrderType Order Type
ProductionPlant I_LogisticsOrder Plant Valuation Area
ProductionSupervisor I_LogisticsOrder ProductionSupervisor Prodn Supervisor
Plant I_MaterialDocumentRecord Plant Valuation Area
PlantName
GoodsMovementType I_MaterialDocumentRecord GoodsMovementType Movement Type
PostingDate I_MaterialDocumentRecord PostingDate Posting Date for GR
QuantityInBaseUnit I_MaterialDocumentRecord QuantityInBaseUnit Quantity
Batch I_MaterialDocumentRecord Batch Lot No.
PlantForEdit I_MaterialDocumentRecord Plant Valuation Area
MaterialForEdit I_MaterialDocumentRecord Material Vehicle Model
BatchForEdit I_MaterialDocumentRecord Batch Lot No.
StorageLocation I_MaterialDocumentRecord StorageLocation StorageLocation
StorageLocationName
numc15astimestampendasCreationDateTime
BaseUnit I_MaterialDocumentRecord MaterialBaseUnit Valuation Unit
_OrderCategory I_LogisticsOrder _OrderCategory
_OrderType I_LogisticsOrder _OrderType
_Plant I_LogisticsOrder _Plant
_ProductionSupervisor I_LogisticsOrder _ProductionSupervisor

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 P_ProcOrdMgmtGoodsMovement.
-- 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: PPORGDMVMT

CREATE VIEW P_ProcOrdMgmtGoodsMovement AS
SELECT
  _Document.MaterialDocument AS MaterialDocument,
  _Document.MaterialDocumentYear AS MaterialDocumentYear,
  _Document.MaterialDocumentItem AS MaterialDocumentItem,
  _Document.ManufacturingOrder AS ProcessOrder,
  _ManufacturingOrder.OrderCategory AS ManufacturingOrderCategory,
  _ManufacturingOrder.OrderType AS ManufacturingOrderType,
  _ManufacturingOrder.Plant AS ProductionPlant,
  _ManufacturingOrder.ProductionSupervisor AS ProductionSupervisor,
  _Document.Plant AS Plant,
  _Document._Plant.PlantName AS PlantName,
  _Document.GoodsMovementType AS GoodsMovementType,
  _Document.PostingDate AS PostingDate,
  _Document.QuantityInBaseUnit AS QuantityInBaseUnit,
  _Document.Batch AS Batch,
  _Document.Plant AS PlantForEdit,
  _Document.Material AS MaterialForEdit,
  _Document.Batch AS BatchForEdit,
  _Document.StorageLocation AS StorageLocation,
  _Document._StorageLocation.StorageLocationName AS StorageLocationName,
  case _Document.CreationTime when '240000' then cast(cast(concat(_Document.CreationDate,cast('235959' as tims))as abap.numc(15)) as timestamp) else cast(cast(concat(_Document.CreationDate , _Document.CreationTime)as abap.numc(15)) as timestamp) end as CreationDateTime AS numc15astimestampendasCreationDateTime,
  _Document.MaterialBaseUnit AS BaseUnit,
  _ManufacturingOrder._OrderCategory AS _OrderCategory,
  _ManufacturingOrder._OrderType AS _OrderType,
  _ManufacturingOrder._Plant AS _Plant,
  _ManufacturingOrder._ProductionSupervisor AS _ProductionSupervisor
FROM I_MaterialDocumentRecord AS _Document
INNER JOIN I_LogisticsOrder AS _ManufacturingOrder ON /* join condition not captured in parsed metadata */
;

Learn More