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

146 columns | Print definition?ERP 6.0  | KBETR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CN/CBPSAP001Vendor/product18KBETRCondition Ratedecimal152
2/1CN/CBPSAP016Contract Item17KBETRCondition Ratedecimal152
3/1CN/CBPSAP019Contract Header17KBETRCondition Ratedecimal152
4/1CN/CBPSAP068Location-Dependent18KBETRCondition Ratedecimal152
5/1CN/CBPSAP118Product17KBETRCondition Ratedecimal152
6/1CN/CPTSAP00001Business Partner/Product Group18KBETRCondition Ratedecimal152
7/1CN/CPTSAP00004Business Partner/Product GUID18KBETRCondition Ratedecimal152
8/1CN/CPTSAP00005Business Partner/Product Group/Product GUID19KBETRCondition Ratedecimal152
9/1CN/CPTSAP00006Business Partner17KBETRCondition Ratedecimal152
10/1CN/CTXSAPD0001Country/Cost Center/Product Usage19KBETRCondition Ratedecimal152
11/1CN/CTXSAPD0002Country/Order/Product Usage19KBETRCondition Ratedecimal152
12/1CN/CTXSAPD0003Country/Product Usage18KBETRCondition Ratedecimal152
13/1CN/CTXSAPD0004Country17KBETRCondition Ratedecimal152
14/1CN/CTXSAPD0201Country/Tax Code18KBETRCondition Ratedecimal152
15/1CN/CTXSAPR0100Country/Product Tax Group/Business Partner Tax Group19KBETRCondition Ratedecimal152
16/1CN/CTXSAPR0103Country/Product Tax Group18KBETRCondition Ratedecimal152
17/1CN/CTXSAPR0104Country17KBETRCondition Ratedecimal152
18/1CN/CTXSAPR0105Country/Tax Event18KBETRCondition Ratedecimal152
19/1CN/CTXSAPR0106Country/Region/Product Tax Group/Business Partner Tax Group20KBETRCondition Ratedecimal152
20/1CN/CTXSAPR0107Country/Tax Event/ST Jurisdiction Code19KBETRCondition Ratedecimal152
21/1CN/CTXSAPR0108Country/Region/Product Tax Group19KBETRCondition Ratedecimal152
22/1CN/CTXSAPR0110Country/1L Sppl.Jur.Code/1L Rec.Jur.Code19KBETRCondition Ratedecimal152
23/1CN/CTXSAPR0111Country/2L Sppl.Jur.Code/2L Rec.Jur.Code19KBETRCondition Ratedecimal152
24/1CN/CTXSAPR0112Country/2L Sppl.Jur.Code/2L Rec.Jur.Code/Tax Tariff Code20KBETRCondition Ratedecimal152
25/1CN/CTXSAPR0113Country/2L Sppl.Jur.Code/2L Rec.Jur.Code/Product Tax Group20KBETRCondition Ratedecimal152
26/1CN/CTXSAPR0120Country/Tax Tariff Code18KBETRCondition Ratedecimal152
27/1CN/CTXSAPR0130Country/3L Jur.Code18KBETRCondition Ratedecimal152
28/1CN/CTXSAPR0131Country/3L Jur.Code/Product Tax Group19KBETRCondition Ratedecimal152
29/1CN/CTXSAPR0140Country/Tax Event/Jurisdiction Code19KBETRCondition Ratedecimal152
30/1CN/CTXSAPR0201Country/Tax Code18KBETRCondition Ratedecimal152
31/1CN/CTXSAPRBR01Country/Tax Tariff Code18KBETRCondition Ratedecimal152
32/1CN/CTXSAPRBR02Country/Product Tax Group18KBETRCondition Ratedecimal152
33/1CN/CTXSAPRBR03Country/Product Tax Group/Business Partner Tax Group19KBETRCondition Ratedecimal152
34/1CN/CTXSAPRBR10Country/1L Sppl.Jur.Code/1L Rec.Jur.Code19KBETRCondition Ratedecimal152
35/1CN/CTXSAPRBR11Country/1L Sppl.Jur.Code/1L Rec.Jur.Code/Tax Tariff Code20KBETRCondition Ratedecimal152
36/1CN/CTXSAPRBR12Country/1L Sppl.Jur.Code/1L Rec.Jur.Code/Product Tax Group20KBETRCondition Ratedecimal152
37/1CN/CTXSAPRBR20Country/2L Jur.Code18KBETRCondition Ratedecimal152
38/1CN/CTXSAPRBR21Country/2L Jur.Code/Product Tax Group19KBETRCondition Ratedecimal152
39/1CN/CTXSAPRIN03Country/Tax Tariff Code/Business Partner ID19KBETRCondition Ratedecimal152
40/1CN/CTXSAPRIN04Recipient Country/Tax Tariff Code/Business Partner ID19KBETRCondition Ratedecimal152
41/1CN/CTXSAPRIN06Country/Spl Reg./Rec Region/Tax Group/Tax Group21KBETRCondition Ratedecimal152
42/1CN/CTXSAPRIN07Country/Partner ID/Recip. Tax Region/Tax Group20KBETRCondition Ratedecimal152
43/1CN/CTXSAPS0100Country/Business Process18KBETRCondition Ratedecimal152
44/1CN/CTXSAPS0101Country/Bus. Transaction18KBETRCondition Ratedecimal152
45/1CN/CTXSAPS0102Country/Bus. Transaction18KBETRCondition Ratedecimal152
46/1CN/CTXSAPW0201Country/Tax Code18KBETRCondition Ratedecimal152
47/1CN/CTXSAPW0202Country/Business Partner Tax Group18KBETRCondition Ratedecimal152
48/1CN/CTXSAPX0100Country/Region18KBETRCondition Ratedecimal152
49/1CN/CTXSAPX0101Country/Supplier BP ID/Business Partner ID19KBETRCondition Ratedecimal152
50/1CN/CTXSAPX0102Country/Business Partner Tax Group18KBETRCondition Ratedecimal152
51/1CN/CTXSAPX0103Country/Supplier BP ID/Business Partner ID/Product Tax Group20KBETRCondition Ratedecimal152
52/1CN/CTXSAPX0104Recipient Country/Recipient Tax Region/Locat. Relationship19KBETRCondition Ratedecimal152
53/1CN/CTXSAPX0105Country/Product Tax Group18KBETRCondition Ratedecimal152
54/1CN/CTXSAPX0106Country/Region/Product Tax Group19KBETRCondition Ratedecimal152
55/1CN/CTXSAPX0140Country/Product Tax Group/Jurisdiction Code19KBETRCondition Ratedecimal152
56/1CN/CTXSAPX0141Country/Business Partner Tax Group/Jurisdiction Code19KBETRCondition Ratedecimal152
57/1CN/CTXSAPX0146Country/Region/Product Tax Group19KBETRCondition Ratedecimal152
58/1CN/CTXSAPX0147Country/Region/Business Partner Tax Group19KBETRCondition Ratedecimal152
59/1CN/CTXSAPX0148Country17KBETRCondition Ratedecimal152
60/1CN/CTXSAPXBR01Country/Tax Tariff Code18KBETRCondition Ratedecimal152
61/1CN/CTXSAPXBR02Country/Product Tax Group18KBETRCondition Ratedecimal152
62/1CN/CTXSAPXBR03Country/Product Tax Group/Business Partner Tax Group19KBETRCondition Ratedecimal152
63/1CN/CTXSAPXBR11Country/1L Sppl.Jur.Code/1L Rec.Jur.Code/Tax Tariff Code20KBETRCondition Ratedecimal152
64/1CN/LBPSCALEV01Scale Table - Variable Data Part of a Scale4KBETRCondition Ratedecimal152
65/1CN/LBPSCALEV02Scale Table - Variable Data Part of a Scale5KBETRCondition Ratedecimal152
66/1CN/LPTSCALEV01Scale Table - Variable Data Part of a Scale4KBETRCondition Ratedecimal152
67/1CN/LPTSCALEV02Scale Table - Variable Data Part of a Scale5KBETRCondition Ratedecimal152
68/1CN/LTXSCALEV01Scale Table - Variable Data Part of a Scale4KBETRCondition Ratedecimal152
69/1CN/LTXSCALEV02Scale Table - Variable Data Part of a Scale5KBETRCondition Ratedecimal152
70/BGLOCS/VATMAITMVAT Margin Items22KBETRTax Ratedecimal112
71/CCEE/SIFI_UMSITTax items applied for decrease/increase of input VAT13KBETRTax Ratedecimal112
72/SLOAP/PRICING_2Conditions (1-Dimensional Quantity Scale)6KBETRRate (condition amount or percentage)decimal112
73BSETTax Data Document Segment28KBETRTax Ratedecimal112
74FIEUD_GOODS_ISAFT-XML:Goods Movement Line Items51KBETRRate (condition amount or percentage)decimal112
75FIEUD_MMINVTAXSAFT:MM: TAX Information for E-XML MM invoice for LU12KBETRRate (condition amount or percentage)decimal112
76FIEUD_MMINV_ISAFT:MM: Item Details for XML Purchase Invoice29KBETRRate (condition amount or percentage)decimal112
77FISKD_VATCNTRLDocument's information reported to SK authorities19KBETRTax Ratenvarchar60
78FUDT_VDOCBSETTax Data Document Segment of Verification Document28KBETRTax Ratedecimal112
79FUDT_VDOCBSETHTax Data Document Segment of Verification Document(History)28KBETRTax Ratedecimal112
80J_1UF_INV_REFDocument references to FI Invoice processed items17KBETRRate (condition amount or percentage)decimal112
81J_1UF_VAT_DISTRVAT distribution coefficient for Ukraine6KBETRRate (condition amount or percentage)decimal112
82J_3RVATD_RUNStored VAT-return Runs: Main Section13KBETRTax Ratedecimal112
83J_3RVATD_RUN_TAStored VAT-return Runs: Tax Agent Section13KBETRTax Ratedecimal112
84KONVConditions (Transaction Data)11KBETRRate (condition amount or percentage)decimal112
TOPAccounting Interface
85GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)69KBETRRate (condition amount or percentage)decimal112
86GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)69KBETRRate (condition amount or percentage)decimal112
TOPAustria
87PA0136HR Master Record: Infotype 0136 (Garn. Transfer A)30KBETRAmount of Transfer of Costsdecimal92
TOPConditions
88KONDConditions (Data)60KBETRRate (condition amount or percentage) where no scale existsdecimal112
89KONMConditions (1-Dimensional Quantity Scale)6KBETRRate (condition amount or percentage)decimal112
90KONPConditions (Item)14KBETRRate (condition amount or percentage) where no scale existsdecimal112
91KONWConditions (1-Dimensional Value Scale)6KBETRRate (condition amount or percentage)decimal112
TOPCost Center Accounting
92TKRSTRTransport Resource Prices18KBETRRate (condition amount or percentage) where no scale existsdecimal112
TOPCross-Application Components
93VKONVConditions (Transaction Data)11KBETRRate (condition amount or percentage)decimal112
TOPEmpties Management
94/BEV1/EMLGKTOEmpties Account50KBETRRate (condition amount or percentage) where no scale existsdecimal112
TOPExchanges
95OIA12ICONDConditions of OIA12I items8KBETRRate (condition amount or percentage)decimal112
96OIANFFee Condition Records11KBETRRate (condition amount or percentage)decimal112
TOPFinancial Accounting
97DEFTAX_ITEMData for Deferred Taxes16KBETRTax Ratedecimal112
98T007VTax Codes to be Transported8KBETRRate (condition amount or percentage)decimal112
TOPFreight Processing
99VFSCAR1Freight Rates (One-Dimensional)6KBETRRate (condition amount or percentage) where no scale existsdecimal112
100VFSCAR2Freight Rates (Two-Dimensional)6KBETRRate (condition amount or percentage) where no scale existsdecimal112
101VFSCAR3Freight Rates (Three-Dimensional)7KBETRRate (condition amount or percentage) where no scale existsdecimal112
TOPGermany
102PA0116HR Master Record: Infotype 0116 (Garn. Transfer D)30KBETRAmount of Transfer of Costsdecimal92
TOPGlobal Trade
103WB2_D_PRASPTrading Contract: pricing aspects12KBETRRate (condition amount or percentage) where no scale existsdecimal112
TOPHandheld Connectivity
104/DSD/PR_RSAMMDSD Promotions - Promotion Result Amounts5KBETRRate (condition amount or percentage)decimal112
TOPIncentive and Commission Management ICM
105CACS_DOCFI_TData Transfer: FI Document (Tax Item)12KBETRRate (condition amount or percentage) where no scale existsdecimal112
TOPIntegration
106FKK_KONV_SHORTPrice Conditions for SD Billing Document - Extracts15KBETRRate (condition amount or percentage)decimal112
TOPInvoice Verification
107RBDIFFKOInvoice Verification - Conditions15KBETRRate (condition amount or percentage)decimal112
TOPJoint Venture und Production Sharing Accounting
108JVKONVIS-Oil / Joint Venture / Data table for CRP pricing data11KBETRRate (condition amount or percentage)decimal112
TOPLocalization
109IDGT_CODE_LCTax Catalog Code5KBETRVAT Tax Ratedecimal92
110J_1BFIFOINIncoming FIFO relevant Consignment movements (BRAZIL)20KBETRRate (condition amount or percentage)decimal112
111J_1BFIFOOUTOutgoing FIFO relevant Consignment movements (BRAZIL)19KBETRRate (condition amount or percentage)decimal112
112J_1IKONVExcise recalculated conditions15KBETRRate (condition amount or percentage)decimal112
113J_1IRAINCNDArticle Inward Note Conditions6KBETRRate (condition amount or percentage)decimal112
114J_1ISER_BSEGTransaction table having the Invoices with Service Category19KBETRTax Ratedecimal112
115J_3RFSEC_ITEMData for Secondary events for deferred tax20KBETRTax Ratedecimal112
116RFIDPTAAVPro-Rata Asset Acquisition Value13KBETRTax Ratedecimal112
TOPLogistics Execution
117/DSD/PE_CNDRDIPricing: Retrieved Condition Records - Item Info.5KBETRRate (condition amount or percentage) where no scale existsdecimal112
118/DSD/PE_CNDRDQPricing: Retrieved Condition Records - Quan. Scale6KBETRRate (condition amount or percentage)decimal112
119/DSD/PE_CNDRDVPricing: Retrieved Condition Records - Value Scale6KBETRRate (condition amount or percentage)decimal112
TOPMarketing, Accounting and Pricing
120OIC_KONVConditions (Procedure Data)11KBETRRate (condition amount or percentage)decimal112
121OIC_OIANFFee Condition Records11KBETRRate (condition amount or percentage)decimal112
TOPOverhead Cost Controlling
122KONRResource Prices: Help Table for Variable Fields26KBETRRate (condition amount or percentage) where no scale existsdecimal112
123KONR1Resource Prices: Help Table for Variable Fields26KBETRRate (condition amount or percentage) where no scale existsdecimal112
TOPOverhead Cost Orders
124KONXOverhead Rates: Help Table for Variable Fields23KBETRRate (condition amount or percentage) where no scale existsdecimal112
125KONX1Overhead Rates: Help Table for Variable Fields23KBETRRate (condition amount or percentage) where no scale existsdecimal112
126TKZUTRTransport Overhead Records18KBETRRate (condition amount or percentage) where no scale existsdecimal112
TOPPatient Accounting
127NVKONVIS-H: Conditions10KBETRRate (condition amount or percentage)decimal112
TOPPeriodical Sales and Distribution
128JKONVIS-M/SD: Conditions (Transaction Data)11KBETRRate (condition amount or percentage)decimal112
129JLTPST2IS-M/SD: Main Data for Batch Input Postal Charges7KBETRAmount field for batch inputnvarchar150
130JLTPST3IS-M/SD: Scale Data for Batch Input Postal Charges6KBETRAmount field for batch inputnvarchar150
TOPPricing
131PRCD_CONDPrice Condition - Item - Condition (KONV)49KBETRCondition Ratedecimal152
132PRCM_TABL_000Reference Table for Condition Tables (A000)17KBETRCondition Ratedecimal152
TOPRecycling Administration Core Functions
133J_7LP03REA Price List: Conditions11KBETRFormula: Amountdecimal172
TOPRemaining Beverage - Obsolete Objects
134/BEV1/BO_DATAProof Table for Rebate Processing26KBETRRate (condition amount or percentage) where no scale existsdecimal112
135/BEV1/RBKPCopy Table for KONP for Accrual (Field KBRUE)14KBETRRate (condition amount or percentage) where no scale existsdecimal112
136/BEV1/RBWEItemized Proof Rebate Settlement19KBETRRate (condition amount or percentage) where no scale existsdecimal112
TOPRetail Pricing
137WPFDOFamily Pricing: Diff. Dist. Chain-Depnd. Price Relationships9KBETRAmount for the Price Relationship for a Family Groupdecimal112
138WPFGRFamily Pricing: Defintion of Family Groups9KBETRAmount for the Price Relationship for a Family Groupdecimal112
TOPService Station Retailing
139OIRADBTDocument base table24KBETRRate (condition amount or percentage)decimal112
140OIRC_GMMHSSR Meters - History26KBETRSSR Meters - Actual pricedecimal112
141OIRC_GMMH_DELSSR Meters - Deleted meter readings history27KBETRSSR Meters - Actual pricedecimal112
142OIRC_MRREJSSR Meters - Meter readings rejected records29KBETRSSR Meters - Actual pricedecimal112
143OIRC_PRCHKSSR Pricing - Price check11KBETRSSR Pricing - Actual pricedecimal112
TOPSubsequent Settlement
144EBABGSettlement Runs Subsequent Settlement, Interval Scales11KBETRRate (condition amount or percentage)decimal112
145EBABPSettlement Runs Subsequent Settlement, Condition Record12KBETRRate (condition amount or percentage) where no scale existsdecimal112
TOPWaste Management
146EEWA_BULK_DATABulk refuse order data12KBETRRate (condition amount or percentage)decimal112