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

109 columns | Print definition?ERP 6.0  | AKTYP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DFKK_RCVER_LOCKLock table: Receiver ID4AKTYPMass activity typenvarchar40
2REFXCN_PROMCATPromotional Data3AKTYPPromotion Categorynvarchar100
3REFXCN_RULEMAPMapping of Material Group & Promotion Cat. to Reporting Rule5AKTYPPromotion Categorynvarchar40
4REFXCN_RULMAPMapping of Material Group & Promotion Cat. to Reporting Rule6AKTYPPromotion Categorynvarchar100
5T020FI/AM Transaction Control3AKTYPActivity category in SAP transactionnvarchar10
6T063Screen Control: Inventory Management6AKTYPActivity category in SAP transactionnvarchar10
7T066Screen Selection, Invoice Verification7AKTYPActivity category in SAP transactionnvarchar10
8T078SAction Type Screen Selection for G/L Acct Master Data2AKTYPActivity category in SAP transactionnvarchar10
9T130MTransaction control parameters: material master maintenance3AKTYPActivity category in SAP transactionnvarchar10
10T138BMaterial master screen sequence control7AKTYPActivity category in SAP transactionnvarchar10
11T148MTransaction control parameters: special stocks3AKTYPActivity category in SAP transactionnvarchar10
12T168Screen Control, Purchasing5AKTYPActivity category in SAP transactionnvarchar10
13T342Control of Screen Sequence in WM14AKTYPActivity category in SAP transactionnvarchar10
14T365Initial values for PM notification transactions4AKTYPActivity category in transaction (Cr/Ch/D)nvarchar10
15T370Start Values for PM Master Data Transactions4AKTYPActivity category in transaction (Cr/Ch/D)nvarchar10
16T370AActivity Category for PM Lists4AKTYPActivity category in SAP transactionnvarchar10
17T401MTransaction control paramters: MRP profiles3AKTYPActivity category in SAP transactionnvarchar10
18T441MForecast transaction control3AKTYPActivity category in SAP transactionnvarchar10
19T450PTransaction control for maintaining ind. requirements8AKTYPActivity category in SAP transactionnvarchar10
20T588ATransaction Codes5AKTYPActivity Type for Transactionsnvarchar10
21TC62Sequence of detail screens when processing header externally2AKTYPActivity category in SAP transactionnvarchar10
22TK180Default Values per Transaction (Screen Sequence Control)5AKTYPActivity category in SAP transactionnvarchar10
23TKSB0Transaction control CO4AKTYPActivity category in SAP transactionnvarchar10
24TTABSTables with Special Maintenance3AKTYPActivity category in SAP transactionnvarchar10
25T7PIQCORRAPFORMApplication Forms for Ad-Hoc Correspondence3AKTYPMass activity typenvarchar40
TOPBasic Functions
26T180Screen Sequence Control: Transaction Default Values4AKTYPActivity category in SAP transactionnvarchar10
TOPBusiness Partner Enhancements for Financial Services
27TP105BP: Field Modification via Activity Category2AKTYPActivity Category for Business Partner Managementnvarchar20
TOPClaims Management
28TICL025Transaction Control FS-CM2AKTYPActivity Categorynvarchar20
29TICL170Transaction Control FS-CM-EVT2AKTYPActivity Categorynvarchar20
30TICL450FS-CM: Benefits/Services/Fees Catalog Transaction Control2AKTYPActivity Categorynvarchar20
TOPCollectionsDisbursements
31TVSC_FSTATUSField Status for Fields in Scheduling1AKTYPActivity Categorynvarchar20
TOPConsumption-Based Planning See Also PP-MRP
32WSAF_PRED_AKTYPAssignments of Promotion Types to Predictors (SAF)4AKTYPPromotion Categorynvarchar40
33WSAF_PROMO_DELTAChange Information for Promotions6AKTYPPromotion Categorynvarchar40
TOPContract Accounts Receivable and Payable
34DFKKDDADebit Memo Notification36AKTYPMass activity typenvarchar40
35DFKKENQTemporary Lock Entries for Mass Activities2AKTYPMass activity typenvarchar40
36DFKKIP_ITMHPayment Specification: Deletions Not Yet Confirmed20AKTYPPayment Specification: Activity Categorynvarchar10
37DFKKRPLLink from Mass Run Interval for Application Log4AKTYPMass activity typenvarchar40
38DFKKSTATTable for Temporary Statistics Data, for Mass Activities2AKTYPMass activity typenvarchar40
39DFKK_BUKRS_LOCKLock Table: Company Code4AKTYPMass activity typenvarchar40
40DFKK_SELP_HISTFI-CA Selection - Result Records - History2AKTYPMass activity typenvarchar40
41DFKK_VKONT_LOCKLock Table: Contract Account (Interval)5AKTYPMass activity typenvarchar40
42DFK_JC_CNTR_PRODProduction Table3AKTYPMass activity typenvarchar40
43DPAYCPayment program - administrative records14AKTYPMass activity typenvarchar40
44FKJOPARAMSUser-Defined Parameters for FKJO_SCHEDULE3AKTYPMass activity typenvarchar40
45FKKCOCCVCorrespondence generation - control records2AKTYPMass activity typenvarchar40
46TFK048CExecution variants of event 50152AKTYPMass activity typenvarchar40
47TFK048CTExecution variants texts3AKTYPMass activity typenvarchar40
48TFK090AMass Activity Types1AKTYPMass activity typenvarchar40
49TFK090ATContract A/R & A/P Activities - Activity Type (Texts)2AKTYPMass activity typenvarchar40
50TFK090BMass Activities: List of Add. Functions fr.Environment Menu1AKTYPMass activity typenvarchar40
51TFK090BTMass Activities: Texts on Add. Functions via Menu Environmt2AKTYPMass activity typenvarchar40
52TFK090CMass Activities: Permitted Synchronization Objects1AKTYPMass activity typenvarchar40
53TFK090EMass Activities - Field Selection - Free Selection1AKTYPMass activity typenvarchar40
54TFK090_CATMass Activities: Additional Characteristic2AKTYPMass activity typenvarchar40
55TFK090_CATTMass Activities: Texts of Additional Characteristics3AKTYPMass activity typenvarchar40
56TFK090_COUNTERDefinition Table of Counters for Mass Activities1AKTYPMass activity typenvarchar40
57TFK090_COUNTERTText Table for TFK090_COUNTER2AKTYPMass activity typenvarchar40
58TFKK_SELP_TYPSelection Types - Customizing5AKTYPMass Activity Typenvarchar40
59TFKMSGARecording of Problem Classes of Messages2AKTYPMass activity typenvarchar40
60TFKMSGCProblem Class of Messages (Customer)2AKTYPMass activity typenvarchar40
61TFKMSGSProblem Class of Messages (Standard)1AKTYPMass activity typenvarchar40
TOPContract Billing
62ERCHV_GEN_PROTStructure Log of Consumption History4AKTYPMass activity typenvarchar40
TOPData Collection
63S086Promotion15AKTYPPromotion Categorynvarchar40
64S086ES086 - Structural Information10AKTYPPromotion Categorynvarchar40
65S117Receipt/article30AKTYPPromotion Categorynvarchar40
66S953BW Vorl.für BON/Artikel S11730AKTYPAktionstypnvarchar40
TOPIncentive and Commission Management ICM
67CACSCD_ACSCDAccount Assignment of Stt.Types for FS-CD Settlement System6AKTYPActivity Categorynvarchar20
68CACSCD_DOCCD_PDSettlement to FS-CD: Reference Document Line Items8AKTYPActivity Categorynvarchar20
TOPInvoicing
69ERPLIS-U: Link of Mass Run Interval to Application Log4AKTYPMass activity typenvarchar40
TOPInvoicing in Contract Accounts Receivable and Payable
70DFKKINV_CYCREQDummy Document for Invoicing for Periodic Invoicing12AKTYPMass activity typenvarchar40
TOPLoans Management
71TDPR_TA_PRTYPEAssignment of Transaction Code to Product Category3AKTYPActivitynvarchar20
TOPMaintenance Notifications
72TQSCRNotification: Screen control4AKTYPActivity category in transaction (Cr/Ch/D)nvarchar10
73TQSCRTNotification: Text table heading tabstrip4AKTYPActivity category in transaction (Cr/Ch/D)nvarchar10
TOPMaintenance Orders
74IWOT_LNKAssignment of View Profiles4AKTYPActivity category in transaction (Cr/Ch/D)nvarchar10
TOPPayment Item
75TBKKIDTBCA/Internal Payment Trans.: Control Table for Dialog Callup4AKTYPActivitynvarchar20
76TBKKIFVFunction Variants for Document Type and Activity2AKTYPActivitynvarchar20
77TBKKI_02AFunction Variant Inference3AKTYPActivitynvarchar20
78TBKKI_04Field Status Resulting from Activity2AKTYPActivitynvarchar20
TOPPeriodical Sales and Distribution
79TJ180Initial Values of Transaction in IS-M4AKTYPActivity category in SAP transactionnvarchar10
TOPProduction Orders
80TCO05CUA status depending on panel, trans. type, funct. type etc.6AKTYPActivity category in the transactionnvarchar10
TOPPromotion
81TWAAPromotion Type, IS-R3AKTYPPromotion Categorynvarchar40
82TWTYPromotion category, IS-R2AKTYPPromotion Categorynvarchar40
83TWTYTPromotion cat. short text, IS-R2AKTYPPromotion Categorynvarchar40
84WAKHPromotion Header Data, IS-R3AKTYPPromotion Categorynvarchar40
TOPPublic Sector Contract Accounts Receivable and Payable
85DFMCA_RETURN_OData Table for Tax Returns2AKTYPMass activity typenvarchar40
TOPQuality Notifications
86TQ85Function table for follow-up functions6AKTYPUsage for Follow-Up Functionnvarchar20
TOPRemaining Beverage - Obsolete Objects
87/BEV3/CH180Screen Sequence Control: Transaction Default Values5AKTYPActivity category in SAP transactionnvarchar10
TOPRouting
88TC01CUA status table6AKTYPActivity category in the transactionnvarchar10
89TC01ASet type of function5AKTYPActivity category in the transactionnvarchar10
TOPSAP Business Partner
90TB105BDT Field Grouping for each Activity Category3AKTYPBDT activitynvarchar20
91TB105_2BDT Field Grouping per Activity Category Part 23AKTYPBDT activitynvarchar20
92TB105_3BDT Field Grouping per Activity Category Part 33AKTYPBDT activitynvarchar20
93TB105_4BDT Field Grouping per Activity Category Part 43AKTYPBDT activitynvarchar20
94TB109BDT Application Transactions for Appl. Object BUPA3AKTYPBDT activitynvarchar20
95TB201BP: Scheduled Changes for each Role (Time-Dependency)4AKTYPActivity Categorynvarchar20
96TBZ0KBDT Activity Categories1AKTYPActivity Categorynvarchar20
97TBZ0LBDT Activity Categories: Texts2AKTYPActivity Categorynvarchar20
98TBZ0MBDT Activities4AKTYPActivity Categorynvarchar20
99TBZ1EBDT Application Transactions5AKTYPBDT activitynvarchar20
TOPSAP Utilities
100EMA_ENQGlobal Lock for Mass Activity for Mass Run2AKTYPMass activity typenvarchar40
101ESMON_MARUNIDHDRMonitoring Mass Run: Buffer for Header Data2AKTYPMass activity typenvarchar40
102ESMON_MARUNIDINTMonitoring Mass Run: Buffer for Intervals2AKTYPMass activity typenvarchar40
103ESMON_MASS_ACTMonitoring Mass Run: Supported Mass Activity Types =Obsolete1AKTYPMass activity typenvarchar40
104ESMON_MASS_ACT_AMonitoring Mass Run: Activated Mass Activity Types2AKTYPMass activity typenvarchar40
TOPScreen Sequence Control
105T185FScreen Control: Function Codes4AKTYPActivity category in SAP transactionnvarchar10
TOPTransaction Manager
106AT185Treasury: Starting Values for Subsequent Screen Control4AKTYPActivity category in SAP transactionnvarchar10
TOPTransportation and Distribution
107OIGSHTD Shipment History5AKTYPActivity category in SAP transactionnvarchar10
TOPWarehouse Management
108T342TAssignment of Title Bar to PF Status6AKTYPActivity category in SAP transactionnvarchar10
TOPWarranties
109T790Warranty Transaction - Initial Values4AKTYPActivity category in transaction (Cr/Ch/D)nvarchar10