SAP ABAP View EPM_V_PO (View for EPM Purchase Order)

Hierarchy

☛ PI_BASIS (Software Component) Basis Plug-In
   ⤷ CA (Application Component) Cross-Application Components
     ⤷ PI_EPM (Package) Enterprise Procurement Model

Basic Data

View Type	D	Database View
Database View	EPM_V_PO
Short Description	View for EPM Purchase Order
Root table	SNWD_PO	EPM: Purchase Order Header Table

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SNWD_PO	SNWD_PO
2	SNWD_PO_I
3	SNWD_PO_SL
4	SNWD_PD
5	SNWD_BPA
6	SNWD_EMPLOYEES

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	SNWD_PO	CLIENT	JL	EQ				0	0
2	SNWD_PO_I	CLIENT	JR	EQ			AND	0	0
3	SNWD_PO_I	CLIENT	JL	EQ				0	0
4	SNWD_PO_SL	CLIENT	JR	EQ			AND	0	0
5	SNWD_PO_I	CLIENT	JL	EQ				0	0
6	SNWD_PD	CLIENT	JR	EQ			AND	0	0
7	SNWD_PO	NODE_KEY	JL	EQ				0	0
8	SNWD_PO_I	PARENT_KEY	JR	EQ			AND	0	0
9	SNWD_PO_I	NODE_KEY	JL	EQ				0	0
10	SNWD_PO_SL	PARENT_KEY	JR	EQ			AND	0	0
11	SNWD_PO_I	PRODUCT_GUID	JL	EQ				0	0
12	SNWD_PD	NODE_KEY	JR	EQ			AND	0	0
13	SNWD_PO	CLIENT	JL	EQ				0	0
14	SNWD_BPA	CLIENT	JR	EQ			AND	0	0
15	SNWD_PO	PARTNER_GUID	JL	EQ				0	0
16	SNWD_BPA	NODE_KEY	JR	EQ			AND	0	0
17	SNWD_PO	CLIENT	JL	EQ				0	0
18	SNWD_EMPLOYEES	CLIENT	JR	EQ			AND	0	0
19	SNWD_PO	CREATED_BY	JL	EQ				0	0
20	SNWD_EMPLOYEES	NODE_KEY	JR	EQ			AND	0	0
21	SNWD_PO	CHANGED_BY	JL	EQ				0	0
22	SNWD_EMPLOYEES	NODE_KEY	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	SNWD_PO	CLIENT		☐	MANDT	☐	Client
2	NODE_KEY	SNWD_PO	NODE_KEY		☐	SNWD_NODE_KEY	☐	EPM: Generic Node Key
3	NODE_KEY_I	SNWD_PO_I	NODE_KEY		☐	SNWD_NODE_KEY	☐	EPM: Generic Node Key
4	PO_ID	SNWD_PO	PO_ID		☐	SNWD_PO_ID	☐	EPM: Purchase Order Number
5	CREATED_BY	SNWD_EMPLOYEES	EMPLOYEE_ID		☐	SNWD_ID	☐	EPM: Employee ID
6	CREATED_AT	SNWD_PO	CREATED_AT		☐	TIMESTAMPL	☐	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
7	CHANGED_BY	SNWD_EMPLOYEES	EMPLOYEE_ID		☐	SNWD_ID	☐	EPM: Employee ID
8	CHANGED_AT	SNWD_PO	CHANGED_AT		☐	TIMESTAMPL	☐	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
9	NOTE_GUID	SNWD_PO	NOTE_GUID		☐	SNWD_NODE_KEY	☐	EPM: Generic Node Key
10	CURRENCY_CODE	SNWD_PO	CURRENCY_CODE		☐	SNWD_CURR_CODE	☐	EPM: Currency Code
11	GROSS_AMOUNT	SNWD_PO	GROSS_AMOUNT		☐	SNWD_TTL_GROSS_AMOUNT	☐	EPM: Total Gross Amount
12	NET_AMOUNT	SNWD_PO	NET_AMOUNT		☐	SNWD_TTL_NET_AMOUNT	☐	EPM: Total Net Amount
13	TAX_AMOUNT	SNWD_PO	TAX_AMOUNT		☐	SNWD_TTL_TAX_AMOUNT	☐	EPM: Total Tax Amount
14	LIFECYCLE_STATUS	SNWD_PO	LIFECYCLE_STATUS		☐	SNWD_PO_LC_STATUS_CODE	☐	EPM: Purchase Order Lifecycle Status
15	APPROVAL_STATUS	SNWD_PO	APPROVAL_STATUS		☐	SNWD_PO_AP_STATUS_CODE	☐	EPM: Purchase Order Approval Status
16	CONFIRM_STATUS	SNWD_PO	CONFIRM_STATUS		☐	SNWD_PO_CF_STATUS_CODE	☐	EPM: Purchase Order Confirmation Status
17	ORDERING_STATUS	SNWD_PO	ORDERING_STATUS		☐	SNWD_PO_OR_STATUS_CODE	☐	EPM: Purchase Order Ordering Status
18	PO_ITEM_POS	SNWD_PO_I	PO_ITEM_POS		☐	SNWD_PO_ITEM_POS	☐	EPM: Purchase Order Item Position
19	NOTE_GUID_I	SNWD_PO_I	NOTE_GUID		☐	SNWD_NODE_KEY	☐	EPM: Generic Node Key
20	CURRENCY_CODE_I	SNWD_PO_I	CURRENCY_CODE		☐	SNWD_CURR_CODE	☐	EPM: Currency Code
21	GROSS_AMOUNT_I	SNWD_PO_I	GROSS_AMOUNT		☐	SNWD_TTL_GROSS_AMOUNT	☐	EPM: Total Gross Amount
22	NET_AMOUNT_I	SNWD_PO_I	NET_AMOUNT		☐	SNWD_TTL_NET_AMOUNT	☐	EPM: Total Net Amount
23	TAX_AMOUNT_I	SNWD_PO_I	TAX_AMOUNT		☐	SNWD_TTL_TAX_AMOUNT	☐	EPM: Total Tax Amount
24	QUANTITY	SNWD_PO_SL	QUANTITY		☐	SNWD_QUANTITY	☐	EPM: Quantity
25	QUANTITY_UNIT	SNWD_PO_SL	QUANTITY_UNIT		☐	SNWD_QUANTITY_UNIT	☐	EPM: Quantity Unit
26	DELIVERY_DATE	SNWD_PO_SL	DELIVERY_DATE		☐	TIMESTAMPL	☐	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
27	PRODUCT_ID	SNWD_PD	PRODUCT_ID		☐	SNWD_PRODUCT_ID	☐	EPM: Product ID
28	BP_ID	SNWD_BPA	BP_ID		☐	SNWD_PARTNER_ID	☐	EPM: Business Partner ID

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	SAP	20140117
SAP Release Created in	720