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  | TFK090A
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
Financial Accounting :: Contract Accounts Receivable and Payable
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TFK090A361Mass Activity TypesContract Accounts Receivable and Payable
SQL:  selectupdate insert create

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

SELECT AKTYP, EVE_ITVL, EVE_PARA, TCODE, JTYPE, NOIMME, NODATE, NOCONT, OBJECT, NO_FIKEY, HERKF, RESOB, PER_MAND, COTYP, BEGRU, FAUS, PARA_ICON, STRUCT, PARAM_ID, FB_ADJUST, LEN_LAUFI, LAYOUT, MAX_JOBS, USE_MASS_DOC, APPL_LOG_LEV1, APPL_LOG_LEV2, APPL_LOG_LEV3, APPL_LOG_LEV4, APPL_LOG_LEV5, FREE_SEL_TAB, XNOCOMPAUTHCHECK, SHOW_STD_COUNT, MAX_ITVL_RETRIES, ALOBJ, NO_BUDAT, DEF_DBLIMIT FROM TFK090A
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1AKTYPMass activity typenvarchar40CHAR(N' ')NoAKTYP_KK Allow NULL? 
2EVE_ITVLEvent for Interval Processing of Mass Activitynvarchar40CHAR(N' ')YesTFKFBMEVE_ITVL_KK Allow NULL? 
3EVE_PARAActivity Event: Additional Parameters or Move Parametersnvarchar40CHAR(N' ')YesTFKFBMEVE_PARA_KK Allow NULL? 
4TCODETransaction Codenvarchar200CHAR(N' ')YesTSTCTCODE Allow NULL? 
5JTYPEJob categorynvarchar20CHAR(N' ')YesTFKDO_TYPJTYPE_KK Allow NULL? 
6NOIMMENo Immediate Start Allowedchar10CHAR(N' ')YesNOIMME_KK Allow NULL? 
7NODATEStart Using Date not Permittedchar10CHAR(N' ')YesNODATE_KK Allow NULL? 
8NOCONTStart via Job Container Not Permittedchar10CHAR(N' ')YesNOCONT_KK Allow NULL? 
9OBJECTObject for distribution into intervalsnvarchar100CHAR(N' ')YesTFKDIOBJECT_KK Allow NULL? 
10NO_FIKEYReconciliation Key Not Requiredchar10CHAR(N' ')YesNO_FIKEY_KK Allow NULL? 
11HERKFDocument Origin Keynvarchar20CHAR(N' ')YesTFK001HERKF_KK Allow NULL? 
12RESOBReservation Objectnvarchar30CHAR(N' ')YesRESOB_KK Allow NULL? 
13PER_MANDPeriod selection requestedchar10CHAR(N' ')YesPER_MAND_KK Allow NULL? 
14COTYPCorrespondence Typenvarchar40CHAR(N' ')YesTFK070ACOTYP_KK Allow NULL? 
15BEGRUAuthorization Groupnvarchar40CHAR(N' ')YesBEGRU Allow NULL? 
16FAUSField selection fieldsnvarchar500CHAR(N' ')YesFAUS1_KK Allow NULL? 
17PARA_ICONIcon in text fields (substitute display, alias)nvarchar40CHAR(N' ')YesICONICON_D Allow NULL? 
18STRUCTMass activities: Structure of additional parametersnvarchar300CHAR(N' ')YesDD02LFKK_MAD_STRUCT Allow NULL? 
19PARAM_IDParameter IDnvarchar200CHAR(N' ')YesTPARAPARAM_ID Allow NULL? 
20FB_ADJUSTFunction module for parameter version adjustmentnvarchar300CHAR(N' ')YesTFDIRFKK_MAD_FB_ADJUST_KK Allow NULL? 
21LEN_LAUFIMass Activities: Permitted Length for Run Identificationchar10CHAR(N' ')YesLEN_LAUFI_KK Allow NULL? 
22LAYOUTTab in master records: Tab layoutnvarchar40CHAR(N' ')Yes*TAB_LAYOUT Allow NULL? 
23MAX_JOBSMaximum Number of Jobs for an Activitysmallint50INT2((0))YesMAX_JOBS_KK
24USE_MASS_DOCUse of Mass Postings Functionchar10CHAR(N' ')YesUSE_MASS_DOC_KK Allow NULL? 
25APPL_LOG_LEV1Use of Application Log on Level 1char10CHAR(N' ')YesUSE_APPL_LOG_ON_LEVEL1_KK Allow NULL? 
26APPL_LOG_LEV2Use of Application Log on Level 2char10CHAR(N' ')YesUSE_APPL_LOG_ON_LEVEL2_KK Allow NULL? 
27APPL_LOG_LEV3Use of Application Log on Level 3char10CHAR(N' ')YesUSE_APPL_LOG_ON_LEVEL3_KK Allow NULL? 
28APPL_LOG_LEV4Use of Application Log on Level 4char10CHAR(N' ')YesUSE_APPL_LOG_ON_LEVEL4_KK Allow NULL? 
29APPL_LOG_LEV5Use of Application Log on Level 5char10CHAR(N' ')YesUSE_APPL_LOG_ON_LEVEL5_KK Allow NULL? 
30FREE_SEL_TABTable on Which Free Selection Is Basednvarchar300CHAR(N' ')YesDD02LFREE_SEL_TAB_KK Allow NULL? 
31XNOCOMPAUTHCHECKSuppress Authorization Check for Company Codeschar10CHAR(N' ')YesXNOCOMPAUTHCHECK_KK Allow NULL? 
32SHOW_STD_COUNTDisplay Standard Counterchar10CHAR(N' ')YesSHOW_STD_COUNT_KK Allow NULL? 
33MAX_ITVL_RETRIESMaximum Number of Repetition Attempts for Intervalsmallint50INT2((0))YesMAX_ITVL_RETRIES_KK
34ALOBJApplication Log: Object Name (Application Code)nvarchar200CHAR(N' ')Yes*BALOBJ_D Allow NULL? 
35NO_BUDATPosting Date Not Required Field/Empty as Standardchar10CHAR(N' ')YesNO_BUDAT_KK Allow NULL? 
36DEF_DBLIMITProposal for Block Size for Mass Selectionint100INT4((0))YesDEF_DBLIMIT_KK Allow NULL? 
NamePrimaryUniqueTypeColumns
TFK090A~0YesYesCLUSTEREDAKTYP

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