V_Mmim_Ddl_Om_Or_GR4PO_EMAIL

DDL: V_MMIM_DDL_OM_OR_GR4PO_EMAIL SQL: V_MMIM_OR_GR4PO Type: view
11 Fields 3 Data Sources

Output Management E-Mail GR4PO

V_Mmim_Ddl_Om_Or_GR4PO_EMAIL is a CDS View that provides data about "Output Management E-Mail GR4PO" in SAP S/4HANA. It reads from 3 data sources (I_AddressPersonName, I_MaterialDocumentRecord, I_User) and exposes 11 fields with key fields MaterialDocument, MaterialDocumentYear, MaterialDocumentItem.

SAP Help Documentation

CategoryCDS Views for E-Mail Template Notifications
Purpose
This CDS view provides a list of fields to describe an activity in a compliance scenario and can be used as a template to build the content of different e-mail notifications. To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations No special authorizations are required to use this CDS view.

Structure
Important Fields Important fields in this view include the following: Field Name Description CalendarDay Calendar Day CalendarMonth Calendar Month CalendarYear Calendar Year ClientID Client ID FullNameOfPerson Full Name of Person MaterialDocument Number of Material Document MaterialDocumentItem Material Document Item MaterialDocumentYear Material Document Year PurchaseOrder Purchase Order Number PurchaseOrderItem Item Number of Purchasing Document SystemID System ID

View on SAP Help Portal →

Data Sources (3)

SourceAliasJoin Type
I_AddressPersonName _AddressPersonName left_outer
I_MaterialDocumentRecord _MaterialDocumentRecord from
I_User _User left_outer

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName V_MMIM_OR_GR4PO view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.modelingPattern #OUTPUT_EMAIL_DATA_PROVIDER view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Output Management E-Mail GR4PO view

Fields (11)

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
PurchaseOrder I_MaterialDocumentRecord PurchaseOrder Purchasing Document
PurchaseOrderItem I_MaterialDocumentRecord PurchaseOrderItem Purchasing Document Item
FullNameOfPerson I_AddressPersonName PersonFullName Full Name
CalendarDay
CalendarMonth
CalendarYear
SystemID
ClientID

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 V_Mmim_Ddl_Om_Or_GR4PO_EMAIL.
-- 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: V_MMIM_OR_GR4PO

CREATE VIEW V_Mmim_Ddl_Om_Or_GR4PO_EMAIL AS
SELECT
  _MaterialDocumentRecord.MaterialDocument AS MaterialDocument,
  _MaterialDocumentRecord.MaterialDocumentYear AS MaterialDocumentYear,
  _MaterialDocumentRecord.MaterialDocumentItem AS MaterialDocumentItem,
  _MaterialDocumentRecord.PurchaseOrder AS PurchaseOrder,
  _MaterialDocumentRecord.PurchaseOrderItem AS PurchaseOrderItem,
  _AddressPersonName.PersonFullName AS FullNameOfPerson,
  substring(_MaterialDocumentRecord.CreationDate, 7, 2) AS CalendarDay,
  substring(_MaterialDocumentRecord.CreationDate, 5, 2) AS CalendarMonth,
  substring(_MaterialDocumentRecord.CreationDate, 1, 4) AS CalendarYear,
  substring(_MaterialDocumentRecord.LogicalSystem, 1, 3) AS SystemID,
  substring(_MaterialDocumentRecord.LogicalSystem, 8, 3) AS ClientID
FROM I_MaterialDocumentRecord AS _MaterialDocumentRecord
LEFT OUTER JOIN I_User AS _User ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AddressPersonName AS _AddressPersonName ON /* join condition not captured in parsed metadata */
;

Learn More