SAP ABAP View /SAPSRM/V_SPO_MT (POs with Materials for Which ASNs Have Not Yet Been Created)

Hierarchy

☛ SRM_SERVER (Software Component) SRM_SERVER
   ⤷ SRM-EBP-CA-UI (Application Component) User Interface/Templates
     ⤷ /SAPSRM/PDO_CHIP_FEEDER_COMMON (Package) Feeder/Utility Classes for CHIP

Basic Data

View Type	D	Database View
Database View	/SAPSRM/V_SPO_MT
Short Description	POs with Materials for Which ASNs Have Not Yet Been Created
Root table	BBP_PDHGP	Business Transaction Purchasing Information

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	BBP_PDHGP	BBP_PDHGP
2	BBP_PDIGP
3	BBP_PDPSET
4	CRMD_ORDERADM_I
5	CRMD_ORDERADM_H

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	BBP_PDHGP	CLIENT	JL	EQ				0	0
2	BBP_PDIGP	CLIENT	JR	EQ			AND	0	0
3	CRMD_ORDERADM_I	CLIENT	JL	EQ				0	0
4	BBP_PDIGP	CLIENT	JR	EQ			AND	0	0
5	BBP_PDPSET	CLIENT	JL	EQ				0	0
6	BBP_PDIGP	CLIENT	JR	EQ			AND	0	0
7	BBP_PDHGP	GUID	JL	EQ				0	0
8	CRMD_ORDERADM_I	HEADER	JR	EQ			AND	0	0
9	BBP_PDIGP	GUID	JL	EQ				0	0
10	BBP_PDPSET	GUID	JR	EQ			AND	0	0
11	CRMD_ORDERADM_I	GUID	JL	EQ				0	0
12	BBP_PDIGP	GUID	JR	EQ			AND	0	0
13	CRMD_ORDERADM_H	GUID	JL	EQ				0	0
14	BBP_PDHGP	GUID	JR	EQ			AND	0	0
15	CRMD_ORDERADM_H	CLIENT	JL	EQ				0	0
16	BBP_PDIGP	CLIENT	JR	EQ			AND	0	0
17	BBP_PDPSET	ASN_IND		EQ	'X'		AND	0	0
18	BBP_PDHGP	VERSION_TYPE		EQ	''		AND	0	0
19	BBP_PDIGP	FINAL_ENTRY		NE	'X'		AND	0	0
20	BBP_PDIGP	DEL_IND		NE	'X'		AND	0	0
21	CRMD_ORDERADM_H	OBJECT_TYPE		EQ	'BUS2230'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	CRMD_ORDERADM_I	CLIENT		☐	MANDT	☐	Client
2	GUID_I	BBP_PDIGP	GUID		☐	BBP_GUID	☐	Globally Unique identifier
3	PRODUCT_TYPE	BBP_PDIGP	PRODUCT_TYPE		☐	BBP_PRODUCT_TYPE	☐	Product Type
4	DELIV_DATE	BBP_PDIGP	DELIV_DATE		☐	EINDT	☐	Item delivery date
5	QUANTITY	BBP_PDIGP	QUANTITY		☐	BBP_MNG	☐	Quantity in Order Unit
6	UNIT	BBP_PDIGP	UNIT		☐	BBP_UNIT	☐	Purchase Order Unit
7	GROSS_PRICE	BBP_PDIGP	GROSS_PRICE		☐	BBP_GROSS_PRICE	☐	Gross Price
8	PRICE	BBP_PDIGP	PRICE		☐	BBP_PRICE	☐	Net Price
9	PRICE_UNIT	BBP_PDIGP	PRICE_UNIT		☐	EPEIN	☐	Price unit
10	VALUE	BBP_PDIGP	VALUE		☐	BBP_VALUE	☐	Net Value
11	CURRENCY	BBP_PDIGP	CURRENCY		☐	WAERS	☐	Currency Key
12	FINAL_INV	BBP_PDIGP	FINAL_INV		☐	BBP_EREKZ	☐	Final invoice indicator
13	FINAL_ENTRY	BBP_PDIGP	FINAL_ENTRY		☐	BBP_FINAL_ENTRY	☐	Final Entry Indicator (Goods/Services)
14	VAL_ASN	BBP_PDIGP	VAL_ASN		☐	BBP_ASN_VALUE	☐	Ship Note Value Released
15	VAL_CF_E	BBP_PDIGP	VAL_CF_E		☐	BBP_CF_VALUE_E	☐	Value of Entered Confirmations
16	VAL_CF	BBP_PDIGP	VAL_CF		☐	BBP_CF_VALUE	☐	Value of Confirmations Released
17	VAL_IV_E	BBP_PDIGP	VAL_IV_E		☐	BBP_IV_VALUE_E	☐	Entered Invoice Value
18	VAL_IV	BBP_PDIGP	VAL_IV		☐	BBP_IV_VALUE	☐	Released Invoice Value
19	VAL_PO_E	BBP_PDIGP	VAL_PO_E		☐	BBP_PO_VALUE_E	☐	Value of POs/Confirmations/Invoices Created for Contract
20	VAL_PO_E_AGG	BBP_PDIGP	VAL_PO_E_AGG		☐	BBP_AGG_VALUE_E	☐	Value PO / Confirm. / Inv. for Contract Hierarchy
21	QUAN_ASN_E	BBP_PDIGP	QUAN_ASN_E		☐	BBP_ASN_QUANT_E	☐	Shipping Notification Quantity Entered
22	QUAN_ASN	BBP_PDIGP	QUAN_ASN		☐	BBP_ASN_QUANT	☐	Ship Note Quantity Releas'd
23	QUAN_CF_E	BBP_PDIGP	QUAN_CF_E		☐	BBP_CF_QUANT_E	☐	Quantity of Entered Confirmation
24	QUAN_CF	BBP_PDIGP	QUAN_CF		☐	BBP_CF_QUANT	☐	Quantity of Released Confirmations
25	QUAN_IV_E	BBP_PDIGP	QUAN_IV_E		☐	BBP_IV_QUANT_E	☐	Entered Invoiced Quantity
26	QUAN_IV	BBP_PDIGP	QUAN_IV		☐	BBP_IV_QUANT	☐	Released Invoiced Quantity
27	QUAN_PO_E	BBP_PDIGP	QUAN_PO_E		☐	BBP_PO_QUANT_E	☐	Quantity of POs/Confirmations/Invoices Created for Contract
28	NUM_ASN	BBP_PDIGP	NUM_ASN		☐	BBP_NUM_ASN	☐	No. of Shipping Notifications Entered for a PO
29	NUM_CONF	BBP_PDIGP	NUM_CONF		☐	BBP_NUM_CONF	☐	Number of Entered Confirmations for a Purchase Order
30	NUM_INV	BBP_PDIGP	NUM_INV		☐	BBP_NUM_INV	☐	Number of Entered Invoices for Purchase Order or Confirmat.
31	PRODUCT	CRMD_ORDERADM_I	PRODUCT		☐	CRMT_PRODUCT_GUID_DB	☐	Internal Unique ID of Product
32	NUMBER_INT	CRMD_ORDERADM_I	NUMBER_INT		☐	CRMT_ITEM_NO	☐	Item Number in Document
33	NUMBER_EXT	CRMD_ORDERADM_I	NUMBER_EXT		☐	CRMT_ITEM_NO_EXT	☐	External Item Number
34	ITM_TYPE	CRMD_ORDERADM_I	ITM_TYPE		☐	CRMT_ITEM_TYPE_DB	☐	Item Category
35	GUID_H	BBP_PDHGP	GUID		☐	BBP_GUID	☐	Globally Unique identifier
36	CLIENT1	BBP_PDHGP	CLIENT		☐	EC_CLIENT	☐	Client
37	CLIENT2	BBP_PDIGP	CLIENT		☐	EC_CLIENT	☐	Client
38	CLIENT3	BBP_PDPSET	CLIENT		☐	EC_CLIENT	☐	Client
39	GUID_PS	BBP_PDPSET	GUID		☐	BBP_GUID	☐	Globally Unique identifier
40	GUID_I2	CRMD_ORDERADM_I	GUID		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
41	CLIENT_HEAD	CRMD_ORDERADM_H	CLIENT		☐	MANDT	☐	Client
42	GUID_HEAD	CRMD_ORDERADM_H	GUID		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
43	OBJECT_ID	CRMD_ORDERADM_H	OBJECT_ID		☐	CRMT_OBJECT_ID_DB	☐	Transaction ID
44	SHIPPING_TS	BBP_PDIGP	SHIPPING_TS		☐	BBP_SHIPPING_TS	☐	Shipping Date and Time (Time Stamp)

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	701