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

43 columns | Print definition?ERP 6.0  | VALUE_OLD

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/CDATAFDatabase table for changed data (fields)8VALUE_OLDValuenvarchar2550
2CDPOSChange document items15VALUE_OLDOld contents of changed fieldnvarchar2540
3CNVCMIS_RENAMEConversion values for rules5VALUE_OLDOld Valuenvarchar500
4CNVMBTRENAMERenaming 1:15VALUE_OLDOld Valuenvarchar500
5CNVTDMSSCR_MATABScrambling Final Mapping Table6VALUE_OLDConversion: Old valuenvarchar500
6CNVTDMSSCR_MTABScrambling Final Mapping Table5VALUE_OLDConversion: Old valuenvarchar500
7CNV_20201_TRACKLog for number range objects: Old value - new value5VALUE_OLDnvarchar200
8CNV_20201_TRACKTLog for number range obj.: Old_value - New_value (test run)5VALUE_OLDnvarchar200
9CNV_20317_DATBIDetermination for date dependent tables5VALUE_OLD30 Charactersnvarchar300
10CNV_COA_OTHERSMapping for other objects 'Old/New'7VALUE_OLDObject value OLDnvarchar300
11FARR_D_RAI_CHChange Sequence of Changed Items15VALUE_OLDChange Value "Old"nvarchar2550
12GRACCHANGELOGData Change Log table12VALUE_OLDLong Descriptionnvarchar2550
13GRFNATSAudit Trail Framework Sub data repository10VALUE_OLDCharacter field, length 32nvarchar320
14GRFNCHGHISTRECChange History Records6VALUE_OLDChange History Old Valueimage21474836470
15PCDPOSChange document items15VALUE_OLDOld contents of changed fieldnvarchar2540
TOPAccounts Receivable Accounting Process Integration
16FDM_LDDBFSCM-DM: Log And Delay Database14VALUE_OLDFSCM-DM: Old Attribute Valuenvarchar40
TOPAgency Business Global Trade
17WBRCCFAgency Business: Complaints - Change Fields6VALUE_OLDAB-CWB: Valuenvarchar400
TOPAudit trail enhancements ILM
18AUT_D_ILM_CDPOSAudit Trail (ILM): Storage Change Document Items (ILM)16VALUE_OLDOld contents of changed fieldnvarchar2540
19AUT_D_ILM_CD_STRAudit Trail (ILM): Storage for Change Docs (STRING Values)12VALUE_OLDOld Change Document Value for STRING Variablentext10737418230
TOPBusiness Configuration Sets
20SCPRCCSVBC Set: Values5VALUE_OLDBC Sets; Values up to a length of 130nvarchar1300
21SCPRUSRVBC Set: Last variable entered per user (activ.)3VALUE_OLDBC Sets; Values up to a length of 130nvarchar1300
TOPChange Documents
22CDPOS_STRAdditional Change Document - Table for STRINGs11VALUE_OLDOld Change Document Value for STRING Variablentext10737418230
23PCDPOS_STRAdditional Planned Change Document: Table for STRINGs11VALUE_OLDOld Change Document Value for STRING Variablentext10737418230
TOPCollaboration Folders
24CFX_HISTORYCFX: Data for Object History14VALUE_OLDCharacter String for Collaboration Foldersntext10737418230
25CFX_HIST_USERGRPSaves the History Entries for the User Groups10VALUE_OLDCharacter String for Collaboration Foldersntext10737418230
TOPContract Accounts Receivable and Payable
26DFKKBICObsolete11VALUE_OLDOld Contents of Changed Fieldnvarchar800
27DFKKBICLFI-CA Batch Input - Error Change Logs11VALUE_OLDOld Contents of Changed Fieldnvarchar800
28DFKKCOLI_LOGCollection Agency Information File: Communication Log21VALUE_OLDOld contents of changed fieldnvarchar2540
29DFKKCOLLP_IM_WBuffer: Coll. Agency Info File (Item Master Data Change)16VALUE_OLDField Content before Changenvarchar1000
30DFKKCOLL_CHCollection: Changes to Business Partner Master Data11VALUE_OLDOld contents of changed fieldnvarchar2540
TOPFunctions for U.S. Federal Government
31FMFG_MM_PEND_CHGPurchasing document changes requiring Notification approvl11VALUE_OLDOld value for pending MM document changenvarchar1000
TOPGovernance, Risk and Compliance
32GRFNATFAudit Trail Framework data repository13VALUE_OLDntext10737418230
TOPGRC Process Control Plug-in
33/GRCPI/GRIADBLOGAM - Table of GRC log records for table changes9VALUE_OLDOld contents of changed fieldnvarchar2540
TOPMaintenance Orders
34/MRSS/D_CHG_HISTChange Documents (Field Changes)11VALUE_OLDField Valuenvarchar500
TOPPackage Tools
35PAKPARAM_LOGPackage Parameters Table7VALUE_OLDPackage parameter valuenvarchar800
TOPProcess Controls -Automated Controls
36GRPCRTA_DBTABLOGGRC Table of log records for table changes9VALUE_OLDOld contents of changed fieldnvarchar2540
37GRPCRTA_HRDAT2PC HR control data for infotype 0014 and 001525VALUE_OLDCommentnvarchar500
38GRPCRTA_TCHLOGChange log : Changed data8VALUE_OLDOld contents of changed fieldnvarchar2540
TOPProduct Safety
39EST_CHANGE_DOCSEHS: Change Documents in the EH&S System15VALUE_OLDField contents of changed fieldnvarchar2540
TOPProfitability Analysis
40TKENCFCO-PA: Characteristics of Realignments6VALUE_OLDCO-PA characteristic valuenvarchar500
TOPRegulatory reporting for insurance companies
41TISSR_GP_CHANGEISSR: Tabelle zur Aufnahme der Informationen zur GP-Änderung13VALUE_OLDAlter Feldinhalt des geänderten Feldsnvarchar2540
TOPSales
42/CBAD/CHG_EFF_ICBAD: Changes to the future in extended contracts - Item5VALUE_OLDOld contents of changed fieldnvarchar2540
TOPSAP Business Workflow
43SWECDVALUEField (Values) for Event Linkage12VALUE_OLDField contents of changed fieldnvarchar2540