SAP ABAP View SEPM_SDDL_SO_JI (Erzeugt aus Ddl Source SEPM_SDDL_SALESORDER_JOI)

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_JI
Short Description	Erzeugt aus Ddl Source SEPM_SDDL_SALESORDER_JOI
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_V_SOI
5	SEPM_SDDL_PROD
6	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_V_SOI	MANDT	JR	EQ			AND	0	0
31	SEPM_SDDL_SO_HD	SALES_ORDER_KEY	JL	EQ				0	0
32	SEPM_SDDL_V_SOI	SALES_ORDER_KEY	JR	EQ			AND	0	0
33	SEPM_SDDL_SO_HD	MANDT	JL	EQ				0	0
34	SEPM_SDDL_PROD	MANDT	JR	EQ			AND	0	0
35	SEPM_SDDL_V_SOI	PRODUCT_KEY	JL	EQ				0	0
36	SEPM_SDDL_PROD	PRODUCT_KEY	JR	EQ			AND	0	0
37	SEPM_SDDL_SO_HD	MANDT	JL	EQ				0	0
38	SEPM_SDDL_V_SOSL	MANDT	JR	EQ			AND	0	0
39	SEPM_SDDL_V_SOI	ITEM_KEY	JL	EQ				0	0
40	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	ITEM_POSITION	SEPM_SDDL_V_SOI	ITEM_POSITION		☐	SNWD_SO_ITEM_POS	☐	EPM: Sales Order Item Position
24	ITEM_GROSS_AMOUNT	SEPM_SDDL_V_SOI	GROSS_AMOUNT		☐	SNWD_TTL_GROSS_AMOUNT	☐	EPM: Total Gross Amount
25	ITEM_NET_AMOUNT	SEPM_SDDL_V_SOI	NET_AMOUNT		☐	SNWD_TTL_NET_AMOUNT	☐	EPM: Total Net Amount
26	ITEM_TAX_AMOUNT	SEPM_SDDL_V_SOI	TAX_AMOUNT		☐	SNWD_TTL_TAX_AMOUNT	☐	EPM: Total Tax Amount
27	ITEM_CURRENCY_CODE	SEPM_SDDL_V_SOI	CURRENCY_CODE		☐	SNWD_CURR_CODE	☐	EPM: Currency Code
28	ITEM_PRODUCT_ID	SEPM_SDDL_PROD	PRODUCT_ID		☐	SNWD_PRODUCT_ID	☐	EPM: Product ID
29	ITEM_QUANTITY	SEPM_SDDL_V_SOSL	QUANTITY		☐	SNWD_QUANTITY	☐	EPM: Quantity
30	ITEM_QUANTITY_UNIT	SEPM_SDDL_V_SOSL	QUANTITY_UNIT		☐	SNWD_QUANTITY_UNIT	☐	EPM: Quantity Unit
31	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