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

88 columns | Print definition?ERP 6.0  | MEASURE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/FORDOCSPLITDocument Header and Line details for Splitting8MEASUREFunded Programnvarchar240
2BSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)76MEASUREFunded Programnvarchar240
3BSEGAccounting Document Segment314MEASUREFunded Programnvarchar240
4BSIS_BAKAccounting: Secondary Index for G/L Accounts76MEASUREFunded Programnvarchar240
5FMADB_DEFAULT_AAFMADB: Default Account Assignment for Petty Amounts9MEASUREFunded Programnvarchar240
6FMADB_TC_WEIGHTSFMADB: Trace - Saved Weights (Last Run)12MEASUREFunded Programnvarchar240
7FMBASOBJNR_TRACETrace for table FMBASOBJNR9MEASUREFunded Programnvarchar240
8FMBCS_FMBL_CDEmpty table for change documents on FMBL incl. local. fields17MEASUREFunded Programnvarchar240
9FUDT_VDOCBSEGVerification Document Item with Additional Info303MEASUREFunded Programnvarchar240
10FUDT_VDOCBSEGEVVerification Document Item in the Entry View303MEASUREFunded Programnvarchar240
11FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)303MEASUREFunded Programnvarchar240
12GLPOS_C_CTFI Document: Entry View173MEASUREFunded Programnvarchar240
13GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items173MEASUREFunded Programnvarchar240
14GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items173MEASUREFunded Programnvarchar240
15GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items173MEASUREFunded Programnvarchar240
16GLPOS_N_CTNew General Ledger: Line Item with Currency Type176MEASUREFunded Programnvarchar240
17GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type176MEASUREFunded Programnvarchar240
18T7PIQSINGLEFEESDefine Attributes for Individual Fees25MEASUREFunded Programnvarchar240
TOPAccounting Interface
19GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)410MEASUREFunded Programnvarchar240
20GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)410MEASUREFunded Programnvarchar240
TOPActual Update and Commitment Update
21GMREVBDGTFM1Defult settings for GM revaluation of currency8MEASUREFunded Programnvarchar240
TOPAvailability Control
22FMAVCOObject table 114MEASUREFunded Programnvarchar240
TOPBudget Control System
23FMBASOBJNRObject numbers for FM addresses11MEASUREFunded Programnvarchar240
TOPBudgeting
24BUCC_RULEConsistency Checks - Rules19MEASUREKey Figures - Program in Funds Managementnvarchar10
25FMBDOObject table 1 - Budget address14MEASUREFunded Programnvarchar240
26FMBLFunds management budget document lines (entry documents)17MEASUREFunded Programnvarchar240
27FMHBLFunds management budget document lines (held documents)17MEASUREFunded Programnvarchar240
28FMPEP_VARIANTLSession variants (line part) for transaction FMPEP17MEASUREFunded Programnvarchar240
29FMRBOObject table 114MEASUREFunded Programnvarchar240
TOPBudgeting and Availability Control
30GMBDGTFYDLINEGM Budgeting Fiscal Year Distribution Lines19MEASUREFunded Programnvarchar240
31GMFMRECSGM RIB: FM Receivers (obsolete)10MEASUREFunded Programnvarchar240
32GMFMRECS1GM RIB: FM Budget Receivers7MEASUREFunded Programnvarchar240
33GMHBDGTFYDLINEGM Budgeting Fiscal Year Distribution Lines20MEASUREFunded Programnvarchar240
TOPContract Accounts Receivable and Payable
34DFKKFMBGAINFOTax Information for Public-Owned Commercial Operations12MEASUREFunded Programnvarchar240
35DFKKFMDYINFOLog Data for Subsequent FM Activation in FI-CA8MEASUREFunded Programnvarchar240
36DFKKOPAADistribution Items with Account Assignment27MEASUREFunded Programnvarchar240
37DFKKOP_REPOpen Items from FPO4161MEASUREFunded Programnvarchar240
38DFKKRP3Returns: Manual Posting Specifications27MEASUREFunded Programnvarchar240
39DFKKSUMPosting totals from FI-CA64MEASUREFunded Programnvarchar240
40DFKKSUMOLDTotals Records Without Account Assignment Changes20MEASUREFunded Programnvarchar240
41TFKFMDY2Account Assignments for Subsequent FM Activation7MEASUREFunded Programnvarchar240
TOPDepreciation Simulation
42IMCCIM Summarization: Characteristics that are master data9MEASUREMeasure: Identification for internal usenvarchar260
43IMCEMIM Summarization: Measures3MEASUREMeasure: Identification for internal usenvarchar260
44IMCEMTIM Summarization: Texts for measures4MEASUREMeasure: Identification for internal usenvarchar260
TOPFinancial Accounting
45ACCTITCompressed Data from FI/CO Document162MEASUREFunded Programnvarchar240
46BSASAccounting: Secondary Index for G/L Accounts (Cleared Items)76MEASUREFunded Programnvarchar240
47BSISAccounting: Secondary Index for G/L Accounts76MEASUREFunded Programnvarchar240
48VBSEGADocument Segment for Document Parking - Asset Database89MEASUREFunded Programnvarchar240
49VBSEGSDocument Segment for Document Parking - G/L Account Database144MEASUREFunded Programnvarchar240
TOPFunctions for U.S. Federal Government
50FMFGKEYKey for Facts-Attributes for Ledger 95/FMUSFGT4MEASUREFunded Programnvarchar240
51FMFGKEY96Key for FACTS - Attributes for Ledger 96/FMUSFGFACTS1T11MEASUREFunded Programnvarchar240
52FMFGKEY97Key for FACTS - Attributes for Ledger 97/FMUSFGFACTS2T4MEASUREFunded Programnvarchar240
TOPFund Accounting
53FMADB_ENTITYADB: Entities Involved in Procedure7MEASUREFunded Programnvarchar240
TOPFunds Management
54FMFG_SAV_FACTS1ASaved FACTS1A data for docs excluded from SL Repost for 60064MEASUREFunded Programnvarchar240
55FMFG_SAV_FACTS2ASaved FACTS2A data for docs excluded from SL Repost for 60062MEASUREFunded Programnvarchar240
56FMFG_SAV_FMUSFGASaved FMUSFGA data for docs excluded from SL Repost for 60090MEASUREFunded Programnvarchar240
57FMIFIITFI Line Item Table in Funds Management22MEASUREFunded Programnvarchar240
58FMIOObject Table for Funds Management21MEASUREFunded Programnvarchar240
59FMIOICommitment Documents Funds Management28MEASUREFunded Programnvarchar240
60FMSPLITAActual line item table37MEASUREFunded Programnvarchar240
61FMSPLITCObject table 25MEASUREFunded Programnvarchar240
62FMSPLITPPlan line items table69MEASUREFunded Programnvarchar240
63FMSPLITTSummary table24MEASUREFunded Programnvarchar240
64FMUSFGAActual line item table for US Federal Government.90MEASUREFunded Programnvarchar240
65FMUSFGFACTS1A4Actual line item table64MEASUREFunded Programnvarchar240
66FMUSFGFACTS1TSummary table73MEASUREFunded Programnvarchar240
67FMUSFGFACTS2AActual line item table62MEASUREFunded Programnvarchar240
68FMUSFGFACTS2TSummary table71MEASUREFunded Programnvarchar240
69FMUSFGTSummary table for US Federal Government68MEASUREFunded Programnvarchar240
70FMZUOBAllocation of CO Object to FM Account Assignment16MEASUREFunded Programnvarchar240
71IAOM_GTR_EXATGrantor: Account Assignment Manager External Characteristics9MEASUREFunded Programnvarchar240
72KBLPDocument Item: Manual Document Entry92MEASUREFunded Programnvarchar240
TOPFunds Management-Specific Postings
73FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years125MEASUREFunded Programnvarchar240
74PSOSEGADocument Segment for Assets Document Parking46MEASUREFunded Programnvarchar240
75PSOSEGSRecurring Request Document Segment, G/L Accounts137MEASUREFunded Programnvarchar240
TOPGeneral Ledger Accounting
76BSEG_ADDEntry View of Accounting Document for Additional Ledgers72MEASUREFunded Programnvarchar240
77FAGL_SPLINFOSplittling Information of Open Items74MEASUREFunded Programnvarchar240
TOPGrantee Management
78GMIAActual Line Item Table58MEASUREFunded Programnvarchar240
TOPInvoice Verification
79RBCODocument Item, Incoming Invoice, Account Assignment77MEASUREFunded Programnvarchar240
TOPMaster Data
80FMMEASUREFM Funded Program Master Data3MEASUREFunded Programnvarchar240
81FMMEASURETFM Funded Program Text Table4MEASUREFunded Programnvarchar240
82GMSPPROGRAMSponsored program master7MEASUREObsolete - do not usenvarchar240
83GMSPPROGRAM_FMBTSponsored Program Master Data - Budget Transfer Objects6MEASUREFunded Programnvarchar240
TOPPurchasing
84EKCPAPurchasing Contract Commitment Plan Account Assignment Data23MEASUREFunded Programnvarchar240
TOPRental Accounting
85VIEXCFCNDNSCash Flow Summarization31MEASUREProgram in Funds Managementnvarchar240
86VIRADOCITEMRE Document Item36MEASUREProgram in Funds Managementnvarchar240
87VITMOATerm: Organizational Assignment16MEASUREProgram in Funds Managementnvarchar240
TOPRepetitive Manufacturing
88COMPMOVEGoods Movement of Components136MEASUREFunded Programnvarchar240