	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

152 columns | ERP 6.0 | KDAUF

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/GEP/T_NEED	Graphischer Leitstand: Bedarfe (einzuplanende Objekte)	19	KDAUF	Verkaufsbeleg	nvarchar	10	0
2	/GEP/T_SPLIT	Graphischer Leitstand: Splits (eingeplante Objekte)	20	KDAUF	Verkaufsbeleg	nvarchar	10	0
3	/SMERP/STG_PM001	Data staging - Equipment complex table	192	KDAUF	Sales Order Number	nvarchar	10	0
4	/SMERP/STG_PM003	Data staging - Equipment List Set - Hdr - complex tab	186	KDAUF	Sales Order Number	nvarchar	10	0
5	AUAA	Settlement Document: Receiver Segment	29	KDAUF	Sales Order Number	nvarchar	10	0
6	GLPCA_CT	Profit Center Documents	77	KDAUF	Sales Order Number	nvarchar	10	0
7	GLPCA_T_CT	Profit Center Documents	93	KDAUF	Sales Order Number	nvarchar	10	0
8	P2B2_C1	HCM Declustering B2 - Cost Distribution Table C1	17	KDAUF	Sales Order Number	nvarchar	10	0
9	P2B2_CWST	HCM Declustering B2 - PDC Time Tickets	105	KDAUF	Sales Order Number	nvarchar	10	0
10	P2B2_WST	HCM Declustering B2 - PDC Time Tickets	105	KDAUF	Sales Order Number	nvarchar	10	0
11	P2PL_RETROADJ	Payroll Result PL: Retro, originals and changes	27	KDAUF	Sales Order Number	nvarchar	10	0
12	P2PL_RETRODIF	Payroll Result PL: Retro, originals and changes	27	KDAUF	Sales Order Number	nvarchar	10	0
13	P2PL_RETROMEM	Payroll Result PL: Retro, originals and changes	27	KDAUF	Sales Order Number	nvarchar	10	0
14	P2RG_COSTS	Distribution of Employer's Cost (Payroll Function XDEC)	34	KDAUF	Sales Order Number	nvarchar	10	0
15	P2RT_CZDAV	P18_03	18	KDAUF	Sales Order Number	nvarchar	10	0
16	P2RU_COSTS	Distribution of Employer's Cost (Payroll Function XDEC)	34	KDAUF	Sales Order Number	nvarchar	10	0
17	P2RX_C1	Cost Distribution Table C1	15	KDAUF	Sales Order Number	nvarchar	10	0
18	S980	ORDRES DE FABRICATION	52	KDAUF	Numéro de la commande client	nvarchar	10	0
19	S981	OF ARTICLES POSTES	62	KDAUF	Numéro de la commande client	nvarchar	10	0
20	ZEIM_AFPO	Order item	11	KDAUF	Sales order number	nvarchar	10	0
21	ZEIM_LIPS	SD document: Delivery: Item data	109	KDAUF	Sales Order Number	nvarchar	10	0
TOPAccounting Interface
22	GLE_FI_ITEM_MODF	ECS: Modified FI Line Items (Header/Item/Currency Data)	195	KDAUF	Sales Order Number	nvarchar	10	0
23	GLE_FI_ITEM_ORIG	ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)	195	KDAUF	Sales Order Number	nvarchar	10	0
TOPActual CostingMaterial Ledger
24	CKMLDUVCO	Usage Differences for Each Account Assignment Object	17	KDAUF	Sales Order Number	nvarchar	10	0
25	CKMLMV013	Assignment table: Process for production order	14	KDAUF	Sales order number	nvarchar	10	0
26	FCML_ALT	Alternatives	17	KDAUF	Sales Document Number (Alternative)	nvarchar	10	0
27	FCML_PROC	Business Processes	19	KDAUF	Sales Document Number (Process)	nvarchar	10	0
28	MLCO	Material valuation document account assignment information	28	KDAUF	Sales Order Number	nvarchar	10	0
TOPAlternative Valuation Run
29	CKMLAVRDOCIT	Lines for Cumulation Posting Document	52	KDAUF	Sales Order Number	nvarchar	10	0
TOPConfirmations
30	AFFW	Goods Movements with Errors from Confirmations	15	KDAUF	Sales Order Number	nvarchar	10	0
31	AFRV	Confirmation pool	25	KDAUF	Sales Order Number	nvarchar	10	0
32	AFRV_DEL	Backup Copy for Confirmation Pool	25	KDAUF	Sales Order Number	nvarchar	10	0
TOPConstruction Industry
33	T5DB4	HR Construction Site File	9	KDAUF	Sales Order Number	nvarchar	10	0
34	T5DB8	Construction Sector: Team Assignment to Work Site	32	KDAUF	Sales Order Number	nvarchar	10	0
35	T5DBV	Construction Pay: Cost Assignment: Hostels	14	KDAUF	Sales Order Number	nvarchar	10	0
36	T5DBX	Construction Pay: Incentive Wage Connection	14	KDAUF	Sales Order Number	nvarchar	10	0
TOPContract Accounts Receivable and Payable
37	DFKKDEFREV_POS	Line Item Table (Event-Based Deferred Revenues)	32	KDAUF	Sales Order Number	nvarchar	10	0
38	DFKKMOPK	Items in contract account document	11	KDAUF	Sales Order Number	nvarchar	10	0
39	DFKKOPK	Items in contract account document	11	KDAUF	Sales Order Number	nvarchar	10	0
40	DFKKORDERPOS	Requests: Items	48	KDAUF	Sales Order Number	nvarchar	10	0
41	DFKKORDERPOS_S	Request Templates: Items	42	KDAUF	Sales Order Number	nvarchar	10	0
42	DFKKSUM	Posting totals from FI-CA	20	KDAUF	Sales Order Number	nvarchar	10	0
43	DFKKSUMOLD	Totals Records Without Account Assignment Changes	7	KDAUF	Sales Order Number	nvarchar	10	0
44	FKKDEFREV	Trigger Table for Deferred Revenue Postings	20	KDAUF	Sales Order Number	nvarchar	10	0
TOPCost Object
45	FCO_DOC_HEAD	Failure Cost Document Header	10	KDAUF	Sales Order Number	nvarchar	10	0
TOPCross-Application Components
46	AAUUFK	Order master data	70	KDAUF	Sales Order Number	nvarchar	10	0
TOPData Collection
47	S225	Goods receipts: repetitive manufacturing	14	KDAUF	Sales order number	nvarchar	10	0
48	S225E	S225 - Structural Information	9	KDAUF	Sales order number	nvarchar	10	0
49	S226	Material usage: repetitive manufacturing	12	KDAUF	Sales order number	nvarchar	10	0
50	S226E	S226 - Structural Information	7	KDAUF	Sales order number	nvarchar	10	0
51	S227	Product costs: repetitive manufacturing	13	KDAUF	Sales order number	nvarchar	10	0
52	S227E	S227 - Structural Information	8	KDAUF	Sales order number	nvarchar	10	0
53	S279	Transfer BW: Bestandsführung	37	KDAUF	Klantordernummer	nvarchar	10	0
54	S279BIW1	S279BIW1 * BW Transfer: Inventory Management	37	KDAUF	Sales Order Number	nvarchar	10	0
55	S279BIW2	S279BIW2 * BW Transfer: Inventory Management	37	KDAUF	Sales Order Number	nvarchar	10	0
TOPData Retention Tool
56	TXW_S_MSEG	Retrieve MSEG from archive	34	KDAUF	Sales Order Number	nvarchar	10	0
TOPData Transfer
57	PPDIT	Transfer to Accounting: Lines in HR IDOCs	23	KDAUF	Sales Order Number	nvarchar	10	0
58	PPDST	Transfer to Accounting: Substituted Acc. Assig. Object	12	KDAUF	Sales Order Number	nvarchar	10	0
59	PPKIX	Transfer FI/CO: Index of Account Assignment Combinations	14	KDAUF	Sales Order Number	nvarchar	10	0
TOPDemand Management
60	PBID	Planned independent requirements index: MRP area	33	KDAUF	Sales Order Number	nvarchar	10	0
61	PBIM	Independent Requirements for Material	31	KDAUF	Sales Order Number	nvarchar	10	0
TOPDistribution of Usage Variances
62	CKMLDUVNCO	Usage Differences for Each Account Assignment Object	17	KDAUF	Sales Order Number	nvarchar	10	0
TOPElectronic Bank Statement
63	FEB_ACCNT_SAVE	Saving of Posting Lines for Postprocessing (Account Assign.)	44	KDAUF	Sales Order Number	nvarchar	10	0
64	FEB_ACT	Acct Assignment Templates	44	KDAUF	Sales Order Number	nvarchar	10	0
TOPExchanges
65	OIA12I	Movement Based Netting document item	18	KDAUF	Sales Order Number	nvarchar	10	0
66	OIAQB	Exchange Movements Index	25	KDAUF	Sales Order Number	nvarchar	10	0
TOPFinancial Accounting
67	ACCTIT	Compressed Data from FI/CO Document	70	KDAUF	Sales Order Number	nvarchar	10	0
68	T076K	FI-EDI: Additional Account Assignments	11	KDAUF	Sales Order Number	nvarchar	10	0
69	VBSEGA	Document Segment for Document Parking - Asset Database	46	KDAUF	Sales Order Number	nvarchar	10	0
70	VBSEGS	Document Segment for Document Parking - G/L Account Database	37	KDAUF	Sales Order Number	nvarchar	10	0
TOPFunds Management-Specific Postings
71	FMFUNDTRANSYEAR	Additional Documents for Funds Transfer to Diff. Years	38	KDAUF	Sales Order Number	nvarchar	10	0
72	PSOSEGS	Recurring Request Document Segment, G/L Accounts	37	KDAUF	Sales Order Number	nvarchar	10	0
TOPGeneral Ledger Accounting
73	FAGL_SPLINFO	Splittling Information of Open Items	20	KDAUF	Sales Order Number	nvarchar	10	0
TOPGeneral Ledger Reorganization
74	FAGL_R_SPL	Reorganization: Splitting Information of the Open Items	24	KDAUF	Sales Order Number	nvarchar	10	0
TOPGL Account Posting
75	TCJ_POSITIONS	Cash Journal Document Items	51	KDAUF	Sales Order Number	nvarchar	10	0
TOPInformation System
76	MCAFPOV	Versions: Order Item	28	KDAUF	Sales order number	nvarchar	10	0
77	MCCOMPV	Versions: Material Components	18	KDAUF	Sales Order Number	nvarchar	10	0
78	MCSFIS	R/2 SFIS Data: Old	62	KDAUF	Sales order number	nvarchar	10	0
TOPInterface to Terminal Automation System
79	OIK02B	IS-OIL/TAS: Status of processed functions - messages	18	KDAUF	Sales Order Number	nvarchar	10	0
80	OIK29	IS-OIL/TPI: Status of processed inbound IDoc OILSHI01	9	KDAUF	Sales Document	nvarchar	10	0
81	OIK29C	IS-OIL/TPI: Status of processed functions - messages	17	KDAUF	Sales Order Number	nvarchar	10	0
82	OIK29D	IS-OIL/TPI: Status of processed inbound IDoc OILSHI01	10	KDAUF	Sales Document	nvarchar	10	0
TOPInventory Management
83	CHVW	Table CHVW for Batch Where-Used List	10	KDAUF	Sales Order Number	nvarchar	10	0
84	ISEG	Physical Inventory Document Items	11	KDAUF	Sales Order Number	nvarchar	10	0
85	MSEG	Document Segment: Material	21	KDAUF	Sales Order Number	nvarchar	10	0
86	MWXMSEG	ZMSEG: Interface for Posting of Value	21	KDAUF	Sales Order Number	nvarchar	10	0
87	MWZMSEG	ZMSEG:Interface for Posting of Value	21	KDAUF	Sales Order Number	nvarchar	10	0
88	RESB	Reservation/dependent requirements	34	KDAUF	Sales Order Number	nvarchar	10	0
89	RKPF	Document Header: Reservation	17	KDAUF	Sales Order Number	nvarchar	10	0
TOPLogistics Information System LIS
90	S280	Order header and item, BW	52	KDAUF	Sales order number	nvarchar	10	0
91	S280BIW1	S280BIW1 * Order header and item, BW	52	KDAUF	Sales order number	nvarchar	10	0
92	S280BIW2	S280BIW2 * Order Header and Item, BW	52	KDAUF	Sales order number	nvarchar	10	0
93	S281	Order Operation, BW	62	KDAUF	Sales order number	nvarchar	10	0
94	S281BIW1	S281BIW1 * Order Process, BW	62	KDAUF	Sales order number	nvarchar	10	0
95	S281BIW2	S281BIW2 * Order Process, BW	62	KDAUF	Sales order number	nvarchar	10	0
96	S282	Order Component, BW	20	KDAUF	Sales order number	nvarchar	10	0
97	S282BIW1	S282BIW1 * Order Components, BW	20	KDAUF	Sales order number	nvarchar	10	0
98	S282BIW2	S282BIW2 * Order Components, BW	20	KDAUF	Sales order number	nvarchar	10	0
TOPMaintenance Notifications
99	QMIH	Quality message - maintenance data excerpt	31	KDAUF	Sales Document	nvarchar	10	0
TOPMaintenance Orders
100	AUFM	Goods movements for order	14	KDAUF	Sales Order Number	nvarchar	10	0
TOPMaintenance Program Definition
101	MPDITEM	Maintenance Plan Items	12	KDAUF	Sales Document	nvarchar	10	0
TOPMaintenance Task Lists
102	MPOS	Maintenance item	39	KDAUF	Sales Document	nvarchar	10	0
TOPMaster Data
103	BLPK	Document log header	11	KDAUF	Sales and Distribution Document Number	nvarchar	10	0
104	KBVL	Individual Customer Plng File Entry, MRP Area Long-Term Plng	7	KDAUF	Sales Order Number	nvarchar	10	0
105	KBVM	Individual Customer Planning File Entry, MRP Area	6	KDAUF	Sales Order Number	nvarchar	10	0
106	KDPL	Index customer order -> planned order	2	KDAUF	Sales Order Number	nvarchar	10	0
107	KDVL	Individual Customer Planning File Entry, Long-Term Planning	5	KDAUF	Sales Order Number	nvarchar	10	0
108	KDVM	Individual Customer Planning File Entry	4	KDAUF	Sales Order Number	nvarchar	10	0
109	MDSM	Simulative dependent requirements	90	KDAUF	Sales Order Number	nvarchar	10	0
110	PLAF	Planned Order	22	KDAUF	Sales Order Number	nvarchar	10	0
111	PSPL	Index project -> planned order	7	KDAUF	Sales Order Number	nvarchar	10	0
112	PUMS	Project number new key assignment (structure)	2	KDAUF	Sales Order Number	nvarchar	10	0
TOPMaterials Management
113	/ISDFPS/CHVW_E	External Batch Where-Used List	10	KDAUF	Sales Order Number	nvarchar	10	0
114	J_1GVL_ML	Material Ledger	93	KDAUF	Sales Order Number	nvarchar	10	0
TOPOverhead Cost Orders
115	AUFK	Order master data	70	KDAUF	Sales Order Number	nvarchar	10	0
116	COBRB	Distribution Rules Settlement Rule Order Settlement	46	KDAUF	Sales Order Number	nvarchar	10	0
TOPPayroll
117	T5TPSC1SPLIT	Rozdelení nákladu	25	KDAUF	Císlo zakázky odberatele	nvarchar	10	0
TOPPersonnel Time Events
118	TPTCOR_KOSTL	Cost Assignment (Correction Scenario)	7	KDAUF	Sales Order Number	nvarchar	10	0
TOPPersonnel Time Management
119	ASSOB	Assignment Objects	13	KDAUF	Sales Order Number	nvarchar	10	0
120	CC1ERP	Incorrect Time Events from CC1, Postings	106	KDAUF	Sales Order Number	nvarchar	10	0
121	CC1TEV	Temporary Buffer for Time Events from CC1	30	KDAUF	Sales Order Number	nvarchar	10	0
122	COIFT	Interface to Activity Allocation	45	KDAUF	Sales Order Number	nvarchar	10	0
123	PTEX2000	Interface Table for Attendances/Absences Infotype(2001/2002)	55	KDAUF	Sales Order Number	nvarchar	10	0
124	PTEX2003GEN	Interface Table for IT 2003: General Information	54	KDAUF	Sales Order Number	nvarchar	10	0
125	PTEX2003SPEC	Interface Table for IT 2003: Interval Information	30	KDAUF	Sales Order Number	nvarchar	10	0
126	PTEX2010	Interface Table for EE Remuneration Info. Infotype (2010)	54	KDAUF	Sales Order Number	nvarchar	10	0
127	TEVEN_MORE	Additional Data for Time Events	105	KDAUF	Sales Order Number	nvarchar	10	0
TOPPlant Data Collection
128	RUECK	Temp. storage for subsystem confirmations	20	KDAUF	Sales Order Number	nvarchar	10	0
TOPProduction Backflush
129	PPC_COMAT	Maximum Bill of Material of Backflushed Materials (for CO)	8	KDAUF	Sales Order Number	nvarchar	10	0
130	PPC_HEAD	Document PP Backflush - Header	13	KDAUF	Sales Order Number	nvarchar	10	0
131	PPC_MAT_DET	Super BOM: Special Account/Batch Information	4	KDAUF	Sales Order Number	nvarchar	10	0
132	PPC_STEP2	Goods Movements Table for New PPCGO Logic (2 Steps)	14	KDAUF	Sales Order Number	nvarchar	10	0
TOPProduction Orders
133	AFPO	Order item	11	KDAUF	Sales order number	nvarchar	10	0
TOPProfit Center Accounting
134	GLPCA	EC-PCA: Actual Line Items	72	KDAUF	Sales Order Number	nvarchar	10	0
135	GLPCP	EC-PCA: Plan Line Items	130	KDAUF	Sales Order Number	nvarchar	10	0
TOPProfitability Analysis Basic Functions
136	K840001	Summarization level KT: 800 KK 01 KKROBJ 000001	12	KDAUF	Sales Order Number	nvarchar	10	0
137	K840005	Summarization level KT: 800 KK 01 KKROBJ 000003	12	KDAUF	Sales Order Number	nvarchar	10	0
138	K840009	Summarization level KT: 800 KK 01 KKROBJ 000005	12	KDAUF	Sales Order Number	nvarchar	10	0
TOPQuality Inspection
139	QALS	Inspection lot record	110	KDAUF	Sales Order Number of Valuated Sales Order Stock	nvarchar	10	0
TOPQuality Notifications
140	TQ8CO	Assignment of reference orders to notification type	12	KDAUF	Sales Order Number	nvarchar	10	0
TOPRepetitive Manufacturing
141	COMPMOVE	Goods Movement of Components	116	KDAUF	Sales Order Number	nvarchar	10	0
142	RMUSER	User Settings for REM Backflush Transactions	7	KDAUF	Sales Order Number	nvarchar	10	0
TOPSerial Numbers
143	EQBS	Serial Number Stock Segment	10	KDAUF	Sales Order Number	nvarchar	10	0
TOPShipping
144	LIPS	SD document: Delivery: Item data	109	KDAUF	Sales Order Number	nvarchar	10	0
TOPSimulation
145	VSAFPO_CN	Version: Order items in PP orders	12	KDAUF	Sales order number	nvarchar	10	0
146	VSAUFK_CN	Version: Order master data	71	KDAUF	Sales Order Number	nvarchar	10	0
147	VSPLAF_CN	Version: Planned order	23	KDAUF	Sales Order Number	nvarchar	10	0
148	VSRESB_CN	Version: Reservation/Dependent requirements	35	KDAUF	Sales Order Number	nvarchar	10	0
TOPSocial Insurance
149	T5D3P	HR Technical Assignments for Workers' Compensation Assoc.	9	KDAUF	Sales Order Number	nvarchar	10	0
TOPTariffs, Duties and Permits
150	OIH14	Tax rate revaluation - obsolete	9	KDAUF	Sales Order Number	nvarchar	10	0
TOPTravel Expenses
151	PTRV_DOC_IT	Transfer Travel -> FI/CO: Lines of TRV interm. document	22	KDAUF	Sales Order Number	nvarchar	10	0
TOPTravel Planning
152	FTPT_REQ_ACCOUNT	Travel Request Cost Assignment	17	KDAUF	Sales Order Number	nvarchar	10	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

152 columns | ERP 6.0 | KDAUF