SAP ABAP View SEPM_SO_INVHEADP (OIA: SO Invoices joined with Business Partner Info)
Hierarchy
SAP_BASIS (Software Component) SAP Basis Component
   BC-SRV-NWD-XBR (Application Component) HANA Reference Applications
     S_EPM_OIA_APPS_GUI (Package) OIA demos with standard SAP GUI
Basic Data
View Type D Database View 
Database View SEPM_SO_INVHEADP  
Short Description OIA: SO Invoices joined with Business Partner Info    
Root table SNWD_SO_INV_HEAD   EPM: Sales Order Invoice Header Table 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 SNWD_SO_INV_HEAD SNWD_SO_INV_HEAD
2 SNWD_SO  
3 SNWD_BPA  
4 SNWD_AD  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 SNWD_SO_INV_HEAD CLIENT JL EQ 0 0
2 SNWD_SO CLIENT JR EQ AND 0 0
3 SNWD_SO_INV_HEAD SO_GUID JL EQ 0 0
4 SNWD_SO NODE_KEY JR EQ AND 0 0
5 SNWD_SO_INV_HEAD CLIENT JL EQ 0 0
6 SNWD_BPA CLIENT JR EQ AND 0 0
7 SNWD_SO_INV_HEAD BUYER_GUID JL EQ 0 0
8 SNWD_BPA NODE_KEY JR EQ AND 0 0
9 SNWD_BPA CLIENT JL EQ 0 0
10 SNWD_AD CLIENT JR EQ AND 0 0
11 SNWD_BPA ADDRESS_GUID JL EQ 0 0
12 SNWD_AD NODE_KEY JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 CLIENT SNWD_SO_INV_HEAD CLIENT   MANDT Client
2 BP_ID SNWD_BPA BP_ID   SNWD_PARTNER_ID EPM: Business Partner ID
3 COMPANY_NAME SNWD_BPA COMPANY_NAME   SNWD_COMPANY_NAME EPM: Company Name
4 COUNTRY SNWD_AD COUNTRY   SNWD_COUNTRY EPM: Country Code
5 EMAIL SNWD_BPA EMAIL_ADDRESS   SNWD_EMAIL_ADDRESS EPM: E-Mail Address
6 SO_ID SNWD_SO SO_ID   SNWD_SO_ID EPM: Sales Order Number
7 GROSS_AMOUNT SNWD_SO_INV_HEAD GROSS_AMOUNT   SNWD_TTL_GROSS_AMOUNT EPM: Total Gross Amount
8 CURRENCY_CODE SNWD_SO_INV_HEAD CURRENCY_CODE   SNWD_CURR_CODE EPM: Currency Code
                 
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 SAP  20141013 
SAP Release Created in 740