SAP ABAP View SEPM_SDDL_V_BPJ (Erzeugt aus Ddl Source SEPM_SDDL_BUSINESSPARTNER_JOIN)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-NWD (Application Component) NetWeaver Demonstration
     ⤷ S_EPM_CDS_TEST (Package) Package for CDS test objects and demo examples

Basic Data

View Type	D	Database View
Database View	SEPM_SDDL_V_BPJ
Short Description	Erzeugt aus Ddl Source SEPM_SDDL_BUSINESSPARTNER_JOIN
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	DDDDLCHARTYPES

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				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	BUSINESS_PARTNER_KEY	SEPM_V_BPA	BUSINESS_PARTNER_KEY		☐	SNWD_NODE_KEY	☐	EPM: Generic Node Key
3	BUSINESS_PARTNER_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	BUSINESS_PARTNER_ROLE_NAME	DDDDLCHARTYPES	CCHAR8		☐		☐
6	EMAIL_ADDRESS	SEPM_V_BPA	EMAIL_ADDRESS		☐	SNWD_EMAIL_ADDRESS	☐	EPM: E-Mail Address
7	PHONE_NUMBER	SEPM_V_BPA	PHONE_NUMBER		☐	SNWD_PHONE_NUMBER	☐	EPM: Phone Number
8	FAX_NUMBER	SEPM_V_BPA	FAX_NUMBER		☐	SNWD_PHONE_NUMBER	☐	EPM: Phone Number
9	WEB_ADDRESS	SEPM_V_BPA	WEB_ADDRESS		☐	SNWD_STRING	☐	EPM: String
10	COMPANY_NAME	SEPM_V_BPA	COMPANY_NAME		☐	SNWD_COMPANY_NAME	☐	EPM: Company Name
11	LEGAL_FORM	SEPM_V_BPA	LEGAL_FORM		☐	SNWD_LEGAL_FORM	☐	EPM: Legal Form of Business Partner
12	ADDRESS_KEY	SEPM_V_BPA	ADDRESS_KEY		☐	SNWD_NODE_KEY	☐	EPM: Generic Node Key
13	COUNTRY	SEPM_V_ADDRESS	COUNTRY		☐	SNWD_COUNTRY	☐	EPM: Country Code
14	POSTAL_CODE	SEPM_V_ADDRESS	POSTAL_CODE		☐	SNWD_POSTAL_CODE	☐	EPM: Postal Code
15	CITY	SEPM_V_ADDRESS	CITY		☐	SNWD_CITY	☐	EPM: City
16	STREET	SEPM_V_ADDRESS	STREET		☐	SNWD_STREET	☐	EPM: Street
17	BUILDING	SEPM_V_ADDRESS	BUILDING		☐	SNWD_BUILDING	☐	EPM: Building
18	ADDRESS_LATITUDE	SEPM_V_ADDRESS	LATITUDE		☐	SNWD_LAT	☐	EPM: Latitude
19	ADDRESS_LONGITUDE	SEPM_V_ADDRESS	LONGITUDE		☐	SNWD_LONG	☐	EPM: Longitude
20	CONTACT_FIRST_NAME	SEPM_V_CONTACT	FIRST_NAME		☐	SNWD_FIRST_NAME	☐	EPM: First Name
21	CONTACT_LAST_NAME	SEPM_V_CONTACT	LAST_NAME		☐	SNWD_LAST_NAME	☐	EPM: Last Name
22	CONTACT_SEX	SEPM_V_CONTACT	SEX		☐	SNWD_SEX	☐	EPM: Sex
23	CONTACT_EMAIL_ADDRESS	SEPM_V_CONTACT	EMAIL_ADDRESS		☐	SNWD_EMAIL_ADDRESS	☐	EPM: E-Mail Address
24	CONTACT_PHONE_NUMBER	SEPM_V_CONTACT	PHONE_NUMBER		☐	SNWD_PHONE_NUMBER	☐	EPM: Phone Number
25	CREATED_BY_EMPLOYEE_KEY	SEPM_V_BPA	CREATED_BY_EMPLOYEE_KEY		☐	SNWD_NODE_KEY	☐	EPM: Generic Node Key
26	CREATED_AT	SEPM_V_BPA	CREATED_AT		☐	TIMESTAMPL	☐	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
27	CHANGED_BY_EMPLOYEE_KEY	SEPM_V_BPA	CHANGED_BY_EMPLOYEE_KEY		☐	SNWD_NODE_KEY	☐	EPM: Generic Node Key
28	CHANGED_AT	SEPM_V_BPA	CHANGED_AT		☐	TIMESTAMPL	☐	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
29	CURRENCY_CODE	SEPM_V_BPA	CURRENCY_CODE		☐	SNWD_CURR_CODE	☐	EPM: Currency Code
30	CREATED_BY_EMPLOYEE_ID	SEPM_SDDL_V_EMPL	EMPLOYEE_ID		☐	SNWD_ID	☐	EPM: Employee ID
31	CREATED_BY_EMPLOYEE_FIRST_NAME	SEPM_SDDL_V_EMPL	FIRST_NAME		☐	SNWD_FIRST_NAME	☐	EPM: First Name
32	CREATED_BY_EMPLOYEE_LAST_NAME	SEPM_SDDL_V_EMPL	LAST_NAME		☐	SNWD_LAST_NAME	☐	EPM: Last Name
33	CREATED_BY_EMPLOYEE_EMAIL	SEPM_SDDL_V_EMPL	EMAIL_ADDRESS		☐	SNWD_EMAIL_ADDRESS	☐	EPM: E-Mail Address
34	CHANGED_BY_EMPLOYEE_ID	SEPM_SDDL_V_EMPL	EMPLOYEE_ID		☐	SNWD_ID	☐	EPM: Employee ID
35	CHANGED_BY_EMPLOYEE_FIRST_NAME	SEPM_SDDL_V_EMPL	FIRST_NAME		☐	SNWD_FIRST_NAME	☐	EPM: First Name
36	CHANGED_BY_EMPLOYEE_LAST_NAME	SEPM_SDDL_V_EMPL	LAST_NAME		☐	SNWD_LAST_NAME	☐	EPM: Last Name
37	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