SAP ABAP View SEPM_SDDL_SO_J_A (Generates fr.DDL Srce SEPM_SDDL_SO_JOIN_ALL)

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_A
Short Description	Generates fr.DDL Srce SEPM_SDDL_SO_JOIN_ALL
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_SDDL_V_EMPL	MANDT	JR	EQ			AND	0	0
7	SEPM_SDDL_V_SOH	CHANGED_BY_EMPLOYEE_KEY	JL	EQ				0	0
8	SEPM_SDDL_V_EMPL	EMPLOYEE_KEY	JR	EQ			AND	0	0
9	SEPM_SDDL_V_SOH	MANDT	JL	EQ				0	0
10	SEPM_V_BPA	MANDT	JR	EQ			AND	0	0
11	SEPM_SDDL_V_SOH	BUYER_KEY	JL	EQ				0	0
12	SEPM_V_BPA	BUSINESS_PARTNER_KEY	JR	EQ			AND	0	0
13	SEPM_SDDL_V_SOH	MANDT	JL	EQ				0	0
14	SEPM_SDDL_TEXK_T	MANDT	JR	EQ			AND	0	0
15	SEPM_SDDL_V_SOH	NOTE_KEY	JL	EQ				0	0
16	SEPM_SDDL_TEXK_T	TEXT_ORIGINAL_LANGUAGE_KEY	JR	EQ			AND	0	0
17	SEPM_SDDL_V_SOH	MANDT	JL	EQ				0	0
18	SEPM_SDDL_V_TEXT	MANDT	JR	EQ			AND	0	0
19	SEPM_SDDL_V_SOH	NOTE_KEY	JL	EQ				0	0
20	SEPM_SDDL_V_TEXT	ORIGINAL_LANUAGE_KEY	JR	EQ			AND	0	0
21	SEPM_SDDL_V_SOH	MANDT	JL	EQ				0	0
22	SEPM_SDDL_V_SOI	MANDT	JR	EQ			AND	0	0
23	SEPM_SDDL_V_SOH	SALES_ORDER_KEY	JL	EQ				0	0
24	SEPM_SDDL_V_SOI	SALES_ORDER_KEY	JR	EQ			AND	0	0
25	SEPM_SDDL_V_SOH	MANDT	JL	EQ				0	0
26	SEPM_SDDL_PROD	MANDT	JR	EQ			AND	0	0
27	SEPM_SDDL_V_SOI	PRODUCT_KEY	JL	EQ				0	0
28	SEPM_SDDL_PROD	PRODUCT_KEY	JR	EQ			AND	0	0
29	SEPM_SDDL_V_SOH	MANDT	JL	EQ				0	0
30	SEPM_SDDL_V_SOSL	MANDT	JR	EQ			AND	0	0
31	SEPM_SDDL_V_SOI	ITEM_KEY	JL	EQ				0	0
32	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	TOTAL_NET_AMOUNT	SEPM_SDDL_V_SOH	NET_AMOUNT		☐	SNWD_TTL_NET_AMOUNT	☐	EPM: Total Net Amount
5	TOTAL_TAX_AMOUNT	SEPM_SDDL_V_SOH	TAX_AMOUNT		☐	SNWD_TTL_TAX_AMOUNT	☐	EPM: Total Tax Amount
6	CREATED_BY	SEPM_SDDL_V_EMPL	EMPLOYEE_ID		☐	SNWD_ID	☐	EPM: Employee ID
7	CHANGED_BY	SEPM_SDDL_V_EMPL	EMPLOYEE_ID		☐	SNWD_ID	☐	EPM: Employee ID
8	CREATED_AT	SEPM_SDDL_V_SOH	CREATED_AT		☐	TIMESTAMPL	☐	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
9	CHANGED_AT	SEPM_SDDL_V_SOH	CHANGED_AT		☐	TIMESTAMPL	☐	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
10	CURRENCY_CODE	SEPM_SDDL_V_SOH	CURRENCY_CODE		☐	SNWD_CURR_CODE	☐	EPM: Currency Code
11	DELIVERY_STATUS	SEPM_SDDL_V_SOH	DELIVERY_STATUS		☐	SNWD_SO_OR_STATUS_CODE	☐	EPM: Sales Order Ordering Status
12	LIFECYCLE_STATUS	SEPM_SDDL_V_SOH	LIFECYCLE_STATUS		☐	SNWD_SO_LC_STATUS_CODE	☐	EPM: Sales Order Lifecycle Status
13	BILLING_STATUS	SEPM_SDDL_V_SOH	BILLING_STATUS		☐	SNWD_SO_CF_STATUS_CODE	☐	EPM: Sales Order Confirmation Status
14	CREATED_BY_LASTNAME	SEPM_SDDL_V_EMPL	LAST_NAME		☐	SNWD_LAST_NAME	☐	EPM: Last Name
15	CREATED_BY_FIRSTNAME	SEPM_SDDL_V_EMPL	FIRST_NAME		☐	SNWD_FIRST_NAME	☐	EPM: First Name
16	BUYER_ID	SEPM_V_BPA	BUSINESS_PARTNER_ID		☐	SNWD_PARTNER_ID	☐	EPM: Business Partner ID
17	BUYER_NAME	SEPM_V_BPA	COMPANY_NAME		☐	SNWD_COMPANY_NAME	☐	EPM: Company Name
18	ORIGINAL_NOTE_LANGUAGE	SEPM_SDDL_TEXK_T	ORIGINAL_LANGUAGE		☐	SPRAS	☐	Language Key
19	NOTE_LANGUAGE	SEPM_SDDL_V_TEXT	LANGUAGE		☐	SPRAS	☐	Language Key
20	HEADER_NOTE_TEXT	SEPM_SDDL_V_TEXT	TEXT		☐	SNWD_DESC	☐	EPM: Text field for names and descriptions
21	ITEM_POSITITION	SEPM_SDDL_V_SOI	ITEM_POSITION		☐	SNWD_SO_ITEM_POS	☐	EPM: Sales Order Item Position
22	ITEM_GROSS_AMMOUNT	SEPM_SDDL_V_SOI	GROSS_AMOUNT		☐	SNWD_TTL_GROSS_AMOUNT	☐	EPM: Total Gross Amount
23	ITEM_NET_AMMOUNT	SEPM_SDDL_V_SOI	NET_AMOUNT		☐	SNWD_TTL_NET_AMOUNT	☐	EPM: Total Net Amount
24	ITEM_TAX_AMMOUNT	SEPM_SDDL_V_SOI	TAX_AMOUNT		☐	SNWD_TTL_TAX_AMOUNT	☐	EPM: Total Tax Amount
25	ITEM_PRODUCT_ID	SEPM_SDDL_PROD	PRODUCT_ID		☐	SNWD_PRODUCT_ID	☐	EPM: Product ID
26	ITEM_QUANTITY	SEPM_SDDL_V_SOSL	QUANTITY		☐	SNWD_QUANTITY	☐	EPM: Quantity
27	ITEM_QUANTITY_UNIT	SEPM_SDDL_V_SOSL	QUANTITY_UNIT		☐	SNWD_QUANTITY_UNIT	☐	EPM: Quantity Unit
28	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	20141121
SAP Release Created in	740