P_MaterialDocumentMigration

DDL: P_MATERIALDOCUMENTMIGRATION SQL: PMMMATDOCMIG Type: view CONSUMPTION
9 Fields 2 Data Sources

Material Document for Migration

P_MaterialDocumentMigration is a Consumption CDS View that provides data about "Material Document for Migration" in SAP S/4HANA. It reads from 2 data sources (I_GoodsMovementType, I_MaterialDocumentRecord) and exposes 9 fields with key fields MaterialDocument, MaterialDocumentItem, MaterialDocumentYear.

Data Sources (2)

SourceAliasJoin Type
I_GoodsMovementType GoodsMovement inner
I_MaterialDocumentRecord MatDoc from

Parameters (1)

NameTypeDefault
P_PurchaseOrder ebeln

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PMMMATDOCMIG view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Material Document for Migration view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocument MaterialDocument Material Doc.
KEY MaterialDocumentItem MaterialDocumentItem Material Document Item
KEY MaterialDocumentYear MaterialDocumentYear Material Document Year
PurchaseOrder PurchaseOrder Purchasing Document
PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
QuantityInBaseUnit QuantityInBaseUnit Quantity
GoodsReceiptQtyInOrderUnit GoodsReceiptQtyInOrderUnit
PostingDate PostingDate Posting Date for GR
IsReversalMovementType I_MaterialDocumentRecord IsReversalMovementType RevMvmtTypeInd.

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_MaterialDocumentMigration.
-- 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: PMMMATDOCMIG
-- Parameters: P_PurchaseOrder : ebeln

CREATE VIEW P_MaterialDocumentMigration AS
SELECT
  MaterialDocument,
  MaterialDocumentItem,
  MaterialDocumentYear,
  PurchaseOrder,
  PurchaseOrderItem,
  QuantityInBaseUnit,
  GoodsReceiptQtyInOrderUnit,
  PostingDate,
  MatDoc.IsReversalMovementType AS IsReversalMovementType
FROM I_MaterialDocumentRecord AS MatDoc
INNER JOIN I_GoodsMovementType AS GoodsMovement ON /* join condition not captured in parsed metadata */
;

Learn More