SEPM_P_SalesOrderItemCube

DDL: SEPM_P_SALESORDERITEMCUBE SQL: SEPM_PSOIC Type: view Package: S_EPM_CDS_REF
36 Fields 1 Data Sources 6 Associations

EPM Demo: Sales Order Item with Addtl. Data (private view)

SEPM_P_SalesOrderItemCube is a CDS View of category Cube that provides data about "EPM Demo: Sales Order Item with Addtl. Data (private view)" in SAP S/4HANA. It reads from 1 data source (SEPM_I_SalesOrderItem) and exposes 36 fields with key fields SalesOrder, SalesOrderItem. It has 6 associations to related views. Part of development package S_EPM_CDS_REF.

Data Sources (1)

SourceAliasJoin Type
SEPM_I_SalesOrderItem SEPM_I_SalesOrderItem from

Parameters (1)

NameTypeDefault
P_DisplayCurrency snwd_curr_code

Associations (6)

CardinalityTargetAliasCondition
[0..*] SEPM_I_SalesOrderItemText_E _ItemText $projection.salesorder = _ItemText.SalesOrder and $projection.SalesOrderItem = _ItemText.SalesOrderItem
[0..1] SEPM_I_SalesOrder_E _SalesOrder_E $projection.salesorder = _SalesOrder_E.SalesOrder
[0..1] SEPM_I_Product_E _Product_E $projection.product = _Product_E.Product
[0..1] SEPM_I_BusinessPartner_E _Customer_E $projection.Customer = _Customer_E.BusinessPartner
[0..1] SEPM_I_BusinessPartner_E _Supplier_E $projection.Supplier = _Supplier_E.BusinessPartner
[0..1] SEPM_I_Currency _DisplayCurrency $projection.DisplayCurrency = _DisplayCurrency.Currency

Annotations (5)

NameValueLevelField
EndUserText.label EPM Demo: Sales Order Item with Addtl. Data (private view) view
Analytics.dataCategory #CUBE view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName SEPM_PSOIC view
ObjectModel.representativeKey SalesOrderItem view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder _SalesOrder SalesOrder SD Document
_SalesOrder_E _SalesOrder_E
KEY SalesOrderItem SalesOrderItem Sales Order Item
_ItemText _ItemText
Product _Product Product Product Sold
_Product_E _Product_E
ProductAvailabilityStatus ProductAvailabilityStatus ATP Status
_ProductAvailabilityStatus _ProductAvailabilityStatus
TransactionCurrency TransactionCurrency Transaction Currency
_TransactionCurrency _TransactionCurrency
GrossAmountInTransacCurrency GrossAmountInTransacCurrency Tax-Inclusive Amount
NetAmountInTransactionCurrency NetAmountInTransactionCurrency Tax-Exclusive Amount
TaxAmountInTransactionCurrency TaxAmountInTransactionCurrency VAT Amount Type
DisplayCurrency
_DisplayCurrency _DisplayCurrency
Quantity _ScheduleLine Quantity Value
QuantityUnit _ScheduleLine QuantityUnit Unit of measure
_QuantityUnit _ScheduleLine _QuantityUnit
CreationDateTime _SalesOrder CreationDateTime Timestamp
LastChangeDateTime _SalesOrder LastChangedDateTime Time Stamp
Customer
_Customer_E _Customer_E
SalesOrderLifeCycleStatus _SalesOrder SalesOrderLifeCycleStatus
_LifeCycleStatus _SalesOrder _LifeCycleStatus
SalesOrderBillingStatus _SalesOrder SalesOrderBillingStatus
_BillingStatus _SalesOrder _BillingStatus
SalesOrderDeliveryStatus _SalesOrder SalesOrderDeliveryStatus
_DeliveryStatus _SalesOrder _DeliveryStatus
ProductType _Product ProductType Product Type Group
_ProductType _Product _ProductType
ProductCategory _Product ProductCategory Prod Category
_ProductCategory _Product _ProductCategory
ProductValueAddedTax _Product ProductValueAddedTax
_ProductValueAddedTax _Product _ProductValueAddedTax
Supplier
_Supplier_E _Supplier_E

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_P_SalesOrderItemCube.
-- 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: SEPM_PSOIC
-- Parameters: P_DisplayCurrency : snwd_curr_code

CREATE VIEW SEPM_P_SalesOrderItemCube AS
SELECT
  _SalesOrder.SalesOrder AS SalesOrder,
  SalesOrderItem,
  _Product.Product AS Product,
  ProductAvailabilityStatus,
  TransactionCurrency,
  GrossAmountInTransacCurrency,
  NetAmountInTransactionCurrency,
  TaxAmountInTransactionCurrency,
  $parameters.P_DisplayCurrency AS DisplayCurrency,
  _ScheduleLine.Quantity AS Quantity,
  _ScheduleLine.QuantityUnit AS QuantityUnit,
  _ScheduleLine._QuantityUnit AS _QuantityUnit,
  _SalesOrder.CreationDateTime AS CreationDateTime,
  _SalesOrder.LastChangedDateTime AS LastChangeDateTime,
  _SalesOrder._Customer.BusinessPartner AS Customer,
  _SalesOrder.SalesOrderLifeCycleStatus AS SalesOrderLifeCycleStatus,
  _SalesOrder._LifeCycleStatus AS _LifeCycleStatus,
  _SalesOrder.SalesOrderBillingStatus AS SalesOrderBillingStatus,
  _SalesOrder._BillingStatus AS _BillingStatus,
  _SalesOrder.SalesOrderDeliveryStatus AS SalesOrderDeliveryStatus,
  _SalesOrder._DeliveryStatus AS _DeliveryStatus,
  _Product.ProductType AS ProductType,
  _Product._ProductType AS _ProductType,
  _Product.ProductCategory AS ProductCategory,
  _Product._ProductCategory AS _ProductCategory,
  _Product.ProductValueAddedTax AS ProductValueAddedTax,
  _Product._ProductValueAddedTax AS _ProductValueAddedTax,
  _Product._Supplier.BusinessPartner AS Supplier
FROM SEPM_I_SalesOrderItem
LEFT OUTER JOIN SEPM_I_SalesOrderItemText_E AS _ItemText ON salesorder = _ItemText.SalesOrder AND SalesOrderItem = _ItemText.SalesOrderItem  -- association [0..*]
LEFT OUTER JOIN SEPM_I_SalesOrder_E AS _SalesOrder_E ON salesorder = _SalesOrder_E.SalesOrder  -- association [0..1]
LEFT OUTER JOIN SEPM_I_Product_E AS _Product_E ON product = _Product_E.Product  -- association [0..1]
LEFT OUTER JOIN SEPM_I_BusinessPartner_E AS _Customer_E ON Customer = _Customer_E.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN SEPM_I_BusinessPartner_E AS _Supplier_E ON Supplier = _Supplier_E.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN SEPM_I_Currency AS _DisplayCurrency ON DisplayCurrency = _DisplayCurrency.Currency  -- association [0..1]
;

Learn More