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

50 columns | Print definition?ERP 6.0  | FONDS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1FMADB_DEFAULT_AAFMADB: Default Account Assignment for Petty Amounts6FONDSFundnvarchar100
2FMADB_TC_WEIGHTSFMADB: Trace - Saved Weights (Last Run)9FONDSFundnvarchar100
3T77PRNL_BEGRELPension Return: Determination of Pension Rel. Start Date2FONDSPension Fundnvarchar40
4ZEIM_VBAPSales Document: Item Data240FONDSFundnvarchar100
5CMACGRANTGrant Master Data17FONDSFundnvarchar100
6T7PIQSINGLEFEESDefine Attributes for Individual Fees23FONDSFundnvarchar100
7TCMAC06DDerivation of ISR Scenario Related Data21FONDSFundnvarchar100
TOPBilling
8VBRPBilling Document: Item Data209FONDSFundnvarchar100
TOPBudgeting and Availability Control
9FMCDCFAssign Commitment Item to Fund5FONDSFundnvarchar100
10FMCDRBRevenues Increasing the Budget Government of Canada4FONDSFundnvarchar100
11FMCDRBERevenues Increasing Budget Government of Canada (Receiver)4FONDSSender fundnvarchar100
12FMFCTRMVStore Bgt vals. returned before moving funds ctr.6FONDSFundnvarchar100
TOPContract Accounts Receivable and Payable
13DFKKCASHFCInterim Table for Cash Management and Forecast Data14FONDSFundnvarchar100
14DFKKFMDYINFOLog Data for Subsequent FM Activation in FI-CA6FONDSFundnvarchar100
15DFKKOPAADistribution Items with Account Assignment25FONDSFundnvarchar100
16DFKKOP_REPOpen Items from FPO4159FONDSFundnvarchar100
17DFKKRP3Returns: Manual Posting Specifications25FONDSFundnvarchar100
18DFKKSUMPosting totals from FI-CA62FONDSFundnvarchar100
19DFKKSUMOLDTotals Records Without Account Assignment Changes18FONDSFundnvarchar100
20FMCA_CLEAR_ACCMaintain Assgt of Clarification Worklist to FM Acct Assgt6FONDSFundnvarchar100
21TFKFMDY2Account Assignments for Subsequent FM Activation5FONDSFundnvarchar100
TOPFund Accounting
22FMADB_ENTITYADB: Entities Involved in Procedure4FONDSFundnvarchar100
TOPFunds Management
23FMCDRBBSFM Rev. Incr. Budget History - Government Canada4FONDSSender fundnvarchar100
24FMCFSIFFI-FM: Selected Open Documents from FI Update25FONDSFundnvarchar100
25FMCFSIF_TRSelected Open FI Documents (Settlement)25FONDSFundnvarchar100
26FMCFSIOFI-FM: Selected Open Commitment Documents28FONDSFundnvarchar100
27FMCFSIO_TRFI-FM: Selected Open Commitment Documents28FONDSFundnvarchar100
28FMDECK3Cover eligibility: amount management for sender budget obj.6FONDSFundnvarchar100
29FMDECKHKAssignment of FM Account Assignment to Cover Pool4FONDSFundnvarchar100
30FMDECKHKCAssignment of FM Account Assignment to Cover Pool5FONDSFundnvarchar100
31FMDECKRGCover Pool5FONDSFundnvarchar100
32FMDECKUNGAssignment of a Cover Pool to an FM Account Assignment5FONDSFundnvarchar100
33FMFUNDSELFIFM: Selected Fund for Closing Operations4FONDSFundnvarchar100
34FMFYCVAValue Adjustments Before Fiscal Year Change18FONDSFundnvarchar100
35FMIAAAssignment Table for Budget Ledger7FONDSFundnvarchar100
36FMICOITFM/CO integration: Line item13FONDSFundnvarchar100
37FMIFIITFI Line Item Table in Funds Management19FONDSFundnvarchar100
38FMIOObject Table for Funds Management9FONDSFundnvarchar100
39FMIOICommitment Documents Funds Management25FONDSFundnvarchar100
40FMUDPOOLAssignment of Cover Pool to Rev. Increasing FM Acct Assgmt4FONDSFundnvarchar100
41FMUDPOOLCAssignment of Cover Pool to Rev. Increasing FM Acct Assgmt4FONDSFundnvarchar100
42FMUDRULERules for Revenues Increasing Budget4FONDSFundnvarchar100
43FMUDRULECRules for Revenues Increasing the Budget4FONDSFundnvarchar100
44FMZUCHChange information on allocation of CO Object to FM Object12FONDSFundnvarchar100
45FMZUGRAllocation of CO Group to FM Account Assignment12FONDSFundnvarchar100
46FMZUOBAllocation of CO Object to FM Account Assignment10FONDSFundnvarchar100
TOPLocalization
47ITFM_D_RESIDUALSITFM: Residuals: EFD Residuals data Table13FONDSFundnvarchar100
TOPNetherlands
48T5N1QPension Accounting (NL)25FONDSPension Fundnvarchar40
TOPReporting
49T5N5PPension Schemes (NL)5FONDSPension Fundnvarchar40
TOPSales
50VBAPSales Document: Item Data247FONDSFundnvarchar100