	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

123 columns | ERP 6.0 | NPLNR

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/OPT/VIM_1ITEM_S	Document Item	41	NPLNR	Network Number for Account Assignment	nvarchar	12	0
2	/OPT/VIM_TITEM	Document Item	41	NPLNR	Network Number for Account Assignment	nvarchar	12	0
3	AUAA	Settlement Document: Receiver Segment	26	NPLNR	Network Number for Account Assignment	nvarchar	12	0
4	BSAD_BAK	Accounting: Secondary index for customers (cleared items)	97	NPLNR	Network Number for Account Assignment	nvarchar	12	0
5	BSAK_BAK	Accounting: Secondary Index for Vendors (Cleared Items)	101	NPLNR	Network Number for Account Assignment	nvarchar	12	0
6	BSEG	Accounting Document Segment	223	NPLNR	Network Number for Account Assignment	nvarchar	12	0
7	BSID_BAK	Accounting: Secondary Index for Customers	97	NPLNR	Network Number for Account Assignment	nvarchar	12	0
8	BSIK_BAK	Accounting: Secondary index for vendors	101	NPLNR	Network Number for Account Assignment	nvarchar	12	0
9	BSSEG	Accounting Document Segment	212	NPLNR	Network Number for Account Assignment	nvarchar	12	0
10	FUDT_VDOCBSEG	Verification Document Item with Additional Info	212	NPLNR	Network Number for Account Assignment	nvarchar	12	0
11	FUDT_VDOCBSEGEV	Verification Document Item in the Entry View	212	NPLNR	Network Number for Account Assignment	nvarchar	12	0
12	FUDT_VDOCBSEGH	Verification Document Segment with Additional Info(History)	212	NPLNR	Network Number for Account Assignment	nvarchar	12	0
13	GLPOS_C_CT	FI Document: Entry View	181	NPLNR	Network Number for Account Assignment	nvarchar	12	0
14	GLPOS_C_DEB_CT	GLPOS_C_CT Customer Line Items	181	NPLNR	Network Number for Account Assignment	nvarchar	12	0
15	GLPOS_C_GL_CT	GLPOS_C_CT G/L Line Items	181	NPLNR	Network Number for Account Assignment	nvarchar	12	0
16	GLPOS_C_VEN_CT	GLPOS_C_CT Vendor Line Items	181	NPLNR	Network Number for Account Assignment	nvarchar	12	0
17	GLPOS_N_CT	New General Ledger: Line Item with Currency Type	184	NPLNR	Network Number for Account Assignment	nvarchar	12	0
18	GLPOS_N_GL_CT	New General Ledger: Line Item with Currency Type	184	NPLNR	Network Number for Account Assignment	nvarchar	12	0
19	P2B2_C1	HCM Declustering B2 - Cost Distribution Table C1	15	NPLNR	Network Number for Account Assignment	nvarchar	12	0
20	P2B2_CWST	HCM Declustering B2 - PDC Time Tickets	103	NPLNR	Network Number for Account Assignment	nvarchar	12	0
21	P2B2_WST	HCM Declustering B2 - PDC Time Tickets	103	NPLNR	Network Number for Account Assignment	nvarchar	12	0
22	P2PL_RETROADJ	Payroll Result PL: Retro, originals and changes	25	NPLNR	Network Number for Account Assignment	nvarchar	12	0
23	P2PL_RETRODIF	Payroll Result PL: Retro, originals and changes	25	NPLNR	Network Number for Account Assignment	nvarchar	12	0
24	P2PL_RETROMEM	Payroll Result PL: Retro, originals and changes	25	NPLNR	Network Number for Account Assignment	nvarchar	12	0
25	P2RG_COSTS	Distribution of Employer's Cost (Payroll Function XDEC)	32	NPLNR	Network Number for Account Assignment	nvarchar	12	0
26	P2RT_CZDAV	P18_03	16	NPLNR	Network Number for Account Assignment	nvarchar	12	0
27	P2RU_COSTS	Distribution of Employer's Cost (Payroll Function XDEC)	32	NPLNR	Network Number for Account Assignment	nvarchar	12	0
28	P2RX_C1	Cost Distribution Table C1	13	NPLNR	Network Number for Account Assignment	nvarchar	12	0
29	P2RX_FUND	Accounting Structure for Funds Management	25	NPLNR	Network Number for Account Assignment	nvarchar	12	0
30	REGUP	Processed items from payment program	99	NPLNR	Network Number for Account Assignment	nvarchar	12	0
31	YVIM_1ITEM	Document Item	41	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPAccounting Interface
32	GLE_FI_ITEM_MODF	ECS: Modified FI Line Items (Header/Item/Currency Data)	176	NPLNR	Network Number for Account Assignment	nvarchar	12	0
33	GLE_FI_ITEM_ORIG	ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)	176	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPActual CostingMaterial Ledger
34	MLCO	Material valuation document account assignment information	23	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPAlternative Valuation Run
35	CKMLAVRDOCIT	Lines for Cumulation Posting Document	49	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPConfirmations
36	AFRV	Confirmation pool	23	NPLNR	Network Number for Account Assignment	nvarchar	12	0
37	AFRV_DEL	Backup Copy for Confirmation Pool	23	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPConstruction Industry
38	T5DB4	HR Construction Site File	7	NPLNR	Network Number for Account Assignment	nvarchar	12	0
39	T5DB8	Construction Sector: Team Assignment to Work Site	29	NPLNR	Network Number for Account Assignment	nvarchar	12	0
40	T5DBV	Construction Pay: Cost Assignment: Hostels	12	NPLNR	Network Number for Account Assignment	nvarchar	12	0
41	T5DBX	Construction Pay: Incentive Wage Connection	12	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPCross-Application Components
42	BBSID	Accounting: Secondary index for customers	97	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPData Retention Tool
43	TXW_S_BSEG	Retrieve BSEG from archive	67	NPLNR	Network Number for Account Assignment	nvarchar	12	0
44	TXW_S_MSEG	Retrieve MSEG from archive	40	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPData Transfer
45	PPDIT	Transfer to Accounting: Lines in HR IDOCs	21	NPLNR	Network Number for Account Assignment	nvarchar	12	0
46	PPDST	Transfer to Accounting: Substituted Acc. Assig. Object	10	NPLNR	Network Number for Account Assignment	nvarchar	12	0
47	PPKIX	Transfer FI/CO: Index of Account Assignment Combinations	12	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPElectronic Bank Statement
48	FEB_ACCNT_SAVE	Saving of Posting Lines for Postprocessing (Account Assign.)	32	NPLNR	Network Number for Account Assignment	nvarchar	12	0
49	FEB_ACT	Acct Assignment Templates	32	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPExternal Services
50	ESKN	Account Assignment in Service Package	28	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPFinancial Accounting
51	/OPT/VIM_1ITEM	Document Item	41	NPLNR	Network Number for Account Assignment	nvarchar	12	0
52	ACCTIT	Compressed Data from FI/CO Document	67	NPLNR	Network Number for Account Assignment	nvarchar	12	0
53	BSAD	Accounting: Secondary Index for Customers (Cleared Items)	97	NPLNR	Network Number for Account Assignment	nvarchar	12	0
54	BSAK	Accounting: Secondary Index for Vendors (Cleared Items)	101	NPLNR	Network Number for Account Assignment	nvarchar	12	0
55	BSID	Accounting: Secondary Index for Customers	97	NPLNR	Network Number for Account Assignment	nvarchar	12	0
56	BSIK	Accounting: Secondary Index for Vendors	101	NPLNR	Network Number for Account Assignment	nvarchar	12	0
57	EBSEG	Doc.Segment of Fin.Accntng External Documents	69	NPLNR	Network Number for Account Assignment	nvarchar	12	0
58	KMZEI	FI: Account Assignment Model Item Information	47	NPLNR	Network Number for Account Assignment	nvarchar	12	0
59	KOMU	Account Assignment Templates for G/L Account Items	47	NPLNR	Network Number for Account Assignment	nvarchar	12	0
60	T076K	FI-EDI: Additional Account Assignments	15	NPLNR	Network Number for Account Assignment	nvarchar	12	0
61	VBSEGA	Document Segment for Document Parking - Asset Database	50	NPLNR	Network Number for Account Assignment	nvarchar	12	0
62	VBSEGS	Document Segment for Document Parking - G/L Account Database	76	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPFreight Processing
63	VFKN	Account Determination in Shipment Costs Item	26	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPFunds Management
64	KBLP	Document Item: Manual Document Entry	39	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPFunds Management-Specific Postings
65	FMFUNDTRANSYEAR	Additional Documents for Funds Transfer to Diff. Years	75	NPLNR	Network Number for Account Assignment	nvarchar	12	0
66	PSOSEGS	Recurring Request Document Segment, G/L Accounts	74	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPGeneral Ledger Accounting
67	BSEG_ADD	Entry View of Accounting Document for Additional Ledgers	45	NPLNR	Network Number for Account Assignment	nvarchar	12	0
68	FAGL_SPLINFO	Splittling Information of Open Items	24	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPGeneral Ledger Reorganization
69	FAGL_R_SPL	Reorganization: Splitting Information of the Open Items	21	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPGL Account Posting
70	TCJ_POSITIONS	Cash Journal Document Items	39	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPInterest
71	TZIN1	Document Header Data from Source Document (PS Int.Calc.)	20	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPInventory Management
72	MSEG	Document Segment: Material	114	NPLNR	Network Number for Account Assignment	nvarchar	12	0
73	MWXMSEG	ZMSEG: Interface for Posting of Value	114	NPLNR	Network Number for Account Assignment	nvarchar	12	0
74	MWZMSEG	ZMSEG:Interface for Posting of Value	114	NPLNR	Network Number for Account Assignment	nvarchar	12	0
75	RKPF	Document Header: Reservation	31	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPInvoice Verification
76	RBCO	Document Item, Incoming Invoice, Account Assignment	64	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPJapan
77	T7JPSK_CONTT	Shukko Contract Template	12	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPJoint Venture und Production Sharing Accounting
78	JVCO1	JV Object Table 2 for JVTO1	3	NPLNR	Network Number for Account Assignment	nvarchar	12	0
79	JVPO1	JVA: Plan Line Items	31	NPLNR	Network Number for Account Assignment	nvarchar	12	0
80	JVSO1	JV LI Table with Objects for JVTO1	31	NPLNR	Network Number for Account Assignment	nvarchar	12	0
81	JVTO1	JV Summary Table with Objects	28	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPLocal Currency Changeover
82	EWUFI_SCA	EMU conversion: Table of the clearings to be adjusted	20	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPLocalization
83	J_1BNFLIN	Nota Fiscal line items	93	NPLNR	Network Number for Account Assignment	nvarchar	12	0
84	J_1B_CIAP_OBJECT	CIAP document data	22	NPLNR	Network Number for Account Assignment	nvarchar	12	0
85	J_3RNDSINV	Target use of ingoing invoice positions for AuC	16	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPMaintenance Orders
86	AUFM	Goods movements for order	37	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPMaterials Management
87	J_1GVL_ML	Material Ledger	89	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPOverhead Cost Orders
88	COBRB	Distribution Rules Settlement Rule Order Settlement	41	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPPayment Transactions
89	CRACC	Payment Cards: Account Assignments in Card Master Record	29	NPLNR	Network Number for Account Assignment	nvarchar	12	0
90	CRNUM	Payment cards: Card master record	50	NPLNR	Network Number for Account Assignment	nvarchar	12	0
91	FPRL_ITEM	Item Data	57	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPPayroll
92	T5TPSC1SPLIT	Rozdelení nákladu	23	NPLNR	Cís.sít.diagramu pro prirazení úctu	nvarchar	12	0
TOPPersonnel Time Events
93	TPTCOR_KOSTL	Cost Assignment (Correction Scenario)	6	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPPersonnel Time Management
94	ASSOB	Assignment Objects	11	NPLNR	Network Number for Account Assignment	nvarchar	12	0
95	CC1ERP	Incorrect Time Events from CC1, Postings	105	NPLNR	Network Number for Account Assignment	nvarchar	12	0
96	CC1TEV	Temporary Buffer for Time Events from CC1	28	NPLNR	Network Number for Account Assignment	nvarchar	12	0
97	COIFT	Interface to Activity Allocation	43	NPLNR	Network Number for Account Assignment	nvarchar	12	0
98	PTEX2000	Interface Table for Attendances/Absences Infotype(2001/2002)	53	NPLNR	Network Number for Account Assignment	nvarchar	12	0
99	PTEX2003GEN	Interface Table for IT 2003: General Information	52	NPLNR	Network Number for Account Assignment	nvarchar	12	0
100	PTEX2003SPEC	Interface Table for IT 2003: Interval Information	28	NPLNR	Network Number for Account Assignment	nvarchar	12	0
101	PTEX2010	Interface Table for EE Remuneration Info. Infotype (2010)	52	NPLNR	Network Number for Account Assignment	nvarchar	12	0
102	TEVEN_MORE	Additional Data for Time Events	104	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPPlant Data Collection
103	RUECK	Temp. storage for subsystem confirmations	18	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPPosition Budgeting and Control
104	HRFPM_DIFFERENCE	HRFPM: Personnel Costs Savings/ Overrun	34	NPLNR	Network Number for Account Assignment	nvarchar	12	0
105	HRFPM_FM_POS	HRFPM: FM Documents - Items	18	NPLNR	Network Number for Account Assignment	nvarchar	12	0
106	HRFPM_FM_POS_BU	HRFPM: FM Documents - Items for Budget	19	NPLNR	Network Number for Account Assignment	nvarchar	12	0
107	HRFPM_FPM_POS	HRFPM: FPM Documents - Items	32	NPLNR	Network Number for Account Assignment	nvarchar	12	0
108	HRFPM_FPM_POS_BU	HRFPM: FPM Documents - Items for Budget	33	NPLNR	Network Number for Account Assignment	nvarchar	12	0
109	HRFPM_OBJECTS	HRFPM: Object table of the commitment engine	28	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPPurchasing
110	EBKN	Purchase Requisition Account Assignment	30	NPLNR	Network Number for Account Assignment	nvarchar	12	0
111	EKCPA	Purchasing Contract Commitment Plan Account Assignment Data	15	NPLNR	Network Number for Account Assignment	nvarchar	12	0
112	EKKN	Account Assignment in Purchasing Document	33	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPQuality Inspection
113	QALS	Inspection lot record	188	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPQuality Notifications
114	TQ8CO	Assignment of reference orders to notification type	10	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPRemaining Beverage - Obsolete Objects
115	/BEV3/CH1030BSG1	Document Segment CH Event Ledger Part1	214	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPRemote Logistics Management
116	OIO_RT_RTDOC_MT	Returns document - material items	17	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPRepetitive Manufacturing
117	COMPMOVE	Goods Movement of Components	119	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPSelf-Service Procurement
118	/SRMERP/D_ACC_IT	Account assignment item	27	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPSimulation
119	VSEBKN_CN	Version: Purchase requisition account assignment	31	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPSocial Insurance
120	T5D3P	HR Technical Assignments for Workers' Compensation Assoc.	7	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPTechnical Application Support
121	CNV_20425_SCA	EMU conversion: Table of the clearings to be adjusted	17	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPTravel Expenses
122	PTRV_DOC_IT	Transfer Travel -> FI/CO: Lines of TRV interm. document	20	NPLNR	Network Number for Account Assignment	nvarchar	12	0
TOPTravel Planning
123	FTPT_REQ_ACCOUNT	Travel Request Cost Assignment	15	NPLNR	Network Number for Account Assignment	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

123 columns | ERP 6.0 | NPLNR