SAP ABAP View BBP_PDVIEW_IAP (Item Data: General Purchasing and Purchasing Set)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ SRM-EBP (Application Component) Enterprise Buyer
     ⤷ BBP_PRODOC (Package) B2B Procurement Document

Basic Data

View Type	D	Database View
Database View	BBP_PDVIEW_IAP
Short Description	Item Data: General Purchasing and Purchasing Set
Root table	BBP_PDIGP	Business transaction item-Purchasing information

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	BBP_PDIGP	BBP_PDIGP
2	CRMD_ORDERADM_I

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	BBP_PDIGP	CLIENT	JL	EQ				0	0
2	CRMD_ORDERADM_I	CLIENT	JR	EQ			AND	0	0
3	BBP_PDIGP	GUID	JL	EQ				0	0
4	CRMD_ORDERADM_I	GUID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	BBP_PDIGP	*		☐		☐
2	CLIENT	BBP_PDIGP	CLIENT		☐	EC_CLIENT	☐	Client
3	GUID	BBP_PDIGP	GUID		☐	BBP_GUID	☐	Globally Unique identifier
4	CATEGORY	BBP_PDIGP	CATEGORY		☐	BBP_CATEGORY_GUID_RAW	☐	Product Category GUID
5	CATEGORY_ID	BBP_PDIGP	CATEGORY_ID		☐	BBP_CATEGORY_ID	☐	Product Category ID
6	SCHEMA_TYPE	BBP_PDIGP	SCHEMA_TYPE		☐	SCHEMA_TYPE	☐	Standard Schema Type
7	CT_CATEGORY_ID	BBP_PDIGP	CT_CATEGORY_ID		☐	BBP_CT_CATEGORY_ID	☐	Category Name
8	ITM_EX_CT_UN_ID	BBP_PDIGP	ITM_EX_CT_UN_ID		☐	BBP_ITM_EX_CT_UN_ID	☐	Unique Key in External Category
9	MANU_PROD	BBP_PDIGP	MANU_PROD		☐	BBP_MFRPN	☐	Manufacturer Part Number
10	MFR_NO_EXT	BBP_PDIGP	MFR_NO_EXT		☐	EMNFR	☐	External manufacturer code name or number
11	CATALOGID	BBP_PDIGP	CATALOGID		☐	BBP_WS_SERVICE_ID	☐	Technical Key of a Web Service (for Example - a Catalog)
12	CATALOGITEM	BBP_PDIGP	CATALOGITEM		☐	BBP_CATALOGITEM	☐	Catalog Item (Unique Key)
13	EXT_QUOTE_ID	BBP_PDIGP	EXT_QUOTE_ID		☐	BBP_EXT_QUOTE_ID	☐	Number of External Bid
14	EXT_QUOTE_ITEM	BBP_PDIGP	EXT_QUOTE_ITEM		☐	BBP_EXT_QUOTE_ITEM	☐	Item for an External Bid
15	PRODUCT_TYPE	BBP_PDIGP	PRODUCT_TYPE		☐	BBP_PRODUCT_TYPE	☐	Product Type
16	DEL_DATCAT	BBP_PDIGP	DEL_DATCAT		☐	LPEIN_INT	☐	Date type (day, week, month, interval)
17	DELIV_DATE	BBP_PDIGP	DELIV_DATE		☐	EINDT	☐	Item delivery date
18	DELIV_TIME	BBP_PDIGP	DELIV_TIME		☐	BBP_DELIV_TIME	☐	Delivery Time of the Item
19	LEADTIME	BBP_PDIGP	LEADTIME		☐	BBP_LEADTIME	☐	Delivery Time in Days
20	VPER_START	BBP_PDIGP	VPER_START		☐	BBP_VPER_START	☐	Validity Period From
21	VPER_END	BBP_PDIGP	VPER_END		☐	BBP_VPER_END	☐	Validity period
22	QUANTITY	BBP_PDIGP	QUANTITY		☐	BBP_MNG	☐	Quantity in Order Unit
23	UNIT	BBP_PDIGP	UNIT		☐	BBP_UNIT	☐	Purchase Order Unit
24	GROSS_PRICE	BBP_PDIGP	GROSS_PRICE		☐	BBP_GROSS_PRICE	☐	Gross Price
25	PRICE	BBP_PDIGP	PRICE		☐	BBP_PRICE	☐	Net Price
26	PRICE_UNIT	BBP_PDIGP	PRICE_UNIT		☐	EPEIN	☐	Price unit
27	PRICE_ORIGIN	BBP_PDIGP	PRICE_ORIGIN		☐	BBP_PRICE_ORIGIN	☐	Original Price (Determination/Manual Input)
28	VALUE	BBP_PDIGP	VALUE		☐	BBP_VALUE	☐	Net Value
29	CURRENCY	BBP_PDIGP	CURRENCY		☐	WAERS	☐	Currency Key
30	TAX_CODE	BBP_PDIGP	TAX_CODE		☐	BBP_MWSKZ	☐	Tax Code
31	BBP_MOVE_TYPE	BBP_PDIGP	BBP_MOVE_TYPE		☐	BBP_MOVE_TYPE	☐	Movement Code for Enterprise Buyer Professional Edition
32	SRC_OBJECT_TYPE	BBP_PDIGP	SRC_OBJECT_TYPE		☐	BBP_SRC_I_OBJ_TYP	☐	Object Type of Reference Item
33	SRC_ITM_ID	BBP_PDIGP	SRC_ITM_ID		☐	BBP_SRC_ITM_ID	☐	Unique ID of a Template Item
34	SRC_LOG_SYS	BBP_PDIGP	SRC_LOG_SYS		☐	BBP_SRC_LOG_SYS	☐	Logical System of Template Document (Vacant if in Loc. Sys.)
35	SRC_GUID	BBP_PDIGP	SRC_GUID		☐	BBP_SRC_I_GUID	☐	Reference Item GUID
36	CTR_LOG_SYS	BBP_PDIGP	CTR_LOG_SYS		☐	BBP_CTR_LOG_SYSTEM	☐	Logical System from Which the Contract Originates
37	CTR_GUID	BBP_PDIGP	CTR_GUID		☐	BBP_CTR_I_GUID	☐	Contract Template Item GUID
38	CTR_ITEM_NUMBER	BBP_PDIGP	CTR_ITEM_NUMBER		☐	BBP_CTR_ITEM	☐	Number of Contract Item
39	CTR_HDR_NUMBER	BBP_PDIGP	CTR_HDR_NUMBER		☐	BBP_CTR_ID	☐	Contract Number
40	CTR_HDR_GUID	BBP_PDIGP	CTR_HDR_GUID		☐	BBP_CTR_H_GUID	☐	GUID Contract
41	COMM_ID	BBP_PDIGP	COMM_ID		☐	BBP_COMM_ID	☐	Clear Item ID for Commitments Interface
42	DEL_IND	BBP_PDIGP	DEL_IND		☐	BBP_DEL_IND	☐	Deletion Indicator EBP Purchasing Document
43	FINAL_INV	BBP_PDIGP	FINAL_INV		☐	EREKZ	☐	Final Invoice Indicator
44	FINAL_ENTRY	BBP_PDIGP	FINAL_ENTRY		☐	BBP_FINAL_ENTRY	☐	Final Entry Indicator (Goods/Services)
45	DEDUCT_IND	BBP_PDIGP	DEDUCT_IND		☐	BBP_DEDUCT_IND	☐	Discount/Rejection Indicator at Item Level
46	REJECT_WI	BBP_PDIGP	REJECT_WI		☐	SWW_WIID	☐	Work item ID
47	VAL_CF_E	BBP_PDIGP	VAL_CF_E		☐	BBP_CF_VALUE_E	☐	Value of Entered Confirmations
48	VAL_CF	BBP_PDIGP	VAL_CF		☐	BBP_CF_VALUE	☐	Value of Confirmations Released
49	VAL_IV_E	BBP_PDIGP	VAL_IV_E		☐	BBP_IV_VALUE_E	☐	Entered Invoice Value
50	VAL_IV	BBP_PDIGP	VAL_IV		☐	BBP_IV_VALUE	☐	Released Invoice Value
51	VAL_PO_E	BBP_PDIGP	VAL_PO_E		☐	BBP_PO_VALUE_E	☐	Value of POs/Confirmations/Invoices Created for Contract
52	QUAN_CF_E	BBP_PDIGP	QUAN_CF_E		☐	BBP_CF_QUANT_E	☐	Quantity of Entered Confirmation
53	QUAN_CF	BBP_PDIGP	QUAN_CF		☐	BBP_CF_QUANT	☐	Quantity of Released Confirmations
54	QUAN_IV_E	BBP_PDIGP	QUAN_IV_E		☐	BBP_IV_QUANT_E	☐	Entered Invoiced Quantity
55	QUAN_IV	BBP_PDIGP	QUAN_IV		☐	BBP_IV_QUANT	☐	Released Invoiced Quantity
56	QUAN_PO_E	BBP_PDIGP	QUAN_PO_E		☐	BBP_PO_QUANT_E	☐	Quantity of POs/Confirmations/Invoices Created for Contract
57	NUM_CONF	BBP_PDIGP	NUM_CONF		☐	BBP_NUM_CONF	☐	Number of Entered Confirmations for a Purchase Order
58	NUM_INV	BBP_PDIGP	NUM_INV		☐	BBP_NUM_INV	☐	Number of Entered Invoices for Purchase Order or Confirmat.
59	DCIND	BBP_PDIGP	DCIND		☐	BBP_DCIND	☐	Debit/credit Indicator
60	SUBTYPE	BBP_PDIGP	SUBTYPE		☐	BBP_I_SUBTYPE	☐	Specification Purchase Item (e.g. Direct Material/Hierarch.)
61	SOURCE_REL_IND	BBP_PDIGP	SOURCE_REL_IND		☐	BBP_SOURCE_REL_IND	☐	Indicator - If the Document is Sourcing-Relevant
62	EXT_DEMID	BBP_PDIGP	EXT_DEMID		☐	BBP_EXT_DEMID	☐	External Requirement Tracking Number
63	EXT_DEM_POSID	BBP_PDIGP	EXT_DEM_POSID		☐	BBP_EXT_DEM_POSID	☐	External Requirement Tracking Number
64	EXT_DEM_LOGSYS	BBP_PDIGP	EXT_DEM_LOGSYS		☐	BBP_EXT_DEM_LOGSYS	☐	Logical System from where an External Requirement Comes
65	PCINS	BBP_PDIGP	PCINS		☐	BBPPCINS	☐	Procurement card company
66	PCNUM	BBP_PDIGP	PCNUM		☐	BBPPCNUM	☐	Procurement card number
67	PCNAME	BBP_PDIGP	PCNAME		☐	BBPPCNAME	☐	Name of procurement cardholder
68	PCDAT_TO	BBP_PDIGP	PCDAT_TO		☐	BBPPCDAT_TO	☐	Procurement Card Validity Date
69	LOGSYS_FI	BBP_PDIGP	LOGSYS_FI		☐	BBP_LOGSYS_FI	☐	Logical System of FI System
70	ITM_RELEASED	BBP_PDIGP	ITM_RELEASED		☐	BBP_ITM_RELEASED	☐	Indicator - Item is to be Released
71	ACTIVE_ITEM	BBP_PDIGP	ACTIVE_ITEM		☐	BBP_GUID	☐	Globally Unique identifier
72	TIME_FROM	BBP_PDIGP	TIME_FROM		☐	BBP_TIME_FROM	☐	Start Time
73	TIME_TO	BBP_PDIGP	TIME_TO		☐	BBP_TIME_TO	☐	Finish Time
74	ORIGIN_ORDER_ID	BBP_PDIGP	ORIGIN_ORDER_ID		☐	BBP_ORIGIN_ORDER_ID	☐	Origninal Customer's PO No. for Third Party Transaction
75	ORIGIN_ITEM_ID	BBP_PDIGP	ORIGIN_ITEM_ID		☐	BBP_ORIGIN_ORDER_ITEM_ID	☐	Orignl Customer Purchase Order Item No. - Third Party Trans.
76	NUM_SOS	BBP_PDIGP	NUM_SOS		☐	BBP_NUM_SOS	☐	Number of Sources of Supply Found (for Performance)
77	GROUPING_LEVEL	BBP_PDIGP	GROUPING_LEVEL		☐	BBP_GROUPING_LEVEL	☐	Specifies How Hierarchy Positions are to be Managed
78	DELIV_DAYS	BBP_PDIGP	DELIV_DAYS		☐	BBP_DELIV_DAYS	☐	Delivery Time in Days
79	INCOTERM_KEY	BBP_PDIGP	INCOTERM_KEY		☐	BBP_INCOTERM_KEY	☐	Incoterm Key
80	INCOTERM_LOC	BBP_PDIGP	INCOTERM_LOC		☐	BBP_INCOTERM_LOCATION	☐	Incoterm Location
81	TAX_CODE_ORIGIN	BBP_PDIGP	TAX_CODE_ORIGIN		☐	BBP_TAX_CODE_ORIGIN	☐	Origin Tax Code Indicator (Determination/Manual Entry)
82	MIN_ORDER_VALUE	BBP_PDIGP	MIN_ORDER_VALUE		☐	BBP_VALUE	☐	Net Value
83	MIN_ORDER_QUAN	BBP_PDIGP	MIN_ORDER_QUAN		☐	BBP_MNG	☐	Quantity in Order Unit
84	EXT_DEM_SUBPOSID	BBP_PDIGP	EXT_DEM_SUBPOSID		☐	BBP_EXT_DEM_SUBPOSID	☐	External Requirement Subitem Number
85	*	CRMD_ORDERADM_I	*		☐		☐
86	-	CRMD_ORDERADM_I	CLIENT		☐	MANDT	☐	Client
87	-	CRMD_ORDERADM_I	GUID		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
88	CREATED_AT	CRMD_ORDERADM_I	CREATED_AT		☐	COMT_CREATED_AT_USR	☐	Created At (Output in User Time Zone)
89	CREATED_BY	CRMD_ORDERADM_I	CREATED_BY		☐	CRMT_CREATED_BY	☐	User that Created the Transaction
90	CHANGED_AT	CRMD_ORDERADM_I	CHANGED_AT		☐	COMT_CHANGED_AT_USR	☐	Changed At (Output in User Time Zone)
91	CHANGED_BY	CRMD_ORDERADM_I	CHANGED_BY		☐	CRMT_CHANGED_BY	☐	Transaction Last Changed By
92	OBJECT_TYPE	CRMD_ORDERADM_I	OBJECT_TYPE		☐	CRMT_SWO_OBJTYP_PROCESS_ITM_DB	☐	CRM Item Object Type
93	DESCRIPTION_UC	CRMD_ORDERADM_I	DESCRIPTION_UC		☐	CRMT_PRSHTEXTG_DB	☐	Product Short Text in Upper Case for F4 Help
94	HEADER	CRMD_ORDERADM_I	HEADER		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
95	PARENT	CRMD_ORDERADM_I	PARENT		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
96	ALTERNATIVE	CRMD_ORDERADM_I	ALTERNATIVE		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
97	PRODUCT	CRMD_ORDERADM_I	PRODUCT		☐	CRMT_PRODUCT_GUID_DB	☐	Internal Unique ID of Product
98	PRODUCT_SRC_SYS	CRMD_ORDERADM_I	PRODUCT_SRC_SYS		☐	CRMT_PRODUCT_SRC_SYS	☐	Logical System from Which Product Originates
99	ORDERED_PROD	CRMD_ORDERADM_I	ORDERED_PROD		☐	CRMT_ORDERED_PROD_DB	☐	Product Name Entered
100	PARTNER_PROD	CRMD_ORDERADM_I	PARTNER_PROD		☐	CRMT_ITEM_DESCR_PARTNER	☐	Product Number of Business Partner
101	DESCRIPTION	CRMD_ORDERADM_I	DESCRIPTION		☐	CRMT_PRSHTEXTX_DB	☐	Product Short Text
102	ITM_LANGUAGE	CRMD_ORDERADM_I	ITM_LANGUAGE		☐	CRMT_ITEM_LANGU	☐	Short Text Language for an Item
103	NUMBER_INT	CRMD_ORDERADM_I	NUMBER_INT		☐	CRMT_ITEM_NO	☐	Item Number in Document
104	NUMBER_EXT	CRMD_ORDERADM_I	NUMBER_EXT		☐	CRMT_ITEM_NO_EXT	☐	External Item Number
105	ITM_TYPE	CRMD_ORDERADM_I	ITM_TYPE		☐	CRMT_ITEM_TYPE_DB	☐	Item Category
106	ORDER_DATE	CRMD_ORDERADM_I	ORDER_DATE		☐	CRMT_ORDER_DATE	☐	Posting Date
107	SUBST_REASON	CRMD_ORDERADM_I	SUBST_REASON		☐	CRMT_ITEM_SUBSTITUTION	☐	Reason for Product Substitution
108	ITM_USAGE	CRMD_ORDERADM_I	ITM_USAGE		☐	CRMT_ITEM_USAGE	☐	Usage of Higher-Level Item
109	ITM_TYPE_USAGE	CRMD_ORDERADM_I	ITM_TYPE_USAGE		☐	CRMT_IT_TYPE_USAGE	☐	Item Category Usage
110	PRODUCT_KIND	CRMD_ORDERADM_I	PRODUCT_KIND		☐	CRMT_PRODUCT_KIND	☐	Technnical Type of Product
111	LOG_SYSTEM_EXT	CRMD_ORDERADM_I	LOG_SYSTEM_EXT		☐	CRMT_LOGSYS	☐	Logical System
112	ORDERADM_I_DUMMY	CRMD_ORDERADM_I	ORDERADM_I_DUMMY		☐	DUMMY	☐	Dummy function in length 1
113	ALTID_TYPE	CRMD_ORDERADM_I	ALTID_TYPE		☐	COMT_ALTID_TYPE	☐	ID Type for Alternative IDs
114	PARENT_IN_COMP_TX	CRMD_ORDERADM_I	PARENT_IN_COMP_TX		☐	CRMT_COMP_TX_PARENT_GUID	☐	Higher-Level Item Number in Composite Transaction
115	NUMBER_INT_COMP_TX	CRMD_ORDERADM_I	NUMBER_INT_COMP_TX		☐	CRMT_COMP_TX_ITEM_NO	☐	Composite Transaction-Specific Item Number

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