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

22 columns | Print definition?ERP 6.0  | BTTYP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2RX_BTPayroll Results: Bank Transfers21BTTYPPBS Transfer Typenvarchar20
2P2RX_BT_PERSONPayment-Related Information (Person)23BTTYPPBS Transfer Typenvarchar20
3T5M3UBank Transfer Types (Denmark)3BTTYPPBS Transfer Typenvarchar20
4T77PAYKZBTBank Transfer Table Image (BTKZ)38BTTYPPBS Transfer Typenvarchar20
TOPAgency Business Global Trade
5WBINTRSTAgency Business : Intrastat Relevant data20BTTYPBusiness Transaction Type (Intrastat Code)nvarchar20
TOPCompany Pension Scheme Germany
6PA0202HR Master Record Infotype 0202 (Entitlements)75BTTYPType of Amount Calculationnvarchar10
TOPDenmark
7T5M3TTexts for Transfer Types (Denmark)2BTTYPPBS Transfer Typenvarchar20
TOPElectronic Compliance Reporting
8/ECRS/DVIADefault Values for Import Worklist6BTTYPBusiness Transaction Type (Intrastat Code)nvarchar20
9/ECRS/RPACAggregated Correction Item10BTTYPBusiness Transaction Type (Intrastat Code)nvarchar20
10/ECRS/RPAIAggregated Declaration Item7BTTYPBusiness Transaction Type (Intrastat Code)nvarchar20
11/ECRS/RPICCorrection Item13BTTYPBusiness Transaction Type (Intrastat Code)nvarchar20
12/ECRS/RPITDeclaration Item10BTTYPBusiness Transaction Type (Intrastat Code)nvarchar20
13/ECRS/TBTTBusiness Transaction Type (Intrastat Code)3BTTYPBusiness Transaction Type (Intrastat Code)nvarchar20
14/ECRS/TBTTTBusiness Transaction Type (Intrastat Code) Name4BTTYPBusiness Transaction Type (Intrastat Code)nvarchar20
15/ECRS/WLENWorklist for Intrastat Declaration50BTTYPBusiness Transaction Type (Intrastat Code)nvarchar20
TOPPayroll
16T7SIBUBank Units Slovenia16BTTYPVrsta nakazilanvarchar20
17T7SIBUXConversion to TRR 20035BTTYPVrsta nakazilanvarchar20
18T7SKEC0009Logovacia tabulka pre EURO konverziu - IT 000953BTTYPDruh prevodu PBSnvarchar20
TOPPersonnel Administration
19PA0009HR Master Record: Infotype 0009 (Bank Details)50BTTYPPBS Transfer Typenvarchar20
20T521BPayee Keys21BTTYPPBS Transfer Typenvarchar20
TOPRecruitment
21PB0009HR Master Record: Infotype 0009 (Bank Details)50BTTYPPBS Transfer Typenvarchar20
TOPRussia
22T7RU1BPayee Keys of receiving orders (Russia standard)25BTTYPPBS Transfer Typenvarchar20