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

39 columns | Print definition?ERP 6.0  | CHECKTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/T_ACCHECKCheck assignment14CHECKTYPEField Checknvarchar10
2/AIF/T_ACCHECKVCheck assignment16CHECKTYPEField Checknvarchar10
3/AIF/T_FMAPCONDField condition mapping32CHECKTYPEField Checknvarchar10
4/AIF/T_FMAPCONDVField condition mapping variant35CHECKTYPEField Checknvarchar10
5/AIF/T_IFCHECKCheck assignment17CHECKTYPEField Checknvarchar10
6/AIF/T_IFCHECKVCheck assignment19CHECKTYPEField Checknvarchar10
7/AIF/T_RECFLDSField definition9CHECKTYPEField Checknvarchar10
8/AIF/T_TABCHKSingle Check5CHECKTYPEField Checknvarchar10
9/AIF/T_TABCHKVSingle Check7CHECKTYPEField Checknvarchar10
10/OPT/X085Process Type Determination Step Details7CHECKTYPECheck Typenvarchar10
11/OPT/X097Document Type Determination Step Details6CHECKTYPEDoc. Type . Determination Check Typenvarchar10
12/OPT/Y085Process Type Determination Step Details7CHECKTYPECheck Typenvarchar10
13/OPT/Y097Document Type Determination Step Details6CHECKTYPEDoc. Type . Determination Check Typenvarchar10
14/OPT/Z085Process Type Determination Step Details7CHECKTYPECheck Typenvarchar10
15/OPT/Z097Document Type Determination Step Details6CHECKTYPEDoc. Type . Determination Check Typenvarchar10
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
16DCERRLISTDD: Tabelle für die Speicherung fehlerhafter DD-Objekte1CHECKTYPEDD: Typ eines Massenchecksnvarchar100
TOPBI Content Analyzer
17RSBCTTOOLS_TMPTemporary table6CHECKTYPEChecks for Content Checkmannvarchar20
18RSCONTCHECKCROSSStatus Tables of Cross System Checks for Content Objects5CHECKTYPEChecks for Content Checkmannvarchar20
19RSCONTCHECKPROPBI Content Checks Properties1CHECKTYPEChecks for Content Checkmannvarchar20
20RSCONTENTCHECKStatus Tables of Consistence Checks for Content Objects6CHECKTYPEChecks for Content Checkmannvarchar20
21RSCONTENTCHECK_AArchiving Table for Object Status3CHECKTYPEChecks for Content Checkmannvarchar20
22RSCONTENTCHECK_CCustomizing for Contentchecks2CHECKTYPEChecks for Content Checkmannvarchar20
23RSCONTENTCHECK_MMessages from the Content Checkman6CHECKTYPEChecks for Content Checkmannvarchar20
TOPBudgeting
24BUCC_LIBConsistency Checks - Library4CHECKTYPEConsistency Checks - Check Typenvarchar10
25BUCC_LIB_TLibrary Texts for Consistency Checks4CHECKTYPEConsistency Checks - Check Typenvarchar10
26BUCC_RULEConsistency Checks - Rules4CHECKTYPEConsistency Checks - Check Typenvarchar10
27BUCC_RULE_MSGConsistency Checks - Message of the rule4CHECKTYPEConsistency Checks - Check Typenvarchar10
28BUCC_RULE_OPDConsistency Checks - Operands4CHECKTYPEConsistency Checks - Check Typenvarchar10
29BUCC_RULE_TRule Texts for Consistency Checks4CHECKTYPEConsistency Checks - Check Typenvarchar10
30FMCC_CUST_LIBFM - Consistency checks - Assignment of libraries6CHECKTYPEConsistency Checks - Check Typenvarchar10
TOPFinancial Accounting
31/OPT/VIM_T111Process Type Determination Step Details7CHECKTYPECheck Typenvarchar10
32/OPT/VIM_T119Document Type Determination Step Details6CHECKTYPEDoc. Type . Determination Check Typenvarchar10
TOPInformation Quality Management
33SIQMMESSAGESInformation Quality Messages5CHECKTYPECheck Technology (Information Quality)nvarchar200
34SIQMRESULTSInformation Quality Results (Main Table)5CHECKTYPECheck Technology (Information Quality)nvarchar200
TOPMicrosoft SQL Server
35DBSTATTMSSTable sizes7CHECKTYPEMS SQL Server type of check actionnvarchar10
TOPPerformance Monitors TCC
36DBCHKExceptions for data base checks1CHECKTYPETable/index check typetinyint30
TOPPurchasing
37WRFT_POHF_CHCKObsolete: Please do not use3CHECKTYPEObsolete: Please do not usenvarchar20
38WRFT_POHF_CHCK_TObsolete: Please do not use2CHECKTYPEObsolete: Please do not usenvarchar20
39WRFT_POHF_CHCK_VObsolete: Please do not use2CHECKTYPEObsolete: Please do not usenvarchar20