V_Mmim_Ddl_Om_Or_Email

DDL: V_MMIM_DDL_OM_OR_EMAIL SQL: V_MMIM_OR_EMAIL Type: view
18 Fields 3 Data Sources

Output Management E-Mail

V_Mmim_Ddl_Om_Or_Email is a CDS View that provides data about "Output Management E-Mail" in SAP S/4HANA. It reads from 3 data sources (I_AddressPersonName, I_MaterialDocumentRecord, I_User) and exposes 18 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 Batch Batch Number CalendarDay Calendar Day CalendarMonth Calendar Month CalendarYear Calendar Year FullNameOfPerson Full Name of Person Material Material Number MaterialDocument Number of Material Document MaterialDocumentItem Material Document Item MaterialDocumentYear Material Document Year OrderQuantity Quantity in Purchase Order Price Unit OrderUnitOfMeasure Order Price Unit (Purchasing) Plant Plant PurchaseOrder Purchase Order Number PurchaseOrderItem Item Number of Purchasing Document Quantity Unit of entry StorageLocation Storage Location UnitOfMeasure Quantity in unit of entry Vendor Supplier's Account Number

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_EMAIL 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 view

Fields (18)

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
Material I_MaterialDocumentRecord Material Vehicle Model
Plant I_MaterialDocumentRecord Plant Valuation Area
StorageLocation I_MaterialDocumentRecord StorageLocation StorageLocation
Batch I_MaterialDocumentRecord Batch Lot No.
Quantity I_MaterialDocumentRecord EntryUnit Unit of Entry
UnitOfMeasure I_MaterialDocumentRecord QuantityInEntryUnit Quantity in Unit of Entry
OrderQuantity I_MaterialDocumentRecord QtyInPurchaseOrderPriceUnit Qty in OPUn
OrderUnitOfMeasure I_MaterialDocumentRecord OrderPriceUnit Order Price Un.
Vendor I_MaterialDocumentRecord Supplier Supplier
FullNameOfPerson I_AddressPersonName PersonFullName Full Name
CalendarDay
CalendarMonth
CalendarYear

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_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_EMAIL

CREATE VIEW V_Mmim_Ddl_Om_Or_Email AS
SELECT
  _MaterialDocumentRecord.MaterialDocument AS MaterialDocument,
  _MaterialDocumentRecord.MaterialDocumentYear AS MaterialDocumentYear,
  _MaterialDocumentRecord.MaterialDocumentItem AS MaterialDocumentItem,
  _MaterialDocumentRecord.PurchaseOrder AS PurchaseOrder,
  _MaterialDocumentRecord.PurchaseOrderItem AS PurchaseOrderItem,
  _MaterialDocumentRecord.Material AS Material,
  _MaterialDocumentRecord.Plant AS Plant,
  _MaterialDocumentRecord.StorageLocation AS StorageLocation,
  _MaterialDocumentRecord.Batch AS Batch,
  _MaterialDocumentRecord.EntryUnit AS Quantity,
  _MaterialDocumentRecord.QuantityInEntryUnit AS UnitOfMeasure,
  _MaterialDocumentRecord.QtyInPurchaseOrderPriceUnit AS OrderQuantity,
  _MaterialDocumentRecord.OrderPriceUnit AS OrderUnitOfMeasure,
  _MaterialDocumentRecord.Supplier AS Vendor,
  _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
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