SAP Purchasing Tables

Are you looking for the right table related to SAP Purchasing 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 Purchasing (MM-PUR) module.

Top 10 tables in Purchasing

TableDescription
EKBEH_MARemoved PO History Records at Account Assignment Level
T161RREORG Control, Purchasing
T166PItem Texts in Purchasing Document Printouts
T161VNShipping-Rel. Data f. Stck Transfer f. PO Doc.Type f. St.Loc
MMPUR_IDX_PCNFINStandard index table PurchaseOrderERPConfirmation_In_V1
T161SRelease Indicator, Purchase Requisition
T024ZPurchasing Organizations
MMPUR_REC_RSCFINAIF REC RFQRequestSUITEConfirmation_In
EKBZHHistory per Purchasing Document: Delivery Costs
T162Field Selection, Purchasing Document

List of SAP tables for Purchasing

TableDescription
EKBEH_MARemoved PO History Records at Account Assignment Level
T161RREORG Control, Purchasing
T166PItem Texts in Purchasing Document Printouts
T161VNShipping-Rel. Data f. Stck Transfer f. PO Doc.Type f. St.Loc
MMPUR_IDX_PCNFINStandard index table PurchaseOrderERPConfirmation_In_V1
T161SRelease Indicator, Purchase Requisition
T024ZPurchasing Organizations
MMPUR_REC_RSCFINAIF REC RFQRequestSUITEConfirmation_In
EKBZHHistory per Purchasing Document: Delivery Costs
T162Field Selection, Purchasing Document
A161Info Record: Variants
MMPUR_UPG_CTRLTable for Upgrade Control in MMPUR
MMPUR_ENABLE_BCDocument Categories enabled for Blockchain
EINAPurchasing Info Record: General Data
T163MConfirmation Control Keys: Description
T16LGTexts for Routines for Data Retrieval in Requisition Lists
TMKKGroup for Calculation Schema (Supplier)
BLK_REASONBlocking Reason in Purchase Order
MMPUR_MGRP2PGRPMapping of Material Group to Purchasing Group
T163BPurchase Order History Categories
TEMPLATE_HEADERHeader Data: Template
T163KSAssignment of Tax Indicator to Account Assignment Category
TMSI3Copying Fields: Main to Sub-item
T163KAccount Assignment Categories in Purchasing Document
EBUBIndex for Stock Transport Requisitions for Material
T16F_CRITERIARelease Criteria
T162XDescription of Field Groups from T162/T162K
MMPUR_VERS_CRSNTVersioning: Reason Code Texts
AMPL_REJECTIONRejection of AMPL Row
MMPUR_IDX_RSCFINStandard index table RFQRequestSUITEConfirmation_In
MMPUR_VERS_CONDNVersioning: Condition Data
EKCPAPurchasing Contract Commitment Plan Account Assignment Data
T16FHDescriptions of Release Groups
MMPUR_ALLOW_BCDocument Categories allowed for Blockchain
TMKM1TTaxes: Materials (Purchasing)
PREXTEnhancement Fields for Purchase Requisition
T161ZAdditional Checks for Outline Agreements on Reorganization
MMPUR_VER_T161Purchasing Document Types for Versioning
TMQ1Number Ranges for Quota Arrangement
T16CTDCM Text for Reason for Change
MMPUREXPRTJOBOVWPurchasing document export job status
MMPUR_VERS_CFLDSVersioning Activation for specific relevant fields
T163XZombie T163X
T163PRelease Creation Profile
T161GRelease Prerequisite, Purchase Requisition
MMPUR_REC_PCREINAIF Default Keyfield Table PurchasingContractERPRequest_In_V
T168TScreen Titles
T162TDescription of Field Selection Reference Key
T160JText Table for Intrastat Reports
EKPVShipping Data For Stock Transfer of Purchasing Document Item
TMKW1Taxes: Plant (Purchasing)
EKETHScheduling Agreement Schedules: History Tables
MMPUR_REC_PREQINAIF REC PurchaseRequestERPRequestIn
EKBE_MAHistory of Purchasing Document at Account Assignment Level
TMMPURCFOLDERScFolders Maintenance
T161VShipping-Specific Data for Stock Tfr. for Purch. Doc. Type
T160RRoutines for Buyer's Negotiation Sheet
EKKIPurchasing Condition Index
TWLADDetermination of Address from Plant and Storage Location
TMM_BWEXTAdministrative Data for Extractors
EKKOPurchasing Document Header
T161PHActivate Park and hold in Purchasing documents
EKPAPartner Roles in Purchasing
MMPRC_DISTR_PTNRTable to hold partner data in Purchasing doc distribution
TMSI1Sub-Item Category in Purchasing
T163DAssignment Internal/External Confirmation Category
MMPUR_REC_PCNFINAIF Default Keyfield Table PurchaseOrderERPConfirmation_In_V
EKCPIPurchasing Contract Commitment Plan Item Information
T161FRelease Point Assignment for Purchase Requisition Release
A160Plant Info Record: Variants
T161PCheck of Document Type, Document Category, Item Category
MMPUR_REC_POHSINAIF REC POItemHistoryNotification_In
EKBZ_MADelivery Costs at Account Assignment Level
MEPO_BADI_EXAMPLBAdI ME21N: Example: Customer's Own Data
T161Purchasing Document Types
INFREC_ARCHIVEArchiving Index for info records
EKBZH_MAHistory Table Delivery Costs at Account Assignment Level
EKBZHistory per Purchasing Document: Delivery Costs
T16F_PROCESSORSProcessors for PO Release Steps
EKRSDCERS Procedure: Planned Delivery Costs to be Invoiced
T16FVRelease Prerequisites
MEREQ_BADI_EXAMPBAdI ME51N: Example of Customer's Own Data
T160ODescription of Scope of List
T16LCDescription of Scope of List: Purchase Requisitions
EKBEHistory per Purchasing Document
T167Number Range Management for Purchasing Master Data
EBAN_TECHPurchase Requisition for External Sourcing
EINEPurchasing Info Record: Purchasing Organization Data
EKEKHRemoved Header Data of Scheduling Agreement Releases
EKCPHPurchasing Contract Commitment Plan Header Information
T16FTDescriptions of Release Strategies
T16LFRoutines for Data Retrieval in Requisition Lists
T161HFields for Release Procedure, Purchase Requisition
T175DPCategories of Down Payment Request in Purchasing
EKPOPurchasing Document Item
PEKESVariant Supplier Confirmations
T069TCertificate Categories: Text Description
T069Certificate Categories
T168Screen Control, Purchasing
T160BSAP Transaction Control, List Displays, Purchasing
TEBOVolume Rebate Groups, Purchasing
EKPO_DISTRPurchasing Document Item Distribution
T161ERelease Codes
EQUKQuota File: Header
T024WValid Purchasing Organizations for Plant
T027CCodes for Compliance with Shipping Instructions
MMPURUI_CFDOCcFolders ID for Purchasing Documents
MMPRC_CCTR_TSTPLast run timestamp for Central contracts Calloff update
T16FKRelease Statuses
EBKNPurchase Requisition Account Assignment
MMPUR_ANA_EKETAnalytical Data for Schedule Lines
T163CTexts for Purchase Order History Categories
T16FEDescriptions of Release Indicators: Purchasing Documents
EKPBMaterial Provided Item in Purchasing Document
T163GConfirmation Control
T170Copying Control: Texts in Purchasing
T16FWAssignment of Role to Release Code
T161WOrder Types for Stock Transfer
T16LBScope of List: Purchase Requisitions
T163YTexts for Item Categories
TMBWTSource of Supply Keys
EKBEHRemoved PO History Records
EKBE_SRV_SUMTotals History for SRV Documents
MMPUR_IDX_PCREINStandard index table PurchasingContractERPRequest_In_V1
T163FConfirmation Categories: Descriptions
EBAN_ARCHIVEArchiving Index MM_EBAN
T16LDRoutines for Structure of Requisition Lists
TMQ2Quota Arrangement Rules
TMSI2TDescription of Processing Key for Sub-Items
EKUBIndex for Stock Transport Orders for Material
EKBE_SCComponent Consumption History for Subcontracting
MEREQXPurchase Requisition Change Parameter
T167TTransaction Description
EKEHHRemoved Scheduling Agreement Release Documentation
TMSRM_EHTYPSRM Hierarchy Types
MMPUR_IDX_PREQINStandard index table PurchaseRequestERPRequest_In
T16FGRelease Groups
T161MFine-Tuned Control: Message Types
T027DCompliance with Shipping Instructions: Texts
EREVVersion in Purchasing
TMKTSAP Transaction Control: Conditions in Purchasing
T161CSettings for Documents from CRM/BBP
TMKKTGroup for Calculation Schema (Supplier): Description
EKCCIndex Table for CCP Process
T16CRVersion-Relevant Fields of Purchase Requisition
T163Item Categories in Purchasing Document
TMPPFTTexts for Control Profile of Manufacturer Part Numbers
T161NMessage Determination Schemas: Assignment
T16LIData Retrieval for List Scope: Purchase Requisitions
T160DFunction Authorizations: Purchase Order
T160XScope of List: Buyer's Negotiation Sheet
BLK_REASON_TXText Table for Blocking Reason in Purchase Order
T163ACheck Item Category/Account Assignment Category
T16CADCM Control Table: Change Management
T16CCDCM Reason for Change
EBANPurchase Requisition
T163EConfirmation Categories
EKPO_WEIGHTSPurchasing Document Weights
T161IDetermination of Release Strategy
TMKK1Taxes: Account Assignment (Purchasing)
TMBW1Source of Supply Keys
T161BDefault Values for Purchasing
T16CDControl of Selection in Buyer Approval
T160IControl of Intrastat Reports
T027AShipping Instructions, Purchasing
T027BTexts: Shipping Instructions
EKESSupplier Confirmations
EORDPurchasing Source List
T024Purchasing Groups
T161UTexts for Release Indicator
T162KField Selection, Account Assignment Fields, Purchasing
AMPLTable of Approved Manufacturer Parts
T166CPrint-Relevant Purchasing Document Changes
T160CSAP Transaction Control for List Displays in CALL
T168FFunction Codes, Purchasing
T024EPurchasing Organizations
T163ITexts for Account Assignment Categories
T024W_CCPPlant/Supplying Plant Assignment for Extended Source Determ.
POEXTEnhancement Fields for Purchase Order
TMAMInternal Comment on Quotation
T166KHeader Texts in Purchasing Document Printouts
EKABRelease Documentation
T166ASupplement Text in Purchasing Document Printouts
T16LLRoutines for List Scope: Purchase Requisitions
MMDOC_HIER_LINKSDocument links of a hierarchy document
EKANobsolete as central address management is used
T175DP_TEXTTexts for Down Payment Categories
T165KCopying Options: Header Texts
EKDFDocument Flow for Logistics Differential Invoice
MMPRC_HUB_MSGSTable to hold messages raised on Purchasing doc distribution
T163RCTDescription of Reason for Final Account Assignment Indicator
EKETScheduling Agreement Schedule Lines
T162YGroups: Field Selection
TAMPSPTManufacturer/Part Combinations: Texts for Blocking Reasons
EQUPQuota File: Item
CRS_PURCHITM_MAPMapping of CRM purchase assignments to preq items
T163RCReason for Final Account Assignment Indicator
MMPRC_CC_CALLOFFCalloff data for Central contracts in Hub
TMKW1TTaxes: Plant (Purchasing)
T16LATexts on Status of Requisition Processing
T161TTexts for Purchasing Document Types
T165PCopying Options: Item texts
EIPAOrder Price History: Info Record
MMPRC_CCTR_RELORCalloff data for Central contracts in Hub
TMKSCalculation Schemas: Purchasing
T166TChange Texts in Purchasing Document Printouts
T163LConfirmation Control Keys
T16PCPurchasing Document Process Control internal Features
TEMPLATE_DATATemplates
T16LHDefault List Scope for Requisitions in Transactions
MMPRC_ARC_LOGMAPMapping of Log Files for Archiving in S/4HANA Hub System
TAMPSPManufacturer/Part Combinations: Blocking Reasons
TBSGPurchasing Documents: Reasons for Ordering
EKKNAccount Assignment in Purchasing Document
T16FCRelease Codes
T460QSpecial Procurement Types per Procurement Type
TMAMTInternal Comment on Quotation: Descriptive Text
TMKETGroup for Calculation Schema (Purch. Org.): Description
EKEKHeader Data for Scheduling Agreement Releases
T16CEOutput Control: Display of Change Documents in Purchasing
EKEHScheduling Agreement Release Documentation
MMDOC_EXT_LINKSMaintain External Links for Purchasing Documents
T166UHeadings in Purchasing Document Printout
T16FBRelease Indicator: Purchasing Document
T16LETexts for Routines for Structure of Requisition Lists
TMBW2Source of Supply Keys
T160EFunction Authorizations: Purchasing: Descriptions
MMPUR_REC_PORQINAIF Default Keyfield Table PurchaseOrderERPRequest_In_V1
T16FSRelease Strategies
T160MMessage Control: Purchasing (System Messages)
TMSRM_EHTYPTSRM Hierarchies
MPNCL1Dynamic Calls During Processing of Sub-Items
MMPUR_VERS_CDOCUVersioning Activation per Purchasing Document Type
T163SDescription for Release Creation Profile
MMPUR_IDX_PORQINStandard index table PurchaseOrderERPRequest_In_V1
TMKK1TTaxes: Account Assignment (Purchasing)
MMPUR_VERS_CRSNCVersioning: Reason Codes
TEBOTVolume Rebate Groups (Purchasing): Texts
T160PEntities Table Routines
TMSI2Processing Key for Sub-Items
T160SAP Transaction Control, Purchasing
T160LScope of Purchasing Lists
TMPPFControl Profile for Manufacturer Part Number Management
T160YScope of List: Buyer's Negotiation Sheet: Description
TMSI4Time-Spots for New Determination of Sub-Item
T160VDefault Values for Purchasing
T160SSelection Parameters for Purchasing Lists
T069QControl Data for Source Determination and Checking
T160TDescription of Selection Parameters
TMKSUCalculation Schema: Purchasing: for Stock Transfer
TMKLTDescription of Scope of List: Conditions (Purchasing)
TMSI1TDescription of Subitem Category
T160QScope of List: Buyer's Negotiation Sheet: Routines
T160WDescription for Default Values for Purchasing Operations
TMKEGroup for Calculation Schema (Purchasing Organization)
EKRSERS Procedure: Goods (Merchandise) Movements to be Invoiced
TMKGTDescription of Condition Group
TMKM1Taxes: Materials (Purchasing)
TMKLScope of List for Conditions in Purchasing
TMKGGroup of Conditions Table
TMEDPurchasing Various Control Parameters
TMKRSequence of Conditions Tables in Purchasing
T16FDDescription of Release Codes
T161ALinkage of Requisition Doc. Type to Purchasing Document Type