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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

187 columns | Print definition?ERP 6.0  | VKBUR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CADMC/00000510TVBUR5VKBURnvarchar40
2/1CADMC/00000516TVKBT6VKBURnvarchar40
3/1RA/0SD010MIItems for Class SD01 - Raw Data111VKBURSales Officenvarchar40
4/BIC/B0000176000PSA for 2LIS_11_VAHDR T90CLNT090 Sales Doc. Header36VKBURnvarchar40
5/BIC/B0000177000PSA for 2LIS_11_V_ITM T90CLNT090 Sls-Ship.Alloc.Item22VKBURnvarchar40
6/BIC/B0000178000PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item32VKBURnvarchar40
7/BIC/B0000179000PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule45VKBURnvarchar40
8/BIC/B0000180000PSA for 2LIS_11_V_SCL T90CLNT090 Sls-Ship.Alloc.Sch.35VKBURnvarchar40
9/BIC/B0000181000PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond.26VKBURnvarchar40
10/BIC/B0000183000PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item86VKBURnvarchar40
11/BIC/B0000185000PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item92VKBURnvarchar40
12/BIC/B0000186000PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond.67VKBURnvarchar40
13/SMD/MD_____011NSID-Tabelle fuer Sales Office3VKBURSales Officenvarchar40
14/SMERP/STG_PM001Data staging - Equipment complex table165VKBURSales Officenvarchar40
15/SMERP/STG_PM002Data staging - Functional Location complex table109VKBURSales Officenvarchar40
16/SMERP/STG_PM003Data staging - Equipment List Set - Hdr - complex tab165VKBURSales Officenvarchar40
17/SMERP/STG_PM008Data staging - Functional Loc. List Set - Hdr - complex tab109VKBURSales Officenvarchar40
18CE1PR22Périm. résultat IDES78VKBURAgence commercialenvarchar40
19CE2PR22Périm. résultat IDES62VKBURAgence commercialenvarchar40
20CE4PR22Périm. résultat IDES47VKBURAgence commercialenvarchar40
21CE4PR22_ACCTPérim. résultat IDES48VKBURAgence commercialenvarchar40
22CE4PR22_FLAGPérim. résultat IDES44VKBURFlag : caract. imputée manuellement ou via TKEZUnvarchar10
23CE4PR22_KENCPérim. résultat IDES46VKBURAgence commercialenvarchar40
24CMM_D_IDXCommodity Management: Index Table17VKBURSales Officenvarchar40
25FIEUC_SALESOFCSAFT : Sales offices for SAF-T Reporting5VKBURSales Officenvarchar40
26FIEUD_INVSUMMARYSAFT: FI Transaction Summary Information7VKBURSales Officenvarchar40
27GLPCA_CTProfit Center Documents128VKBURSales Officenvarchar40
28GLPCA_T_CTProfit Center Documents144VKBURSales Officenvarchar40
29KCONSConsent Data: Consent data provided for legal entity6VKBURSales Officenvarchar40
30MEV_D_AD_ITEM_SDPeriod-End Valuation: Accruals Document Item SD13VKBURSales Officenvarchar40
31MEV_D_WL_ITEMPeriod-end valuation: Worklist item40VKBURSales Officenvarchar40
32S905ES905 - Structure Information6VKBURSales Officenvarchar40
33TNAD3Output Control: Printers by Sales Office4VKBURSales Officenvarchar40
34ZEIM_LIPSSD document: Delivery: Item data69VKBURSales Officenvarchar40
35ZEIM_VBAKSales Document: Header Data23VKBURSales Officenvarchar40
TOPAccount Determination
36TVBVKOrganizational Unit: Sales Groups per Sales Office2VKBURSales Officenvarchar40
37TVKBTOrganizational Unit: Sales Offices: Texts3VKBURSales Officenvarchar40
38TVKBZOrg.Unit: Sales Office: Assignment to Organizational Unit5VKBURSales Officenvarchar40
TOPAccounting Interface
39GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)248VKBURSales Officenvarchar40
40GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)248VKBURSales Officenvarchar40
TOPAdvanced Returns Management
41MSR_C_ROPROPOSALMulti-Step Returns : Proposal values3VKBURSales Officenvarchar40
TOPAdvertising Management
42B220Output per Organizational Data, Confirmation, No Quasi7VKBURSales Officenvarchar40
43JHAKIS-M/AM: Order-Publishing-Media (Header Data)16VKBURSales Officenvarchar40
44JHAREV1IS-M/AM: Order Revenue Recognition Key Date Values33VKBURSales Officenvarchar40
45JHAREV3IS-M/AM: Order Revenue Recognition Key Date Quantities30VKBURSales Officenvarchar40
46JHFREV2IS-M/AM: Key Dates for Billing Document Revenue Recognition55VKBURSales Officenvarchar40
47JHFREV4IS-M/AM: Billing Document Revenue Recognition Key Date Qties52VKBURSales Officenvarchar40
48JHTFPIS-M/AM: Billing/Settlement Documents - Item63VKBURSales Officenvarchar40
49JHTVAABKIS-M/AM: Contract Settlement Header Data7VKBURSales Officenvarchar40
50JHTVBIS-M/AM: Contract Requirements6VKBURSales Officenvarchar40
51JHTVKOIS-M/AM: Contract6VKBURSales Officenvarchar40
52JHWWWTEMP_ORDERIS-M/AM: Temporary Table for Order Data from the Internet6VKBURSales Officenvarchar40
53JJTMXBIS-M: Media-Mix Package Element7VKBURSales Officenvarchar40
54JJTVVIS-M/AM: Media Sales Agent Contract6VKBURSales Officenvarchar40
55S481IS-M/AM: View of BP Sales Areas14VKBURSales Officenvarchar40
56S481ES481 - Structural Information9VKBURSales Officenvarchar40
57TJHCIC_ORDER_WSIS-M/AM: Order Fast Entry in CIC6VKBURSales Officenvarchar40
58TJHCNUMIS-M/AM: Number Range Interval per Sales Office2VKBURSales Officenvarchar40
59TJHPRINTIS-M/AM: Output Control5VKBURSales Officenvarchar40
60TJHWWW_JHAWIS-M/AM: Enter Classified Ad IAC: General Settings6VKBURSales Officenvarchar40
TOPAgency Business Global Trade
61WBRKAgency business: Header87VKBURSales Officenvarchar40
TOPAllocation
62AUVDIWorklist for Deliveries (Follow-on Doc. Generation)20VKBURSales Officenvarchar40
TOPBasic Functions
63TPVSOProduct Proposal: Online Procedure Determination5VKBURSales Officenvarchar40
64VETVGDelivery Due Index for Stock Transfer14VKBURSales Officenvarchar40
TOPBilling
65A146Customer Hierarchy7VKBURSales Officenvarchar40
66A147Customer Hierarchy (Sales Deal)7VKBURSales Officenvarchar40
67VBRPBilling Document: Item Data68VKBURSales Officenvarchar40
TOPChargeback
68WCOCOHCondition Contract: Header35VKBURSales Officenvarchar40
TOPConditions
69KONAAgreements6VKBURSales Officenvarchar40
TOPCosting
70COERSales Order Value Revenue71VKBURSales Officenvarchar40
TOPCross-Application Components
71VVBAKSales Document: Header Data23VKBURSales Officenvarchar40
TOPCustomer Master
72KNVVCustomer Master Sales Data41VKBURSales Officenvarchar40
TOPData Collection
73S002SIS: Sales Office Statistics10VKBURSales Officenvarchar40
74S002BIW1S002BIW1 * SIS: Sales office statistics5VKBURSales Officenvarchar40
75S002BIW2S002BIW2 * SIS: Sales office statistics5VKBURSales Officenvarchar40
76S002ES002 - Structural Information5VKBURSales Officenvarchar40
77S008Communications Table SD -> CO/Projects59VKBURSales Officenvarchar40
78S016SIS: Sales activities9VKBURSales Officenvarchar40
79S016ES016 - Structural Information4VKBURSales Officenvarchar40
80S260SD - Sales order21VKBURSales Officenvarchar40
81S260BIW1SD - Sales order21VKBURSales Officenvarchar40
82S260BIW2SD - Sales order21VKBURSales Officenvarchar40
83S261SD - Delivery note63VKBURSales Officenvarchar40
84S261BIW1SD - Delivery note63VKBURSales Officenvarchar40
85S261BIW2SD - Delivery note63VKBURSales Officenvarchar40
86S262SD - Billing document49VKBURSales Officenvarchar40
87S262BIW1SD - Billing document49VKBURSales Officenvarchar40
88S262BIW2SD - Billing document49VKBURSales Officenvarchar40
89S263SD - Sales order/delivery note18VKBURSales Officenvarchar40
90S263BIW1SD - Sales order/delivery note18VKBURSales Officenvarchar40
91S263BIW2SD - Sales order/delivery note18VKBURSales Officenvarchar40
92S264SD- Offer21VKBURSales Officenvarchar40
93S264BIW1S264BIW1 * SD - Quotation21VKBURSales Officenvarchar40
94S264BIW2S264BIW2 * SD - Quotation21VKBURSales Officenvarchar40
95S272Do not use!50VKBURSales Officenvarchar40
96S272BIW1Do not use!50VKBURSales Officenvarchar40
97S272BIW2Do not use!50VKBURSales Officenvarchar40
98S276Transfer BW: Vertriebsdaten37VKBURVerkoopkantoornvarchar40
99S276BIW1S276BIW1 * Transfer to BW: Sales and Distribution Data37VKBURSales Officenvarchar40
100S276BIW2S276BIW2 * BW Transfer: Sales and Distribution Data37VKBURSales Officenvarchar40
101S905Absatzplanung11VKBUROficina de ventasnvarchar40
TOPEquipment
102IEQT_WL_ITEMSInterim Statuses - Items109VKBURSales Officenvarchar40
103IEQT_WL_ITM_BACInterim Statuses - Items (Backup)110VKBURSales Officenvarchar40
TOPFunctional Locations
104ILOAPM Object Location and Account Assignment47VKBURSales Officenvarchar40
105ILOA_VSLocation & Account Assignment for PM Object (Version Table)48VKBURSales Officenvarchar40
TOPInformation System
106TJBW02IS-M/AM BW: Access to Time Slice Rule5VKBURSales Officenvarchar40
TOPLogistics - General
107WBHKTrading Contract: Header Data42VKBURSales Officenvarchar40
TOPMaintenance Notifications
108PMSDOPM organizational data for SD documents7VKBURSales Officenvarchar40
109QMELQuality Notification101VKBURSales Officenvarchar40
TOPMaintenance Orders
110TPMUSPM/SM - User default values40VKBURSales Officenvarchar40
TOPMaterial Maintenance
111TASSIGN_SD_VKBURHelp Table for Status Info on SD Maint. Views: Key VKBUR2VKBURSales Officenvarchar40
TOPMedia Product Sales and Distribution
112JKSDCOLLECTIS-M: (Obsolete): Collection10VKBURSales Officenvarchar40
113JKSDORDERINDEXIndex Table for IS-M Orders15VKBURSales Officenvarchar40
114JKSDPROTOCOLIS-M: Order Generation Log12VKBURSales Officenvarchar40
115JKSDPROTOCOL2IS-M: Log13VKBURSales Officenvarchar40
116JKSDREPROTOCOLIS-M: Return Release Log10VKBURSales Officenvarchar40
117JKSDRETURNCHECKIS-M: Quantity Check on Return8VKBURSales Officenvarchar40
118JKSDTRANSFERIS-M: BP Goods Transfer9VKBURSales Officenvarchar40
119JKSDT_SD_CON_GENIS-M: Table for Generating Contracts16VKBURSales Officenvarchar40
120JKSDUNSOLDIS-M: Header Data on Unsold Copies13VKBURSales Officenvarchar40
121JKSECONTRINDEXIndex Table for IS-M Contracts19VKBURSales Officenvarchar40
122S485IS-M: Sales Figures19VKBURSales Officenvarchar40
123S488Return Quantity Check23VKBURSales Officenvarchar40
TOPPeriodical Sales and Distribution
124B405Sales Organization/Distribution Channel/Division/Sales Off.7VKBURSales Officenvarchar40
125JKAKSales Order Header Data17VKBURIS-M/SD: Receiving Sales Officenvarchar40
126JKWWWTEMP_ORDERIS-M/SD: WWW Temporary Table for Order Data from Internet7VKBURSales Officenvarchar40
127JVTZAEM2Sales Order Header Data19VKBURSales Officenvarchar40
128S451IS-M/SD: Sales Office Statistics8VKBURSales Officenvarchar40
129S451ES451 - Structural Data3VKBURSales Officenvarchar40
130TJKWVIS-M/SD: External Connection - Sales Area Determination6VKBURSales Officenvarchar40
131TJKWWW_FIXIS-M/SD: WWW, Combinations of Fixed Order Values7VKBURSales Officenvarchar40
TOPPersonnel Administration
132PA0900HR Master Record: Infotype 0900 (Sales Data)25VKBURSales Officenvarchar40
TOPPOS Interface
133WVFBDRS Interface, Intermediate Buffer, Order Item FM58VKBURSales Officenvarchar40
TOPProduct Catalog
134TWICOSTOREOnline Stores12VKBURSales officenvarchar40
TOPProfit Center Accounting
135GLPCAEC-PCA: Actual Line Items83VKBURSales Officenvarchar40
TOPProfitability Analysis
136CE1850060VKBURSales Officenvarchar40
137CE1IDEAOp. Concern BR World78VKBURSales Officenvarchar40
138CE1IDESErgebnisbereich IDES78VKBURVerkaufsbüronvarchar40
139CE1INT1Ergebnisbereich IDES78VKBURVerkaufsbüronvarchar40
140CE1OC01Bike International73VKBURSales Officenvarchar40
141CE1S001Sample operating concern52VKBURSales Officenvarchar40
142CE2850044VKBURSales Officenvarchar40
143CE2IDEAOp. Concern BR World62VKBURSales Officenvarchar40
144CE2IDESErgebnisbereich IDES62VKBURVerkaufsbüronvarchar40
145CE2INT1Ergebnisbereich IDES62VKBURVerkaufsbüronvarchar40
146CE2OC01Bike International57VKBURSales Officenvarchar40
147CE2S001Sample operating concern40VKBURSales Officenvarchar40
148CE4850029VKBURSales Officenvarchar40
149CE48500_ACCT30VKBURSales Officenvarchar40
150CE48500_FLAG26VKBURFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
151CE48500_KENC28VKBURSales Officenvarchar40
152CE4IDEAOp. Concern BR World47VKBURSales Officenvarchar40
153CE4IDEA_ACCTOp. Concern BR World48VKBURSales Officenvarchar40
154CE4IDEA_FLAGOp. Concern BR World44VKBURFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
155CE4IDEA_KENCOp. Concern BR World46VKBURSales Officenvarchar40
156CE4IDESErgebnisbereich IDES47VKBURVerkaufsbüronvarchar40
157CE4IDES_ACCTErgebnisbereich IDES48VKBURVerkaufsbüronvarchar40
158CE4IDES_FLAGErgebnisbereich IDES44VKBURFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
159CE4IDES_KENCErgebnisbereich IDES46VKBURVerkaufsbüronvarchar40
160CE4INT1Ergebnisbereich IDES47VKBURVerkaufsbüronvarchar40
161CE4INT1_ACCTErgebnisbereich IDES48VKBURVerkaufsbüronvarchar40
162CE4INT1_FLAGErgebnisbereich IDES44VKBURFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
163CE4INT1_KENCErgebnisbereich IDES46VKBURVerkaufsbüronvarchar40
164CE4OC01Bike International42VKBURSales Officenvarchar40
165CE4OC01_ACCTBike International43VKBURSales Officenvarchar40
166CE4OC01_KENCBike International41VKBURSales Officenvarchar40
167CE4S001Sample operating concern27VKBURSales Officenvarchar40
168CE4S001_ACCTSample operating con35VKBURSales Officenvarchar40
169CE4S001_FLAGSample Operating Concern 131VKBURFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
170CE4S001_KENCSample operating con32VKBURSales Officenvarchar40
TOPRemaining Beverage - Obsolete Objects
171/BEV1/RBVBAKSales Document: Header Data23VKBURSales Officenvarchar40
TOPSales
172TVBUROrganizational Unit: Sales Offices2VKBURSales Officenvarchar40
173VAKGUSales Index: Quotation Validity6VKBURSales Officenvarchar40
174VAKPASales Index: Orders by Partner Function7VKBURSales Officenvarchar40
175VAPMASales Index: Order Items by Material10VKBURSales Officenvarchar40
176VBAKSales Document: Header Data23VKBURSales Officenvarchar40
177VEPVGDelivery Due Index15VKBURSales Officenvarchar40
TOPSales Activities
178VBKASales Activities15VKBURSales Officenvarchar40
TOPSales and Distribution
179/BGLOCS/SDCUSTIVSettings for INVOICE informations3VKBURSales Officenvarchar40
180IDVKBUR_BUPLAAssignment of Business Place to Sales Office2VKBURSales Officenvarchar40
TOPSales and Distribution SD enhancements
181/SAPMP/SD_LEIHGReturnable Packaging Settlement24VKBURSales Officenvarchar40
TOPSales Promotions
182VKAOFSales Index: Open Sales Activities4VKBURSales Officenvarchar40
183VKAWVSales Activities by Follow-up Date5VKBURSales Officenvarchar40
TOPShipping
184LIKPSD Document: Delivery Header Data54VKBURSales Officenvarchar40
185LIPSSD document: Delivery: Item data69VKBURSales Officenvarchar40
TOPSimulation
186VSVBAK_CNVersion: Sales document: Header data24VKBURSales Officenvarchar40
TOPTrading Contract
187TB2BWEBPROFILETrading Contract Web Profile Table6VKBURSales Officenvarchar40