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	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	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
Industry Specific :: Industry Solution Oil :: Downstream :: Transportation and Distribution
1	ERP EHP7	6.0	OIGS	94	1	TD Shipment Header	Transportation and Distribution

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	CLIENT	Client	nvarchar	3	Allow NULL?
2	SHNUMBER	TD shipment number	nvarchar	10	Allow NULL?
3	SHTYPE	TD shipment type	nvarchar	4	Allow NULL?
4	XBLNR	Reference Document Number	nvarchar	16	Allow NULL?
5	VEH_MODE	TD vehicle mode of transport	char	1	Allow NULL?
6	VMRQT	Vehicle meter required indicator	char	1	Allow NULL?
7	CPLID	Compartment load indicator	char	1	Allow NULL?
8	CHKCMP_P_C	Check compatibility at scheduling for product/compartment	char	1	Allow NULL?
9	CHKCMP_V_C	Check compatibility at scheduling for vehicle/customer	char	1	Allow NULL?
10	PART_DC	TD partial delivery confirmation allowance	char	1	Allow NULL?
11	UOMID	Unit of measure identification	char	1	Allow NULL?
12	CFBLL	Confirm balance load of deliveries	char	1	Allow NULL?
13	INPGP	Intransit posting group	nvarchar	2	Allow NULL?
14	WGT_UOM	TD weight unit of measure	nvarchar	3	Allow NULL?
15	VOL_UOM	TD volume unit of measure	nvarchar	3	Allow NULL?
16	NR_DECV	Number of decimal places for shipment quantities	nvarchar	2	Allow NULL?
17	NR_DECW	Number of decimal places for shipment quantities	nvarchar	2	Allow NULL?
18	VOLA_UOM	TD volume unit of measure (ambient)	nvarchar	3	Allow NULL?
19	VOLC_UOM	TD volume unit of measure, corrected (temperature)	nvarchar	3	Allow NULL?
20	OVLD_WRNG	TD check overloading at loading - (only warning)	char	1	Allow NULL?
21	OIG_DLNMCK	Sequence number check for TD document	char	1	Allow NULL?
22	SCHUND	TD-S Underdelivery tolerance message level	char	1	Allow NULL?
23	SCHOVR	TD-S Overdelivery tolerance message level	char	1	Allow NULL?
24	LOAUND	TD-L under-delivery tolerance message level	char	1	Allow NULL?
25	LOAOVR	TD-L Over-delivery tolerance message level	char	1	Allow NULL?
26	DELUND	TD-D Under-delivery tolerance message level	char	1	Allow NULL?
27	DELOVR	TD-D over-delivery tolerance message level	char	1	Allow NULL?
28	EV_SEQ_UNI	TD Event sequence number (unique)	char	1	Allow NULL?
29	EV_GROUP	TD - event default group	nvarchar	4	Allow NULL?
30	SHFT_MNT	TD - shift mandatory	char	1	Allow NULL?
31	CHK_OVL	TD check overloading	char	1	Allow NULL?
32	VCLOSE	Vehicle close flag; set confirmation to complete (status=6)	char	1	Allow NULL?
33	VBALNC	TD vehicle balance check against tolerance table (TOIGS5)	char	1	Allow NULL?
34	GLPST	TD gain/loss postings at vehicle close	char	1	Allow NULL?
35	EXCH_SCH	Automatically access user exit for exchange assignment	char	1	Allow NULL?
36	FFTYP	Fulfillment indicator for exchange assignments	char	1	Allow NULL?
37	EXGASS	Purchase assignment user exit	nvarchar	3	Allow NULL?
38	BWART	Movement Type (Inventory Management)	nvarchar	3	Allow NULL?
39	VSART	Shipping type	nvarchar	2	Allow NULL?
40	EXCH_LOAD	Automatically access user exit for exchange assignment	char	1	Allow NULL?
41	EXCH_CHECK	Check exchange assignments at scheduling	char	1	Allow NULL?
42	AUSTGASGN	TD-F auto assignment of stages to document items	char	1	Allow NULL?
43	FKART	Shipment cost type	nvarchar	4	Allow NULL?
44	FRKRL	Proposal freight costs relevance, Shipment header	char	1	Allow NULL?
45	FRKRL_STR	Proposal freight costs relevance, shipment leg	char	1	Allow NULL?
46	FRKRL_UMP	Proposal for shipment costs relevance - Load transfer point	char	1	Allow NULL?
47	FRKRL_GRP	Proposal for freight costs relevance, Border cross.pt	char	1	Allow NULL?
48	FRKRL_VEH	TD - shipment cost relevance for vehicles	char	1	Allow NULL?
49	SCLDTYPE	TD-F -Shipment costing based on loaded or disch. quantitites	char	1	Allow NULL?
50	CPL_CUSFNT	TD compartment planning - customer function	char	1	Allow NULL?
51	NEW_COMP	Adopt compartment allocation when the vehicle is changed	char	1	Allow NULL?
52	CHGDOCS	IS-OIL TD Write Change Documents for TD shipments	char	1	Allow NULL?
53	PROLI	Dangerous Goods Management Profile in SD Documents	nvarchar	3	Allow NULL?
54	DGTLOCK	Block Indicator for Dangerous Goods	char	1	Allow NULL?
55	DGMDDAT	Selection date dangerous goods master data	nvarchar	8	Allow NULL?
56	CONT_DG	Indicator: Document contains dangerous goods	char	1	Allow NULL?
57	C_SHTYP	Shipment type	nvarchar	4	Allow NULL?
58	TPLST	Transportation planning point	nvarchar	4	Allow NULL?
59	ROUTE	Route	nvarchar	6	Allow NULL?
60	CARRIER	Number of forwarding agent	nvarchar	10	Allow NULL?
61	CRE_NAME	Name of Person who Created the Object	nvarchar	12	Allow NULL?
62	CRE_DATE	Date on Which Record Was Created	nvarchar	8	Allow NULL?
63	CRE_TIME	Entry time	nvarchar	6	Allow NULL?
64	CHA_NAME	Name of Person Who Changed Object	nvarchar	12	Allow NULL?
65	CHA_DATE	Changed On	nvarchar	8	Allow NULL?
66	CHA_TIME	Time last change was made	nvarchar	6	Allow NULL?
67	OIG_SSTSF	TD Shipment Status (Functional)	char	1	Allow NULL?
68	SCHED_STDT	Planned date for start of shipment	nvarchar	8	Allow NULL?
69	SCHED_STTM	Scheduling start time	nvarchar	6	Allow NULL?
70	LOAD_STDT	Planned date for start of loading	nvarchar	8	Allow NULL?
71	LOAD_STTM	Planned time for start of loading	nvarchar	6	Allow NULL?
72	LOAD_EDDT	Planned date for end of loading	nvarchar	8	Allow NULL?
73	LOAD_EDTM	Planned time for end of loading	nvarchar	6	Allow NULL?
74	DEL_STDT	Planned date for start of delivery confirmation	nvarchar	8	Allow NULL?
75	DEL_STTM	Planned time for start of delivery confirmation	nvarchar	6	Allow NULL?
76	DEL_EDDT	Planned date for end of delivery confirmation	nvarchar	8	Allow NULL?
77	DEL_EDTM	Planned time for end of delivery confirmation	nvarchar	6	Allow NULL?
78	LOAD_STDTA	Date for start of loading	nvarchar	8	Allow NULL?
79	LOAD_STTMA	Actual time for start of loading	nvarchar	6	Allow NULL?
80	LOAD_EDDTA	Actual date for end of loading	nvarchar	8	Allow NULL?
81	LOAD_EDTMA	Actual time for end of loading	nvarchar	6	Allow NULL?
82	DEL_STDTA	Actual date for start of delivery confirmation	nvarchar	8	Allow NULL?
83	DEL_STTMA	Actual time for start of delivery confirmation	nvarchar	6	Allow NULL?
84	DEL_EDDTA	Actual date for end of delivery confirm	nvarchar	8	Allow NULL?
85	DEL_EDTMA	Actual time for end of delivery confirmation	nvarchar	6	Allow NULL?
86	FBSTA	Status of shipment costs calculation	char	1	Allow NULL?
87	FBGST	Overall status of calculation of shipment costs for shipment	char	1	Allow NULL?
88	ARSTA	Status of shipment costs settlement	char	1	Allow NULL?
89	ARGST	Total status of shipment costs settlement for shipment	char	1	Allow NULL?
90	FRKRL_SHP	Shipment costs relevance	char	1	Allow NULL?
91	SKALSM	Pricing procedure in shipment header	nvarchar	6	Allow NULL?
92	TSWUSEIND	OIL TSW: TSW usage indicator	char	1	Allow NULL?
93	CHG_REASON	OIL-TPI: Change reason code	nvarchar	2	Allow NULL?
94	SHSTA_SCD	TD Shipment Status (Functional)	char	1	Allow NULL?

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

94 COLUMNS | 1 INDEXES | ERP 6.0 | OIGS TABLE

TOP ERP 6.0 | OIGS COLUMNS

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

94 COLUMNS | 1 INDEXES | ERP 6.0 | OIGS TABLE

TOPERP 6.0 | OIGS COLUMNS

TOPERP 6.0 | OIGS INDEXES

TOP ERP 6.0 | OIGS COLUMNS

TOP ERP 6.0 | OIGS INDEXES