SAP ABAP View SEPM_SDDL_SO_J (Generates fr.DDL Srce SEPM_SDDL_SO_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_J
Short Description	Generates fr.DDL Srce SEPM_SDDL_SO_JOIN
Root table	SEPM_SDDL_V_SOH	Generated Table for View

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SEPM_SDDL_V_SOH	SEPM_SDDL_V_SOH
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_V_SOH	MANDT	JL	EQ				0	0
2	SEPM_SDDL_V_EMPL	MANDT	JR	EQ			AND	0	0
3	SEPM_SDDL_V_SOH	CREATED_BY_EMPLOYEE_KEY	JL	EQ				0	0
4	SEPM_SDDL_V_EMPL	EMPLOYEE_KEY	JR	EQ			AND	0	0
5	SEPM_SDDL_V_SOH	MANDT	JL	EQ				0	0
6	SEPM_V_BPA	MANDT	JR	EQ			AND	0	0
7	SEPM_SDDL_V_SOH	BUYER_KEY	JL	EQ				0	0
8	SEPM_V_BPA	BUSINESS_PARTNER_KEY	JR	EQ			AND	0	0
9	SEPM_SDDL_V_SOH	MANDT	JL	EQ				0	0
10	SEPM_SDDL_TEXK_T	MANDT	JR	EQ			AND	0	0
11	SEPM_SDDL_V_SOH	NOTE_KEY	JL	EQ				0	0
12	SEPM_SDDL_TEXK_T	TEXT_ORIGINAL_LANGUAGE_KEY	JR	EQ			AND	0	0
13	SEPM_SDDL_V_SOH	MANDT	JL	EQ				0	0
14	SEPM_SDDL_V_TEXT	MANDT	JR	EQ			AND	0	0
15	SEPM_SDDL_V_SOH	NOTE_KEY	JL	EQ				0	0
16	SEPM_SDDL_V_TEXT	ORIGINAL_LANUAGE_KEY	JR	EQ			AND	0	0
17	SEPM_SDDL_V_SOH	MANDT	JL	EQ				0	0
18	SEPM_SDDL_V_SOI	MANDT	JR	EQ			AND	0	0
19	SEPM_SDDL_V_SOH	SALES_ORDER_KEY	JL	EQ				0	0
20	SEPM_SDDL_V_SOI	SALES_ORDER_KEY	JR	EQ			AND	0	0
21	SEPM_SDDL_V_SOH	MANDT	JL	EQ				0	0
22	SEPM_SDDL_PROD	MANDT	JR	EQ			AND	0	0
23	SEPM_SDDL_V_SOI	PRODUCT_KEY	JL	EQ				0	0
24	SEPM_SDDL_PROD	PRODUCT_KEY	JR	EQ			AND	0	0
25	SEPM_SDDL_V_SOH	MANDT	JL	EQ				0	0
26	SEPM_SDDL_V_SOSL	MANDT	JR	EQ			AND	0	0
27	SEPM_SDDL_V_SOI	ITEM_KEY	JL	EQ				0	0
28	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_V_SOH	MANDT		☐	MANDT	☐	Client
2	SALES_ORDER_ID	SEPM_SDDL_V_SOH	SALES_ORDER_ID		☐	SNWD_SO_ID	☐	EPM: Sales Order Number
3	TOTAL_GROSS_AMOUNT	SEPM_SDDL_V_SOH	GROSS_AMOUNT		☐	SNWD_TTL_GROSS_AMOUNT	☐	EPM: Total Gross Amount
4	CREATED_AT	SEPM_SDDL_V_SOH	CREATED_AT		☐	TIMESTAMPL	☐	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
5	CURRENCY_CODE	SEPM_SDDL_V_SOH	CURRENCY_CODE		☐	SNWD_CURR_CODE	☐	EPM: Currency Code
6	DELIVERY_STATUS	SEPM_SDDL_V_SOH	DELIVERY_STATUS		☐	SNWD_SO_OR_STATUS_CODE	☐	EPM: Sales Order Ordering Status
7	CREATED_BY_LASTNAME	SEPM_SDDL_V_EMPL	LAST_NAME		☐	SNWD_LAST_NAME	☐	EPM: Last Name
8	CREATED_BY_FIRSTNAME	SEPM_SDDL_V_EMPL	FIRST_NAME		☐	SNWD_FIRST_NAME	☐	EPM: First Name
9	BUYER_ID	SEPM_V_BPA	BUSINESS_PARTNER_ID		☐	SNWD_PARTNER_ID	☐	EPM: Business Partner ID
10	BUYER_NAME	SEPM_V_BPA	COMPANY_NAME		☐	SNWD_COMPANY_NAME	☐	EPM: Company Name
11	ORIGINAL_NOTE_LANGUAGE	SEPM_SDDL_TEXK_T	ORIGINAL_LANGUAGE		☐	SPRAS	☐	Language Key
12	NOTE_LANGUAGE	SEPM_SDDL_V_TEXT	LANGUAGE		☐	SPRAS	☐	Language Key
13	HEADER_NOTE_TEXT	SEPM_SDDL_V_TEXT	TEXT		☐	SNWD_DESC	☐	EPM: Text field for names and descriptions
14	ITEM_POSITITION	SEPM_SDDL_V_SOI	ITEM_POSITION		☐	SNWD_SO_ITEM_POS	☐	EPM: Sales Order Item Position
15	ITEM_GROSS_AMMOUNT	SEPM_SDDL_V_SOI	GROSS_AMOUNT		☐	SNWD_TTL_GROSS_AMOUNT	☐	EPM: Total Gross Amount
16	ITEM_PRODUCT_ID	SEPM_SDDL_PROD	PRODUCT_ID		☐	SNWD_PRODUCT_ID	☐	EPM: Product ID
17	ITEM_QUANTITY	SEPM_SDDL_V_SOSL	QUANTITY		☐	SNWD_QUANTITY	☐	EPM: Quantity

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	20141121
SAP Release Created in	740