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

48 columns | Print definition?ERP 6.0  | KVSL1

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1J_1I_EXIM_ACCKEYEXIM: Account Key3KVSL1Account keynvarchar30
2KONVConditions (Transaction Data)29KVSL1Account keynvarchar30
3T687Account Determination: Account Key3KVSL1Account keynvarchar30
4T687TAccount Determination: Account Key Texts4KVSL1Account keynvarchar30
TOPAdvertising Management
5C290IS-M: PURORG/ACCKEY6KVSL1Account keynvarchar30
6C291IS-M: PCORG/ACTASSGRP/ACCTKEY7KVSL1Account keynvarchar30
7C300IS-M/AM: Cust Grp/Service Type/Account Key7KVSL1Account keynvarchar30
8C301IS-M: Service Type/Account Key6KVSL1Account keynvarchar30
9C302IS-PAM: VKORG/GRPDEB/KTOSCHL7KVSL1Account keynvarchar30
10C303IS-M: Account Key Only5KVSL1Account keynvarchar30
TOPConditions
11C001Cust.Grp/MaterialGrp/AcctKey8KVSL1Account keynvarchar30
12C002Cust.Grp/Account Key7KVSL1Account keynvarchar30
13C003Material Grp/Acct Key7KVSL1Account keynvarchar30
14C005Acct Key6KVSL1Account keynvarchar30
15C502Chart of Accounts/SlsOrg/DChannel/AcctGroup Cust/Account Key8KVSL1Account keynvarchar30
16KONDConditions (Data)57KVSL1Account keynvarchar30
17T683SPricing Procedure: Data16KVSL1Account keynvarchar30
TOPCross-Application Components
18VKONVConditions (Transaction Data)29KVSL1Account keynvarchar30
TOPExchanges
19OIANFFee Condition Records29KVSL1Account keynvarchar30
TOPIndustry Solution Engineering Construction
20C495Document Category/Condition Type/Own-External/Account Key8KVSL1Account keynvarchar30
21C496Condition Type/Account Key6KVSL1Account keynvarchar30
22C497Document Category/Condition Type/Account Key7KVSL1Account keynvarchar30
23C498Doc. Category/Condition Type/Own-Ext./Actvty Type/Acc. Key9KVSL1Account keynvarchar30
24C499Doc. Cat./Cond. Type/Own-Ext./Acty Type/Ctlg Group/Acc. Key11KVSL1Account keynvarchar30
TOPJoint Venture und Production Sharing Accounting
25JVKONVIS-Oil / Joint Venture / Data table for CRP pricing data29KVSL1Account keynvarchar30
TOPLocalization
26IDMX_DI_TAXESDigital Invoice Mexico: Legal Abbreviations of Taxes4KVSL1Account keynvarchar30
27IDMX_DI_TAXTYPTable is OBSOLETE (replaced by IDMX_DI_TAXES)3KVSL1Account keynvarchar30
TOPMarketing, Accounting and Pricing
28OIC_KONVConditions (Procedure Data)29KVSL1Account keynvarchar30
29OIC_OIANFFee Condition Records29KVSL1Account keynvarchar30
TOPPatient Accounting
30C400IS-H: Account key/case type/private/ext.physician5KVSL1Account keynvarchar30
31C401IS-H: Acct key/case type/srv.catalog/srv./private/ext.phys.5KVSL1Account keynvarchar30
32NVKONVIS-H: Conditions13KVSL1Account keynvarchar30
TOPPeriodical Sales and Distribution
33C450IS-M/SD: SOrg./Publ./Edit./CGrp./AKey/BFreq.9KVSL1Account keynvarchar30
34C451IS-M/SD: SOrg./Publ./CAccGrp./AccKey/BFreq.8KVSL1Account keynvarchar30
35C452IS-M/SD: SOrg./Publ./AKey/BFreq.7KVSL1Account keynvarchar30
36C453IS-M/SD: SOrg./AKey/BFreq.6KVSL1Account keynvarchar30
37C460IS-M/SD: POrg./Publ./Edit./SC/AKey9KVSL1Account keynvarchar30
38C461IS-M/SD: POrg./Publ./Edit./AKey8KVSL1Account keynvarchar30
39C462IS-M/SD: POrg./Publ./AKey7KVSL1Account keynvarchar30
40C463IS-M/SD: POrg./AKey6KVSL1Account keynvarchar30
41C465IS-M/SD: SC/Publ./Edit./EEAcGrp./AKey9KVSL1Account keynvarchar30
42C466IS-M/SD: SC/Publ./Edit./AKey8KVSL1Account keynvarchar30
43C467IS-M/SD: SC/Publ./AKey7KVSL1Account keynvarchar30
44C468IS-M/SD: SC/AKey6KVSL1Account keynvarchar30
45JKONVIS-M/SD: Conditions (Transaction Data)29KVSL1Account keynvarchar30
TOPPricing
46PRCC_COND_PPPricing Procedure Data (T683S)9KVSL1Account Keynvarchar30
47PRCD_CONDPrice Condition - Item - Condition (KONV)8KVSL1Account Keynvarchar30
TOPTariffs, Duties and Permits
48C410Chart of accts / Account key - acct assign for ED rev5KVSL1Account keynvarchar30