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
Real Estate Management :: Flexible Real Estate Management :: Rent Adjustment
1	ERP EHP7	6.0	VIAJRECORD	81	9	Adjustment record	Rent Adjustment

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	RECORDGUID	Generic Key of Adjustment Record	varbinary	16	0
3	PROCESSGUID	Generic Key of Process	varbinary	16	0
4	INTRENO	Internal Key of Real Estate Object	nvarchar	13	0	Allow NULL?
5	TERMNO	Term Number	nvarchar	4	0	Allow NULL?
6	ADJMRULE	Adjustment Rule	nvarchar	10	0	Allow NULL?
7	ADJMSUBRULE	Elementary Adjustment Rule (Part of Comb. Rule)	nvarchar	10	0	Allow NULL?
8	ADJMSUBMETH	Adjustment Method	nvarchar	4	0	Allow NULL?
9	ADJMDRECORDSTAT	Status of an Adjustment Record	char	1	0	Allow NULL?
10	ADJMRULEDEFAULT	Alternative Adjustment Rule	nvarchar	10	0	Allow NULL?
11	ADJMRECSTEPNO	Sequential Number of Adjustment Step	nvarchar	8	0	Allow NULL?
12	DERF	First Entered on	nvarchar	8	0	Allow NULL?
13	TERF	Time of Initial Entry	nvarchar	6	0	Allow NULL?
14	RERF	Entered by	nvarchar	12	0	Allow NULL?
15	FDELETE	Deletion Indicator for Archiving	char	1	0	Allow NULL?
16	CONDGUIDOLD	GUID (RAW16) for Conditions	varbinary	16	0
17	CONDGUIDNEW	GUID (RAW16) for Conditions	varbinary	16	0
18	CONDGUIDREF	GUID (RAW16) for Conditions	varbinary	16	0
19	ADJMFROMOLD	Valid-From Date of New Condition Item	nvarchar	8	0	Allow NULL?
20	ADJMFROMCALC	Valid-From Date of New Condition Item	nvarchar	8	0	Allow NULL?
21	ADJMFROMMOD	Valid-From Date of New Condition Item	nvarchar	8	0	Allow NULL?
22	UNITPRICEOLD	Unit Price	decimal	19	6
23	UNITPRICECALC	Unit Price	decimal	19	6
24	UNITPRICEMOD	Unit Price	decimal	19	6
25	ADJMCONDDELETE	Condition Is Deleted	char	1	0	Allow NULL?
26	METHREFGUID	Reference to Process-Specific Data for Adjustment Record	varbinary	16	0
27	ADJMFROMMODDATE	Valid-From Date Changed On	nvarchar	8	0	Allow NULL?
28	ADJMFROMMODUSER	Valid-From Date Changed By	nvarchar	12	0	Allow NULL?
29	UNITPRICEMODDATE	Valid-From Date Changed On	nvarchar	8	0	Allow NULL?
30	UNITPRICEMODUSER	Price Changed By	nvarchar	12	0	Allow NULL?
31	CONDVALIDTOOLD	Date up to when condition is valid	nvarchar	8	0	Allow NULL?
32	ADJMCONDNEW	New Condition on Target	char	1	0	Allow NULL?
33	UPBEFORECAPPING	Unit Price Before Capping	decimal	19	6
34	MONTHCAPPING	Time in Months	nvarchar	3	0	Allow NULL?
35	DISSOLVEINGUID	Reference to Condition That Contains the Cancellation	varbinary	16	0
36	ADJMREASON	Adjustment Reason	nvarchar	10	0	Allow NULL?
37	CHGREASON	Reason for Change	nvarchar	10	0	Allow NULL?
38	CHGREASONOLD	Reason for Change	nvarchar	10	0	Allow NULL?
39	CARRYFROMGUID	Reference to Transferred Condition	varbinary	16	0
40	CARRYOVERCT	Condition Type	nvarchar	4	0	Allow NULL?
41	RECGROUPGUID	GUID for Grouping Adjustment Records	varbinary	16	0
42	INTRENODEPEND	Internal Key of Real Estate Object	nvarchar	13	0	Allow NULL?
43	RECORDUPDATE	Record Was Updated	char	1	0	Allow NULL?
44	UNITPRICEANN	Unit Price	decimal	19	6
45	ADJMFROMANN	Valid-From Date of New Condition Item	nvarchar	8	0	Allow NULL?
46	CONDPURPOSENEW	Conditions - External Purpose	nvarchar	4	0	Allow NULL?
47	CONDTYPECEA	Condition Type	nvarchar	4	0	Allow NULL?
48	CONDTYPENEW	Condition Type	nvarchar	4	0	Allow NULL?
49	TERMNOAJNEW	Term Number	nvarchar	4	0	Allow NULL?
50	TAKETERMNO	Copy Terms	char	1	0	Allow NULL?
51	MAXINCREL	Maximum Increase in Percent	decimal	7	2
52	UPLESSCAPMONTH	Unit Price	decimal	19	6
53	ADJMFROMLESSCM	Valid-From Date of New Condition Item	nvarchar	8	0	Allow NULL?
54	UPPOSMARGIN	Unit Price	decimal	19	6
55	UPPOSMARGINUSED	Unit Price	decimal	19	6
56	UPINCALLOWED	Unit Price	decimal	19	6
57	ADJMACTIVDATE	Activated On	nvarchar	8	0	Allow NULL?
58	ADJMACTIVUSER	Activated By	nvarchar	12	0	Allow NULL?
59	DUEDATEUP	Due Date for Follow-Up Postings	nvarchar	8	0	Allow NULL?
60	DUEDATEUPOLD	Due Date for Follow-Up Postings	nvarchar	8	0	Allow NULL?
61	ADJMANNOUNCETO	Date Reply to Notification Is Required	nvarchar	8	0	Allow NULL?
62	ADJMANNOUNCEDATE	Notification Date	nvarchar	8	0	Allow NULL?
63	ADJMANNOUNCEUSER	Notified By	nvarchar	12	0	Allow NULL?
64	ADJMAPPROVALTO	Date Up to Which the Approval Must Occur	nvarchar	8	0	Allow NULL?
65	ADJMAPPROVALDATE	Approval On	nvarchar	8	0	Allow NULL?
66	ADJMAPPROVALUSER	Approved By	nvarchar	12	0	Allow NULL?
67	ADJMDECLINEDATE	Rejected On	nvarchar	8	0	Allow NULL?
68	ADJMDECLINEUSER	Rejected By	nvarchar	12	0	Allow NULL?
69	ADJMREVERSALDATE	Reversed On	nvarchar	8	0	Allow NULL?
70	ADJMREVERSALUSER	Reversed by	nvarchar	12	0	Allow NULL?
71	ADJMDOCDATE	Adjustment Letter On	nvarchar	8	0	Allow NULL?
72	ADJMDOCCOUNT	Number of Adjustment Letters	tinyint	3	0
73	ADJMDUNLEVEL	Dunning Level	tinyint	3	0
74	ADJMDUNDATE	Reminder Letter On	nvarchar	8	0	Allow NULL?
75	ADJMDUNCOUNT	Number of Reminder Letters	tinyint	3	0
76	ADJMAPPDATE	Approval Confirmation Letter On	nvarchar	8	0	Allow NULL?
77	ADJMAPPCOUNT	Number of Approval Confirmation Letters	tinyint	3	0
78	ADJMANNDATE	Date of Last Notification Letter	nvarchar	8	0	Allow NULL?
79	ADJMANNCOUNT	Number of Notification Letters	tinyint	3	0
80	ADJMDEACTIVDATE	Deactivated On	nvarchar	8	0	Allow NULL?
81	ADJMDEACTIVUSER	Deactivated By	nvarchar	12	0	Allow NULL?

Name	Primary	Unique	Type	Columns
VIAJRECORD~0	Yes	Yes	CLUSTERED	MANDT, RECORDGUID
VIAJRECORD~007	No	No	NONCLUSTERED	MANDT, RECGROUPGUID
VIAJRECORD~1	No	No	NONCLUSTERED	MANDT, INTRENO
VIAJRECORD~2	No	No	NONCLUSTERED	MANDT, PROCESSGUID
VIAJRECORD~3	No	No	NONCLUSTERED	MANDT, CONDGUIDOLD
VIAJRECORD~4	No	No	NONCLUSTERED	MANDT, CONDGUIDNEW
VIAJRECORD~5	No	No	NONCLUSTERED	MANDT, METHREFGUID
VIAJRECORD~6	No	No	NONCLUSTERED	MANDT, DISSOLVEINGUID
VIAJRECORD~7	No	No	NONCLUSTERED	MANDT, CARRYFROMGUID

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

81 COLUMNS | 9 INDEXES | ERP 6.0 | VIAJRECORD TABLE

TOP ERP 6.0 | VIAJRECORD COLUMNS

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

81 COLUMNS | 9 INDEXES | ERP 6.0 | VIAJRECORD TABLE

TOPERP 6.0 | VIAJRECORD COLUMNS

TOPERP 6.0 | VIAJRECORD INDEXES

TOP ERP 6.0 | VIAJRECORD COLUMNS

TOP ERP 6.0 | VIAJRECORD INDEXES