SAP IS Tables

Data Collection Tables (LO-LIS-DC)

Table	Description
S001	SIS: Customer Statistics
S031	Statistics: Movements for current stocks
S066	Open orders: credit management
S012	Purchasing
S032	Statistics: Current Stock and Grouping Terms
S002	SIS: Sales Office Statistics
S067	Open deliveries/billing documents (KM)
S026	Material Usage
S004	SIS: Product/Sales Organization/Distribution Channel
S039	Statistics: Inventory Controlling
S076	Sales & Operations Planning
S022	SFIS: Order Operation Data for Work Center
S990	Sales Forecasting Actuals
S003	SIS: SalesOrg/DistCh/Division/District/Customer/Product
S013	PURCHIS: Statistics for Vendor Evaluation
.....	..................................

Inventory Controlling Tables (MM-IS-IC)

Table	Description
PROP	Forecast parameters
MAPR	Material Index for Forecast
S094	Stock/Requirements Analysis
TMCA	Evaluating movement types for LIS update
PRON	Postprocessing of forecast errors and exception messages
MCON	Generierte Tabelle zu einem View
S196	Goods movement: Plant
S195	Material movements: storage location
S198	Periodic plant stock
S197	Periodic storage location stock
T001W_BIW	Generierte Tabelle zu einem View

Integration Engine Tables (BC-XI-IS-IEN)

Table	Description
SXMSPMAST	Integration Engine: Message Queue (Master)
SXMSPLSRV	XMS: Pipeline Service Specification
SXMSCLUR	XMB: Resources Cluster
SXMSCLUP	XMB: Property Cluster
SXMSPMAST2	XML Message Broker: Message Queue (Master) (Switch Table)
SXMSCONFDF	XMS: Integration Engine Configuration Parameters
SXMSPVERS	Integration Engine: Message Version
SXMSPHIST	XML Message Broker: History
SXMSPEMAS	Integration Engine: Enhanced Message Queue (Master)
SXMSCONFVL	XMS: Integration Engine Configuration Data
SXMSPERROR	XML Message Broker: Message Queue (Incorrect Entries)
SXMSPIPE	XML Message Server: Pipeline Definition
SXMSSPDIAGS	Objects for SXMS SUPPORT DIAGNOSTICS
SXMSPVERS2	Integration Engine: Message Version (Switch Table)
SXMSSYERR	XMS: System Error Error Codes
.....	..................................

Reporting Tables (LO-LIS-REP)

Table	Description
MCSI	File for Storage of Selection Versions (INDX)
MCSA	File for saving selection versions (AUSTAB)
MCSHIERB	Tree for general hierarchy
TMC73	Key Figure Information for the Standard Analyses
TMC7	Standard Analyses in Logistics Controlling
MCSLOGDIR	Directory of MCSLOG Entries
MCRSV	Selection versions: Header data
MCKZS	Key figure views in Logistics Controlling
MCKZSF	Key figures for key figure view
MCKZST	Texts for key figures of the key figure view
MCRMK	LIS selection versions: Characteristics
MCRSVT	Logistics Controlling: Texts for selection versions
MCSIDIR	Directory of MCSI Entries
TMCRT	Texts for RMCS0F00 (LIS Standard Analyses)
TMC8	Predefined Key Figures per Analysis
.....	..................................

Reporting Tables (PM-IS-REP)

Table	Description
S115	Cost Evaluation
S061	Location and planning
S070	Breakdown Statistics
S062	Object class and manufacturer
MCIPMIS	PMIS: Master data characteristics for PMIS before image
S065	Object statistics
S063	Damage Analysis 30 .
S205	MAP: Store Planning Movements
S064	Single object - damage analysis
PMCO2	Cost structure: Job key figures (PMIS)
S205E	S205 - Structure Information
PMCOCKF	Cost/Quantity structure: Customer-specific key figs (PMIS)
PMMRCKF	IMG: Assign QUAN Fields to UNIT Fields
PMMRCKFA	IMG: Update PMIS Measurement Document: Assignments and Units
PMMRCKFB	IMG: Consumption Key Figures in PMIS: Function and Arguments
.....	..................................

Data Collection Tables (SD-IS-DC)

Table	Description
KNA1VV	Generierte Tabelle zu einem View
S264	SD- Offer
H_VAKZ	Generierte Tabelle zu einem View
LFA1M1	Generierte Tabelle zu einem View
H_TVBUR	Generierte Tabelle zu einem View
M_VKNKA	Generierte Tabelle zu einem View
V_VKORG_BW	Generierte Tabelle zu einem View
H_T179	Generierte Tabelle zu einem View
H_TVAU	Generated Table for View H_TVAU
S264BIW1	S264BIW1 * SD - Quotation
S264BIW2	S264BIW2 * SD - Quotation
H_TVKO	Generated Table for View H_TVKO
H_T685	Generated Table for View H_T685
H_TVAK	Generierte Tabelle zu einem View
H_TVFK	Generierte Tabelle zu einem View
.....	..................................

Statistics Tables (IS-U-IS-ST)

Table	Description
DBESTA_BWPROT	Log Recordc for BW Sales Statistics Update
TE771T	Rate Category: Statistics Groups - Texts
S440	IS-U rate statistics
EITESTA	IS-U Sales Statistics: Temp. Index for Document Selection
TE770	Contract: Statistics Groups
TE770T	Contract: Statistics Groups - Texts
TE771	Rate Category: Statistics Groups
TE775	Update Group Determination
TE776	UIS: Alloc. of Billing Unit of Meas. -> Stat. Unit of Meas.
TE777_BIW	BW: Specify Statistics Currency
TE777_UIS	UIS: Specify Statistics Currency
TE778	Reduce Data Quantity in Sales Statistics Extractor
TE789	Trans. Stats Categories
TE789C	Control for Updating Transaction Stats
TE789T	Texts for Transaction Statistics Categs
.....	..................................

Vendor Evaluation Tables (MM-IS-VE)

Table	Description
ELBP	Main Criterion for Vendor Evaluation
ELBK	Vendor Evaluation: Header Data
ELBM	Vendor Evaluation: Material-Related Item
T147I	Definition for Subcriteria for Main Criterion
T147D	Texts for Subcriteria in Vendor Evaluation
T147B	Texts for Main Criteria in Vendor Evaluation
T147F	Description of Weighting Keys in Vendor Evaluation
T147G	Main Criteria in Vendor Evaluation
T147J	Weighting Keys in Vendor Evaluation
EVAL_IV_RES_HD	Results of Vendor Evaluation (Header)
EVAL_IV_RES_ITM	Results of Vendor Evaluation (Item)

Runtime Workbench/Monitoring Tables (BC-XI-IS-WKB)

Table	Description
SXMSALERTLOGGER	XI Alert Logs
SXMSPFRAWH	Integn Eng: Header Table for Raw Data for Performance Evaln
SXMSMSTAT	Exchange Infrastructure: Message Status
SXMSPFCOMPONENT	Integration Engine: Component Information
SXMSALERTRULES	Rules for Alert Generation: Msg Header -> Alert Category
SXMSPFRAWD	Integration Engine: Data Table for Raw Data for Performance
SXMSMSTATT	Exchange Infrastructure: Message Status Description
SXMSPFADDRESS	Integration Engine: Sender and Receiver Information
SXMSMSGFILTER	SAP XI: Filter for Sender/Receiver Attributes
SXMSMSGINDCUS	SAP XI: Configuration for Indexing of Messages
SXMSMSGINDLOG	SAP XI: Indexing Log of Messages
SXMSMSGINDSRV	SAP XI: Services for Indexing of Messages
SXMSMSGPMI	Using XI Messages in PMI
SXMSALERTCONTROL	Control Table
SXMSPFAGG	Integration Engine: Aggregated Data for Performance Display
.....	..................................

Data Collection Tables (EC-EIS-DCM)

Table	Description
TKAF	Field catalog for Accounting
TKCHW	SAP-EIS: Hierarchy data
COIX	Controlling: Info system cluster tables
CF001	Profitability Analysis
COIX_DATA40	Cluster table infosystem
T242B	Characteristic values per characteristic
T242V	Data area (previously version)
TKEBW	Description of exceptions
CF005	Personnel Information
CF003	Projects
TKCTK	Language Table for Key Figures
CF006	Balance Sheet
COIX_DATA	Controlling: Info system cluster tables
TKCDO	Min. homogeneousness
T241B	Description of Characteristic Values
.....	..................................

Early Warning System Tables (LO-LIS-EWS)

Table	Description
MCY1	Objects: Early Warning
MCYM	Objects: Early Warning
MCYB	Objects: Early Warning
MCYA	Early Warning: Exceptions
MCYC	Key Figures: Early Warning
MCYAT	Early Warning: Exception Texts
MCYD	Early Warning: Groups of Exceptions
MCYE	Early Warning: Trend Analysis Requirements
MCYF	Early Warning: Exception Texts
MCYT	Early Warning: Exception Texts

Industry Solution Oil Tables (IS-OIL)

Table	Description
C410	Chart of accts / Account key - acct assign for ED rev
OIJNE	Nomination Events
OIRADBT	Document base table
C011	Company Code/Payment card type/Splitting result
Q001	Company/Card Type/Split Result
S430	SIS: (OIL-TSW) Sales document statistics by TSW object
OIB_DEF_INDEX_GM	Default index for Goods Movement
OIUH_RV_GL	Journal Entry General Ledger Table
C013	Company Code / card type
OIJNOMI	Nomination Item
OIAQB	Exchange Movements Index
LIPSO2	Appendix for Delivery Note Additional Quantities
OI001	Company Code Parameters
MSEGO2	Material Document Quantities in Additional Units of Measure
OIIX	OIL-BDRP: Application control record
.....	..................................

Business Process Engine Tables (BC-XI-IS-BPE)

Table	Description
SWFXICACHE	XI: Cache for Process Definitions
SWFRXIHDR	XI Adapter: Header Data for a Message Object
SWFDCRLDLVMODE	Configuration of Inbound Processing
SWFDXMPCNTT	XML Message Proxy: Container Definition (Text)
BRR_HEADER	Header Data of a Business Rule (Table Structure)
BRR_HEADER_C	Client-Specific Business Rule (Table Structure)
SWFXICLOG	XI Cache: Message Log
SWFXIOBJS	XI: Cache: Objects of a Process Definition (Proxy, CRL..)
BRR_ATTRIB	Custom Attribute or Rule
BRR_ATTRIB_C	Custom Attribute or Rule
SWFXIPROCMSGREL	Relationship Between Process Instances in XI Messages
SWFBDVLINK	Generierte Tabelle zu einem View
BRR_TEXT	Language-Dependent Rule Text
BRR_TEXT_C	Text for a Language-Dependent Rule
SWFRXICNT	XI Adapter: XML Container for a Message Object
.....	..................................

Industry Solution Engineering & Construction Tables (IS-EC)

Table	Description
COSTING_VARIANT	Default Costing Variant for Easy cost planning
J_3GABEST	Current Stocks
J_3GHBEST	Historical Stock
J_3GSTLKOPF	Header Data for Equipment BOMs
J_3GVERSI	Tax/Insurance Data
J_3GTBEST	Temporary Stock
J_3GBELP	Document Data - Item Data
C496	Condition Type/Account Key
J_3GBELK	Document File - Header Data
A258	Movement Type/Sender Type/Recipient Type
A370	Customer/Service
ADBOS_ECP_REL	Object Relationship Service: Generic Binary Links
A254	Customer or Goods Recipient/Equipment/Material
A255	Customer/Loading Cost Relevance
A265	Standard Dummy Customer/Document Type/Material Grp/Material
.....	..................................

Aerospace & Defence Industry Solution Tables (IS-AD)

Table	Description
MSID	Vendor Stock with Vendor
MSIS	Vendor Stock with Vendor - Total
MCSD	Customer Stock
MCSS	Total Customer Stock
MSCD	Customer stock with vendor
EQUIPKPI	Used to store the Delta values and counters for MTBE calc
MSRD	Project Stock with Vendor
MSFD	Sales Order Stock with Vendor
MSCDH	Customer stock with vendor - History
SPCGLOBAL	Global constants for SPEC 2000
DIS_TOBJS_COSP	Distribution: Objects distributed to per Group WBS (Cost)
MSFDH	Sales Order Stock at Vendor: History
MSFS	Sales Order Stock with Vendor - Total
MSIDH	Vendor Stock with Vendor - History
MCSDH	Customer Stock: History
.....	..................................

Logistics Information Library Tables (LO-LIS-LIB)

Table	Description
MCLI	Key Figures in Information Library
MCLIO	Info Set Text in LIL
MCLIP	Info Set Assignment in LIL
MCLIT	Key Figure Texts
MCLIN	Info Sets in LIL
MCLIV	Default Values in LIL

Interactive Drilldown Reporting Tables (EC-EIS-DD)

Table	Description
TRSTHV	BRST directory of hierarchies
TRSTHC	BRST directory of hierarchy classes
TRSTHVT	BRST Texts for hierarchies

Purchasing Information System Tables (MM-IS-PU)

Table	Description
MCEKS	R/2 PURCHIS Data (Status: Last Data Transmission)

Industry Solution Catch Weight Management Tables (IS-CWM)

Table	Description
CON_FIN_WQ_HDR	Header Table for Transactions in Work Queue
CON_FIN_WQ_DATA	Data of Transactions in Work Queue (INDX Table)

Defense Forces and Public Security Tables (IS-DFS)

Table	Description
HRP1985	DB Talbe for Infotype 1985
HRP1950	DB Table for Infotype 1950
HRP1955	DB Table for Infotype 1955
HRP1953	DB Table for Infotype 1953
HRP1954	DB Table for Infotype 1954
HRP1956	DB Table for Infotype 1956
HRP1957	DB Table for Infotype 1957 - Obsolete, DO NOT USE
HRP1959	DB Table for Infotype 1959
HRP1980	DB Table for Infotype 1980
HRP1981	DB Table for Infotype 1981
HRP1982	DB Talbe for Infotype 1982
HRP1951	DB Table for Infotype 1951
HRP1952	DB Table for Infotype 1952
HRP1958	DB Table for Infotype 1958
HRP1983	DB Talbe for Infotype 1983
.....	..................................