SAP ABAP View SEPM_SUM_AMOUNT (CDS view with sum of gross_amount on open EPM invoices)
Hierarchy
SAP_BASIS (Software Component) SAP Basis Component
   BC-SRV-NWD-XBR (Application Component) HANA Reference Applications
     S_EPM_OIA_DFG_PROVIDER (Package) OIA Reference Feature Implementation
Basic Data
View Type D Database View 
Database View SEPM_SUM_AMOUNT  
Short Description CDS view with sum of gross_amount on open EPM invoices    
Root table SNWD_SO_INV_ITEM   EPM: Sales Order Invoice Items Table 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 SNWD_SO_INV_ITEM SNWD_SO_INV_ITEM
2 SNWD_SO_INV_HEAD  
3 DDDDLCURRTYPES  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 SNWD_SO_INV_ITEM CLIENT JL EQ 0 0
2 SNWD_SO_INV_HEAD CLIENT JR EQ AND 0 0
3 SNWD_SO_INV_HEAD NODE_KEY JL EQ 0 0
4 SNWD_SO_INV_ITEM PARENT_KEY JR EQ AND 0 0
5 SNWD_SO_INV_HEAD PAYMENT_STATUS EQ ' ' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT SNWD_SO_INV_ITEM CLIENT   MANDT Client
2 BUPA_KEY SNWD_SO_INV_HEAD BUYER_GUID   SNWD_NODE_KEY EPM: Generic Node Key
3 CURRENCY_CODE SNWD_SO_INV_ITEM CURRENCY_CODE   SNWD_CURR_CODE EPM: Currency Code
4 GROSS_AMOUNT DDDDLCURRTYPES CURR15_2    
                 
Maintenance Status
Access
  read only
  read and change
  Time-dependent views: like U, validity data like ' '
  read, change, delete and insert
Delivery Class      
Data Browser/Table View Maintenance    Display/Maintenance Allowed with Restrictions  
History
Last changed by/on DDIC  20150523 
SAP Release Created in 740