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

99 columns | Print definition?ERP 6.0  | KRECH

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CN/CBPSAP001Vendor/product22KRECHCalculation Type for Conditionnvarchar30
2/1CN/CBPSAP016Contract Item21KRECHCalculation Type for Conditionnvarchar30
3/1CN/CBPSAP019Contract Header21KRECHCalculation Type for Conditionnvarchar30
4/1CN/CBPSAP068Location-Dependent22KRECHCalculation Type for Conditionnvarchar30
5/1CN/CBPSAP118Product21KRECHCalculation Type for Conditionnvarchar30
6/1CN/CPTSAP00001Business Partner/Product Group22KRECHCalculation Type for Conditionnvarchar30
7/1CN/CPTSAP00004Business Partner/Product GUID22KRECHCalculation Type for Conditionnvarchar30
8/1CN/CPTSAP00005Business Partner/Product Group/Product GUID23KRECHCalculation Type for Conditionnvarchar30
9/1CN/CPTSAP00006Business Partner21KRECHCalculation Type for Conditionnvarchar30
10/1CN/CTXSAPD0001Country/Cost Center/Product Usage23KRECHCalculation Type for Conditionnvarchar30
11/1CN/CTXSAPD0002Country/Order/Product Usage23KRECHCalculation Type for Conditionnvarchar30
12/1CN/CTXSAPD0003Country/Product Usage22KRECHCalculation Type for Conditionnvarchar30
13/1CN/CTXSAPD0004Country21KRECHCalculation Type for Conditionnvarchar30
14/1CN/CTXSAPD0201Country/Tax Code22KRECHCalculation Type for Conditionnvarchar30
15/1CN/CTXSAPR0100Country/Product Tax Group/Business Partner Tax Group23KRECHCalculation Type for Conditionnvarchar30
16/1CN/CTXSAPR0103Country/Product Tax Group22KRECHCalculation Type for Conditionnvarchar30
17/1CN/CTXSAPR0104Country21KRECHCalculation Type for Conditionnvarchar30
18/1CN/CTXSAPR0105Country/Tax Event22KRECHCalculation Type for Conditionnvarchar30
19/1CN/CTXSAPR0106Country/Region/Product Tax Group/Business Partner Tax Group24KRECHCalculation Type for Conditionnvarchar30
20/1CN/CTXSAPR0107Country/Tax Event/ST Jurisdiction Code23KRECHCalculation Type for Conditionnvarchar30
21/1CN/CTXSAPR0108Country/Region/Product Tax Group23KRECHCalculation Type for Conditionnvarchar30
22/1CN/CTXSAPR0110Country/1L Sppl.Jur.Code/1L Rec.Jur.Code23KRECHCalculation Type for Conditionnvarchar30
23/1CN/CTXSAPR0111Country/2L Sppl.Jur.Code/2L Rec.Jur.Code23KRECHCalculation Type for Conditionnvarchar30
24/1CN/CTXSAPR0112Country/2L Sppl.Jur.Code/2L Rec.Jur.Code/Tax Tariff Code24KRECHCalculation Type for Conditionnvarchar30
25/1CN/CTXSAPR0113Country/2L Sppl.Jur.Code/2L Rec.Jur.Code/Product Tax Group24KRECHCalculation Type for Conditionnvarchar30
26/1CN/CTXSAPR0120Country/Tax Tariff Code22KRECHCalculation Type for Conditionnvarchar30
27/1CN/CTXSAPR0130Country/3L Jur.Code22KRECHCalculation Type for Conditionnvarchar30
28/1CN/CTXSAPR0131Country/3L Jur.Code/Product Tax Group23KRECHCalculation Type for Conditionnvarchar30
29/1CN/CTXSAPR0140Country/Tax Event/Jurisdiction Code23KRECHCalculation Type for Conditionnvarchar30
30/1CN/CTXSAPR0201Country/Tax Code22KRECHCalculation Type for Conditionnvarchar30
31/1CN/CTXSAPRBR01Country/Tax Tariff Code22KRECHCalculation Type for Conditionnvarchar30
32/1CN/CTXSAPRBR02Country/Product Tax Group22KRECHCalculation Type for Conditionnvarchar30
33/1CN/CTXSAPRBR03Country/Product Tax Group/Business Partner Tax Group23KRECHCalculation Type for Conditionnvarchar30
34/1CN/CTXSAPRBR10Country/1L Sppl.Jur.Code/1L Rec.Jur.Code23KRECHCalculation Type for Conditionnvarchar30
35/1CN/CTXSAPRBR11Country/1L Sppl.Jur.Code/1L Rec.Jur.Code/Tax Tariff Code24KRECHCalculation Type for Conditionnvarchar30
36/1CN/CTXSAPRBR12Country/1L Sppl.Jur.Code/1L Rec.Jur.Code/Product Tax Group24KRECHCalculation Type for Conditionnvarchar30
37/1CN/CTXSAPRBR20Country/2L Jur.Code22KRECHCalculation Type for Conditionnvarchar30
38/1CN/CTXSAPRBR21Country/2L Jur.Code/Product Tax Group23KRECHCalculation Type for Conditionnvarchar30
39/1CN/CTXSAPRIN03Country/Tax Tariff Code/Business Partner ID23KRECHCalculation Type for Conditionnvarchar30
40/1CN/CTXSAPRIN04Recipient Country/Tax Tariff Code/Business Partner ID23KRECHCalculation Type for Conditionnvarchar30
41/1CN/CTXSAPRIN06Country/Spl Reg./Rec Region/Tax Group/Tax Group25KRECHCalculation Type for Conditionnvarchar30
42/1CN/CTXSAPRIN07Country/Partner ID/Recip. Tax Region/Tax Group24KRECHCalculation Type for Conditionnvarchar30
43/1CN/CTXSAPS0100Country/Business Process22KRECHCalculation Type for Conditionnvarchar30
44/1CN/CTXSAPS0101Country/Bus. Transaction22KRECHCalculation Type for Conditionnvarchar30
45/1CN/CTXSAPS0102Country/Bus. Transaction22KRECHCalculation Type for Conditionnvarchar30
46/1CN/CTXSAPW0201Country/Tax Code22KRECHCalculation Type for Conditionnvarchar30
47/1CN/CTXSAPW0202Country/Business Partner Tax Group22KRECHCalculation Type for Conditionnvarchar30
48/1CN/CTXSAPX0100Country/Region22KRECHCalculation Type for Conditionnvarchar30
49/1CN/CTXSAPX0101Country/Supplier BP ID/Business Partner ID23KRECHCalculation Type for Conditionnvarchar30
50/1CN/CTXSAPX0102Country/Business Partner Tax Group22KRECHCalculation Type for Conditionnvarchar30
51/1CN/CTXSAPX0103Country/Supplier BP ID/Business Partner ID/Product Tax Group24KRECHCalculation Type for Conditionnvarchar30
52/1CN/CTXSAPX0104Recipient Country/Recipient Tax Region/Locat. Relationship23KRECHCalculation Type for Conditionnvarchar30
53/1CN/CTXSAPX0105Country/Product Tax Group22KRECHCalculation Type for Conditionnvarchar30
54/1CN/CTXSAPX0106Country/Region/Product Tax Group23KRECHCalculation Type for Conditionnvarchar30
55/1CN/CTXSAPX0140Country/Product Tax Group/Jurisdiction Code23KRECHCalculation Type for Conditionnvarchar30
56/1CN/CTXSAPX0141Country/Business Partner Tax Group/Jurisdiction Code23KRECHCalculation Type for Conditionnvarchar30
57/1CN/CTXSAPX0146Country/Region/Product Tax Group23KRECHCalculation Type for Conditionnvarchar30
58/1CN/CTXSAPX0147Country/Region/Business Partner Tax Group23KRECHCalculation Type for Conditionnvarchar30
59/1CN/CTXSAPX0148Country21KRECHCalculation Type for Conditionnvarchar30
60/1CN/CTXSAPXBR01Country/Tax Tariff Code22KRECHCalculation Type for Conditionnvarchar30
61/1CN/CTXSAPXBR02Country/Product Tax Group22KRECHCalculation Type for Conditionnvarchar30
62/1CN/CTXSAPXBR03Country/Product Tax Group/Business Partner Tax Group23KRECHCalculation Type for Conditionnvarchar30
63/1CN/CTXSAPXBR11Country/1L Sppl.Jur.Code/1L Rec.Jur.Code/Tax Tariff Code24KRECHCalculation Type for Conditionnvarchar30
64KONVConditions (Transaction Data)9KRECHCalculation type for conditionnvarchar10
TOPAdvertising Management
65TJJ83IS-M/AM: Condition Reference4KRECHIS-M: Calculation Type for Commission Record (Direct Input)nvarchar10
TOPBasic Functions
66T610UForeign Trade: Upload: Duty Rate Types, Legal Regulations4KRECHCalculation type for conditionnvarchar10
TOPConditions
67KONDConditions (Data)19KRECHCalculation type for conditionnvarchar10
68KONPConditions (Item)13KRECHCalculation type for conditionnvarchar10
69T685AConditions: Types: Additional Price Element Data4KRECHCalculation type for conditionnvarchar10
70T685ZCondition Types: Lower/Higher Limits for Pricing Elements4KRECHCalculation type for conditionnvarchar10
TOPCost Center Accounting
71TKRSTRTransport Resource Prices17KRECHCalculation type for conditionnvarchar10
TOPCross-Application Components
72VKONVConditions (Transaction Data)9KRECHCalculation type for conditionnvarchar10
TOPData Collection
73S060Model Structure for Info Structures with Initial VAKEY24KRECHCalculation type for conditionnvarchar10
TOPExchanges
74OIA12ICONDConditions of OIA12I items7KRECHCalculation type for conditionnvarchar10
75OIANFFee Condition Records9KRECHCalculation type for conditionnvarchar10
TOPExtended Rebate
76S469Erweiterte Bonusabrechnung25KRECHConditie-rekenregelnvarchar10
TOPFreight Processing
77VFKGRP(Freight) Group Conditions14KRECHCalculation rule for scalesnvarchar20
78VFKONV(Freight) Conditions19KRECHCalculation rule for scalesnvarchar20
79VFSCAHScale Header8KRECHCalculation rule for scalesnvarchar20
TOPGlobal Trade
80WB2_D_PRASPTrading Contract: pricing aspects16KRECHCalculation type for conditionnvarchar10
TOPIntegration
81FKK_KONV_SHORTPrice Conditions for SD Billing Document - Extracts13KRECHCalculation type for conditionnvarchar10
TOPJoint Venture und Production Sharing Accounting
82JVKONVIS-Oil / Joint Venture / Data table for CRP pricing data9KRECHCalculation type for conditionnvarchar10
TOPLogistics Execution
83/DSD/PE_CNDRDIPricing: Retrieved Condition Records - Item Info.4KRECHCalculation type for conditionnvarchar10
TOPMarketing, Accounting and Pricing
84OIC_KONVConditions (Procedure Data)9KRECHCalculation type for conditionnvarchar10
85OIC_OIANFFee Condition Records9KRECHCalculation type for conditionnvarchar10
TOPOverhead Cost Controlling
86KONRResource Prices: Help Table for Variable Fields21KRECHCalculation type for conditionnvarchar10
87KONR1Resource Prices: Help Table for Variable Fields21KRECHCalculation type for conditionnvarchar10
TOPOverhead Cost Orders
88KONXOverhead Rates: Help Table for Variable Fields18KRECHCalculation type for conditionnvarchar10
89KONX1Overhead Rates: Help Table for Variable Fields18KRECHCalculation type for conditionnvarchar10
90TKZUTRTransport Overhead Records17KRECHCalculation type for conditionnvarchar10
TOPPeriodical Sales and Distribution
91JKONVIS-M/SD: Conditions (Transaction Data)9KRECHCalculation type for conditionnvarchar10
TOPPricing
92PRCC_COND_CTCondition Types (T685A)4KRECHCalculation Type for Conditionnvarchar30
93PRCC_COND_LIMITSCondition Types: Lower/Higher Limits for Pricing Elements4KRECHCalculation Type for Conditionnvarchar30
94PRCD_CONDPrice Condition - Item - Condition (KONV)11KRECHCalculation Type for Conditionnvarchar30
95PRCM_TABL_000Reference Table for Condition Tables (A000)21KRECHCalculation Type for Conditionnvarchar30
96REBC_COND_CTRebate Condition Types4KRECHCalculation Type for Conditionnvarchar30
TOPRemaining Beverage - Obsolete Objects
97/BEV1/BO_DATAProof Table for Rebate Processing33KRECHCalculation type for conditionnvarchar10
98/BEV1/RBKPCopy Table for KONP for Accrual (Field KBRUE)13KRECHCalculation type for conditionnvarchar10
99/BEV1/RBWEItemized Proof Rebate Settlement26KRECHCalculation type for conditionnvarchar10