SEPM_I_CustomerInvoice_E

DDL: SEPM_I_CUSTOMERINVOICE_E SQL: SEPM_ICIE Type: view Package: S_EPM_CDS_REF
20 Fields 3 Data Sources 4 Associations

EPM Demo: Cust. Invoice with Ext. IDs

SEPM_I_CustomerInvoice_E is a CDS View of category Dimension that provides data about "EPM Demo: Cust. Invoice with Ext. IDs" in SAP S/4HANA. It reads from 3 data sources (SEPM_I_BusinessPartner, SEPM_I_CustomerInvoice, SEPM_I_SalesOrder) and exposes 20 fields with key field CustomerInvoice. It has 4 associations to related views. Part of development package S_EPM_CDS_REF.

Data Sources (3)

SourceAliasJoin Type
SEPM_I_BusinessPartner BP left_outer
SEPM_I_CustomerInvoice CI from
SEPM_I_SalesOrder SO left_outer

Associations (4)

CardinalityTargetAliasCondition
[0..*] SEPM_I_CustomerInvoiceItem_E _Item $projection.CustomerInvoice = _Item.CustomerInvoice
[0..1] SEPM_I_SalesOrder_E _SalesOrder $projection.SalesOrder = _SalesOrder.SalesOrder
[0..1] SEPM_I_BusinessPartner_E _Customer $projection.Customer = _Customer.BusinessPartner
[0..1] SEPM_I_CUSTOMER_E _CustomerV2 $projection.Customer = _CustomerV2.Customer

Annotations (8)

NameValueLevelField
EndUserText.label EPM Demo: Cust. Invoice with Ext. IDs view
Analytics.dataCategory #DIMENSION view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName SEPM_ICIE view
ObjectModel.representativeKey CustomerInvoice view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY CustomerInvoice SEPM_I_SalesOrder SalesOrder SD Document
SalesOrder SEPM_I_SalesOrder SalesOrder SD Document
DeliveryNote SEPM_I_CustomerInvoice DeliveryNote Delivery Note No.
CreationDateTime SEPM_I_CustomerInvoice CreationDateTime Timestamp
LastChangedDateTime SEPM_I_CustomerInvoice LastChangedDateTime Time Stamp
CreatedBySystemUser
LastChangedBySystemUser
TransactionCurrency SEPM_I_CustomerInvoice TransactionCurrency Transaction Currency
GrossAmountInTransacCurrency SEPM_I_CustomerInvoice GrossAmountInTransacCurrency Tax-Inclusive Amount
NetAmountInTransactionCurrency SEPM_I_CustomerInvoice NetAmountInTransactionCurrency Tax-Exclusive Amount
TaxAmountInTransactionCurrency SEPM_I_CustomerInvoice TaxAmountInTransactionCurrency VAT Amount Type
Customer SEPM_I_BusinessPartner BusinessPartner Issuing Authority
DunningLevel SEPM_I_CustomerInvoice DunningLevel Dunning Level
CustomerInvoicePaymentStatus SEPM_I_CustomerInvoice CustomerInvoicePaymentStatus Payment Status
_PaymentStatus SEPM_I_CustomerInvoice _PaymentStatus
_Item _Item
_SalesOrder _SalesOrder
_Customer _Customer
_CustomerV2 _CustomerV2
_TransactionCurrency SEPM_I_CustomerInvoice _TransactionCurrency

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view SEPM_I_CustomerInvoice_E.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: SEPM_ICIE

CREATE VIEW SEPM_I_CustomerInvoice_E AS
SELECT
  SO.SalesOrder AS CustomerInvoice,
  SO.SalesOrder AS SalesOrder,
  CI.DeliveryNote AS DeliveryNote,
  CI.CreationDateTime AS CreationDateTime,
  CI.LastChangedDateTime AS LastChangedDateTime,
  CI._CreatedByUser.SystemUser AS CreatedBySystemUser,
  CI._LastChangedByUser.SystemUser AS LastChangedBySystemUser,
  CI.TransactionCurrency AS TransactionCurrency,
  CI.GrossAmountInTransacCurrency AS GrossAmountInTransacCurrency,
  CI.NetAmountInTransactionCurrency AS NetAmountInTransactionCurrency,
  CI.TaxAmountInTransactionCurrency AS TaxAmountInTransactionCurrency,
  BP.BusinessPartner AS Customer,
  CI.DunningLevel AS DunningLevel,
  CI.CustomerInvoicePaymentStatus AS CustomerInvoicePaymentStatus,
  CI._PaymentStatus AS _PaymentStatus,
  CI._TransactionCurrency AS _TransactionCurrency
FROM SEPM_I_CustomerInvoice AS CI
LEFT OUTER JOIN SEPM_I_SalesOrder AS SO ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN SEPM_I_BusinessPartner AS BP ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN SEPM_I_CustomerInvoiceItem_E AS _Item ON CustomerInvoice = _Item.CustomerInvoice  -- association [0..*]
LEFT OUTER JOIN SEPM_I_SalesOrder_E AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN SEPM_I_BusinessPartner_E AS _Customer ON Customer = _Customer.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN SEPM_I_CUSTOMER_E AS _CustomerV2 ON Customer = _CustomerV2.Customer  -- association [0..1]
;

Learn More