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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

67 columns | Print definition?ERP 6.0  | FORMULA

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1REQLINESRTemporary Line Data: Requirement Coverage Request (Services)54FORMULAFormula numbernvarchar100
2RSBPCB_MEM_HIEBPC: BPF Driver Dimension Hierarchy Member Item12FORMULABPC: BPF Step Region Criteria Formulanvarchar10
3T7CNRMP_DETITMDetermining Factor Item18FORMULAFormulanvarchar80
4T7CNRMP_FORMULAFormula2FORMULAFormulanvarchar80
5T7CNRMP_FORMULATText Table of Formula3FORMULAFormulanvarchar80
6T7CNRMP_FRMOPRFormula Operand2FORMULAFormulanvarchar80
7T7CNRMP_FRMOPRTText Table of Formula Operand3FORMULAFormulanvarchar80
8T7CNRMP_RPTSTAStatistical Dimension for Report19FORMULAFormulanvarchar80
TOPBalanced Scorecard
9UMB_SC103Scorecard: Measure Assignment11FORMULAFormula IDnvarchar100
10UMB_SC180Scorecard: Initiatives26FORMULAFormula IDnvarchar100
TOPBasic Functions
11T890FI-SL: Boolean Formulas3FORMULABoolean formulanvarchar2540
12UKM_FORMULASSAP Credit Management: Formulas2FORMULAFormula in Credit Managementnvarchar300
13UKM_FORMULAS0TSAP Credit Management: Formula Texts3FORMULAFormula in Credit Managementnvarchar300
TOPBSI
14BTXFDOCBSI: Tax Formula Documentation4FORMULABSI: Tax formulanvarchar10
15BTXFORMBSI Tax Formulas4FORMULAFormula numbernvarchar10
16BTXOVERBSI: Higher Level Tax Formula7FORMULABSI Formuladecimal10
17BTXOVER_OBSI: Higher Level Tax Formula6FORMULABSI Formuladecimal10
18BTXOVFRBSI: Higher Level Formulas for Employees7FORMULABSI Formuladecimal10
19BTXOVFR_OBSI: Higher Level Formulas for Employees6FORMULABSI: Tax formulanvarchar10
20BTXRATEBSI: Tax Rates per Company Based on Degree of Experience7FORMULABSI Formulanvarchar20
21BTXRATE_OBSI: Tax Rates per Company Based on Degree of Experience6FORMULABSI Formuladecimal10
TOPBusiness Rule Framework
22TBRF145BRF: General Arithmetical Expressions (Formula)6FORMULAFormula Linenvarchar2550
TOPClaims Management
23ICLSCWCOMPWorkers Comp - Benefits Catalog17FORMULABRFplus Expression for Deriving Total Benefitnvarchar200
24ICL_WC_RWBWCOMP: Rules Workbench32FORMULABRFplus Expression for Deriving Total Benefitnvarchar200
TOPClassification System New
25CME_ST_ISO_AT1CME Characteristic: ISO Attributes10FORMULAFormulanvarchar2550
26CME_ST_ISO_AT1HCME Characteristic: ISO Attributes8FORMULAFormulanvarchar2550
TOPContract Billing
27EMDUSDFORMHEADTable of MDUS Formulas2FORMULATime-of-Use Formulanvarchar100
28EMDUSDFORMHEADTText Table for MDUS Formulas2FORMULATime-of-Use Formulanvarchar100
29EMDUSDFORMINInput Parameters of a Formula2FORMULATime-of-Use Formulanvarchar100
30EMDUSDFORMINTText Table for MDUS Formula Input Parameters2FORMULATime-of-Use Formulanvarchar100
31EMDUSDFORMOUTOutput Parameters of a Formula2FORMULATime-of-Use Formulanvarchar100
32EMDUSDFORMOUTTText Table for MDUS Formula Output Parameters2FORMULATime-of-Use Formulanvarchar100
33EMDUSDIFTIMETABTOU Formulas of TOU Interface9FORMULATime-of-Use Formulanvarchar100
34EMDUSDIFTOUTABTOU Periods of TOU Interface10FORMULATime-of-Use Formulanvarchar100
35EMDUSDRQITEMSubrequest for Request4FORMULATime-of-Use Formulanvarchar100
TOPCorporate Performance Monitor
36UMC_GS110Formula2FORMULAFormula IDnvarchar100
37UMC_GS110TFormula: Texts2FORMULAFormula IDnvarchar100
38UMC_GS111Formula Detail2FORMULAFormula IDnvarchar100
39UMR_RI114RMS: Measure Selection and Attributes7FORMULAFormula IDnvarchar100
40UMV_TR210Value Driver Tree: Used Measures9FORMULAFormula IDnvarchar100
TOPCross-Application Mass Maintenance
41MASSVARNEWVALUESVariants: New Field Values9FORMULAFormula for Mass Maintenancenvarchar400
42MASSVARNEWVAL_SSystem Variants: New Field Values8FORMULAFormula for Mass Maintenancenvarchar400
TOPData Staging
43RSFOBUEV000BW - FoBuEv: Header Data of a Formula5FORMULAntext10737418230
44RSUPDFORMBW: Update Rules - Formulas - Checking Table3FORMULAExternal Formula IDnvarchar250
TOPEnergy Data Management
45EEDMFORMHEADFormula Header Data2FORMULAFormula for Calculation of Profilesnvarchar150
46EEDMFORMHEADTFormula (Text)2FORMULAFormula for Calculation of Profilesnvarchar150
47EEDMFORMMODPARCalculation Mode Options per Formula Parameter2FORMULAFormula for Calculation of Profilesnvarchar150
48EEDMFORMPARFormula Parameters2FORMULAFormula for Calculation of Profilesnvarchar150
49EEDMFORMPARTFormula Parameters2FORMULAFormula for Calculation of Profilesnvarchar150
50EFORMULAINSTIS-U EDM Header Data of Formula Instance (DB Table)4FORMULAFormula for Calculation of Profilesnvarchar150
51ERTPINTERFACERTP Interface (Header Data)3FORMULAFormula for Calculation of Profilesnvarchar150
TOPEvaluations
52EVE_THRESHOLD_GGlobal Threshold Values: Definition8FORMULAFormula IDnvarchar320
TOPInformation Consistency
53SIC_SRC_STRATEGYSearch: strategy8FORMULAStrategy Formulanvarchar2000
TOPIntegrated Product and Process Engineering
54CPPE_VSI_FORMVariable-Size Item Formulas in iPPE3FORMULAFormula Field for Variable-Size Item Datanvarchar650
TOPMaster Recipe
55KALCMaterial Quantity Calculation - Formulas14FORMULAFormula in material quantity calculationnvarchar2500
TOPProduct Cost Planning
56TJP_ECP_KPIECP: Pricing Key Definition7FORMULAFormula for Calculating Aggregated Itemnvarchar2550
TOPProfitability Analysis
57TKECONDCO-PA: Formula Storage6FORMULAFormulanvarchar720
TOPReal Estate Management
58TIVO2Rent Adjustment: Control Table for RRP Adjustment6FORMULAMathematical expressionnvarchar650
TOPRemaining Beverage - Obsolete Objects
59/BEV3/CHBBDGSTFAgreement Condition Strategy - Formula8FORMULAFormula linenvarchar720
60/BEV3/CHBCALCFAgreement Calculation - Formula8FORMULAFormula linenvarchar720
61/BEV3/CHCFORMELFCalculation Formula4FORMULAFormula linenvarchar720
62/BEV3/CHCTBDGSTFCustomizing: Condition Strategy Formula4FORMULAFormula linenvarchar720
TOPSets
63RWSLINEReport Writer Data for the Set Line11FORMULAFormula in set linenvarchar2400
TOPTariffs, Duties and Permits
64OIH_J1B_FACBrazil: Factor for calculation of PIS / COFINS ST11FORMULAFormula type for PIS/COFINS ST calculationnvarchar10
TOPUSA
65BTXTERRBSI: Employee Payroll Error Message Grouping7FORMULABSI: Tax formulanvarchar10
66BTXTRESBSI: Tax Results7FORMULABSI: Tax formulanvarchar10
67BTXTTAXBSI: Test Taxes7FORMULABSI: Tax formulanvarchar10