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  | SAKN2

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1KONVConditions (Transaction Data)33SAKN2Number of Provision Accountnvarchar100
TOPAdvertising Management
2C290IS-M: PURORG/ACCKEY8SAKN2G/L Account Numbernvarchar100
3C291IS-M: PCORG/ACTASSGRP/ACCTKEY9SAKN2G/L Account Numbernvarchar100
4C300IS-M/AM: Cust Grp/Service Type/Account Key9SAKN2G/L Account Numbernvarchar100
5C301IS-M: Service Type/Account Key8SAKN2G/L Account Numbernvarchar100
6C302IS-PAM: VKORG/GRPDEB/KTOSCHL9SAKN2Number of Provision Accountnvarchar100
7C303IS-M: Account Key Only7SAKN2Number of Provision Accountnvarchar100
TOPConditions
8C000Condition Table for Acct.Determination: $7SAKN2Number of Provision Accountnvarchar100
9C001Cust.Grp/MaterialGrp/AcctKey10SAKN2Number of Provision Accountnvarchar100
10C002Cust.Grp/Account Key9SAKN2Number of Provision Accountnvarchar100
11C003Material Grp/Acct Key9SAKN2Number of Provision Accountnvarchar100
12C004General7SAKN2Number of Provision Accountnvarchar100
13C005Acct Key8SAKN2Number of Provision Accountnvarchar100
14C006SlsOrg/Card cat.8SAKN2Number of Provision Accountnvarchar100
15C008SlsOrg/Dist.chan.8SAKN2Number of Provision Accountnvarchar100
16C009SlsOrg/Dist.chan./Div.9SAKN2Number of Provision Accountnvarchar100
17C502Chart of Accounts/SlsOrg/DChannel/AcctGroup Cust/Account Key10SAKN2G/L Account Numbernvarchar100
TOPContract Handling
18C402Item cat.7SAKN2Number of Provision Accountnvarchar100
TOPCross-Application Components
19VKONVConditions (Transaction Data)33SAKN2G/L Account Numbernvarchar100
TOPCustomizing Tools Techniques
20ZC015Convertion toolbox Correspondance of account number4SAKN2G/L Account Numbernvarchar100
TOPExchanges
21OIANFFee Condition Records33SAKN2G/L Account Numbernvarchar100
TOPFunds Management-Specific Postings
22PAYKOAdditional FM Data for Payment Request13SAKN2Target accountnvarchar100
TOPIndustry Solution Engineering Construction
23C495Document Category/Condition Type/Own-External/Account Key10SAKN2Number of Provision Accountnvarchar100
24C496Condition Type/Account Key8SAKN2Number of Provision Accountnvarchar100
25C497Document Category/Condition Type/Account Key9SAKN2Number of Provision Accountnvarchar100
26C498Doc. Category/Condition Type/Own-Ext./Actvty Type/Acc. Key11SAKN2Number of Provision Accountnvarchar100
27C499Doc. Cat./Cond. Type/Own-Ext./Acty Type/Ctlg Group/Acc. Key13SAKN2Number of Provision Accountnvarchar100
TOPIntegration
28FKK_KONV_SHORTPrice Conditions for SD Billing Document - Extracts26SAKN2G/L Account Numbernvarchar100
TOPInterest
29TZIN2Interest Document:Segment Int.Indicator & Valuation Category8SAKN2G/L Account Numbernvarchar100
TOPJoint Venture und Production Sharing Accounting
30JVKONVIS-Oil / Joint Venture / Data table for CRP pricing data33SAKN2G/L Account Numbernvarchar100
TOPMarketing, Accounting and Pricing
31OIC_KONVConditions (Procedure Data)33SAKN2G/L Account Numbernvarchar100
32OIC_OIANFFee Condition Records33SAKN2G/L Account Numbernvarchar100
TOPPatient Accounting
33C400IS-H: Account key/case type/private/ext.physician10SAKN2G/L Account Numbernvarchar100
34C401IS-H: Acct key/case type/srv.catalog/srv./private/ext.phys.13SAKN2G/L Account Numbernvarchar100
TOPPeriodical Sales and Distribution
35C450IS-M/SD: SOrg./Publ./Edit./CGrp./AKey/BFreq.12SAKN2G/L Account Numbernvarchar100
36C451IS-M/SD: SOrg./Publ./CAccGrp./AccKey/BFreq.11SAKN2G/L Account Numbernvarchar100
37C452IS-M/SD: SOrg./Publ./AKey/BFreq.10SAKN2G/L Account Numbernvarchar100
38C453IS-M/SD: SOrg./AKey/BFreq.9SAKN2G/L Account Numbernvarchar100
39C460IS-M/SD: POrg./Publ./Edit./SC/AKey11SAKN2G/L Account Numbernvarchar100
40C461IS-M/SD: POrg./Publ./Edit./AKey10SAKN2G/L Account Numbernvarchar100
41C462IS-M/SD: POrg./Publ./AKey9SAKN2G/L Account Numbernvarchar100
42C463IS-M/SD: POrg./AKey8SAKN2G/L Account Numbernvarchar100
43C464IS-M/SD: POrg.7SAKN2G/L Account Numbernvarchar100
44C465IS-M/SD: SC/Publ./Edit./EEAcGrp./AKey11SAKN2G/L Account Numbernvarchar100
45C466IS-M/SD: SC/Publ./Edit./AKey10SAKN2G/L Account Numbernvarchar100
46C467IS-M/SD: SC/Publ./AKey9SAKN2G/L Account Numbernvarchar100
47C468IS-M/SD: SC/AKey8SAKN2G/L Account Numbernvarchar100
48C469IS-M/SD: SC7SAKN2G/L Account Numbernvarchar100
49JFXTJL26DLIS-M: Backup Transfer Internal Table XTJL266SAKN2IS-M: Real G/L Accountnvarchar100
50JKONVIS-M/SD: Conditions (Transaction Data)33SAKN2G/L Account Numbernvarchar100
51TJF20Convert Bank Clearing Account to Interim Account (Bank Rtns)4SAKN2Interim Account for Bank Returnsnvarchar100
52TJF30IS-M/SD: Conversion of Clearing Acct to Real G/L Acct (Run)5SAKN2IS-M: Real G/L Accountnvarchar100
53TJL26IS-M/SD: Conversion of Clearing Account - Real G/L Account4SAKN2IS-M: Real G/L Accountnvarchar100
TOPPOS Interface
54C007Vendor7SAKN2Number of Provision Accountnvarchar100
TOPService Station Retailing
55C011Company Code/Payment card type/Splitting result9SAKN2G/L Account Numbernvarchar100
56C012Sales Org / Card type / split result9SAKN2G/L Account Numbernvarchar100
57C013Company Code / card type8SAKN2G/L Account Numbernvarchar100
58C014Card Type7SAKN2G/L Account Numbernvarchar100
TOPTariffs, Duties and Permits
59C410Chart of accts / Account key - acct assign for ED rev7SAKN2Number of Provision Accountnvarchar100