SAP Data Collection Tables

Are you looking for the right table related to SAP Data Collection 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 Data Collection (LO-LIS-DC) module.

Top 10 tables in Data Collection

TableDescription
S053ES053 - Structural Information
S006SIS: Sales Rep/SalesOrg/DistCh/Division/Customer/Product
S110OTB
S050Shipment
TMCW1Table for Counter Readings of Info Structures Re-Setup
TFCGFields Catalogs for Statistics Fields
TMCELIS - Environment generation sample reports and references
S305ES305 - Structure Information
TMC25Valid Hierarchies for Formulas/Conditions
TMC26Texts for Valid Hierarchies for Formulas/Requirements

List of tables in Data Collection

TableDescription
S053ES053 - Structural Information
S006SIS: Sales Rep/SalesOrg/DistCh/Division/Customer/Product
S110OTB
S050Shipment
TMCW1Table for Counter Readings of Info Structures Re-Setup
TFCGFields Catalogs for Statistics Fields
TMCELIS - Environment generation sample reports and references
S305ES305 - Structure Information
TMC25Valid Hierarchies for Formulas/Conditions
TMC26Texts for Valid Hierarchies for Formulas/Requirements
TFCSPermissible Source Tables per Application
S274ES274 - structure information
TMC2PTable for Number Assignment of Update Reports
S274Do not use!
TMCBIWLIS: BIW Customizing
TMC1TShort Texts on Generated DDIC Structures
TMCLVBWTTexts for Transaction Key for SAP BW
TMC1KSSave Versions for Table TMC1K
S300ES300 - Structural Information
S003BIW1S003BIW1 * SIS: SaleOrg/Dist.Channel/Divisn/Distrct/Cust/Pro
S004ES004 - Structural Information
S051ES051 - Structural Information
S303WIS: Group view
S273BIW2Do not use!
S006ES006 - Structural Information
S119Transaction Number (Till Receipt)
TMC1DData Elements of Generated DDIC Structures
S002BIW1S002BIW1 * SIS: Sales office statistics
MCS0Reference Structure for Generating Info Structures
S035Statistics: Batch Stocks
S003ES003 - Structural Information
S092ES092 - Structural Information
S054ES054 - Structural Information
S012Purchasing
S409ES409 - Structure Information
S016ES016 - Structural Information
S272Do not use!
S274BIW1Do not use!
TMC2DKey Figures (Updating)
S303ES303 - Structural Information
MCCMFOTax table, Copy Management formulas
MCSLISEHLIS Inbound Interface: Control Information (Headers)
S079STRPS: Movements + Stock
MCSMETTTexts for Methods to Transform LIS Statistical Data
S117Receipt/article
S077ES077 - Structural Information
S092Resource Requirements: Material
S304WIS: Sample scenario
S004BIW2SIS: Product/Sales Organization/Distribution Channel
S272BIW1Do not use!
TMCW3Table for Counter Readings of Info Structures Re-Setup
S085Material: Movements + Stock
S027Product Costs
S305WIS: Applicatons PM/QM/SM
LOLIS_IDX_INVCO1Standard index table
S150ES150 - Structural Information
S120Sales as per receipts
S005ES005 - Structural Information
S119ES119 - Structural Information
S081ES081 - Structural Information
S091ES091 - Structural Information
TMC2SInfo Structures to be Updated per Business Event
MCSSZENTTexts for MCSSZEN
S138Variants: SIS & planning
S021SFIS: Order Item Data for Material
S017SIS: Sales promotions
S032ES032 - Structural information
S277BIW2S277BIW2 * Transfer to BW: Revaluation at Retail
S005BIW2S005BIW2 * SIS: Ship.Pnt/Route/Forw.Agent/Recipient Country
S003SIS: SalesOrg/DistCh/Division/District/Customer/Product
S085ES085 - Structural Information
S127ES127 - Structural information
S125Forecast history for ex. system
S275BIW2S275BIW2 * Transfer to BW: Purchasing Data
S140Product Allocations
S011BIW1S011BIW1 * PURCHIS: Purchasing Group Statistics
S130Replenishment
S277BIW1S277BIW1 * Transfer to BW: Revaluation at Retail
S122ES122 - Structural Information
S165Inspection Results (General): Customers
S053Shipment: shipping data
TMC5Business Events for Statistics Updating
MCSCMVARLIS Copy Management: Control Table for Variant Maintenance
S128ES128 - Structural information
S107ES107 - Structural Information
S140ES140 - Structural Information
TMC4Global Control Elements: LIS Info Structure
S276BIW1S276BIW1 * Transfer to BW: Sales and Distribution Data
S084ES084 - Structural Information
S160ES160 - Structural Information
TMC4UCTRansport Table for Info Structure Data Connections
S279BIW2S279BIW2 * BW Transfer: Inventory Management
MCS2Sample Structure for Structural Information - Info Structure
S171Payment item data
S091BIW1S091BIW1 * WM: Quantity flows
S054Stages of shipment
S076ES076 - Structural Information
S152W&S: Rough Workload Estimate - Goods Issue
S166Quantitative Inspection Results: Customer
S263SD - Sales order/delivery note
S006BIW1S006BIW1 * SIS: Sales Rep/SalesOrg/DistCh/Division/Customer/
S162Quantitative Inspection Results
S098ES098 - Structural Information
S008Communications Table SD -> CO/Projects
S034ES034 - Structure Information
S136Index: conditions in document
S196BIW2S196BIW2 * Goods Movement: Plant
S090WM: Stock placements/removals
S276BIW2S276BIW2 * BW Transfer: Sales and Distribution Data
S123ES123 - Structural Information
S001BIW1S001BIW1 * SIS: Customer Statistics
LOLIS_REC_INVCO1AIF Default Keyfield Table
TMC21Application-Specific Parameters for Generating Updates
MCSSZENLIS Data management scenarios
S022ES022 - Structural information
S087Material/add-on
S013BIW1PURCHIS: Statistics for Vendor Evaluation
S100Problems: Material Analysis
TMC2FRelevant Update Routines for Info Structures
S027ES027 - Structural Information
MCSMETMethods for Reassignment of Statistical Data
S026Material Usage
MCSLISEFLIS Inbound Interface: Control Information (Fields)
S019SIS: Address counter
TMC24ASpec. Source Fields for Unit Fields Per Event
S091WM: Quantity flows
MCSLOGFile for saving logs
S039ES039 - Structural Information
S077STRPS: Movements
S004BIW1SIS: Product/Sales Organization/Distribution Channel
S130ES130 - Structural Information
S164Quantitative Inspection Result: Vendor
S052ES052 - Structural Information
S275BIW1S275BIW1 * Transfer to BW: Purchasing Data
S055ES055 - Structural Information
S225ES225 - Structural Information
S302ES302 - Structural Information
S126Open Variants - Basis 1
S110ES110 - Structural Information
S096ES096 - Structural Information
S076Sales & Operations Planning
S172ES172 - Structural Information
S159ES159 - Structural Information
S120BIW1S120BIW1 * Sales as Per Receipts
S074Subsequent Settlement: Operative
S018ES018 - Structural Information
S261BIW1SD - Delivery note
S060Model Structure for Info Structures with Initial VAKEY
S080ES080 - Structural Information
S263BIW1SD - Sales order/delivery note
S039Statistics: Inventory Controlling
TFCAPermitted Field Catalogs for Each Application
S120BIW2S120BIW2 * Sales as Per Receipts
TMC2DSKey Figures (Updating)
S003BIW2S003BIW2 * SIS: SaleOrg/Dist.Channel/Divisn/Distrct/Cust/Pro
S195BIW1S195BIW1 * Goods Movement: Storage Location
TMC4CConnections of Info Structures
S032Statistics: Current Stock and Grouping Terms
S173ES173 - Structural Information
S181Free Goods Values
S152ES152 - Structural Information
S067Open deliveries/billing documents (KM)
S127Open Variants - Basis 2
S068ES068 - Structural Information
S038ES038 - Structural information
S082ES082 - Structural Information
S272BIW2Do not use!
TMC2_EXT_CHECKEnhanced Check for Update Rules
S120ES120 - Structural Information
TMCBIWULIS: BIW Customizing
S262BIW2SD - Billing document
S012BIW1S012BIW1 * Purchasing
S278BIW1S278BIW1 * Transfer to BW: Stock
S029KANBAN
S091BIW2S091BIW2 * WM: Quantity Flows
S260SD - Sales order
TMC6PNecessary Characteristics for Units
VKMILog for Updating Open Credit Values (S066, S067)
TMCAEFeatures of Application
TMC7K_CHECKDefinition of the Char. Chain f. Checking the Info Structure
S123Customer / material group
S122BIW2S122BIW2 * Cashier
S016SIS: Sales activities
S200Inventory Controlling Stores
S195BIW2S195BIW2 * Goods Movement: Storage Location
LOLIS_IDX_INVCO2Standard index table INVCON02
S174BIW2S174BIW2 * Activities
S015Subsequent Settlement: Evaluation
S172Vendor billing document data
S170Payment document data
TMC24Source Fields for Units Fields per Event
S174Services
S001SIS: Customer Statistics
S078STRPS: Stock
S108ES108 - Structural Information
S198BIW1S198BIW1 * Periodic Plant Stocks
S104ES104 - Structural Information
S128Open Variants - SIS
S005BIW1S005BIW1 * SIS: Ship.Pnt/Route/Forw.Agent/Recipient Country
S301ES301 - Structural Information
S013BIW2S013BIW2 * PURCHIS: Statistics for vendor evaluation
S117ES117 - Structural Information
S196BIW1S196BIW1 * Material Movements: Plant
S073Cumulative Delivered Quantities
S021ES021 - Structure information
S011BIW2S011BIW2 * PURCHIS: Purchasing Group Statistics
S094ES094 - Structural Information
TMCUSParameters for Standard Analyses in LIS
S161Inspection Results: General
S081Purchasing: Stock
S104Customer Statistics
TMCAPApplications: Logistics Information System
S126ES126 - Structural information
S271BIW1Do not use!
S225Goods receipts: repetitive manufacturing
S017ES017 - Structural Information
S304ES304 - Structural Information
TMC4TDescriptions of LIS Information Structures
MCSLISEHTLIS Inbound Interface: Control Information (H): Texts
S013PURCHIS: Statistics for Vendor Evaluation
S012BIW2S012BIW2 * Purchasing
S093ES093 - Structural Information
S137Variants: Basis 2
S200ES200 - Structural Information
S116Customer Analysis
S271Do not use!
S108Additionals
S093Resource Requirements: Material
S173Vendor billing document item
S024Totals Records for Work Center
S150W&S: Rough Workload Estimate
TMCZTTexts on Special Info Structure Categories
S159W&S: Picking Waves
S024ES024 - Structural information
TMC6Units for Statistics Updating
TMC4UTTransport Table for Info Structure Texts
S100ES100 - Structural Information
TMC4UTransport Table for Info Structure Data
S273BIW1Do not use!
S106Season: Stock
S069ES069 - Structural Information
S064ES064 - Structural information
S194MRP: Business Info Warehouse
S226ES226 - Structural Information
S028ES028 - Structural Information
S083ES083 - Structural Information
S129ES129 - Structural information
S011ES011 - Structural Information
S034INVCO: Movements (Batches)
S174BIW1S174BIW1 * Activities
S066Open orders: credit management
MCCMDETax table, Copy Management
TFCTField Catalog Description
S012ES012 - Structural Information
S270BIW1Do not use!
TMC2LIS: Status Management - Updating
S086ES086 - Structural Information
LOLIS_IDX_INVCO3Standard index table INVCON03
S072Individual Records for Inspection Lot
S006BIW2S006BIW2 * SIS: Sales Rep/SalesOrg/DistCh/Division/Customer/
S279BIW1S279BIW1 * BW Transfer: Inventory Management
TMC23ASpec. USING Parameter for Unit Conversion Per Source Field
TMC2KObjects (Updating)
LOLIS_REC_INVCO2AIF Default Keyfield Table INVCON02
S084Material: Stock
S129Open Variants - Planning
S170ES170 - Structural Information
TMCZSpecial Categories of Info Structures
TMCATApplication Text: Logistics Information System
TMCLBWLogistics Control Table for Enhancement in SAP BW
S124ES124 - Structural Information
S273Do not use!
S026ES026 - Structural Information
TMC6UValid Unit Conversion: Source Field/Statistics Field
MCSSZENVTText table to MCSSZENV
S111ES111 - Structure Information
S009CAS: Last Documents
S033Statistics: Movements for Current Stock (Individual Records)
S004SIS: Product/Sales Organization/Distribution Channel
S270ES270 - Structural Information
S022SFIS: Order Operation Data for Work Center
S171ES171 - Structural Information
S038All Key Figures for Batch Analysis
S001ES001 - Structural Information
S018SIS: Address list for sales promotion
S273ES273 - Structure information
S002SIS: Sales Office Statistics
S125ES125 - Structural information
S122BIW1S122BIW1 * Cashier
S051Shipment routes
S019ES019 - Structural Information
S102ES102 - Structural Information
S262BIW1SD - Billing document
S121Material aggregation - POS
S013ES013 - Structural Information
MCPRVERGeneration Version of LIS Programs
S069Material Statistics
S271ES271 - Structural Information
S106ES106 - Structural Information
S174ES174 - Structural Information
S098QM notifications: vendor analysis
S122Cashier
S111Index: Subsequent Settlement
S096Distribution Scenario
S082Purchasing: Movements + Stock
MCS1Model Structure for Info Structures with Initial VAKEY
S105Season: Movements
S025SFIS: Run Schedule
S226Material usage: repetitive manufacturing
S099ES099 - Structural Information
S078ES078 - Structural Informaton
S083Material: Movements
S002BIW2S002BIW2 * SIS: Sales office statistics
S197BIW2S197BIW2 * Periodic Storage Location Stock
S271BIW2Do not use!
S181ES181 - Structural information
S278BIW2S278BIW2 * Transfer to BW: Stock
S121ES121 - Structural Information
TFCFFields in Field Catalogs
S031Statistics: Movements for current stocks
S270BIW2Do not use!
TMC2QReference as to Which Update Uses Which Program
S050ES050 - Structural Information
S015ES015 - Structural Information
TMC6TDescription of Units for Statistics Updating
S001BIW2S001BIW2 * SIS: Customer statistics
TMC2_EXT_CHECK_DEnhanced Check for Update Rules - Date Fields
S160Perishables
S023ES023 - Structure information
S086Promotion
S124Customer / material
S105ES105 - Structural Information
S102Problems: Vendor Analysis
TMC2KSObjects (Updating)
S005SIS: Shipping Point/Route/Forwarding Agent/Receiving Country
S074ES074 - Structural Information
S137ES137 -Structural Information
S052Means of transportation
S002ES002 - Structural Information
S261BIW2SD - Delivery note
MCDYNTYPENScreen Types for LIS Generation
S272ES272 - Structural Information
S079ES079 - Structural Information
TMC2WAdditional Information and Warnings for Source Fields
S090ES090 - Structural Information
S116ES116 - Structural information
TMC1DSSave Versions for Table TMC1D
TMCTCLIS Transaction Code Control
S080Purchasing: Movements
S263BIW2SD - Sales order/delivery note
S302WIS: Object view
S103ES103 - Structural Information
S097QM notifications: material analysis
TMC20Parameters for Generating Updating (Internal Use)
S227ES227 - Structural Information
S099QM notifications: customer analysis
S087ES087 - Structural Information
S300WIS: Organization view
S097ES097 - Structural Information
S301WIS: Process view
TMC1Generated DDIC Structures for LIS, Conditions, Output
S274BIW2Do not use!
S163Quantitative Inspection Result: Vendor
MCSCMFIELDSDefinition of field processing category in LIS Copy Mgmt
S138ES138 - Structural Information
MCSSZENVMethod references to LIS Data Management scenarios
TMC5TDescription of Events for Statistics Updating
LOLIS_REC_INVCO3AIF Default Keyfield Table INVCON03
S103Problems: Customer Analysis
S198BIW2S198BIW2 * Periodic Plant Stock
S014CAS Document Information
S107Season: Movements + Stock
S260BIW2SD - Sales order
S023SFIS: Totals Records for Material
S055Shipment: materials
TMC23Necessary USING Parameters for Unit Conversion
TMC1KKey Elements in Generated DDIC Structures
S261SD - Delivery note
S028Reporting Point Statistics
S011PURCHIS: Purchasing Group Statistics
S033ES033 - Structural information
TMCLVBWTransaction Key for SAP BW
S262SD - Billing document
S194BIW1S194BIW1 * MRP: Business Info Warehouse
S197BIW1Periodic storage location stock
TMCBUpdate groups
S270Do not use!
S260BIW1SD - Sales order
S227Product costs: repetitive manufacturing
TMCBTUpdate Groups (LIS): Texts
S136ES136 - Structural Information