	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

135 columns | ERP 6.0 | MANDATORY

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/ATL/KPCC_STR	Request/Answer credit card interface file structures	8	MANDATORY	Flag field mandatory	nvarchar	1	0
2	/CPD/PWSC_CONATT	Contact Attribute	5	MANDATORY	Mandatory for Contact Attribute	nvarchar	1	0
3	/CPD/PWSC_GRATTR	Reporting Attribute Profile	6	MANDATORY	Mandatory Attribute	nvarchar	1	0
4	/FLDQ/AD_DUP_FLD	Fields to use during duplicate check, per data model	8	MANDATORY	True/False	nvarchar	1	0
5	/IAM/D_ACT_ROOT	Root	13	MANDATORY	Mandatory Activity Indicator	nvarchar	1	0
6	/SAPPSSRM/ATTR	Application data of Questionnaire	8	MANDATORY	Indicator: If an Attribute is a Required Entry Field	nvarchar	1	0
7	/SAPPSSRM/C_ATTR	Customizing data of Questionnaire	8	MANDATORY	Indicator: If an Attribute is a Required Entry Field	nvarchar	1	0
8	/SAPSRM/C_SRC_CR	Search Service: Criteria Customizing	7	MANDATORY	Search Criterion Mandatory Flag	nvarchar	1	0
9	BBP_DYNAT_MASTER	Master Data for Dynamic Attributes	8	MANDATORY	Indicator: If an Attribute is a Required Entry Field	nvarchar	1	0
10	BBP_PDDYN	Dynamic attributes	9	MANDATORY	Indicator: If an Attribute is a Required Entry Field	nvarchar	1	0
11	CNVCMIS_A_1_TABF	Selection of Object Type TABLE (TABF) Master information	11	MANDATORY	Flag: Field is required (not blank)	nvarchar	1	0
12	CNV_NCE_STEPS	Number conversion engine: steps and order	5	MANDATORY	NCE flag: step is mandatory	nvarchar	1	0
13	GRACEUPCONFIG	End User Personalization Fields	5	MANDATORY	Mandatory field for EUP	nvarchar	1	0
14	GRRMFH	Analysis: Forecasting Horizons	5	MANDATORY	Forecasting horizon: Mandatory input	nvarchar	1	0
15	HRHAPCN_FPROPS	Field Properties	11	MANDATORY	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')	nvarchar	1	0
16	IDSAU_CR_C_AS	Assign Certificate	5	MANDATORY	Mandatory Check for Certificate	nvarchar	1	0
17	J_1ICO_VENDDET	Columbia: Monthly data for freelancers/vendors	28	MANDATORY	Mandatory Contribution	nvarchar	1	0
18	T7UN_ESS_PROPS	NPO: Field Properties of Approver screen	7	MANDATORY	HR: Required Entry Field	nvarchar	1	0
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
19	DD03L	Table Fields	7	MANDATORY	Flag: Field is required (not blank)	nvarchar	1	0
TOPAdditional Material Functions
20	WSDT_MAT_LAYOUT	Customizing for Material Creation	6	MANDATORY	Required field within the Material Creation function	nvarchar	1	0
TOPAMI Event Management
21	TEAMIC_EM_EVTATR	Customizing Table for the link btw. attribute and event type	4	MANDATORY	Flag: Field is required (not blank)	nvarchar	1	0
TOPApplication Framework
22	MDG_MDF1004	Master Data Attributes of Predefined Fields	4	MANDATORY	Master Data: Required Entry	nvarchar	1	0
23	MDG_MDF1007	Master Data Attributes of Roles	4	MANDATORY	Master Data: Required Entry	nvarchar	1	0
24	MDG_MDF1011	Master Data Attributes at Hierarchy Edges	4	MANDATORY	Master Data: Required Entry	nvarchar	1	0
25	MDG_MDF1016	Master Data Attributes at Network Edges	4	MANDATORY	Master Data: Required Entry	nvarchar	1	0
26	MDG_MDFL1004	Attributes of Predefined Fields in Local Roles	4	MANDATORY	Master Data: Required Entry	nvarchar	1	0
27	MDG_MDFL1011	Attributes at Hierarchy Edges in Local Roles	4	MANDATORY	Master Data: Required Entry	nvarchar	1	0
28	MDG_MDFL1016	Master Data Attributes at Network Edges in Local Roles	4	MANDATORY	Master Data: Required Entry	nvarchar	1	0
TOPAppraisal, Valuation, and Survey Tool
29	HRHAP_P_APPER	Appraisal Document: Part Appraiser Assignment	15	MANDATORY	Flag: Mandatory Part Appraisers	nvarchar	1	0
TOPBilling in Contract Accounts Receivable and Payable
30	TFK8040	Allocation of Billing Fact Category to Billing Fact Check	3	MANDATORY	Billing Fact Check Is Required	nvarchar	1	0
31	TFK8045	Properties of Technical Properties of Billing Rules	3	MANDATORY	Technical Attribute of Billing Rule Is Required	nvarchar	1	0
TOPBusiness Objects, Common Components
32	EHFNDC_FC_NDP_AT	Field Control BO Node Profile: Attribute Property	8	MANDATORY	Field Control Is Mandatory	nvarchar	1	0
TOPBusiness Partner
33	RATCE_PROCEDURES	Rating Procedure	6	MANDATORY	Entries Required in All Fields for Rating Procedure	nvarchar	1	0
TOPCase Management
34	SCMGATTRPROFA	Case: Profile Attributes	7	MANDATORY	Case: Indicator for Required Attribute	nvarchar	1	0
TOPClassification System New
35	CME_ST_CHARATR	Characteristic: Global Attributes	12	MANDATORY	Mandatory	nvarchar	1	0
36	CME_ST_CHARATRH	Characteristic: Global Attributes	10	MANDATORY	Mandatory	nvarchar	1	0
TOPConfiguration Check Framework
37	DFIT_UNIT_PARAM	Parameters for Check Units	5	MANDATORY	Indicates whether config check parameter value is Mandatory	nvarchar	1	0
TOPCustomer Contact
38	BCONTAO	Allowed Contact Objects (obsolete as of 4.51)	6	MANDATORY	Mandatory Role	nvarchar	1	0
39	BCONTCAOR	Assignment of Object Roles to Contact Classes/Activity	5	MANDATORY	Mandatory Role	nvarchar	1	0
TOPData Mining
40	RSDMTPN_SRV_PAR	Parameters required for the services	6	MANDATORY	Parameter Mandatory	nvarchar	1	0
41	RSDMTP_SRV_PARAM	Parameters required for the services	7	MANDATORY	Parameter Mandatory	nvarchar	1	0
TOPData Replication Framework
42	DRFC_PARO	Outbound Implementation Parameters	3	MANDATORY	Mandatory Parameter for Outbound Implementation	nvarchar	1	0
TOPData Staging
43	RSISFIELDSH	Shadow table: InfoSource fields	6	MANDATORY	Flag: Required-entry field	nvarchar	1	0
44	RSISOFIELD	InfoSource fields (provider structure of a source system)	5	MANDATORY	Flag: Required-entry field	nvarchar	1	0
45	RSOLTPSOURCEFDSH	Shadow Table: OLTP Source Fields	5	MANDATORY	Flag: Required-entry field	nvarchar	1	0
46	RSOLTPSOURCEFIE	OLTP Source Fields	5	MANDATORY	Flag: Required-entry field	nvarchar	1	0
47	RSOLTPSOURCESFI	Segment Fields of a DataSource	6	MANDATORY	Flag: Required-entry field	nvarchar	1	0
48	RSOSATTFDSH	Shadow table: InfoSource attributes	6	MANDATORY	Flag: Required-entry field	nvarchar	1	0
49	RSOSFIELDSH	Shadow table: InfoSource fields	6	MANDATORY	Flag: Required-entry field	nvarchar	1	0
50	RSOSOATTFD	InfoSource attributes of a source system	5	MANDATORY	Flag: Required-entry field	nvarchar	1	0
51	RSTRFIELDSH	Shadow table: Transfer Structure Fields	5	MANDATORY	Flag: Required-entry field	nvarchar	1	0
52	RSTSFIELD	Transfer structure fields	15	MANDATORY	Flag: Required-entry field	nvarchar	1	0
53	RSTSFIELDSH	Shadow table: Transfer structure fields	5	MANDATORY	Flag: Required-entry field	nvarchar	1	0
54	RSUIFIELDS	Fields for Generated User Interfaces	8	MANDATORY	Flag: Field is required (not blank)	nvarchar	1	0
TOPDocument Management System
55	CVSE_APPL_DOKOB	Object assignments for each search application	4	MANDATORY	Structure with required fields for search engine	nvarchar	30	0
TOPE-Recruiting
56	HRP5129	DB Table for Infotype 5129	21	MANDATORY	Qualification is Mandatory	nvarchar	1	0
TOPEnd User Technology
57	RSDASSERVPAR	Service Parameter of the Data Access Service	8	MANDATORY	Parameter is Mandatory	nvarchar	1	0
58	RSKPI_ATTR_DEF	KPI Attribute: Header Data	4	MANDATORY	Boolean	nvarchar	1	0
59	RSKPI_KPI_IN	KPI: Input Parameters	7	MANDATORY	Parameter is Mandatory	nvarchar	1	0
60	RSRD_ATTR	Broadcasting Framework: Producer/Distributor Attributes	14	MANDATORY	Boolean	nvarchar	1	0
61	RSRRENDERERATR	Web Output Module Attributes	5	MANDATORY	Boolean	nvarchar	1	0
62	RSZWMDITEMPARAM	BW Web Metadata: Item Parameter association	6	MANDATORY	Boolean	nvarchar	1	0
63	RSZWMDPARAMNEST	BW Web Metadata: Parameter Containment	7	MANDATORY	Boolean	nvarchar	1	0
TOPEnvironment, Health and Safety
64	/TDAG/CPC_REP005	CP: Define attributes for element	18	MANDATORY	Mandatory	nvarchar	1	0
65	T7EHS00_QUESTQ	Individual Questions in Questionnaire	10	MANDATORY	Answer Required	nvarchar	1	0
TOPFinancials Basis
66	UGMD1004	FIN Master Data: Attributes of Predefined Fields	4	MANDATORY	FIN Master Data: Required Entry	nvarchar	1	0
67	UGMD1007	FIN Master Data: Attributes of Roles	4	MANDATORY	FIN Master Data: Required Entry	nvarchar	1	0
68	UGMD1011	FIN Master Data: Attributes at Hierarchy Edges	4	MANDATORY	FIN Master Data: Required Entry	nvarchar	1	0
69	UGMD1016	FIN Master Data: Attributes at Network Edges	4	MANDATORY	FIN Master Data: Required Entry	nvarchar	1	0
70	UGMDL1004	FIN Master Data: Local: Attributes of Predefined Fields	5	MANDATORY	FIN Master Data: Required Entry	nvarchar	1	0
71	UGMDL1011	FIN Master Data: Local Roles - Attributes at Hierarchy Edges	5	MANDATORY	FIN Master Data: Required Entry	nvarchar	1	0
72	UGMDL1016	FIN Master Data: Local Roles - Attributes at Network Links	5	MANDATORY	FIN Master Data: Required Entry	nvarchar	1	0
TOPFunds Management
73	FMRCN_MAPP_FIELD	Field mapping	4	MANDATORY	Field is mandatory	nvarchar	1	0
74	TBP4C	Select Budget Types for Subdivision	4	MANDATORY	Budget Subtype Mandatory	nvarchar	1	0
TOPGeneral
75	T588MFPROPC	HR: Field Properties	7	MANDATORY	HR: Required Entry Field	nvarchar	1	0
76	T588MFPROPS	HR: Field Properties	6	MANDATORY	HR: Required Entry Field	nvarchar	1	0
TOPGRC Risk Management
77	GRFNMWREG	Migration Registry	7	MANDATORY	Mandatory	nvarchar	1	0
TOPHandheld Connectivity
78	/DSD/PR_HEAD	MDSD Promotion - Promotion Header	15	MANDATORY	DSD Deal Conditions - Mandatory Flag	nvarchar	1	0
79	/DSD/PR_PCLN	MDSD Promotions - Promotion Precondition	9	MANDATORY	DSD Deal Conditions - Mandatory Flag	nvarchar	1	0
TOPIntegration of FPM and Persistency Frameworks like BOPF
80	/BOFU/IPBI_POWLS	POWL: Selection Parameters	8	MANDATORY	Mandatory?	nvarchar	1	0
TOPInterfaces
81	VXSITDL	Express Delivery Company: Meta Description Data Field	10	MANDATORY	Flag: Field is required (not blank)	nvarchar	1	0
TOPLoans Management
82	/FSIH/LINK	Table of Links Between Loan and Insurance Policy	6	MANDATORY	Force Placed Insurance	nvarchar	1	0
TOPMaintenance Processing
83	/MRSS/D_BAS_REQQ	Required Qualifications for Demands	11	MANDATORY	Requirement Is Mandatory	nvarchar	1	0
TOPMarketing Retail Network
84	OIFSCTSNDEFC	Screen Definition Customizing - Screen Configuration Tool	7	MANDATORY	Mandatory data screen	nvarchar	1	0
85	OIFSCTSNDEFS	Screen Definitions - Screen Configuration Tool	4	MANDATORY	Mandatory data screen	nvarchar	1	0
TOPMaterial Master
86	WER_ACT_SM_FLD_A	Action simple mapping target structure fields	12	MANDATORY	Indicates whether an element is mandatory (True or False)	nvarchar	1	0
87	WER_ACT_SM_FLD_S	Action simple mapping target structure fields	11	MANDATORY	Indicates whether an element is mandatory (True or False)	nvarchar	1	0
TOPMeasurement System
88	GHO_IMPTT_ITEM	Data Capture Items	8	MANDATORY	Mandatory	nvarchar	1	0
89	GHO_MEAS_GRPCR	Measurement Group Measurement	4	MANDATORY	Mandatory	nvarchar	1	0
TOPMusing Tools
90	WDKAPPNAVPAR	WDK: External navigation target parameters	7	MANDATORY	Mandatory	nvarchar	1	0
TOPObjective Setting and Appraisals
91	HRP5029	DB Table for Infotype 5029	18	MANDATORY	Cascading Goals: Goal Type	nvarchar	1	0
TOPOccupational Health
92	T7EHS00_PROT	Health Surveillance Protocols	11	MANDATORY	Mandatory Examination	nvarchar	1	0
TOPOLAP Technology
93	RSUNIURLIOBJ	URL->IObj	5	MANDATORY	Boolean	nvarchar	1	0
TOPOrganizational Management
94	T777IFPROPC	HRBAS: Infotype Field Properties	9	MANDATORY	Req. Entry	nvarchar	1	0
95	T777IFPROPS	HRBAS: Infotype Field Properties	8	MANDATORY	Req. Entry	nvarchar	1	0
TOPPeople Centric UI Framework
96	CRMC_LAYOUT	Layout table for structureedit element	17	MANDATORY	Mandatory Field	nvarchar	1	0
97	CRMC_LAYOUTC	Layout table for structureedit element	18	MANDATORY	Mandatory Field	nvarchar	1	0
TOPPeople Centric UI Framework Customizing
98	CRMC_FIELDGRP	Screen Structure Field Group Field	13	MANDATORY	Mandatory Field	nvarchar	1	0
99	CRMC_FIELDGRPC	Field Group (Cust.)	14	MANDATORY	Mandatory Field	nvarchar	1	0
TOPPersonal Object Worklist
100	POWL_SELCRIT_C	Cust table for powl selcrit	8	MANDATORY	X-Flag	nvarchar	1	0
TOPPortfolio Management
101	/RPM/QSTN_CUST	Question Customer Attributes	8	MANDATORY	Mandatory	nvarchar	1	0
TOPPublic Sector Contract Accounts Receivable and Payable
102	TFACT_SET_PART	Fact Set Parts	5	MANDATORY	Field Mandatory	nvarchar	1	0
103	TFACT_TYPE_PART	Fact Type Parts	5	MANDATORY	Field Mandatory	nvarchar	1	0
104	TFMCA_PT_LD_FMT	Format of Customizing Legal Description	5	MANDATORY	Legal Description is Required for Parcel	nvarchar	1	0
TOPRetention Warehouse
105	IWP_REPOS_BW	Available Tables for BW	7	MANDATORY	Table is mandatory	nvarchar	1	0
106	IWP_REPOS_BW_C	Available Tables for BW - Customer adoptions	7	MANDATORY	Table is mandatory	nvarchar	1	0
107	IWP_REPOS_BW_V	Available Views for BW	5	MANDATORY	Table is mandatory	nvarchar	1	0
108	IWP_REPOS_BW_V_C	Available Views for BW - Customer adoption	5	MANDATORY	Table is mandatory	nvarchar	1	0
TOPReusable Components of Business Suite Foundation
109	/BOBF/C_ATT_SCH1	Attachment Schema: Attachment Types	4	MANDATORY	Mandatory	nvarchar	1	0
110	/BOBF/C_TXCTTS	OBSOLETE - Assignment Text Type to Text Schema and Config.	4	MANDATORY	Mandatory Text	nvarchar	1	0
111	/BOBF/C_TXC_TS	OBSOLETE - Text Schema: Definition	4	MANDATORY		nvarchar	1	0
112	/BOFU/CFCNPRA	Field Control: Attribute Properties	9	MANDATORY	Mandatory?	nvarchar	1	0
113	/BOFU/C_TXCTTS	Assignment Text Type to Text Schema and Configuration	4	MANDATORY	Mandatory Text	nvarchar	1	0
114	/BOFU/C_TXC_TS	Text Schema: Definition	4	MANDATORY		nvarchar	1	0
115	/BOFU/S_TXCTTS	Assignment Text Type to Text Schema and Configuration	3	MANDATORY	Mandatory Text	nvarchar	1	0
116	/BOFU/S_TXC_TS	Default Text Schema Definition	3	MANDATORY		nvarchar	1	0
TOPSAP Expert Finder
117	T7XP_ELEM	Expert Profile Element	20	MANDATORY	Required Entry Indicator in Expert Profile	nvarchar	1	0
TOPSAP Internet Transaction Server
118	IACFL	Feature in ITS Plug-In	2	MANDATORY	Mandatory Availability	nvarchar	1	0
TOPSAP NetWeaver Mobile - Use subcomponents
119	MEREP_405	Mapping Result for Synchronization (BAPI)	8	MANDATORY	Mandatory	nvarchar	1	0
TOPService Data Download
120	/BDL/BDLFUVERS	Service Definition, Definition of all versions of a Logfun	25	MANDATORY	Sending of data essential for check?	nvarchar	1	0
121	BDLFUVERS	Definition of all Versions for one Logical Function	24	MANDATORY	Sending of data essential for check?	nvarchar	1	0
TOPTraining Management
122	LSOMETADATA	Supported Metadata	3	MANDATORY	Metadata Details Mandatory	nvarchar	1	0
TOPTravel Planning
123	TA23APIS		3	MANDATORY		nvarchar	1	0
124	TA23TVTTA_FIND	Grouping For Eligibility of Activity Types	3	MANDATORY	Flag: Activity is required	nvarchar	1	0
TOPUI Configuration Design Layer
125	BSP_DLC_DESIGN	Design layer: Design	6	MANDATORY	Mandatory	nvarchar	1	0
126	BSP_DLC_SDESIGN	Design layer: Design	5	MANDATORY	Mandatory	nvarchar	1	0
TOPWeb Application Builder
127	O2HTMLATTR	Attributes of HTML Tags	5	MANDATORY	Boolean	nvarchar	1	0
TOPWeb Services Tool
128	CRMC_WST_DESIGN	Open Services Tool: Design	6	MANDATORY	Mandatory	nvarchar	1	0
TOPWorkforce Management Application
129	WFAEM_FIELD	Fields that can appear on UI screens	3	MANDATORY	Must appear on screen flag	nvarchar	1	0
130	WFAEM_FIELD_A	UI screen group field attributes	5	MANDATORY	Must appear on screen flag	nvarchar	1	0
131	WFAEM_SCRNGRP	Screen groups for employee UI screens	2	MANDATORY	Must appear on screen flag	nvarchar	1	0
TOPWorkforce Management Core
132	/SAPAPO/LRPRQPRO	Qualifications Profile	11	MANDATORY	Indicator for an Optional Qualification Requirement	nvarchar	1	0
133	WFMEM_FIELD	Fields that can appear on UI screens	3	MANDATORY	Must appear on screen flag	nvarchar	1	0
134	WFMEM_FIELD_A	UI screen group field attributes	5	MANDATORY	Must appear on screen flag	nvarchar	1	0
135	WFMEM_SCRNGRP	Screen groups for employee UI screens	2	MANDATORY	Must appear on screen flag	nvarchar	1	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

135 columns | ERP 6.0 | MANDATORY