SAP ABAP View EPM_V_PO_SUPPL (EPM_V_PO_SUPPL)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-NWD (Application Component) NetWeaver Demonstration
     ⤷ S_NWDEMO_OBSOLETE (Package) Obsolete Objects - Do Not Use

Basic Data

View Type	D	Database View
Database View	EPM_V_PO_SUPPL
Short Description	EPM_V_PO_SUPPL
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_BPA
3	SNWD_BPA_CONTACT
4	SNWD_AD

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_BPA	CLIENT	JR	EQ			AND	0	0
3	SNWD_PO	PARTNER_GUID	JL	EQ				0	0
4	SNWD_BPA	NODE_KEY	JR	EQ			AND	0	0
5	SNWD_BPA	CLIENT	JL	EQ				0	0
6	SNWD_BPA_CONTACT	CLIENT	JR	EQ			AND	0	0
7	SNWD_BPA	NODE_KEY	JL	EQ				0	0
8	SNWD_BPA_CONTACT	PARENT_KEY	JR	EQ			AND	0	0
9	SNWD_BPA_CONTACT	CLIENT	JL	EQ				0	0
10	SNWD_AD	CLIENT	JR	EQ			AND	0	0
11	SNWD_BPA_CONTACT	ADDRESS_GUID	JL	EQ				0	0
12	SNWD_AD	NODE_KEY	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	NODE_KEY	SNWD_PO	NODE_KEY		☐	SNWD_NODE_KEY	☐	EPM: Generic Node Key
2	CLIENT	SNWD_PO	CLIENT		☐	MANDT	☐	Client
3	BP_CITY	SNWD_AD	CITY		☐	SNWD_CITY	☐	EPM: City
4	BP_POSTAL_CODE	SNWD_AD	POSTAL_CODE		☐	SNWD_POSTAL_CODE	☐	EPM: Postal Code
5	BP_COUNTRY	SNWD_AD	COUNTRY		☐	SNWD_COUNTRY	☐	EPM: Country Code
6	PO_ID	SNWD_PO	PO_ID		☐	SNWD_PO_ID	☐	EPM: Purchase Order Number
7	CREATED_BY	SNWD_PO	CREATED_BY		☐	SNWD_NODE_KEY	☐	EPM: Generic Node Key
8	CREATED_AT	SNWD_PO	CREATED_AT		☐	TIMESTAMPL	☐	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
9	CHANGED_BY	SNWD_PO	CHANGED_BY		☐	SNWD_NODE_KEY	☐	EPM: Generic Node Key
10	CHANGED_AT	SNWD_PO	CHANGED_AT		☐	TIMESTAMPL	☐	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
11	PARTNER_GUID	SNWD_PO	PARTNER_GUID		☐	SNWD_NODE_KEY	☐	EPM: Generic Node Key
12	CURRENCY_CODE	SNWD_PO	CURRENCY_CODE		☐	SNWD_CURR_CODE	☐	EPM: Currency Code
13	GROSS_AMOUNT	SNWD_PO	GROSS_AMOUNT		☐	SNWD_TTL_GROSS_AMOUNT	☐	EPM: Total Gross Amount
14	NET_AMOUNT	SNWD_PO	NET_AMOUNT		☐	SNWD_TTL_NET_AMOUNT	☐	EPM: Total Net Amount
15	TAX_AMOUNT	SNWD_PO	TAX_AMOUNT		☐	SNWD_TTL_TAX_AMOUNT	☐	EPM: Total Tax Amount
16	LIFECYCLE_STATUS	SNWD_PO	LIFECYCLE_STATUS		☐	SNWD_PO_LC_STATUS_CODE	☐	EPM: Purchase Order Lifecycle Status
17	APPROVAL_STATUS	SNWD_PO	APPROVAL_STATUS		☐	SNWD_PO_AP_STATUS_CODE	☐	EPM: Purchase Order Approval Status
18	CONFIRM_STATUS	SNWD_PO	CONFIRM_STATUS		☐	SNWD_PO_CF_STATUS_CODE	☐	EPM: Purchase Order Confirmation Status
19	ORDERING_STATUS	SNWD_PO	ORDERING_STATUS		☐	SNWD_PO_OR_STATUS_CODE	☐	EPM: Purchase Order Ordering Status

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