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

41 columns | Print definition?ERP 6.0  | BKOND

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1RDPT_CONDITIONCondition within Redemption Schedule9BKONDCondition item currency amountdecimal132
2TZB11Activity-dependent one-time conditions9BKONDCondition item currency amountdecimal132
3VIYCADVPAYAdvance Payments50BKONDCondition item currency amountdecimal172
TOPBack Office
4TRST_CLASFLOCFM: Class Flows in Securities Account94BKONDCondition item currency amountdecimal172
5TRST_CLASFLO_REVCFM: Reversed Class Flows in Securities Account94BKONDCondition item currency amountdecimal172
TOPBank Components
6JBASTCPStandard Conditions: Condition Item9BKONDAmount of Condition Itemdecimal172
TOPLoans Management
7TTONFTVVZZKOPOTest neue Fima: VVZZKOPO12BKONDWährungsbetrag der Konditionspositiondecimal132
8TTONFTVZZBEPPTest neue FIMA: VZZBEPP84BKONDWährungsbetrag der Konditionspositiondecimal132
9VDBEPIPosted line items for document header104BKONDCondition item currency amountdecimal132
10VDBEPI_EUFlow Data / Actual Position Before EURO Conversion14BKONDCondition item currency amountdecimal132
11VDBEPI_SHADOWShadow Table for VDBEPI (Restrictions)104BKONDCondition item currency amountdecimal132
12VDBEPPFlow Data - Planned Item135BKONDCondition item currency amountdecimal132
13VDBEPP_EUFlow Data / Planned Items Before EURO Changeover16BKONDCondition item currency amountdecimal132
14VDBOBEPPBusiness Operation: Entered and Activated Flow Data135BKONDCondition item currency amountdecimal132
15VDBOBEPP_EUFlow Data / Planned Items Before EURO Changeover17BKONDCondition item currency amountdecimal132
16VDKOPO_EUCondition Item Data Before EURO Conversion (Loans)12BKONDCondition item currency amountdecimal132
17VDREPAYMENTPayoff Master Data57BKONDPayment Installment for Repayment Changedecimal132
18VZFZE_VDBEPPCentral Entry Table for Release Procedure138BKONDCondition item currency amountdecimal132
TOPMaster Data
19VDESCROWKOPO0TEMPORARY USE: Escrow Condition Items11BKONDCondition item currency amountdecimal132
TOPOverhead Cost Orders
20TKZU1Overhead Base Cost Elements4BKONDCondition typenvarchar40
21TKZU2Overhead Base Origin4BKONDCondition typenvarchar40
22TKZU4Surcharge Base - Cost Center / Activity Type4BKONDCondition typenvarchar40
TOPReal Estate Contract
23VICDCFOBJObject-Related Cash Flow46BKONDCondition item currency amountdecimal172
24VICDCFPAYPayment-Related Cash Flow46BKONDCondition item currency amountdecimal172
TOPReal Estate Management
25S406Rental units60BKONDCondition: amountdecimal132
26S407Rental agreements99BKONDCondition item currency amountdecimal152
27TZK02Condition group, condition group - condition type allocation38BKONDCondition item currency amountdecimal132
28VIRPS406Rental units60BKONDCondition: amountdecimal132
29VIRPS407Rental agreements99BKONDCondition item currency amountdecimal132
30VIVW02Management contract: Periodic fee types9BKONDCondition item currency amountdecimal132
31VZZKOPO_DMAmount fields for VZZKOPO in original currency11BKONDCondition item currency amountdecimal132
TOPRemaining Beverage - Obsolete Objects
32/BEV3/CHABEWEALTTest Transfer Structure: Flow Records in Cash Flow Calcul.48BKONDCondition item currency amountdecimal172
33/BEV3/CHAKONDALTTest transfer structure cash flow for conditions24BKONDCondition item currency amountdecimal172
TOPTransaction Data Pool
34JBDKOPOCondition Items10BKONDAmount of Condition Itemdecimal172
35JBDVTCPVariable Transaction - Condition Items8BKONDAmount of Condition Itemdecimal172
TOPTransaction Manager
36BCKVZZKOPOBACKUP: Condition Item Table13BKONDCondition item currency amountdecimal132
37OTC_CONV_FINKOBackup Table for Financial Transaction Conditions24BKONDCondition item currency amountdecimal132
38OTC_CONV_IFINKOBackup Table for Financial Transaction Underlying Conditions23BKONDCondition item currency amountdecimal132
39VTBFINKOTransaction Condition24BKONDCondition item currency amountdecimal132
40VTIFINKOUnderlying transaction conditions23BKONDCondition item currency amountdecimal132
TOPTreasury
41VZZKOPOTable condition items14BKONDCondition item currency amountdecimal132