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

40 columns | Print definition?ERP 6.0  | BPID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAnalyzer
1JBRHISPHBAUMSTree Structure for Deactivated Portfolio Hierarchies5BPIDBase Portfolio IDnvarchar120
2JBRHISPHZUORDNRM Deactivated PH: Assign Base Portfolios to End Nodes4BPIDBase Portfolio IDnvarchar120
TOPAssetLiability Management
3JBRSVGAPRESRM: Saved Gap Evaluation Results4BPIDBase Portfolio IDnvarchar120
TOPClinical System
4N1CONNBPPROXYRegistered Proxy OU2BPIDConnectivity: Business Partner IDnvarchar100
5N1CORDTWSInbound Service - Clinical Order Type Assignment4BPIDInitiating Employee/Business Partnernvarchar100
6N1PATEXi.s.h.med: Connectivity, External Partner2BPIDConnectivity: Business Partner IDnvarchar100
TOPData Staging
7RSBKBPBreakpoints1BPIDDTP: Breakpoint IDnvarchar60
TOPGlobal Organization Customizing
8/MRSS/D_PROP_RESTable containing Proposed resources for Tenders4BPIDTender Business Partner IDnvarchar100
9/MRSS/D_REQ_CANDTable of Portal demands : Candidates Information4BPIDPortal BUPA IDnvarchar100
10/MRSS/D_REQ_VENTable of Portal demands : Additional Vender Information2BPIDPortal BUPA IDnvarchar100
TOPLoans Management
11TTKWGDATAWork Table for GBA 24c4BPIDBusiness Partner Numbernvarchar100
TOPMarket Risk Analysis
12I74TRMTreasury Standard3BPIDBasisportfolio-IDnvarchar120
TOPRisk Analysis
13I9AMBPKIS-B: RM Model/Include DBTab Base Portfolio Determination3BPIDBase Portfolio IDnvarchar120
14JBRAMOUNTRM: Account Balance Summarization in Base Portfolio3BPIDBase Portfolio IDnvarchar120
15JBRBPBase Portfolio Definition3BPIDBase Portfolio IDnvarchar120
16JBRBPCFKNRM: Aggregated Capital Commitment Cash Flows3BPIDBase Portfolio IDnvarchar120
17JBRBPCFVRM: BP Update Administration for Cash Flows4BPIDBase Portfolio IDnvarchar120
18JBRBPCFVNRM: BP Update Management for Cash Flows4BPIDBase Portfolio IDnvarchar120
19JBRBPCFZNRM: Aggregated Interest Commitment Cash Flows3BPIDBase Portfolio IDnvarchar120
20JBRBPFARTRM: Update Type for Objects per View4BPIDBase Portfolio IDnvarchar120
21JBRBPKSVRM BP Update Administration for Account Balances4BPIDBase Portfolio IDnvarchar120
22JBRBPTBase Portfolio Definition: Text4BPIDBase Portfolio IDnvarchar120
23JBRBPWPVRM: BP Update Administration for Positions/Securities4BPIDBase Portfolio IDnvarchar120
24JBRBSTDRM: Base Portfolios - Single Positions (until F3.03)3BPIDBase Portfolio IDnvarchar120
25JBRBSTVRM: Base Portfolio for Position Management4BPIDBase Portfolio IDnvarchar120
26JBRCFKAPRM: Aggregated Capital Commitment Cash Flows per BP3BPIDBase Portfolio IDnvarchar120
27JBRCFZINSRM: Aggregated Fixed-Interest Cash Flows per BP3BPIDBase Portfolio IDnvarchar120
28JBREGSHRM Base Portfolio for Single Transactions3BPIDBase Portfolio IDnvarchar120
29JBRKONRM: Account Balance Summarization in Base Portfolio3BPIDBase Portfolio IDnvarchar120
30JBRMZBGRM: Assignment of Transactions to Business Partners4BPIDBase Portfolio IDnvarchar120
31JBRPHBAUMSStorage of Portfolio Hierarchy5BPIDBase Portfolio IDnvarchar120
32JBRSHKNNodes in Portfolio Hierarchy5BPIDBase Portfolio IDnvarchar120
33JBRSVABESTRM: Header Table SDTFT (Additional Info.) for Saved Datasets5BPIDBase Portfolio IDnvarchar120
34JBRSVGAPRES2RM: Saved Gap Evaluation Results4BPIDBase Portfolio IDnvarchar120
35JBRSVPHBAUMRM: Portfolio Hierarchy for Saved Datasets (Backtesting)6BPIDBase Portfolio IDnvarchar120
36JBRSVPHZUORDNRM: Assignment of PH->BP for Saved Datasets (Backtesting)5BPIDBase Portfolio IDnvarchar120
37JBRUBSTVRM: Base Portfolio - Management of Non-Int-Bearing Positions4BPIDBase Portfolio IDnvarchar120
38JBRZUORDNTRM: Assignment of Base Portfolios to PH End Nodes4BPIDBase Portfolio IDnvarchar120
TOPSyntax, Compiler, Runtime
39TPDASESSIONBP4BPIDTPDA: Debug Session - Breakpoint IDint100
TOPWorkforce Management Core
40WFDSD_DEMANDWork Force Deployment Demand32BPIDBusiness Partner Numbernvarchar100