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

83 columns | Print definition?ERP 6.0  | STAFO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TMCBUpdate groups2STAFOUpdate group for statistics updatenvarchar60
2TQ55Assign inspection lot origin for update group3STAFOUpdate Group: Inspection Lots / Usage Decisionnvarchar60
3TVSFKUpdate Group: Statistics (Header)7STAFOUpdate group for statistics updatenvarchar60
4TVSFPUpdate Group: Statistics (Item)9STAFOUpdate group for statistics updatenvarchar60
5ZEIM_LIPSSD document: Delivery: Item data78STAFOUpdate group for statistics updatenvarchar60
6ZEIM_VBAKSales Document: Header Data50STAFOUpdate group for statistics updatenvarchar60
7ZEIM_VBAPSales Document: Item Data111STAFOUpdate group for statistics updatenvarchar60
TOPAdvertising Management
8JHAEIS-M/AM: OPM Sub-Item Schedule Line32STAFOUpdate group for statistics updatenvarchar60
9JHAGAIS-M/AM: Order-Publishing-Media Billing Dataset233STAFOUpdate group for statistics updatenvarchar60
10JHAKIS-M/AM: Order-Publishing-Media (Header Data)22STAFOIS-M: Update group for statistics updatenvarchar60
11JHAPIS-M/AM: Order-Publishing-Media Item112STAFOIS-M: Update group for statistics updatenvarchar60
12JHTFKIS-M/AM: Settlement Documents (Billing, Commission) - Header81STAFOIS-M: Update group for statistics updatenvarchar60
13JHTFPIS-M/AM: Billing/Settlement Documents - Item87STAFOIS-M: Update group for statistics updatenvarchar60
14TJH05IS-M/AM: Billing: Document Types29STAFOIS-M: Billing header: Update group for statisticsnvarchar60
15TJHMC1IS-M/AM: Update Group Determination for Order Header7STAFOUpdate group for statistics updatenvarchar60
16TJHMC2IS-M/AM: Statistic Group Determination for Billing Dataset9STAFOUpdate group for statistics updatenvarchar60
17TJHMC3Statistics Group Determination for Item/B.Datatset/Schd.Line9STAFOUpdate group for statistics updatenvarchar60
18TJJMC1IS-M/SD: Provisional Test8STAFOUpdate group for statistics updatenvarchar60
TOPAgency Business Global Trade
19WBRKAgency business: Header59STAFOUpdate group for statistics updatenvarchar60
20WBRPAgency business: Item25STAFOUpdate group for statistics updatenvarchar60
TOPBasic Functions
21T014Credit control areas4STAFOCredit update for open order/delivery/billing document valuenvarchar60
22TVFKBilling: Document Types23STAFOUpdate group for statistics updatenvarchar60
TOPBilling
23VBRKBilling Document: Header Data51STAFOUpdate group for statistics updatenvarchar60
24VBRPBilling Document: Item Data76STAFOUpdate group for statistics updatenvarchar60
TOPContract Billing
25DBERCHZIndividual Line Items128STAFOUpdate group for statistics updatenvarchar60
26DBERCHZ1Individual line items82STAFOUpdate group for statistics updatenvarchar60
27DBERCHZ5Individual line items (unimportant rows)82STAFOUpdate group for statistics updatenvarchar60
28ERCHZ_SHORTBilling Document Individual Lines Extract40STAFOUpdate group for statistics updatenvarchar60
TOPCross-Application Components
29VVBAKSales Document: Header Data50STAFOUpdate group for statistics updatenvarchar60
30VVBAPSales Document: Item Data111STAFOUpdate group for statistics updatenvarchar60
TOPData Collection
31TMC2LIS: Status Management - Updating3STAFOUpdate group for statistics updatenvarchar60
32TMC2DKey Figures (Updating)3STAFOUpdate group for statistics updatenvarchar60
33TMC2DSKey Figures (Updating)3STAFOUpdate group for statistics updatenvarchar60
34TMC2FRelevant Update Routines for Info Structures4STAFOUpdate group for statistics updatenvarchar60
35TMC2KObjects (Updating)3STAFOUpdate group for statistics updatenvarchar60
36TMC2KSObjects (Updating)3STAFOUpdate group for statistics updatenvarchar60
37TMC2PTable for Number Assignment of Update Reports3STAFOUpdate group for statistics updatenvarchar60
38TMC2QReference as to Which Update Uses Which Program3STAFOUpdate group for statistics updatenvarchar60
39TMC2SInfo Structures to be Updated per Business Event3STAFOUpdate group for statistics updatenvarchar60
40TMC5Business Events for Statistics Updating7STAFOUpdate group for statistics updatenvarchar60
41TMCBTUpdate Groups (LIS): Texts3STAFOUpdate group for statistics updatenvarchar60
TOPInformation System
42MCVSRFKStatistically Relevant Fields for Order + Delivery Header4STAFOUpdate group for statistics updatenvarchar60
43MCVSRFPStatistically Relevant Fields for Order + Billing Document4STAFOUpdate group for statistics updatenvarchar60
44TKSFKUpdate Sequence: Sales Activity Processing Statistics: Headr7STAFOUpdate group for statistics updatenvarchar60
TOPInspection Lot Completion
45QAVEInspection processing: Usage decision23STAFOUpdate group for statistics updatenvarchar60
TOPInvoicing
46DBERDZDB Table: Individ. Lines - Print Document154STAFOUpdate group for statistics updatenvarchar60
TOPMaintenance Notifications
47TQ80Notification Types36STAFOUpdate group for statistics updatenvarchar60
TOPPeriodical Sales and Distribution
48JFRKIS-M/SD: Billing - Header Data41STAFOUpdate group for statistics updatenvarchar60
49JFRPIS-M/SD: Billing Document - Item Data36STAFOUpdate group for statistics updatenvarchar60
50JKAKSales Order Header Data32STAFOUpdate group for statistics updatenvarchar60
51JKAPSales Order - Item Data34STAFOUpdate group for statistics updatenvarchar60
52JLRKIS-M/SD: Settlement Header Data28STAFOUpdate group for statistics updatenvarchar60
53JLRPIS-M/SD: Item Data for Settlement38STAFOUpdate group for statistics updatenvarchar60
54JVTLFNGIS-M/SD: Delivery/Home Delivery41STAFOUpdate group for statistics updatenvarchar60
55JVTZAEM2Sales Order Header Data34STAFOUpdate group for statistics updatenvarchar60
56TJFKIS-M/SD: Billing Document Types22STAFOUpdate group for statistics updatenvarchar60
57TJKMC3IS-M/SD: Definition of Update Group for Sales Doc., Header7STAFOUpdate group for statistics updatenvarchar60
58TJKMC4IS-M/SD: Definition of Update Group for Sales Doc., Item9STAFOUpdate group for statistics updatenvarchar60
59TJKMC5IS-M/SD: Definition of Update Group for Deliveries6STAFOUpdate group for statistics updatenvarchar60
60TJKMC6IS-M/SD: Def.of Update Group per Order-Delivery Assgmt9STAFOUpdate group for statistics updatenvarchar60
61TJL11IS-M/SD: Object Types for Document Flow etc.19STAFOUpdate group for statistics updatenvarchar60
TOPPurchasing
62EKKOPurchasing Document Header53STAFOUpdate group for statistics updatenvarchar60
63EKPOPurchasing Document Item82STAFOUpdate group for statistics updatenvarchar60
64T161Purchasing Document Types11STAFOUpdate group for statistics updatenvarchar60
65T163Item Categories in Purchasing Document12STAFOUpdate group for statistics updatenvarchar60
66TMSI2Processing Key for Sub-Items13STAFOUpdate group for statistics updatenvarchar60
TOPQuality Inspection
67QALSInspection lot record52STAFOUpdate group for statistics updatenvarchar60
TOPRemaining Beverage - Obsolete Objects
68/BEV1/RBBOCustomer Master Data Rebate Processing14STAFOUpdate group for statistics updatenvarchar60
69/BEV1/RBSTAFODefine Update Groups for Virtual Documents2STAFOUpdate Group for Statistics Updatenvarchar60
70/BEV1/RBTMC2FTemporary Storage of Contents from TMC2F4STAFOUpdate group for statistics updatenvarchar60
71/BEV1/RBVBAKSales Document: Header Data50STAFOUpdate group for statistics updatenvarchar60
72/BEV1/RBVBAPSales Document: Item Data111STAFOUpdate group for statistics updatenvarchar60
TOPReporting
73VTSFFUpdating Sequence: Statistics Shipment5STAFOUpdate group for statistics updatenvarchar60
TOPSales
74VBAKSales Document: Header Data50STAFOUpdate group for statistics updatenvarchar60
75VBAPSales Document: Item Data111STAFOUpdate group for statistics updatenvarchar60
TOPSales Activities
76VBKASales Activities52STAFOUpdate group for statistics updatenvarchar60
TOPShipping
77LIKPSD Document: Delivery Header Data50STAFOUpdate group for statistics updatenvarchar60
78LIPSSD document: Delivery: Item data78STAFOUpdate group for statistics updatenvarchar60
TOPSimulation
79VSVBAK_CNVersion: Sales document: Header data51STAFOUpdate group for statistics updatenvarchar60
80VSVBAP_CNVersion: Sales document: Item data112STAFOUpdate group for statistics updatenvarchar60
TOPStatistics
81TE775Update Group Determination5STAFOUpdate group for statistics updatenvarchar60
TOPTransportation
82VTTKShipment Header70STAFOUpdate group for statistics updatenvarchar60
83VTTSStage of Shipment66STAFOUpdate group for statistics updatenvarchar60