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

138 columns | Print definition?ERP 6.0  | KPEIN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CN/CBPSAP001Vendor/product19KPEINCondition Pricing Unitdecimal50
2/1CN/CBPSAP016Contract Item18KPEINCondition Pricing Unitdecimal50
3/1CN/CBPSAP019Contract Header18KPEINCondition Pricing Unitdecimal50
4/1CN/CBPSAP068Location-Dependent19KPEINCondition Pricing Unitdecimal50
5/1CN/CBPSAP118Product18KPEINCondition Pricing Unitdecimal50
6/1CN/CPTSAP00001Business Partner/Product Group19KPEINCondition Pricing Unitdecimal50
7/1CN/CPTSAP00004Business Partner/Product GUID19KPEINCondition Pricing Unitdecimal50
8/1CN/CPTSAP00005Business Partner/Product Group/Product GUID20KPEINCondition Pricing Unitdecimal50
9/1CN/CPTSAP00006Business Partner18KPEINCondition Pricing Unitdecimal50
10/1CN/CTXSAPD0001Country/Cost Center/Product Usage20KPEINCondition Pricing Unitdecimal50
11/1CN/CTXSAPD0002Country/Order/Product Usage20KPEINCondition Pricing Unitdecimal50
12/1CN/CTXSAPD0003Country/Product Usage19KPEINCondition Pricing Unitdecimal50
13/1CN/CTXSAPD0004Country18KPEINCondition Pricing Unitdecimal50
14/1CN/CTXSAPD0201Country/Tax Code19KPEINCondition Pricing Unitdecimal50
15/1CN/CTXSAPR0100Country/Product Tax Group/Business Partner Tax Group20KPEINCondition Pricing Unitdecimal50
16/1CN/CTXSAPR0103Country/Product Tax Group19KPEINCondition Pricing Unitdecimal50
17/1CN/CTXSAPR0104Country18KPEINCondition Pricing Unitdecimal50
18/1CN/CTXSAPR0105Country/Tax Event19KPEINCondition Pricing Unitdecimal50
19/1CN/CTXSAPR0106Country/Region/Product Tax Group/Business Partner Tax Group21KPEINCondition Pricing Unitdecimal50
20/1CN/CTXSAPR0107Country/Tax Event/ST Jurisdiction Code20KPEINCondition Pricing Unitdecimal50
21/1CN/CTXSAPR0108Country/Region/Product Tax Group20KPEINCondition Pricing Unitdecimal50
22/1CN/CTXSAPR0110Country/1L Sppl.Jur.Code/1L Rec.Jur.Code20KPEINCondition Pricing Unitdecimal50
23/1CN/CTXSAPR0111Country/2L Sppl.Jur.Code/2L Rec.Jur.Code20KPEINCondition Pricing Unitdecimal50
24/1CN/CTXSAPR0112Country/2L Sppl.Jur.Code/2L Rec.Jur.Code/Tax Tariff Code21KPEINCondition Pricing Unitdecimal50
25/1CN/CTXSAPR0113Country/2L Sppl.Jur.Code/2L Rec.Jur.Code/Product Tax Group21KPEINCondition Pricing Unitdecimal50
26/1CN/CTXSAPR0120Country/Tax Tariff Code19KPEINCondition Pricing Unitdecimal50
27/1CN/CTXSAPR0130Country/3L Jur.Code19KPEINCondition Pricing Unitdecimal50
28/1CN/CTXSAPR0131Country/3L Jur.Code/Product Tax Group20KPEINCondition Pricing Unitdecimal50
29/1CN/CTXSAPR0140Country/Tax Event/Jurisdiction Code20KPEINCondition Pricing Unitdecimal50
30/1CN/CTXSAPR0201Country/Tax Code19KPEINCondition Pricing Unitdecimal50
31/1CN/CTXSAPRBR01Country/Tax Tariff Code19KPEINCondition Pricing Unitdecimal50
32/1CN/CTXSAPRBR02Country/Product Tax Group19KPEINCondition Pricing Unitdecimal50
33/1CN/CTXSAPRBR03Country/Product Tax Group/Business Partner Tax Group20KPEINCondition Pricing Unitdecimal50
34/1CN/CTXSAPRBR10Country/1L Sppl.Jur.Code/1L Rec.Jur.Code20KPEINCondition Pricing Unitdecimal50
35/1CN/CTXSAPRBR11Country/1L Sppl.Jur.Code/1L Rec.Jur.Code/Tax Tariff Code21KPEINCondition Pricing Unitdecimal50
36/1CN/CTXSAPRBR12Country/1L Sppl.Jur.Code/1L Rec.Jur.Code/Product Tax Group21KPEINCondition Pricing Unitdecimal50
37/1CN/CTXSAPRBR20Country/2L Jur.Code19KPEINCondition Pricing Unitdecimal50
38/1CN/CTXSAPRBR21Country/2L Jur.Code/Product Tax Group20KPEINCondition Pricing Unitdecimal50
39/1CN/CTXSAPRIN03Country/Tax Tariff Code/Business Partner ID20KPEINCondition Pricing Unitdecimal50
40/1CN/CTXSAPRIN04Recipient Country/Tax Tariff Code/Business Partner ID20KPEINCondition Pricing Unitdecimal50
41/1CN/CTXSAPRIN06Country/Spl Reg./Rec Region/Tax Group/Tax Group22KPEINCondition Pricing Unitdecimal50
42/1CN/CTXSAPRIN07Country/Partner ID/Recip. Tax Region/Tax Group21KPEINCondition Pricing Unitdecimal50
43/1CN/CTXSAPS0100Country/Business Process19KPEINCondition Pricing Unitdecimal50
44/1CN/CTXSAPS0101Country/Bus. Transaction19KPEINCondition Pricing Unitdecimal50
45/1CN/CTXSAPS0102Country/Bus. Transaction19KPEINCondition Pricing Unitdecimal50
46/1CN/CTXSAPW0201Country/Tax Code19KPEINCondition Pricing Unitdecimal50
47/1CN/CTXSAPW0202Country/Business Partner Tax Group19KPEINCondition Pricing Unitdecimal50
48/1CN/CTXSAPX0100Country/Region19KPEINCondition Pricing Unitdecimal50
49/1CN/CTXSAPX0101Country/Supplier BP ID/Business Partner ID20KPEINCondition Pricing Unitdecimal50
50/1CN/CTXSAPX0102Country/Business Partner Tax Group19KPEINCondition Pricing Unitdecimal50
51/1CN/CTXSAPX0103Country/Supplier BP ID/Business Partner ID/Product Tax Group21KPEINCondition Pricing Unitdecimal50
52/1CN/CTXSAPX0104Recipient Country/Recipient Tax Region/Locat. Relationship20KPEINCondition Pricing Unitdecimal50
53/1CN/CTXSAPX0105Country/Product Tax Group19KPEINCondition Pricing Unitdecimal50
54/1CN/CTXSAPX0106Country/Region/Product Tax Group20KPEINCondition Pricing Unitdecimal50
55/1CN/CTXSAPX0140Country/Product Tax Group/Jurisdiction Code20KPEINCondition Pricing Unitdecimal50
56/1CN/CTXSAPX0141Country/Business Partner Tax Group/Jurisdiction Code20KPEINCondition Pricing Unitdecimal50
57/1CN/CTXSAPX0146Country/Region/Product Tax Group20KPEINCondition Pricing Unitdecimal50
58/1CN/CTXSAPX0147Country/Region/Business Partner Tax Group20KPEINCondition Pricing Unitdecimal50
59/1CN/CTXSAPX0148Country18KPEINCondition Pricing Unitdecimal50
60/1CN/CTXSAPXBR01Country/Tax Tariff Code19KPEINCondition Pricing Unitdecimal50
61/1CN/CTXSAPXBR02Country/Product Tax Group19KPEINCondition Pricing Unitdecimal50
62/1CN/CTXSAPXBR03Country/Product Tax Group/Business Partner Tax Group20KPEINCondition Pricing Unitdecimal50
63/1CN/CTXSAPXBR11Country/1L Sppl.Jur.Code/1L Rec.Jur.Code/Tax Tariff Code21KPEINCondition Pricing Unitdecimal50
64/1CN/LBPSCALEEVLScale Table - Fixed Data Part of a Scale4KPEINCondition Pricing Unitdecimal50
65/1CN/LPTSCALEEVLScale Table - Fixed Data Part of a Scale4KPEINCondition Pricing Unitdecimal50
66/1CN/LTXSCALEEVLScale Table - Fixed Data Part of a Scale4KPEINCondition Pricing Unitdecimal50
67/BIC/B0000178000PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item54KPEINdecimal50
68/BIC/B0000179000PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule61KPEINdecimal50
69KONVConditions (Transaction Data)14KPEINCondition pricing unitdecimal50
70ZCM_FIX_ALLOC_DBFixation Allocation Table14KPEINCondition pricing unitdecimal50
71ZEIM_LIPSSD document: Delivery: Item data166KPEINCondition pricing unitdecimal50
72ZEIM_VBAPSales Document: Item Data94KPEINCondition pricing unitdecimal50
TOPConditions
73KONDConditions (Data)22KPEINCondition pricing unitdecimal50
74KONDNConditions: Free goods - Data section34KPEINCondition pricing unitdecimal50
75KONPConditions (Item)16KPEINCondition pricing unitdecimal50
76T685ZCondition Types: Lower/Higher Limits for Pricing Elements8KPEINCondition pricing unitdecimal50
TOPCost Center Accounting
77TKRSTRTransport Resource Prices20KPEINCondition pricing unitdecimal50
TOPCross-Application Components
78VKONVConditions (Transaction Data)14KPEINCondition pricing unitdecimal50
79VVBAPSales Document: Item Data94KPEINCondition pricing unitdecimal50
TOPExchanges
80OIA12ICONDConditions of OIA12I items10KPEINCondition pricing unitdecimal50
81OIANFFee Condition Records14KPEINCondition pricing unitdecimal50
TOPFreight Processing
82VFKGRP(Freight) Group Conditions15KPEINCondition pricing unitdecimal50
83VFKONV(Freight) Conditions20KPEINCondition pricing unitdecimal50
84VFSCAHScale Header6KPEINCondition pricing unitdecimal50
85VFSIShipment Costs: Sub-item Data19KPEINCondition pricing unitdecimal50
TOPGlobal Trade
86WB2_D_PRASPTrading Contract: pricing aspects14KPEINCondition pricing unitdecimal50
TOPGlobal Trade Services
87/SAPSLL/PREVDWLOSLL: Preference: Vend.Decl. f. Cust. Purp. - Worklist9KPEINPrice Unitdecimal50
TOPIntegration
88FKK_KONV_SHORTPrice Conditions for SD Billing Document - Extracts18KPEINCondition pricing unitdecimal50
TOPInvoice Verification
89RBDIFFKOInvoice Verification - Conditions17KPEINCondition pricing unitdecimal50
TOPJoint Venture und Production Sharing Accounting
90JVKONVIS-Oil / Joint Venture / Data table for CRP pricing data14KPEINCondition pricing unitdecimal50
TOPLocalization
91J_1BFIFOINIncoming FIFO relevant Consignment movements (BRAZIL)21KPEINCondition pricing unitdecimal50
92J_1BFIFOOUTOutgoing FIFO relevant Consignment movements (BRAZIL)20KPEINCondition pricing unitdecimal50
93J_1IADDEXCAdditional Excise rate table9KPEINCondition pricing unitdecimal50
94J_1IEXCTAXTax calc. - Excise tax rates9KPEINCondition pricing unitdecimal50
95J_1IMATEXPExceptional materials excise rates12KPEINCondition pricing unitdecimal50
TOPLogistics Execution
96/DSD/PE_CNDRDIPricing: Retrieved Condition Records - Item Info.7KPEINCondition pricing unitdecimal50
TOPMarketing, Accounting and Pricing
97OIC_KONVConditions (Procedure Data)14KPEINCondition pricing unitdecimal50
98OIC_OIANFFee Condition Records14KPEINCondition pricing unitdecimal50
TOPOverhead Cost Controlling
99KONRResource Prices: Help Table for Variable Fields28KPEINCondition pricing unitdecimal50
100KONR1Resource Prices: Help Table for Variable Fields28KPEINCondition pricing unitdecimal50
TOPOverhead Cost Orders
101KONXOverhead Rates: Help Table for Variable Fields25KPEINCondition pricing unitdecimal50
102KONX1Overhead Rates: Help Table for Variable Fields25KPEINCondition pricing unitdecimal50
103TKZUTRTransport Overhead Records20KPEINCondition pricing unitdecimal50
TOPPeriodical Sales and Distribution
104JKEPSales Order: Schedule Line Data28KPEINCondition pricing unitdecimal50
105JKONVIS-M/SD: Conditions (Transaction Data)14KPEINCondition pricing unitdecimal50
106JLTPST2IS-M/SD: Main Data for Batch Input Postal Charges9KPEINR/2 tablenvarchar50
TOPPricing
107PRCC_COND_LIMITSCondition Types: Lower/Higher Limits for Pricing Elements8KPEINCondition Pricing Unitdecimal50
108PRCD_CONDPrice Condition - Item - Condition (KONV)50KPEINCondition Pricing Unitdecimal50
109PRCM_TABL_000Reference Table for Condition Tables (A000)18KPEINCondition Pricing Unitdecimal50
TOPRecycling Administration Core Functions
110J_7LM04REA Article Master: Packaging Assignments13KPEINNumber of Sales Units in Packaging Bill of Materialdecimal50
111J_7LP02REA Price List: Items14KPEINCondition Pricing Unitdecimal90
112J_7LP03REA Price List: Conditions13KPEINCondition pricing unitdecimal50
113J_7LV1PREA Document: Item Data41KPEINCondition Pricing Unitdecimal90
TOPRemaining Beverage - Obsolete Objects
114/BEV1/BO_DATAProof Table for Rebate Processing29KPEINCondition pricing unitdecimal50
115/BEV1/RBKPCopy Table for KONP for Accrual (Field KBRUE)16KPEINCondition pricing unitdecimal50
116/BEV1/RBVBAPSales Document: Item Data94KPEINCondition pricing unitdecimal50
117/BEV1/RBWEItemized Proof Rebate Settlement21KPEINCondition pricing unitdecimal50
TOPSales
118VBAPSales Document: Item Data94KPEINCondition pricing unitdecimal50
TOPService Station Retailing
119OIRADBTDocument base table26KPEINCondition pricing unitdecimal50
120OIRCCOMPDSSR Pricing - Competitor price differences6KPEINCondition pricing unitdecimal50
121OIRCCOMPDMSSR Pricing - Competitor price differences/Material7KPEINCondition pricing unitdecimal50
122OIRCLPCDSSR Pricing - Location price cluster differences6KPEINCondition pricing unitdecimal50
123OIRCLPCDMSSR Pricing - Location price cluster differences/Material7KPEINCondition pricing unitdecimal50
124OIRCMDPGRSSR Pricing - Material differences rates6KPEINCondition pricing unitdecimal50
125OIRCSDPGRSSR Pricing - Service type differences rates6KPEINCondition pricing unitdecimal50
126OIRCT685SSR Pricing - Condition type definition6KPEINCondition pricing unitdecimal50
127OIRCT685_HSSR Pricing - Condition type definition7KPEINCondition pricing unitdecimal50
128OIRC_GMMHSSR Meters - History28KPEINCondition pricing unitdecimal50
129OIRC_GMMH_DELSSR Meters - Deleted meter readings history29KPEINCondition pricing unitdecimal50
130OIRC_MRREJSSR Meters - Meter readings rejected records31KPEINCondition pricing unitdecimal50
131OIRC_PRCHKSSR Pricing - Price check14KPEINSSR Pricing - Actual price pricing unitdecimal50
132OIRC_PRLOG_DIFSSR Pricing - Price update differences12KPEINCondition pricing unitdecimal50
133OIRC_PRLOG_PRLSSR Pricing - Old and new prices9KPEINCondition pricing unitdecimal50
134OIRC_PRLOG_PRMSSR Pricing - Price update parameter log13KPEINCondition pricing unitdecimal50
135OIREUPLPXXXXSSR PC: DTF table for item information15KPEINCondition pricing unitdecimal50
TOPShipping
136LIPSSD document: Delivery: Item data166KPEINCondition pricing unitdecimal50
TOPSimulation
137VSVBAP_CNVersion: Sales document: Item data95KPEINCondition pricing unitdecimal50
TOPSubsequent Settlement
138EBABPSettlement Runs Subsequent Settlement, Condition Record14KPEINCondition pricing unitdecimal50