SEPM_I_SALESORDERITEM

CDS View
10 Fields 11 CDS Views

EPM Demo: Sales Order Item

SEPM_I_SALESORDERITEM is a CDS View in S/4HANA. EPM Demo: Sales Order Item. It contains 10 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
Repm_SalesOrderC view from Sales Order Cube View
Repm_Soi_Cube view from REPM_SOI_CUBE
SEPM_I_CI_ITEM_COMP_PID view left_outer COMPOSITE EPM Products composite view
SEPM_I_CI_ITEM_COMP_PR view left_outer COMPOSITE EPM Product Reviews composite view
SEPM_I_CustomerInvoiceItem_E view left_outer EPM Demo: Customer Invoice Item with External IDs
SEPM_I_SalesOrderItem_E view from EPM Demo: Sales Order Item with External IDs
SEPM_I_SalesOrderItem_E_V2 view from EPM Demo: SO Item and SL with Ext. IDs
SEPM_I_SalesOrderItemText_E view inner EPM Demo: SO Item Text with External IDs
SEPM_P_SalesOrderItemCube view from EPM Demo: Sales Order Item with Addtl. Data (private view)
SEPMRA_I_SlsOrdItemCubeBase view from Sales Order Item Cube
SEPMRA_P_OVW_LastSaleD000 view left_outer

Fields (10)

KeyField CDS FieldsUsed in Views
KEY SalesOrderItem SalesOrderItem 3
KEY SalesOrderItemUUID SalesOrderItemUUID 2
_ProductAvailabilityStatus _ProductAvailabilityStatus 4
_TransactionCurrency _TransactionCurrency 4
GrossAmountInTransacCurrency GrossAmountInTransacCurrency 4
NetAmountInTransactionCurrency NetAmountInTransactionCurrency 5
OpportunityItem OpportunityItem 4
ProductAvailabilityStatus ProductAvailabilityStatus 4
TaxAmountInTransactionCurrency TaxAmountInTransactionCurrency 5
TransactionCurrency TransactionCurrency 5

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- EPM Demo: Sales Order Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SEPM_I_SALESORDERITEM (
    SALESORDERITEM,
    SALESORDERITEMUUID,
    _PRODUCTAVAILABILITYSTATUS,
    _TRANSACTIONCURRENCY,
    GROSSAMOUNTINTRANSACCURRENCY,
    NETAMOUNTINTRANSACTIONCURRENCY,
    OPPORTUNITYITEM,
    PRODUCTAVAILABILITYSTATUS,
    TAXAMOUNTINTRANSACTIONCURRENCY,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (SALESORDERITEM, SALESORDERITEMUUID)
);

Learn More