SEPM_I_SALESORDER

CDS View
31 Fields 21 CDS Views

EPM Demo: Sales Order

SEPM_I_SALESORDER is a CDS View in S/4HANA. EPM Demo: Sales Order. It contains 31 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 (31)

KeyField CDS FieldsUsed in Views
KEY CreatedByUser CreatedByUser 4
KEY SalesOrder CustomerInvoice,SalesOrder 13
KEY SalesOrderUUID SalesOrderUUID 1
_BillingStatus _BillingStatus 1
_DeliveryStatus _DeliveryStatus 1
_LifeCycleStatus _LifeCycleStatus 1
_OverallStatus _OverallStatus 1
_PaymentMethod _PaymentMethod 1
_PaymentTerms _PaymentTerms 1
_TransactionCurrency _TransactionCurrency 1
BillToPartyAddressUUID BillToPartyAddressUUID 1
CreationDateTime CreationDateTime 2
CustomerContactUUID CustomerContactUUID 1
CustomerUUID CustomerUUID 1
GrossAmountInTransacCurrency GrossAmount,GrossAmountInTransacCurrency 5
IsCreatedByBusinessPartner IsCreatedByBusinessPartner 2
IsLastChangedByBusinessPartner IsLastChangedByBusinessPartner 2
LastChangedByUser LastChangedByUser 1
LastChangedDateTime LastChangedDateTime 2
NetAmountInTransactionCurrency NetAmountInTransactionCurrency 2
Opportunity Opportunity 2
SalesOrderBillingStatus SalesOrderBillingStatus 2
SalesOrderDeliveryStatus SalesOrderDeliveryStatus 2
SalesOrderLifeCycleStatus LifeCycleStatus,SalesOrderLifeCycleStatus 4
SalesOrderOverallStatus SalesOrderOverallStatus 2
SalesOrderPaymentMethod SalesOrderPaymentMethod 2
SalesOrderPaymentTerms SalesOrderPaymentTerms 2
ShipToPartyAddressUUID ShipToPartyAddressUUID 1
ShortTextGroupUUID ShortTextGroupUUID 1
TaxAmountInTransactionCurrency TaxAmountInTransactionCurrency 2
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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SEPM_I_SALESORDER (
    CREATEDBYUSER,
    SALESORDER,
    SALESORDERUUID,
    _BILLINGSTATUS,
    _DELIVERYSTATUS,
    _LIFECYCLESTATUS,
    _OVERALLSTATUS,
    _PAYMENTMETHOD,
    _PAYMENTTERMS,
    _TRANSACTIONCURRENCY,
    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