SEPM_C_RAMP_ProductDraft

DDL: SEPM_C_RAMP_PRODUCTDRAFT Type: view Package: S_EPM_REF_APPS_PROD_MAN_ODATA
30 Fields 1 Data Sources 2 Associations

Product Draft

SEPM_C_RAMP_ProductDraft is a CDS View that provides data about "Product Draft" in SAP S/4HANA. It reads from 1 data source (SEPM_I_ProductDraft) and exposes 30 fields with key field Id. It has 2 associations to related views. Part of development package S_EPM_REF_APPS_PROD_MAN_ODATA.

Data Sources (1)

SourceAliasJoin Type
SEPM_I_ProductDraft draft from

Associations (2)

CardinalityTargetAliasCondition
[0..*] SEPM_C_RAMP_ImageDraft _Images $projection.ProductDraftUUID = _Images.ProductDraftUUID
[1..1] SEPM_C_RAMP_Category _SubCategory $projection.SubCategoryId = _SubCategory.Id

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName SEPM_CMPPRODDRFT view
AbapCatalog.compiler.compareFilter true view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.compositionRoot true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Product Draft view
Search.searchable true view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY Id SEPM_I_ProductDraft Product Product Sold
ProductDraftUUID SEPM_I_ProductDraft ProductDraftUUID Key
ProductId SEPM_I_ProductDraft Product Product Sold
Name SEPM_I_ProductDraft ProductName Description
Description SEPM_I_ProductDraft ProductDescription Description
DimensionUnit SEPM_I_ProductDraft DimensionUnit Unit of length
DimensionHeight SEPM_I_ProductDraft Height Height
DimensionWidth SEPM_I_ProductDraft Width Width
DimensionDepth SEPM_I_ProductDraft Depth Draught
WeightUnit SEPM_I_ProductDraft WeightUnit Weight unit
WeightMeasure SEPM_I_ProductDraft Weight Weight Used
Price SEPM_I_ProductDraft Price RVP f.PricePro.
CurrencyCode SEPM_I_ProductDraft Currency Valuation Crcy
QuantityUnit SEPM_I_ProductDraft ProductBaseUnit Unit of Measure
ImageUrl SEPM_I_ProductDraft ProductPictureURL Image
SupplierId SEPM_I_ProductDraft Supplier Supplier
SupplierName
SubCategoryId SEPM_I_ProductDraft ProductCategory Prod Category
SubCategoryName _SubCategory Name Zone name
MainCategoryId SEPM_I_ProductDraft ProductMainCategory Main Category
MainCategoryName SEPM_I_ProductDraft ProductMainCategory Main Category
CreatedAt SEPM_I_ProductDraft CreationDateTime Timestamp
CreatedBy SEPM_I_ProductDraft CreatedByUser User Name
LastModified SEPM_I_ProductDraft LastChangedDateTime Time Stamp
ExpiresAt SEPM_I_ProductDraft ExpirationDateTime Time Stamp
IsNewProduct SEPM_I_ProductDraft IsNewProduct
IsDirty SEPM_I_ProductDraft IsDirty Boolean Variable (X = True, - = False, Space = Unknown)
_Images _Images
_SubCategory _SubCategory
_Supplier _Supplier

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 SEPM_C_RAMP_ProductDraft.
-- 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 SEPM_C_RAMP_ProductDraft AS
SELECT
  draft.Product AS Id,
  draft.ProductDraftUUID AS ProductDraftUUID,
  draft.Product AS ProductId,
  draft.ProductName AS Name,
  draft.ProductDescription AS Description,
  draft.DimensionUnit AS DimensionUnit,
  draft.Height AS DimensionHeight,
  draft.Width AS DimensionWidth,
  draft.Depth AS DimensionDepth,
  draft.WeightUnit AS WeightUnit,
  draft.Weight AS WeightMeasure,
  draft.Price AS Price,
  draft.Currency AS CurrencyCode,
  draft.ProductBaseUnit AS QuantityUnit,
  draft.ProductPictureURL AS ImageUrl,
  draft.Supplier AS SupplierId,
  draft._Supplier.CompanyName AS SupplierName,
  draft.ProductCategory AS SubCategoryId,
  _SubCategory.Name AS SubCategoryName,
  draft.ProductMainCategory AS MainCategoryId,
  draft.ProductMainCategory AS MainCategoryName,
  draft.CreationDateTime AS CreatedAt,
  draft.CreatedByUser AS CreatedBy,
  draft.LastChangedDateTime AS LastModified,
  draft.ExpirationDateTime AS ExpiresAt,
  draft.IsNewProduct AS IsNewProduct,
  draft.IsDirty AS IsDirty
FROM SEPM_I_ProductDraft AS draft
LEFT OUTER JOIN SEPM_C_RAMP_ImageDraft AS _Images ON ProductDraftUUID = _Images.ProductDraftUUID  -- association [0..*]
LEFT OUTER JOIN SEPM_C_RAMP_Category AS _SubCategory ON SubCategoryId = _SubCategory.Id  -- association [1..1]
;

Learn More