	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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

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

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

387 columns | ERP 6.0 | AENNR

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/SMD/MD_____00BL	SID-Tabelle fuer Change Number	3	AENNR	Change Number	nvarchar	12	0
2	/SMD/MD_____01DP	SID-Tabelle fuer Change Number	3	AENNR	Change Number	nvarchar	12	0
3	/SMERP/STG_PM006	Data staging - Equip List Set - Classifications - Cmplx Tab	18	AENNR	Change Number	nvarchar	12	0
4	/SMERP/STG_PM007	Data staging - Equip List Set - Char Values - complex table	26	AENNR	Change Number	nvarchar	12	0
5	/SMERP/STG_PM011	Data staging - Func Loc. LSet - Classifications - Cmplx Tab	18	AENNR	Change Number	nvarchar	12	0
6	/SMERP/STG_PM012	Data staging - Func Loc LSet - Char Values - complex table	26	AENNR	Change Number	nvarchar	12	0
7	AUSP_CONV	Characteristic Values	19	AENNR	Change Number	nvarchar	12	0
8	EHPRCD_DEC_DE	Obsolete	6	AENNR	Change Number	nvarchar	12	0
9	EHPRCD_DEC_IN	Obsolete	6	AENNR	Change Number	nvarchar	12	0
10	KSSK_CONV	Allocation Table: Object to Class	11	AENNR	Change Number	nvarchar	12	0
11	ZXFT_LS_CHMT01	Change Request Properties	4	AENNR	Change Number	nvarchar	12	0
TOPBasic Data
12	MKAL_AEND	Change History of Production Version (Recipes Only)	6	AENNR	Change Number	nvarchar	12	0
TOPBills of Material
13	STAS	BOMs - Item Selection	9	AENNR	Change Number	nvarchar	12	0
14	STKO	BOM Header	8	AENNR	Change Number	nvarchar	12	0
15	STPO	BOM item	8	AENNR	Change Number	nvarchar	12	0
TOPCAD Integration
16	CDESK_IPPE_RTYPE	CAD-Specific Relationship Type	3	AENNR	Change Number	nvarchar	12	0
TOPCharacteristics
17	CABN	Characteristic	50	AENNR	Change Number	nvarchar	12	0
18	CABNNEW	Characteristic	50	AENNR	Change Number	nvarchar	12	0
19	CABNT	Characteristic Descriptions	10	AENNR	Change Number	nvarchar	12	0
20	CAWN	Characteristic values	17	AENNR	Change Number	nvarchar	12	0
21	CAWNT	Value Texts	9	AENNR	Change Number	nvarchar	12	0
TOPClasses
22	AUSP	Characteristic Values	19	AENNR	Change Number	nvarchar	12	0
23	CLAENNR	Change number-to-class alloc.: classification effectivity	4	AENNR	Change Number	nvarchar	12	0
24	KSML	Characteristics of a Class	14	AENNR	Change Number	nvarchar	12	0
25	KSSK	Allocation Table: Object to Class	11	AENNR	Change Number	nvarchar	12	0
TOPClinical System
26	N2DRAWA	Document Info Record	9	AENNR	Change Number	nvarchar	12	0
TOPCompliance Check
27	EHSBT_RC_ESTRHSH	EHS: Table f. Storing Substs w. Constraints in Shared Memory	9	AENNR	Change Number	nvarchar	12	0
TOPComputer Aided Process Planning
28	PLPH	CAPP: Sub-operations	9	AENNR	Change Number	nvarchar	12	0
TOPConfiguration management
29	IBINCM	IB: Config.Mang.: Component/Instance	5	AENNR	Change Number	nvarchar	12	0
30	IBSPCM	IB: Config.Mang.: Specialization	5	AENNR	Change Number	nvarchar	12	0
31	IBSTCM	IB: Conf.Mang.:Structure	5	AENNR	Change Number	nvarchar	12	0
32	TCM_BASELINE	Baseline data (Configuration Management)	22	AENNR	Change Number	nvarchar	12	0
33	TCM_PF_CONT	Table for data container for product folder (Conf. Mgmt)	15	AENNR	Change Number	nvarchar	12	0
TOPCross-Application Component CA Enhancements
34	MILL_CLPROFP	Profile for Selection by Characteristics: Items	30	AENNR	Change Number	nvarchar	12	0
TOPCross-Application Components
35	MMAPL	Allocation of task lists to materials	11	AENNR	Change Number	nvarchar	12	0
36	PDS_OPER	PDS Data for Operations and Dependent Data	16	AENNR	Change Number	nvarchar	12	0
37	PLLPO	Task list - operation/activity	8	AENNR	Change Number	nvarchar	12	0
TOPDemand Management
38	TPHVP	Header: Planning Profile	9	AENNR	Change Number	nvarchar	12	0
39	TPLVP	Planning Profile	7	AENNR	Change Number	nvarchar	12	0
40	TPSVP	Planning profile lines	10	AENNR	Change Number	nvarchar	12	0
TOPDigital Signature
41	TC72	Digital Signature for Engineering Change Order	6	AENNR	Change Number	nvarchar	12	0
42	TC76	Digital Signature for Object Management Record	4	AENNR	Change Number	nvarchar	12	0
TOPDistribution Requirements Planning
43	PLPLAN_PARAM	BOM-dependent planning parameter	6	AENNR	Change Number	nvarchar	12	0
TOPDocument Management System
44	DRAW	Document Info Record	9	AENNR	Change Number	nvarchar	12	0
TOPEngineering Change Management
45	AEDT	Engineering Change Management: Alternative Dates	2	AENNR	Change Number	nvarchar	12	0
46	AEEF	ECM: effectivity	2	AENNR	Change Number	nvarchar	12	0
47	AENR	Change Master	2	AENNR	Change Number	nvarchar	12	0
48	AENV	ECH: Object Types for Change Master	2	AENNR	Change Number	nvarchar	12	0
49	AEOI	ECH: Object Management Records for Change Master	2	AENNR	Change Number	nvarchar	12	0
50	AEPF	ECM: effectivity	2	AENNR	Change Number	nvarchar	12	0
51	AEPLST	Identical object in explosion (item)	3	AENNR	Change Number	nvarchar	12	0
52	COMM_IL_ECMCHG	Engineering Change Management: Change Graph	10	AENNR	Change Order	nvarchar	12	0
53	ECM_GROUP	Group Assignment for Change Number	4	AENNR	Change Order	nvarchar	12	0
54	ECM_ORD	Change Order	3	AENNR	Change Order	nvarchar	12	0
55	ECM_REQ	Data for Engineering Change Request	3	AENNR	Change Order	nvarchar	12	0
56	ECM_TSK	Change Task	3	AENNR	Change Order	nvarchar	12	0
57	ENODE	Nodes ECH	3	AENNR	Change Number	nvarchar	12	0
58	TECN	Effectivity object: change numbers	4	AENNR	Change Number	nvarchar	12	0
TOPEngineering Configuration Order BOM
59	CUOBOM_CHANGE	Manually Changed Items in the Order BOM	10	AENNR	Change Number	nvarchar	12	0
TOPEnvironment
60	LCABN	Characteristic	50	AENNR	Change Number	nvarchar	12	0
61	LCABNT	Characteristic descriptions	10	AENNR	Change Number	nvarchar	12	0
62	LKSML	Characteristics of a Class	14	AENNR	Change Number	nvarchar	12	0
63	LKSSK	Allocation Table: Object to Class	11	AENNR	Change Number	nvarchar	12	0
TOPEnvironment, Health and Safety
64	/TDAG/CPT_CHKENT	CP: Check entries	6	AENNR	Change Number	nvarchar	12	0
65	/TDAG/CPT_DECSUB	CP: Declarable Substances	6	AENNR	Change Number	nvarchar	12	0
66	/TDAG/CPT_DEC_DE	CP: Declarable Substances, Dependent attributes	6	AENNR	Change Number	nvarchar	12	0
67	/TDAG/CPT_DEC_IN	CP: Declarable Substances, Independent attributes	6	AENNR	Change Number	nvarchar	12	0
68	/TDAG/CPT_ESTMJ	EHS: Substance - material - allocation	6	AENNR	Change Number	nvarchar	12	0
69	/TDAG/CPT_HISENT	CP: Worklist entries for Compliance History	6	AENNR	Change Number	nvarchar	12	0
70	/TDAG/CPT_IMDENT	CP: IMDS entries	6	AENNR	Change Number	nvarchar	12	0
71	/TDAG/CPT_REAENT	CP: Reach entries	6	AENNR	Change Number	nvarchar	12	0
72	/TDAG/CPT_REVENT	CP: Revision entries	6	AENNR	Change Number	nvarchar	12	0
73	DGTPK	DG: Packing Requirement	6	AENNR	Change Number	nvarchar	12	0
74	EHQMT_BASIC_DATA	EH&S-QM: Basic Data for Inspection Plans	7	AENNR	Change Number	nvarchar	12	0
75	EHQMT_MAIN1	EH&S-QM: Subs. Value Assignmt Types for Insp. Plan Creation	6	AENNR	Change Number	nvarchar	12	0
76	EHQMT_MAIN2	EH&S-QM: Characteristics for Inspection Plan Creation	6	AENNR	Change Number	nvarchar	12	0
77	EHSBT_APPL_SCOPE	EHS: General Scope of Application	6	AENNR	Change Number	nvarchar	12	0
TOPEnvironment, Health and Safety Master Data
78	CCDUTCARR	Provisions for Carriage	6	AENNR	Change Number	nvarchar	12	0
79	CCDUTDGREL	Product Release	6	AENNR	Change Number	nvarchar	12	0
80	CCDUTPACK	Packaging Code Approvals	6	AENNR	Change Number	nvarchar	12	0
81	CCDUTSPROV	Special Provisions	6	AENNR	Change Number	nvarchar	12	0
82	CCDUTTRAPPR	Transport Restrictions	6	AENNR	Change Number	nvarchar	12	0
83	DGTMD	DG: Dangerous Goods Master	6	AENNR	Change Number	nvarchar	12	0
84	ESTPH	EHS: Phrase Header	6	AENNR	Change Number	nvarchar	12	0
85	ESTPJ	EHS: Phrase set - phrase header assignment	6	AENNR	Change Number	nvarchar	12	0
86	ESTPO	EHS: Original Phrase	6	AENNR	Change Number	nvarchar	12	0
87	ESTPP	EHS: Phrase Item	6	AENNR	Change Number	nvarchar	12	0
88	ESTPS	EHS: Phrase Set	6	AENNR	Change Number	nvarchar	12	0
89	ESTPT	EHS: Language-Dependent Description for Phrase Sets	6	AENNR	Change Number	nvarchar	12	0
90	HSMT_DN	EHS: Hazardous Substance Addit. Data 2 (Numeric Type)	6	AENNR	Change Number	nvarchar	12	0
91	HSMT_DT	EHS: Hazardous Substance Addit. Data 1 (Text Type)	6	AENNR	Change Number	nvarchar	12	0
92	HSMT_MD	EHS: Hazardous Substance Basic Data	6	AENNR	Change Number	nvarchar	12	0
TOPFlow Manufacturing
93	LDLBH	Line balance/planned rate header record	13	AENNR	Change Number	nvarchar	12	0
TOPIndustrial Hygiene and Safety
94	CCIHT_ACH	EHS: Safety Measures - Header	6	AENNR	Change Number	nvarchar	12	0
95	CCIHT_AD08	EHS: Customer Analysis Method 08 Detail Data	6	AENNR	Change Number	nvarchar	12	0
96	CCIHT_AD09	EHS: Customer Analysis Method 09 Detail Data	6	AENNR	Change Number	nvarchar	12	0
97	CCIHT_AD10	EHS: Customer Analysis Method 10 Detail Data	6	AENNR	Change Number	nvarchar	12	0
98	CCIHT_AM01	EHS: Customer Analysis Method 01	6	AENNR	Change Number	nvarchar	12	0
99	CCIHT_AM02	EHS: Customer Analysis Method 02	6	AENNR	Change Number	nvarchar	12	0
100	CCIHT_AM03	EHS: Customer Analysis Method 03	6	AENNR	Change Number	nvarchar	12	0
101	CCIHT_AM04	EHS: Customer Analysis Method 04	6	AENNR	Change Number	nvarchar	12	0
102	CCIHT_AM05	EHS: Customer Analysis Method 05	6	AENNR	Change Number	nvarchar	12	0
103	CCIHT_AM06	EHS: Customer Analysis Method 06	6	AENNR	Change Number	nvarchar	12	0
104	CCIHT_AM07	EHS: Customer Analysis Method 07	6	AENNR	Change Number	nvarchar	12	0
105	CCIHT_AM08	EHS: Customer Analysis Method 08	6	AENNR	Change Number	nvarchar	12	0
106	CCIHT_AM09	EHS: Customer Analysis Method 09	6	AENNR	Change Number	nvarchar	12	0
107	CCIHT_AM10	EHS: Customer Analysis Method 10	6	AENNR	Change Number	nvarchar	12	0
108	CCIHT_ANML	EHS: Analysis Method - Meas. Value - Ref. Value Comparison	6	AENNR	Change Number	nvarchar	12	0
109	CCIHT_ANNC	EHS: Analysis Method - Standardized Criteria	6	AENNR	Change Number	nvarchar	12	0
110	CCIHT_ANQS	EHS: Analysis Method Questionnaire	6	AENNR	Change Number	nvarchar	12	0
111	CCIHT_ANQSREL	EHS: Analysis Method Questionnaire - Relevant Questions	6	AENNR	Change Number	nvarchar	12	0
112	CCIHT_ANSC	EHS: Analysis Method - Summated Rating (Header)	6	AENNR	Change Number	nvarchar	12	0
113	CCIHT_ANSE	EHS: Analysis Method - Summated Rating (Details)	6	AENNR	Change Number	nvarchar	12	0
114	CCIHT_EPI	EHS: Exposure Profile Entry	6	AENNR	Change Number	nvarchar	12	0
115	CCIHT_ERAI	EHS: Exposure Log - Additional Information	6	AENNR	Change Number	nvarchar	12	0
116	CCIHT_ERH	EHS: Risk Assessment - Header	6	AENNR	Change Number	nvarchar	12	0
117	CCIHT_ERQT	EHS: Exposure Assignment - Exposure Amounts	6	AENNR	Change Number	nvarchar	12	0
118	CCIHT_ERRA	EHS: - Obsolete - Exposure Assignment - Risk Assessment	6	AENNR	Change Number	nvarchar	12	0
119	CCIHT_FAL	EHS: Injury/Illness Log	6	AENNR	Change Number	nvarchar	12	0
120	CCIHT_FALMA	EHS: Medical Measures	6	AENNR	Change Number	nvarchar	12	0
121	CCIHT_FAVA	EHS: Obsolete - Inj./Illn. Log Addit. Info. (Classif. Sys.)	6	AENNR	Change Number	nvarchar	12	0
122	CCIHT_IAL	EHS: Incident/Accident Log - Header	6	AENNR	Change Number	nvarchar	12	0
123	CCIHT_IAVA	EHS: Obsolete - Inc./Acc. Log - Addit. Info. (Classif. Sys.)	6	AENNR	Change Number	nvarchar	12	0
124	CCIHT_IHVA	EHS: Value Assignment Data Records for Classific. System	6	AENNR	Change Number	nvarchar	12	0
125	CCIHT_IP	EHS: List of Persons Involved	6	AENNR	Change Number	nvarchar	12	0
126	CCIHT_IPABSS	EHS: Incident/Accident Log - Absences for Person Affected	6	AENNR	Change Number	nvarchar	12	0
127	CCIHT_IPEVA	EHS: Inc./Acc. Log - Data for Person Affected (Event)	6	AENNR	Change Number	nvarchar	12	0
128	CCIHT_IPEVALIM	EHS: Incident/Accident Log - Link Accident to Restrictions	6	AENNR	Change Number	nvarchar	12	0
129	CCIHT_IPEVINJ	EHS: Injuries to Person Affected	6	AENNR	Change Number	nvarchar	12	0
130	CCIHT_IPVA	EHS: Obsolete -IAL, Person Aff. - Addit. Info. (Class. Sys.)	6	AENNR	Change Number	nvarchar	12	0
131	CCIHT_MJ	EHS: Measurement	6	AENNR	Change Number	nvarchar	12	0
132	CCIHT_MJIMPORT	EHS: Pooled Table for Imported Measurements	6	AENNR	Change Number	nvarchar	12	0
133	CCIHT_MJVA	EHS: Measured Values	6	AENNR	Change Number	nvarchar	12	0
134	CCIHT_MJVAIMP	EHS: Imported Measured Values	6	AENNR	Change Number	nvarchar	12	0
135	CCIHT_MJVAQT	EHS: Table Temporary Data from Measured Values to Amounts	6	AENNR	Change Number	nvarchar	12	0
136	CCIHT_MJWA	EHS: Assignment of Work Area to Measurement Job	6	AENNR	Change Number	nvarchar	12	0
137	CCIHT_MP	EHS: Measurement Project	6	AENNR	Change Number	nvarchar	12	0
138	CCIHT_MPDV	EHS: Devices Required for Measurement Project	6	AENNR	Change Number	nvarchar	12	0
139	CCIHT_MPMT	EHS: Measurement Plan - Measurement Method	6	AENNR	Change Number	nvarchar	12	0
140	CCIHT_MPPL	EHS: Project Plan	6	AENNR	Change Number	nvarchar	12	0
141	CCIHT_MPWA	EHS: Assignment of Work Area to Measurement Project	6	AENNR	Change Number	nvarchar	12	0
142	CCIHT_PTCP	EHS: Pattern to Collective Pattern Assignment	6	AENNR	Change Number	nvarchar	12	0
143	CCIHT_RC	EHS: Accident Causes (Root Causes)	6	AENNR	Change Number	nvarchar	12	0
144	CCIHT_RFMJ	EHS: Reference Measurement	6	AENNR	Change Number	nvarchar	12	0
145	CCIHT_WAA	EHS: Accident Location	6	AENNR	Change Number	nvarchar	12	0
146	CCIHT_WAAD	EHS: Language-Dependent Description of Accident Location	6	AENNR	Change Number	nvarchar	12	0
147	CCIHT_WADO	EHS: Work Area - Links to Info Objects	6	AENNR	Change Number	nvarchar	12	0
148	CCIHT_WAH	EHS: Work Area - Header	6	AENNR	Change Number	nvarchar	12	0
149	CCIHT_WAIH	EHS: Work Area - Industrial Hygiene and Safety Data	6	AENNR	Change Number	nvarchar	12	0
150	CCIHT_WALD	EHS: Language-Dependent Name and Descr. of Work Area	6	AENNR	Change Number	nvarchar	12	0
151	CCIHT_WAPT	EHS: Assignment of Template to Work Area	6	AENNR	Change Number	nvarchar	12	0
152	CCIHT_WAQS	EHS: Work Area - Specific Questionnaire Assignment	6	AENNR	Change Number	nvarchar	12	0
TOPInstalled Base
153	IBIN	IB: IBase Components - Condition	5	AENNR	Change Number	nvarchar	12	0
154	IBSP	IB: Installed Base Component - Enhancement/Specialization	5	AENNR	Change Number	nvarchar	12	0
155	IBST	IB: Installation Component - Structure	5	AENNR	Change Number	nvarchar	12	0
TOPIntegrated Product and Process Engineering
156	CMIG_MAPPING	Mapping Table (Classic PP and iPPE Objekt Key)	18	AENNR	Change Number	nvarchar	12	0
157	INSTHIST	Geometric Instance: History Management	4	AENNR	Change Number in iPPE	nvarchar	12	0
158	PAMODD	Duration of an Activity-Resource Relationship	5	AENNR	Change Number in iPPE	nvarchar	12	0
159	PATST	Test Alternative: Attribute Table	4	AENNR	Change Number in iPPE	nvarchar	12	0
160	PNGEN	Generic Engineering Node: Attribute Table	4	AENNR	Change Number in iPPE	nvarchar	12	0
161	PNTST	Test Node: Attribute Table	4	AENNR	Change Number in iPPE	nvarchar	12	0
162	PPECIF_LOGOBJ	iPPE/CIF: Different Objects	5	AENNR	Change Number in iPPE	nvarchar	12	0
163	PPECPROOBJLNK	iPPE Assignment Table: Object Links with cProjects	12	AENNR	Change Number in iPPE	nvarchar	12	0
164	PPESCMPV	iPPE Status, BOM-Specific Data	5	AENNR	Change Number in iPPE	nvarchar	12	0
165	PRELACT	Relationships for the SNP and Workshop Plan	5	AENNR	Change Number in iPPE	nvarchar	12	0
166	PRELIDH	iPPE Relationship: Additional Table for Effectivity (ECH)	4	AENNR	Change Number in iPPE	nvarchar	12	0
167	PRGEN	GEN Relationships - Relationships Table	5	AENNR	Change Number in iPPE	nvarchar	12	0
168	PROJID	iPPE Assignment Table: PS Objects	6	AENNR	Change Number	nvarchar	12	0
169	PRPVR	Relationship Between Variants: Identification and Attributes	4	AENNR	Change Number in iPPE	nvarchar	12	0
170	PRSET	Set Relationships: Table of Links	4	AENNR	Change Number in iPPE	nvarchar	12	0
171	PRTST	Test Relationships - Relationships Table	5	AENNR	Change Number in iPPE	nvarchar	12	0
172	PVCMP	PVS Variant (CMP): History Management	8	AENNR	Change Number in iPPE	nvarchar	12	0
173	PVCMPH	Obsolete: Replaced by PVCMP	3	AENNR	Change Number	nvarchar	12	0
174	PVCOL	PVS Variant (COL): Color Attributes	4	AENNR	Change Number in iPPE	nvarchar	12	0
175	PVCONA	iPPE Concept: Activations	5	AENNR	Change Number in iPPE	nvarchar	12	0
176	PVSCSQ	Change Sequence in the PVS	2	AENNR	Change Number in iPPE	nvarchar	12	0
177	PVS_VSHEME	Variance Scheme for Structure Node	7	AENNR	Change Number in iPPE	nvarchar	12	0
178	PVTST	Test Variant: Attribute Table	4	AENNR	Change Number in iPPE	nvarchar	12	0
179	PXARCID	Table for Archiving Indicators for iPPE Objects	4	AENNR	Change Number in iPPE	nvarchar	12	0
TOPInventory Management
180	RESB	Reservation/dependent requirements	73	AENNR	Change Number	nvarchar	12	0
TOPMaintenance Program Definition
181	MPDPSD	MPD: MPD and MP header data	7	AENNR	Change Number	nvarchar	12	0
TOPMaintenance Task Lists
182	EAPL	Allocation of task lists to pieces of equipment	12	AENNR	Change Number	nvarchar	12	0
183	PLWP	Allocation of maintenance packages to task list operations	16	AENNR	Change Number	nvarchar	12	0
184	TAPL	Allocation of task lists to functional locations	13	AENNR	Change Number	nvarchar	12	0
TOPMaster Data
185	MDSM	Simulative dependent requirements	73	AENNR	Change Number	nvarchar	12	0
186	PLAF	Planned Order	44	AENNR	Change Number	nvarchar	12	0
TOPMaster Data Distribution
187	/ISDFPS/TL1	Task List - Operation/Activity	8	AENNR	Change Number	nvarchar	12	0
TOPMaster Recipe
188	PLFT	Process Instructions	10	AENNR	Change Number	nvarchar	12	0
189	PLFV	PI Characteristics/Sub-Operation Parameter Values	11	AENNR	Change Number	nvarchar	12	0
TOPMaterial Master
190	MARA_TMP	File for Incorrect Data in Direct Input	9	AENNR	Change Number	nvarchar	12	0
TOPNetwork and Activity
191	AFAB	Network - Relationships	31	AENNR	Change Number	nvarchar	12	0
192	MLST	Milestone	6	AENNR	Change Number	nvarchar	12	0
193	PLAB	Relationships	14	AENNR	Change Number	nvarchar	12	0
TOPObject Dependencies
194	CUCVRNT	Variants of Constraints	8	AENNR	Change Number	nvarchar	12	0
195	CUEX	Dependency Storage - Compilation	8	AENNR	Change Number	nvarchar	12	0
196	CUKB	Administrative Information for Dependency Maintenance	19	AENNR	Change Number	nvarchar	12	0
197	CUKBT	Text Table for Dependency Maintenance Admin. Information	8	AENNR	Change Number	nvarchar	12	0
198	CUKN	Dependency Storage - Variants/Configuration	6	AENNR	Change Number	nvarchar	12	0
199	CUOB	Assignment of Object to Dependency	7	AENNR	Change Number	nvarchar	12	0
200	CURSADD	Dependency Net Additional Data	9	AENNR	Change Number	nvarchar	12	0
201	CURSVAR	Internal Variables of Constraints	14	AENNR	Change Number	nvarchar	12	0
202	CUXREF	Object Dependency Cross References	10	AENNR	Change Number	nvarchar	12	0
TOPOccupational Health
203	T7EHS00_CAL_FAV	EHS: Medical Practice Calendar Favorites	4	AENNR	Change Number	nvarchar	12	0
204	T7EHS00_CAL_PHYS	Assgmt of MP Calendar Owner to Physician for Service Appt	6	AENNR	Change Number	nvarchar	12	0
205	T7EHS00_EXAM	Examinations	17	AENNR	Change Number	nvarchar	12	0
206	T7EHS00_EXAMLAB	Assignments of Examination to Lab. Tests	10	AENNR	Change Number	nvarchar	12	0
207	T7EHS00_EXAMPHY	Assignments of Examination to Physical Tests	10	AENNR	Change Number	nvarchar	12	0
208	T7EHS00_EXAMT	Examinations (Text Table)	9	AENNR	Change Number	nvarchar	12	0
209	T7EHS00_LABTEST	Tests for Laboratory Examinations	14	AENNR	Change Number	nvarchar	12	0
210	T7EHS00_LABTESTT	Possible Tests for Laboratory Examinations	8	AENNR	Change Number	nvarchar	12	0
211	T7EHS00_PERPRSCD	Enter Validity of Protocol with Respect to Person	8	AENNR	Change Number	nvarchar	12	0
212	T7EHS00_PHYTEST	Tests for Physical Examinations	11	AENNR	Change Number	nvarchar	12	0
213	T7EHS00_PHYTESTT	Possible Tests for Physical Examinations	8	AENNR	Change Number	nvarchar	12	0
214	T7EHS00_PREGANA	Table for Comment Field: Protocol_Regulation-analysis_text	11	AENNR	Change Number	nvarchar	12	0
215	T7EHS00_PREGDES	Table for Comment Field: Protocol_Regulation-description	11	AENNR	Change Number	nvarchar	12	0
216	T7EHS00_PREGFOL	Table for Comment Field: Protocol_Regulation-follow_up	11	AENNR	Change Number	nvarchar	12	0
217	T7EHS00_PREGPRO	Table for Comment Field: Protocol_Regulation-procedure_text	11	AENNR	Change Number	nvarchar	12	0
218	T7EHS00_PROT	Health Surveillance Protocols	35	AENNR	Change Number	nvarchar	12	0
219	T7EHS00_PROTAGNT	Agents for Protocol	13	AENNR	Change Number	nvarchar	12	0
220	T7EHS00_PROTEXAM	Examinations for Protocol	13	AENNR	Change Number	nvarchar	12	0
221	T7EHS00_PROTFREQ	Frequency of Protocol	13	AENNR	Change Number	nvarchar	12	0
222	T7EHS00_PROTMEM	Table for Comment Field: Protocol Description	9	AENNR	Change Number	nvarchar	12	0
223	T7EHS00_PROTREG	Regulations for Protocol	18	AENNR	Change Number	nvarchar	12	0
224	T7EHS00_PROTT	Protocol Text Table	9	AENNR	Change Number	nvarchar	12	0
225	T7EHS00_VACCH	EHS: Vaccination Data Header Information	6	AENNR	Change Number	nvarchar	12	0
TOPOperative Structures
226	PRPS	WBS (Work Breakdown Structure) Element Master Data	75	AENNR	Change Number	nvarchar	12	0
TOPProcess Order
227	AFFT	Order - Process Instructions	18	AENNR	Change Number	nvarchar	12	0
228	AFFV	Order - Process Instruction Values	26	AENNR	Change Number	nvarchar	12	0
TOPProduct Data Management
229	CONV_FILE	Clipboard for Objects to Convert	22	AENNR	Change Number	nvarchar	12	0
230	EXPO_ECN_DB	List of Change Numbers (Configuration Management)	4	AENNR	Change Number	nvarchar	12	0
TOPProduct Safety
231	CCGLT_LSDE	EHS: Label Stock - Language-Dependent Descriptions	6	AENNR	Change Number	nvarchar	12	0
232	CCGLT_LSHD	EHS: Label Stock Header Table	6	AENNR	Change Number	nvarchar	12	0
233	CCGLT_LSLT	EHS: Label Stock - Assigned Label Categories	6	AENNR	Change Number	nvarchar	12	0
234	CCGLT_LSRV	EHS: Label Stock - Assigned Validity Area	6	AENNR	Change Number	nvarchar	12	0
235	CCGLT_LSTG	EHS: Label Stock - Assigned Transport Symbol Groups	6	AENNR	Change Number	nvarchar	12	0
236	CCUNTCARR	Provisions for Carriage	6	AENNR	Change Number	nvarchar	12	0
237	CCUNTPACK	Packing Requirements	6	AENNR	Change Number	nvarchar	12	0
238	CCUNTSPROV	Special Packing Provisions	6	AENNR	Change Number	nvarchar	12	0
239	CVDDCS	EHS: Control Structure (Report Shipping)	6	AENNR	Change Number	nvarchar	12	0
240	CVDDCSP	EHS: Control Structure Parameters (Report Shipping)	6	AENNR	Change Number	nvarchar	12	0
241	CVDDH	EHS: Report shipping orders	6	AENNR	Change Number	nvarchar	12	0
242	CVDDP	EHS: Parameter Values for Report Shipping	6	AENNR	Change Number	nvarchar	12	0
243	EHSBT_REL02	EHS: Control Table for Local Overwrite of Inheritance	3	AENNR	Change Number	nvarchar	12	0
244	EST07	EHS: Dangerous Goods Management - Transport Approval	6	AENNR	Change Number	nvarchar	12	0
245	EST0B	EHS: Dangerous Goods Management - Packaging Code Approval	6	AENNR	Change Number	nvarchar	12	0
246	EST0D	EHS: Dangerous Goods Management - Risk Classification	6	AENNR	Change Number	nvarchar	12	0
247	EST0F	EHS: Dangerous Goods Management - Transport Classification	6	AENNR	Change Number	nvarchar	12	0
248	ESTDCS	EHS: Control Structure (Report Body)	6	AENNR	Change Number	nvarchar	12	0
249	ESTDCSP	EHS: Parameter Control Structure	6	AENNR	Change Number	nvarchar	12	0
250	ESTDF	Additional Information - User-Defined Text	6	AENNR	Change Number	nvarchar	12	0
251	ESTDH	EHS: Report Header	6	AENNR	Change Number	nvarchar	12	0
252	ESTDJ	EHS: Assignment of Specifications to Reports	6	AENNR	Change Number	nvarchar	12	0
253	ESTDO	EHS: Report application objects	6	AENNR	Change Number	nvarchar	12	0
254	ESTDR	EHS: Additional Information: Value Assignment Assessment	6	AENNR	Change Number	nvarchar	12	0
255	ESTDS	EHS: Additional Information: Value Assignment Source	6	AENNR	Change Number	nvarchar	12	0
256	ESTDSCS	EHS: eSDS Control Structure	6	AENNR	Change Number	nvarchar	12	0
257	ESTDU	EHS: Additional Information: Value Assignment Usage	6	AENNR	Change Number	nvarchar	12	0
258	ESTLN	EHS: Language-Dependent Description for Report Template	6	AENNR	Change Number	nvarchar	12	0
259	ESTLP	EHS: Report Variant	6	AENNR	Change Number	nvarchar	12	0
260	ESTLR	EHS: Language-Dependent Description of Report Variant	6	AENNR	Change Number	nvarchar	12	0
261	ESTLU	EHS: Report Variant Rating	6	AENNR	Change Number	nvarchar	12	0
262	ESTLV	EHS: Report Variant Language (Labels Only)	6	AENNR	Change Number	nvarchar	12	0
263	ESTMJ	EHS: Specification-Material Assignment	6	AENNR	Change Number	nvarchar	12	0
264	ESTOH	EHS: WWI generation / print jobs	6	AENNR	Change Number	nvarchar	12	0
265	ESTRH	EHS: Specification Header	6	AENNR	Change Number	nvarchar	12	0
266	ESTRI	EHS: Identifier (Numbers, Names, Chemical Formulas)	6	AENNR	Change Number	nvarchar	12	0
267	ESTRL	EHS: Identifier - Regulatory List Assignment	6	AENNR	Change Number	nvarchar	12	0
268	ESTRR	EHS: Reference	6	AENNR	Change Number	nvarchar	12	0
269	ESTST	EHS: Specification Status Assignment	6	AENNR	Change Number	nvarchar	12	0
270	ESTVA	EHS: Value Assignment	6	AENNR	Change Number	nvarchar	12	0
271	ESTVH	EHS: Specification - Value Assignment Type Assignment	6	AENNR	Change Number	nvarchar	12	0
272	ESTVP	EHS: Value Assignment Item	6	AENNR	Change Number	nvarchar	12	0
273	ESTWL	EHS: BOMBOS - Worklist Table	6	AENNR	Change Number	nvarchar	12	0
274	ESTWO	EHS: Print jobs	6	AENNR	Change Number	nvarchar	12	0
275	TCGHIT	EHS: No. of hits	3	AENNR	Change Number	nvarchar	12	0
276	TCGOUTVAR	EHS: Output variants	3	AENNR	Change Number	nvarchar	12	0
277	TCGQUE	EHS: Queries	3	AENNR	Change Number	nvarchar	12	0
278	TCGREL02	EHS: Obsolete	2	AENNR	Change Number	nvarchar	12	0
279	TCGRUL	EHS: Easy Expert Set of Rules	3	AENNR	Change Number	nvarchar	12	0
280	TCGRULPOSMREST	EHS: Easy Expert Set of Rules, Characteristic Restrictions	84	AENNR	Change Number	nvarchar	12	0
281	TCGTPLH	EHS: Inheritance Template Header	3	AENNR	Change Number	nvarchar	12	0
282	TCGTPLI	EHS: Inheritance Templates - Identifiers	6	AENNR	Change Number	nvarchar	12	0
283	TCGTPLP	EHS: Inheritance Templates - Properties	6	AENNR	Change Number	nvarchar	12	0
284	TCGTPLREL	EHS: Inheritance Relationships	6	AENNR	Change Number	nvarchar	12	0
285	TCGTPLU	EHS: Inheritance Templates - Usages	6	AENNR	Change Number	nvarchar	12	0
TOPProduct Structure Browser
286	USROBJECTS	Table of Previous Initial Object in Structure Overview	5	AENNR	Change Number	nvarchar	12	0
TOPProduction Orders
287	AFFL	Work order sequence	9	AENNR	Change Number	nvarchar	12	0
288	AFKO	Order Header Data PP Orders	108	AENNR	Change Number	nvarchar	12	0
289	AFVC	Operation within an order	133	AENNR	Change Number	nvarchar	12	0
290	COMPCMP	OCM: Comparison result, individual records for components	23	AENNR	Change Number	nvarchar	12	0
291	COMPH	OCM: Comparison result (header entry)	15	AENNR	Change Number	nvarchar	12	0
292	COMPOPR	OCM: Comparison result, individual records for operations	22	AENNR	Change Number	nvarchar	12	0
293	COMPPRT	OCM: Comparison result, individual record for PRTs	17	AENNR	Change Number	nvarchar	12	0
294	COMPSQU	OCM: Comparison results; Single records for sequences	18	AENNR	Change Number	nvarchar	12	0
295	DRAD_PORDER	Attributes for Links: Document to Production Order	14	AENNR	Change Number	nvarchar	12	0
296	FUNOCM	Function marked for Order Change Management	31	AENNR	Change Number	nvarchar	12	0
TOPProduction ResourcesTools
297	AFFH	PRT assignment data for the work order	67	AENNR	Change Number	nvarchar	12	0
298	CRFH	CIM production resource/tool master data	11	AENNR	Change Number	nvarchar	12	0
TOPQuality Management
299	ZPH_ENH_SRMT01	Change Request Properties	4	AENNR	Change Number	nvarchar	12	0
TOPRecipe
300	RCPC_AENNR	RMS-RCP: Dummy Change Number	2	AENNR	Change Number	nvarchar	12	0
301	RCPT_API_KSSK_D	RMS - RCP: Deletion Entries for Classification	3	AENNR	Change Number	nvarchar	12	0
302	RCPT_PPV	RMS-RCP: Process Parameter Value Assignment	5	AENNR	Change Number	nvarchar	12	0
TOPRecipe Development
303	/PLMI/LBL_MIGRAT	Migration Administration (mapping of EhP4 to PLMWUI)	3	AENNR	Change Number	nvarchar	12	0
304	/PLMI/RCP_MIGRAT	Migration Administration (mapping of RM to RD)	3	AENNR	Change Number	nvarchar	12	0
TOPResourcen Management
305	FRMLT20	RMS-FRM: Connection Table BOM - Formula (LoM)	5	AENNR	Change Number	nvarchar	12	0
306	MRTRST_QM_REL	RMS-MRTRS : QM of GR Element to QM of MR Element	10	AENNR	Change Number	nvarchar	12	0
307	PNEQR	RMS - RCP Equipment Requirement Node: Attributes	8	AENNR	Change Number	nvarchar	12	0
308	PNFRM	RMS-FRM: PVS Formula - Item Nodes: Attributes	4	AENNR	Change Number	nvarchar	12	0
309	PNPOBA	RMS-RCP: Attributes of "Process Action" POB Node	6	AENNR	Change Number	nvarchar	12	0
310	PNPOBO	RMS-RCP: Attributes of the "Process Operation" POB Node	6	AENNR	Change Number	nvarchar	12	0
311	PNPOBS	RMS-RCP: Attributes of POB Nodes, Process and Stage	6	AENNR	Change Number	nvarchar	12	0
312	PREQR	RMS-RCP: iPPE Relationship: Equipment Requirement	4	AENNR	Change Number	nvarchar	12	0
313	PRPOBA	RMS-RCP: iPPE Relationship: Operation-Action	4	AENNR	Change Number	nvarchar	12	0
314	PRPOBI	RMS-RCP: iPPE Relationship: Assignment Relationshps f. Items	4	AENNR	Change Number	nvarchar	12	0
315	PRPOBO	RMS-RCP: iPPE Relationship: Stage-Operation	4	AENNR	Change Number	nvarchar	12	0
316	PRPOBR	RMS-RCP: iPPE Relationship: Relationships Between Operations	4	AENNR	Change Number	nvarchar	12	0
317	PRPOBS	RMS-RCP: iPPE Relationship: Recipe-Stage, Process-Stage	4	AENNR	Change Number	nvarchar	12	0
318	PVFRMH	RMS-FRM: PVS Variant (Formula): History Management	3	AENNR	Change Number	nvarchar	12	0
319	PVRCPD	PVS Header/Recipe Basic Data	4	AENNR	Change Number	nvarchar	12	0
320	RCPT_GRMR_REL	RMS-RCP: Relationship Between General Recipe & Master Recipe	7	AENNR	Change Number	nvarchar	12	0
321	RMSAT_LASTAT	RMS-ATL: Translation Status	6	AENNR	Change Number	nvarchar	12	0
322	RMSAT_QMHDR	QM: Header Table, Operation Level: Sample Drawing Takt, CCP	6	AENNR	Change Number	nvarchar	12	0
323	RMSAT_QMINSP	RMS: ATL QM List of Inspection Data for General Recipes	6	AENNR	Change Number	nvarchar	12	0
324	RMSAT_QMINSPT	RMS: ATL QM Detail Texts for Inspections in General Recipes	6	AENNR	Change Number	nvarchar	12	0
325	RMSAT_STD_PARA_H	RMS-ATL: Header Table Parameter Standardization	4	AENNR	Change Number	nvarchar	12	0
326	RMSLA_DIIT	Items of Diet Label List	4	AENNR	Change Number	nvarchar	12	0
327	RMSLA_DILI	Header Data of Diet Label List	4	AENNR	Change Number	nvarchar	12	0
328	RMSLA_DIVA	Diet Values	4	AENNR	Change Number	nvarchar	12	0
329	RMSLA_HDH	Time-Dependent Header Data of Label Set	3	AENNR	Change Number	nvarchar	12	0
330	RMSLA_HDLG	Languages for Label Set	3	AENNR	Change Number	nvarchar	12	0
331	RMSLA_INIT	Items of Ingredient Label List	4	AENNR	Change Number	nvarchar	12	0
332	RMSLA_INLI	Header Data of Ingredient Label List	4	AENNR	Change Number	nvarchar	12	0
333	RMSLA_INLIT_LOC	Labeling: Target Location Dependent Ingredient List Title	4	AENNR	Change Number	nvarchar	12	0
334	RMSLA_INVA	Ingredient Quantities	4	AENNR	Change Number	nvarchar	12	0
335	RMSLA_NUIT	Items of Nutrition Label List	4	AENNR	Change Number	nvarchar	12	0
336	RMSLA_NULI	Header Data of Nutrition Label List	4	AENNR	Change Number	nvarchar	12	0
337	RMSLA_NULIT	Description of Nutrition Label List	4	AENNR	Change Number	nvarchar	12	0
338	RMSLA_NULIT_LOC	Labeling: Target Location Dependent Nutrient List descr.	5	AENNR	Change Number	nvarchar	12	0
339	RMSLA_NURDA	RDAs of Component lists	4	AENNR	Change Number	nvarchar	12	0
340	RMSLA_NUVA	Nutritional Value Data	4	AENNR	Change Number	nvarchar	12	0
341	RMSLA_PAIT	Item Data of Package Label List	4	AENNR	Change Number	nvarchar	12	0
342	RMSLA_PALI	Header Data of Package Label List	4	AENNR	Change Number	nvarchar	12	0
343	RMSLA_PALIT	Description of Package Label List	4	AENNR	Change Number	nvarchar	12	0
344	RMSLA_STMT	Statements and Footnotes of Label Set	3	AENNR	Change Number	nvarchar	12	0
345	RMSLA_USAGE	Label Set Usage	3	AENNR	Change Number	nvarchar	12	0
346	RMXTT_TRIAL_MR	Trial: Assigned Master Recipes	10	AENNR	Change Number	nvarchar	12	0
TOPRouting
347	MAPL	Assignment of Task Lists to Materials	11	AENNR	Change Number	nvarchar	12	0
348	PLAS	Task list - selection of operations/activities	10	AENNR	Change Number	nvarchar	12	0
349	PLFH	Task list - production resources/tools	10	AENNR	Change Number	nvarchar	12	0
350	PLFL	Task list - sequences	9	AENNR	Change Number	nvarchar	12	0
351	PLKO	Task list - header	8	AENNR	Change Number	nvarchar	12	0
352	PLMZ	Allocation of bill of material items to operations	8	AENNR	Change Number	nvarchar	12	0
353	PLPO	Task list - operation/activity	8	AENNR	Change Number	nvarchar	12	0
TOPSales
354	VBSN	Change status relating to scheduling agreements	4	AENNR	Internal sequential engineering change number	nvarchar	4	0
TOPSCM Basis
355	CIF_IMECM	Int. Model Reference Table for Engineering Change Management	2	AENNR	Change Number	nvarchar	12	0
TOPSimulation
356	VSAFAB_CN	Version: Network relationships	32	AENNR	Change Number	nvarchar	12	0
357	VSAFFH_CN	Version: PRT allocation to work order	68	AENNR	Change Number	nvarchar	12	0
358	VSAFFL_CN	Version: Order sequences PP orders	10	AENNR	Change Number	nvarchar	12	0
359	VSAFKO_CN	Version: Order header data for PP orders	109	AENNR	Change Number	nvarchar	12	0
360	VSAFVC_CN	Version: Operation in order	134	AENNR	Change Number	nvarchar	12	0
361	VSMLST_CN	Version: Milestone	7	AENNR	Change Number	nvarchar	12	0
362	VSPLAF_CN	Version: Planned order	44	AENNR	Change Number	nvarchar	12	0
363	VSPRPS_CN	Version: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data	76	AENNR	Change Number	nvarchar	12	0
364	VSRESB_CN	Version: Reservation/Dependent requirements	74	AENNR	Change Number	nvarchar	12	0
TOPTemplates
365	PRPSS	Standard WBS Element (WBS element) - Master Data	75	AENNR	Change Number	nvarchar	12	0
TOPVariant Configuration
366	CUCO	Additional Data for Configurable Objects	20	AENNR	Change Number	nvarchar	12	0
367	KRIF	Richie Riffle	8	AENNR	Change Number	nvarchar	12	0
TOPWaste Management
368	EHSWAT000	MD (BDT): Master Table for the Waste Management Master Data	6	AENNR	Change Number	nvarchar	12	0
369	EHSWAT001	MD (BDT): Generator/Disposer/Transporter	6	AENNR	Change Number	nvarchar	12	0
370	EHSWAT001ACC	MD (BDT): Generator/Disposer/Transporter - Accnt Assignment	6	AENNR	Change Number	nvarchar	12	0
371	EHSWAT001_DESCR	MD (BDT): Language-Dependent Data for Partner	7	AENNR	Change Number	nvarchar	12	0
372	EHSWAT002	MD (BDT): Waste Generation/Disposal/Transport	6	AENNR	Change Number	nvarchar	12	0
373	EHSWAT003	MD (BDT): Disposal Channel	6	AENNR	Change Number	nvarchar	12	0
374	EHSWAT100	MD (BDT): Business Partner Roles	6	AENNR	Change Number	nvarchar	12	0
375	EHSWAT_APPAMOUNT	MD: Waste Permit Predicted Quantities	6	AENNR	Change Number	nvarchar	12	0
376	EHSWAT_APPBP	MD: Waste Permit Partner	6	AENNR	Change Number	nvarchar	12	0
377	EHSWAT_APPBPCON	MD: Waste Permit - Partner - Contracts	6	AENNR	Change Number	nvarchar	12	0
378	EHSWAT_APPROVAL	MD: Waste Approval	6	AENNR	Change Number	nvarchar	12	0
379	EHSWAT_APPWAKEY	MD: Waste Permit Waste Code	6	AENNR	Change Number	nvarchar	12	0
380	EHSWAT_BPDEFINIT	MD: Partner Reference to Master Data Objects	6	AENNR	Change Number	nvarchar	12	0
381	EHSWAT_BPID	MD: Partner - Jurisdiction-Dependent Data	6	AENNR	Change Number	nvarchar	12	0
382	EHSWAT_BPLIZ	Licenses for Partner	6	AENNR	Change Number	nvarchar	12	0
383	EHSWAT_BPWAAM	MD: Partner-Waste Quantity Predictions	6	AENNR	Change Number	nvarchar	12	0
384	EHSWAT_BPWAKEY	MD: Partner Waste Codes	6	AENNR	Change Number	nvarchar	12	0
385	EHSWAT_BPWAWAKEY	MD: Partner-Waste Waste Code	6	AENNR	Change Number	nvarchar	12	0
386	EHSWAT_DCAPP	MD: Disposal Channel-Waste Permit	6	AENNR	Change Number	nvarchar	12	0
387	EWA_EHSWAV_100	EHSWAV_100 Local Table	6	AENNR	Change Number	nvarchar	12	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

387 columns | ERP 6.0 | AENNR