SEPM_I_SALESORDER

CDS View
24 Fields 21 CDS Views

EPM Demo: Sales Order

SEPM_I_SALESORDER is a CDS View in S/4HANA. EPM Demo: Sales Order. It contains 24 fields. 21 CDS views read from this table.

CDS Views using this table (21)

ViewTypeJoinVDMDescription
BDEF_CDS_ROOT_FOR_TEST view from Used for behavior definition tests.
BDEF_CDS_SUB_FOR_TEST view from The object used in tests
REPM_SalesOrder view from Sales Orders View
Repm_SalesOrderC view left_outer Sales Order Cube View
REPM_SalesOrderDetailsD view from REPM: Sales Order Details Dimension View
REPM_SalesOrderV3 view from Sales Orders View
Repm_Soi_Cube view left_outer 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_CustomerInvoice_E view left_outer EPM Demo: Cust. Invoice with Ext. IDs
SEPM_I_CustomerInvoiceItem_E view left_outer EPM Demo: Customer Invoice Item with External IDs
SEPM_I_SalesOrder_E view from EPM Demo: Sales Order with External IDs
SEPM_I_SalesOrderItem_E view left_outer EPM Demo: Sales Order Item with External IDs
SEPM_I_SalesOrderItem_E_V2 view left_outer EPM Demo: SO Item and SL with Ext. IDs
SEPM_I_SalesOrderItemText_E view left_outer EPM Demo: SO Item Text with External IDs
SEPM_I_SalesOrderText_E view inner EPM Demo: Sales Order Text with External IDs
SEPMRA_I_SalesOrderAge view from Sales Order Age
SEPMRA_I_SlsOrdToTimeDim view from Projection of SO to Time Dimension
SEPMRA_P_ALP_SlsOrdAmntPlan0 view from
SEPMRA_P_OVW_SalesOrder view from
SEPMRA_P_SalesOrderQuantity view from Sales Order Quantity

Fields (24)

KeyField CDS FieldsUsed in Views
KEY CreatedByUser CreatedByUser 4
KEY SalesOrder CustomerInvoice,SalesOrder 12
KEY SalesOrderUUID SalesOrderUUID 1
BillToPartyAddressUUID BillToPartyAddressUUID 1
CreationDateTime CreationDateTime 1
CustomerContactUUID CustomerContactUUID 1
CustomerUUID CustomerUUID 1
GrossAmountInTransacCurrency GrossAmount,GrossAmountInTransacCurrency 4
IsCreatedByBusinessPartner IsCreatedByBusinessPartner 1
IsLastChangedByBusinessPartner IsLastChangedByBusinessPartner 1
LastChangedByUser LastChangedByUser 1
LastChangedDateTime LastChangedDateTime 1
NetAmountInTransactionCurrency NetAmountInTransactionCurrency 1
Opportunity Opportunity 1
SalesOrderBillingStatus SalesOrderBillingStatus 1
SalesOrderDeliveryStatus SalesOrderDeliveryStatus 1
SalesOrderLifeCycleStatus LifeCycleStatus,SalesOrderLifeCycleStatus 3
SalesOrderOverallStatus SalesOrderOverallStatus 1
SalesOrderPaymentMethod SalesOrderPaymentMethod 1
SalesOrderPaymentTerms SalesOrderPaymentTerms 1
ShipToPartyAddressUUID ShipToPartyAddressUUID 1
ShortTextGroupUUID ShortTextGroupUUID 1
TaxAmountInTransactionCurrency TaxAmountInTransactionCurrency 1
TransactionCurrency TransactionCurrency 4

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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SEPM_I_SALESORDER (
    CREATEDBYUSER,
    SALESORDER,
    SALESORDERUUID,
    BILLTOPARTYADDRESSUUID,
    CREATIONDATETIME,
    CUSTOMERCONTACTUUID,
    CUSTOMERUUID,
    GROSSAMOUNTINTRANSACCURRENCY,
    ISCREATEDBYBUSINESSPARTNER,
    ISLASTCHANGEDBYBUSINESSPARTNER,
    LASTCHANGEDBYUSER,
    LASTCHANGEDDATETIME,
    NETAMOUNTINTRANSACTIONCURRENCY,
    OPPORTUNITY,
    SALESORDERBILLINGSTATUS,
    SALESORDERDELIVERYSTATUS,
    SALESORDERLIFECYCLESTATUS,
    SALESORDEROVERALLSTATUS,
    SALESORDERPAYMENTMETHOD,
    SALESORDERPAYMENTTERMS,
    SHIPTOPARTYADDRESSUUID,
    SHORTTEXTGROUPUUID,
    TAXAMOUNTINTRANSACTIONCURRENCY,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (CREATEDBYUSER, SALESORDER, SALESORDERUUID)
);

Learn More