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

42 columns | Print definition?ERP 6.0  | VALUE_NEW

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/CDATAFDatabase table for changed data (fields)7VALUE_NEWValuenvarchar2550
2CDPOSChange document items14VALUE_NEWNew contents of changed fieldnvarchar2540
3CNVCMIS_RENAMEConversion values for rules6VALUE_NEWNew Valuenvarchar500
4CNVMBTRENAMERenaming 1:16VALUE_NEWNew Valuenvarchar500
5CNVTDMSSCR_MATABScrambling Final Mapping Table7VALUE_NEWConversion: New valuenvarchar500
6CNVTDMSSCR_MTABScrambling Final Mapping Table6VALUE_NEWConversion: New valuenvarchar500
7CNV_20201_TRACKLog for number range objects: Old value - new value8VALUE_NEWnvarchar200
8CNV_20201_TRACKTLog for number range obj.: Old_value - New_value (test run)8VALUE_NEWnvarchar200
9CNV_20317_DATBIDetermination for date dependent tables9VALUE_NEW30 Charactersnvarchar300
10CNV_COA_OTHERSMapping for other objects 'Old/New'8VALUE_NEWObject value NEWnvarchar300
11DFKKBIXCIT_CHChange Sequence of Changed Consumption Items11VALUE_NEWNew Field Valuenvarchar2550
12FARR_D_RAI_CHChange Sequence of Changed Items16VALUE_NEWChange Value "New"nvarchar2550
13GRACCHANGELOGData Change Log table13VALUE_NEWLong Descriptionnvarchar2550
14GRFNATSAudit Trail Framework Sub data repository12VALUE_NEWCharacter field, length 32nvarchar320
15GRFNCHGHISTRECChange History Records7VALUE_NEWChange History New Valueimage21474836470
16PCDPOSChange document items14VALUE_NEWNew contents of changed fieldnvarchar2540
TOPAccounts Receivable Accounting Process Integration
17FDM_LDDBFSCM-DM: Log And Delay Database13VALUE_NEWFSCM-DM: Dispute Case Attribute Valuenvarchar40
TOPAudit trail enhancements ILM
18AUT_D_ILM_CDPOSAudit Trail (ILM): Storage Change Document Items (ILM)15VALUE_NEWNew contents of changed fieldnvarchar2540
19AUT_D_ILM_CD_STRAudit Trail (ILM): Storage for Change Docs (STRING Values)13VALUE_NEWNew Change Document Value for STRING Variablentext10737418230
TOPBilling in Contract Accounts Receivable and Payable
20DFKKBIXBIT_CHChange Sequence of Changed Billable Items12VALUE_NEWNew Field Valuenvarchar2550
TOPBusiness Configuration Sets
21SCPRCCSVBC Set: Values7VALUE_NEWBC Sets; Values up to a length of 130nvarchar1300
22SCPRUSRVBC Set: Last variable entered per user (activ.)4VALUE_NEWBC Sets; Values up to a length of 130nvarchar1300
TOPChange Documents
23CDPOS_STRAdditional Change Document - Table for STRINGs12VALUE_NEWNew Change Document Value for STRING Variablentext10737418230
24PCDPOS_STRAdditional Planned Change Document: Table for STRINGs12VALUE_NEWNew Change Document Value for STRING Variablentext10737418230
TOPContract Accounts Receivable and Payable
25DFKKBICObsolete10VALUE_NEWNew Contents of Changed Fieldnvarchar800
26DFKKBICLFI-CA Batch Input - Error Change Logs10VALUE_NEWNew Contents of Changed Fieldnvarchar800
27DFKKCOLI_LOGCollection Agency Information File: Communication Log20VALUE_NEWNew contents of changed fieldnvarchar2540
28DFKKCOLLP_IM_WBuffer: Coll. Agency Info File (Item Master Data Change)15VALUE_NEWField Content after Changenvarchar1000
29DFKKCOLL_CHCollection: Changes to Business Partner Master Data10VALUE_NEWNew contents of changed fieldnvarchar2540
TOPFunctions for U.S. Federal Government
30FMFG_MM_PEND_CHGPurchasing document changes requiring Notification approvl10VALUE_NEWNew value for pending MM document changenvarchar1000
TOPGovernance, Risk and Compliance
31GRFNATFAudit Trail Framework data repository14VALUE_NEWntext10737418230
TOPGRC Process Control Plug-in
32/GRCPI/GRIADBLOGAM - Table of GRC log records for table changes10VALUE_NEWNew contents of changed fieldnvarchar2540
TOPMaintenance Orders
33/MRSS/D_CHG_HISTChange Documents (Field Changes)12VALUE_NEWField Valuenvarchar500
TOPPackage Tools
34PAKPARAM_LOGPackage Parameters Table6VALUE_NEWPackage parameter valuenvarchar800
TOPProcess Controls -Automated Controls
35GRPCRTA_DBTABLOGGRC Table of log records for table changes10VALUE_NEWNew contents of changed fieldnvarchar2540
36GRPCRTA_HRDAT2PC HR control data for infotype 0014 and 001526VALUE_NEWCommentnvarchar500
37GRPCRTA_TCHLOGChange log : Changed data9VALUE_NEWNew contents of changed fieldnvarchar2540
TOPProduct Safety
38EST_CHANGE_DOCSEHS: Change Documents in the EH&S System16VALUE_NEWField contents of changed fieldnvarchar2540
TOPProfitability Analysis
39TKENCFCO-PA: Characteristics of Realignments7VALUE_NEWCO-PA characteristic valuenvarchar500
TOPRegulatory reporting for insurance companies
40TISSR_GP_CHANGEISSR: Tabelle zur Aufnahme der Informationen zur GP-Änderung12VALUE_NEWNeuer Feldinhalt des geänderten Feldsnvarchar2540
TOPSales
41/CBAD/CHG_EFF_ICBAD: Changes to the future in extended contracts - Item6VALUE_NEWNew contents of changed fieldnvarchar2540
TOPSAP Business Workflow
42SWECDVALUEField (Values) for Event Linkage11VALUE_NEWField contents of source/changed fieldnvarchar2540