SAP ABAP Table BQPIM (Import Structure for Source of Supply Check and Search)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ SRM-EBP (Application Component) Enterprise Buyer
     ⤷ BBP_APPLICATION (Package) Structure Package EBP
       ⤷ ME (Package) Application development R/3 Purchasing

Basic Data

Table Category	INTTAB	Structure
Structure	BQPIM	Table Relationship Diagram
Short Description	Import Structure for Source of Supply Check and Search

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
2	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
3	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
4	OLDAT	☐	DATUM	DATUM	DATS	8	0	Date
5	NEDAT	☐	DATUM	DATUM	DATS	8	0	Date
6	BESKZ	☐	BESKZ	BESKZ	CHAR	1	0	Procurement Type
7	SOBES	☐	SOBES	SOBES	CHAR	1	0	Special procurement type
8	OLMNG	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
9	NEMNG	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
10	OLBSM	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
11	NEBSM	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
12	BSART	☐	BSART	BSART	CHAR	4	0	Order Type (Purchasing)	T161
13	BSTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
14	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	T163
15	BSAKZ	☐	BSAKZ	BSAKZ	CHAR	1	0	Control indicator for purchasing document type
16	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
17	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
18	USEQU	☐	USEQU	USEQU	CHAR	1	0	Quota arrangement usage	TMQ2
19	VORGA	☐	VORGA	VORGA	CHAR	2	0	Transaction/event
20	QUNUM	☐	QUNUM	QUNUM	CHAR	10	0	Number of quota arrangement
21	QUPOS	☐	QUPOS	NUM03	NUMC	3	0	Quota arrangement item
22	UMREZ	☐	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
23	UMREN	☐	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
24	MEINS	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
25	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
26	FLIEF	☐	FLIEF	LIFNR	CHAR	10	0	Fixed vendor	LFA1
27	OFLIE	☐	FLIEF	LIFNR	CHAR	10	0	Fixed vendor	LFA1
28	BEWRK	☐	BEWRK	WERKS	CHAR	4	0	Plant from Which Material is Procured	T001W
29	OBEWR	☐	BEWRK	WERKS	CHAR	4	0	Plant from Which Material is Procured	T001W
30	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	EINA
31	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
32	OEKOR	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
33	KONNR	☐	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	EKKO
34	OKONN	☐	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	EKKO
35	KTPNR	☐	KTPNR	EBELP	NUMC	5	0	Item number of principal purchase agreement	EKPO
36	OKTPN	☐	KTPNR	EBELP	NUMC	5	0	Item number of principal purchase agreement	EKPO
37	LISTE	☐	XFELD	XFELD	CHAR	1	0	Checkbox
38	MATNL	☐	MATNL	XFELD	CHAR	1	0	Do not read material
39	MSGNO	☐	XFELD	XFELD	CHAR	1	0	Checkbox
40	PRAKT	☐	PRAKT	XFELD	CHAR	1	0	Display current price
41	NOAUS	☐	NOAUS	XFELD	CHAR	1	0	No box listing sources of supply
42	LMEIN	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
43	FRGDT	☐	FRGDT	DATUM	DATS	8	0	Purchase Requisition Release Date
44	EBZKA	☐	EBZKA	XFELD	CHAR	1	0	Source: Contract
45	EBZKM	☐	EBZKM	XFELD	CHAR	1	0	Source: Contract, Item Category M
46	EBZKW	☐	EBZKW	XFELD	CHAR	1	0	Source: Contract, Item Category W
47	EBZIN	☐	EBZIN	XFELD	CHAR	1	0	Source: Info Record
48	EBZOM	☐	EBZOM	XFELD	CHAR	1	0	Source for Items Without Material
49	RESE1	☐	XFELD	XFELD	CHAR	1	0	Checkbox
50	RESE2	☐	XFELD	XFELD	CHAR	1	0	Checkbox
51	RESE3	☐	XFELD	XFELD	CHAR	1	0	Checkbox
52	BQPRA	☐	BQPRA	BQPRA	CHAR	1	0	Selection of source of supply according to price
53	BZQSO	☐	BZQSO	BZQSO	CHAR	1	0	Determine item category from special procurement key
54	BZQHL	☐	BZQHL	XFELD	CHAR	1	0	Take regular vendor into account
55	NOQUL	☐	NOQUL	XFELD	CHAR	1	0	Do not evaluate quota arrangement
56	NOQUU	☐	NOQUU	XFELD	CHAR	1	0	Do not update quota arrangement
57	NOORL	☐	NOORL	XFELD	CHAR	1	0	Do not evaluate source list
58	NONWR	☐	NONWR	XFELD	CHAR	1	0	Supplying plant may not be changed
59	NOVRT	☐	NOVRT	XFELD	CHAR	1	0	Do not search for outline agreements
60	NOMVR	☐	NOMVR	XFELD	CHAR	1	0	Do not search for material-related outline agreements
61	NOWVR	☐	NOWVR	XFELD	CHAR	1	0	Do not search for material-group-related outline agreements
62	NOMEI	☐	NOMEI	XFELD	CHAR	1	0	Always use order unit from info record
63	NOQUM	☐	NOQUMNG	XFELD	CHAR	1	0	Do not take quota-allocated quantities into account
64	PACKNO	☐	PACKNO	PACKNO	NUMC	10	0	Package number	*
65	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	*
66	BWSCL	☐	BQSCL	BQSCL	CHAR	1	0	Source of supply key	*
67	BZQBW	☐	BZQBW	BZQSO	CHAR	1	0	Determine item category from source of supply key
68	TXZ01	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
69	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
70	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	*
71	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
72	FCALL	☐	XFELD	XFELD	CHAR	1	0	Checkbox
73	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
74	UMSOK	☐	UMSOK	SOBKZ	CHAR	1	0	Special stock indicator for physical stock transfer	*
75	KZFME	☐	KZWSO	KZWSO	CHAR	1	0	Units of measure usage
76	EMATN	☐	EMATNR	MATNR	CHAR	18	0	Material number	*
77	MPROF	☐	MPROF	MPROF	CHAR	4	0	Mfr part profile	*
78	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
79	MFRNR	☐	MFRNR	LIFNR	CHAR	10	0	Manufacturer number	LFA1
80	MFRPN	☐	MFRPN	CHAR40	CHAR	40	0	Manufacturer Part Number
81	EMNFR	☐	EMNFR	CHAR10	CHAR	10	0	External manufacturer code name or number
82	BPUEB	☐	BPUEB	BPUEB	CHAR	1	0	Adopt requisition price in purchase order
83	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
84	BAPIC	☐	BAPIC	XFELD	CHAR	1	0	Indicator called up via BAPI
85	QUNUM_REQ	☐	QUNUM	QUNUM	CHAR	10	0	Number of quota arrangement
86	PLIFZ	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
87	LBLKZ	☐	LBLKZ	XFELD	CHAR	1	0	Subcontracting vendor
88	EMLIF	☐	EMLIF	LIFNR	CHAR	10	0	Vendor to be supplied/who is to receive delivery	*
89	ADRNR	☐	ADRNR_MM	AD_ADDRNUM	CHAR	10	0	Manual address number in purchasing document item	*
90	ADRN2	☐	ADRN2	AD_ADDRNUM	CHAR	10	0	Number of delivery address	*
91	KUNNR	☐	EKUNNR	KUNNR	CHAR	10	0	Customer	*
92	CDELT	☐	CDELT	XFELD	CHAR	1	0	Check Delivery Date in Source Determination
93	CALCPR	☐	CALCPR		CHAR	1	0	Determine price
94	ESTKZ	☐	ESTKZ	ESTKZ	CHAR	1	0	Creation indicator (purchase requisition/schedule lines)
95	BESWK	☐	BESWK	WERKS	CHAR	4	0	Procuring Plant	*
96	NOVRT_ORD	☐	NOVRT	XFELD	CHAR	1	0	Do not search for outline agreements
97	RESLO	☐	RESLO	LGORT	CHAR	4	0	Issuing Storage Location for Stock Transport Order	*
98	ORESL	☐	RESLO	LGORT	CHAR	4	0	Issuing Storage Location for Stock Transport Order	*
99	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
100	RETPO_CHANGE	☐	XFELD	XFELD	CHAR	1	0	Checkbox
101	MHDRZ	☐	MHDRZ	DEC4	DEC	4	0	Minimum Remaining Shelf Life
102	IPRKZ	☐	DATTP	DATTP	CHAR	1	0	Period Indicator for Shelf Life Expiration Date
103	SRM_CONTRACT_ID	☐	SRM_CONTRACT_ID	BBP_BAPI_EBELN	CHAR	10	0	Central Contract
104	SRM_CONTRACT_ITM	☐	SRM_CONTRACT_ITEM	BBP_ITEMNO	NUMC	10	0	Central Contract Item Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BQPIM	BEWRK	T001W	WERKS
2	BQPIM	BSART	T161	BSART
3	BQPIM	EKORG	T024E	EKORG
4	BQPIM	FLIEF	LFA1	LIFNR
5	BQPIM	INFNR	EINA	INFNR
6	BQPIM	KNTTP	T163K	KNTTP
7	BQPIM	KONNR	EKKO	EBELN
8	BQPIM	KTPNR	EKPO	EBELP
9	BQPIM	LIFNR	LFA1	LIFNR
10	BQPIM	MATKL	T023	MATKL
11	BQPIM	MATNR	MARA	MATNR
12	BQPIM	MEINS	T006	MSEHI
13	BQPIM	MFRNR	LFA1	LIFNR
14	BQPIM	OBEWR	T001W	WERKS
15	BQPIM	OEKOR	T024E	EKORG
16	BQPIM	OFLIE	LFA1	LIFNR
17	BQPIM	OKONN	EKKO	EBELN
18	BQPIM	OKTPN	EKPO	EBELP
19	BQPIM	PSTYP	T163	PSTYP
20	BQPIM	USEQU	TMQ2	USEQU
21	BQPIM	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20110901
SAP Release Created in