SAP ABAP View SEPM_BPA_ET (Erzeugt aus Ddl Source SEPM_DDL_CUSTOMER_EXTENTED)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-NWD (Application Component) NetWeaver Demonstration
     ⤷ S_EPM_HANA_EXT_ODATA_PAL (Package) EPM: PAL Odata

Basic Data

View Type	D	Database View
Database View	SEPM_BPA_ET
Short Description	Erzeugt aus Ddl Source SEPM_DDL_CUSTOMER_EXTENTED
Root table	SEPM_V_BPA	Generated Table for View

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SEPM_V_BPA	SEPM_V_BPA
2	SEPM_V_ADDRESS
3	SEPM_V_CONTACT
4	SEPM_SDDL_V_EMPL
5	SNWD_BP_EXT_PAL
6	SNWD_AD_EXT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	SEPM_V_BPA	MANDT	JL	EQ				0	0
2	SEPM_V_ADDRESS	MANDT	JR	EQ			AND	0	0
3	SEPM_V_BPA	ADDRESS_KEY	JL	EQ				0	0
4	SEPM_V_ADDRESS	ADDRESS_KEY	JR	EQ			AND	0	0
5	SEPM_V_BPA	MANDT	JL	EQ				0	0
6	SEPM_V_CONTACT	MANDT	JR	EQ			AND	0	0
7	SEPM_V_BPA	BUSINESS_PARTNER_KEY	JL	EQ				0	0
8	SEPM_V_CONTACT	BUSINESS_PARTNER_KEY	JR	EQ			AND	0	0
9	SEPM_V_BPA	MANDT	JL	EQ				0	0
10	SEPM_SDDL_V_EMPL	MANDT	JR	EQ			AND	0	0
11	SEPM_V_BPA	CREATED_BY_EMPLOYEE_KEY	JL	EQ				0	0
12	SEPM_SDDL_V_EMPL	EMPLOYEE_KEY	JR	EQ			AND	0	0
13	SEPM_V_BPA	MANDT	JL	EQ				0	0
14	SEPM_SDDL_V_EMPL	MANDT	JR	EQ			AND	0	0
15	SEPM_V_BPA	CHANGED_BY_EMPLOYEE_KEY	JL	EQ				0	0
16	SEPM_SDDL_V_EMPL	EMPLOYEE_KEY	JR	EQ			AND	0	0
17	SEPM_V_BPA	MANDT	JL	EQ				0	0
18	SNWD_BP_EXT_PAL	CLIENT	JR	EQ			AND	0	0
19	SEPM_V_BPA	BUSINESS_PARTNER_KEY	JL	EQ				0	0
20	SNWD_BP_EXT_PAL	NODE_KEY	JR	EQ			AND	0	0
21	SEPM_V_BPA	MANDT	JL	EQ				0	0
22	SNWD_AD_EXT	CLIENT	JR	EQ			AND	0	0
23	SEPM_V_BPA	ADDRESS_KEY	JL	EQ				0	0
24	SNWD_AD_EXT	NODE_KEY	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	SEPM_V_BPA	MANDT		☐	MANDT	☐	Client
2	CUSTOMER_KEY	SEPM_V_BPA	BUSINESS_PARTNER_KEY		☐	SNWD_NODE_KEY	☐	EPM: Generic Node Key
3	CUSTOMER_ID	SEPM_V_BPA	BUSINESS_PARTNER_ID		☐	SNWD_PARTNER_ID	☐	EPM: Business Partner ID
4	BUSINESS_PARTNER_ROLE	SEPM_V_BPA	BUSINESS_PARTNER_ROLE		☐	SNWD_BUSINESS_PARTNER_ROLE	☐	EPM: Business Partner Role
5	EMAIL_ADDRESS	SEPM_V_BPA	EMAIL_ADDRESS		☐	SNWD_EMAIL_ADDRESS	☐	EPM: E-Mail Address
6	PHONE_NUMBER	SEPM_V_BPA	PHONE_NUMBER		☐	SNWD_PHONE_NUMBER	☐	EPM: Phone Number
7	FAX_NUMBER	SEPM_V_BPA	FAX_NUMBER		☐	SNWD_PHONE_NUMBER	☐	EPM: Phone Number
8	WEB_ADDRESS	SEPM_V_BPA	WEB_ADDRESS		☐	SNWD_STRING	☐	EPM: String
9	COMPANY_NAME	SEPM_V_BPA	COMPANY_NAME		☐	SNWD_COMPANY_NAME	☐	EPM: Company Name
10	LEGAL_FORM	SEPM_V_BPA	LEGAL_FORM		☐	SNWD_LEGAL_FORM	☐	EPM: Legal Form of Business Partner
11	ADDRESS_KEY	SEPM_V_BPA	ADDRESS_KEY		☐	SNWD_NODE_KEY	☐	EPM: Generic Node Key
12	COUNTRY	SEPM_V_ADDRESS	COUNTRY		☐	SNWD_COUNTRY	☐	EPM: Country Code
13	POSTAL_CODE	SEPM_V_ADDRESS	POSTAL_CODE		☐	SNWD_POSTAL_CODE	☐	EPM: Postal Code
14	CITY	SEPM_V_ADDRESS	CITY		☐	SNWD_CITY	☐	EPM: City
15	STREET	SEPM_V_ADDRESS	STREET		☐	SNWD_STREET	☐	EPM: Street
16	BUILDING	SEPM_V_ADDRESS	BUILDING		☐	SNWD_BUILDING	☐	EPM: Building
17	FIRST_NAME	SEPM_V_CONTACT	FIRST_NAME		☐	SNWD_FIRST_NAME	☐	EPM: First Name
18	LAST_NAME	SEPM_V_CONTACT	LAST_NAME		☐	SNWD_LAST_NAME	☐	EPM: Last Name
19	GENDER	SEPM_V_CONTACT	SEX		☐	SNWD_SEX	☐	EPM: Sex
20	DATE_OF_BIRTH	SEPM_V_CONTACT	DATE_OF_BIRTH		☐	SYDATUM	☐	System Date
21	CHILDREN	SNWD_BP_EXT_PAL	CHILDREN		☐	SNWD_CHILDREN	☐	EPM HANA: No of children
22	AVG_CHILD_AGE	SNWD_BP_EXT_PAL	AVG_CHILD_AGE		☐	SNWD_CHILDRENS_AVG_AGE	☐	EPM HANA: Average age of children
23	VEHICLES	SNWD_BP_EXT_PAL	VEHICLES		☐	SNWD_VEHICLES	☐	EPM HANA: Number of vehicles
24	AVG_VEHICLE_VAL	SNWD_BP_EXT_PAL	AVG_VEHICLE_VAL		☐	SNWD_VEHICLE_VALUE	☐	EPM HANA: Average vehicle value
25	FREQUENT_TRVLR	SNWD_BP_EXT_PAL	FREQUENT_TRVLR		☐	SNWD_BOOL	☐	EPM: Boolean
26	CREDIT_CARD	SNWD_BP_EXT_PAL	CREDIT_CARD		☐	SNWD_BOOL	☐	EPM: Boolean
27	JOB_TYPE	SNWD_BP_EXT_PAL	JOB_TYPE		☐	SNWD_JOB_TYPE	☐	EPM HANA: Job type
28	FAMILY_MEMBERS	SNWD_BP_EXT_PAL	FAMILY_MEMBERS		☐	SNWD_FAMILY_MEMBERS	☐	EPM HANA: Number of family members
29	WEALTH_RANKING	SNWD_BP_EXT_PAL	WEALTH_RANKING		☐	SNWD_WEALTH_RANKING	☐	EPM HANA: Wealth ranking
30	INCOME	SNWD_BP_EXT_PAL	INCOME		☐	SNWD_INCOME	☐	EPM HANA: Income
31	DISC_PROM_PARTIC	SNWD_BP_EXT_PAL	DISC_PROM_PARTIC		☐	SNWD_BOOL	☐	EPM: Boolean
32	LATITUDE	SNWD_AD_EXT	LATITUDE		☐	SNWD_LATITUDE	☐	EPM HANA: Latitude
33	LONGITUDE	SNWD_AD_EXT	LONGITUDE		☐	SNWD_LONGITUDE	☐	EPM HANA: Longitude
34	CREATED_BY_EMPLOYEE_KEY	SEPM_V_BPA	CREATED_BY_EMPLOYEE_KEY		☐	SNWD_NODE_KEY	☐	EPM: Generic Node Key
35	CREATED_AT	SEPM_V_BPA	CREATED_AT		☐	TIMESTAMPL	☐	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
36	CHANGED_BY_EMPLOYEE_KEY	SEPM_V_BPA	CHANGED_BY_EMPLOYEE_KEY		☐	SNWD_NODE_KEY	☐	EPM: Generic Node Key
37	CHANGED_AT	SEPM_V_BPA	CHANGED_AT		☐	TIMESTAMPL	☐	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
38	CURRENCY_CODE	SEPM_V_BPA	CURRENCY_CODE		☐	SNWD_CURR_CODE	☐	EPM: Currency Code
39	CREATED_BY_EMPLOYEE_ID	SEPM_SDDL_V_EMPL	EMPLOYEE_ID		☐	SNWD_ID	☐	EPM: Employee ID
40	CREATED_BY_EMPLOYEE_FIRST_NAME	SEPM_SDDL_V_EMPL	FIRST_NAME		☐	SNWD_FIRST_NAME	☐	EPM: First Name
41	CREATED_BY_EMPLOYEE_LAST_NAME	SEPM_SDDL_V_EMPL	LAST_NAME		☐	SNWD_LAST_NAME	☐	EPM: Last Name
42	CREATED_BY_EMPLOYEE_EMAIL	SEPM_SDDL_V_EMPL	EMAIL_ADDRESS		☐	SNWD_EMAIL_ADDRESS	☐	EPM: E-Mail Address
43	CHANGED_BY_EMPLOYEE_ID	SEPM_SDDL_V_EMPL	EMPLOYEE_ID		☐	SNWD_ID	☐	EPM: Employee ID
44	CHANGED_BY_EMPLOYEE_FIRST_NAME	SEPM_SDDL_V_EMPL	FIRST_NAME		☐	SNWD_FIRST_NAME	☐	EPM: First Name
45	CHANGED_BY_EMPLOYEE_LAST_NAME	SEPM_SDDL_V_EMPL	LAST_NAME		☐	SNWD_LAST_NAME	☐	EPM: Last Name
46	CHANGED_BY_EMPLOYEE_EMAIL	SEPM_SDDL_V_EMPL	EMAIL_ADDRESS		☐	SNWD_EMAIL_ADDRESS	☐	EPM: E-Mail Address

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