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

Dictionary Type: Structure
Description: Import Structure for Source of Supply Check and Search




ABAP Code to SELECT data from BQPIM
Related tables to BQPIM
Access table BQPIM




Structure field list including key, data, relationships and ABAP select examples

BQPIM is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Import Structure for Source of Supply Check and Search" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_BQPIM TYPE BQPIM.

The BQPIM table consists of various fields, each holding specific information or linking keys about Import Structure for Source of Supply Check and Search data available in SAP. These include WERKS (Plant), MATKL (Material Group), OLDAT (Date), NEDAT (Date).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP BQPIM structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
MATKLMaterial Group MATKLCHAR9T023MATKLMKLS_WBWG
OLDATDate DATUMDATS8DATUM
NEDATDate DATUMDATS8DATUM
BESKZProcurement Type BESKZCHAR1BESKZMBS
SOBESSpecial procurement type SOBESCHAR1SOBES
OLMNGQuantity MENGE_DQUAN13(3) MENG13
NEMNGQuantity MENGE_DQUAN13(3) MENG13
OLBSMQuantity MENGE_DQUAN13(3) MENG13
NEBSMQuantity MENGE_DQUAN13(3) MENG13
BSARTOrder Type (Purchasing) BSARTCHAR4T161BSARTBSA
BSTYPPurchasing Document Category BSTYPCHAR1BSTYP
PSTYPItem Category in Purchasing Document PSTYPCHAR1T163PSTYP
BSAKZControl indicator for purchasing document type BSAKZCHAR1BSAKZ
KZVBRConsumption Posting KZVBRCHAR1KZVBR
KNTTPAccount Assignment Category KNTTPCHAR1T163KKNTTPKNT
USEQUQuota arrangement usage USEQUCHAR1TMQ2USEQU
VORGATransaction/event VORGACHAR2VORGA
QUNUMNumber of Quota Arrangement QUNUMCHAR10ALPHAQUNUM
QUPOSQuota Arrangement Item QUPOSNUMC3NUM03
UMREZNumerator for Conversion to Base Units of Measure UMREZDEC5UMBSZ
UMRENDenominator for conversion to base units of measure UMRENDEC5UMBSN
MEINSPurchase Order Unit of Measure BSTMEUNIT3T006CUNITMEINS
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10LFA1ALPHALIFNRLIFKRED_C
FLIEFFixed Vendor FLIEFCHAR10LFA1ALPHALIFNR
OFLIEFixed Vendor FLIEFCHAR10LFA1ALPHALIFNR
BEWRKPlant from Which Material is Procured BEWRKCHAR4T001WWERKS
OBEWRPlant from Which Material is Procured BEWRKCHAR4T001WWERKS
INFNRNumber of Purchasing Info Record INFNRCHAR10EINAALPHAINFNRINFMEIN_C
EKORGPurchasing Organization EKORGCHAR4T024EEKORGEKO
OEKORPurchasing Organization EKORGCHAR4T024EEKORGEKO
KONNRNumber of Principal Purchase Agreement KONNRCHAR10EKKOALPHAEBELNKTR
OKONNNumber of Principal Purchase Agreement KONNRCHAR10EKKOALPHAEBELNKTR
KTPNRItem Number of Principal Purchase Agreement KTPNRNUMC5EKPOEBELP
OKTPNItem Number of Principal Purchase Agreement KTPNRNUMC5EKPOEBELP
LISTECheckbox XFELDCHAR1XFELD
MATNLDo not read material MATNLCHAR1XFELD
MSGNOCheckbox XFELDCHAR1XFELD
PRAKTDisplay current price PRAKTCHAR1XFELD
NOAUSNo box listing sources of supply NOAUSCHAR1XFELD
LMEINBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
FRGDTPurchase Requisition Release Date FRGDTDATS8DATUM
EBZKASource: Contract EBZKACHAR1XFELD
EBZKMSource: Contract, Item Category M EBZKMCHAR1XFELD
EBZKWSource: Contract, Item Category W EBZKWCHAR1XFELD
EBZINSource: Info Record EBZINCHAR1XFELD
EBZOMSource for Items Without Material EBZOMCHAR1XFELD
RESE1Checkbox XFELDCHAR1XFELD
RESE2Checkbox XFELDCHAR1XFELD
RESE3Checkbox XFELDCHAR1XFELD
BQPRASelection of source of supply according to price BQPRACHAR1BQPRA
BZQSODetermine item category from special procurement key BZQSOCHAR1BZQSO
BZQHLTake regular vendor into account BZQHLCHAR1XFELD
NOQULDo not evaluate quota arrangement NOQULCHAR1XFELD
NOQUUDo not update quota arrangement NOQUUCHAR1XFELD
NOORLDo not evaluate source list NOORLCHAR1XFELD
NONWRSupplying plant may not be changed NONWRCHAR1XFELD
NOVRTDo not search for outline agreements NOVRTCHAR1XFELD
NOMVRDo not search for material-related outline agreements NOMVRCHAR1XFELD
NOWVRDo not search for material-group-related outline agreements NOWVRCHAR1XFELD
NOMEIAlways use order unit from info record NOMEICHAR1XFELD
NOQUMDo not take quota-allocated quantities into account NOQUMNGCHAR1XFELD
PACKNOPackage number PACKNONUMC10Assigned to domainPACKNO
VERIDProduction Version VERIDCHAR4Assigned to domainVERIDVER
BWSCLSource of supply key BQSCLCHAR1Assigned to domainBQSCL
BZQBWDetermine item category from source of supply key BZQBWCHAR1BZQSO
TXZ01Short Text TXZ01CHAR40TEXT40
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
SATNRCross-Plant Configurable Material SATNRCHAR18Assigned to domainMATN1MATNR
ATTYPMaterial Category ATTYPCHAR2ATTYPMTY
FCALLCheckbox XFELDCHAR1XFELD
SOBKZSpecial Stock Indicator SOBKZCHAR1Assigned to domainSOBKZ
UMSOKSpecial Stock Indicator for Physical Stock Transfer UMSOKCHAR1Assigned to domainSOBKZ
KZFMEUnits of measure usage KZWSOCHAR1KZWSO
EMATNMaterial Number EMATNRCHAR18Assigned to domainMATN1MATNRMAT
MPROFManufacturer Part Profile MPROFCHAR4Assigned to domainMPROF
REVLVRevision Level REVLVCHAR2NUMCVREVLVRVS
MFRNRNumber of a Manufacturer MFRNRCHAR10LFA1ALPHALIFNR
MFRPNManufacturer Part Number MFRPNCHAR40CHAR40
EMNFRExternal manufacturer code name or number EMNFRCHAR10CHAR10
BPUEBAdopt Requisition Price in Purchase Order BPUEBCHAR1BPUEB
CUOBJConfiguration (internal object number) CUOBJNUMC18CUOBJCUX
BAPICIndicator called up via BAPI BAPICCHAR1XFELD
QUNUM_REQNumber of Quota Arrangement QUNUMCHAR10ALPHAQUNUM
PLIFZPlanned Delivery Time in Days PLIFZDEC3DEC3
LBLKZSubcontracting vendor LBLKZCHAR1XFELD
EMLIFVendor to be supplied/who is to receive delivery EMLIFCHAR10Assigned to domainALPHALIFNR
ADRNRManual address number in purchasing document item ADRNR_MMCHAR10Assigned to domainALPHAAD_ADDRNUM
ADRN2Number of delivery address ADRN2CHAR10Assigned to domainALPHAAD_ADDRNUM
KUNNRCustomer EKUNNRCHAR10Assigned to domainALPHAKUNNRKUN
CDELTCheck Delivery Date in Source Determination CDELTCHAR1XFELD
CALCPRDetermine price CALCPRCHAR1
ESTKZCreation Indicator (Purchase Requisition/Schedule Lines) ESTKZCHAR1ESTKZ
BESWKProcuring Plant BESWKCHAR4Assigned to domainWERKSBESW
NOVRT_ORDDo not search for outline agreements NOVRTCHAR1XFELD
RESLOIssuing Storage Location for Stock Transport Order RESLOCHAR4Assigned to domainLGORT
ORESLIssuing Storage Location for Stock Transport Order RESLOCHAR4Assigned to domainLGORT
LGORTStorage Location LGORT_DCHAR4Assigned to domainLGORTLAG
RETPO_CHANGECheckbox XFELDCHAR1XFELD
MHDRZMinimum Remaining Shelf Life MHDRZDEC4DEC4
IPRKZPeriod Indicator for Shelf Life Expiration Date DATTPCHAR1PERKZDATTPH_PERDKZ
SRM_CONTRACT_IDCentral Contract SRM_CONTRACT_IDCHAR10ALPHABBP_BAPI_EBELNMMBSI_MEKK_CC
SRM_CONTRACT_ITMCentral Contract Item Number SRM_CONTRACT_ITEMNUMC10BBP_ITEMNO

Key field Non-key field



How do I retrieve data from SAP structure BQPIM using ABAP code?

As BQPIM is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on BQPIM as there is no data to select.

How to access SAP table BQPIM

Within an ECC or HANA version of SAP you can also view further information about BQPIM and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!