SAP Purchase Requisitions Tables
Are you looking for the right table related to SAP Purchase Requisitions Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Purchase Requisitions (MM-PUR-REQ) module.
Top 10 tables in Purchase Requisitions
| Table | Description |
|---|---|
| USER_REQ_GROUPS | Requisitioning Groups |
| IWI_PRHDRITMDT_D | I_PURCHASEREQNWORKITEMTP I_WRKITMPURREQNHDRITEMDETAILTP |
| CFB_C_RMC_BSART | Document Types in Raw Material Procurement Cockpit |
| MMPUR_ADV_FTRS | Advance features customizing |
| IWI_PRHDRDET_D | I_PURCHASEREQNWORKITEMTP I_WORKITEMPURREQNHDRDETAILTP |
| MMPUR_CAT_CT_MSG | Temporary table for error logging in Catalog extraction |
| IWIPURREQNITXT_D | I_PURCHASEREQNWORKITEMTP I_WRKITMPURREQUISITIONTEXTTP |
| MMPUR_CAT_EXLGPP | Catalog Extractor Logs for Parallel Processing |
| DRAFT_PR_ITM_TXT | SSP Requisition Item text types |
| MMPUR_CAT_LNGTXT | Text table for Long text |
List of tables in Purchase Requisitions
| Table | Description |
|---|---|
| USER_REQ_GROUPS | Requisitioning Groups |
| IWI_PRHDRITMDT_D | I_PURCHASEREQNWORKITEMTP I_WRKITMPURREQNHDRITEMDETAILTP |
| CFB_C_RMC_BSART | Document Types in Raw Material Procurement Cockpit |
| MMPUR_ADV_FTRS | Advance features customizing |
| IWI_PRHDRDET_D | I_PURCHASEREQNWORKITEMTP I_WORKITEMPURREQNHDRDETAILTP |
| MMPUR_CAT_CT_MSG | Temporary table for error logging in Catalog extraction |
| IWIPURREQNITXT_D | I_PURCHASEREQNWORKITEMTP I_WRKITMPURREQUISITIONTEXTTP |
| MMPUR_CAT_EXLGPP | Catalog Extractor Logs for Parallel Processing |
| DRAFT_PR_ITM_TXT | SSP Requisition Item text types |
| MMPUR_CAT_LNGTXT | Text table for Long text |
| MMPUR_CAT_ATTCHM | Images and Attachments |
| MMPUR_CAT_DSCTXT | Text table for description text |
| MMPUR_CAT_CRCUST | Settings for Cross-Catalog Search |
| MMPUR_CAT_CNTNT | SDOK: Table for document contents (import/export) |
| PURREQNACCT_D | T_PURCHASEREQN T_PURCHASEREQNACCTASSGMT |
| IWI_PRHDRITM_D | I_WORKITEMPURREQNHDRITEMTP I_WORKITEMPURREQNHDRITEMTP |
| PREQ_OPN_CNF | I_PURREQNITMSOPENFORCONF I_PURREQNITMSOPENFORCONF |
| PORD_OPN_CNFM | I_PURREQNITMSOPENFORCONFTP I_PURORDSOPENFORCONFTP |
| MMPUR_CAT_RELTYP | Relationship types text table |
| MMPUR_POLLING | Catalog Poll Details |
| USERDEF_HDR_D | I_USERDEFAULTSETTINGWD I_USERDEFAULTSETTINGWD |
| MMPUR_ML_EXPORT | Purchasing document export job status |
| MMPUR_WFL_RSTRT | Manage Conditions to Restart Flexible Workflow |
| PRACCTWI_D | I_PURCHASEREQNWORKITEMTP I_PURREQNACCTASSGMTWRKITMTP |
| OCIITM_PROPS | Internal catalog proposals for free text |
| IPURREQDELADD_D | I_PURCHASEREQNDELIVERYADDRTP I_PURCHASEREQNDELIVERYADDRTP |
| PURREQNITM_D | T_PURCHASEREQN T_PURCHASEREQNITEM |
| PROCCATCALLSTR_D | Generated draft table for core CDS view: I_Proccatalogcallst |
| OFI_CNFG_EF_T | Text table for Entity Field Table(OFI_CNFG_EF) |
| MMPUR_CAT_ATMAIN | Attachment main |
| USER_CATALOGS | Catalog value(s) for a user |
| USERDEF_CAT_D | I_USERDEFAULTSETTINGWD I_USERCATALOGSWITHDRAFT |
| PROCCAT_CALDET_D | I_CATALOGCALLDETAILSTP I_CATALOGCALLDETAILSTP |
| MMPUR_REQ_C_DEF | Purchase Requisition Configuration |
| MMPUR_CAT_ATTHMB | Attachment table for Thumb Image |
| PRHIACCTWI_D | I_PURCHASEREQNWORKITEMTP I_PURREQNHDRITMACASWRKITMTP |
| OCIITM_PROP_SUPP | Supplier recommendations for internal catalog proposals |
| MMPUR_CT_ITM_SRH | Item search |
| OFI_CNFG_EF | Office integration Configurations of Entity Fields |
| OCIITM_PROP_RLPO | Internal catalog proposal related purchase orders |
| USER_DEF_SETTING | Personnel and default setting based on type |
| MMPUR_BE_EOP_LOG | Latest time stamp of PR EOP sync with back end |
| EBAN_SSP_HDR_D | Requisition header Draft for SSP, Draft Version 2 |
| MMPUR_C_ML_IA | Machine Learning: Intelligent Approval Scenarios |
| SSPREQ_HDR_D | I_PURCHASEREQUISITION_WD I_PURCHASEREQUISITION_WD |
| MMPUR_SSP_RSRV_C | Customizing table for material group for reservation |
| PROCCATCALLDET_D | Generated draft table for core CDS view: I_Proccatalogcallde |
| MIG_SC_CUST_FLDS | Table for holding customer fields during SC migration |
| MMPUR_CAT_VR | Relation Table for View Id and Product key for catalog item |
| MMPUR_CAT_PRDREL | Product Relationship |
| MMPUR_CAT_PRCONV | Price Conversion Table |
| OCIITM_PROPST | Internal catalog proposal descriptionsMANDT MANDT |
| MMPUR_FIELD_MAP | To convert GFN names to Internal names and vice-versa |
| MMPUR_REQ_GROUPS | Requisitioning groups for purchasing |
| MMPUR_IMG_ML_MTR | ML Search Metering - Image based buying |
| MMPUR_ML_IA_JOB | ML: Intelliigent Approval Job Status |
| SSPREQ_ITM_D | I_PURCHASEREQUISITION_WD I_PURCHASEREQUISITIONITEM_WD |
| MMPUR_CAT_RTGRVW | Rating and review table |
| DRAFT_PR_ITEM | SSP Requisition Item |
| MMPUR_CAT_EXTRLG | Catalog Extractor Logs |
| MMPUR_CAT_VD | Table to contain the Catalog Views |
| PURREQNITMTXT_D | T_PURCHASEREQN T_PURCHASEREQNITEMTEXT |
| OFI_CONFIG_EF | Office integration Configurations of Entity Fields |
| USERDEF_ITM_D | I_USERDEFAULTSETTINGWD I_USERDEFAULTSETTINGITEMWD |
| MMPURUPLDFILETMP | Error Messages for Excel based Data Exchange |
| USERCATALOGS_D | Generated draft table for core CDS view: I_Usercatalogs |
| MMPUR_OCI_LNCH | Secure OCI Parameters |
| MMPUR_CAT_FILTER | Database tabel for transient filter |
| MMPUR_CTLG_ATTR | Dynamic Catalog Attribute table |
| MMPUR_PR_D_POIT | Item Node for Purchase Order Draft |
| SSPREQ_ITM_TXT_D | Requisition Draft for Texts SSP , Draft Version 2 |
| MMPUR_CAT_MY_FAV | Personal Markers |
| MMPUR_ML_INFER | Inference table for ML |
| MIG_SC_S4H_HIST | SRM Shopping Carts migration to S/4 HANA History |
| PURREQNDELIVAD_D | T_PURCHASEREQN T_PURCHASEREQNDELIVERYADD |
| IWI_PRITMDET_D | I_PURCHASEREQNWORKITEMTP I_WORKITEMPURREQNITEMDETAILTP |
| CFB_C_RMC_PERIOD | Period Under Review for Raw Material Procurement Cockpit |
| USERDEFSETTING_D | Generated draft table for core CDS view: I_UserDefaultSettin |
| MMPUR_SRH_CUST | Search Customizing |
| OFI_CNFG_ET_T | Text table for Entity table(OFI_CNFG_ET_T) |
| DRAFT_PR_ACC | SSP requisition Accounting |
| USERSETTINGITE_D | Generated draft table for core CDS view: I_UserDefaultSettin |
| OFI_CNFG_H | Office integration config header |
| OFI_CNFG_H_T | Text Table for Header Table OFI_CNFG_H |
| DRAFT_PR_HEADER | SSP requisition Draft |
| MMPUR_PR_D_POHD | Header Draft Database Table for Purchase Order |
| MMPUR_CAT_PRCSCL | Price scale for catalog items |
| PORD_OPN_CNF | I_PURREQNITMSOPENFORCONF I_PURORDSOPENFORCONF |
| MMPUR_ML_IA_HIST | Machine Learning: Intelligent Approval History |
| IWIPURREQNHTXT_D | I_PURCHASEREQNWORKITEMTP I_WRKITMPURREQNHDRITEMTEXTTP |
| MMPUR_CAT_ATTRB | Dynamic Catalog Attribute table |
| MMPUR_REQ_D_ROOT | Header Node - #GENERATED# |
| OFI_CONFIG_H | Office integration config header |
| PROCCAT_CALSTR_D | I_CATALOGCALLDETAILSTP I_CATALOGCALLSTRUCTURETP |
| MMPUR_PR_FOR_CNF | Purchase Requisition Open for confirmation |
| STXH_SSP_ITMTX_D | Requisition Draft for Texts SSP , Draft Version 2 |
| USER_PERS_DATA | Advanced user setting details |
| MMPUR_CAT_MGPTXT | Text table for material group |
| EBAN_SSP_ITM_D | Requisition Item Draft for SSP , Draft Version 2 |
| MMPUR_CAT_ITM | Catalog items stored for search |
| USERDEF_GRP_D | I_USERDEFAULTSETTINGWD I_USERREQUISITIONINGGROUPSWD |
| MMPUR_C_ML_CONF | Machine Learning Scenario Configuration |
| IPURREQ_WI_D | I_PURCHASEREQNWORKITEMTP I_PURCHASEREQNWORKITEMTP |
| MMPUR_CAT_ITMATR | Attributes for the Catalog Item |
| SSPREQ_ITM_ACC_D | I_PURCHASEREQUISITION_WD I_PURREQNACCASSIGNMENT_WD Gen |
| OFI_CONFIG_ET | Office integration configuration entities |
| CFB_C_RMC_PERI_T | Raw Material Procurement Cockpit: Period Under Review Text |
| PREQ_OPN_CNFM | I_PURREQNITMSOPENFORCONFTP I_PURREQNITMSOPENFORCONFTP |
| MMPUR_CAT_ATHTXT | Text table for attachments |
| MIG_SC_STAT_HIST | Status of SC in SRM before migrating to S/4 HANA |
| MMPUR_CAT_ITMCUS | Customer fields for catalog item |
| EBKN_SSP_ACC_D | Requisition Account Draft for SSP, Draft Version 2 |
| OFI_UPLOAD_FILE | Table for upload file error logging |
| PURREQNHDR_D | T_PURCHASEREQN T_PURCHASEREQN |
| OFI_CNFG_ET | Office integration configuration entities |
| MMPUR_SRH_AUTH | Attribute search authorization |
| IWI_PRHDR_D | I_WORKITEMPURREQNHDRTP I_WORKITEMPURREQNHDRTP |