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

45 columns | Print definition?ERP 6.0  | KBEZ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1FTBB_YCBSC_DREVTBasis Spread Curve Derivation for Evaluation Curves (Texts)3KBEZShort Namenvarchar300
2FTBB_YCBSC_DRFWTBasis Spread Curve Derivation for Forward Curves (Texts)3KBEZShort Namenvarchar300
3FTBB_YCCSC_DRBPTReference Entity Derivation for Business Partners (Texts)3KBEZShort Namenvarchar300
4FTBB_YCCSC_DROWTReference Entity Derivation for Your Own Companies (Texts)3KBEZShort Namenvarchar300
TOPAccounting Interface
5GLE_CMP_ERRTECS: Text Table for Compound Error Categories4KBEZShort Descriptionnvarchar600
TOPAssetLiability Management
6JBAPLANVTALM Planning Variant: Text Table6KBEZShort Namenvarchar300
7JBASIMATALM Simulation Type: Texts4KBEZShort Namenvarchar300
8JBRABREGTABTRM: Write-Down Rule for P+L Simulation (Texts)4KBEZShort Namenvarchar300
9JBRBG2TText Table for Gap Type4KBEZShort Namenvarchar300
10JBRIASZDTDescriptions for Utilization Scenarios4KBEZShort Namenvarchar300
11JBRLQSZHTTexts for Liquidation Scenarios4KBEZShort Namenvarchar300
12JBRLZBTMaturity Band - Texts4KBEZShort Namenvarchar300
13JBRPBLDTTexts for Period Block - Definition4KBEZShort Namenvarchar300
14JBRSIMZTTexts for Simulated Interest Payments4KBEZShort Namenvarchar300
TOPLoans Management
15TD17TBranch office text table4KBEZShort Namenvarchar150
16TD18TBusiness region text table4KBEZShort Namenvarchar150
TOPMarket Risk Analyzer
17JBRBFARTTBeta factor type texts4KBEZShort Namenvarchar300
18JBREVALTRisk Management evaluation type - texts4KBEZShort Namenvarchar300
19JBRREGDTText Table Market Data Shift Definition4KBEZShort Namenvarchar300
20JBRREGWTText table for risk factor shift5KBEZShort Namenvarchar300
21JBRRHBAUMTTexts for Tree Structure of Risk Hierarchy5KBEZShort Namenvarchar300
22JBRRHBAUMTHText for Tree Structure of Risk Hierarchy (History)6KBEZShort Namenvarchar300
23JBRRHBAUMT_BACKBackup Table JBRRHBAUMT (Required for Transport Imports)5KBEZShort Namenvarchar300
24JBRRHTTexts for Risk Hierarchy Check Table4KBEZShort Namenvarchar300
25JBRRHTHTexts for Risk Hierarchy Check Table (History)5KBEZShort Namenvarchar300
26JBRRHT_BACKBackup Table JBRRHT (Required for Transport Imports)4KBEZShort Namenvarchar300
TOPMaster Data
27TD19TOrganizational Unit (Contract Management)4KBEZShort Namenvarchar150
28TD30TDistribution Channel4KBEZShort Namenvarchar150
TOPRisk Analysis
29JBRALFDTTexts for Due Date Scenario - Definition4KBEZShort Namenvarchar300
30JBRBEWREGTValuation Rules for Evaluations (Texts)4KBEZShort Namenvarchar300
31JBRBPTBase Portfolio Definition: Text5KBEZShort Namenvarchar300
32JBRCFARTTTexts for Description of Cash Flow Type4KBEZShort Namenvarchar300
33JBRINDXRM: Cluster for Storing Datasets Derived from INDX5KBEZShort Namenvarchar300
34JBRINDXCATRM: Cluster for Storing Datasets, Catalog Entries5KBEZShort Namenvarchar300
35JBRINDXKATRM: Cluster for Storage of Datasets, Catalog3KBEZShort Namenvarchar300
36JBRPHTPortfolio hierarchy5KBEZShort Namenvarchar300
37JBRRHKNTTTexts (only used for data definitions)5KBEZShort Namenvarchar300
38JBRRMBTText Table for Analysis Structure3KBEZShort Namenvarchar300
39JBRSARTTText Table for Balance Types4KBEZShort Namenvarchar300
40JBRSITDims texts4KBEZShort Namenvarchar300
41JBRSPHTDefinition of Portfolio Hierarchy (Text Table)5KBEZShort Namenvarchar300
42JBRVREGTTexts for Summarization Rule4KBEZShort Namenvarchar300
TOPTreasury
43ATKO1TText Table Correlation Type4KBEZShort Namenvarchar300
44ATVO3TText Table Statistics Type4KBEZShort Namenvarchar300
TOPVital Signs
45N1VPSTMaster Data Vital Signs (Language-Dependent Texts)4KBEZVital Sign Short Textnvarchar100