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

36 columns | Print definition?ERP 6.0  | SCALE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IWBEP/I_SBO_FPSB: Function Import Parameters9SCALEService Builder: OData Scaleint100
2/IWBEP/I_SBO_PRSB: OData Properties17SCALEService Builder: OData Scaleint100
3/IWBEP/I_SBO_TYSB: OData Type Definitions12SCALEService Builder: OData Scaleint100
4ESH_HDB_CALCESH Calculated Attributes on HDB Tables13SCALENatural Numberint100
5P2KZ_TAXTax7SCALEPosition of a Field in a Linetinyint30
6P2UA_TAXUkrainian Tax7SCALEPosition of a Field in a Linetinyint30
7P2UR_TAXRussian Tax7SCALEPosition of a Field in a Linetinyint30
8PAPBSGB_SWF_CONTSWF: Contract Details37SCALESWF: Pay Scalenvarchar20
9PYD_D_PTPayroll Data Source Parameter Type7SCALEPayroll Data Source Framework: Max. number of decimal digitsint100
10T5GPBSS_PSCSWF: Pay Scale7SCALESWF: Pay Scalenvarchar20
11T5GPBSS_PSC2SWF: Pay Scale9SCALESWF: Pay Scalenvarchar20
12T5PBFAWage type determination to consider for the allowance10SCALEReceivable level percentagedecimal52
13T7RUB3Scale selection by Bonus model and Personal modifier8SCALEScale of Bonus Modelnvarchar40
14T7RUB4Scale of bonus model3SCALEScale of Bonus Modelnvarchar40
15T7RUB4TTexts for Bonus Model Scales4SCALEScale of Bonus Modelnvarchar40
16T7RUB5Scale - values3SCALEScale of Bonus Modelnvarchar40
17T7RU_558D_TAXSplit Indicator Tax for Transfered Wage Types6SCALEPosition of a Field in a Linetinyint30
18HRP1723DB Table for Infotype 172320SCALEScalenvarchar40
TOPCCMSDatabase Monitors for MaxDB
19SDB_SIZE_SCALESList of Meas. Units (MB, Pages,...) for Various Displays1SCALEVersion Number Componentnvarchar20
TOPConsolidation
20TF335Scaling Factor for Online Entry4SCALEScaling Factornvarchar10
TOPDepreciation Simulation
21IMCCIM Summarization: Characteristics that are master data31SCALEScale of investment objectsnvarchar20
TOPEngineering Desktop
22EDESK_INSTDatabase Table for Instance Mgmt in Engineering Desktop17SCALEParameter for DMU Transformation Matrixfloat1516
TOPFunds Management
23TBP1CBudget/Plan Profile13SCALEScaling factornvarchar10
TOPIntegrated Product and Process Engineering
24INSTCMPDCMP Attribute of Change State for Geometric Instance23SCALEParameter for DMU Transformation Matrixfloat1516
TOPInterest Calculation
25T056ITime-dep.terms for interest calc.rule8SCALEAmount-independent levels for interest rate determinationnvarchar20
TOPProduct Configurator
26COMM_CFGNUMBasic Data for Numeric Characteristics6SCALECharacteristic Scalesmallint50
TOPProduct Data Management
27CONV_MATRICESMatrixes that must be checked into BOMs22SCALEParameter of the DMU transformation matrix (STEP)float1516
28DMUTMXTransformation matrix parameter in STEP format(ISO 10303-42)15SCALEParameter of the DMU transformation matrix (STEP)float1516
TOPProfitability Analysis
29TKEVA03Costing Key21SCALEFactor for Production Order Cost Estimatenvarchar10
TOPPublic Sector Contract Accounts Receivable and Payable
30DFMCA_BRF170BRF: Progressive Calculation9SCALECharacter Field Length = 10nvarchar100
31DFMCA_BRF171BRF: Progressive Calculation9SCALECharacter Field Length = 10nvarchar100
TOPQualifications and Requirements
32HRP1033DB table for infotype 103318SCALEScale IDnvarchar80
TOPSales and Distribution
33SCENUMNumeric Characteristics6SCALENumber of decimal places of numeric characteristic valuenvarchar20
TOPTraining Management
34HRP1886DB Table for Infotype 188622SCALEGrading Scalenvarchar50
35LSOLHGRADESCALEGrading Scale2SCALEGrading Scalenvarchar50
36LSOLHGRADESCALETText Table for Grading Scale3SCALEGrading Scalenvarchar50