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

62 columns | Print definition?ERP 6.0  | CHNAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNV_10940_FCONSTFinal consistency check status15CHNAMEUser Namenvarchar120
2DFKKBIXCIT_CHChange Sequence of Changed Consumption Items6CHNAMEUser Making Changenvarchar120
3DFKKINV_REVTReversal Task8CHNAMEUser Who Changed the Reversal Tasknvarchar120
4DFKK_MA_CHG_LOGLog Record of Change of Master Agreement6CHNAMEUser Making Changenvarchar120
5DMC_CU_RUN_OBJTSObject pair for Content Upgrade Analysis20CHNAMEUser Namenvarchar120
6FARR_D_RAI_CHChange Sequence of Changed Items11CHNAMEUser name of the person responsible in change documentnvarchar120
7LAW2D_ATTACHMENTLAW 2.0 Attachement table13CHNAMELAW 2.0 Changer User Namenvarchar300
8LAW2D_CONTLAW 2.0: User types included in another user type8CHNAMELAW 2.0 Changer User Namenvarchar300
9LAW2D_DATASETLAW 2.0 Dataset (Header of the LAW measurement)29CHNAMELAW 2.0 Changer User Namenvarchar300
10LAW2D_ENG_PRESEL7CHNAMEnvarchar300
11LAW2D_EXT_SYSTEMLAW 2.0 External System Data17CHNAMELAW 2.0 Changer User Namenvarchar300
12LAW2D_GROUP12CHNAMEnvarchar300
13LAW2D_GROUP_SYS7CHNAMEnvarchar300
14LAW2D_MEASPLANLAW 2.0 Measurement Plan16CHNAMELAW 2.0 Changer User Namenvarchar300
15LAW2D_SYSTEMLAW 2.0 system table29CHNAMELAW 2.0 Changer User Namenvarchar300
16TTS_AUDIT_FLGAudit Status Records (Work Tickets)4CHNAMEReviewernvarchar120
17TTS_OT_AUDIT_FLGAudit Status Records (Operation Tickets)4CHNAMEReviewernvarchar120
TOPAccounting - General
18FAGL_CLOCO_COMNTComments for Closing Cockpit10CHNAMEUser Namenvarchar120
TOPActive Quality Control
19TQG_EVAL_GR_TYPXGraphic Types: XML Layout3CHNAMEUser Namenvarchar120
TOPBilling in Contract Accounts Receivable and Payable
20DFKKBIBILLACC_FIBilling Account Facts Items8CHNAMEUser Making Changenvarchar120
21DFKKBIBILLACC_HBilling Account Header28CHNAMEUser Making Changenvarchar120
22DFKKBIEDRWOATPermanently Rejected EDRs (Payments, Receivables, Credit)25CHNAMEUser Making Changenvarchar120
23DFKKBIEDRWOTCPermanently Rejected EDRs18CHNAMEUser Making Changenvarchar120
24DFKKBIEDRWOZ01Test Data: Permanently Rejected EDRs fr. Category ZTCSERVICE22CHNAMEUser Making Changenvarchar120
25DFKKBIXBIT_CHChange Sequence of Changed Billable Items7CHNAMEUser Making Changenvarchar120
TOPDown Payment Chains
26/SAPPCE/TDPC19Down Payment Chain: Transactions9CHNAMEUser name of processer who made change to objectnvarchar120
27/SAPPCE/TDPC20Down Payment Chain: Document Header26CHNAMEUser name of processer who made change to objectnvarchar120
TOPFree Goods
28KONBBYHBonus Buys: Header6CHNAMEName of Person Who Changed Objectnvarchar120
29KONMATGRPMaterial Grouping: Header6CHNAMEName of Person Who Changed Objectnvarchar120
TOPSAP Internet Transaction Server
30IACFLFeature in ITS Plug-In3CHNAMELast processor of IAC objectnvarchar120
31IACFLOWINDX file for HTML templates (cross-language)7CHNAMELast processor of IAC objectnvarchar120
32IACHTMLObsolete:INDX File for HTML Templates (Language-Independent)11CHNAMELast processor of IAC objectnvarchar120
33IACHTMLLObsolete: INDX File for HTML Templates (Language-Dependent)12CHNAMELast processor of IAC objectnvarchar120
34IACHTRCObsolete: Language Resources for Internet Applications7CHNAMELast processor of IAC objectnvarchar120
35IACHTRCLObsolete: Language Resources for Internet Applications8CHNAMELast processor of IAC objectnvarchar120
36IACJSCRObsolete: INDX File for MIME Objects (Language-Independent)10CHNAMELast processor of IAC objectnvarchar120
37IACMIMEObsolete: INDX File for MIME Objects (Language-Independent)10CHNAMELast processor of IAC objectnvarchar120
38IACMIMELObsolete: INDX File for MIME Objects (Language-Dependent)11CHNAMELast processor of IAC objectnvarchar120
39IACMLParameters for MIME Objects (Language-Specific) File & Rel.6CHNAMELast processor of IAC objectnvarchar120
40IACMUParameters for MIME Objects (Non-Lang.-Specific) File & Rel.6CHNAMELast processor of IAC objectnvarchar120
41IACRLanguage Resources for Internet Applications (Service, Theme4CHNAMELast processor of IAC objectnvarchar120
42IACSInternet Application Components with ITS3CHNAMELast processor of IAC objectnvarchar120
43IACSERVICEObsolete: Internet Application Components with ITS6CHNAMELast processor of IAC objectnvarchar120
44IACTLParameters for HTML Templates (Non-Lang.-Spec.) Prog. Name7CHNAMELast processor of IAC objectnvarchar120
45IACTUParameters for HTML Templates (Non-Lang.-Spec.) Prog. Name7CHNAMELast processor of IAC objectnvarchar120
46IACXUXML Templates for HTML Templates7CHNAMELast processor of IAC objectnvarchar120
TOPService Data Download
47/SDF/CMO_IACJSCRCMO Service: INDX File for MIME Objects (Language-Indep10CHNAMELast processor of IAC objectnvarchar120
TOPWebRFC, Web Reporting
48WWWDATAINDX-type table for storing WWW objects6CHNAMEUser Namenvarchar120
TOPWork Clearance Management
49WCAAPWCM: Application33CHNAMELast Changed Bynvarchar120
50WCACGQWCM: Log (WCM Object <-> Catalog)17CHNAMELast Changed Bynvarchar120
51WCACIWCM: (Temporary) Log for Tagging/Untagging (Conflict Check)28CHNAMELast Changed Bynvarchar120
52WCACMWCM: Current Operational Condition/Type13CHNAMELast Changed Bynvarchar120
53WCACQWCM: Log for Tagging/Untagging (Conflict Check)29CHNAMELast Changed Bynvarchar120
54WCAGWCM: Data for Mode-Dependent Tagging12CHNAMELast Changed Bynvarchar120
55WCAHEWCM: Work Clearance Document (Header)33CHNAMELast Changed Bynvarchar120
56WCAJWCM: Lineup30CHNAMELast Changed Bynvarchar120
57WCAKWCM: Verification List (Header Data)12CHNAMELast Changed Bynvarchar120
58WCAMCWCM: Log of Operational Lists (Header Data)9CHNAMELast Changed Bynvarchar120
59WCAMEWCM: (Temporary) Log of Operational Lists (Items)52CHNAMELast Changed Bynvarchar120
60WCAMIWCM: Log of Operational Lists (Items)50CHNAMELast Changed Bynvarchar120
61WCARWCM: Operational Step12CHNAMELast Changed Bynvarchar120
62WCAWWCM: Work Approval31CHNAMELast Changed Bynvarchar120