SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

51 columns | Print definition?ERP 6.0  | XTRUSTED

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPFund Accounting
1FMGLFLEX00General ledger: Transaction attributes8XTRUSTEDRecord is committed on database (reliable)nvarchar10
2FMGLFLEX01General ledger: Technical fields7XTRUSTEDRecord is committed on database (reliable)nvarchar10
3FMGLFLEX02General ledger: Main account assignment5XTRUSTEDRecord is committed on database (reliable)nvarchar10
4FMGLFLEX03General ledger: SAP additional account assignment7XTRUSTEDRecord is committed on database (reliable)nvarchar10
5FMGLFLEX04General ledger: Customer additional account assignment3XTRUSTEDRecord is committed on database (reliable)nvarchar10
6FMGLFLEX05General Ledger: Additional Acct Assignment: Customer 23XTRUSTEDRecord is committed on database (reliable)nvarchar10
7FMGLFLEX06General ledger: Sender SAP additional account assignment8XTRUSTEDRecord is committed on database (reliable)nvarchar10
8FMGLFLEX07General Ledger: Reserve Table 16XTRUSTEDRecord is committed on database (reliable)nvarchar10
9FMGLFLEX08General Ledger: Reserve Table 23XTRUSTEDRecord is committed on database (reliable)nvarchar10
10PSGLFLEX00General ledger: Transaction attributes8XTRUSTEDRecord is committed on database (reliable)nvarchar10
11PSGLFLEX01General ledger: Technical fields7XTRUSTEDRecord is committed on database (reliable)nvarchar10
12PSGLFLEX02General ledger: Main account assignment7XTRUSTEDRecord is committed on database (reliable)nvarchar10
13PSGLFLEX03General ledger: SAP additional account assignment7XTRUSTEDRecord is committed on database (reliable)nvarchar10
14PSGLFLEX04General ledger: Customer additional account assignment3XTRUSTEDRecord is committed on database (reliable)nvarchar10
15PSGLFLEX05General Ledger: Additional Acct Assignment: Customer 23XTRUSTEDRecord is committed on database (reliable)nvarchar10
16PSGLFLEX06General ledger: Sender SAP additional account assignment9XTRUSTEDRecord is committed on database (reliable)nvarchar10
17PSGLFLEX07General Ledger: Reserve Table 17XTRUSTEDRecord is committed on database (reliable)nvarchar10
18PSGLFLEX08General Ledger: Reserve Table 23XTRUSTEDRecord is committed on database (reliable)nvarchar10
TOPGeneral Ledger Accounting
19FAGLFLEX00General ledger: Transaction attributes8XTRUSTEDRecord is committed on database (reliable)nvarchar10
20FAGLFLEX01General ledger: Technical fields7XTRUSTEDRecord is committed on database (reliable)nvarchar10
21FAGLFLEX02General ledger: Main account assignment5XTRUSTEDRecord is committed on database (reliable)nvarchar10
22FAGLFLEX03General ledger: SAP additional account assignment10XTRUSTEDRecord is committed on database (reliable)nvarchar10
23FAGLFLEX04General ledger: Customer additional account assignment4XTRUSTEDRecord is committed on database (reliable)nvarchar10
24FAGLFLEX05General Ledger: Additional Acct Assignment: Customer 23XTRUSTEDRecord is committed on database (reliable)nvarchar10
25FAGLFLEX06General ledger: Sender SAP additional account assignment9XTRUSTEDRecord is committed on database (reliable)nvarchar10
26FAGLFLEX07General Ledger: Reserve Table 13XTRUSTEDRecord is committed on database (reliable)nvarchar10
27FAGLFLEX08General Ledger: Reserve Table 23XTRUSTEDRecord is committed on database (reliable)nvarchar10
28FAGL_RMAP_CUSTReorganization: Object Number of the Signature Values5XTRUSTEDRecord is committed on database (reliable)nvarchar10
29FAGL_RMAP_SAPReorganization: Object Number of the Signature Values7XTRUSTEDRecord is committed on database (reliable)nvarchar10
30FAGL_RMAP_SIGReorganization: Object Number of the Signature Values10XTRUSTEDRecord is committed on database (reliable)nvarchar10
TOPGeneral Ledger Reorganization
31FAGL_R_MAP_CUSTReorganization: Object Number of the Signature Values4XTRUSTEDRecord is committed on database (reliable)nvarchar10
32FAGL_R_MAP_SAPReorganization: Object Number of the Included SAP Fields10XTRUSTEDRecord is committed on database (reliable)nvarchar10
33FAGL_R_OI_TRACK0Reorganization: Open Items for Inclusion5XTRUSTEDRecord is committed on database (reliable)nvarchar10
TOPJoint Venture und Production Sharing Accounting
34JVGLFLEX00General ledger: Transaction attributes8XTRUSTEDRecord is committed on database (reliable)nvarchar10
35JVGLFLEX01General ledger: Technical fields7XTRUSTEDRecord is committed on database (reliable)nvarchar10
36JVGLFLEX02General ledger: Main account assignment5XTRUSTEDRecord is committed on database (reliable)nvarchar10
37JVGLFLEX03General ledger: SAP additional account assignment10XTRUSTEDRecord is committed on database (reliable)nvarchar10
38JVGLFLEX04General ledger: Customer additional account assignment3XTRUSTEDRecord is committed on database (reliable)nvarchar10
39JVGLFLEX05General Ledger: Additional Acct Assignment: Customer 23XTRUSTEDRecord is committed on database (reliable)nvarchar10
40JVGLFLEX06General ledger: Sender SAP additional account assignment9XTRUSTEDRecord is committed on database (reliable)nvarchar10
41JVGLFLEX07General Ledger: Joint Venture Accounting Fields6XTRUSTEDRecord is committed on database (reliable)nvarchar10
42JVGLFLEX08General Ledger: Reserve Table 23XTRUSTEDRecord is committed on database (reliable)nvarchar10
TOPSpecial Purpose Ledger
43/CCIS/PROFTAX00Object Table Number:008XTRUSTEDRecord is committed on database (reliable)nvarchar10
44/CCIS/PROFTAX01Object Table Number:017XTRUSTEDRecord is committed on database (reliable)nvarchar10
45/CCIS/PROFTAX02Object Table Number:025XTRUSTEDRecord is committed on database (reliable)nvarchar10
46/CCIS/PROFTAX03Object Table Number:0317XTRUSTEDRecord is committed on database (reliable)nvarchar10
47/CCIS/PROFTAX04Object Table Number:043XTRUSTEDRecord is committed on database (reliable)nvarchar10
48/CCIS/PROFTAX05Object Table Number:053XTRUSTEDRecord is committed on database (reliable)nvarchar10
49/CCIS/PROFTAX06Object Table Number:0613XTRUSTEDRecord is committed on database (reliable)nvarchar10
50/CCIS/PROFTAX07Object Table Number:073XTRUSTEDRecord is committed on database (reliable)nvarchar10
51/CCIS/PROFTAX08Object Table Number:083XTRUSTEDRecord is committed on database (reliable)nvarchar10