I_Productsupplierean

DDL: I_PRODUCTSUPPLIEREAN SQL: IPRDSUPLREAN Type: view BASIC Package: VDM_MD_PRODUCT
13 Fields 1 Data Sources 5 Associations

Product Supplier EAN Active Core Entity

I_Productsupplierean is a Basic CDS View that provides data about "Product Supplier EAN Active Core Entity" in SAP S/4HANA. It reads from 1 data source (mlea) and exposes 13 fields with key fields Product, ProductUnit, Supplier, SequenceNumber, AlternativeUnit. It has 5 associations to related views. Part of development package VDM_MD_PRODUCT.

Data Sources (1)

SourceAliasJoin Type
mlea mlea from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_Product _Product $projection.Product = _Product.Product
[0..1] I_UnitOfMeasure _AlternativeUnit $projection.AlternativeUnit = _AlternativeUnit.UnitOfMeasure
[0..1] I_UnitOfMeasure _ProductUnit $projection.ProductUnit = _ProductUnit.UnitOfMeasure
[0..*] I_ProductDescription_2 _ProductDescription $projection.Product = _ProductDescription.Product
[0..*] I_UnitOfMeasureText _AlternativeUnitText $projection.AlternativeUnit = _AlternativeUnitText.UnitOfMeasure

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName IPRDSUPLREAN view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Product Supplier EAN Active Core Entity view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY Product mlea matnr Vehicle Model
KEY ProductUnit mlea meinh Unit of Measure
KEY Supplier mlea lifnr Vendor no.
KEY SequenceNumber mlea lfnum Sequence no.
KEY AlternativeUnit mlea meinh Unit of Measure
GlobalTradeItemNumber mlea ean11 EAN/UPC
IsSupplierMainGTINIndicator mlea lfean Main EAN of vdr
SupplierProduct mlea lartn Supp. Mat. No.
_Product _Product
_AlternativeUnit _AlternativeUnit
_ProductUnit _ProductUnit
_ProductDescription _ProductDescription
_AlternativeUnitText _AlternativeUnitText

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 I_Productsupplierean.
-- 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: IPRDSUPLREAN

CREATE VIEW I_Productsupplierean AS
SELECT
  mlea.matnr AS Product,
  mlea.meinh AS ProductUnit,
  mlea.lifnr AS Supplier,
  mlea.lfnum AS SequenceNumber,
  mlea.meinh AS AlternativeUnit,
  mlea.ean11 AS GlobalTradeItemNumber,
  mlea.lfean AS IsSupplierMainGTINIndicator,
  mlea.lartn AS SupplierProduct
FROM mlea
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _AlternativeUnit ON AlternativeUnit = _AlternativeUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ProductUnit ON ProductUnit = _ProductUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_ProductDescription_2 AS _ProductDescription ON Product = _ProductDescription.Product  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _AlternativeUnitText ON AlternativeUnit = _AlternativeUnitText.UnitOfMeasure  -- association [0..*]
;

Learn More