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

38 columns | Print definition?ERP 6.0  | BWVAR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DFKKFWKORRNCumul. Table for Adjustment and Inverse Postings (New)3BWVARValuation Variant in FI-CA Year-End Closingnvarchar30
2TKKAS_CONVCopy of TKKAS64BWVARValuation Variant for WIPnvarchar30
TOPConsumer Products for Food Beverage
3CFB_VERID_MRPRelease/Lock Production Version for Mat. Req. Planning10BWVARValuation Variant in Costingnvarchar30
TOPContract Accounts Receivable and Payable
4DFKKFWBEWManagement Data for Foreign Currency Valuations5BWVARValuation Variant in FI-CA Year-End Closingnvarchar30
5DFKKFWBEW_LDManagement Data for Ledger-Specific Foreign Crcy Valuations6BWVARValuation Variant in FI-CA Year-End Closingnvarchar30
6DFKKFWKORRCumulation Table for Adjustment and Inverse Postings11BWVARValuation Variant in FI-CA Year-End Closingnvarchar30
7DFKKOPBEWFI-CA Foreign Currency Valuation6BWVARValuation Variant in FI-CA Year-End Closingnvarchar30
8DFKKOPBEW_LDFI-CA Ledger-Specific Foreign Currency Valuation7BWVARValuation Variant in FI-CA Year-End Closingnvarchar30
9TFK044CFI-CA Valuation Variant3BWVARValuation Variant in FI-CA Year-End Closingnvarchar30
10TFK044CTName of Valuation Variant4BWVARValuation Variant in FI-CA Year-End Closingnvarchar30
11TFK044DFI-CA Company Code Valuation3BWVARValuation Variant in FI-CA Year-End Closingnvarchar30
TOPCost Object
12TKKASControl Table for Results Analysis64BWVARValuation Variant for WIPnvarchar30
13TKKAUResults Analysis Methods - Default Values in TKKAS60BWVARValuation Variant for Scrapnvarchar30
TOPCustomer Bill of Services
14ADBOS_ECP_CKISBOS: Enhancement to Detailed Statement7BWVARValuation Variant in Costingnvarchar30
TOPIndustry Solution Catch Weight Management
15/FMP/D_MP_HISTMaterial Price History20BWVARValuation Variant in Costingnvarchar30
16/FMP/D_MP_PRICMaterial Prices19BWVARValuation Variant in Costingnvarchar30
TOPMaterials Management
17J_1GVL_WHB016Sources for Production Costs (Cost Estimates)5BWVARValuation Variant in Costingnvarchar30
TOPProduct Cost Planning
18CKHSHeader: Unit Costing (Control + Totals)8BWVARValuation Variant in Costingnvarchar30
19CKHTTexts for CKHS8BWVARValuation Variant in Costingnvarchar30
20CKIPUnit Costing: Period Costs Line Item8BWVARValuation Variant in Costingnvarchar30
21CKISItems Unit Costing/Itemization Product Costing8BWVARValuation Variant in Costingnvarchar30
22CKIS_CCItemization: Additional Data - Concurrent Costing7BWVARValuation Variant in Costingnvarchar30
23CKITTexts for CKIS8BWVARValuation Variant in Costingnvarchar30
24FVMKMarking File for Release of Std Cost Est in Company Code5BWVARValuation Variant in Costingnvarchar30
25KEKOProduct Costing - Header Data7BWVARValuation Variant in Costingnvarchar30
26KEKO_CCAdditional Data for Concurrent Costing7BWVARValuation Variant in Costingnvarchar30
27KEPHProduct Costing: Cost Components for Cost of Goods Mfd7BWVARValuation Variant in Costingnvarchar30
28TCK03Costing Variants4BWVARValuation Variant in Costingnvarchar30
29TCK05Valuation Variants in Costing2BWVARValuation Variant in Costingnvarchar30
30TCK06Valuation Variants in Costing - Texts3BWVARValuation Variant in Costingnvarchar30
31TCK10Price Factors for Relevancy to Costing2BWVARValuation Variant in Costingnvarchar30
32TCK27Cost Component Split in Different Currency4BWVARValuation Variant in Costingnvarchar30
33TCK28CO Area Based Costing4BWVARValuation Variant in Costingnvarchar30
34TCK32Costing Versions4BWVARValuation Variant in Costingnvarchar30
35TCK33Assignment of Condition Types to Origin Group5BWVARValuation Variant in Costingnvarchar30
36TCK35Valuation Variants in Costing2BWVARValuation Variant in Costingnvarchar30
37TCK36Valuation Variants in Costing - Texts4BWVARValuation Variant in Costingnvarchar30
TOPTools
38TKEBWLREVAQuery Data Transfer: Variables3BWVARBW Object (InfoObject, GUID...)nvarchar300