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	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
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	OPCH	386	A/P Invoice
7	INV1	265	A/R Invoice - Rows
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

B1 8.8: Top 10 requests

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

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: Industry Solution Oil :: Downstream :: Traders and Schedulers Workbench
1	ERP EHP7	6.0	OIJNOMH	99	4	Nomination Header	Traders and Schedulers Workbench

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	NOMTK	Nomination (technical) Key	nvarchar	20	0	Allow NULL?
3	NOMCL	Nomination Class	nvarchar	2	0	Allow NULL?
4	NOMTYP	Nomination type	nvarchar	4	0	Allow NULL?
5	BUSTYP	Business type	nvarchar	4	0	Allow NULL?
6	NOMNR	Nomination number	nvarchar	20	0	Allow NULL?
7	NOMST	Nomination header status	char	1	0	Allow NULL?
8	NMSHTYPE	TD shipment type	nvarchar	4	0	Allow NULL?
9	NMBALCH	Balance check indicator (default)	char	1	0	Allow NULL?
10	STAGES_ID	GUID in 'CHAR' format with upper-/lowercase (!)	nvarchar	22	0	Allow NULL?
11	WORKLIST	Worklist entry indicator	char	1	0	Allow NULL?
12	SENTDAT	Last header action date	nvarchar	8	0	Allow NULL?
13	SENTTIME	Last header action time	nvarchar	6	0	Allow NULL?
14	SENTNAM	Last user who worked on object	nvarchar	12	0	Allow NULL?
15	ITEMS	Nomination item counter	nvarchar	4	0	Allow NULL?
16	COUNTER1	Nomination planned item Counter	nvarchar	4	0	Allow NULL?
17	COUNTER2	Nomination scheduled Item Counter	nvarchar	4	0	Allow NULL?
18	COUNTER3	Nomination rejected Item Counter	nvarchar	4	0	Allow NULL?
19	COUNTER4	Nomination confirmed Item Counter	nvarchar	4	0	Allow NULL?
20	COUNTER5	Nomination partially complete Item Counter	nvarchar	4	0	Allow NULL?
21	COUNTER6	Nomination completed Item Counter	nvarchar	4	0	Allow NULL?
22	APO_SHIPMENT_ID	GUID in 'CHAR' format with upper-/lowercase (!)	nvarchar	22	0	Allow NULL?
23	APO_SHIPMENT_NUM	Shipment Number	nvarchar	10	0	Allow NULL?
24	NMBLOCK	Blocking indicator	char	1	0	Allow NULL?
25	NOMTYPDESC	IS-Oil: Descriptive text	nvarchar	36	0	Allow NULL?
26	SHTYP	Shipment type	nvarchar	4	0	Allow NULL?
27	TKNUM	Shipment Number	nvarchar	10	0	Allow NULL?
28	LOV_GL	Gain Loss LOV posting indicator	char	1	0	Allow NULL?
29	TSYST	Transport system	nvarchar	10	0	Allow NULL?
30	NMSHIPPER	Shipper	nvarchar	10	0	Allow NULL?
31	NMCARRIER	Transport system Carrier	nvarchar	10	0	Allow NULL?
32	CYCLE	Nomination Pipeline cycle ID	nvarchar	10	0	Allow NULL?
33	NMWERK	Transport system In-transit Plant	nvarchar	4	0	Allow NULL?
34	NMLGORT	Transport system In-transit Storage Location	nvarchar	4	0	Allow NULL?
35	NMVEHICLE	TD Vehicle Number	nvarchar	10	0	Allow NULL?
36	NMVESSEL	TD vehicle identifier	nvarchar	18	0	Allow NULL?
37	NMTPLST	Transportation planning point	nvarchar	4	0	Allow NULL?
38	ROUTE	Route	nvarchar	6	0	Allow NULL?
39	BOOKTS	Book TS indicator	char	1	0	Allow NULL?
40	EV_GROUP	TD - event default group	nvarchar	4	0	Allow NULL?
41	VKTRA	Mode of transport	nvarchar	2	0	Allow NULL?
42	QTYIN	Qty received in TS	decimal	13	3
43	QTYOUT	Qty delivered from TS	decimal	13	3
44	UNIT	Nomination(pipe) UoM	nvarchar	3	0	Allow NULL?
45	TST_FROM_MIN	Scheduled / Acceptance / Pipe Batch Start Timestamp	decimal	15	0
46	TST_TO_MAX	Scheduled / Acceptance / Pipe Batch End Timestamp	decimal	15	0
47	BLOIND	Blocking indicator	char	1	0	Allow NULL?
48	DELIND	Deletion indicator	char	1	0	Allow NULL?
49	SHNUM	TD shipment number	nvarchar	10	0	Allow NULL?
50	ERDAT	Date on Which Record Was Created	nvarchar	8	0	Allow NULL?
51	ERZEIT	Time of creation	nvarchar	6	0	Allow NULL?
52	ERNAM	Name of Person who Created the Object	nvarchar	12	0	Allow NULL?
53	AEDAT	Changed On	nvarchar	8	0	Allow NULL?
54	AEZEIT	Time of day the record was changed	nvarchar	6	0	Allow NULL?
55	AENAM	Name of Person Who Changed Object	nvarchar	12	0	Allow NULL?
56	EV_SEQ_UNI	TD Event sequence number (unique)	char	1	0	Allow NULL?
57	VSART	Shipping type	nvarchar	2	0	Allow NULL?
58	SHTYPE	TD shipment type	nvarchar	4	0	Allow NULL?
59	VEHID	Default vehicle number	nvarchar	10	0	Allow NULL?
60	TSSUOMV	TS standard volume UoM	nvarchar	3	0	Allow NULL?
61	TSSUOMM	TS standard weight UoM	nvarchar	3	0	Allow NULL?
62	CYCPERD	TS cycle duration	decimal	10	0
63	CYCPUOM	TS cycle duration UoM	nvarchar	3	0	Allow NULL?
64	CARRIER	Transport system Carrier	nvarchar	10	0	Allow NULL?
65	WERK	Transport system In-transit Plant	nvarchar	4	0	Allow NULL?
66	LGORT	Transport system In-transit Storage Location	nvarchar	4	0	Allow NULL?
67	NOMMSK	Nomination mask	nvarchar	10	0	Allow NULL?
68	SHIPPER	Default TS shipper code	nvarchar	10	0	Allow NULL?
69	CONLTM	Carrier lead time	decimal	3	0
70	CONLUOM	Confirmation lead time UoM	nvarchar	3	0	Allow NULL?
71	TPLST	Transportation planning point	nvarchar	4	0	Allow NULL?
72	UNLIMITED	Indicator: Unlimited Overdelivery Allowed	char	1	0	Allow NULL?
73	BOTOL	Quantity tolerance over (percentage)	decimal	4	1
74	BUTOL	Quantity tolerance under (%)	decimal	4	1
75	BOTOLABS	Absolute tolerance qty over	decimal	13	3
76	BUTOLABS	Absolute tolerance qty under	decimal	13	3
77	BULTOLUOM	Absolute tolerance UoM	nvarchar	3	0	Allow NULL?
78	BALCH	Balance check indicator (default)	char	1	0	Allow NULL?
79	FLTTNOMTK	Nomination (technical) Key	nvarchar	20	0	Allow NULL?
80	EXTNOMNR	External Nomination Number	nvarchar	10	0	Allow NULL?
81	CHANGENR	Change Number	nvarchar	4	0	Allow NULL?
82	NOMSTATUSRU	Nomination Approval Status	char	1	0	Allow NULL?
83	DISPATCHTYP	Freight Shipment Type	nvarchar	2	0	Allow NULL?
84	DISPATCHREC	Dispatch Scheduling	nvarchar	2	0	Allow NULL?
85	CONNECTIONTYP	Route Type	nvarchar	2	0	Allow NULL?
86	RAILCAROWN	Railcar Ownership	nvarchar	2	0	Allow NULL?
87	TARIFFCOD	Special Tariff Code	nvarchar	5	0	Allow NULL?
88	PAYERTYP	Responsible Party for Payment	nvarchar	2	0	Allow NULL?
89	SENDCAT	Partner Object	char	1	0	Allow NULL?
90	SENDER	Sender	nvarchar	10	0	Allow NULL?
91	RECVCAT	Partner Object	char	1	0	Allow NULL?
92	RECEIVER	Receiver	nvarchar	10	0	Allow NULL?
93	PYRCAT	Partner Object	char	1	0	Allow NULL?
94	PAYER	Payer	nvarchar	10	0	Allow NULL?
95	ROWNCAT	Partner Object	char	1	0	Allow NULL?
96	ROADOWNER	Access Road Owner	nvarchar	10	0	Allow NULL?
97	NOMNREGDATE	Nomination Registration Date	nvarchar	8	0	Allow NULL?
98	NOMNVALDFROM	Nomination Validity Period From	nvarchar	8	0	Allow NULL?
99	NOMNVALDTO	Nomination Valid Period To	nvarchar	8	0	Allow NULL?

Name	Primary	Unique	Type	Columns
OIJNOMH~0	Yes	Yes	CLUSTERED	NOMTK, MANDT
OIJNOMH~A01	No	No	NONCLUSTERED	AEDAT, NOMNR, MANDT
OIJNOMH~TSC	No	No	NONCLUSTERED	NMCARRIER, TSYST, MANDT
OIJNOMH~VEH	No	No	NONCLUSTERED	DELIND, NMVEHICLE, 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

99 COLUMNS | 4 INDEXES | ERP 6.0 | OIJNOMH TABLE

TOP ERP 6.0 | OIJNOMH COLUMNS

TOP ERP 6.0 | OIJNOMH 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

99 COLUMNS | 4 INDEXES | ERP 6.0 | OIJNOMH TABLE

TOPERP 6.0 | OIJNOMH COLUMNS

TOPERP 6.0 | OIJNOMH INDEXES

TOP ERP 6.0 | OIJNOMH COLUMNS

TOP ERP 6.0 | OIJNOMH INDEXES