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

156 columns | Print definition?ERP 6.0  | FM_AREA

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/AT_APPR_HISApproval History for Level Based Approvals74FM_AREAFinancial Management Areanvarchar40
2/OPT/AT_LBA_LOGApproval History for Level Based Approvals75FM_AREAFinancial Management Areanvarchar40
3BBP_PCACCProcurement Card: Accounting Data7FM_AREAFinancial Management Areanvarchar40
4BBP_PCMASProcurement Card Master Data24FM_AREAFinancial Management Areanvarchar40
5BBP_PCMODProcurement Card: Modified Statement Data9FM_AREAFinancial Management Areanvarchar40
6CNFM_FMBLExtension table for table FMBL (localization PSM China)2FM_AREAFinancial Management Areanvarchar40
7CNFM_FMHBLExtension table for table FMHBL (localization PSM China)2FM_AREAFinancial Management Areanvarchar40
8FMBCS_FMBL_CDEmpty table for change documents on FMBL incl. local. fields2FM_AREAFinancial Management Areanvarchar40
9FMPEP_ADM_SVSession Variants administration2FM_AREAFinancial Management Areanvarchar40
10FMPEP_VARIANTHTSession Variant Text3FM_AREAFinancial Management Areanvarchar40
TOPActual Update and Commitment Update
11GMREVBDGTFM1Defult settings for GM revaluation of currency3FM_AREAFinancial Management Areanvarchar40
TOPAvailability Control
12FMAVCACTCDActivation of Change Documents for FMAVCT Records2FM_AREAFinancial Management Areanvarchar40
13FMAVCBUDFILTBAVC filter settings for FM budget values: valid budget types2FM_AREAFinancial Management Areanvarchar40
14FMAVCBUDFILTHAVC filter settings for FM budget values: header entries2FM_AREAFinancial Management Areanvarchar40
15FMAVCLDGRACTActivation of availability ledger for Funds Management2FM_AREAFinancial Management Areanvarchar40
16FMAVCLDGRATTAttributes of Availability Control Ledger (Funds Management)2FM_AREAFinancial Management Areanvarchar40
17FMAVCLDGRGATYear-Independent Attributes of Control Ledger (FM)2FM_AREAFinancial Management Areanvarchar40
18FMAVCUPDFILTHAVC Filter Settings for FM Posting Data: Header Entries2FM_AREAFinancial Management Areanvarchar40
19FMAVCUPDFILTVAVC Filter Settings for Posting Data: Excluded Value Types2FM_AREAFinancial Management Areanvarchar40
20FMAVC_RBE_SETAVC Ledger Settings for RBE2FM_AREAFinancial Management Areanvarchar40
TOPBudget Control System
21FMBASIDXIndex table for budget structure and AVC2FM_AREAFinancial Management Areanvarchar40
TOPBudgeting
22FMACTIVPERActivate Period Control Budgeting2FM_AREAFinancial Management Areanvarchar40
23FMBCSABudget Control System activation settings2FM_AREAFinancial Management Areanvarchar40
24FMBCSA_USERUser specific Budget Control System activation settings2FM_AREAFinancial Management Areanvarchar40
25FMBHFunds management budget header (entry documents)2FM_AREAFinancial Management Areanvarchar40
26FMBLFunds management budget document lines (entry documents)2FM_AREAFinancial Management Areanvarchar40
27FMBSCDACTActivation of Change Documents for Budget Structure2FM_AREAFinancial Management Areanvarchar40
28FMBS_BOBudget Addresses2FM_AREAFinancial Management Areanvarchar40
29FMBS_BSBudget structures2FM_AREAFinancial Management Areanvarchar40
30FMBS_BS_TTexts for Budget Structures2FM_AREAFinancial Management Areanvarchar40
31FMBS_CONTROLBudget structure settings on FM area and fiscal year level2FM_AREAFinancial Management Areanvarchar40
32FMBS_CONTROL_LDRBS settings FM area, fisc. year and posting ledger2FM_AREAFinancial Management Areanvarchar40
33FMBS_HIE_ACTActivation of Hierarchical Budget Structure2FM_AREAFinancial Management Areanvarchar40
34FMBS_VERS_ASSBudget Addresses settings on the version level2FM_AREAFinancial Management Areanvarchar40
35FMBTGDEFBudget Group content definition2FM_AREAFinancial Management Areanvarchar40
36FMBTGROUPBudget Type Group definition2FM_AREAFinancial Management Areanvarchar40
37FMBTGROUPTText for Budget Type Group2FM_AREAFinancial Management Areanvarchar40
38FMBUDCATBudget category activation2FM_AREAFinancial Management Areanvarchar40
39FMBUDTXTBudget texts register3FM_AREAFinancial Management Areanvarchar40
40FMBUDTXT_KEYBudget Text Key Customizing3FM_AREAFinancial Management Areanvarchar40
41FMBUDTYPEBudget type definition2FM_AREAFinancial Management Areanvarchar40
42FMBUDTYPETTexts for Budget Types2FM_AREAFinancial Management Areanvarchar40
43FMBUMANAGERManagement of budgeting enironment in FM2FM_AREAFinancial Management Areanvarchar40
44FMBUSTATUSStatus and budget addresses settings on the version level2FM_AREAFinancial Management Areanvarchar40
45FMBWUDUser Documents3FM_AREAFinancial Management Areanvarchar40
46FMCCFBDGT_CNTRLCustomizing settings: creation of budget during ccf2FM_AREAFinancial Management Areanvarchar40
47FMCCFBDGT_CUSTCustomizing settings: creation of budget during ccf2FM_AREAFinancial Management Areanvarchar40
48FMCC_CUST_LIBFM - Consistency checks - Assignment of libraries2FM_AREAFinancial Management Areanvarchar40
49FMCEACTActivation of Cover Elibility2FM_AREAFinancial Management Areanvarchar40
50FMCECDACTActivation of Change Documents for Cover Elibility2FM_AREAFinancial Management Areanvarchar40
51FMCECGADDRSCover Groups: Assigned Budget Addresses2FM_AREAFinancial Management Areanvarchar40
52FMCECVGRPCover Groups2FM_AREAFinancial Management Areanvarchar40
53FMCECVGRPTTexts for Cover Groups2FM_AREAFinancial Management Areanvarchar40
54FMCONSUM_FTYPEConsumable budget type for Fund Type2FM_AREAFinancial Management Areanvarchar40
55FMCONSUM_FUNDConsumable budget type for Fund2FM_AREAFinancial Management Areanvarchar40
56FMCUPRPCDACTActivation of Change History for Preposted Documents2FM_AREAFinancial Management Areanvarchar40
57FMCUPRPCOMAssignment of Field Profiles for Preposted Budget Documents2FM_AREAFinancial Management Areanvarchar40
58FMDIMSTATEDefinition of state for account assignment element2FM_AREAFinancial Management Areanvarchar40
59FMDISTADistribution Activation2FM_AREAFinancial Management Areanvarchar40
60FMDISTCDistribution Checks2FM_AREAFinancial Management Areanvarchar40
61FMDISTCKDistribution Checks2FM_AREAFinancial Management Areanvarchar40
62FMEDFORMS_WDAssignment of Forms for Entry document2FM_AREAFinancial Management Areanvarchar40
63FMFSVAAssignment of Field Status Variant2FM_AREAFinancial Management Areanvarchar40
64FMHBHFunds management budget header (held documents)2FM_AREAFinancial Management Areanvarchar40
65FMHBLFunds management budget document lines (held documents)2FM_AREAFinancial Management Areanvarchar40
66FMHIEHEADERSHierarchy Nodes: Constant Parts ("Headers")2FM_AREAFinancial Management Areanvarchar40
67FMHIEIDSHierarchy IDs2FM_AREAFinancial Management Areanvarchar40
68FMHIEIDSTTexts for Hierarchy IDs2FM_AREAFinancial Management Areanvarchar40
69FMHIENODESHierarchy Nodes (Without Constant Part)2FM_AREAFinancial Management Areanvarchar40
70FMHIESETTINGSSettings for Budget Hierarchies2FM_AREAFinancial Management Areanvarchar40
71FMHIE_CHGCHK_FLGActivate Checks for Hierarchy Change2FM_AREAFinancial Management Areanvarchar40
72FMMAACTActivation of Multi-annual Budgeting2FM_AREAFinancial Management Areanvarchar40
73FMMACGPERCPercentage per cover group (Multi-annual budgeting)2FM_AREAFinancial Management Areanvarchar40
74FMMAPERCStandard percentage set for multi-annual budgeting2FM_AREAFinancial Management Areanvarchar40
75FMMIGDOCMigrated Documents6FM_AREAFinancial Management Areanvarchar40
76FMMIGOVOverview of Migration Status2FM_AREAFinancial Management Areanvarchar40
77FMMIGPARPartially Migrated Documents6FM_AREAFinancial Management Areanvarchar40
78FMOPENPERControl Budgeting Periods2FM_AREAFinancial Management Areanvarchar40
79FMOPENPER_FUNDControl Budgeting Periods per Fund2FM_AREAFinancial Management Areanvarchar40
80FMORGFAVBCS : Organizer Favorites4FM_AREAFinancial Management Areanvarchar40
81FMPEP_VARIANTHSession variants (header part) for transaction FMPEP2FM_AREAFinancial Management Areanvarchar40
82FMPEP_VARIANTLSession variants (line part) for transaction FMPEP2FM_AREAFinancial Management Areanvarchar40
83FMPROFILEProfile for BCS budgeting2FM_AREAFinancial Management Areanvarchar40
84FMPTCOMBAllowed combinations (process / budget type)2FM_AREAFinancial Management Areanvarchar40
85FMPTCOMBAAllowed combinations (process / budget type) for status2FM_AREAFinancial Management Areanvarchar40
86FMPTCOMBAGAllowed combinations process / budget type group for status2FM_AREAFinancial Management Areanvarchar40
87FMPTCOMBGAllowed Combinations Process/Budget Type Using BT Groups2FM_AREAFinancial Management Areanvarchar40
88FMRBACTRIB Customizing Settings2FM_AREAFinancial Management Areanvarchar40
89FMRBACTCDActivation of Change Documents for FMRBT Records2FM_AREAFinancial Management Areanvarchar40
90FMRBBOBJECTSMaster Data For Revenue Increasing the Budget: RIB Objects2FM_AREAFinancial Management Areanvarchar40
91FMRBBRECSMaster Data For RIB: Budget Receivers per RIB Object2FM_AREAFinancial Management Areanvarchar40
92FMRBCDACTActivation of Change Documents for Cover Elibility2FM_AREAFinancial Management Areanvarchar40
93FMRELSTATEDefinition of release scenario2FM_AREAFinancial Management Areanvarchar40
94FMREL_FTYPEConsumable budget type for Fund Type2FM_AREAFinancial Management Areanvarchar40
95FMREL_FUNDRelease settings for Fund2FM_AREAFinancial Management Areanvarchar40
96FMREV_STGRD_ACTActivation of the Reversal Reason for Budget Documents2FM_AREAFinancial Management Areanvarchar40
97FMREV_STGRD_DEFAllowed Reversal Reasons for Budget Documents2FM_AREAFinancial Management Areanvarchar40
98FMROLLUP_FTYPEPreclosing Rollup: Transfer Rules for Fund Type2FM_AREAFinancial Management Areanvarchar40
99FMROLLUP_FUNDPreclosing Rollup: Transfer Rules for Fund2FM_AREAFinancial Management Areanvarchar40
100FMSTATDEFBudgeting status definition2FM_AREAFinancial Management Areanvarchar40
101FMSTATDEFTTexts for Budgeting Status2FM_AREAFinancial Management Areanvarchar40
TOPBudgeting and Availability Control
102GMBDGTFMFM defaults for Interface with GM Budget3FM_AREAFinancial Management Areanvarchar40
103GMBDGTFYDLINEGM Budgeting Fiscal Year Distribution Lines15FM_AREAFinancial Management Areanvarchar40
104GMFMRECSGM RIB: FM Receivers (obsolete)6FM_AREAFinancial Management Areanvarchar40
105GMFMRECS1GM RIB: FM Budget Receivers3FM_AREAFinancial Management Areanvarchar40
106GMHBDGTFYDLINEGM Budgeting Fiscal Year Distribution Lines16FM_AREAFinancial Management Areanvarchar40
107GMRBFMRECGM RIB: FM Budget Receivers4FM_AREAFinancial Management Areanvarchar40
TOPFunctions for U.S. Federal Government
108FMFG_BUTYPEBudgetary ledger Attributes of the budget type6FM_AREAFinancial Management Areanvarchar40
109FMFG_FUND_ADJCustomizing for adjustment on fund level2FM_AREAFinancial Management Areanvarchar40
TOPFunds Management
110BPREP_HRFPM_BCSVariants of Budget Creation for PBC3FM_AREAFinancial Management Areanvarchar40
111FMBLEXTACBActivation of BL Ext for Value Type - Budgets2FM_AREAFinancial Management Areanvarchar40
112FMBLEXTACCActivation of BL Ext for Value Type - Commitments / Actuals2FM_AREAFinancial Management Areanvarchar40
113FMBLEXTACTActivation of BL Ext for Budget Category2FM_AREAFinancial Management Areanvarchar40
114FMBLEXTBUSubstitute BL Doc Types for Budget Docs2FM_AREAFinancial Management Areanvarchar40
115FMBLEXTEASubstitute BL Doc Types for Earmarked Funds2FM_AREAFinancial Management Areanvarchar40
116FMBLEXTFASubstitute BL Doc Types2FM_AREAFinancial Management Areanvarchar40
117FMBLEXTFLASelection of fields to be moved in FI for BL Ext - Fields2FM_AREAFinancial Management Areanvarchar40
118FMBLEXTFMASelection of fields to be moved in FI for BL Ext - FM Areas2FM_AREAFinancial Management Areanvarchar40
119FMBLEXTINSubstitute BL Doc Types for Invoices2FM_AREAFinancial Management Areanvarchar40
120FMBLPSTNGFM BL posting customizing for GL line-items collection2FM_AREAFinancial Management Areanvarchar40
121FMBPCLOSE_FTYPEPreclosing Rollup: Transfer Rules for Fund Type2FM_AREAFinancial Management Areanvarchar40
122FMBPCLOSE_FUNDPreclosing Rollup: Transfer Rules for Fund2FM_AREAFinancial Management Areanvarchar40
123FMBUDACLRules for Closing Residual Ledger Accounts3FM_AREAFinancial Management Areanvarchar40
124FMBUDBCSBudgetary ledger account derivation: BCS3FM_AREAFinancial Management Areanvarchar40
125FMBUDDISBudgetary ledger account derivation: Budgeting (old)3FM_AREAFinancial Management Areanvarchar40
126FMBUDRESBudgetary ledger account derivation: Revenue/Statistical3FM_AREAFinancial Management Areanvarchar40
127FMBUDREVRevenue/Statistical Postings & Open items/actuals Resource3FM_AREAFinancial Management Areanvarchar40
128FMBUDSTABudgetary ledger account derivation: Open items/Actuals bdgt3FM_AREAFinancial Management Areanvarchar40
129FMCLOSEOUTRules for Closing out Obligations2FM_AREAFinancial Management Areanvarchar40
130FMFG_SAV_FACTS1ASaved FACTS1A data for docs excluded from SL Repost for 60054FM_AREAFinancial Management Areanvarchar40
131FMFG_SAV_FACTS2ASaved FACTS2A data for docs excluded from SL Repost for 60058FM_AREAFinancial Management Areanvarchar40
132FMFG_SAV_FMUSFGASaved FMUSFGA data for docs excluded from SL Repost for 60078FM_AREAFinancial Management Areanvarchar40
133FMFG_YBA_AVCFMFG: Year of Budget Authority - AVC2FM_AREAFinancial Management Areanvarchar40
134FMFUNDTYPEFM Fund Types2FM_AREAFinancial Management Areanvarchar40
135FMFUNDTYPETFM Fund Types Texts2FM_AREAFinancial Management Areanvarchar40
136FMIUROpen Interval Rules for updating FM2FM_AREAFinancial Management Areanvarchar40
137FMUDOverride FM Update Date2FM_AREAFinancial Management Areanvarchar40
138FMUSFGAActual line item table for US Federal Government.78FM_AREAFinancial Management Areanvarchar40
139FMUSFGFACTS1A4Actual line item table54FM_AREAFinancial Management Areanvarchar40
140FMUSFGFACTS1TSummary table64FM_AREAFinancial Management Areanvarchar40
141FMUSFGFACTS2AActual line item table58FM_AREAFinancial Management Areanvarchar40
142FMUSFGFACTS2TSummary table68FM_AREAFinancial Management Areanvarchar40
143FMUSFGTSummary table for US Federal Government65FM_AREAFinancial Management Areanvarchar40
144TBPAS_FTYPEBudget Subtypes for Availability Control for Each Fund Type2FM_AREAFinancial Management Areanvarchar40
145TBPAS_FUNDBudget Subtypes for Availability Control Per Fund2FM_AREAFinancial Management Areanvarchar40
146TBPBWRET20FM Plan Data Transfer Header Transfer3FM_AREAFinancial Management Areanvarchar40
TOPGrantee Management
147GMIAActual Line Item Table53FM_AREAFinancial Management Areanvarchar40
TOPMaster Data
148FMMEASURE_FGCField group criteria (Funded Program) using FM Area2FM_AREAFinancial Management Areanvarchar40
149GMFUNDRECOVER_OFund recovery for outgoing grants4FM_AREAFinancial Management Areanvarchar40
150GMGFUNDGrant specific fund details3FM_AREAFinancial Management Areanvarchar40
151GMGRCOSTSHARECost sharing master data3FM_AREAFinancial Management Areanvarchar40
152GMGRSPONSOREDOBJGrant sponsored objects5FM_AREAFinancial Management Areanvarchar40
153GMSPCLASS_FMBASponsored Class Master Data - Budget Allowed Object3FM_AREAFinancial Management Areanvarchar40
154GMSPCLASS_FMBTSponsored Class Master Data - Budget Transfer Object3FM_AREAFinancial Management Areanvarchar40
155GMSPPROGRAM_FMBASponsored Program Master Data - Budget Allowed Object3FM_AREAFinancial Management Areanvarchar40
156GMSPPROGRAM_FMBTSponsored Program Master Data - Budget Transfer Objects3FM_AREAFinancial Management Areanvarchar40