	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

330 columns | ERP 6.0 | AWTYP

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/BIC/B0000168000	PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items	92	AWTYP		nvarchar	5	0
2	/BIC/B0000169000	PSA for 0FI_GL_41 T90CLNT090 Documents, Compact	92	AWTYP		nvarchar	5	0
3	/BIC/B0000172000	PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items	129	AWTYP		nvarchar	5	0
4	/BIC/B0000174000	PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs	10	AWTYP		nvarchar	5	0
5	/BIC/B0000175000	PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q)	10	AWTYP		nvarchar	5	0
6	/OPT/AT_APPR_HIS	Approval History for Level Based Approvals	2	AWTYP	Reference Transaction	nvarchar	5	0
7	/OPT/AT_LBA_LOG	Approval History for Level Based Approvals	2	AWTYP	Reference Transaction	nvarchar	5	0
8	/SAPF15/F15	F15 Belege (Kopfdaten)	33	AWTYP	Referenzvorgang	nvarchar	5	0
9	/SAPF15/F15H	F15 Belege (Kopfdaten Historie)	34	AWTYP	Referenzvorgang	nvarchar	5	0
10	ARBERP_D_STSTRIG	Trigger table: send cXML acc. doc. rel. msg. based on BTE	3	AWTYP	Reference Transaction	nvarchar	5	0
11	CNVTDMS_05_ACCTH	Collected Header Document Numbers for TDMS_Time-ACCTHD	3	AWTYP	AWTYP for CNVTDMS_05_ACCTHD	nvarchar	5	0
12	CNV_20100_COES	Duplicate COES keys (target values)	4	AWTYP	Reference Transaction	nvarchar	5	0
13	FAGLFLEXC	EMU: Sum of Open Items of Table FAGLFLEXT	19	AWTYP	Reference Transaction	nvarchar	5	0
14	FAGLFLEXD	EMU: Documentation of changes in Txn.Figs of Tabl FAGLFLEXT	21	AWTYP	Reference Transaction	nvarchar	5	0
15	FAGLFLEXT_BAK	General Ledger: Totals	18	AWTYP	Reference Transaction	nvarchar	5	0
16	FAGLFLEXT_DIF	Delta Table: G/L Totals	18	AWTYP	Reference Transaction	nvarchar	5	0
17	FUDT_VDOCBKPF	Verification Document Header	35	AWTYP	Reference Transaction	nvarchar	5	0
18	FUDT_VDOCBKPFH	Verification Document Header(History)	35	AWTYP	Reference Transaction	nvarchar	5	0
19	GLPCA_CT	Profit Center Documents	51	AWTYP	Reference Transaction	nvarchar	5	0
20	GLPCA_T_CT	Profit Center Documents	67	AWTYP	Reference Transaction	nvarchar	5	0
21	GLPOS_C_CT	FI Document: Entry View	55	AWTYP	Reference Transaction	nvarchar	5	0
22	GLPOS_C_DEB_CT	GLPOS_C_CT Customer Line Items	55	AWTYP	Reference Transaction	nvarchar	5	0
23	GLPOS_C_GL_CT	GLPOS_C_CT G/L Line Items	55	AWTYP	Reference Transaction	nvarchar	5	0
24	GLPOS_C_VEN_CT	GLPOS_C_CT Vendor Line Items	55	AWTYP	Reference Transaction	nvarchar	5	0
25	GLPOS_N_CT	New General Ledger: Line Item with Currency Type	55	AWTYP	Reference Transaction	nvarchar	5	0
26	GLPOS_N_GL_CT	New General Ledger: Line Item with Currency Type	55	AWTYP	Reference Transaction	nvarchar	5	0
27	INTITFX	Fixed Interest Amounts per Invoice	8	AWTYP	Reference Transaction	nvarchar	5	0
28	PAYR_XBANC_HR	Temporary Storage in FI for Cashed HR Checks	7	AWTYP	Reference Transaction	nvarchar	5	0
29	T060	Rules for A/R and A/P information system	4	AWTYP	Evaluation type	nvarchar	2	0
30	T060A	Evaluation types in A/R and A/P information system	4	AWTYP	Evaluation type	nvarchar	2	0
31	T060B	Texts for T060A - evaluatn types in A/R and A/P info system	5	AWTYP	Evaluation type	nvarchar	2	0
32	T060T	Evaluation names in the FI information system	5	AWTYP	Evaluation type	nvarchar	2	0
33	TTYPVX	Enhanced Document Summarization in FI	2	AWTYP	Reference Transaction	nvarchar	5	0
34	VIYCEXPITEM	Expense Items	10	AWTYP	Reference Transaction	nvarchar	5	0
35	ZARIXFI1	Archive Information Structure SAP_FI_DOC_002	15	AWTYP	Reference Transaction	nvarchar	5	0
36	ZARIXFI2	Archive Information Structure SAP_FI_DOC_DRB1	9	AWTYP	Reference Transaction	nvarchar	5	0
37	ZSAWA	Actual line item table	44	AWTYP	Reference Transaction	nvarchar	5	0
38	ZSAWP	Plan line items table	124	AWTYP	Reference Transaction	nvarchar	5	0
39	ZSEMBPSA	Actual line item table	40	AWTYP	Reference Transaction	nvarchar	5	0
40	ZSEMBPSP	Plan line items table	120	AWTYP	Reference Transaction	nvarchar	5	0
41	ZSPLITA	Isteinzelposten-Tabelle	44	AWTYP	Referenzvorgang	nvarchar	5	0
42	ZSPLITP	Planeinzelposten-Tabelle	124	AWTYP	Referenzvorgang	nvarchar	5	0
43	ZZ001A	Actual Line Item Table	51	AWTYP	Reference Transaction	nvarchar	5	0
44	ZZ001P	Plan Line Items Table	131	AWTYP	Reference Transaction	nvarchar	5	0
45	ZZLINEA	Actual line item table	45	AWTYP	Reference Transaction	nvarchar	5	0
46	ZZLINEP	Plan line items table	109	AWTYP	Reference Transaction	nvarchar	5	0
47	ZZSL01A	Actual line item table	53	AWTYP	Reference Transaction	nvarchar	5	0
48	ZZSL01P	Plan line items table	133	AWTYP	Reference Transaction	nvarchar	5	0
49	ZZSPECA	Actual line item table	44	AWTYP	Reference Transaction	nvarchar	5	0
50	ZZSPECP	Plan line item table	108	AWTYP	Reference Transaction	nvarchar	5	0
TOPAccounting Interface
51	GLE_FI_ITEM_MODF	ECS: Modified FI Line Items (Header/Item/Currency Data)	3	AWTYP	Reference Transaction	nvarchar	5	0
52	GLE_FI_ITEM_ORIG	ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)	3	AWTYP	Reference Transaction	nvarchar	5	0
TOPAccounts Receivable Accounting Process Integration
53	FDM_CCM_CORR	Trigger Table for Manual Adjustments (Claims Management)	3	AWTYP	Reference Transaction	nvarchar	5	0
TOPAccrual Engine
54	ACEPSOIT	Line Items for Accrual Item in Accrual Engine	19	AWTYP	Reference Transaction	nvarchar	5	0
55	TACECOMP	Accrual Engine Application Component	4	AWTYP	Reference Transaction	nvarchar	5	0
TOPActual CostingMaterial Ledger
56	CKMI1	Index for Accounting Documents for Material	5	AWTYP	Reference Transaction	nvarchar	5	0
57	CKMVFM_BSEG_OUT	Display of FI Documents, Transaction CKMVFM, SAP Note 912984	26	AWTYP	Reference Transaction	nvarchar	5	0
58	MLHD	Material Ledger Document: Header	5	AWTYP	Reference Transaction	nvarchar	5	0
TOPAdaptor
59	UKM_TRANSFER_AR	Data from AR for SAP Credit Management	13	AWTYP	Reference Transaction	nvarchar	5	0
TOPAutomatic Payments
60	PAYRQ	Payment Requests	141	AWTYP	Reference Transaction	nvarchar	5	0
TOPAvailability Control
61	FMAVCA	Actual line item table	43	AWTYP	Reference Transaction	nvarchar	5	0
62	FMAVCP	Plan line items table	91	AWTYP	Reference Transaction	nvarchar	5	0
TOPBasic Functions
63	ANEK	Document Header Asset Posting	44	AWTYP	Reference Transaction	nvarchar	5	0
64	ARC_IDX_AT	Index table for ACCTIT/ACCTHD/ACCTCR archives	8	AWTYP	Reference Transaction	nvarchar	5	0
65	ETXDCH	External tax document: header info	3	AWTYP	Reference Transaction	nvarchar	5	0
66	FDS2	CM&F Line Items in SD Documents (fromr Release 4.0)	2	AWTYP	Reference Transaction	nvarchar	5	0
67	FDSP	Cash Mgmt Adjustment Items from Document Splitting	3	AWTYP	Reference Transaction	nvarchar	5	0
68	FILCA	FI-LC: Actual journal entry table with 2 object tables	56	AWTYP	Reference Transaction	nvarchar	5	0
69	FILCP	FI-LC: Plan line items for object table	132	AWTYP	Reference Transaction	nvarchar	5	0
70	GGREFA	Example for Global FI-SL Line Items (Actual)	46	AWTYP	Reference Transaction	nvarchar	5	0
71	GGREFP	Example for Global FI-SL Line Items (Plan)	126	AWTYP	Reference Transaction	nvarchar	5	0
72	GLFUNCA	Actual Line Items Table for Cost of Sales Accounting	44	AWTYP	Reference Transaction	nvarchar	5	0
73	GLFUNCP	Plan Line Items Table for Cost of Sales Accounting	108	AWTYP	Reference Transaction	nvarchar	5	0
74	GLFUNCU	Rollup line item tables with function area for IDES	44	AWTYP	Reference Transaction	nvarchar	5	0
75	GLFUNCV	Rollup plan line items table with function area for IDES	108	AWTYP	Reference Transaction	nvarchar	5	0
76	GLIDXA	Index to Find FI-SL Documents Based on AWKEY	3	AWTYP	Reference Transaction	nvarchar	5	0
77	GLP0	Local Logical General Ledger Plan Line Items	79	AWTYP	Reference Transaction	nvarchar	5	0
78	GLREFA	Example for Local FI-SL Line Items (Actual)	44	AWTYP	Reference Transaction	nvarchar	5	0
79	GLREFP	Example for Local FI-SL Line Items (Plan)	124	AWTYP	Reference Transaction	nvarchar	5	0
80	GLREFU	Example for FI-SL Rollup Line Items (Actual)	46	AWTYP	Reference Transaction	nvarchar	5	0
81	GLREFV	Example for Rollup FI-SL Line Items (Plan)	126	AWTYP	Reference Transaction	nvarchar	5	0
82	T036M2	Earmarked Funds: Group Assignment If Account Missing	2	AWTYP	Reference Transaction	nvarchar	5	0
83	TTXI	External tax interface: index file	2	AWTYP	Reference Transaction	nvarchar	5	0
84	TTXU	External tax interface: Audit file update information	12	AWTYP	Reference Transaction	nvarchar	5	0
85	TTXY	External tax interface: tax information	2	AWTYP	Reference Transaction	nvarchar	5	0
TOPBasis Components
86	ZDS400_BKPF	Belegkopf für Buchhaltung	35	AWTYP	Referenzvorgang	nvarchar	5	0
TOPBudgeting
87	FMBDA	Actual line item table	44	AWTYP	Reference Transaction	nvarchar	5	0
88	FMBDP	FM Budget change line items table	92	AWTYP	Reference Transaction	nvarchar	5	0
89	FMBH	Funds management budget header (entry documents)	30	AWTYP	Reference Transaction	nvarchar	5	0
90	FMRBA	Actual line item table	42	AWTYP	Reference Transaction	nvarchar	5	0
91	FMRBP	Plan line items table	90	AWTYP	Reference Transaction	nvarchar	5	0
TOPBudgeting and Availability Control
92	GMBDGTHEADER	Budget Document Header	29	AWTYP	Reference Transaction	nvarchar	5	0
TOPCentral Cash Desk Procedure
93	FMFG_PPA_INV_LN	Reason Codes for Accounting Documents (Item Level)	4	AWTYP	Reference Transaction	nvarchar	5	0
TOPCollectionsDisbursements
94	GLISDEA	Actual Line Item Tables for Insurance (DE)	56	AWTYP	Reference Transaction	nvarchar	5	0
95	GLISDEP	Plan Line Item Table for Insurance (DE)	120	AWTYP	Reference Transaction	nvarchar	5	0
96	GRISDEA	Actual Line Item Table for Insurance (DE) - Rollup	56	AWTYP	Reference Transaction	nvarchar	5	0
97	GRISDEP	Plan Line Item Table for Insurance (DE) - Rollup	120	AWTYP	Reference Transaction	nvarchar	5	0
98	VVSCPOS	Payment Plan Item	116	AWTYP	Reference Transaction	nvarchar	5	0
TOPConsolidation
99	ECMCA	SAP Cons.: Journal Entry Table (Actual)	58	AWTYP	Reference Transaction	nvarchar	5	0
TOPContract Accounts Receivable and Payable
100	DFKKKO	Header Data in Open Item Accounting Document	19	AWTYP	Reference Transaction	nvarchar	5	0
101	DFKKKO_SHORT	Header Data for Contract Accounting Document - Extracts	9	AWTYP	Reference Transaction	nvarchar	5	0
102	DFKKMKO	Header data for sample contract accounting document	19	AWTYP	Reference Transaction	nvarchar	5	0
103	DFKKORDER	Requests: Header Data	21	AWTYP	Reference Transaction	nvarchar	5	0
104	DFKKORDER_S	Request Templates: Header Data	21	AWTYP	Reference Transaction	nvarchar	5	0
TOPControlling
105	COK41C_IX	Index Table for Documents in a Posting Run	6	AWTYP	Reference Transaction	nvarchar	5	0
106	COPPP_HDR	CO Postprocessing List - Headers	34	AWTYP	Reference Transaction	nvarchar	5	0
107	TKACPC	CO Line Item Summarization: Fields to be Summarized	2	AWTYP	Reference Transaction	nvarchar	5	0
TOPCost Element Accounting
108	COFIP	Single plan items for reconciliation ledger	120	AWTYP	Reference Transaction	nvarchar	5	0
109	COFIS	Actual line items for reconciliation ledger	57	AWTYP	Reference Transaction	nvarchar	5	0
TOPCost Object
110	FCO_DOC_HEAD	Failure Cost Document Header	4	AWTYP	Reference Transaction	nvarchar	5	0
TOPCosting
111	COES	CO Object: Sales Order Value Line Items	3	AWTYP	Reference Transaction	nvarchar	5	0
TOPCross-Application Components
112	BKKPF	Accounting document header	35	AWTYP	Reference Transaction	nvarchar	5	0
TOPData Retention Tool
113	TXW_S_ANEA	Retrieve ANEA from archive	30	AWTYP	Reference Transaction	nvarchar	5	0
114	TXW_S_ANEK	Retrieve ANEP from archive	35	AWTYP	Reference Transaction	nvarchar	5	0
115	TXW_S_ANEP	Retrieve ANEP from archive	26	AWTYP	Reference Transaction	nvarchar	5	0
116	TXW_S_BKPF	Retrieve BKPF from archive	34	AWTYP	Reference Transaction	nvarchar	5	0
117	TXW_S_COBK	Retrieve COBK from archive	25	AWTYP	Reference Transaction	nvarchar	5	0
118	TXW_S_COEP	Retrieve COEP from archive	37	AWTYP	Reference Transaction	nvarchar	5	0
119	TXW_S_COFI	Retrieve COFIS from archive	23	AWTYP	Reference Transaction	nvarchar	5	0
120	TXW_S_MKPF	Retrieve MKPF from archive	20	AWTYP	Reference Transaction	nvarchar	5	0
121	TXW_S_VBRK	Retrieve VBRK from archive	24	AWTYP	Reference Transaction	nvarchar	5	0
TOPDown Payment Chains
122	/SAPPCE/TDPCIDXC	Down Payment Chain: Index for Cleared Items	12	AWTYP	Reference Transaction	nvarchar	5	0
123	/SAPPCE/TDPCIDXO	Down Payment Chain: Index for Open Items	12	AWTYP	Reference Transaction	nvarchar	5	0
TOPEnterprise Services - Personnel Time Management
124	TIM_SE_EXT_KEY	Mapping Table for IT2004: External Key and Infotype Key	2	AWTYP	Reference Transaction	nvarchar	5	0
TOPExpenditure Certification
125	FMEUFEXP	Certified Expenditure Documents	4	AWTYP	Reference Transaction	nvarchar	5	0
TOPFinancial Accounting
126	ACCTCR	Compressed Data from FI/CO Document - Currencies	2	AWTYP	Reference Transaction	nvarchar	5	0
127	ACCTHD	Compressed Data from FI/CO Document - Header	2	AWTYP	Reference Transaction	nvarchar	5	0
128	ACCTIT	Compressed Data from FI/CO Document	2	AWTYP	Reference Transaction	nvarchar	5	0
129	ARIX_BKPF	FI_DOCUMNT: Header-Oriented Document Index for Archive	5	AWTYP	Reference Transaction	nvarchar	5	0
130	BKPF	Accounting Document Header	35	AWTYP	Reference Transaction	nvarchar	5	0
131	BSPL	Split Posting Procedures	2	AWTYP	Reference Transaction	nvarchar	5	0
132	EBKPF	Fin.Accntng Doc.Header (of Docs from Extern.Systems)	40	AWTYP	Reference Transaction	nvarchar	5	0
133	FBICRC001A	ICRC: Open Items GL Accounts: Documents	34	AWTYP	Reference Transaction	nvarchar	5	0
134	FBICRC001P	Not in use	49	AWTYP	Reference Transaction	nvarchar	5	0
135	FBICRC002A	ICRC: GL Accounts: Documents	34	AWTYP	Reference Transaction	nvarchar	5	0
136	FBICRC002P	Not in use	49	AWTYP	Reference Transaction	nvarchar	5	0
137	FBICRC003A	ICRC: Open Items Customers/Vendors: Documents	35	AWTYP	Reference Transaction	nvarchar	5	0
138	FBICRC003P	Not in use	50	AWTYP	Reference Transaction	nvarchar	5	0
139	FERC_D2	Documents per sender and account	16	AWTYP	Reference Transaction	nvarchar	5	0
140	TAX_APPLI	Applications for Tax Services	2	AWTYP	Reference Transaction	nvarchar	5	0
141	TTYP	Object Types for Accounting	1	AWTYP	Reference Transaction	nvarchar	5	0
142	TTYPT	Object Type Names for Accounting	2	AWTYP	Reference Transaction	nvarchar	5	0
143	TTYPV	FI Summarization Dependent on the Object Type	2	AWTYP	Reference Transaction	nvarchar	5	0
144	VBKPF	Document Header for Document Parking	62	AWTYP	Reference Transaction	nvarchar	5	0
TOPFinancial Services Localization
145	/CEEIS/RUA	Actual line item table	55	AWTYP	Reference Transaction	nvarchar	5	0
146	/CEEIS/RUP	Plan line items table	135	AWTYP	Reference Transaction	nvarchar	5	0
TOPFlexible Real Estate Management
147	VIPRLEDTAGRA	Isteinzelposten-Tabelle	34	AWTYP	Referenzvorgang	nvarchar	5	0
148	VIPRLEDTAGRP	Planeinzelposten-Tabelle	98	AWTYP	Referenzvorgang	nvarchar	5	0
TOPFSCM In-House Cash
149	IHC_DB_PN	Source Document for Incoming Payment Orders	127	AWTYP	Reference Transaction	nvarchar	5	0
TOPFunctions for U.S. Federal Government
150	FMABP_AREAS	Assignment of application areas for automated budget posting	1	AWTYP	Reference Transaction	nvarchar	5	0
TOPFund Accounting
151	FMCCAVCA	Actual line item table	40	AWTYP	Reference Transaction	nvarchar	5	0
152	FMCCAVCP	Plan line items table	88	AWTYP	Reference Transaction	nvarchar	5	0
153	FMGLFLEX00	General ledger: Transaction attributes	6	AWTYP	Reference Transaction	nvarchar	5	0
154	FMGLFLEXA	General Ledger: Actual Line Items	11	AWTYP	Reference Transaction	nvarchar	5	0
155	FMGLFLEXP	General Ledger: Plan Line Items	13	AWTYP	Reference Transaction	nvarchar	5	0
156	FMGLFLEXT	General Ledger Public Sector: Total	18	AWTYP	Reference Transaction	nvarchar	5	0
157	PSGLFLEX00	General ledger: Transaction attributes	6	AWTYP	Reference Transaction	nvarchar	5	0
158	PSGLFLEXA	General Ledger: Actual Line Items	11	AWTYP	Reference Transaction	nvarchar	5	0
159	PSGLFLEXP	General Ledger: Plan Line Items	13	AWTYP	Reference Transaction	nvarchar	5	0
160	PSGLFLEXT	General Ledger Public Sector: Total	18	AWTYP	Reference Transaction	nvarchar	5	0
TOPFunds Management
161	BPDK	Header Entry Document	23	AWTYP	Reference Transaction	nvarchar	5	0
162	FCABK	FI-CA: Document Header	8	AWTYP	Reference Transaction	nvarchar	5	0
163	FMFG_PO_SUBSET	ZEKKN number to correct invoices for SES	10	AWTYP	Reference Transaction	nvarchar	5	0
164	FMFG_PO_ZEKKN	ZEKKN data for all FI items referencing service POs	10	AWTYP	Reference Transaction	nvarchar	5	0
165	FMFG_SAV_FACTS1A	Saved FACTS1A data for docs excluded from SL Repost for 600	46	AWTYP	Reference Transaction	nvarchar	5	0
166	FMFG_SAV_FACTS2A	Saved FACTS2A data for docs excluded from SL Repost for 600	50	AWTYP	Reference Transaction	nvarchar	5	0
167	FMFG_SAV_FMUSFGA	Saved FMUSFGA data for docs excluded from SL Repost for 600	46	AWTYP	Reference Transaction	nvarchar	5	0
168	FMFG_SAV_GLIDXA	Saved GLIDXA data for docs excluded from SL Repost for 600	3	AWTYP	Reference Transaction	nvarchar	5	0
169	FMIA	Actual Line Item Table for Funds Management	47	AWTYP	Reference Transaction	nvarchar	5	0
170	FMIFIHD	FI Header Table in Funds Management	12	AWTYP	Reference Transaction	nvarchar	5	0
171	FMIP	Plan Line Items Table for Funds Management	79	AWTYP	Reference Transaction	nvarchar	5	0
172	FMSPLITA	Actual line item table	48	AWTYP	Reference Transaction	nvarchar	5	0
173	FMSPLITP	Plan line items table	80	AWTYP	Reference Transaction	nvarchar	5	0
174	FMUSFGA	Actual line item table for US Federal Government.	46	AWTYP	Reference Transaction	nvarchar	5	0
175	FMUSFGFACTS1A	4Actual line item table	46	AWTYP	Reference Transaction	nvarchar	5	0
176	FMUSFGFACTS1P	Plan line items table	77	AWTYP	Reference Transaction	nvarchar	5	0
177	FMUSFGFACTS2A	Actual line item table	50	AWTYP	Reference Transaction	nvarchar	5	0
178	FMUSFGFACTS2P	Plan line items table	81	AWTYP	Reference Transaction	nvarchar	5	0
179	FMUSFGP	Plan line items table	77	AWTYP	Reference Transaction	nvarchar	5	0
180	KBLE	Document Item Processing: Manual Document Entry	34	AWTYP	Reference Transaction	nvarchar	5	0
TOPGeneral Ledger Accounting
181	BKPF_ADD	Accounting Document Header	35	AWTYP	Reference Transaction	nvarchar	5	0
182	FAGLCOFITRACE	Log of Real-Time Integration CO->FI	7	AWTYP	Reference Transaction	nvarchar	5	0
183	FAGLFLEX00	General ledger: Transaction attributes	6	AWTYP	Reference Transaction	nvarchar	5	0
184	FAGLFLEXA	General Ledger: Actual Line Items	11	AWTYP	Reference Transaction	nvarchar	5	0
185	FAGLFLEXP	General Ledger: Plan Line Items	13	AWTYP	Reference Transaction	nvarchar	5	0
186	FAGLFLEXT	General Ledger: Totals	18	AWTYP	Reference Transaction	nvarchar	5	0
187	FAGL_BW_LOG_TOTL	FI-GL: Log for BW Extraction: Totals Records	11	AWTYP	Reference Transaction	nvarchar	5	0
188	FAGL_MIG_FICHA1	Worklist for FI Reassignment Tool	9	AWTYP	Reference Transaction	nvarchar	5	0
189	FAGL_MIG_PROCESS	Document-Specific Business Transaction Assignment	7	AWTYP	Reference Transaction	nvarchar	5	0
190	FAGL_MIG_RPITEMS	Migration in New G/L: Objects To Be Posted Subsequently	10	AWTYP	Reference Transaction	nvarchar	5	0
191	FAGL_QUEUE_LOG	Log of Delta Queue for Error Analysis	9	AWTYP	Reference Transaction	nvarchar	5	0
192	FAGL_SPLINFO	Splittling Information of Open Items	8	AWTYP	Reference Transaction	nvarchar	5	0
193	FAGL_VAL_LOG	Validation of Document Splitting: Log	15	AWTYP	Reference Transaction	nvarchar	5	0
194	FAGL_VAL_PROCESS	Document Splitting: Validation Mode Dependent on Processes	2	AWTYP	Reference Transaction	nvarchar	5	0
195	GLFLEXA	Flexible general ledger: Actual line items	48	AWTYP	Reference Transaction	nvarchar	5	0
196	GLFLEXP	Flexible G/L: Plan line items	126	AWTYP	Reference Transaction	nvarchar	5	0
TOPGrantee Management
197	GMAVCA	Actual line item table	43	AWTYP	Reference Transaction	nvarchar	5	0
198	GMAVCP	Plan line items table	107	AWTYP	Reference Transaction	nvarchar	5	0
199	GMIA	Actual Line Item Table	42	AWTYP	Reference Transaction	nvarchar	5	0
200	GMIP	Plan line items table	89	AWTYP	Reference Transaction	nvarchar	5	0
TOPInput Tax Treatment
201	VIBETAXD	Zuordnung Vorsteuerbeleg zum Berichtigungsobjekt	2	AWTYP	Referenzvorgang	nvarchar	5	0
TOPIntegration
202	FKK_VBRK_SHORT	Header Data for SD Billing Document - Extracts	21	AWTYP	Reference Transaction	nvarchar	5	0
TOPInvoicing
203	DBERDZ	DB Table: Individ. Lines - Print Document	26	AWTYP	Reference Transaction	nvarchar	5	0
204	ERDB	Documents for Print Document (ERDK)	8	AWTYP	Reference Transaction	nvarchar	5	0
205	ERDB_SHORT	Documents for Print Document (ERDK) - Extraction	8	AWTYP	Reference Transaction	nvarchar	5	0
TOPJoint Venture und Production Sharing Accounting
206	JVGLFLEX00	General ledger: Transaction attributes	6	AWTYP	Reference Transaction	nvarchar	5	0
207	JVGLFLEXA	General Ledger: Actual Line Items	11	AWTYP	Reference Transaction	nvarchar	5	0
208	JVGLFLEXP	General Ledger: Plan Line Items	13	AWTYP	Reference Transaction	nvarchar	5	0
209	JVGLFLEXT	General Ledger: Totals	18	AWTYP	Reference Transaction	nvarchar	5	0
210	JVPO1	JVA: Plan Line Items	139	AWTYP	Reference Transaction	nvarchar	5	0
211	JVPSC01A	Actual line item table	54	AWTYP	Reference Transaction	nvarchar	5	0
212	JVPSC01P	Plan line item table	118	AWTYP	Reference Transaction	nvarchar	5	0
213	JVSO1	JV LI Table with Objects for JVTO1	75	AWTYP	Reference Transaction	nvarchar	5	0
214	JVSO2	JV Billing FI-SL Line Item	43	AWTYP	Reference Transaction	nvarchar	5	0
215	T8J_POST_ERROR	Documents with errors in JV posting	2	AWTYP	Reference Transaction	nvarchar	5	0
216	T8J_POST_ERROR_C	Documents with errors in JV posting (Open Items)	2	AWTYP	Reference Transaction	nvarchar	5	0
TOPLease Accounting
217	FILA_GF_ITEMDOCS	Assignment of Process - FI/CO Document Numbers	6	AWTYP	Reference Transaction	nvarchar	5	0
218	FILA_GF_ITEMLINK	Assignment of Objects to Assets	12	AWTYP	Reference Transaction	nvarchar	5	0
219	TFILA_COMPONENT	Application Components of Accounting Engine	3	AWTYP	Reference Transaction	nvarchar	5	0
TOPLocal Currency Changeover
220	EWUFICRDOC	EMU conversion: Documents to RFEWUDOC	3	AWTYP	Reference Transaction	nvarchar	5	0
221	EWUFI_CDOC	EMU conversion: Documents to RFEWUDOC	8	AWTYP	Reference Transaction	nvarchar	5	0
TOPLocalization
222	IDMX_DI_TAXES	Digital Invoice Mexico: Legal Abbreviations of Taxes	2	AWTYP	Object Type	nvarchar	5	0
223	IDMX_DI_TXTIDDET	Digital Invoice Mexico: Data ID - Text ID Determination	2	AWTYP	Object Type	nvarchar	5	0
224	IDMX_DI_TXTOB	Digital Invoice Mexico: Valid Text Objects	1	AWTYP	Object Type	nvarchar	5	0
225	J_1AINFINV	Inflation: Invoices for Replacement Value Determination	5	AWTYP	Reference Transaction	nvarchar	5	0
226	J_1B_CIAP_OBJECT	CIAP document data	52	AWTYP	Reference Transaction	nvarchar	5	0
227	J_1IEWTPROV	Table for TDS provisions	7	AWTYP	Reference Transaction	nvarchar	5	0
228	J_1ISERVC	Service tax details	3	AWTYP	Object type of calling application	nvarchar	5	0
229	J_3RFTAXRA	Tax Accounting: Actual line item table	55	AWTYP	Reference Transaction	nvarchar	5	0
230	J_3RFTAXRP	Tax Accounting: Plan line item table	103	AWTYP	Reference Transaction	nvarchar	5	0
231	J_3RFTAXRVA	Tax Accounting: Actual line item table	55	AWTYP	Reference Transaction	nvarchar	5	0
232	J_3RFTAXRVP	Tax Accounting: Plan line item table	103	AWTYP	Reference Transaction	nvarchar	5	0
TOPMaintenance Processing
233	/MRSS/D_BAS_RES	Resource Master Data	7	AWTYP	Reference Transaction	nvarchar	5	0
234	/MRSS/D_RES_TA	Time allocations for resources	17	AWTYP	Reference Transaction	nvarchar	5	0
TOPMaterials Management
235	J_1GVL_ML	Material Ledger	85	AWTYP	Reference Transaction	nvarchar	5	0
TOPNew Zealand
236	PT2001	HR Time Record: Infotype 2001 (Absences)	67	AWTYP	Reference Transaction	nvarchar	5	0
TOPOverhead Cost Controlling
237	COBK	CO Object: Document Header	33	AWTYP	Reference Transaction	nvarchar	5	0
TOPPayment Order
238	BKKPOHD	Payment Order, Header Data	28	AWTYP	Reference Transaction	nvarchar	5	0
239	BKKPOHD_TMP	Planned Payment Order, Header Data	29	AWTYP	Reference Transaction	nvarchar	5	0
240	BKKPOHD_TMP_DEL	Planned Payment Order, Header Data	29	AWTYP	Reference Transaction	nvarchar	5	0
TOPPayment Transactions
241	CUP_DOC_IT	Document relevant for CUP/CIG Number	5	AWTYP	Reference Transaction	nvarchar	5	0
TOPPersonnel Time Management
242	PA0007	HR Master Record: Infotype 0007 (Planned Working Time)	44	AWTYP	Reference Transaction	nvarchar	5	0
243	PA2001	HR Time Record: Infotype 2001 (Absences)	67	AWTYP	Reference Transaction	nvarchar	5	0
244	PA2002	HR Time Record: Infotype 2002 (Attendances)	49	AWTYP	Reference Transaction	nvarchar	5	0
245	PA2003	HR Time Record: Infotype 2003 (Substitutions)	63	AWTYP	Reference Transaction	nvarchar	5	0
246	PA2010	HR Time Record: Infotype 2010 (Employee Remuneration Info.)	49	AWTYP	Reference Transaction	nvarchar	5	0
247	PTEX2000	Interface Table for Attendances/Absences Infotype(2001/2002)	3	AWTYP	Reference Transaction	nvarchar	5	0
248	PTEX2003GEN	Interface Table for IT 2003: General Information	3	AWTYP	Reference Transaction	nvarchar	5	0
249	PTEX2003SPEC	Interface Table for IT 2003: Interval Information	3	AWTYP	Reference Transaction	nvarchar	5	0
250	PTEX2010	Interface Table for EE Remuneration Info. Infotype (2010)	3	AWTYP	Reference Transaction	nvarchar	5	0
251	PTEXDIR	Interface Table for Infotypes (Directory Table)	3	AWTYP	Reference Transaction	nvarchar	5	0
TOPProfit Center Accounting
252	GLPCA	EC-PCA: Actual Line Items	48	AWTYP	Reference Transaction	nvarchar	5	0
253	GLPCP	EC-PCA: Plan Line Items	136	AWTYP	Reference Transaction	nvarchar	5	0
TOPProfitability Analysis
254	CEERROR	CO-PA: Incorrect records from SD	60	AWTYP	Reference Transaction	nvarchar	5	0
255	TKE_BUS_TRANS	CO-PA Update of Business Transations	2	AWTYP	Reference Transaction	nvarchar	5	0
TOPProject Management
256	DPR_CONF_LI	Project Management Confirmation: Line Item	12	AWTYP	Reference Transaction	nvarchar	5	0
TOPReal Estate Management
257	VIBEPP	Flow data - Planned items for real estate management	69	AWTYP	Reference Transaction	nvarchar	5	0
258	VIDOCS	Reference Table for Real Estate Documents	9	AWTYP	Reference Transaction	nvarchar	5	0
259	VIMIRA	Instalments for Lease-Out	5	AWTYP	Reference Transaction	nvarchar	5	0
260	VITAXA	Line items for correction items	3	AWTYP	Reference Transaction	nvarchar	5	0
261	VITAXD	Tax Shares per Real Estate Account Assignment	2	AWTYP	Reference Transaction	nvarchar	5	0
262	VITAXR	Outflows for correction items	3	AWTYP	Reference Transaction	nvarchar	5	0
263	VITAXU	Tax transfer posting for advance payments with jurisdiction	7	AWTYP	Reference Transaction	nvarchar	5	0
TOPRecruitment
264	PB0007	HR Master Record: Infotype 0007 (Planned Working Time)	44	AWTYP	Reference Transaction	nvarchar	5	0
TOPRecycling Administration Core Functions
265	J_7LC09	REA Customizing: General Controls	49	AWTYP	Reference Transaction	nvarchar	5	0
TOPRegulatory reporting for insurance companies
266	ISSRFLDEA	Actual line item table	78	AWTYP	Reference Transaction	nvarchar	5	0
267	ISSRFLDEP	Plan line items table	158	AWTYP	Reference Transaction	nvarchar	5	0
268	ISSRPREFLOW	ISSR: Basistabelle/Bewegungstabelle	43	AWTYP	Operazione di riferimento	nvarchar	5	0
269	TISSR_IFB_SY_AWT	ISSR: Beziehung Vorsystem zu RWIN-AWTYP	3	AWTYP	Referenzvorgang	nvarchar	5	0
TOPRemaining Beverage - Obsolete Objects
270	/BEV3/CH1030BKPF	Header Data for CH Event Ledger 00001030	37	AWTYP	Reference Transaction	nvarchar	5	0
271	/BEV3/CHABELFLUS	Contract Statement Document Flow	13	AWTYP	Reference Transaction	nvarchar	5	0
272	/BEV3/CHFIA	Actual line item table	42	AWTYP	Reference Transaction	nvarchar	5	0
273	/BEV3/CHFIP	Plan Line Items Table	122	AWTYP	Reference Transaction	nvarchar	5	0
274	/BEV3/CHVGRA	Actual line item table	44	AWTYP	Reference Transaction	nvarchar	5	0
275	/BEV3/CHVGRP	Plan Line Items Table	124	AWTYP	Reference Transaction	nvarchar	5	0
TOPRetail Ledger
276	PCRRETAILA	Actual line item table	43	AWTYP	Reference Transaction	nvarchar	5	0
277	PCRRETAILP	Plan line items table	123	AWTYP	Reference Transaction	nvarchar	5	0
TOPShift Planning
278	HRP1046	Database Table for Infotype 1046	30	AWTYP	Attendance or absence indicator	nvarchar	1	0
279	HRP1049	Database Tables for Infotype 1049	24	AWTYP	Attendance or absence indicator	nvarchar	1	0
280	PSOLL	Shift Planning: Target Plan	13	AWTYP	Attendance or absence indicator	nvarchar	1	0
281	T77ED	Shift Planning: Definition of Shifts	16	AWTYP	Attendance or absence indicator	nvarchar	1	0
TOPSpecial Purpose Ledger
282	/CCIS/PBU18A	PBU18: Actual line item table	57	AWTYP	Reference Transaction	nvarchar	5	0
283	/CCIS/PBU18P	PBU18: Plan line item table	137	AWTYP	Reference Transaction	nvarchar	5	0
284	/CCIS/PROFTAX00	Object Table Number:00	6	AWTYP	Reference Transaction	nvarchar	5	0
285	/CCIS/PROFTAXA	Actual Line Items Table for General Ledger	11	AWTYP	Reference Transaction	nvarchar	5	0
286	/CCIS/PROFTAXP	Plan Line Items Table for General Ledger	13	AWTYP	Reference Transaction	nvarchar	5	0
287	/CCIS/PROFTAXT	Totals Table for General Ledger	18	AWTYP	Reference Transaction	nvarchar	5	0
TOPTariffs, Duties and Permits
288	OIHEDA	Actual line item table, IS-OIL Excise Duty Special Ledger	58	AWTYP	Reference Transaction	nvarchar	5	0
289	OIHEDP	Plan line item table, IS-OIL Excise Duty Special Ledger	138	AWTYP	Reference Transaction	nvarchar	5	0
290	OIHSLA	TDP (excise duty) special ledger actual line item table	63	AWTYP	Reference Transaction	nvarchar	5	0
TOPTransfer to Financial Accounting
291	TRACTSLA	Actual Line Item Table	36	AWTYP	Reference Transaction	nvarchar	5	0
292	TRACTSLP	Plan Line Items Table	116	AWTYP	Reference Transaction	nvarchar	5	0
TOPTreasury
293	FLQITEMSO_FC	Liquidity Calculation-Forecast Line Items from Sales Orders	2	AWTYP	Reference Transaction	nvarchar	5	0
TOPUnited Kingdom
294	T5G_CONVNI	NI Conversion: Mapping customer wage types	6	AWTYP	Wage Type	nvarchar	4	0
TOPUS Prompt Payment Act
295	FMFG_PPA_INVSTAT	PPA Invoice Status Table	4	AWTYP	Reference Transaction	nvarchar	5	0
296	FMFG_PPA_INV_HD	PPA invoice header information (reason codes)	4	AWTYP	Reference Transaction	nvarchar	5	0
297	FMFG_PPA_INV_HIS	PPA Invoice Status Change History	4	AWTYP	Reference Transaction	nvarchar	5	0
298	FMFG_PPA_LINK	Link the application log to an Invoice (PPA)	2	AWTYP	Reference Transaction	nvarchar	5	0
TOPWorkforce Management Core
299	/SAPAPO/LRPAINTG	Table for Appointment Interval Groups	2	AWTYP	WFM Application Category	nvarchar	5	0
300	/SAPAPO/LRPAINTN	Table of Appointment Intervals	2	AWTYP	WFM Application Category	nvarchar	5	0
301	/SAPAPO/LRPAINTT	Text Table for Appointment Interval Group Types	3	AWTYP	WFM Application Category	nvarchar	5	0
302	/SAPAPO/LRPAPSYS	Application Systems	2	AWTYP	WFM Application Category	nvarchar	5	0
303	/SAPAPO/LRPAWTY	WFM Application Categories	1	AWTYP	WFD Application Category	nvarchar	5	0
304	/SAPAPO/LRPDEMH	LRP Requirements	17	AWTYP	WFM Application Category	nvarchar	5	0
305	/SAPAPO/LRPGWAFN	RFC Function Names of WFM GW Applications	1	AWTYP	WFM Application Category	nvarchar	5	0
306	/SAPAPO/LRPGWEXT	Information on How to Communicate with WFM GW Applications	3	AWTYP	WFM Application Category	nvarchar	5	0
307	/SAPAPO/LRPGWPRE	Mapping of Prefix for GWI Applications to Application Cat.	1	AWTYP	WFM Application Category	nvarchar	5	0
308	/SAPAPO/LRPGWREA	Response to Data from Groupware	1	AWTYP	WFM Application Category	nvarchar	5	0
309	/SAPAPO/LRPGWRES	Resource Information for GW Integration	4	AWTYP	WFM Application Category	nvarchar	5	0
310	/SAPAPO/LRPGWWOP	Proxy for Workforce Management Objects	7	AWTYP	WFM Application Category	nvarchar	5	0
311	/SAPAPO/LRPMAPS1	Text Table for Application Status	2	AWTYP	WFM Application Category	nvarchar	5	0
312	/SAPAPO/LRPMAPSD	Mapping Rules of Applications for Applications of Core St.	2	AWTYP	WFM Application Category	nvarchar	5	0
313	/SAPAPO/LRPMAPST	Mapping Table of LRP for Appl. Status for Core Status	2	AWTYP	WFM Application Category	nvarchar	5	0
314	/SAPAPO/LRPOTCH	Timespec types to exclude from OT	2	AWTYP	WFM Application Category	nvarchar	5	0
315	/SAPAPO/LRPRESO	Key and Descriptive Data for a Resource	10	AWTYP	WFM Application Category	nvarchar	5	0
316	/SAPAPO/LRPRSMAP	Mapping Table for WFM Resources	3	AWTYP	WFM Application Category	nvarchar	5	0
317	/SAPAPO/LRPRTSAT	Attributes for a Requirement's Time Data	19	AWTYP	WFM Application Category	nvarchar	5	0
318	/SAPAPO/LRPSMAP	Obsolete: Mapping Table of LRP Naming Service (Short Names)	3	AWTYP	WFM Application Category	nvarchar	5	0
319	/SAPAPO/LRPSTSAT	Attributes for Resource's Time Data	19	AWTYP	WFM Application Category	nvarchar	5	0
320	/SAPAPO/LRPSUBID	Table for Subscription of Concrete Subjects	5	AWTYP	WFM Application Category	nvarchar	5	0
321	/SAPAPO/LRPSUBTY	Table for Subscription of Generic Subjects	5	AWTYP	WFM Application Category	nvarchar	5	0
322	/SAPAPO/LRPTAWTY	Text Table for LRP Application Categories	1	AWTYP	WFM Application Category	nvarchar	5	0
323	/SAPAPO/LRPTSMAP	Mapping Table for WFM Time Specifications	3	AWTYP	WFM Application Category	nvarchar	5	0
324	/SAPAPO/TSTGWRES	Resource Information for GW Integration	4	AWTYP	WFM Application Category	nvarchar	5	0
325	/SAPAPO/TSTRESO	Key and Descriptive Data for a Resource	10	AWTYP	WFM Application Category	nvarchar	5	0
326	WFDC_PLGS_SEQ_LC	LRP Strategy: Sequence of Planning Steps for LC	2	AWTYP	WFD Application Category	nvarchar	5	0
327	WFDC_STRG	Scheduling Strategy	2	AWTYP	WFD Application Category	nvarchar	5	0
328	WFDC_STRG_LC	LRP Strategies Supported by the LC Dispatcher	2	AWTYP	WFD Application Category	nvarchar	5	0
329	WFDC_STRG_T	Scheduling Strategy Text	2	AWTYP	WFD Application Category	nvarchar	5	0
330	WFDSC_GW_ENABLE	Enable Groupware Message Automation	2	AWTYP	Application Type	nvarchar	5	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

330 columns | ERP 6.0 | AWTYP