SAP ABAP View SEPM_SDDL_SO_HD (Erzeugt aus Ddl Source SEPM_SDDL_SALESORDER_HEAD)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-NWD (Application Component) NetWeaver Demonstration
     ⤷ S_EPM_CDS (Package) EPM: Core Data Services

Basic Data

View Type	D	Database View
Database View	SEPM_SDDL_SO_HD
Short Description	Erzeugt aus Ddl Source SEPM_SDDL_SALESORDER_HEAD
Root table	SNWD_SO	EPM: Sales Order Header Table

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SNWD_SO	SNWD_SO
2	SEPM_SDDL_V_EMPL
3	SEPM_V_BPA
4	DDDDLCHARTYPES

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	SNWD_SO	CREATED_BY	JL	EQ				0	0
2	SEPM_SDDL_V_EMPL	EMPLOYEE_KEY	JR	EQ			AND	0	0
3	SNWD_SO	CREATED_BY_BP	JL	EQ				0	0
4			JR	EQ	' '		AND	0	0
5	SNWD_SO	CLIENT	JL	EQ				0	0
6	SEPM_SDDL_V_EMPL	MANDT	JR	EQ			AND	0	0
7	SNWD_SO	CHANGED_BY	JL	EQ				0	0
8	SEPM_SDDL_V_EMPL	EMPLOYEE_KEY	JR	EQ			AND	0	0
9	SNWD_SO	CHANGED_BY_BP	JL	EQ				0	0
10			JR	EQ	' '		AND	0	0
11	SNWD_SO	CLIENT	JL	EQ				0	0
12	SEPM_SDDL_V_EMPL	MANDT	JR	EQ			AND	0	0
13	SNWD_SO	CREATED_BY	JL	EQ				0	0
14	SEPM_V_BPA	BUSINESS_PARTNER_KEY	JR	EQ			AND	0	0
15	SNWD_SO	CREATED_BY_BP	JL	EQ				0	0
16			JR	EQ	'X'		AND	0	0
17	SNWD_SO	CLIENT	JL	EQ				0	0
18	SEPM_V_BPA	MANDT	JR	EQ			AND	0	0
19	SNWD_SO	CHANGED_BY	JL	EQ				0	0
20	SEPM_V_BPA	BUSINESS_PARTNER_KEY	JR	EQ			AND	0	0
21	SNWD_SO	CHANGED_BY_BP	JL	EQ				0	0
22			JR	EQ	'X'		AND	0	0
23	SNWD_SO	CLIENT	JL	EQ				0	0
24	SEPM_V_BPA	MANDT	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	SNWD_SO	CLIENT		☐	MANDT	☐	Client
2	SALES_ORDER_KEY	SNWD_SO	NODE_KEY		☐	SNWD_NODE_KEY	☐	EPM: Generic Node Key
3	SALES_ORDER_ID	SNWD_SO	SO_ID		☐	SNWD_SO_ID	☐	EPM: Sales Order Number
4	CREATED_BY_KEY	SNWD_SO	CREATED_BY		☐	SNWD_NODE_KEY	☐	EPM: Generic Node Key
5	CHANGED_BY_KEY	SNWD_SO	CHANGED_BY		☐	SNWD_NODE_KEY	☐	EPM: Generic Node Key
6	CREATED_AT	SNWD_SO	CREATED_AT		☐	TIMESTAMPL	☐	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
7	CHANGED_AT	SNWD_SO	CHANGED_AT		☐	TIMESTAMPL	☐	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
8	IS_CREATED_BY_BUYER	SNWD_SO	CREATED_BY_BP		☐	SNWD_BOOL	☐	EPM: Boolean
9	IS_CHANGED_BY_BUYER	SNWD_SO	CHANGED_BY_BP		☐	SNWD_BOOL	☐	EPM: Boolean
10	CREATED_BY_EMPLOYEE_ID	SEPM_SDDL_V_EMPL	EMPLOYEE_ID		☐	SNWD_ID	☐	EPM: Employee ID
11	CHANGED_BY_EMPLOYEE_ID	SEPM_SDDL_V_EMPL	EMPLOYEE_ID		☐	SNWD_ID	☐	EPM: Employee ID
12	CREATED_BY_BUYER_ID	SEPM_V_BPA	BUSINESS_PARTNER_ID		☐	SNWD_PARTNER_ID	☐	EPM: Business Partner ID
13	CHANGED_BY_BUYER_ID	SEPM_V_BPA	BUSINESS_PARTNER_ID		☐	SNWD_PARTNER_ID	☐	EPM: Business Partner ID
14	CREATED_BY_ID	DDDDLCHARTYPES	CCHAR10		☐		☐
15	CHANGED_BY_ID	DDDDLCHARTYPES	CCHAR10		☐		☐
16	NOTE_KEY	SNWD_SO	NOTE_GUID		☐	SNWD_NODE_KEY	☐	EPM: Generic Node Key
17	SALES_OPPORTUNITY_ID	SNWD_SO	OP_ID		☐	SNWD_OP_ID	☐	EPM: Opportunity ID for SoD IDoc processing
18	CURRENCY_CODE	SNWD_SO	CURRENCY_CODE		☐	SNWD_CURR_CODE	☐	EPM: Currency Code
19	GROSS_AMOUNT	SNWD_SO	GROSS_AMOUNT		☐	SNWD_TTL_GROSS_AMOUNT	☐	EPM: Total Gross Amount
20	NET_AMOUNT	SNWD_SO	NET_AMOUNT		☐	SNWD_TTL_NET_AMOUNT	☐	EPM: Total Net Amount
21	TAX_AMOUNT	SNWD_SO	TAX_AMOUNT		☐	SNWD_TTL_TAX_AMOUNT	☐	EPM: Total Tax Amount
22	LIFECYCLE_STATUS	SNWD_SO	LIFECYCLE_STATUS		☐	SNWD_SO_LC_STATUS_CODE	☐	EPM: Sales Order Lifecycle Status
23	BILLING_STATUS	SNWD_SO	BILLING_STATUS		☐	SNWD_SO_CF_STATUS_CODE	☐	EPM: Sales Order Confirmation Status
24	DELIVERY_STATUS	SNWD_SO	DELIVERY_STATUS		☐	SNWD_SO_OR_STATUS_CODE	☐	EPM: Sales Order Ordering Status
25	BUYER_KEY	SNWD_SO	BUYER_GUID		☐	SNWD_NODE_KEY	☐	EPM: Generic Node Key

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