ERP 6.0: Top 10 requests

	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

B1 9.2: Top 10 requests

	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	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

B1 8.8: Top 10 requests

	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

	Product	Version	Table	Columns	Indexes	Description	Module
Production Planning and Control :: Material Requirements Planning :: Master Data
1	ERP EHP7	6.0	PLAF	123	3	Planned Order	Master Data

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	PLNUM	Planned order number	nvarchar	10	0	Allow NULL?
3	MATNR	Planning material	nvarchar	18	0	Allow NULL?
4	PLWRK	Planning Plant	nvarchar	4	0	Allow NULL?
5	PWWRK	Production plant in planned order	nvarchar	4	0	Allow NULL?
6	PAART	Order type	nvarchar	4	0	Allow NULL?
7	BESKZ	Procurement Type	char	1	0	Allow NULL?
8	SOBES	Special procurement type	char	1	0	Allow NULL?
9	GSMNG	Total planned order quantity	decimal	13	3
10	TLMNG	Partial lot quantity	decimal	13	3
11	AVMNG	Fixed quantity of scrap from production	decimal	13	3
12	BDMNG	Requirement Quantity	decimal	13	3
13	PSTTR	Order start date in planned order	nvarchar	8	0	Allow NULL?
14	PEDTR	Order finish date in the planned order	nvarchar	8	0	Allow NULL?
15	PERTR	Planned opening date in planned order	nvarchar	8	0	Allow NULL?
16	WEBAZ	Goods receipt processing time in days	decimal	3	0
17	DISPO	MRP Controller (Materials Planner)	nvarchar	3	0	Allow NULL?
18	UMSKZ	Conversion indicator for planned order	char	1	0	Allow NULL?
19	AUFFX	Firming indicator for planned order data	char	1	0	Allow NULL?
20	STLFX	Fixing indicator for BOM explosion	char	1	0	Allow NULL?
21	KNTTP	Account Assignment Category	char	1	0	Allow NULL?
22	KDAUF	Sales Order Number	nvarchar	10	0	Allow NULL?
23	KDPOS	Item Number in Sales Order	nvarchar	6	0	Allow NULL?
24	KDEIN	Delivery Schedule for Sales Order	nvarchar	4	0	Allow NULL?
25	PROJN	Old: Project number : No longer used --> PS_POSNR	nvarchar	16	0	Allow NULL?
26	RSNUM	Number of Reservation/Dependent Requirement	nvarchar	10	0	Allow NULL?
27	QUNUM	Number of Quota Arrangement	nvarchar	10	0	Allow NULL?
28	QUPOS	Quota Arrangement Item	nvarchar	3	0	Allow NULL?
29	FLIEF	Fixed Vendor	nvarchar	10	0	Allow NULL?
30	KONNR	Number of Principal Purchase Agreement	nvarchar	10	0	Allow NULL?
31	KTPNR	Item Number of Principal Purchase Agreement	nvarchar	5	0	Allow NULL?
32	EKORG	Purchasing Organization	nvarchar	4	0	Allow NULL?
33	LGORT	Storage Location	nvarchar	4	0	Allow NULL?
34	NUMVR	Version number	nvarchar	2	0	Allow NULL?
35	KZVBR	Consumption Posting	char	1	0	Allow NULL?
36	SOBKZ	Special Stock Indicator	char	1	0	Allow NULL?
37	PSPEL	WBS Element	nvarchar	8	0	Allow NULL?
38	SERNR	BOM explosion number	nvarchar	8	0	Allow NULL?
39	PALTR	Explosion date	nvarchar	8	0	Allow NULL?
40	TECHS	Parameter Variant/Standard Variant	nvarchar	12	0	Allow NULL?
41	STLAN	BOM Usage	char	1	0	Allow NULL?
42	STALT	Alternative BOM	nvarchar	2	0	Allow NULL?
43	STSTA	BOM status	nvarchar	2	0	Allow NULL?
44	AENNR	Change Number	nvarchar	12	0	Allow NULL?
45	ARSNR	Settlement reservation number	nvarchar	10	0	Allow NULL?
46	ARSPS	Item number of the settlement reservation	nvarchar	4	0	Allow NULL?
47	VERTO	Distribution key for quantity produced	nvarchar	4	0	Allow NULL?
48	VERID	Production Version	nvarchar	4	0	Allow NULL?
49	AUFNR	Run schedule header number	nvarchar	12	0	Allow NULL?
50	TRART	Scheduling type of the planned order	char	1	0	Allow NULL?
51	PLGRP	Production Supervisor	nvarchar	3	0	Allow NULL?
52	TERST	Start date for production	nvarchar	8	0	Allow NULL?
53	TERED	Finish date for production	nvarchar	8	0	Allow NULL?
54	BEDID	ID of the capacity requirements record	nvarchar	12	0	Allow NULL?
55	AUFPL	Routing number of operations in the order	nvarchar	10	0	Allow NULL?
56	LINID	ID for a schedule record	nvarchar	15	0	Allow NULL?
57	TRMKZ	Scheduling indicator	char	1	0	Allow NULL?
58	TRMER	Scheduling error	nvarchar	2	0	Allow NULL?
59	REDKZ	Reduction indicator for scheduling	char	1	0	Allow NULL?
60	TRMHK	Scheduling source	char	1	0	Allow NULL?
61	PLNNR	Key for Task List Group	nvarchar	8	0	Allow NULL?
62	PLNAL	Group Counter	nvarchar	2	0	Allow NULL?
63	PLNTY	Task List Type	char	1	0	Allow NULL?
64	FRTHW	Production note in the planned order	char	1	0	Allow NULL?
65	RGEKZ	Indicator: Backflushing for order	char	1	0	Allow NULL?
66	MEINS	Base Unit of Measure	nvarchar	3	0	Allow NULL?
67	CUOBJ	Configuration (internal object number)	nvarchar	18	0	Allow NULL?
68	REVLV	Revision Level	nvarchar	2	0	Allow NULL?
69	ABMNG	Reduced quantity in the planned order	decimal	13	3
70	RATID	Index for the results of scheduling production rates	nvarchar	12	0	Allow NULL?
71	GROID	Index for rough scheduling results	nvarchar	12	0	Allow NULL?
72	RATER	Scheduling error in scheduling production rates	nvarchar	2	0	Allow NULL?
73	GROER	Scheduling error in rough scheduling	nvarchar	2	0	Allow NULL?
74	OBART	Object type	char	1	0	Allow NULL?
75	PLSCN	Planning Scenario of Long-Term Planning	nvarchar	3	0	Allow NULL?
76	SBNUM	Simulation requirements number	nvarchar	10	0	Allow NULL?
77	KBNKZ	Kanban Indicator	char	1	0	Allow NULL?
78	KAPFX	Indicator: capacity for planned order dispatched	char	1	0	Allow NULL?
79	SEQNR	Seq. number order	nvarchar	14	0	Allow NULL?
80	PSTTI	Start Time of Planned Order	nvarchar	6	0	Allow NULL?
81	PEDTI	End Time of Planned Order	nvarchar	6	0	Allow NULL?
82	MONKZ	Indicator: for assembly order procedures	char	1	0	Allow NULL?
83	PRNKZ	Ind.: Leading order in collective order is planned ordre	char	1	0	Allow NULL?
84	MDPBV	Planned order: confirmation of availability	char	1	0	Allow NULL?
85	VFMNG	Planned order: committed quantity	decimal	13	3
86	MDACH	Action control: planned order processing	nvarchar	2	0	Allow NULL?
87	MDACC	Action: planned order processing	nvarchar	4	0	Allow NULL?
88	MDACD	Date of action: planned order	nvarchar	8	0	Allow NULL?
89	MDACT	Time of action: Planned order processing	nvarchar	6	0	Allow NULL?
90	GSBTR	Total commitment date of plnd ord. after ATP check f.comps.	nvarchar	8	0	Allow NULL?
91	PLETX	Planned order shift quantities exist	char	1	0	Allow NULL?
92	PRSCH	Planned order: scheduling using production dates	char	1	0	Allow NULL?
93	LVSCH	Planned order: leading scheduling level (determines dates)	char	1	0	Allow NULL?
94	KZAVC	Indicator for type of availability check	char	1	0	Allow NULL?
95	VRPLA	Indicator: planning without final assembly	char	1	0	Allow NULL?
96	PBDNR	Requirements Plan Number	nvarchar	10	0	Allow NULL?
97	AGREQ	Requirements totaling	char	1	0	Allow NULL?
98	UMREZ	Numerator for Conversion to Base Units of Measure	decimal	5	0
99	UMREN	Denominator for conversion to base units of measure	decimal	5	0
100	ERFMG	Quantity in Unit of Entry	decimal	13	3
101	ERFME	Unit of Entry	nvarchar	3	0	Allow NULL?
102	RQNUM	Requirements record number	nvarchar	10	0	Allow NULL?
103	KZBWS	Valuation of Special Stock	char	1	0	Allow NULL?
104	WEMNG	Quantity of Goods Received	decimal	13	3
105	WAMNG	Issued Quantity	decimal	13	3
106	EDGNO	Internal number for edge of object dependencies tree	nvarchar	17	0	Allow NULL?
107	LBLKZ	Subcontracting vendor	char	1	0	Allow NULL?
108	EMLIF	Vendor to be supplied/who is to receive delivery	nvarchar	10	0	Allow NULL?
109	BERID	MRP Area	nvarchar	10	0	Allow NULL?
110	UBERI	Issuing MRP area when transferring stock	nvarchar	10	0	Allow NULL?
111	EMATN	Material Number Corresponding to Manufacturer Part Number	nvarchar	18	0	Allow NULL?
112	REMFL	Repetitive Manufacturing indicator	char	1	0	Allow NULL?
113	PSTMP	Last Change to Planned Order: Time Stamp	decimal	15	0
114	PUSER	Last Change to Planned Order: User	nvarchar	12	0	Allow NULL?
115	BADI	Object change via active Business Add-In	char	1	0	Allow NULL?
116	STAEX	Status information on BOM explosion in planned order	nvarchar	2	0	Allow NULL?
117	RESLO	Issuing Storage Location for Stock Transport Order	nvarchar	4	0	Allow NULL?
118	SRM_CONTRACT_ID	Central Contract	nvarchar	10	0	Allow NULL?
119	SRM_CONTRACT_ITM	Central Contract Item Number	nvarchar	10	0	Allow NULL?
120	MEDKZ	Indicator for Distributed Planned Order	char	1	0	Allow NULL?
121	CNFQTY	Total Confirmed Qty Planned Order (Repetitive Manufacturing)	decimal	13	3
122	SGT_SCAT	Stock Segment	nvarchar	16	0	Allow NULL?
123	KUNNR	Customer Number	nvarchar	10	0	Allow NULL?

Name	Primary	Unique	Type	Columns
PLAF~0	Yes	Yes	CLUSTERED	PLNUM, MANDT
PLAF~1	No	No	NONCLUSTERED	PLWRK, MATNR, MANDT
PLAF~2	No	No	NONCLUSTERED	FRTHW, UMSKZ, PLWRK, DISPO, MANDT

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 | 3 INDEXES | ERP 6.0 | PLAF TABLE

TOP ERP 6.0 | PLAF COLUMNS

TOP ERP 6.0 | PLAF INDEXES

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 | 3 INDEXES | ERP 6.0 | PLAF TABLE

TOPERP 6.0 | PLAF COLUMNS

TOPERP 6.0 | PLAF INDEXES

TOP ERP 6.0 | PLAF COLUMNS

TOP ERP 6.0 | PLAF INDEXES