SEPM_I_CUSTOMERINVOICE

CDS View
11 Fields 4 CDS Views

EPM Demo: Customer Invoice

SEPM_I_CUSTOMERINVOICE is a CDS View in S/4HANA. EPM Demo: Customer Invoice. It contains 11 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
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 from EPM Demo: Cust. Invoice with Ext. IDs
SEPM_I_CustomerInvoiceItem_E view left_outer EPM Demo: Customer Invoice Item with External IDs

Fields (11)

KeyField CDS FieldsUsed in Views
_PaymentStatus _PaymentStatus 1
_TransactionCurrency _TransactionCurrency 1
CreationDateTime CreationDateTime 1
CustomerInvoicePaymentStatus CustomerInvoicePaymentStatus 1
DeliveryNote DeliveryNote 1
DunningLevel DunningLevel 1
GrossAmountInTransacCurrency GrossAmountInTransacCurrency 1
LastChangedDateTime LastChangedDateTime 1
NetAmountInTransactionCurrency NetAmountInTransactionCurrency 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.

-- EPM Demo: Customer Invoice
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SEPM_I_CUSTOMERINVOICE (
    _PAYMENTSTATUS,
    _TRANSACTIONCURRENCY,
    CREATIONDATETIME,
    CUSTOMERINVOICEPAYMENTSTATUS,
    DELIVERYNOTE,
    DUNNINGLEVEL,
    GROSSAMOUNTINTRANSACCURRENCY,
    LASTCHANGEDDATETIME,
    NETAMOUNTINTRANSACTIONCURRENCY,
    TAXAMOUNTINTRANSACTIONCURRENCY,
    TRANSACTIONCURRENCY
);

Learn More