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

58 columns | Print definition?ERP 6.0  | FISCYEAR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BI0/SFISCYEARMaster Data IDs: InfoObject Fiscal year2FISCYEARFiscal yearnvarchar40
2/BIC/B0000219000PSA for 0CO_OM_OPA_3 T90CLNT090 Orders: Total plan6FISCYEARnvarchar40
3/BIC/B0000221000PSA for 0CO_OM_OPA_2 T90CLNT090 Orders: Budget6FISCYEARnvarchar40
4/SMD/MD_____001ZSID-Tabelle fuer FISCYEAR3FISCYEARFiscal Yearnvarchar40
5FMBCS_FMBL_CDEmpty table for change documents on FMBL incl. local. fields9FISCYEARFiscal Yearnvarchar40
6RSR_TIME_REL_FISTime Relations for Planning5FISCYEARnvarchar40
TOPAccounting Engine
7/EACC/T_MSG_CTXTReduced Persistent View of Message Context Objects8FISCYEARFiscal Yearnvarchar40
TOPBudgeting
8FMBLFunds management budget document lines (entry documents)9FISCYEARFiscal Yearnvarchar40
9FMBS_BOBudget Addresses4FISCYEARFiscal Yearnvarchar40
10FMBS_CONTROLBudget structure settings on FM area and fiscal year level3FISCYEARFiscal Yearnvarchar40
11FMBS_CONTROL_LDRBS settings FM area, fisc. year and posting ledger3FISCYEARFiscal Yearnvarchar40
12FMBS_VERS_ASSBudget Addresses settings on the version level3FISCYEARFiscal Yearnvarchar40
13FMBUDTXTBudget texts register8FISCYEARFiscal Yearnvarchar40
14FMBUMANAGERManagement of budgeting enironment in FM3FISCYEARFiscal Yearnvarchar40
15FMBUSTATUSStatus and budget addresses settings on the version level3FISCYEARFiscal Yearnvarchar40
16FMCC_CUST_LIBFM - Consistency checks - Assignment of libraries4FISCYEARFiscal Yearnvarchar40
17FMCECGADDRSCover Groups: Assigned Budget Addresses3FISCYEARFiscal Yearnvarchar40
18FMCECVGRPCover Groups3FISCYEARFiscal Yearnvarchar40
19FMCECVGRPTTexts for Cover Groups3FISCYEARFiscal Yearnvarchar40
20FMDISTADistribution Activation4FISCYEARFiscal Yearnvarchar40
21FMHBLFunds management budget document lines (held documents)9FISCYEARFiscal Yearnvarchar40
22FMHIEHEADERSHierarchy Nodes: Constant Parts ("Headers")3FISCYEARFiscal Yearnvarchar40
23FMHIEIDSHierarchy IDs3FISCYEARFiscal Yearnvarchar40
24FMHIEIDSTTexts for Hierarchy IDs3FISCYEARFiscal Yearnvarchar40
25FMHIENODESHierarchy Nodes (Without Constant Part)3FISCYEARFiscal Yearnvarchar40
26FMHIE_CHGCHK_FLGActivate Checks for Hierarchy Change4FISCYEARFiscal Yearnvarchar40
27FMKF_TERMKey Figures - FM Terms12FISCYEARKey Figures - Fiscal Yearnvarchar40
28FMKF_TERM_AVCKey Figures - FM AVC Term10FISCYEARKey Figures - Fiscal Yearnvarchar40
29FMKF_TERM_RBKey Figures - FM Terms11FISCYEARKey Figures - Fiscal Yearnvarchar40
30FMMACGPERCPercentage per cover group (Multi-annual budgeting)3FISCYEARFiscal Yearnvarchar40
31FMMIGDOCMigrated Documents7FISCYEARFiscal Yearnvarchar40
32FMMIGOVOverview of Migration Status6FISCYEARFiscal Yearnvarchar40
33FMMIGPARPartially Migrated Documents7FISCYEARFiscal Yearnvarchar40
34FMOPENPERControl Budgeting Periods5FISCYEARFiscal Yearnvarchar40
35FMOPENPER_FUNDControl Budgeting Periods per Fund5FISCYEARFiscal Yearnvarchar40
36FMPEPLAY_COLFMPEP: layout customizing settings for columns8FISCYEARFMPEP - Fiscal Yearnvarchar40
37FMPEP_VARIANTHSession variants (header part) for transaction FMPEP6FISCYEARFiscal Yearnvarchar40
38FMPEP_VARIANTLSession variants (line part) for transaction FMPEP8FISCYEARFiscal Yearnvarchar40
39FMRBBOBJECTSMaster Data For Revenue Increasing the Budget: RIB Objects3FISCYEARFiscal Yearnvarchar40
40FMRBBRECSMaster Data For RIB: Budget Receivers per RIB Object3FISCYEARFiscal Yearnvarchar40
TOPBudgeting and Availability Control
41GMFMRECSGM RIB: FM Receivers (obsolete)7FISCYEARFiscal Yearnvarchar40
42GMFMRECS1GM RIB: FM Budget Receivers4FISCYEARFiscal Yearnvarchar40
43GMRBFMRECGM RIB: FM Budget Receivers5FISCYEARFiscal Yearnvarchar40
TOPBusiness Consolidation
44UCF9030Balance Carryforward: Restatement Assignment5FISCYEARFiscal Yearnvarchar40
45UCST001SEM-BCS: Performance Statistics14FISCYEARFiscal Yearnvarchar40
46UCT9100Workflow Documents: Status4FISCYEARFiscal Yearnvarchar40
47UCT910CWorkflow Documents, Held Documents, Reference Documents7FISCYEARFiscal Yearnvarchar40
48UCT9110Workflow Documents: Approval Actions4FISCYEARFiscal Yearnvarchar40
49UCT9190Log for Methods Calling of BAdI UC_WFV_DOC4FISCYEARFiscal Yearnvarchar40
TOPData Basis
50RSR_REL_TIME_FISTime Relations for Planning4FISCYEARnvarchar40
TOPFlexible Real Estate Management
51TIVXCITCALCDBUDICI Calculation coefficient for D-Building2FISCYEARFiscal Yearnvarchar40
TOPFund Accounting
52FMCCAVCRESERVECCAVC aux table for reserved items13FISCYEARFiscal Yearnvarchar40
TOPLocalization
53TIVXCPTPOSTPARTechnical Parameters for Postings and Payments (obsolate)2FISCYEARFiscal Yearnvarchar40
54VIXCFRAPLOGLog of Calculation of Complementary Budget Amounts3FISCYEARFiscal Yearnvarchar40
TOPPortfolio Management
55RPM_FIDATAFinancial Information7FISCYEARFiscal Yearnvarchar40
56RPM_PROJECT_COControlling Information about a project6FISCYEARFiscal Yearnvarchar40
57RPM_SCENARIO_FINRPM : Scenario financial data4FISCYEARFiscal Yearnvarchar40
TOPPosition Budgeting and Control
58HRFPM_BPREP_DATAPreprocesses Data for BPREP Data Extraction6FISCYEARFiscal Yearnvarchar40