SAP ABAP Table SEPM_SDDL_V_SOH (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	SEPM_SDDL_V_SOH	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	SALES_ORDER_KEY	☑	SNWD_NODE_KEY	SYSUUID	RAW	16	0	EPM: Generic Node Key
3	SALES_ORDER_ID	☐	SNWD_SO_ID	D_EPM_ID	CHAR	10	0	EPM: Sales Order Number
4	CREATED_BY_EMPLOYEE_KEY	☐	SNWD_NODE_KEY	SYSUUID	RAW	16	0	EPM: Generic Node Key	SNWD_EMPLOYEES
5	CHANGED_BY_EMPLOYEE_KEY	☐	SNWD_NODE_KEY	SYSUUID	RAW	16	0	EPM: Generic Node Key	SNWD_EMPLOYEES
6	CREATED_AT	☐	TIMESTAMPL	TZNTSTMPL	DEC	21	7	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
7	CHANGED_AT	☐	TIMESTAMPL	TZNTSTMPL	DEC	21	7	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
8	CREATED_BY_BUYER_KEY	☐	SNWD_BOOL	D_BOOL	CHAR	1	0	EPM: Boolean
9	CHANGED_BY_BUYER_KEY	☐	SNWD_BOOL	D_BOOL	CHAR	1	0	EPM: Boolean
10	NOTE_KEY	☐	SNWD_NODE_KEY	SYSUUID	RAW	16	0	EPM: Generic Node Key	SNWD_TEXT_KEY
11	SALES_OPPORTUNITY_ID	☐	SNWD_OP_ID		CHAR	35	0	EPM: Opportunity ID for SoD IDoc processing
12	CURRENCY_CODE	☐	SNWD_CURR_CODE		CUKY	5	0	EPM: Currency Code
13	GROSS_AMOUNT	☐	SNWD_TTL_GROSS_AMOUNT		CURR	15	2	EPM: Total Gross Amount
14	NET_AMOUNT	☐	SNWD_TTL_NET_AMOUNT		CURR	15	2	EPM: Total Net Amount
15	TAX_AMOUNT	☐	SNWD_TTL_TAX_AMOUNT		CURR	15	2	EPM: Total Tax Amount
16	LIFECYCLE_STATUS	☐	SNWD_SO_LC_STATUS_CODE	D_SO_LC	CHAR	1	0	EPM: Sales Order Lifecycle Status
17	BILLING_STATUS	☐	SNWD_SO_CF_STATUS_CODE	D_SO_CF	CHAR	1	0	EPM: Sales Order Confirmation Status
18	DELIVERY_STATUS	☐	SNWD_SO_OR_STATUS_CODE	D_SO_OR	CHAR	1	0	EPM: Sales Order Ordering Status
19	BUYER_KEY	☐	SNWD_NODE_KEY	SYSUUID	RAW	16	0	EPM: Generic Node Key	SNWD_BPA

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SEPM_SDDL_V_SOH	BUYER_KEY	SNWD_BPA	NODE_KEY		1	CN
2	SEPM_SDDL_V_SOH	CHANGED_BY_EMPLOYEE_KEY	SNWD_EMPLOYEES	NODE_KEY		1	CN
3	SEPM_SDDL_V_SOH	CREATED_BY_EMPLOYEE_KEY	SNWD_EMPLOYEES	NODE_KEY		1	CN
4	SEPM_SDDL_V_SOH	MANDT	T000	MANDT		1	CN
5	SEPM_SDDL_V_SOH	NOTE_KEY	SNWD_TEXT_KEY	NODE_KEY		1	C

History

Last changed by/on	DDIC	20141121
SAP Release Created in