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

76 columns | Print definition?ERP 6.0  | FAREA

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPF15/XXBPDZF15 FI DUMMY9FAREAnvarchar40
2DFKK_FAVFavorites5FAREANatural Numberint100
3FMADB_DEFAULT_AAFMADB: Default Account Assignment for Petty Amounts8FAREAFunctional Areanvarchar160
4FMADB_TC_WEIGHTSFMADB: Trace - Saved Weights (Last Run)11FAREAFunctional Areanvarchar160
5T5PPBS0PHR-PT-PS: OBSOLETE11FAREAFunctional Areanvarchar30
6T5PPBS9FAPortugal Public Sector - BDAP - Function Area3FAREAFunctional Areanvarchar30
7T5PPBS9FATPortugal Public Sector - BDAP - Function Area Texts4FAREAFunctional Areanvarchar30
8ZSAWOObject table 111FAREAFunctional Areanvarchar160
9ZSPLITOObjekttabelle 110FAREAFunktionsbereichnvarchar160
10ZZ001OObject Table 111FAREAFunctional Areanvarchar160
11ZZLINEOObject table 110FAREAFunctional Areanvarchar160
12ZZSPECOObject table 110FAREAFunctional Areanvarchar160
TOPBasic Functions
13GGREFOExample for Global Object Table 1 (Object/Partner)12FAREAFunctional Areanvarchar160
14GLFUNCOObject Table 1 for Cost of Sales Accounting10FAREAFunctional Areanvarchar160
15GLREFOExample for Local Object Table 1 (Object/Partner)11FAREAFunctional Areanvarchar160
TOPCost Element Accounting
16COFIO1Object Table for Reconciliation Ledger COFIT13FAREAFunctional Areanvarchar160
TOPFinancial Services Localization
17/CEEIS/RUOObject table 111FAREAFunctional Areanvarchar160
TOPFund Accounting
18FMADB_ENTITYADB: Entities Involved in Procedure6FAREAFunctional Areanvarchar160
19FMCCAVCOObject table 112FAREAFunctional Areanvarchar160
20FMCCAVCRESERVECCAVC aux table for reserved items11FAREAFunctional Areanvarchar160
21FMCCBASOBJNRObject numbers for CC addresses10FAREAFunctional Areanvarchar160
TOPFunds Management
22BPDZLine Entry Document9FAREAFunctional Areanvarchar160
23BPEGLine Item Overall Values Controlling Obj.20FAREAFunctional Areanvarchar160
24BPEJLine Item Annual Values Controlling Obj.23FAREAFunctional Areanvarchar160
25BPEPLine Item Period Values Controlling Obj.51FAREAFunctional Areanvarchar160
26BPGETotals Record for Total Value Controlling obj.12FAREAFunctional Areanvarchar160
27BPHICross-hierarchy Data Controlling obj.7FAREAFunctional Areanvarchar160
28BPIGBudget Object Index (Overall Budget)8FAREAFunctional Areanvarchar160
29BPIJBudget Object Index (Annual Budget)10FAREAFunctional Areanvarchar160
30BPJATotals Record for Annual Total Controlling Obj.14FAREAFunctional Areanvarchar160
31BPPETotals Record for Period Values Controlling Obj.14FAREAFunctional Areanvarchar160
32BPTRObject Data Controlling Obj.8FAREAFunctional Areanvarchar160
33BPTXBudgeting Text12FAREAFunctional Areanvarchar160
34FMBUDFI-FM Data Transfer Structure FM4C23FAREAFunctional Areanvarchar160
35FMCFAATR-FM: Commitments/Budget Carried Forward7FAREAFunctional Areanvarchar160
36FMCFAASTR-FM: Commitments/Budget Carried Forward (Interim Storage)7FAREAFunctional Areanvarchar160
37FMCFAAS_TRTR-FM: Commitments/Budget Carried Forward (Interim Storage)8FAREAFunctional Areanvarchar160
38FMCFAA_TRTR-FM: Commitments/Budget Carried Forward8FAREAFunctional Areanvarchar160
39FMCFABTR-FM: Commitments/Budget Carried Forward (Sender+Receiver)7FAREAFunctional Areanvarchar160
40FMCFABSTR-FM: Transferred Commitment/Budget (Senders+Receivers)7FAREAFunctional Areanvarchar160
41FMCFABS_TRTR-FM: Transferred Commitment/Budget (Senders+Receivers)7FAREAFunctional Areanvarchar160
42FMCFAB_TRTR-FM: Commitments/Budget Carried Forward (Sender+Receiver)8FAREAFunctional Areanvarchar160
43FMCFSBFM - CF: Carryforward rules5FAREAFunctional Areanvarchar160
44FMCFSIFFI-FM: Selected Open Documents from FI Update28FAREAFunctional Areanvarchar160
45FMCFSIF_TRSelected Open FI Documents (Settlement)27FAREAFunctional Areanvarchar160
46FMCFSIOFI-FM: Selected Open Commitment Documents31FAREAFunctional Areanvarchar160
47FMCFSIO_TRFI-FM: Selected Open Commitment Documents31FAREAFunctional Areanvarchar160
48FMCOPICO-FM: Plan Data Transfer - Annual/Overall Values14FAREAFunctional Areanvarchar160
49FMDECKHKAssignment of FM Account Assignment to Cover Pool5FAREAFunctional Areanvarchar160
50FMDECKHKCAssignment of FM Account Assignment to Cover Pool6FAREAFunctional Areanvarchar160
51FMFG_SAV_FACTS2ASaved FACTS2A data for docs excluded from SL Repost for 60029FAREAFunctional Areanvarchar160
52FMFYCVAValue Adjustments Before Fiscal Year Change20FAREAFunctional Areanvarchar160
53FMIFIITFI Line Item Table in Funds Management21FAREAFunctional Areanvarchar160
54FMIOObject Table for Funds Management20FAREAFunctional Areanvarchar160
55FMIOICommitment Documents Funds Management27FAREAFunctional Areanvarchar160
56FMREFActive availability ctrl: Cross commitments reference table17FAREAFunctional Areanvarchar160
57FMSPLITOObject table 112FAREAFunctional Areanvarchar160
58FMUDPOOLAssignment of Cover Pool to Rev. Increasing FM Acct Assgmt5FAREAFunctional Areanvarchar160
59FMUDPOOLCAssignment of Cover Pool to Rev. Increasing FM Acct Assgmt5FAREAFunctional Areanvarchar160
60FMUDRULERules for Revenues Increasing Budget5FAREAFunctional Areanvarchar160
61FMUDRULECRules for Revenues Increasing the Budget5FAREAFunctional Areanvarchar160
62FMUSFGFACTS1OObject table 120FAREAFunctional Areanvarchar160
63FMUSFGFACTS2AActual line item table29FAREAFunctional Areanvarchar160
64FMUSFGFACTS2CObject table 24FAREAFunctional Areanvarchar160
65FMUSFGFACTS2PPlan line items table29FAREAFunctional Areanvarchar160
66FMUSFGFACTS2TSummary table28FAREAFunctional Areanvarchar160
67FMUSFGOObject table 1 for US Federal Government13FAREAFunctional Areanvarchar160
68FMZUOBAllocation of CO Object to FM Account Assignment12FAREAFunctional Areanvarchar160
69TBPFMXActive availability control on commitment budget7FAREAFunctional Areanvarchar160
TOPGrantee Management
70GMIAActual Line Item Table57FAREAFunctional Areanvarchar160
TOPLocalization
71ITFM_D_RESIDUALSITFM: Residuals: EFD Residuals data Table16FAREAFunctional Areanvarchar160
TOPPortugal
72PA0337HR Master Record: Infotype 0337 (Prof.Classification - PT)33FAREAFunctional Areanvarchar30
TOPProfit Center Accounting
73GLPCOEC-PCA: Object Table for Account Assignment Elements10FAREAFunctional Areanvarchar160
TOPRetail Ledger
74PCRRETAILOObject Table 111FAREAFunctional Areanvarchar160
TOPRevenues and Earnings
75AD01DLIDynamic items (DI)48FAREAFunctional Areanvarchar160
TOPTariffs, Duties and Permits
76OIHEDOObject table 1, IS-OIL Excise Duty Special Ledger18FAREAFunctional Areanvarchar160