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

59 columns | Print definition?ERP 6.0  | SAKN1

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1KONVConditions (Transaction Data)30SAKN1G/L Account Numbernvarchar100
TOPAdvertising Management
2C290IS-M: PURORG/ACCKEY7SAKN1G/L Account Numbernvarchar100
3C291IS-M: PCORG/ACTASSGRP/ACCTKEY8SAKN1G/L Account Numbernvarchar100
4C300IS-M/AM: Cust Grp/Service Type/Account Key8SAKN1G/L Account Numbernvarchar100
5C301IS-M: Service Type/Account Key7SAKN1G/L Account Numbernvarchar100
6C302IS-PAM: VKORG/GRPDEB/KTOSCHL8SAKN1G/L Account Numbernvarchar100
7C303IS-M: Account Key Only6SAKN1G/L Account Numbernvarchar100
TOPConditions
8C000Condition Table for Acct.Determination: $6SAKN1G/L Account Numbernvarchar100
9C001Cust.Grp/MaterialGrp/AcctKey9SAKN1G/L Account Numbernvarchar100
10C002Cust.Grp/Account Key8SAKN1G/L Account Numbernvarchar100
11C003Material Grp/Acct Key8SAKN1G/L Account Numbernvarchar100
12C004General6SAKN1G/L Account Numbernvarchar100
13C005Acct Key7SAKN1G/L Account Numbernvarchar100
14C006SlsOrg/Card cat.7SAKN1G/L Account Numbernvarchar100
15C008SlsOrg/Dist.chan.7SAKN1G/L Account Numbernvarchar100
16C009SlsOrg/Dist.chan./Div.8SAKN1G/L Account Numbernvarchar100
17C502Chart of Accounts/SlsOrg/DChannel/AcctGroup Cust/Account Key9SAKN1G/L Account Numbernvarchar100
TOPContract Handling
18C402Item cat.6SAKN1G/L Account Numbernvarchar100
TOPCross-Application Components
19VKONVConditions (Transaction Data)30SAKN1G/L Account Numbernvarchar100
TOPData Collection
20S008Communications Table SD -> CO/Projects95SAKN1G/L Account Numbernvarchar100
TOPExchanges
21OIANFFee Condition Records30SAKN1G/L Account Numbernvarchar100
TOPIndustry Solution Engineering Construction
22C495Document Category/Condition Type/Own-External/Account Key9SAKN1G/L Account Numbernvarchar100
23C496Condition Type/Account Key7SAKN1G/L Account Numbernvarchar100
24C497Document Category/Condition Type/Account Key8SAKN1G/L Account Numbernvarchar100
25C498Doc. Category/Condition Type/Own-Ext./Actvty Type/Acc. Key10SAKN1G/L Account Numbernvarchar100
26C499Doc. Cat./Cond. Type/Own-Ext./Acty Type/Ctlg Group/Acc. Key12SAKN1G/L Account Numbernvarchar100
TOPIntegration
27FKK_KONV_SHORTPrice Conditions for SD Billing Document - Extracts24SAKN1G/L Account Numbernvarchar100
TOPInterest
28TZIN2Interest Document:Segment Int.Indicator & Valuation Category7SAKN1G/L Account Numbernvarchar100
TOPJoint Venture und Production Sharing Accounting
29JVKONVIS-Oil / Joint Venture / Data table for CRP pricing data30SAKN1G/L Account Numbernvarchar100
TOPMarketing, Accounting and Pricing
30OIC_KONVConditions (Procedure Data)30SAKN1G/L Account Numbernvarchar100
31OIC_OIANFFee Condition Records30SAKN1G/L Account Numbernvarchar100
TOPPatient Accounting
32C400IS-H: Account key/case type/private/ext.physician9SAKN1G/L Account Numbernvarchar100
33C401IS-H: Acct key/case type/srv.catalog/srv./private/ext.phys.12SAKN1G/L Account Numbernvarchar100
34NVKONVIS-H: Conditions14SAKN1G/L Account Numbernvarchar100
TOPPeriodical Sales and Distribution
35C450IS-M/SD: SOrg./Publ./Edit./CGrp./AKey/BFreq.11SAKN1G/L Account Numbernvarchar100
36C451IS-M/SD: SOrg./Publ./CAccGrp./AccKey/BFreq.10SAKN1G/L Account Numbernvarchar100
37C452IS-M/SD: SOrg./Publ./AKey/BFreq.9SAKN1G/L Account Numbernvarchar100
38C453IS-M/SD: SOrg./AKey/BFreq.8SAKN1G/L Account Numbernvarchar100
39C460IS-M/SD: POrg./Publ./Edit./SC/AKey10SAKN1G/L Account Numbernvarchar100
40C461IS-M/SD: POrg./Publ./Edit./AKey9SAKN1G/L Account Numbernvarchar100
41C462IS-M/SD: POrg./Publ./AKey8SAKN1G/L Account Numbernvarchar100
42C463IS-M/SD: POrg./AKey7SAKN1G/L Account Numbernvarchar100
43C464IS-M/SD: POrg.6SAKN1G/L Account Numbernvarchar100
44C465IS-M/SD: SC/Publ./Edit./EEAcGrp./AKey10SAKN1G/L Account Numbernvarchar100
45C466IS-M/SD: SC/Publ./Edit./AKey9SAKN1G/L Account Numbernvarchar100
46C467IS-M/SD: SC/Publ./AKey8SAKN1G/L Account Numbernvarchar100
47C468IS-M/SD: SC/AKey7SAKN1G/L Account Numbernvarchar100
48C469IS-M/SD: SC6SAKN1G/L Account Numbernvarchar100
49JFXTJL26DLIS-M: Backup Transfer Internal Table XTJL265SAKN1Interim Account for Revenue Accrualnvarchar100
50JKONVIS-M/SD: Conditions (Transaction Data)30SAKN1G/L Account Numbernvarchar100
51TJF20Convert Bank Clearing Account to Interim Account (Bank Rtns)3SAKN1Bank account/bank clearing account (G/L account)nvarchar100
52TJF30IS-M/SD: Conversion of Clearing Acct to Real G/L Acct (Run)4SAKN1Interim Account for Revenue Accrualnvarchar100
53TJL26IS-M/SD: Conversion of Clearing Account - Real G/L Account3SAKN1Interim Account for Revenue Accrualnvarchar100
TOPPOS Interface
54C007Vendor6SAKN1G/L Account Numbernvarchar100
TOPService Station Retailing
55C011Company Code/Payment card type/Splitting result8SAKN1G/L Account Numbernvarchar100
56C012Sales Org / Card type / split result8SAKN1G/L Account Numbernvarchar100
57C013Company Code / card type7SAKN1G/L Account Numbernvarchar100
58C014Card Type6SAKN1G/L Account Numbernvarchar100
TOPTariffs, Duties and Permits
59C410Chart of accts / Account key - acct assign for ED rev6SAKN1G/L Account Numbernvarchar100