SAP ABAP View SEPM_SDDL_SOH_J (Erzeugt aus Ddl Source SEPM_SDDL_SALESORDER_HD_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_SOH_J
Short Description	Erzeugt aus Ddl Source SEPM_SDDL_SALESORDER_HD_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

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				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

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