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

63 columns | Print definition?ERP 6.0  | VALTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/X013BDC Parameter Configuration4VALTYPEField Value Determination Typenvarchar10
2/OPT/X014BDC Transaction Data5VALTYPEField Value Determination Typenvarchar10
3/OPT/Y013BDC Parameter Configuration4VALTYPEField Value Determination Typenvarchar10
4/OPT/Y014BDC Transaction Data5VALTYPEField Value Determination Typenvarchar10
5/OPT/Z013BDC Parameter Configuration4VALTYPEField Value Determination Typenvarchar10
6/OPT/Z014BDC Transaction Data5VALTYPEField Value Determination Typenvarchar10
7FMBCS_FMBL_CDEmpty table for change documents on FMBL incl. local. fields20VALTYPEBCS Value Typenvarchar20
TOPAvailability Control
8FMAVCBUDFILTBAVC filter settings for FM budget values: valid budget types7VALTYPEBCS Value Typenvarchar20
9FMAVCBUDFILTHAVC filter settings for FM budget values: header entries9VALTYPEBCS Value Typenvarchar20
TOPBalanced Scorecard
10UMB_BU100BW Buffer (Cross-Application)14VALTYPEValue Typenvarchar10
TOPBudgeting
11BUVALTPROValid Combinations Between Process and Value Type1VALTYPEBCS Value Typenvarchar20
12BUVALTYPEList of budgeting value type instances1VALTYPEBCS Value Typenvarchar20
13BUVALTYPETTexts for Budgeting Value Type Instances1VALTYPEBCS Value Typenvarchar20
14BUVORGAMapping rules for migration from FBS to BCS - Field VORGA2VALTYPEBCS Value Typenvarchar20
15BUWRTTPMapping rules for migration from FBS to BCS - Field WRTTP2VALTYPEBCS Value Typenvarchar20
16FMBLFunds management budget document lines (entry documents)20VALTYPEBCS Value Typenvarchar20
17FMBTGDEFBudget Group content definition5VALTYPEBCS Value Typenvarchar20
18FMBTGROUPBudget Type Group definition3VALTYPEBCS Value Typenvarchar20
19FMBTGROUPTText for Budget Type Group3VALTYPEBCS Value Typenvarchar20
20FMBUDTYPEBudget type definition4VALTYPEBCS Value Typenvarchar20
21FMBUDTYPETTexts for Budget Types5VALTYPEBCS Value Typenvarchar20
22FMBWUSBudgeting Workbench User settings3VALTYPEBCS Value Typenvarchar20
23FMCY_COPIFor CO plan data transfer12VALTYPEBCS Value Typenvarchar20
24FMEDDOCTYPEAAssign process to document type4VALTYPEBCS Value Typenvarchar20
25FMHBLFunds management budget document lines (held documents)20VALTYPEBCS Value Typenvarchar20
26FMKF_TERMKey Figures - FM Terms8VALTYPEKey Figures - Value Typenvarchar20
27FMPEPLAY_COLFMPEP: layout customizing settings for columns10VALTYPEBudget Value Typenvarchar20
28FMPEP_VARIANTHSession variants (header part) for transaction FMPEP25VALTYPEBCS Value Typenvarchar20
29FMPEP_VARIANTLSession variants (line part) for transaction FMPEP20VALTYPEBCS Value Typenvarchar20
30FMPTCOMBAllowed combinations (process / budget type)5VALTYPEBCS Value Typenvarchar20
31FMPTCOMBAAllowed combinations (process / budget type) for status7VALTYPEBCS Value Typenvarchar20
32FMPTCOMBAGAllowed combinations process / budget type group for status7VALTYPEBCS Value Typenvarchar20
33FMPTCOMBGAllowed Combinations Process/Budget Type Using BT Groups5VALTYPEBCS Value Typenvarchar20
34FMROLLUP_FTYPEPreclosing Rollup: Transfer Rules for Fund Type6VALTYPEBCS Value Typenvarchar20
35FMROLLUP_FUNDPreclosing Rollup: Transfer Rules for Fund6VALTYPEBCS Value Typenvarchar20
TOPConsolidation Functions
36UCFV000Validation: Method Settings4VALTYPEValidation Typenvarchar10
37UCFV21GValidation Check: GUID8VALTYPEValidation Typenvarchar10
TOPCorporate Performance Monitor
38UMK_BU100Total Float9VALTYPEValue Typenvarchar10
39UMK_MB100Key Figures: Header Table13VALTYPEValue Typenvarchar10
40UMR_RI124OBSOLETE RMS: Probability and Risk Intensity - Header11VALTYPEValue Typenvarchar10
41UMR_RI128RMS: Measure Deviations for Risks12VALTYPEValue Typenvarchar10
TOPCross-Application Components
42/OPT/CP_T903BDC Parameter Configuration4VALTYPEField Value Determination Typenvarchar10
43/OPT/CP_T904BDC Transaction Data5VALTYPEField Value Determination Typenvarchar10
44RPM_VALTYP_CRPM Value Type Customizing4VALTYPEValue Type for the RPM FI Interfacenvarchar20
TOPDistributor-Reseller-Management
45/SAPHT/DRMACLVALStaging Validations: Assign Validations to the Class3VALTYPEValidation typenvarchar40
46/SAPHT/DRMCGVALGeneral validation in Inbound 867/844 and staging1VALTYPEValidation typenvarchar40
47/SAPHT/DRMCGVALTText table: Active validations for inb 867/844 and staging2VALTYPEValidation typenvarchar40
48/SAPHT/DRMCGVLValidations: details2VALTYPEValidation typenvarchar40
49/SAPHT/DRMCRULEValidation Rules: Group of Individual validation rule4VALTYPEValidation typenvarchar40
50/SAPHT/DRMCVLINDValidations: for manufacturer or distributor1VALTYPEValidation typenvarchar40
TOPManagement Cockpit
51UMM_BU101Obsolete: Buffer of Transaction Data20VALTYPEValue Typenvarchar10
52UMM_BU102Obsolete: Buffer of Transaction Data17VALTYPEValue Typenvarchar10
53UMM_BU105Buffer of Transaction Data17VALTYPEValue Typenvarchar10
TOPMonitoring
54ALPFREP_CATPerfDB Reporting Catalog17VALTYPECPH Output Type: Total (T), Average (A), or Number (N)nvarchar10
TOPPerformance Assessment Workbench
55SLS_LOOKUPAW - Lookup Types4VALTYPEValue type for PAW operational settingnvarchar10
TOPPortfolio Management
56RPM_FIDATAFinancial Information8VALTYPEValue Typenvarchar20
57RPM_PROJECT_COControlling Information about a project7VALTYPEValue Typenvarchar20
58RPM_SCENARIO_FINRPM : Scenario financial data5VALTYPEValue Typenvarchar20
59RPM_VALTYPPeriod Type2VALTYPEValue Typenvarchar20
60RPM_VALTYP_TPeriod Type3VALTYPEValue Typenvarchar20
TOPResourcen Management
61RMSLA_DIVADiet Values7VALTYPEType: Calculated/Declarednvarchar10
62RMSLA_INVAIngredient Quantities6VALTYPEType: Calculated/Declarednvarchar10
63RMSLA_NUVANutritional Value Data7VALTYPEType: Calculated/Declarednvarchar10