SAP ABAP Table SNWD_PO (EPM: Purchase Order Header Table)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-NWD (Application Component) NetWeaver Demonstration
     ⤷ S_NWDEMO_MODEL_DDIC (Package) Common Data Dictionary Objects (only) for EPM and NWDEMO

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SNWD_PO	Table Relationship Diagram
Short Description	EPM: Purchase Order Header Table

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	NODE_KEY	☑	SNWD_NODE_KEY	SYSUUID	RAW	16	0	EPM: Generic Node Key
3	PO_ID	☐	SNWD_PO_ID	D_EPM_ID	CHAR	10	0	EPM: Purchase Order Number
4	.INCLUDE	☐				0	0	EPM: Include-Structure for various tables
5	CREATED_BY	☐	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_BY	☐	SNWD_NODE_KEY	SYSUUID	RAW	16	0	EPM: Generic Node Key	SNWD_EMPLOYEES
8	CHANGED_AT	☐	TIMESTAMPL	TZNTSTMPL	DEC	21	7	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
9	NOTE_GUID	☐	SNWD_NODE_KEY	SYSUUID	RAW	16	0	EPM: Generic Node Key	SNWD_TEXT_KEY
10	PARTNER_GUID	☐	SNWD_NODE_KEY	SYSUUID	RAW	16	0	EPM: Generic Node Key	SNWD_BPA
11	CURRENCY_CODE	☐	SNWD_CURR_CODE		CUKY	5	0	EPM: Currency Code
12	GROSS_AMOUNT	☐	SNWD_TTL_GROSS_AMOUNT		CURR	15	2	EPM: Total Gross Amount
13	NET_AMOUNT	☐	SNWD_TTL_NET_AMOUNT		CURR	15	2	EPM: Total Net Amount
14	TAX_AMOUNT	☐	SNWD_TTL_TAX_AMOUNT		CURR	15	2	EPM: Total Tax Amount
15	LIFECYCLE_STATUS	☐	SNWD_PO_LC_STATUS_CODE	D_PO_LC	CHAR	1	0	EPM: Purchase Order Lifecycle Status
16	APPROVAL_STATUS	☐	SNWD_PO_AP_STATUS_CODE	D_PO_AP	CHAR	1	0	EPM: Purchase Order Approval Status
17	CONFIRM_STATUS	☐	SNWD_PO_CF_STATUS_CODE	D_PO_CF	CHAR	1	0	EPM: Purchase Order Confirmation Status
18	ORDERING_STATUS	☐	SNWD_PO_OR_STATUS_CODE	D_PO_OR	CHAR	1	0	EPM: Purchase Order Ordering Status
19	INVOICING_STATUS	☐	SNWD_PO_IN_STATUS_CODE	D_PO_IN	CHAR	1	0	EPM: Purchase Order Invoicing Status

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SNWD_PO	CHANGED_BY	SNWD_EMPLOYEES	NODE_KEY		1	CN
2	SNWD_PO	CLIENT	T000	MANDT		1	CN
3	SNWD_PO	CREATED_BY	SNWD_EMPLOYEES	NODE_KEY		1	CN
4	SNWD_PO	NOTE_GUID	SNWD_TEXT_KEY	NODE_KEY		1	C
5	SNWD_PO	PARTNER_GUID	SNWD_BPA	NODE_KEY		1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in	720