SEPMRA_I_SALESORDERTP

CDS View
17 Fields 1 CDS Views

Sales Order with Draft

SEPMRA_I_SALESORDERTP is a CDS View in S/4HANA. Sales Order with Draft. It contains 17 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
SEPMRA_C_SalesOrderTP view from Sales Order

Fields (17)

KeyField CDS FieldsUsed in Views
KEY SalesOrder SalesOrder 1
BillToParty BillToParty 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
CreationDateTime CreationDateTime 1
CustomerContact CustomerContact 1
LastChangedByUser LastChangedByUser 1
LastChangedDate LastChangedDate 1
LastChangedDateTime LastChangedDateTime 1
NetAmountInTransactionCurrency NetAmountInTransactionCurrency 1
Quantity Quantity 1
SalesOrderOverallStatus SalesOrderOverallStatus 1
SalesOrderPaymentMethod SalesOrderPaymentMethod 1
SalesOrderPaymentTerms SalesOrderPaymentTerms 1
ShipToParty ShipToParty 1
SoldToParty SoldToParty 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.

-- Sales Order with Draft
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SEPMRA_I_SALESORDERTP (
    SALESORDER,
    BILLTOPARTY,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONDATETIME,
    CUSTOMERCONTACT,
    LASTCHANGEDBYUSER,
    LASTCHANGEDDATE,
    LASTCHANGEDDATETIME,
    NETAMOUNTINTRANSACTIONCURRENCY,
    QUANTITY,
    SALESORDEROVERALLSTATUS,
    SALESORDERPAYMENTMETHOD,
    SALESORDERPAYMENTTERMS,
    SHIPTOPARTY,
    SOLDTOPARTY,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (SALESORDER)
);

Learn More