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

147 columns | Print definition?ERP 6.0  | KMEIN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CN/CBPSAP001Vendor/product20KMEINUnit of Measure for Product-Specific Quantitynvarchar30
2/1CN/CBPSAP016Contract Item19KMEINUnit of Measure for Product-Specific Quantitynvarchar30
3/1CN/CBPSAP019Contract Header19KMEINUnit of Measure for Product-Specific Quantitynvarchar30
4/1CN/CBPSAP068Location-Dependent20KMEINUnit of Measure for Product-Specific Quantitynvarchar30
5/1CN/CBPSAP118Product19KMEINUnit of Measure for Product-Specific Quantitynvarchar30
6/1CN/CPTSAP00001Business Partner/Product Group20KMEINUnit of Measure for Product-Specific Quantitynvarchar30
7/1CN/CPTSAP00004Business Partner/Product GUID20KMEINUnit of Measure for Product-Specific Quantitynvarchar30
8/1CN/CPTSAP00005Business Partner/Product Group/Product GUID21KMEINUnit of Measure for Product-Specific Quantitynvarchar30
9/1CN/CPTSAP00006Business Partner19KMEINUnit of Measure for Product-Specific Quantitynvarchar30
10/1CN/CTXSAPD0001Country/Cost Center/Product Usage21KMEINUnit of Measure for Product-Specific Quantitynvarchar30
11/1CN/CTXSAPD0002Country/Order/Product Usage21KMEINUnit of Measure for Product-Specific Quantitynvarchar30
12/1CN/CTXSAPD0003Country/Product Usage20KMEINUnit of Measure for Product-Specific Quantitynvarchar30
13/1CN/CTXSAPD0004Country19KMEINUnit of Measure for Product-Specific Quantitynvarchar30
14/1CN/CTXSAPD0201Country/Tax Code20KMEINUnit of Measure for Product-Specific Quantitynvarchar30
15/1CN/CTXSAPR0100Country/Product Tax Group/Business Partner Tax Group21KMEINUnit of Measure for Product-Specific Quantitynvarchar30
16/1CN/CTXSAPR0103Country/Product Tax Group20KMEINUnit of Measure for Product-Specific Quantitynvarchar30
17/1CN/CTXSAPR0104Country19KMEINUnit of Measure for Product-Specific Quantitynvarchar30
18/1CN/CTXSAPR0105Country/Tax Event20KMEINUnit of Measure for Product-Specific Quantitynvarchar30
19/1CN/CTXSAPR0106Country/Region/Product Tax Group/Business Partner Tax Group22KMEINUnit of Measure for Product-Specific Quantitynvarchar30
20/1CN/CTXSAPR0107Country/Tax Event/ST Jurisdiction Code21KMEINUnit of Measure for Product-Specific Quantitynvarchar30
21/1CN/CTXSAPR0108Country/Region/Product Tax Group21KMEINUnit of Measure for Product-Specific Quantitynvarchar30
22/1CN/CTXSAPR0110Country/1L Sppl.Jur.Code/1L Rec.Jur.Code21KMEINUnit of Measure for Product-Specific Quantitynvarchar30
23/1CN/CTXSAPR0111Country/2L Sppl.Jur.Code/2L Rec.Jur.Code21KMEINUnit of Measure for Product-Specific Quantitynvarchar30
24/1CN/CTXSAPR0112Country/2L Sppl.Jur.Code/2L Rec.Jur.Code/Tax Tariff Code22KMEINUnit of Measure for Product-Specific Quantitynvarchar30
25/1CN/CTXSAPR0113Country/2L Sppl.Jur.Code/2L Rec.Jur.Code/Product Tax Group22KMEINUnit of Measure for Product-Specific Quantitynvarchar30
26/1CN/CTXSAPR0120Country/Tax Tariff Code20KMEINUnit of Measure for Product-Specific Quantitynvarchar30
27/1CN/CTXSAPR0130Country/3L Jur.Code20KMEINUnit of Measure for Product-Specific Quantitynvarchar30
28/1CN/CTXSAPR0131Country/3L Jur.Code/Product Tax Group21KMEINUnit of Measure for Product-Specific Quantitynvarchar30
29/1CN/CTXSAPR0140Country/Tax Event/Jurisdiction Code21KMEINUnit of Measure for Product-Specific Quantitynvarchar30
30/1CN/CTXSAPR0201Country/Tax Code20KMEINUnit of Measure for Product-Specific Quantitynvarchar30
31/1CN/CTXSAPRBR01Country/Tax Tariff Code20KMEINUnit of Measure for Product-Specific Quantitynvarchar30
32/1CN/CTXSAPRBR02Country/Product Tax Group20KMEINUnit of Measure for Product-Specific Quantitynvarchar30
33/1CN/CTXSAPRBR03Country/Product Tax Group/Business Partner Tax Group21KMEINUnit of Measure for Product-Specific Quantitynvarchar30
34/1CN/CTXSAPRBR10Country/1L Sppl.Jur.Code/1L Rec.Jur.Code21KMEINUnit of Measure for Product-Specific Quantitynvarchar30
35/1CN/CTXSAPRBR11Country/1L Sppl.Jur.Code/1L Rec.Jur.Code/Tax Tariff Code22KMEINUnit of Measure for Product-Specific Quantitynvarchar30
36/1CN/CTXSAPRBR12Country/1L Sppl.Jur.Code/1L Rec.Jur.Code/Product Tax Group22KMEINUnit of Measure for Product-Specific Quantitynvarchar30
37/1CN/CTXSAPRBR20Country/2L Jur.Code20KMEINUnit of Measure for Product-Specific Quantitynvarchar30
38/1CN/CTXSAPRBR21Country/2L Jur.Code/Product Tax Group21KMEINUnit of Measure for Product-Specific Quantitynvarchar30
39/1CN/CTXSAPRIN03Country/Tax Tariff Code/Business Partner ID21KMEINUnit of Measure for Product-Specific Quantitynvarchar30
40/1CN/CTXSAPRIN04Recipient Country/Tax Tariff Code/Business Partner ID21KMEINUnit of Measure for Product-Specific Quantitynvarchar30
41/1CN/CTXSAPRIN06Country/Spl Reg./Rec Region/Tax Group/Tax Group23KMEINUnit of Measure for Product-Specific Quantitynvarchar30
42/1CN/CTXSAPRIN07Country/Partner ID/Recip. Tax Region/Tax Group22KMEINUnit of Measure for Product-Specific Quantitynvarchar30
43/1CN/CTXSAPS0100Country/Business Process20KMEINUnit of Measure for Product-Specific Quantitynvarchar30
44/1CN/CTXSAPS0101Country/Bus. Transaction20KMEINUnit of Measure for Product-Specific Quantitynvarchar30
45/1CN/CTXSAPS0102Country/Bus. Transaction20KMEINUnit of Measure for Product-Specific Quantitynvarchar30
46/1CN/CTXSAPW0201Country/Tax Code20KMEINUnit of Measure for Product-Specific Quantitynvarchar30
47/1CN/CTXSAPW0202Country/Business Partner Tax Group20KMEINUnit of Measure for Product-Specific Quantitynvarchar30
48/1CN/CTXSAPX0100Country/Region20KMEINUnit of Measure for Product-Specific Quantitynvarchar30
49/1CN/CTXSAPX0101Country/Supplier BP ID/Business Partner ID21KMEINUnit of Measure for Product-Specific Quantitynvarchar30
50/1CN/CTXSAPX0102Country/Business Partner Tax Group20KMEINUnit of Measure for Product-Specific Quantitynvarchar30
51/1CN/CTXSAPX0103Country/Supplier BP ID/Business Partner ID/Product Tax Group22KMEINUnit of Measure for Product-Specific Quantitynvarchar30
52/1CN/CTXSAPX0104Recipient Country/Recipient Tax Region/Locat. Relationship21KMEINUnit of Measure for Product-Specific Quantitynvarchar30
53/1CN/CTXSAPX0105Country/Product Tax Group20KMEINUnit of Measure for Product-Specific Quantitynvarchar30
54/1CN/CTXSAPX0106Country/Region/Product Tax Group21KMEINUnit of Measure for Product-Specific Quantitynvarchar30
55/1CN/CTXSAPX0140Country/Product Tax Group/Jurisdiction Code21KMEINUnit of Measure for Product-Specific Quantitynvarchar30
56/1CN/CTXSAPX0141Country/Business Partner Tax Group/Jurisdiction Code21KMEINUnit of Measure for Product-Specific Quantitynvarchar30
57/1CN/CTXSAPX0146Country/Region/Product Tax Group21KMEINUnit of Measure for Product-Specific Quantitynvarchar30
58/1CN/CTXSAPX0147Country/Region/Business Partner Tax Group21KMEINUnit of Measure for Product-Specific Quantitynvarchar30
59/1CN/CTXSAPX0148Country19KMEINUnit of Measure for Product-Specific Quantitynvarchar30
60/1CN/CTXSAPXBR01Country/Tax Tariff Code20KMEINUnit of Measure for Product-Specific Quantitynvarchar30
61/1CN/CTXSAPXBR02Country/Product Tax Group20KMEINUnit of Measure for Product-Specific Quantitynvarchar30
62/1CN/CTXSAPXBR03Country/Product Tax Group/Business Partner Tax Group21KMEINUnit of Measure for Product-Specific Quantitynvarchar30
63/1CN/CTXSAPXBR11Country/1L Sppl.Jur.Code/1L Rec.Jur.Code/Tax Tariff Code22KMEINUnit of Measure for Product-Specific Quantitynvarchar30
64/1CN/LBPSCALEEVLScale Table - Fixed Data Part of a Scale5KMEINUnit of Measure for Product-Specific Quantitynvarchar30
65/1CN/LPTSCALEEVLScale Table - Fixed Data Part of a Scale5KMEINUnit of Measure for Product-Specific Quantitynvarchar30
66/1CN/LTXSCALEEVLScale Table - Fixed Data Part of a Scale5KMEINUnit of Measure for Product-Specific Quantitynvarchar30
67/BIC/B0000178000PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item52KMEINnvarchar30
68/BIC/B0000179000PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule60KMEINnvarchar30
69KONVConditions (Transaction Data)15KMEINCondition unit in the documentnvarchar30
70ZCM_FIX_ALLOC_DBFixation Allocation Table15KMEINCondition unitnvarchar30
71ZEIM_LIPSSD document: Delivery: Item data167KMEINCondition unitnvarchar30
72ZEIM_VBAPSales Document: Item Data95KMEINCondition unitnvarchar30
TOPConditions
73KONDConditions (Data)21KMEINCondition unitnvarchar30
74KONDNConditions: Free goods - Data section35KMEINCondition unitnvarchar30
75KONPConditions (Item)17KMEINCondition unitnvarchar30
76T685ZCondition Types: Lower/Higher Limits for Pricing Elements9KMEINCondition unitnvarchar30
TOPCost Center Accounting
77TKRSTRTransport Resource Prices21KMEINCondition unitnvarchar30
TOPCross-Application Components
78VKONVConditions (Transaction Data)15KMEINCondition unit in the documentnvarchar30
79VVBAPSales Document: Item Data95KMEINCondition unitnvarchar30
TOPData Collection
80S015Subsequent Settlement: Evaluation20KMEINCondition unit in the documentnvarchar30
81S015ES015 - Structural Information13KMEINCondition unit in the documentnvarchar30
82S060Model Structure for Info Structures with Initial VAKEY13KMEINCondition unit in the documentnvarchar30
83S074Subsequent Settlement: Operative16KMEINCondition unit in the documentnvarchar30
84S074ES074 - Structural Information9KMEINCondition unit in the documentnvarchar30
TOPExchanges
85OIA12ICONDConditions of OIA12I items11KMEINCondition unitnvarchar30
86OIANFFee Condition Records15KMEINCondition unit in the documentnvarchar30
TOPExtended Rebate
87S469Erweiterte Bonusabrechnung14KMEINHoeveelheidseenheid conditie in documentnvarchar30
TOPFreight Processing
88VFKGRP(Freight) Group Conditions17KMEINCondition unitnvarchar30
89VFKONV(Freight) Conditions22KMEINCondition unitnvarchar30
90VFSCAHScale Header7KMEINCondition unitnvarchar30
91VFSIShipment Costs: Sub-item Data20KMEINCondition unitnvarchar30
TOPGlobal Trade
92WB2_D_PRASPTrading Contract: pricing aspects15KMEINCondition unitnvarchar30
TOPIntegration
93FKK_KONV_SHORTPrice Conditions for SD Billing Document - Extracts19KMEINCondition unitnvarchar30
TOPInvoice Verification
94RBDIFFKOInvoice Verification - Conditions18KMEINCondition unitnvarchar30
TOPJoint Venture und Production Sharing Accounting
95JVKONVIS-Oil / Joint Venture / Data table for CRP pricing data15KMEINCondition unit in the documentnvarchar30
TOPLocalization
96J_1BFIFOINIncoming FIFO relevant Consignment movements (BRAZIL)22KMEINCondition unitnvarchar30
97J_1BFIFOOUTOutgoing FIFO relevant Consignment movements (BRAZIL)21KMEINCondition unitnvarchar30
98J_1IADDEXCAdditional Excise rate table10KMEINCondition unitnvarchar30
99J_1IEXCTAXTax calc. - Excise tax rates10KMEINCondition unitnvarchar30
100J_1IMATEXPExceptional materials excise rates13KMEINCondition unitnvarchar30
101VIXCJPFXDUNPRICEFixed Unit Prices for Service Charge Settlement15KMEINCondition unitnvarchar30
TOPLogistics Execution
102/DSD/PE_CNDRDIPricing: Retrieved Condition Records - Item Info.8KMEINCondition unitnvarchar30
TOPMarketing, Accounting and Pricing
103OIC_KONVConditions (Procedure Data)15KMEINCondition unit in the documentnvarchar30
104OIC_OIANFFee Condition Records15KMEINCondition unit in the documentnvarchar30
TOPOverhead Cost Controlling
105KONRResource Prices: Help Table for Variable Fields29KMEINCondition unitnvarchar30
106KONR1Resource Prices: Help Table for Variable Fields29KMEINCondition unitnvarchar30
TOPOverhead Cost Orders
107KONXOverhead Rates: Help Table for Variable Fields26KMEINCondition unitnvarchar30
108KONX1Overhead Rates: Help Table for Variable Fields26KMEINCondition unitnvarchar30
109TKZUTRTransport Overhead Records21KMEINCondition unitnvarchar30
TOPPeriodical Sales and Distribution
110JKEPSales Order: Schedule Line Data29KMEINCondition unitnvarchar30
111JKONVIS-M/SD: Conditions (Transaction Data)15KMEINCondition unit in the documentnvarchar30
112JLTPST2IS-M/SD: Main Data for Batch Input Postal Charges10KMEIN3-Byte fieldnvarchar30
TOPPricing
113PRCC_COND_LIMITSCondition Types: Lower/Higher Limits for Pricing Elements9KMEINUnit of Measure for Product-Specific Quantitynvarchar30
114PRCD_CONDPrice Condition - Item - Condition (KONV)51KMEINCondition Unitnvarchar30
115PRCM_TABL_000Reference Table for Condition Tables (A000)19KMEINCondition Unitnvarchar30
TOPRecycling Administration Core Functions
116J_7LP02REA Price List: Items15KMEINCondition unitnvarchar30
117J_7LV1PREA Document: Item Data21KMEINCondition unitnvarchar30
TOPRemaining Beverage - Obsolete Objects
118/BEV1/BO_DATAProof Table for Rebate Processing30KMEINCondition unitnvarchar30
119/BEV1/RBKPCopy Table for KONP for Accrual (Field KBRUE)17KMEINCondition unitnvarchar30
120/BEV1/RBPAIntermediate Table (Material-Specific Contrib. Margin Acc.)16KMEINCondition unit in the documentnvarchar30
121/BEV1/RBVBAPSales Document: Item Data95KMEINCondition unitnvarchar30
122/BEV1/RBWEItemized Proof Rebate Settlement22KMEINCondition unitnvarchar30
TOPSales
123VBAPSales Document: Item Data95KMEINCondition unitnvarchar30
TOPService Station Retailing
124OIRADBTDocument base table27KMEINCondition unitnvarchar30
125OIRCCOMPDSSR Pricing - Competitor price differences7KMEINCondition unitnvarchar30
126OIRCCOMPDMSSR Pricing - Competitor price differences/Material8KMEINCondition unitnvarchar30
127OIRCLPCDSSR Pricing - Location price cluster differences7KMEINCondition unitnvarchar30
128OIRCLPCDMSSR Pricing - Location price cluster differences/Material8KMEINCondition unitnvarchar30
129OIRCMDPGRSSR Pricing - Material differences rates7KMEINCondition unitnvarchar30
130OIRCSDPGRSSR Pricing - Service type differences rates7KMEINCondition unitnvarchar30
131OIRCT685SSR Pricing - Condition type definition7KMEINCondition unitnvarchar30
132OIRCT685_HSSR Pricing - Condition type definition8KMEINCondition unitnvarchar30
133OIRC_GMMHSSR Meters - History29KMEINCondition unitnvarchar30
134OIRC_GMMH_DELSSR Meters - Deleted meter readings history30KMEINCondition unitnvarchar30
135OIRC_MRREJSSR Meters - Meter readings rejected records32KMEINCondition unitnvarchar30
136OIRC_PRCHKSSR Pricing - Price check15KMEINSSR Pricing - Actual price condition unitnvarchar30
137OIRC_PRLOG_DIFSSR Pricing - Price update differences13KMEINCondition unitnvarchar30
138OIRC_PRLOG_PRLSSR Pricing - Old and new prices10KMEINCondition unitnvarchar30
139OIRC_PRLOG_PRMSSR Pricing - Price update parameter log14KMEINCondition unitnvarchar30
140OIREUPLPXXXXSSR PC: DTF table for item information14KMEINCondition unitnvarchar30
TOPShipping
141LIPSSD document: Delivery: Item data167KMEINCondition unitnvarchar30
TOPSimulation
142VSVBAP_CNVersion: Sales document: Item data96KMEINCondition unitnvarchar30
TOPSubsequent Settlement
143EBABPSettlement Runs Subsequent Settlement, Condition Record15KMEINCondition unitnvarchar30
144S015BIW1S015BIW1 * Supplementary settlement - Evaluation20KMEINCondition unit in the documentnvarchar30
145S015BIW2S015BIW2 * Supplementary settlement - Evaluation20KMEINCondition unit in the documentnvarchar30
TOPUnique Identification
146IUID_MAN_DATAManually Maintained Values for IUID Messages26KMEINCondition unitnvarchar30
147IUID_PEDIGREEUII IDoc Message Data for Supporting Supplier Collaboration26KMEINCondition unitnvarchar30