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

35 columns | Print definition?ERP 6.0  | BUDCAT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1FMBCS_FMBL_CDEmpty table for change documents on FMBL incl. local. fields19BUDCATBudget Categorynvarchar20
TOPBudgeting
2BUBUDCATList of budget category instances1BUDCATBudget Categorynvarchar20
3BUBUDCATTTexts for Budget Categories1BUDCATBudget Categorynvarchar20
4BUWRTTPMapping rules for migration from FBS to BCS - Field WRTTP3BUDCATBudget Categorynvarchar20
5FMBLFunds management budget document lines (entry documents)19BUDCATBudget Categorynvarchar20
6FMBS_BOBudget Addresses5BUDCATBudget Categorynvarchar20
7FMBUDCATBudget category activation3BUDCATBudget Categorynvarchar20
8FMBUDTXTBudget texts register4BUDCATBudget Categorynvarchar20
9FMBUMANAGERManagement of budgeting enironment in FM5BUDCATdummy budget category - always initialnvarchar20
10FMBWUSBudgeting Workbench User settings5BUDCATBudget Categorynvarchar20
11FMCECGADDRSCover Groups: Assigned Budget Addresses4BUDCATBudget Categorynvarchar20
12FMCECVGRPCover Groups4BUDCATBudget Categorynvarchar20
13FMCECVGRPTTexts for Cover Groups4BUDCATBudget Categorynvarchar20
14FMCY_COPIFor CO plan data transfer11BUDCATLedgernvarchar20
15FMDISTADistribution Activation5BUDCATBudget Categorynvarchar20
16FMHBLFunds management budget document lines (held documents)19BUDCATBudget Categorynvarchar20
17FMHIEHEADERSHierarchy Nodes: Constant Parts ("Headers")5BUDCATBudget Categorynvarchar20
18FMHIEIDSHierarchy IDs5BUDCATBudget Categorynvarchar20
19FMHIEIDSTTexts for Hierarchy IDs5BUDCATBudget Categorynvarchar20
20FMHIENODESHierarchy Nodes (Without Constant Part)5BUDCATBudget Categorynvarchar20
21FMHIE_CHGCHK_FLGActivate Checks for Hierarchy Change5BUDCATBudget Categorynvarchar20
22FMKF_TERMKey Figures - FM Terms7BUDCATKey Figures - Budget Categorynvarchar20
23FMMAACTActivation of Multi-annual Budgeting3BUDCATBudget Categorynvarchar20
24FMMAPERCStandard percentage set for multi-annual budgeting3BUDCATBudget Categorynvarchar20
25FMOPENPERControl Budgeting Periods3BUDCATBudget Categorynvarchar20
26FMOPENPER_FUNDControl Budgeting Periods per Fund3BUDCATBudget Categorynvarchar20
27FMPEPLAY_COLFMPEP: layout customizing settings for columns5BUDCATBudget Categorynvarchar20
28FMPEP_VARIANTLSession variants (line part) for transaction FMPEP19BUDCATBudget Categorynvarchar20
29FMPTCOMBAAllowed combinations (process / budget type) for status4BUDCATBudget Categorynvarchar20
30FMPTCOMBAGAllowed combinations process / budget type group for status4BUDCATBudget Categorynvarchar20
TOPFunds Management
31BPREP_HRFPM_BCSVariants of Budget Creation for PBC5BUDCATBudget Categorynvarchar20
32FM2BLACT1FM2BL - Activate of FM area and FM Budget Category3BUDCATBudget Categorynvarchar20
33FM2BLACTBFM2BL - Activation of Budget Value Types3BUDCATBudget Categorynvarchar20
34FM2BLACTCFM2BL - Activation of Commitment/Actual Value Types3BUDCATBudget Categorynvarchar20
TOPPlant Maintenance
35MCB_BUDMCB Retraction data for Budget check4BUDCATBudget category for MCB Retraction datanvarchar20