SEPMRA_I_SALESORDERITEMTP

CDS View

EPMRA: Transactional BO SalesOrderItem

SEPMRA_I_SALESORDERITEMTP is a CDS View in S/4HANA. EPMRA: Transactional BO SalesOrderItem. It contains 7 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
SEPMRA_C_SalesOrderItemTP view from Sales Order Item

Fields (7)

KeyField CDS FieldsUsed in Views
KEY SalesOrder SalesOrder 1
KEY SalesOrderItem SalesOrderItem 1
GrossAmountInTransacCurrency GrossAmountInTransacCurrency 1
NetAmountInTransactionCurrency NetAmountInTransactionCurrency 1
Product Product 1
TaxAmountInTransactionCurrency TaxAmountInTransactionCurrency 1
TransactionCurrency TransactionCurrency 1

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.

-- EPMRA: Transactional BO SalesOrderItem
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SEPMRA_I_SALESORDERITEMTP (
    SALESORDER,
    SALESORDERITEM,
    GROSSAMOUNTINTRANSACCURRENCY,
    NETAMOUNTINTRANSACTIONCURRENCY,
    PRODUCT,
    TAXAMOUNTINTRANSACTIONCURRENCY,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (SALESORDER, SALESORDERITEM)
);