C_MKT_CntntPlugInIntactnProd

DDL: C_MKT_CNTNTPLUGININTACTNPROD Type: view_entity CONSUMPTION
12 Fields 1 Data Sources 1 Associations

Email: Interaction Product Plugin

C_MKT_CntntPlugInIntactnProd is a Consumption CDS View that provides data about "Email: Interaction Product Plugin" in SAP S/4HANA. It reads from 1 data source (I_MKT_InteractionProduct) and exposes 12 fields with key field InteractionProductUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_MKT_InteractionProduct InteractionProduct from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_MKT_IA_PRODUCT _ExtensionInteractionProduct $projection.InteractionProductUUID = _ExtensionInteractionProduct.InteractionProduct

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Email: Interaction Product Plugin view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #CONSUMPTION view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY InteractionProductUUID I_MKT_InteractionProduct InteractionProductUUID
InteractionUUID I_MKT_InteractionProduct InteractionUUID NodeID
InteractionProdWeightingFactor I_MKT_InteractionProduct InteractionProdWeightingFactor
InteractionProductAmount I_MKT_InteractionProduct InteractionProductAmount Value Amount
InteractionProductQuantity I_MKT_InteractionProduct InteractionProductQuantity Value
InteractionProductUnit I_MKT_InteractionProduct InteractionProductUnit Unit of Measure
UnitOfMeasureName
InteractionProductStatus I_MKT_InteractionProduct InteractionProductStatus
InteractionProductReason I_MKT_InteractionProduct InteractionProductReason
ProductName I_MKT_InteractionProduct ProductName Description
Currency I_MKT_InteractionProduct Currency Valuation Crcy
CurrencyName

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 C_MKT_CntntPlugInIntactnProd.
-- 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.

CREATE VIEW C_MKT_CntntPlugInIntactnProd AS
SELECT
  InteractionProduct.InteractionProductUUID AS InteractionProductUUID,
  InteractionProduct.InteractionUUID AS InteractionUUID,
  InteractionProduct.InteractionProdWeightingFactor AS InteractionProdWeightingFactor,
  InteractionProduct.InteractionProductAmount AS InteractionProductAmount,
  InteractionProduct.InteractionProductQuantity AS InteractionProductQuantity,
  InteractionProduct.InteractionProductUnit AS InteractionProductUnit,
  InteractionProduct._UnitOfMeasure._Text[1: Language = $session.system_language].UnitOfMeasureName AS UnitOfMeasureName,
  InteractionProduct.InteractionProductStatus AS InteractionProductStatus,
  InteractionProduct.InteractionProductReason AS InteractionProductReason,
  InteractionProduct.ProductName AS ProductName,
  InteractionProduct.Currency AS Currency,
  InteractionProduct._Currency._Text[1: Language = $session.system_language].CurrencyName AS CurrencyName
FROM I_MKT_InteractionProduct AS InteractionProduct
LEFT OUTER JOIN E_MKT_IA_PRODUCT AS _ExtensionInteractionProduct ON InteractionProductUUID = _ExtensionInteractionProduct.InteractionProduct  -- association [1..1]
;

Learn More