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
6BSEG345Accounting Document Segment
7/ISDFPS/CHVW_E34External Batch Where-Used List
8FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6OPCH386A/P Invoice
7INV1265A/R Invoice - Rows
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINM101Whse Journal
4OINV268A/R Invoice
5OIVL77Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Financial Accounting :: Contract Accounts Receivable and Payable
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0DFKKNRP403NOC Returns Lot: Item DataContract Accounts Receivable and Payable
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, KEYN1, POSNA, AENAM, AEDAT, AETIM, XMDCH, FLGRD, STANP, FLINS, GPART, VKONT, VTREF, SUBAP, BKVID, VALDT, BKVID_DEL, ABWBP, BANKS_O, BANKL_O, BANKN_O, BKONT_O, BKREF_O, KOINH_O, IBAN_O, BANKS_N, BANKL_N, BANKN_N, BKONT_N, BKREF_N, KOINH_N, IBAN_N, NAME_LAST, NAME_FIRST, EBVTY, ABVTY, EBVTY_VT, ABVTY_VT, ERTXT, INFOF FROM DFKKNRP
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2KEYN1Reporting of Incorrect Bank Data: Lot Numbernvarchar120CHAR(N' ')NoKEYN1_KK Allow NULL? 
3POSNAReporting of Incorrect Bank Data: Item Numbernvarchar60NUMC(N'000000')NoPOSNA_KK Allow NULL? 
4AENAMName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
5AEDATChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
6AETIMTime at Which the Object Was Last Changednvarchar60TIMS(N'000000')YesAETIM_KK Allow NULL? 
7XMDCHReporting of Incorr. Bank Data: Master Data Change Requiredchar10CHAR(N' ')YesXMDCH_KK Allow NULL? 
8FLGRDError Reasonnvarchar30CHAR(N' ')Yes*FLGRD_KK Allow NULL? 
9STANPReporting of Incorrect Bank Data: Status of Itemschar10CHAR(N' ')YesSTANP_KK Allow NULL? 
10FLINSSender Institution Error Reasonnvarchar30CHAR(N' ')YesFLINS_KK Allow NULL? 
11GPARTBusiness Partner Numbernvarchar100CHAR(N' ')Yes*GPART_KK Allow NULL? 
12VKONTContract Account Numbernvarchar120CHAR(N' ')Yes*VKONT_KK Allow NULL? 
13VTREFReference Specifications from Contractnvarchar200CHAR(N' ')YesVTREF_KK Allow NULL? 
14SUBAPSubapplication in Contract Accounts Receivable and Payablechar10CHAR(N' ')YesSUBAP_KK Allow NULL? 
15BKVIDBank details IDnvarchar40CHAR(N' ')YesBU_BKVID Allow NULL? 
16VALDTInitial Date for Business Partner Datanvarchar80DATS(N'00000000')YesBU_VALDT Allow NULL? 
17BKVID_DELBank Details to Be Deletednvarchar40CHAR(N' ')YesBKDEL_KK Allow NULL? 
18ABWBPAlternative Business Partnernvarchar100CHAR(N' ')Yes*ABWBP_KK Allow NULL? 
19BANKS_OBank country keynvarchar30CHAR(N' ')Yes*BANKS Allow NULL? 
20BANKL_OBank numbernvarchar150CHAR(N' ')YesBANKL Allow NULL? 
21BANKN_OBank account numbernvarchar180CHAR(N' ')YesBANKN Allow NULL? 
22BKONT_OBank Control Keynvarchar20CHAR(N' ')YesBKONT Allow NULL? 
23BKREF_OReference specifications for bank detailsnvarchar200CHAR(N' ')YesBKREF Allow NULL? 
24KOINH_OAccount Holder Namenvarchar600CHAR(N' ')YesBU_KOINH Allow NULL? 
25IBAN_OIBAN (International Bank Account Number)nvarchar340CHAR(N' ')YesFKK_IBAN Allow NULL? 
26BANKS_NBank country keynvarchar30CHAR(N' ')Yes*BANKS Allow NULL? 
27BANKL_NBank numbernvarchar150CHAR(N' ')YesBANKL Allow NULL? 
28BANKN_NBank account numbernvarchar180CHAR(N' ')YesBANKN Allow NULL? 
29BKONT_NBank Control Keynvarchar20CHAR(N' ')YesBKONT Allow NULL? 
30BKREF_NReference specifications for bank detailsnvarchar200CHAR(N' ')YesBKREF Allow NULL? 
31KOINH_NAccount Holder Namenvarchar600CHAR(N' ')YesBU_KOINH Allow NULL? 
32IBAN_NIBAN (International Bank Account Number)nvarchar340CHAR(N' ')YesFKK_IBAN Allow NULL? 
33NAME_LASTLast name of business partner (person)nvarchar400CHAR(N' ')YesBU_NAMEP_L Allow NULL? 
34NAME_FIRSTFirst name of business partner (person)nvarchar400CHAR(N' ')YesBU_NAMEP_F Allow NULL? 
35EBVTYBank Details ID for Incoming Paymentsnvarchar40CHAR(N' ')YesEBVTY_KK Allow NULL? 
36ABVTYBank Details ID for Outgoing Paymentsnvarchar40CHAR(N' ')YesABVTY_KK Allow NULL? 
37EBVTY_VTBank Details ID for Incoming Paymentsnvarchar40CHAR(N' ')YesEBVTY_KK Allow NULL? 
38ABVTY_VTBank Details ID for Outgoing Paymentsnvarchar40CHAR(N' ')YesABVTY_KK Allow NULL? 
39ERTXTError Text when Reporting Back the Prenotificationnvarchar440CHAR(N' ')YesERRTXT Allow NULL? 
40INFOFAdditional informationnvarchar500CHAR(N' ')YesINFOF_KK Allow NULL? 
NamePrimaryUniqueTypeColumns
DFKKNRP~0YesYesCLUSTEREDPOSNA, KEYN1, MANDT
DFKKNRP~001NoNoNONCLUSTEREDSTANP, KEYN1, MANDT
DFKKNRP~002NoNoNONCLUSTEREDVTREF, VKONT, GPART, MANDT