SAP ABAP View /SAPSRM/V_SPO_SR (POs with Services for Which SESs 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_SR
Short Description	POs with Services for Which SESs 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	GR_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	BBP_PDIGP	PRODUCT_TYPE		EQ	'02'		AND	0	0
22	CRMD_ORDERADM_I	ITM_TYPE		EQ	''		AND	0	0
23	CRMD_ORDERADM_H	OBJECT_TYPE		EQ	'BUS2230'		AND	0	0
24	CRMD_ORDERADM_I	OBJECT_TYPE		EQ	'BUS2230001'			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	CATEGORY	BBP_PDIGP	CATEGORY		☐	BBP_CATEGORY_GUID_RAW	☐	Product Category GUID
4	CATEGORY_ID	BBP_PDIGP	CATEGORY_ID		☐	BBP_CATEGORY_ID	☐	Product Category ID
5	PRODUCT_TYPE	BBP_PDIGP	PRODUCT_TYPE		☐	BBP_PRODUCT_TYPE	☐	Product Type
6	DELIV_DATE	BBP_PDIGP	DELIV_DATE		☐	EINDT	☐	Item delivery date
7	DELIV_TIME	BBP_PDIGP	DELIV_TIME		☐	BBP_DELIV_TIME	☐	Delivery Time of the Item
8	VPER_START	BBP_PDIGP	VPER_START		☐	BBP_VPER_START	☐	Validity Period From
9	VPER_END	BBP_PDIGP	VPER_END		☐	BBP_VPER_END	☐	Validity period
10	QUANTITY	BBP_PDIGP	QUANTITY		☐	BBP_MNG	☐	Quantity in Order Unit
11	UNIT	BBP_PDIGP	UNIT		☐	BBP_UNIT	☐	Purchase Order Unit
12	GROSS_PRICE	BBP_PDIGP	GROSS_PRICE		☐	BBP_GROSS_PRICE	☐	Gross Price
13	PRICE	BBP_PDIGP	PRICE		☐	BBP_PRICE	☐	Net Price
14	PRICE_UNIT	BBP_PDIGP	PRICE_UNIT		☐	EPEIN	☐	Price unit
15	PRICE_ORIGIN	BBP_PDIGP	PRICE_ORIGIN		☐	BBP_PRICE_ORIGIN	☐	Original Price (Determination/Manual Input)
16	VALUE	BBP_PDIGP	VALUE		☐	BBP_VALUE	☐	Net Value
17	CURRENCY	BBP_PDIGP	CURRENCY		☐	WAERS	☐	Currency Key
18	FINAL_INV	BBP_PDIGP	FINAL_INV		☐	BBP_EREKZ	☐	Final invoice indicator
19	FINAL_ENTRY	BBP_PDIGP	FINAL_ENTRY		☐	BBP_FINAL_ENTRY	☐	Final Entry Indicator (Goods/Services)
20	VAL_ASN	BBP_PDIGP	VAL_ASN		☐	BBP_ASN_VALUE	☐	Ship Note Value Released
21	VAL_CF_E	BBP_PDIGP	VAL_CF_E		☐	BBP_CF_VALUE_E	☐	Value of Entered Confirmations
22	VAL_CF	BBP_PDIGP	VAL_CF		☐	BBP_CF_VALUE	☐	Value of Confirmations Released
23	VAL_IV_E	BBP_PDIGP	VAL_IV_E		☐	BBP_IV_VALUE_E	☐	Entered Invoice Value
24	VAL_IV	BBP_PDIGP	VAL_IV		☐	BBP_IV_VALUE	☐	Released Invoice Value
25	VAL_PO_E	BBP_PDIGP	VAL_PO_E		☐	BBP_PO_VALUE_E	☐	Value of POs/Confirmations/Invoices Created for Contract
26	VAL_PO_E_AGG	BBP_PDIGP	VAL_PO_E_AGG		☐	BBP_AGG_VALUE_E	☐	Value PO / Confirm. / Inv. for Contract Hierarchy
27	QUAN_ASN_E	BBP_PDIGP	QUAN_ASN_E		☐	BBP_ASN_QUANT_E	☐	Shipping Notification Quantity Entered
28	QUAN_ASN	BBP_PDIGP	QUAN_ASN		☐	BBP_ASN_QUANT	☐	Ship Note Quantity Releas'd
29	QUAN_CF_E	BBP_PDIGP	QUAN_CF_E		☐	BBP_CF_QUANT_E	☐	Quantity of Entered Confirmation
30	QUAN_CF	BBP_PDIGP	QUAN_CF		☐	BBP_CF_QUANT	☐	Quantity of Released Confirmations
31	QUAN_IV_E	BBP_PDIGP	QUAN_IV_E		☐	BBP_IV_QUANT_E	☐	Entered Invoiced Quantity
32	QUAN_IV	BBP_PDIGP	QUAN_IV		☐	BBP_IV_QUANT	☐	Released Invoiced Quantity
33	QUAN_PO_E	BBP_PDIGP	QUAN_PO_E		☐	BBP_PO_QUANT_E	☐	Quantity of POs/Confirmations/Invoices Created for Contract
34	NUM_ASN	BBP_PDIGP	NUM_ASN		☐	BBP_NUM_ASN	☐	No. of Shipping Notifications Entered for a PO
35	NUM_CONF	BBP_PDIGP	NUM_CONF		☐	BBP_NUM_CONF	☐	Number of Entered Confirmations for a Purchase Order
36	NUM_INV	BBP_PDIGP	NUM_INV		☐	BBP_NUM_INV	☐	Number of Entered Invoices for Purchase Order or Confirmat.
37	EXLIN	BBP_PDIGP	EXLIN		☐	/SAPSRM/EXLIN	☐	Configurable Line Item Number
38	PRODUCT	CRMD_ORDERADM_I	PRODUCT		☐	CRMT_PRODUCT_GUID_DB	☐	Internal Unique ID of Product
39	ORDERED_PROD	CRMD_ORDERADM_I	ORDERED_PROD		☐	CRMT_ORDERED_PROD_DB	☐	Product Name Entered
40	DESCRIPTION_I	CRMD_ORDERADM_I	DESCRIPTION		☐	CRMT_PRSHTEXTX_DB	☐	Product Short Text
41	NUMBER_INT	CRMD_ORDERADM_I	NUMBER_INT		☐	CRMT_ITEM_NO	☐	Item Number in Document
42	NUMBER_EXT	CRMD_ORDERADM_I	NUMBER_EXT		☐	CRMT_ITEM_NO_EXT	☐	External Item Number
43	ITM_TYPE	CRMD_ORDERADM_I	ITM_TYPE		☐	CRMT_ITEM_TYPE_DB	☐	Item Category
44	GUID_H	BBP_PDHGP	GUID		☐	BBP_GUID	☐	Globally Unique identifier
45	CLIENT1	BBP_PDHGP	CLIENT		☐	EC_CLIENT	☐	Client
46	CLIENT2	BBP_PDIGP	CLIENT		☐	EC_CLIENT	☐	Client
47	CLIENT3	BBP_PDPSET	CLIENT		☐	EC_CLIENT	☐	Client
48	GUID_PS	BBP_PDPSET	GUID		☐	BBP_GUID	☐	Globally Unique identifier
49	GUID_I2	CRMD_ORDERADM_I	GUID		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
50	CLIENT4	CRMD_ORDERADM_H	CLIENT		☐	MANDT	☐	Client
51	GUID_ORD_H	CRMD_ORDERADM_H	GUID		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
52	OBJECT_ID	CRMD_ORDERADM_H	OBJECT_ID		☐	CRMT_OBJECT_ID_DB	☐	Transaction 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	20141013
SAP Release Created in	701