	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

141 columns | ERP 6.0 | DATEFROM

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/B364/TFPERID	Texts: Char. Employee	4	DATEFROM	Valid from	nvarchar	8	0
2	/B631/HPLANT	Hierarchy: InfoObject Plant	11	DATEFROM	Valid from	nvarchar	8	0
3	/B631/TACTTYPE	Texts: Char. Activity Type	5	DATEFROM	Valid from	nvarchar	8	0
4	/B631/TCOSTCNTR	Texts: Char. Cost Center	5	DATEFROM	Valid from	nvarchar	8	0
5	/B631/TCOSTELMT	Texts: Char. Cost Element	5	DATEFROM	Valid from	nvarchar	8	0
6	/B631/TPROFTCTR	Texts: Char. Profit Center	4	DATEFROM	Valid from	nvarchar	8	0
7	/BI0/HTCTQUERID	Hierarchy: InfoObject Query (UID)	11	DATEFROM	Valid from	nvarchar	8	0
8	/BI0/HTCTUSERNM	Hierarchy: InfoObject User	11	DATEFROM	Valid-From Date	nvarchar	8	0
9	/BI0/HTCTUSRNM	Hierarchy: InfoObject User ID	11	DATEFROM	Valid from	nvarchar	8	0
10	/BI0/PCALMONTH	Master Data (Time-Ind.): Characteristic Calendar Year/Month	8	DATEFROM	Valid from	nvarchar	8	0
11	/BI0/PCALWEEK	Master Data (Time-Ind.): Characteristic Calendar Year/Week	6	DATEFROM	Valid from	nvarchar	8	0
12	/BI0/PCALYEAR	Master Data (Time-Ind.): Characteristic Calendar Year	6	DATEFROM	Valid from	nvarchar	8	0
13	/BI0/QRSPL_ORG	Master Data (Time-Ind.): Characteristic Area of Responsibil.	4	DATEFROM	Valid from	nvarchar	8	0
14	/BIC/B0000159000	PSA for 0COSTCENTER_ATTR T90CLNT090 Cost center	8	DATEFROM		nvarchar	8	0
15	/BIC/B0000160000	PSA for 0COSTCENTER_TEXT T90CLNT090 Cost Center	9	DATEFROM		nvarchar	8	0
16	/BIC/B0000161000	Error Stack DTP_00O2TFZRKJJTTMXXZL7N57I2W 0001	8	DATEFROM		nvarchar	8	0
17	/BIC/B0000282000	PSA for 0EMPLOYEE_TEXT T90CLNT090 Employee	5	DATEFROM		nvarchar	8	0
18	/BIC/B0000284000	PSA for 0EMPLOYEE_2_TEXT T90CLNT090 Employee (Texts)	5	DATEFROM		nvarchar	8	0
19	/BIC/B0000286000	PSA for 0PERSON_TEXT T90CLNT090 Person	5	DATEFROM		nvarchar	8	0
20	/BIC/TZCOSTCENT	Texts: Char. Cost Center	6	DATEFROM	Valid from	nvarchar	8	0
21	/BIC/TZEMP	Texts: Char. Employee	4	DATEFROM	Valid from	nvarchar	8	0
22	/SDF/SQLTIMST	SQL Monitor History: Timestamps - Mapping to time frame	2	DATEFROM	Begin of Data Collection	nvarchar	8	0
23	CMCBD_LQH_ATTR	Liquidity Item Hierarchy Attributes (Header) Runtime	5	DATEFROM	Valid From	nvarchar	8	0
24	CMCB_LQH_ATTR	Liquidity Item Hierarchy Attributes (Header) Runtime	3	DATEFROM	Valid From	nvarchar	8	0
25	DBERCHE	Condition Data	5	DATEFROM	Start Date	nvarchar	8	0
26	DFKKSAFTSAL	Obsolete!	7	DATEFROM	Date	nvarchar	8	0
27	DFKKSAFTSAL_BP	SAF-T Balances	9	DATEFROM	Date	nvarchar	8	0
28	ECONDI	IS-U: Conditions	5	DATEFROM	Start Date	nvarchar	8	0
29	ETOUEXCEPTION	TOU Exception	3	DATEFROM	TOU Exception From-Date	nvarchar	8	0
30	FARR_D_POB_HIS	History table for POB/Contract Structure Change	4	DATEFROM	Valid-From Date	nvarchar	8	0
31	FCLM_LQH_ATTR	Liquidity Item Hierarchy Attributes (Header)	3	DATEFROM	Valid From	nvarchar	8	0
32	RSDDSTATSLICEEX	Extracted values	6	DATEFROM	Valid-From Date	nvarchar	8	0
33	RSDMASTTAB_NOSID	Model Table: Sidless Attr. SID Table (Non-time-dependent)	4	DATEFROM	Valid-From Date	nvarchar	8	0
34	RSSMADAPPARAM	Parameter perisitence for dap generation	3	DATEFROM	Valid-From Date	nvarchar	8	0
35	TIVXCESACCOMP	Companies with agreement of Autonomous community	4	DATEFROM	Date: Valid From	nvarchar	8	0
36	TIVXCESBUPA	Bussiness Partner to Company	4	DATEFROM	Date: Valid From	nvarchar	8	0
37	TIVXCESPOSTING	Posting Deposits	3	DATEFROM	Date: Valid From	nvarchar	8	0
38	VIXCATORDNUM	Purchase Order Number	3	DATEFROM	Valid From	nvarchar	8	0
39	VIXCESCDLOG	Log of Secure Deposit Files	4	DATEFROM	Date: Valid From	nvarchar	8	0
40	VIXCESIBIDATA	IBI master data	3	DATEFROM	Date: Valid From	nvarchar	8	0
41	VIXCITTASICALC	TASI calculation data	3	DATEFROM	Date: Valid From	nvarchar	8	0
42	VIXCITTASIDATA	TASI master data	3	DATEFROM	Date: Valid From	nvarchar	8	0
TOPAssortment Maintenance
43	WSOJOBMAP	MAP: Temporary Listing Table from Planning	12	DATEFROM	Valid-From Date	nvarchar	8	0
TOPBI Content Analyzer
44	RSCONTENTCHECK_E	Exceptions Table for Content Checks	7	DATEFROM	System Date	nvarchar	8	0
TOPBilling in Contract Accounts Receivable and Payable
45	TFK8010	Billing Rate Determination	4	DATEFROM	Start of Validity for a Billing Rate (Date)	nvarchar	8	0
TOPBW Service API
46	ROVERFIELH	Hierarchy using Test Fields in Verification Scenario	11	DATEFROM	Valid-From Date	nvarchar	8	0
47	ROVERTYPEA	Test Type in Verification Scenario	5	DATEFROM	Valid-From Date	nvarchar	8	0
TOPCapacity Evaluations
48	TCY08	Option profiles	26	DATEFROM	Start date for output of capacity evaluations	nvarchar	10	0
TOPClaims Management
49	ICLPROCURE	Claim Item Groupings	15	DATEFROM	Start Date of Period	nvarchar	8	0
50	ICSPROCURE	Claim Item Groupings	15	DATEFROM	Start Date of Period	nvarchar	8	0
TOPCommodity Pricing Engine
51	CPEC_PERIODDET	CPE Term - Period Determination Rule	14	DATEFROM	CPE Term - Start Date for Fixed Period	nvarchar	8	0
52	CPED_PERIODDTIN	CPE Term - Changed Input Data for Period Determination	12	DATEFROM	CPE Term - Start Date for Fixed Period	nvarchar	8	0
TOPConsumption-Based Planning See Also PP-MRP
53	WSAF_EVENTS_OC	Definition of Calendar Events Occurred	4	DATEFROM	Valid From	nvarchar	8	0
54	WSAF_EVENTS_OC_T	Definition of Calendar Effects Occurred (Text)	4	DATEFROM	Valid From	nvarchar	8	0
TOPContract Billing
55	DBERCHZ4	Individual line items (rarely used fields)	39	DATEFROM	Start Date	nvarchar	8	0
56	DBERCHZ8	Document line items (rarely used fields, unimportant)	39	DATEFROM	Start Date	nvarchar	8	0
57	EMDUSDIFTIMETAB	TOU Formulas of TOU Interface	5	DATEFROM	Start Date	nvarchar	8	0
58	EMDUSDIFTIMETABT	Text Table for TOU Periods	5	DATEFROM	Start Date	nvarchar	8	0
59	EMDUSDIFTOUTAB	TOU Periods of TOU Interface	5	DATEFROM	Start Date	nvarchar	8	0
60	EMDUSDIFTOUTABT	Text for TOU Period	5	DATEFROM	Start Date	nvarchar	8	0
61	EMDUSDRQEXCL	Exception Days for Subrequest	5	DATEFROM	Start Date	nvarchar	8	0
62	EMDUSDRQITEM	Subrequest for Request	6	DATEFROM	Start Date	nvarchar	8	0
TOPControlling
63	FCOMIPHIEDIR	Unique Ids for extracted Hierarchies	8	DATEFROM	Valid-From Date	nvarchar	8	0
TOPData Basis
64	RSBMON	Monitor Variants for Open Hub Monitor	3	DATEFROM	Valid-From Date	nvarchar	8	0
65	RSHIEDIR	Hierarchy Catalog	8	DATEFROM	Valid-From Date	nvarchar	8	0
66	RSMAXHIETAB	Hierarchy Node Table with Maximum Possible Structure	11	DATEFROM	Valid-From Date	nvarchar	8	0
TOPData Mining
67	RSDMTP_BAT_HRHDR	BW Hierarchy Creation - Hierarchy Header Details	6	DATEFROM	Valid-From Date	nvarchar	8	0
TOPData Staging
68	RSHIENODETMP	Help Table for Packaged Loading of Hierarchies	10	DATEFROM	Valid-From Date	nvarchar	8	0
69	RSTSODS	Operational Data Store for the transfer structure	4	DATEFROM	Valid-From Date	nvarchar	8	0
TOPElectronic Data Interchange
70	PRICAT_K001	PRICAT: Catalog header	11	DATEFROM	PRICAT: Valid from date of message	nvarchar	8	0
TOPEnergy Data Management
71	EDEXDEFSERVPROV	Data Exchange Definition for Service Provider	5	DATEFROM	Valid From	nvarchar	8	0
72	EDEXDEFUI	Data Exchange Definition for Service Provider	6	DATEFROM	Valid From	nvarchar	8	0
73	EEDMIMPORTLOG_DB	EDM Import Log: Database Table	5	DATEFROM	From-Date for Profile Values	nvarchar	8	0
74	EEDMPROSEND	Recording of Sent Profiles	3	DATEFROM	From-Date	nvarchar	8	0
75	EEDMSETTLDOC	Settlement Document (Header)	3	DATEFROM	From-Date	nvarchar	8	0
76	EEDMSETTLDOCSNDP	Settlement Document (Sent Profiles)	8	DATEFROM	From-Date	nvarchar	8	0
77	EEDMSETTLDOCUPDP	Settlement Document (Updated Profiles)	10	DATEFROM	From-Date	nvarchar	8	0
78	EEDMSETTLIN	Load Shapes Per Settlement Run	9	DATEFROM	From-Date	nvarchar	8	0
79	EEDMSETTLPARAMP	Settlement Paramter: Definition of Reference Profiles	5	DATEFROM	From-Date	nvarchar	8	0
80	EEDMSETTLPODCONS	Generated Consumption per Point of Delivery	5	DATEFROM	From-Date	nvarchar	8	0
81	EEDMSETTLUF	Usage Factors per Settlement Run	9	DATEFROM	From-Date	nvarchar	8	0
82	EEDMSETTLUNIT	Settlement Unit (Header Data)	3	DATEFROM	From-Date	nvarchar	8	0
83	EEDMSETTLUNITGEN	Settlement Unit: Generated Form	3	DATEFROM	From-Date	nvarchar	8	0
84	EEDMSETTLUNITH	Settlement Unit (Historical Data)	3	DATEFROM	From-Date	nvarchar	8	0
85	EEDMSYNPROFALLOC	Synthetic Profile: Allocation of Profiles	6	DATEFROM	From-Date	nvarchar	8	0
86	EFORMULAHIER	IS-U EDM Hierarchy Levels of Formula Instance (DB Table)	7	DATEFROM	From-Date	nvarchar	8	0
87	EFORMULAINSTPMI	ISU EDM Input Parameters for Formula Instance (DB Table)	7	DATEFROM	From-Date	nvarchar	8	0
88	EFORMULATRIGKMP	ISU EDM Compressed Trigger File for Formula Inst. (DB Table)	3	DATEFROM	From-Date	nvarchar	8	0
89	EFORMULATRIGTMP	ISU EDM Temporary Trigger File for Formula Inst. (DB Table)	4	DATEFROM	From-Date	nvarchar	8	0
90	EPROFASS	Allocation of Profiles	7	DATEFROM	From-Date	nvarchar	8	0
91	EPROFHEAD	Profile Header Data	16	DATEFROM	From-Date	nvarchar	8	0
92	EPROFHEAD_TMP	Header Data of Temporary Profile	16	DATEFROM	From-Date	nvarchar	8	0
93	EPROFVALSTAT	Profile Value Status	6	DATEFROM	From-Date	nvarchar	8	0
94	EPROFVALSTATHIST	History of Profile Value Status	7	DATEFROM	From-Date	nvarchar	8	0
95	EPROFVALSTAT_TMP	Status of Temporary Profile Values	6	DATEFROM	From-Date	nvarchar	8	0
96	EPROFVERSHEAD	Header Data for Profile Version	4	DATEFROM	From-Date	nvarchar	8	0
97	EPROFVERSSTAT	Status of Profile Version of Version	6	DATEFROM	From-Date	nvarchar	8	0
98	ERTPEXDAY_TO_INS	Allocation of Exception Agreement for Installation	5	DATEFROM	From-Date	nvarchar	8	0
99	ERTPIFACECOMPHIS	Components for RTP Interface (Historical Part)	4	DATEFROM	From-Date	nvarchar	8	0
100	ERTPIFACEINP	Allocation of Input Parameters for RTP Interface	6	DATEFROM	From-Date	nvarchar	8	0
101	ERTPIFACEINST	Activation of RTP Components for Individual Installations	7	DATEFROM	From-Date	nvarchar	8	0
102	ERTPIFACEINSTPAR	Allocation of Parameters to RTP Interface for Indiv. Insts	9	DATEFROM	From-Date	nvarchar	8	0
103	ESERVPROVHIST	Service Provider (Historical Data)	3	DATEFROM	From-Date	nvarchar	8	0
104	ESERVPROVSERVICE	Non-Billable Services (Service Types) for Service Provider	6	DATEFROM	From-Date	nvarchar	8	0
105	ESOURCEH	Source of Object (Historical Data)	5	DATEFROM	From-Date	nvarchar	8	0
TOPEnhanced Intercompany Data Exchange
106	/ISIDEX/ECANCON	Cancellation Conditions	4	DATEFROM	From-Date	nvarchar	8	0
TOPFlexible Real Estate Management
107	TIVXCITIBPARA	IB Stamp tax parameter	3	DATEFROM	Date: Valid From	nvarchar	8	0
108	TIVXCITIREVA	IRE Variables	2	DATEFROM	Date: Valid From	nvarchar	8	0
109	VIXCITICIDATA	ICI master data	3	DATEFROM	Date: Valid From	nvarchar	8	0
110	VIXCRAESRREFI	Assignment of ISR Ref./Cash Flow Plan (Item)	9	DATEFROM	Date: Valid From	nvarchar	8	0
TOPIntercompany Data Exchange
111	EDEREGPODGROUP	PoD Group	4	DATEFROM	Valid From	nvarchar	8	0
112	EDEREGSCENARIO	Supply Scenario	5	DATEFROM	From-Date	nvarchar	8	0
113	EDEREGSPAGREE	Service Provider Agreements	3	DATEFROM	From-Date	nvarchar	8	0
114	EDRGPODGRASSIGN	Allocation Criteria for PoD to PoD Group (Default)	5	DATEFROM	Valid From	nvarchar	8	0
115	EUIPODGROUP	Point of Delivery Group at PoD	5	DATEFROM	From-Date	nvarchar	8	0
116	TINV_INV_LOGHD	Log Table - HEAD - for Bill Receipt Processing	5	DATEFROM	Date	nvarchar	8	0
TOPInterest Calculation
117	T056I	Time-dep.terms for interest calc.rule	5	DATEFROM	Date from which the entry is valid	nvarchar	8	0
TOPLocalization
118	TIVXCPTRAPARAM	customizing parameters for the Rent adjustment	4	DATEFROM	Date: Valid From	nvarchar	8	0
119	VIXCFRBUDGET	Budget Seasonality Data	88	DATEFROM	Date: Valid From	nvarchar	8	0
120	VIXCFREO	Statuses of Extraordinary Operation	3	DATEFROM	Valid From	nvarchar	8	0
121	VIXCPTIMIDATA	IMI Master Data	3	DATEFROM	Valid from date	nvarchar	8	0
TOPMetadata Repository
122	RSDMASTTAB	Model Table: Attributes SID Table (Non-time-dependent)	4	DATEFROM	Valid-From Date	nvarchar	8	0
123	RSDMCHTTAB	Model Table: Master Data Table (Time-dependent)	4	DATEFROM	Valid-From Date	nvarchar	8	0
124	RSDMHSITABTHJ	Model Table: Conversion Hierarchy Nodes - SID (THJ)	5	DATEFROM	Query: Key date	nvarchar	8	0
125	RSDMSIDTABTHJ	Model Table: Master Data IDs of a Characteristic (THJ)	3	DATEFROM	Query: Key date	nvarchar	8	0
126	RSDMTXTTAB	Model table: Texts of a characteristic	4	DATEFROM	Valid-From Date	nvarchar	8	0
TOPOLAP Technology
127	RSRHIEDIR_TIMDEP	Time Intervals with Time-Dependent Hierarchies	2	DATEFROM	Valid-From Date	nvarchar	8	0
TOPPatient Management
128	NATM	IS-H/IS-H*MED: Time Slot Modification	7	DATEFROM	IS-H/IS-H*MED: Modification Start Date	nvarchar	8	0
TOPPersonalization Framework
129	FPB_PERSPARM	Personalization: User Settings	10	DATEFROM	Date	nvarchar	8	0
TOPPoint of delivery
130	EUIGRID	Allocation of PoD to Grid	5	DATEFROM	From-Date	nvarchar	8	0
131	EUIINSTLN	Allocation of Installation to PoD	6	DATEFROM	From-Date	nvarchar	8	0
132	EUILNR	Allocation of Logical Device to PoD	6	DATEFROM	From-Date	nvarchar	8	0
133	EUILZW	Allocation of Logical Register to PoD	6	DATEFROM	From-Date	nvarchar	8	0
134	EUITRANS	Transformation of Internal/External Point of Delivery No.	5	DATEFROM	From-Date	nvarchar	8	0
TOPPortal Content
135	ISTNLMALERTCA	Alert Category	4	DATEFROM	Validity Start for Alert Category	nvarchar	8	0
136	ISTNLMORDERAL	Orders with Triggered Alerts	4	DATEFROM	Alert Creation Date	nvarchar	8	0
TOPSAP Healthcare - Industry-Specific Components for Hospitals
137	TNWAT_EDI_FACDEF	IS-H AT: EDIVKA Korrekturenfaktoren und Nebenbedingungen	4	DATEFROM	IS-H AT: EDIVKA - Eintrag gültig ab Datum	nvarchar	8	0
138	TNWAT_EDI_KONDMP	IS-H AT: EDIVKA Konditionen zu Korrekturfakt./Nebenbeding.	5	DATEFROM	IS-H AT: EDIVKA - Eintrag gültig ab Datum	nvarchar	8	0
TOPSAP Utilities
139	EEXTSYNPROF	Conversion of External Synthetic Profile ID and Profile	5	DATEFROM	From-Date	nvarchar	8	0
TOPTime Zones
140	TTZDF	Summer time rules (fixed annual dates)	4	DATEFROM	Start of Daylight Saving Time: Date	nvarchar	8	0
TOPWithout Description
141	RSHIENODES	Hierarchy Node(s)	11	DATEFROM	Valid-From Date	nvarchar	8	0

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

141 columns | ERP 6.0 | DATEFROM