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

37 columns | Print definition?ERP 6.0  | ACCT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1ZSAWOObject table 18ACCTAccount Numbernvarchar100
2ZSEMBPSOObject table 18ACCTAccount Numbernvarchar100
3ZSPLITOObjekttabelle 18ACCTKontonummernvarchar100
4ZZ001OObject Table 18ACCTAccount Numbernvarchar100
5ZZLINEOObject table 18ACCTAccount Numbernvarchar100
6ZZSL01OCustom Special Ledger Table Group8ACCTAccount Numbernvarchar100
7ZZSPECOObject table 18ACCTAccount Numbernvarchar100
TOPBasic Functions
8FILCOFI-LC: Acct assign.fields (Object-TrPartner) for table FILCT8ACCTConsolidation itemnvarchar100
9GGREFOExample for Global Object Table 1 (Object/Partner)9ACCTAccount Numbernvarchar100
10GLFUNCOObject Table 1 for Cost of Sales Accounting8ACCTAccount Numbernvarchar100
11GLOO1Object Table for FI-SL Table GLTO13ACCTAccount Numbernvarchar100
12GLOO2Object Table for GLT02: Global4ACCTAccount Numbernvarchar100
13GLOO3Object Table for FI-SL Table GLTO33ACCTAccount Numbernvarchar100
14GLREFOExample for Local Object Table 1 (Object/Partner)8ACCTAccount Numbernvarchar100
TOPCollectionsDisbursements
15GLISDEOObject Table 1 for Insurance (DE)8ACCTAccount Numbernvarchar100
16GRISDEOObject Table 1 for Insurance (DE) - Rollup8ACCTAccount Numbernvarchar100
TOPCost Element Accounting
17COFIO1Object Table for Reconciliation Ledger COFIT8ACCTCost Elementnvarchar100
TOPFinancial Accounting
18FBICRC001OICRC: Open Items GL Accounts: Object table 19ACCTGroup Account Numbernvarchar100
19FBICRC002OICRC: GL Accounts: Object table 19ACCTGroup Account Numbernvarchar100
TOPFinancial Services Localization
20/CEEIS/RUOObject table 18ACCTAccount Numbernvarchar100
TOPFlexible Real Estate Management
21VIPRLEDTAGROObjekttabelle 18ACCTKontonummernvarchar100
TOPFunctions for U.S. Federal Government
22FMFGYECLAAUS Federal Gov't : Y/E Pre-Closing of Anticipated Accounts2ACCTGeneral Ledger Accountnvarchar100
TOPFund Accounting
23FMCCAVCOObject table 18ACCTAccount Numbernvarchar100
TOPFunds Management
24FMSPLITOObject table 18ACCTAccount Numbernvarchar100
25FMUSFGFACTS1OObject table 18ACCTAccount Numbernvarchar100
26FMUSFGFACTS2OObject table 18ACCTAccount Numbernvarchar100
27FMUSFGOObject table 1 for US Federal Government8ACCTAccount Numbernvarchar100
TOPJoint Venture und Production Sharing Accounting
28JVOO1Object Table for FI-SL Table JVTO110ACCTAccount Numbernvarchar100
29JVPSC01OObject table 112ACCTAccount Numbernvarchar100
TOPLocalization
30J_3RFTAXROTax Accounting: Object table11ACCTAccount Numbernvarchar100
31J_3RFTAXRVOTax Accounting: Object table10ACCTAccount Numbernvarchar100
TOPRegulatory reporting for insurance companies
32ISSRFLDEOObject table 19ACCTAccount Numbernvarchar100
TOPRetail Ledger
33PCRRETAILOObject Table 18ACCTAccount Numbernvarchar100
TOPSpecial Purpose Ledger
34/CCIS/PBU18OPBU18: Object table8ACCTAccount Numbernvarchar100
TOPTariffs, Duties and Permits
35OIHEDOObject table 1, IS-OIL Excise Duty Special Ledger15ACCTAccount Numbernvarchar100
36OIHSLOTDP (excise duty) special ledger object table14ACCTAccount Numbernvarchar100
TOPTransfer to Financial Accounting
37TRACTSLOObject Table 18ACCTAccount Numbernvarchar100