SAP ABAP View SEPM_SDDL_SO_JOI (Erzeugt aus Ddl Source SEPM_SDDL_SALESORDER_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_SO_JOI
Short Description	Erzeugt aus Ddl Source SEPM_SDDL_SALESORDER_JOIN
Root table	SEPM_SDDL_SO_HD	Generated Table for View

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SEPM_SDDL_SO_HD	SEPM_SDDL_SO_HD
2	SEPM_SDDL_V_EMPL
3	SEPM_V_BPA
4	SEPM_SDDL_TEXK_T
5	SEPM_SDDL_V_TEXT
6	SEPM_SDDL_V_SOI
7	SEPM_SDDL_PROD
8	SEPM_SDDL_V_SOSL

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	SEPM_SDDL_SO_HD	CREATED_BY_KEY	JL	EQ				0	0
2	SEPM_SDDL_V_EMPL	EMPLOYEE_KEY	JR	EQ			AND	0	0
3	SEPM_SDDL_SO_HD	IS_CREATED_BY_BUYER	JL	EQ				0	0
4			JR	EQ	' '		AND	0	0
5	SEPM_SDDL_SO_HD	MANDT	JL	EQ				0	0
6	SEPM_SDDL_V_EMPL	MANDT	JR	EQ			AND	0	0
7	SEPM_SDDL_SO_HD	CHANGED_BY_KEY	JL	EQ				0	0
8	SEPM_SDDL_V_EMPL	EMPLOYEE_KEY	JR	EQ			AND	0	0
9	SEPM_SDDL_SO_HD	IS_CHANGED_BY_BUYER	JL	EQ				0	0
10			JR	EQ	' '		AND	0	0
11	SEPM_SDDL_SO_HD	MANDT	JL	EQ				0	0
12	SEPM_SDDL_V_EMPL	MANDT	JR	EQ			AND	0	0
13	SEPM_SDDL_SO_HD	CREATED_BY_KEY	JL	EQ				0	0
14	SEPM_V_BPA	BUSINESS_PARTNER_KEY	JR	EQ			AND	0	0
15	SEPM_SDDL_SO_HD	IS_CREATED_BY_BUYER	JL	EQ				0	0
16			JR	EQ	'X'		AND	0	0
17	SEPM_SDDL_SO_HD	MANDT	JL	EQ				0	0
18	SEPM_V_BPA	MANDT	JR	EQ			AND	0	0
19	SEPM_SDDL_SO_HD	CHANGED_BY_KEY	JL	EQ				0	0
20	SEPM_V_BPA	BUSINESS_PARTNER_KEY	JR	EQ			AND	0	0
21	SEPM_SDDL_SO_HD	IS_CHANGED_BY_BUYER	JL	EQ				0	0
22			JR	EQ	'X'		AND	0	0
23	SEPM_SDDL_SO_HD	MANDT	JL	EQ				0	0
24	SEPM_V_BPA	MANDT	JR	EQ			AND	0	0
25	SEPM_SDDL_SO_HD	MANDT	JL	EQ				0	0
26	SEPM_V_BPA	MANDT	JR	EQ			AND	0	0
27	SEPM_SDDL_SO_HD	BUYER_KEY	JL	EQ				0	0
28	SEPM_V_BPA	BUSINESS_PARTNER_KEY	JR	EQ			AND	0	0
29	SEPM_SDDL_SO_HD	MANDT	JL	EQ				0	0
30	SEPM_SDDL_TEXK_T	MANDT	JR	EQ			AND	0	0
31	SEPM_SDDL_SO_HD	NOTE_KEY	JL	EQ				0	0
32	SEPM_SDDL_TEXK_T	TEXT_ORIGINAL_LANGUAGE_KEY	JR	EQ			AND	0	0
33	SEPM_SDDL_SO_HD	MANDT	JL	EQ				0	0
34	SEPM_SDDL_V_TEXT	MANDT	JR	EQ			AND	0	0
35	SEPM_SDDL_SO_HD	NOTE_KEY	JL	EQ				0	0
36	SEPM_SDDL_V_TEXT	ORIGINAL_LANUAGE_KEY	JR	EQ			AND	0	0
37	SEPM_SDDL_SO_HD	MANDT	JL	EQ				0	0
38	SEPM_SDDL_V_SOI	MANDT	JR	EQ			AND	0	0
39	SEPM_SDDL_SO_HD	SALES_ORDER_KEY	JL	EQ				0	0
40	SEPM_SDDL_V_SOI	SALES_ORDER_KEY	JR	EQ			AND	0	0
41	SEPM_SDDL_SO_HD	MANDT	JL	EQ				0	0
42	SEPM_SDDL_TEXK_T	MANDT	JR	EQ			AND	0	0
43	SEPM_SDDL_V_SOI	NOTE_KEY	JL	EQ				0	0
44	SEPM_SDDL_TEXK_T	TEXT_ORIGINAL_LANGUAGE_KEY	JR	EQ			AND	0	0
45	SEPM_SDDL_SO_HD	MANDT	JL	EQ				0	0
46	SEPM_SDDL_V_TEXT	MANDT	JR	EQ			AND	0	0
47	SEPM_SDDL_V_SOI	NOTE_KEY	JL	EQ				0	0
48	SEPM_SDDL_V_TEXT	ORIGINAL_LANUAGE_KEY	JR	EQ			AND	0	0
49	SEPM_SDDL_SO_HD	MANDT	JL	EQ				0	0
50	SEPM_SDDL_PROD	MANDT	JR	EQ			AND	0	0
51	SEPM_SDDL_V_SOI	PRODUCT_KEY	JL	EQ				0	0
52	SEPM_SDDL_PROD	PRODUCT_KEY	JR	EQ			AND	0	0
53	SEPM_SDDL_SO_HD	MANDT	JL	EQ				0	0
54	SEPM_SDDL_V_SOSL	MANDT	JR	EQ			AND	0	0
55	SEPM_SDDL_V_SOI	ITEM_KEY	JL	EQ				0	0
56	SEPM_SDDL_V_SOSL	SALES_ORDER_ITEM_KEY	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	SEPM_SDDL_SO_HD	MANDT		☐	MANDT	☐	Client
2	SALES_ORDER_KEY	SEPM_SDDL_SO_HD	SALES_ORDER_KEY		☐	SNWD_NODE_KEY	☐	EPM: Generic Node Key
3	SALES_ORDER_ID	SEPM_SDDL_SO_HD	SALES_ORDER_ID		☐	SNWD_SO_ID	☐	EPM: Sales Order Number
4	TOTAL_GROSS_AMOUNT	SEPM_SDDL_SO_HD	GROSS_AMOUNT		☐	SNWD_TTL_GROSS_AMOUNT	☐	EPM: Total Gross Amount
5	TOTAL_NET_AMOUNT	SEPM_SDDL_SO_HD	NET_AMOUNT		☐	SNWD_TTL_NET_AMOUNT	☐	EPM: Total Net Amount
6	TOTAL_TAX_AMOUNT	SEPM_SDDL_SO_HD	TAX_AMOUNT		☐	SNWD_TTL_TAX_AMOUNT	☐	EPM: Total Tax Amount
7	CREATED_BY_EMPLOYEE_ID	SEPM_SDDL_V_EMPL	EMPLOYEE_ID		☐	SNWD_ID	☐	EPM: Employee ID
8	CHANGED_BY_EMPLOYEE_ID	SEPM_SDDL_V_EMPL	EMPLOYEE_ID		☐	SNWD_ID	☐	EPM: Employee ID
9	CREATED_BY_BUYER_ID	SEPM_V_BPA	BUSINESS_PARTNER_ID		☐	SNWD_PARTNER_ID	☐	EPM: Business Partner ID
10	CHANGED_BY_BUYER_ID	SEPM_V_BPA	BUSINESS_PARTNER_ID		☐	SNWD_PARTNER_ID	☐	EPM: Business Partner ID
11	IS_CREATED_BY_BUYER	SEPM_SDDL_SO_HD	IS_CREATED_BY_BUYER		☐	SNWD_BOOL	☐	EPM: Boolean
12	IS_CHANGED_BY_BUYER	SEPM_SDDL_SO_HD	IS_CHANGED_BY_BUYER		☐	SNWD_BOOL	☐	EPM: Boolean
13	CREATED_BY_ID	SEPM_SDDL_SO_HD	CREATED_BY_ID		☐		☐
14	CHANGED_BY_ID	SEPM_SDDL_SO_HD	CHANGED_BY_ID		☐		☐
15	CREATED_AT	SEPM_SDDL_SO_HD	CREATED_AT		☐	TIMESTAMPL	☐	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
16	CHANGED_AT	SEPM_SDDL_SO_HD	CHANGED_AT		☐	TIMESTAMPL	☐	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
17	HEADER_CURRENCY_CODE	SEPM_SDDL_SO_HD	CURRENCY_CODE		☐	SNWD_CURR_CODE	☐	EPM: Currency Code
18	DELIVERY_STATUS	SEPM_SDDL_SO_HD	DELIVERY_STATUS		☐	SNWD_SO_OR_STATUS_CODE	☐	EPM: Sales Order Ordering Status
19	LIFECYCLE_STATUS	SEPM_SDDL_SO_HD	LIFECYCLE_STATUS		☐	SNWD_SO_LC_STATUS_CODE	☐	EPM: Sales Order Lifecycle Status
20	BILLING_STATUS	SEPM_SDDL_SO_HD	BILLING_STATUS		☐	SNWD_SO_CF_STATUS_CODE	☐	EPM: Sales Order Confirmation Status
21	BUYER_ID	SEPM_V_BPA	BUSINESS_PARTNER_ID		☐	SNWD_PARTNER_ID	☐	EPM: Business Partner ID
22	BUYER_NAME	SEPM_V_BPA	COMPANY_NAME		☐	SNWD_COMPANY_NAME	☐	EPM: Company Name
23	HEADER_ORIGINAL_NOTE_LANGUAGE	SEPM_SDDL_TEXK_T	ORIGINAL_LANGUAGE		☐	SPRAS	☐	Language Key
24	HEADER_NOTE_LANGUAGE	SEPM_SDDL_V_TEXT	LANGUAGE		☐	SPRAS	☐	Language Key
25	HEADER_NOTE_TEXT	SEPM_SDDL_V_TEXT	TEXT		☐	SNWD_DESC	☐	EPM: Text field for names and descriptions
26	ITEM_POSITION	SEPM_SDDL_V_SOI	ITEM_POSITION		☐	SNWD_SO_ITEM_POS	☐	EPM: Sales Order Item Position
27	ITEM_GROSS_AMOUNT	SEPM_SDDL_V_SOI	GROSS_AMOUNT		☐	SNWD_TTL_GROSS_AMOUNT	☐	EPM: Total Gross Amount
28	ITEM_NET_AMOUNT	SEPM_SDDL_V_SOI	NET_AMOUNT		☐	SNWD_TTL_NET_AMOUNT	☐	EPM: Total Net Amount
29	ITEM_TAX_AMOUNT	SEPM_SDDL_V_SOI	TAX_AMOUNT		☐	SNWD_TTL_TAX_AMOUNT	☐	EPM: Total Tax Amount
30	ITEM_CURRENCY_CODE	SEPM_SDDL_V_SOI	CURRENCY_CODE		☐	SNWD_CURR_CODE	☐	EPM: Currency Code
31	ITEM_ORIGINAL_NOTE_LANGUAGE	SEPM_SDDL_TEXK_T	ORIGINAL_LANGUAGE		☐	SPRAS	☐	Language Key
32	ITEM_NOTE_LANGUAGE	SEPM_SDDL_V_TEXT	LANGUAGE		☐	SPRAS	☐	Language Key
33	ITEM_NOTE_TEXT	SEPM_SDDL_V_TEXT	TEXT		☐	SNWD_DESC	☐	EPM: Text field for names and descriptions
34	ITEM_PRODUCT_ID	SEPM_SDDL_PROD	PRODUCT_ID		☐	SNWD_PRODUCT_ID	☐	EPM: Product ID
35	ITEM_QUANTITY	SEPM_SDDL_V_SOSL	QUANTITY		☐	SNWD_QUANTITY	☐	EPM: Quantity
36	ITEM_QUANTITY_UNIT	SEPM_SDDL_V_SOSL	QUANTITY_UNIT		☐	SNWD_QUANTITY_UNIT	☐	EPM: Quantity Unit
37	ITEM_DELIVERY_DATE	SEPM_SDDL_V_SOSL	DELIVERY_DATE		☐	TIMESTAMPL	☐	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)

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