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

188 columns | Print definition?ERP 6.0  | VKGRP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CADMC/00000515TVGRT6VKGRPnvarchar30
2/1CADMC/00000518TVKGR5VKGRPnvarchar30
3/1RA/0SD010MIItems for Class SD01 - Raw Data112VKGRPSales Groupnvarchar30
4/BIC/B0000176000PSA for 2LIS_11_VAHDR T90CLNT090 Sales Doc. Header37VKGRPnvarchar30
5/BIC/B0000177000PSA for 2LIS_11_V_ITM T90CLNT090 Sls-Ship.Alloc.Item23VKGRPnvarchar30
6/BIC/B0000178000PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item33VKGRPnvarchar30
7/BIC/B0000179000PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule46VKGRPnvarchar30
8/BIC/B0000180000PSA for 2LIS_11_V_SCL T90CLNT090 Sls-Ship.Alloc.Sch.36VKGRPnvarchar30
9/BIC/B0000181000PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond.27VKGRPnvarchar30
10/BIC/B0000183000PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item87VKGRPnvarchar30
11/BIC/B0000185000PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item93VKGRPnvarchar30
12/BIC/B0000186000PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond.68VKGRPnvarchar30
13/SMD/MD_____011QSID-Tabelle fuer Sales Group3VKGRPSales Groupnvarchar30
14/SMERP/STG_PM001Data staging - Equipment complex table166VKGRPSales Groupnvarchar30
15/SMERP/STG_PM002Data staging - Functional Location complex table110VKGRPSales Groupnvarchar30
16/SMERP/STG_PM003Data staging - Equipment List Set - Hdr - complex tab166VKGRPSales Groupnvarchar30
17/SMERP/STG_PM008Data staging - Functional Loc. List Set - Hdr - complex tab110VKGRPSales Groupnvarchar30
18/XFT/QMPPAPT001QM Sampling Header Table16VKGRPSales Groupnvarchar30
19CE1PR22Périm. résultat IDES79VKGRPGroupe de vendeursnvarchar30
20CE2PR22Périm. résultat IDES63VKGRPGroupe de vendeursnvarchar30
21CE4PR22Périm. résultat IDES48VKGRPGroupe de vendeursnvarchar30
22CE4PR22_ACCTPérim. résultat IDES49VKGRPGroupe de vendeursnvarchar30
23CE4PR22_FLAGPérim. résultat IDES45VKGRPFlag : caract. imputée manuellement ou via TKEZUnvarchar10
24CE4PR22_KENCPérim. résultat IDES47VKGRPGroupe de vendeursnvarchar30
25CMM_D_IDXCommodity Management: Index Table16VKGRPSales Groupnvarchar30
26GLPCA_CTProfit Center Documents129VKGRPSales Groupnvarchar30
27GLPCA_T_CTProfit Center Documents145VKGRPSales Groupnvarchar30
28MEV_D_AD_ITEM_SDPeriod-End Valuation: Accruals Document Item SD12VKGRPSales Groupnvarchar30
29MEV_D_WL_ITEMPeriod-end valuation: Worklist item39VKGRPSales Groupnvarchar30
30TNAD4Output Control: Printers by Sales Group4VKGRPSales Groupnvarchar30
31ZEIM_LIPSSD document: Delivery: Item data70VKGRPSales Groupnvarchar30
32ZEIM_VBAKSales Document: Header Data22VKGRPSales Groupnvarchar30
TOPAccount Determination
33TVBVKOrganizational Unit: Sales Groups per Sales Office3VKGRPSales Groupnvarchar30
34TVGRTOrganizational Unit: Sales Groups: Texts3VKGRPSales Groupnvarchar30
35TVKGROrganizational Unit: Sales Groups2VKGRPSales Groupnvarchar30
TOPAccounting Interface
36GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)249VKGRPSales Groupnvarchar30
37GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)249VKGRPSales Groupnvarchar30
TOPAdvertising Management
38B220Output per Organizational Data, Confirmation, No Quasi8VKGRPSales Groupnvarchar30
39JHAKIS-M/AM: Order-Publishing-Media (Header Data)15VKGRPSales Groupnvarchar30
40JHAREV1IS-M/AM: Order Revenue Recognition Key Date Values41VKGRPSales Groupnvarchar30
41JHAREV3IS-M/AM: Order Revenue Recognition Key Date Quantities38VKGRPSales Groupnvarchar30
42JHFREV2IS-M/AM: Key Dates for Billing Document Revenue Recognition56VKGRPSales Groupnvarchar30
43JHFREV4IS-M/AM: Billing Document Revenue Recognition Key Date Qties53VKGRPSales Groupnvarchar30
44JHTFPIS-M/AM: Billing/Settlement Documents - Item64VKGRPSales Groupnvarchar30
45JHTVAABKIS-M/AM: Contract Settlement Header Data8VKGRPSales Groupnvarchar30
46JHTVBIS-M/AM: Contract Requirements7VKGRPSales Groupnvarchar30
47JHTVKOIS-M/AM: Contract7VKGRPSales Groupnvarchar30
48JHWWWTEMP_ORDERIS-M/AM: Temporary Table for Order Data from the Internet7VKGRPSales Groupnvarchar30
49JJTMXBIS-M: Media-Mix Package Element8VKGRPSales Groupnvarchar30
50JJTVVIS-M/AM: Media Sales Agent Contract7VKGRPSales Groupnvarchar30
51TJHCIC_ORDER_WSIS-M/AM: Order Fast Entry in CIC7VKGRPSales Groupnvarchar30
52TJHPRINTIS-M/AM: Output Control4VKGRPSales Groupnvarchar30
53TJHWWW_JHAWIS-M/AM: Enter Classified Ad IAC: General Settings7VKGRPSales Groupnvarchar30
TOPAgency Business Global Trade
54WBRKAgency business: Header88VKGRPSales Groupnvarchar30
TOPAllocation
55AUVDIWorklist for Deliveries (Follow-on Doc. Generation)21VKGRPSales Groupnvarchar30
TOPBasic Functions
56TPVSOProduct Proposal: Online Procedure Determination6VKGRPSales Groupnvarchar30
57VETVGDelivery Due Index for Stock Transfer15VKGRPSales Groupnvarchar30
TOPBilling
58A146Customer Hierarchy8VKGRPSales Groupnvarchar30
59A147Customer Hierarchy (Sales Deal)8VKGRPSales Groupnvarchar30
60VBRPBilling Document: Item Data67VKGRPSales Groupnvarchar30
TOPChargeback
61WCOCOHCondition Contract: Header34VKGRPSales Groupnvarchar30
TOPConditions
62KONAAgreements7VKGRPSales Groupnvarchar30
TOPContract Accounts Receivable and Payable
63DFKKCCMDMaster Data Groups of Test Series3VKGRPCollection Management: Contract Account Groupnvarchar120
64DFKKCCU_ERRLog: Successful Champion/Challenger Updates4VKGRPCollection Management: Contract Account Groupnvarchar120
65DFKKCCU_SUCLog: Champion/Challenger Updates with Errors4VKGRPCollection Management: Contract Account Groupnvarchar120
66DFKKWLIWork Items10VKGRPCollection Management: Contract Account Groupnvarchar120
67DFKKWLIAWork Items (Work Item Type)10VKGRPCollection Management: Contract Account Groupnvarchar120
TOPCosting
68COERSales Order Value Revenue70VKGRPSales Groupnvarchar30
TOPCross-Application Components
69VVBAKSales Document: Header Data22VKGRPSales Groupnvarchar30
TOPCustomer Master
70KNVVCustomer Master Sales Data40VKGRPSales Groupnvarchar30
TOPData Collection
71S002SIS: Sales Office Statistics9VKGRPSales Groupnvarchar30
72S002BIW1S002BIW1 * SIS: Sales office statistics4VKGRPSales Groupnvarchar30
73S002BIW2S002BIW2 * SIS: Sales office statistics4VKGRPSales Groupnvarchar30
74S002ES002 - Structural Information4VKGRPSales Groupnvarchar30
75S008Communications Table SD -> CO/Projects58VKGRPSales Groupnvarchar30
76S016SIS: Sales activities10VKGRPSales Groupnvarchar30
77S016ES016 - Structural Information5VKGRPSales Groupnvarchar30
78S120Sales as per receipts49VKGRPSales Groupnvarchar30
79S120BIW1S120BIW1 * Sales as Per Receipts49VKGRPSales Groupnvarchar30
80S120BIW2S120BIW2 * Sales as Per Receipts49VKGRPSales Groupnvarchar30
81S260SD - Sales order27VKGRPSales Groupnvarchar30
82S260BIW1SD - Sales order27VKGRPSales Groupnvarchar30
83S260BIW2SD - Sales order27VKGRPSales Groupnvarchar30
84S261SD - Delivery note64VKGRPSales Groupnvarchar30
85S261BIW1SD - Delivery note64VKGRPSales Groupnvarchar30
86S261BIW2SD - Delivery note64VKGRPSales Groupnvarchar30
87S262SD - Billing document48VKGRPSales Groupnvarchar30
88S262BIW1SD - Billing document48VKGRPSales Groupnvarchar30
89S262BIW2SD - Billing document48VKGRPSales Groupnvarchar30
90S263SD - Sales order/delivery note24VKGRPSales Groupnvarchar30
91S263BIW1SD - Sales order/delivery note24VKGRPSales Groupnvarchar30
92S263BIW2SD - Sales order/delivery note24VKGRPSales Groupnvarchar30
93S264SD- Offer27VKGRPSales Groupnvarchar30
94S264BIW1S264BIW1 * SD - Quotation27VKGRPSales Groupnvarchar30
95S264BIW2S264BIW2 * SD - Quotation27VKGRPSales Groupnvarchar30
96S272Do not use!51VKGRPSales Groupnvarchar30
97S272BIW1Do not use!51VKGRPSales Groupnvarchar30
98S272BIW2Do not use!51VKGRPSales Groupnvarchar30
99S276Transfer BW: Vertriebsdaten38VKGRPVerkoopgroepnvarchar30
100S276BIW1S276BIW1 * Transfer to BW: Sales and Distribution Data38VKGRPSales Groupnvarchar30
101S276BIW2S276BIW2 * BW Transfer: Sales and Distribution Data38VKGRPSales Groupnvarchar30
TOPEquipment
102IEQT_WL_ITEMSInterim Statuses - Items110VKGRPSales Groupnvarchar30
103IEQT_WL_ITM_BACInterim Statuses - Items (Backup)111VKGRPSales Groupnvarchar30
TOPFunctional Locations
104ILOAPM Object Location and Account Assignment48VKGRPSales Groupnvarchar30
105ILOA_VSLocation & Account Assignment for PM Object (Version Table)49VKGRPSales Groupnvarchar30
TOPInformation System
106TJBW02IS-M/AM BW: Access to Time Slice Rule6VKGRPSales Groupnvarchar30
TOPLogistics - General
107WBHKTrading Contract: Header Data41VKGRPSales Groupnvarchar30
TOPMaintenance Notifications
108PMSDOPM organizational data for SD documents6VKGRPSales Groupnvarchar30
109QMELQuality Notification102VKGRPSales Groupnvarchar30
TOPMaintenance Orders
110TPMUSPM/SM - User default values41VKGRPSales Groupnvarchar30
TOPMedia Product Sales and Distribution
111JKSDCOLLECTIS-M: (Obsolete): Collection9VKGRPSales Groupnvarchar30
112JKSDORDERINDEXIndex Table for IS-M Orders14VKGRPSales Groupnvarchar30
113JKSDPROTOCOLIS-M: Order Generation Log13VKGRPSales Groupnvarchar30
114JKSDPROTOCOL2IS-M: Log14VKGRPSales Groupnvarchar30
115JKSDREPROTOCOLIS-M: Return Release Log11VKGRPSales Groupnvarchar30
116JKSDRETURNCHECKIS-M: Quantity Check on Return9VKGRPSales Groupnvarchar30
117JKSDTRANSFERIS-M: BP Goods Transfer8VKGRPSales Groupnvarchar30
118JKSDT_SD_CON_GENIS-M: Table for Generating Contracts17VKGRPSales Groupnvarchar30
119JKSDUNSOLDIS-M: Header Data on Unsold Copies12VKGRPSales Groupnvarchar30
120JKSECONTRINDEXIndex Table for IS-M Contracts20VKGRPSales Groupnvarchar30
121S485IS-M: Sales Figures22VKGRPSales Groupnvarchar30
122S488Return Quantity Check20VKGRPSales Groupnvarchar30
TOPPeriodical Sales and Distribution
123JKAKSales Order Header Data16VKGRPSales Groupnvarchar30
124JKWWWTEMP_ORDERIS-M/SD: WWW Temporary Table for Order Data from Internet8VKGRPSales Groupnvarchar30
125JVTFEHLERIS-M: Distribution Error Message28VKGRPSales Groupnvarchar30
126JVTZAEM2Sales Order Header Data18VKGRPSales Groupnvarchar30
127S451IS-M/SD: Sales Office Statistics9VKGRPSales Groupnvarchar30
128S451ES451 - Structural Data4VKGRPSales Groupnvarchar30
129TJKWVIS-M/SD: External Connection - Sales Area Determination7VKGRPSales Groupnvarchar30
130TJKWWW_FIXIS-M/SD: WWW, Combinations of Fixed Order Values8VKGRPSales Groupnvarchar30
TOPPersonnel Administration
131PA0900HR Master Record: Infotype 0900 (Sales Data)26VKGRPSales Groupnvarchar30
TOPPOS Interface
132WVFBDRS Interface, Intermediate Buffer, Order Item FM59VKGRPSales Groupnvarchar30
TOPProfit Center Accounting
133GLPCAEC-PCA: Actual Line Items82VKGRPSales Groupnvarchar30
TOPProfitability Analysis
134CE1850063VKGRPSales Groupnvarchar30
135CE1BGISErgebnisbereich für63VKGRPVerkäufergruppenvarchar30
136CE1IDEAOp. Concern BR World79VKGRPSales Groupnvarchar30
137CE1IDESErgebnisbereich IDES79VKGRPVerkäufergruppenvarchar30
138CE1INT1Ergebnisbereich IDES79VKGRPVerkäufergruppenvarchar30
139CE1S001Sample operating concern44VKGRPSales Groupnvarchar30
140CE1S_GOQuickstart Template63VKGRPSales Groupnvarchar30
141CE2850047VKGRPSales Groupnvarchar30
142CE2BGISErgebnisbereich für47VKGRPVerkäufergruppenvarchar30
143CE2IDEAOp. Concern BR World63VKGRPSales Groupnvarchar30
144CE2IDESErgebnisbereich IDES63VKGRPVerkäufergruppenvarchar30
145CE2INT1Ergebnisbereich IDES63VKGRPVerkäufergruppenvarchar30
146CE2S001Sample operating concern34VKGRPSales Groupnvarchar30
147CE2S_GOQuickstart Template47VKGRPSales Groupnvarchar30
148CE4850032VKGRPSales Groupnvarchar30
149CE48500_ACCT33VKGRPSales Groupnvarchar30
150CE48500_FLAG29VKGRPFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
151CE48500_KENC31VKGRPSales Groupnvarchar30
152CE4BGISErgebnisbereich für32VKGRPVerkäufergruppenvarchar30
153CE4BGIS_ACCTErgebnisbereich für33VKGRPVerkäufergruppenvarchar30
154CE4BGIS_FLAGErgebnisbereich für29VKGRPFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
155CE4BGIS_KENCErgebnisbereich für31VKGRPVerkäufergruppenvarchar30
156CE4IDEAOp. Concern BR World48VKGRPSales Groupnvarchar30
157CE4IDEA_ACCTOp. Concern BR World49VKGRPSales Groupnvarchar30
158CE4IDEA_FLAGOp. Concern BR World45VKGRPFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
159CE4IDEA_KENCOp. Concern BR World47VKGRPSales Groupnvarchar30
160CE4IDESErgebnisbereich IDES48VKGRPVerkäufergruppenvarchar30
161CE4IDES_ACCTErgebnisbereich IDES49VKGRPVerkäufergruppenvarchar30
162CE4IDES_FLAGErgebnisbereich IDES45VKGRPFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
163CE4IDES_KENCErgebnisbereich IDES47VKGRPVerkäufergruppenvarchar30
164CE4INT1Ergebnisbereich IDES48VKGRPVerkäufergruppenvarchar30
165CE4INT1_ACCTErgebnisbereich IDES49VKGRPVerkäufergruppenvarchar30
166CE4INT1_FLAGErgebnisbereich IDES45VKGRPFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
167CE4INT1_KENCErgebnisbereich IDES47VKGRPVerkäufergruppenvarchar30
168CE4S001Sample operating concern21VKGRPSales Groupnvarchar30
169CE4S001_ACCTSample operating con29VKGRPSales Groupnvarchar30
170CE4S001_FLAGSample Operating Concern 125VKGRPFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
171CE4S001_KENCSample operating con26VKGRPSales Groupnvarchar30
172CE4S_GOQuickstart Template32VKGRPSales Groupnvarchar30
173CE4S_GO_ACCTQuickstart Template33VKGRPSales Groupnvarchar30
174CE4S_GO_FLAGQuickstart Template29VKGRPFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
175CE4S_GO_KENCQuickstart Template31VKGRPSales Groupnvarchar30
TOPRemaining Beverage - Obsolete Objects
176/BEV1/RBVBAKSales Document: Header Data22VKGRPSales Groupnvarchar30
TOPSales
177VAKGUSales Index: Quotation Validity7VKGRPSales Groupnvarchar30
178VAKPASales Index: Orders by Partner Function8VKGRPSales Groupnvarchar30
179VAPMASales Index: Order Items by Material11VKGRPSales Groupnvarchar30
180VBAKSales Document: Header Data22VKGRPSales Groupnvarchar30
181VEPVGDelivery Due Index16VKGRPSales Groupnvarchar30
TOPSales Activities
182VBKASales Activities16VKGRPSales Groupnvarchar30
TOPSales and Distribution SD enhancements
183/SAPMP/SD_LEIHGReturnable Packaging Settlement23VKGRPSales Groupnvarchar30
TOPSales Promotions
184VKAOFSales Index: Open Sales Activities5VKGRPSales Groupnvarchar30
185VKAWVSales Activities by Follow-up Date6VKGRPSales Groupnvarchar30
TOPShipping
186LIPSSD document: Delivery: Item data70VKGRPSales Groupnvarchar30
TOPSimulation
187VSVBAK_CNVersion: Sales document: Header data23VKGRPSales Groupnvarchar30
TOPTrading Contract
188TB2BWEBPROFILETrading Contract Web Profile Table7VKGRPSales Groupnvarchar30