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

19 columns | Print definition?ERP 6.0  | BANK

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPPSSRM/PYMTPayment Details8BANKBank Namenvarchar500
2BOE_C_AMT_BNMax amount per house bank for payable. BoE3BANKShort Key for a House Banknvarchar50
3BSEDBill of Exchange Fields Document Segment33BANKBank Keysnvarchar150
4EPIC_DUM_BALBalance of Dummy Bank2BANKCharacter Field Length = 10nvarchar100
5EPIC_DUM_TRANSACTransactions of Dummy Bank2BANKCharacter Field Length = 10nvarchar100
6FIPDCOM_LOGOman PDC Printing log6BANKBank Keysnvarchar150
7FUDT_VDOCBSEDBill of Exchange Fields Document Seg. of Verif. Doc33BANKBank Keysnvarchar150
8FUDT_VDOCBSEDHBill of Exchange Fields Segment of Verification Doc(History)33BANKBank Keysnvarchar150
9HRP1890DB Table for Infotype 189026BANKName of Banknvarchar500
TOPFinancial Accounting
10J_3KBANKBank accounts in ZAP5BANKBank namenvarchar300
TOPLocalization
11J_1BLFA1_REC55Information for generating record type 55 referred to GNRE7BANKArchivo Magnetico record 55: GNRE bank codenvarchar30
12J_VE_INCWTMaintain Withholding Tax Payment Details6BANKBank Data for Withholding Tax Reportingnvarchar400
TOPNetherlands
13T5N9RRelationship Repr. Legal Person and External Agencies9BANKBank Account / Giro Account Numbernvarchar180
TOPReal Estate Management
14RFVIAUSZUGTest Data for RE Multicash Statement Data6BANKBank datanvarchar120
15RFVIBK01ABank Procedure Test Data - A-Record6BANKBank datanvarchar120
16RFVIBK01CBank Procedure Test Data - C-Record7BANKBank datanvarchar120
17RFVIBK01EBank Procedure Test Data: E-Record6BANKBank datanvarchar120
18RFVIBK01VBank Procedure Test Data - C-Record - File Extension7BANKBank datanvarchar120
19RFVIUMSATZTest Data for RE Multicash Sales Data7BANKBank datanvarchar120