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

Home | ERP 6.0  | BKKM3
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)
8BSEG345Accounting Document Segment
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
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
Industry Specific :: Bank Components :: Bank Customer Accounts :: Periodic Tasks :: InterestCharge Calculation
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0BKKM3372BCA: Parameters for Mass Runs in Parallel ProcessingInterestCharge Calculation
SQL:  selectupdate insert create

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

SELECT MANDT, PROGN, PROGDATE, PROGNO, RUNSTARTNO, RUNCATG, BKKRS, CLOS_TYP, CLOSETIME, RUNDATE, RUNTIME, RUNUSER, ACCOUNTGE, ACCOUNTLE, ACURRENCY, CLOSEDATE, XACCRUAL, XFEEACCR, TRACE, SIM_RUN, TOLERANCE, CURR, CLOSEDATE_CC, VAL_DAT_TO, ROUND_POS, X_SIM_RUN, BANKSTATDATE, FDATEPOST, FTIMEPOST, XSIMULBKST, XSCREENOUT, XBKSTNOITEM, XDUPLICATE, DUPLDATEFROM, DUPLDATETO, TRACELOG, PRODINT FROM BKKM3
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2PROGNName of the Program/Report on an Application Processnvarchar400CHAR(N' ')NoBKKMPARUNHDBKK_PROGN Allow NULL? 
3PROGDATERun Date of Programnvarchar80DATS(N'00000000')NoBKKMPARUNHDBKK_PRGDAT Allow NULL? 
4PROGNOSequential Number of the Program Runnvarchar30NUMC(N'000')NoBKKMPARUNHDBKK_PRGNO Allow NULL? 
5RUNSTARTNONumber of Repeated Starts of a Mass Runnvarchar30NUMC(N'000')NoBKK_RUNSTARTNO Allow NULL? 
6RUNCATGCategory of a Program Run (Parallel Processing)char10CHAR(N' ')NoBKK_RUNCATG Allow NULL? 
7BKKRSBank Areanvarchar40CHAR(N' ')YesTBKK01BKK_BKKRS Allow NULL? 
8CLOS_TYPConsolidation Frequencynvarchar40CHAR(N' ')YesTBKKG2BKK_CLSTYP Allow NULL? 
9CLOSETIMEBalancing timenvarchar60TIMS(N'000000')YesBKK_CLSTIM Allow NULL? 
10RUNDATEDate of Mass Runnvarchar80DATS(N'00000000')YesBKK_RUNDAT Allow NULL? 
11RUNTIMETime of Program Runnvarchar60TIMS(N'000000')YesBKK_RUNTIM Allow NULL? 
12RUNUSERUser Who Started Program Runnvarchar120CHAR(N' ')YesBKK_RUNUSR Allow NULL? 
13ACCOUNTGEAccount Number Bigger/Equalnvarchar350CHAR(N' ')YesBKK_ACEXGE Allow NULL? 
14ACCOUNTLEAccount Number Smaller/Equalnvarchar350CHAR(N' ')YesBKK_ACEXLE Allow NULL? 
15ACURRENCYCurrency of Current Accountnvarchar50CUKY(N' ')Yes*BKK_ACCUR Allow NULL? 
16CLOSEDATEBalancing datenvarchar80DATS(N'00000000')YesBKK_CLSDAT Allow NULL? 
17XACCRUALIndicator: Execute Interest Acc./Def.char10CHAR(N' ')YesBKK_XACCRU Allow NULL? 
18XFEEACCRIndicator: Execute Accrual/Deferral for Chargeschar10CHAR(N' ')YesBKK_XACCRF Allow NULL? 
19TRACEAccount Balancing Logchar10CHAR(N' ')YesBKK_TRCL Allow NULL? 
20SIM_RUNSimulationchar10CHAR(N' ')YesBKK_SIM Allow NULL? 
21TOLERANCETolerance Amountdecimal172CURR((0))YesBKK_TOLAMT
22CURRTransaction Currencynvarchar50CUKY(N' ')Yes*BKK_TCUR Allow NULL? 
23CLOSEDATE_CCBalancing datenvarchar80DATS(N'00000000')YesBKK_CLSDAT Allow NULL? 
24VAL_DAT_TOCash Concentration: Value Date tonvarchar80DATS(N'00000000')YesBKK_VAL_TO Allow NULL? 
25ROUND_POSCash Concentration: Rounding Off from Pointnvarchar20NUMC(N'00')YesBKK_RND_PS Allow NULL? 
26X_SIM_RUNCash Concentration: X-Simulation Runchar10CHAR(N' ')YesBKK_CLSIMU Allow NULL? 
27BANKSTATDATEBank Statement Datenvarchar80DATS(N'00000000')YesBKK_ACSTDT Allow NULL? 
28FDATEPOSTPosting Date of Oldest Posted Document on Statementnvarchar80DATS(N'00000000')YesBKK_FPSTDT Allow NULL? 
29FTIMEPOSTPosting Time of Oldest Document on Statmentnvarchar60TIMS(N'000000')YesBKK_FPSTTI Allow NULL? 
30XSIMULBKSTIndicator: Simulation of Statement Outputchar10CHAR(N' ')YesBKK_XSIMBS Allow NULL? 
31XSCREENOUTIndicator: Bank Statement Standard Outputchar10CHAR(N' ')YesBKK_XSCR Allow NULL? 
32XBKSTNOITEMIndicator: Bank Statement Without Turnoverschar10CHAR(N' ')YesBKK_XNOITEM Allow NULL? 
33XDUPLICATEIndicator Duplicate Creation for Bank Statementchar10CHAR(N' ')YesBKK_XDUPLICATE Allow NULL? 
34DUPLDATEFROMFrom Date for Bank Statement Duplicate Outputnvarchar80DATS(N'00000000')YesBKK_DUPLDATEFROM Allow NULL? 
35DUPLDATETOTo Date for Bank Statement Duplicate Outputnvarchar80DATS(N'00000000')YesBKK_DUPLDATETO Allow NULL? 
36TRACELOGLog Category for Bank Statementchar10CHAR(N' ')YesBKK_BKSTTRACE Allow NULL? 
37PRODINTInternal Product IDnvarchar180CHAR(N' ')Yes*BKK_PRODINT Allow NULL? 
NamePrimaryUniqueTypeColumns
BKKM3~0YesYesCLUSTEREDRUNCATG, RUNSTARTNO, PROGNO, PROGDATE, PROGN, MANDT
BKKM3~1NoNoNONCLUSTEREDCLOS_TYP, BKKRS, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy