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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

78 columns | Print definition?ERP 6.0  | KUMZA

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CN/SBPSAP001Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
2/1CN/SBPSAP016Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
3/1CN/SBPSAP019Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
4/1CN/SBPSAP068Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
5/1CN/SBPSAP118Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
6/1CN/SPTSAP00001Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
7/1CN/SPTSAP00004Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
8/1CN/SPTSAP00005Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
9/1CN/SPTSAP00006Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
10/1CN/STXSAPD0001Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
11/1CN/STXSAPD0002Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
12/1CN/STXSAPD0003Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
13/1CN/STXSAPD0004Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
14/1CN/STXSAPD0201Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
15/1CN/STXSAPR0100Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
16/1CN/STXSAPR0103Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
17/1CN/STXSAPR0104Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
18/1CN/STXSAPR0105Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
19/1CN/STXSAPR0106Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
20/1CN/STXSAPR0107Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
21/1CN/STXSAPR0108Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
22/1CN/STXSAPR0110Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
23/1CN/STXSAPR0111Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
24/1CN/STXSAPR0112Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
25/1CN/STXSAPR0113Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
26/1CN/STXSAPR0120Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
27/1CN/STXSAPR0130Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
28/1CN/STXSAPR0131Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
29/1CN/STXSAPR0140Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
30/1CN/STXSAPR0201Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
31/1CN/STXSAPRBR01Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
32/1CN/STXSAPRBR02Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
33/1CN/STXSAPRBR03Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
34/1CN/STXSAPRBR10Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
35/1CN/STXSAPRBR11Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
36/1CN/STXSAPRBR12Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
37/1CN/STXSAPRBR20Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
38/1CN/STXSAPRBR21Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
39/1CN/STXSAPRIN03Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
40/1CN/STXSAPRIN04Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
41/1CN/STXSAPRIN06Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
42/1CN/STXSAPRIN07Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
43/1CN/STXSAPS0100Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
44/1CN/STXSAPS0101Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
45/1CN/STXSAPS0102Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
46/1CN/STXSAPW0201Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
47/1CN/STXSAPW0202Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
48/1CN/STXSAPX0100Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
49/1CN/STXSAPX0101Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
50/1CN/STXSAPX0102Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
51/1CN/STXSAPX0103Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
52/1CN/STXSAPX0104Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
53/1CN/STXSAPX0105Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
54/1CN/STXSAPX0106Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
55/1CN/STXSAPX0140Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
56/1CN/STXSAPX0141Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
57/1CN/STXSAPX0146Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
58/1CN/STXSAPX0147Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
59/1CN/STXSAPX0148Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
60/1CN/STXSAPXBR01Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
61/1CN/STXSAPXBR02Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
62/1CN/STXSAPXBR03Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
63/1CN/STXSAPXBR11Supplementary Table for a Condition Table5KUMZACounter for Conversion to Base Unit of Measureint100
64KONVConditions (Transaction Data)16KUMZANumerator for converting condition units to base unitsdecimal50
TOPConditions
65KONDConditions (Data)23KUMZANumerator for converting condition units to base unitsdecimal50
66KONPConditions (Item)19KUMZANumerator for converting condition units to base unitsdecimal50
TOPCost Center Accounting
67TKRSTRTransport Resource Prices22KUMZANumerator for converting condition units to base unitsdecimal50
TOPCross-Application Components
68VKONVConditions (Transaction Data)16KUMZANumerator for converting condition units to base unitsdecimal50
TOPExchanges
69OIANFFee Condition Records16KUMZANumerator for converting condition units to base unitsdecimal50
TOPJoint Venture und Production Sharing Accounting
70JVKONVIS-Oil / Joint Venture / Data table for CRP pricing data16KUMZANumerator for converting condition units to base unitsdecimal50
TOPMarketing, Accounting and Pricing
71OIC_KONVConditions (Procedure Data)16KUMZANumerator for converting condition units to base unitsdecimal50
72OIC_OIANFFee Condition Records16KUMZANumerator for converting condition units to base unitsdecimal50
TOPOverhead Cost Orders
73TKZUTRTransport Overhead Records22KUMZANumerator for converting condition units to base unitsdecimal50
TOPPeriodical Sales and Distribution
74JKONVIS-M/SD: Conditions (Transaction Data)16KUMZANumerator for converting condition units to base unitsdecimal50
TOPPricing
75PRCD_CONDPrice Condition - Item - Condition (KONV)52KUMZACounter for Conversion to Base Unit of Measureint100
76PRCM_SUPP_000Reference Table for Additional Information (KONP000)5KUMZACounter for Conversion to Base Unit of Measureint100
TOPRemaining Beverage - Obsolete Objects
77/BEV1/RBKPCopy Table for KONP for Accrual (Field KBRUE)19KUMZANumerator for converting condition units to base unitsdecimal50
78/BEV1/RBWEItemized Proof Rebate Settlement23KUMZANumerator for converting condition units to base unitsdecimal50