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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

91 columns | Print definition?ERP 6.0  | CRNAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DFKKBIX_RERATEReversal Request for Billable Items12CRNAMEUser Who Created Rerating Request for Billable Itemsnvarchar120
2DFKKINVBILL_REVReversal Request for Billing Document14CRNAMEUser Who Created the Reversal Requestnvarchar120
3DFKKINVDOC_REVReversal Request for Invoicing Document22CRNAMEUser Who Created the Reversal Requestnvarchar120
4DFKKINV_REVTReversal Task5CRNAMEUser Who Created the Reversal Tasknvarchar120
5DFKK_VT_CYCREQPeriodic Rating Request18CRNAMEUser Who Created the Rating Requestnvarchar120
6LAW2D_ATTACHMENTLAW 2.0 Attachement table10CRNAMELAW 2.0 Create User Namenvarchar300
7LAW2D_CONTLAW 2.0: User types included in another user type5CRNAMELAW 2.0 Create User Namenvarchar300
8LAW2D_DATASETLAW 2.0 Dataset (Header of the LAW measurement)26CRNAMELAW 2.0 Create User Namenvarchar300
9LAW2D_ENG_PRESEL4CRNAMEnvarchar300
10LAW2D_EXT_SYSTEMLAW 2.0 External System Data14CRNAMELAW 2.0 Create User Namenvarchar300
11LAW2D_GROUP9CRNAMEnvarchar300
12LAW2D_GROUP_SYS4CRNAMEnvarchar300
13LAW2D_MEASPLANLAW 2.0 Measurement Plan13CRNAMELAW 2.0 Create User Namenvarchar300
14LAW2D_SYSTEMLAW 2.0 system table26CRNAMELAW 2.0 Create User Namenvarchar300
15TTS_SFTSAVECrew Member Information7CRNAMECreated bynvarchar120
TOPAccounting - General
16FAGL_CLOCO_COMNTComments for Closing Cockpit9CRNAMEUser Namenvarchar120
TOPBilling in Contract Accounts Receivable and Payable
17DFKKBIBILLACC_FIBilling Account Facts Items6CRNAMECreated Bynvarchar120
18DFKKBIBILLACC_HBilling Account Header26CRNAMECreated Bynvarchar120
19DFKKBIEDRWOATPermanently Rejected EDRs (Payments, Receivables, Credit)23CRNAMECreated Bynvarchar120
20DFKKBIEDRWOTCPermanently Rejected EDRs16CRNAMECreated Bynvarchar120
21DFKKBIEDRWOZ01Test Data: Permanently Rejected EDRs fr. Category ZTCSERVICE20CRNAMECreated Bynvarchar120
22DFKKBIXBIT_REVReversal Request for Billable Items18CRNAMEReversal Request for Billable Items Created Bynvarchar120
TOPBusiness Package for Manager Self-Service FI
23FPB_EXP_COMMENTExpress Planning: Comments9CRNAMEUser Namenvarchar120
TOPCollectionsDisbursements
24ITAGCYACCDOCAgency Collections: Posted Document from Acct Maint.12CRNAMEName of Person who Created the Objectnvarchar120
25ITAGCYAGENCYFIAgency Collections: Data for Transfer to Agency FI17CRNAMEName of Person who Created the Objectnvarchar120
26ITAGCYCDMMaster Data for Cash Desks8CRNAMEName of Person who Created the Objectnvarchar120
27ITAGCYCOMMCTRLHAgency Collections: Commission Monitoring: History5CRNAMEName of Person who Created the Objectnvarchar120
28ITAGCYCONTCLOSEData for Closed Containers8CRNAMEName of Person who Created the Objectnvarchar120
29ITAGCYCONTHHeader Data for Cash Desk Container40CRNAMEName of Person who Created the Objectnvarchar120
30ITAGCYCONTPItems for a Container17CRNAMEName of Person who Created the Objectnvarchar120
31ITAGCYPAYPayment Information23CRNAMEName of Person who Created the Objectnvarchar120
32ITAGCYWDTable for Withdrawal Information17CRNAMEName of Person who Created the Objectnvarchar120
TOPContract Accounts Receivable and Payable
33DFKKINFCOInformation Container14CRNAMEClerk that Created the Information Containernvarchar120
34DFKKINFCOTInformation Container: Entries from Test14CRNAMEName of Person who Created the Objectnvarchar120
TOPControlling
35SE16N_EDITSE16N: Activation/Deactivation of Editing Functions4CRNAMEEntered bynvarchar120
TOPDown Payment Chains
36/SAPPCE/TDPC19Down Payment Chain: Transactions7CRNAMEUser name of administrator who entered objectnvarchar120
37/SAPPCE/TDPC20Down Payment Chain: Document Header24CRNAMEUser name of administrator who entered objectnvarchar120
TOPEnvironment, Health and Safety
38/TDAG/CPT_TASKDCP: Dokumente zu Aufgabenpositionen7CRNAMECreated Bynvarchar120
39/TDAG/CPT_TASKDACP: Dokumente zu Aufgabenpositionen / Archiv7CRNAMECreated Bynvarchar120
40/TDAG/CPT_TASKHHeader data for tasks24CRNAMECreated Bynvarchar120
41/TDAG/CPT_TASKHACP: Kopfdaten für Aufgaben / Archiv24CRNAMECreated Bynvarchar120
42/TDAG/CPT_TASKICP: Positionsdaten für Aufgaben11CRNAMECreated Bynvarchar120
43/TDAG/CPT_TASKIACP: Positionsdaten für Aufgaben / Archiv11CRNAMECreated Bynvarchar120
44/TDAG/CPT_TRCKHObsolete - CP: Tracker - Kopfdaten21CRNAMECreated Bynvarchar120
45/TDAG/CPT_TRCKHAObsolete - CP: Tracker - Kopfdaten / Archiv21CRNAMECreated Bynvarchar120
46/TDAG/CPT_TRCKIObsolete - CP: Tracker - Positionsdaten11CRNAMECreated Bynvarchar120
47/TDAG/CPT_TRCKIAObsolete - CP: Tracker - Positionsdaten / Archiv11CRNAMECreated Bynvarchar120
TOPFree Goods
48KONBBYHBonus Buys: Header4CRNAMEName of Person who Created the Objectnvarchar120
49KONMATGRPMaterial Grouping: Header4CRNAMEName of Person who Created the Objectnvarchar120
TOPInvoicing
50EITRTemporary Selection Data for IS-U Invoicing21CRNAMEUser Who Created the Invoicing Ordernvarchar120
TOPInvoicing in Contract Accounts Receivable and Payable
51DFKKINVBILL_HBilling Document Header39CRNAMECreated Bynvarchar120
52DFKKINVDOC_HInvoicing Document Header14CRNAMECreated Bynvarchar120
53DFKKINV_CFCClarification Case Invoicing30CRNAMECreated Bynvarchar120
54DFKKINV_CYCREQDummy Document for Invoicing for Periodic Invoicing15CRNAMEUser Who Created the Periodic Invoicing Ordernvarchar120
55DFKKINV_TRIGInvoicing Order34CRNAMEUser Who Created the Invoicing Ordernvarchar120
TOPOnline Text Repository
56OTR_COMMOTR: Comment for Concept9CRNAMEUser Namenvarchar120
TOPProduction Backflush
57PPC_STEP2Goods Movements Table for New PPCGO Logic (2 Steps)19CRNAMEBackflush Created bynvarchar120
TOPSets
58T802GSets: Variables7CRNAMECreated Bynvarchar120
TOPWork Clearance Management
59WCA2WCM: Work and Requirements59CRNAMECreated bynvarchar120
60WCAAPWCM: Application30CRNAMECreated bynvarchar120
61WCABWCM: Valuation6CRNAMECreated bynvarchar120
62WCABQWCM: Log (Valuation)8CRNAMECreated bynvarchar120
63WCACGWCM: WCM Object <-> Catalog13CRNAMECreated bynvarchar120
64WCACGQWCM: Log (WCM Object <-> Catalog)14CRNAMECreated bynvarchar120
65WCACHWCM: (Temporary) Log for Tagging/Untagging (Time-Frame)11CRNAMECreated bynvarchar120
66WCACIWCM: (Temporary) Log for Tagging/Untagging (Conflict Check)25CRNAMECreated bynvarchar120
67WCACMWCM: Current Operational Condition/Type10CRNAMECreated bynvarchar120
68WCACNWCM: (Temporary) Log (Tag/Test Tag)18CRNAMECreated bynvarchar120
69WCACNQWCM: Log (Operational Tag)19CRNAMECreated bynvarchar120
70WCACOWCM: (Temporary) Log for Tagging/Untagging (Ref. Object)6CRNAMECreated bynvarchar120
71WCACQWCM: Log for Tagging/Untagging (Conflict Check)26CRNAMECreated bynvarchar120
72WCACSWCM: (Temporary) Log (Protected Area)8CRNAMECreated bynvarchar120
73WCADWCM: Approval Group10CRNAMECreated bynvarchar120
74WCADQWCM: Log (Approval Group)12CRNAMECreated bynvarchar120
75WCAEWCM: Order Operation <-> Approval Group5CRNAMECreated bynvarchar120
76WCAEQWCM: Log (Order Operation <-> Approval Group)7CRNAMECreated bynvarchar120
77WCAFWCM: Order Operation <-> Work Clearance Document7CRNAMECreated bynvarchar120
78WCAFQWCM: Log (Order Operation <-> Work Clearance Document)9CRNAMECreated bynvarchar120
79WCAGWCM: Data for Mode-Dependent Tagging9CRNAMECreated bynvarchar120
80WCAHEWCM: Work Clearance Document (Header)30CRNAMECreated bynvarchar120
81WCAJWCM: Lineup27CRNAMECreated bynvarchar120
82WCAKWCM: Verification List (Header Data)9CRNAMECreated bynvarchar120
83WCALQWCM: Log (WCM Object <-> WCM Object)12CRNAMECreated bynvarchar120
84WCAMCWCM: Log of Operational Lists (Header Data)6CRNAMECreated bynvarchar120
85WCARWCM: Operational Step9CRNAMECreated bynvarchar120
86WCASWCM: Application <-> Order Operation5CRNAMECreated bynvarchar120
87WCASQWCM: Log (Application <-> Order Operation)7CRNAMECreated bynvarchar120
88WCATWCM: Templates6CRNAMECreated bynvarchar120
89WCAWWCM: Work Approval28CRNAMECreated bynvarchar120
90WCCEWCM: Conflict Rules9CRNAMECreated bynvarchar120
91WCCPVWCM: Approval Groups9CRNAMECreated bynvarchar120