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

39 columns | Print definition?ERP 6.0  | BALANCE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000173000PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal.37BALANCEdecimal170
2/BIC/B0000174000PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs39BALANCEdecimal170
3/BIC/B0000175000PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q)39BALANCEdecimal170
4BOE_PLE_ITEMPledge item data table of BoE management23BALANCEPledge Balancedecimal132
5DIAN_A_1008_07Cached Data of DIAN Format 1003 version 0718BALANCEAccount receivables balancedecimal222
6DIAN_A_1009_07Cached Data of DIAN Format 1009 version 0718BALANCEAccount payables balancedecimal222
7EPIC_DUM_BALBalance of Dummy Bank6BALANCEAmount in document currencydecimal132
8EPIC_DUM_TRANSACTransactions of Dummy Bank12BALANCEAmount in document currencydecimal132
9EPIC_EBR_BALBank Account Balance by Bank Receipt6BALANCEBank Account Balance on Bank Receiptdecimal132
10EPIC_EBR_FEBAdditional Data on Bank Statement Line Item for Bank Receipt22BALANCEBank Account Balance on Bank Receiptdecimal132
11EPIC_EBR_HDROBSOLETE!!!39BALANCEBank Account Balance on Bank Receiptdecimal132
12P2UN_EGRTNPO: EG Internal summary structure41BALANCEEG Advance Balancedecimal102
13VIXCITCADAOTemporary architectural object data120BALANCEBalancedecimal152
14VIXCITTASIDATATASI master data19BALANCEBalancedecimal152
TOPBank Customer Accounts
15BCA_US_DEA_ESCHEscheat Accounts Data8BALANCEAccount balancedecimal232
TOPBrazil
16T7BRCO5Compensation balance of GSW11BALANCEBalancedecimal132
TOPChina
17T7CN3FReported Tax Data22BALANCEtax report banlance to next monthdecimal152
TOPCondition
18BKK92Account Balancing (Interest and Charges)28BALANCEBalancedecimal232
19BKK9APosting and Value Date Balances Carried Forward9BALANCEBalancedecimal232
TOPFlexible Real Estate Management
20VIXCITICIDATAICI master data30BALANCEBalancedecimal152
TOPGeneral Ledger Accounting
21FAGL_BW_LOG_ITEMFI-GL: Log for BW Extraction: Line Items62BALANCEAccumulated balancedecimal172
22FAGL_BW_LOG_TOTLFI-GL: Log for BW Extraction: Totals Records40BALANCEAccumulated balancedecimal172
23FAGL_QUEUE_LOGLog of Delta Queue for Error Analysis39BALANCEAccumulated balancedecimal172
24T8G40Account assignment objects for document splitting4BALANCECreate zero balance for account assignment objectnvarchar10
TOPInterestCharge Calculation
25BKKMBALNOTBCA: Balance Notification Data6BALANCEBalance Shown in the Balance Notification (Account Currency)decimal232
TOPItaly
26T5ITIN1Contribution INAIL table9BALANCEINAIL: Balance Amountdecimal152
TOPJoint Venture und Production Sharing Accounting
27T8JKAccounts for posting exchange differences6BALANCEAccount for balance sheetnvarchar100
TOPLocalization
28RFCASH_HUExchange rate calculation log (Hungary)8BALANCECash Journal Amount Field with +/- Signdecimal152
TOPMaster Data
29BKK50Account balance4BALANCEAccount balancedecimal232
30BKK54Account Balance of Hierarchies6BALANCEAccount balancedecimal232
31BKKOVR_ACCNTItem Table: Accounts with Tolerated Overdraft17BALANCEAccount balancedecimal232
TOPProcess Controls
32GRPC_ACCOUNT_GRPAccount Group Scoping Info.8BALANCEBalance Valuedecimal152
TOPRisk Analysis
33JBRACCOUNTRM BP Update Administration for Account Balances3BALANCEAcct balancedecimal172
34JBRAMOUNTRM: Account Balance Summarization in Base Portfolio7BALANCEAcct balancedecimal172
TOPTraders and Schedulers Workbench
35OIJBRDHRD header f.batch:Don't use(obsolete) & don't delete(XPRA)88BALANCEIndicator to supress balance quantities in Stock Projectionnvarchar10
36OIJLOCMATOIL-TSW: Location Rundown/Planning material table77BALANCEIndicator to supress balance quantities in Stock Projectionnvarchar10
37OIJRDHRundown header: Don't use (obsolete) & don't delete (XPRA)87BALANCEIndicator to supress balance quantities in Stock Projectionnvarchar10
38OIJTSMATOIL-TSW: TS Rundown/Planning material table76BALANCEIndicator to supress balance quantities in Stock Projectionnvarchar10
39OIJ_RDHEADStock Projection header90BALANCEIndicator to supress balance quantities in Stock Projectionnvarchar10