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

195 columns | Print definition?ERP 6.0  | VBTYP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1RA/0SD010MIItems for Class SD01 - Raw Data110VBTYPSD document categorynvarchar10
2/1RA/0SD012MIItems for Class SD01 - Processable59VBTYPSD document categorynvarchar10
3/1RA/0SD014MIItems for Class SD01 - Processed59VBTYPSD document categorynvarchar10
4/ATL/SD_DOCUMENTSD Document Classifications3VBTYPSD document categorynvarchar10
5/BIC/B0000176000PSA for 2LIS_11_VAHDR T90CLNT090 Sales Doc. Header34VBTYPnvarchar10
6/BIC/B0000177000PSA for 2LIS_11_V_ITM T90CLNT090 Sls-Ship.Alloc.Item21VBTYPnvarchar10
7/BIC/B0000178000PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item31VBTYPnvarchar10
8/BIC/B0000179000PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule44VBTYPnvarchar10
9/BIC/B0000180000PSA for 2LIS_11_V_SCL T90CLNT090 Sls-Ship.Alloc.Sch.34VBTYPnvarchar10
10/BIC/B0000181000PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond.25VBTYPnvarchar10
11/BIC/B0000182000PSA for 2LIS_12_VCHDR T90CLNT090 Delivery Header Data34VBTYPnvarchar10
12/BIC/B0000183000PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item28VBTYPnvarchar10
13/BIC/B0000184000PSA for 2LIS_13_VDHDR T90CLNT090 Bill.Doc.Header Data29VBTYPnvarchar10
14/BIC/B0000185000PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item21VBTYPnvarchar10
15/BIC/B0000186000PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond.20VBTYPnvarchar10
16/SLCE/PR_SDMAINTSD Maintenance for Promoted Subitems2VBTYPSD document categorynvarchar10
17CNVA_PCREA_WIP_OLT PC Reorg Analysis: WIP Reconciliation results (Level 2)13VBTYPSD document categorynvarchar10
18CNV_20551_VBELNSales documents selected for deletion4VBTYPSD document categorynvarchar10
19CNV_20551_VBTYPSales document types in tables4VBTYPSD document categorynvarchar10
20IDGT_GTDMMapping of SAP Document and GT Document7VBTYPSD document categorynvarchar10
21J_1IEXIM_PROCESSEXIM : Process Data2VBTYPSD document categorynvarchar10
22J_1IEXM_DOC_FLOWEXIM : Document Flow2VBTYPSD document categorynvarchar10
23TINGURules for updating the index in SD documents2VBTYPSD document categorynvarchar10
24ZEIM_VBAKSales Document: Header Data9VBTYPSD document categorynvarchar10
TOPAccounting Interface
25GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)268VBTYPSD document categorynvarchar10
26GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)268VBTYPSD document categorynvarchar10
TOPAdditionals Management
27TWTCTRLControl table for procedures for additionals18VBTYPSD document categorynvarchar10
TOPAdvertising Management
28JHAKIS-M/AM: Order-Publishing-Media (Header Data)7VBTYPSD document categorynvarchar10
29JHAPIS-M/AM: Order-Publishing-Media Item6VBTYPIS-M/AM: Sales Document Categorynvarchar10
30JHAREV1IS-M/AM: Order Revenue Recognition Key Date Values38VBTYPSD document categorynvarchar10
31JHAREV3IS-M/AM: Order Revenue Recognition Key Date Quantities35VBTYPSD document categorynvarchar10
32JHFREV2IS-M/AM: Key Dates for Billing Document Revenue Recognition42VBTYPIS-M/AM: Sales Document Categorynvarchar10
33JHFREV4IS-M/AM: Billing Document Revenue Recognition Key Date Qties39VBTYPIS-M/AM: Sales Document Categorynvarchar10
34JHTFKIS-M/AM: Settlement Documents (Billing, Commission) - Header85VBTYPIS-M/AM: Sales Document Categorynvarchar10
35JHTVAABPIS-M/AM: Contract Settlement Item Data43VBTYPIS-M/AM: Sales Document Categorynvarchar10
36TJH05IS-M/AM: Billing: Document Types10VBTYPIS-M/AM: Sales Document Categorynvarchar10
37TJHAKIS-M/AM: Order-Publishing-Media: Sales Document Type11VBTYPIS-M/AM: Sales Document Categorynvarchar10
38TJHAPIS-M/AM: Order-Publishing-Media: Item Categories3VBTYPIS-M/AM: Sales Document Categorynvarchar10
TOPBasic Functions
39FDS1Cash Management & Forecast: Line Items of SD Documents6VBTYPSD document categorynvarchar10
40FTGKLLegal Control: Log (Up-to-Date)5VBTYPSD document categorynvarchar10
41FTGKLALegal Control: Log (Prestep for Archiving)5VBTYPSD document categorynvarchar10
42T182EControl Table for Customer Statistics2VBTYPSD document categorynvarchar10
43TVAKSales Document Types27VBTYPSD document categorynvarchar10
44TVFKBilling: Document Types13VBTYPSD document categorynvarchar10
45TVLKDelivery Types19VBTYPSD document categorynvarchar10
46TVLPDeliveries: Item Categories34VBTYPSD document categorynvarchar10
47VBBESales Requirements: Individual Records11VBTYPSD document categorynvarchar10
48VBBSSales Requirement Totals Record7VBTYPSD document categorynvarchar10
49VBUKSales Document: Header Status and Administrative Data23VBTYPSD document categorynvarchar10
TOPBasic functions
50VEPOPacking: Handling Unit Item (Contents)7VBTYPSD document categorynvarchar10
TOPBasic Functions
51VZLOGLog Analysis of x/y Tables11VBTYPSD document categorynvarchar10
TOPBasis Components
52ZDS400_VBAKTabelle für Beispielprogramm des ZDS4009VBTYPVertriebsbelegtypnvarchar10
53ZSALES_ORD_HEADSales Order Header (IDES DEMO)7VBTYPSD document categorynvarchar10
TOPBilling
54VBRKBilling Document: Header Data5VBTYPSD document categorynvarchar10
55VRKPASales Index: Bills by Partner Functions10VBTYPSD document categorynvarchar10
56VRPMASD Index: Billing Items per Material9VBTYPSD document categorynvarchar10
TOPComplaints and Returns
57/SPE/SHP_IDX_QISPL Returns Deliveries: Relevant for Quality Inspection11VBTYPSD document categorynvarchar10
TOPConstruction Equipment Management
58J_3GBELARTDocument Types4VBTYPCEM Document Categorynvarchar10
TOPContract Accounts Receivable and Payable
59FKK_JFRK_SHORTHeader Data for IS-M/SD Billing Document - Extracts18VBTYPSD document categorynvarchar10
TOPCosting
60COERSales Order Value Revenue22VBTYPSD document categorynvarchar10
61TCJO5Transfer of planned data from sales document3VBTYPSD document categorynvarchar10
TOPCross-Application Components
62VVBAKSales Document: Header Data9VBTYPSD document categorynvarchar10
63VVBUKSales Document: Header Status and Administrative Data23VBTYPSD document categorynvarchar10
TOPCustomer Bill of Services
64/SAPBOQ/HEADERHeader of service package BOQ8VBTYPSD document categorynvarchar10
TOPDangerous Goods Management
65TDGD13EHS: Validity Template Processing for Sales Documents3VBTYPSD Docum. Categs for Sales with Template/One-Time Mat. Proc.nvarchar10
66TDGD15EHS: Validity Template Processing for Shipping Documents3VBTYPSD Docum. Categs for Shipping with Templ./One-Time Mat.Proc.nvarchar10
67TDGD19EHS: Validity Template Processing for Shipment Documents3VBTYPSD Docum. Categs for Shipment with Templ./One-Time Mat.Proc.nvarchar10
TOPData Collection
68S008Communications Table SD -> CO/Projects19VBTYPSD document categorynvarchar10
69S009CAS: Last Documents12VBTYPSD document categorynvarchar10
70S014CAS Document Information12VBTYPSD document categorynvarchar10
71S260SD - Sales order18VBTYPSD document categorynvarchar10
72S260BIW1SD - Sales order18VBTYPSD document categorynvarchar10
73S260BIW2SD - Sales order18VBTYPSD document categorynvarchar10
74S261SD - Delivery note35VBTYPSD document categorynvarchar10
75S261BIW1SD - Delivery note35VBTYPSD document categorynvarchar10
76S261BIW2SD - Delivery note35VBTYPSD document categorynvarchar10
77S262SD - Billing document18VBTYPSD document categorynvarchar10
78S262BIW1SD - Billing document18VBTYPSD document categorynvarchar10
79S262BIW2SD - Billing document18VBTYPSD document categorynvarchar10
80S263SD - Sales order/delivery note14VBTYPSD document categorynvarchar10
81S263BIW1SD - Sales order/delivery note14VBTYPSD document categorynvarchar10
82S263BIW2SD - Sales order/delivery note14VBTYPSD document categorynvarchar10
83S264SD- Offer18VBTYPSD document categorynvarchar10
84S264BIW1S264BIW1 * SD - Quotation18VBTYPSD document categorynvarchar10
85S264BIW2S264BIW2 * SD - Quotation18VBTYPSD document categorynvarchar10
86VKMILog for Updating Open Credit Values (S066, S067)8VBTYPSD document categorynvarchar10
TOPData Retention Tool
87TXW_S_LIKPRetrieve LIKP from archive6VBTYPSD document categorynvarchar10
88TXW_S_VBRKRetrieve VBRK from archive22VBTYPSD document categorynvarchar10
TOPExtended Rebate
89BON_ENH_LEDGERReconciliation Accounts for Rebate Credit Memos5VBTYPSD document categorynvarchar10
TOPExternal Services
90ESLHService Package Header Data19VBTYPSD document categorynvarchar10
TOPExtra Charge
91/BEV1/ECMITDExtra Charge Reconciliation Accounts5VBTYPSD document categorynvarchar10
TOPFinancial Accounting
92/BGLOCS/SDFIMAPMapping between SD doc. types and FI doc. types VAT BG2VBTYPSD document categorynvarchar10
TOPFreight Processing
93TVTFShipment Cost Types3VBTYPSD document categorynvarchar10
94VFKKShipment Costs: Header Data3VBTYPSD document categorynvarchar10
95VFSIShipment Costs: Sub-item Data6VBTYPSD document categorynvarchar10
96VFZPCorrect Original Assignmen of Conditions5VBTYPSD document categorynvarchar10
TOPGeneral Ledger Reorganization
97FAGL_R_SDLOG_001Reorganization: Log of Non-Reorganized Sales Documents4VBTYPSD document categorynvarchar10
TOPIndustry Solution Oil
98TOI0_REL_SD_RANKIS-OIL: Ranking of SD relvance fields3VBTYPSD document categorynvarchar10
TOPIndustry-Specific Component Automotive
99DPSPPC_WD_ADDRMapping table: Formatting country - WD component/window3VBTYPSD document categorynvarchar10
TOPIntegration
100FKK_VBRK_SHORTHeader Data for SD Billing Document - Extracts19VBTYPSD document categorynvarchar10
TOPInterface to Terminal Automation System
101OIK01IS-OIL/TAS: LID Document Data2VBTYPSD document categorynvarchar10
102OIK01DIS-OIL/TAS: deactivated LID Document Data2VBTYPSD document categorynvarchar10
103OIK37IS OIL: Shadow table for SD document processing2VBTYPSD document categorynvarchar10
104OIKDCSDelivery confirmation status9VBTYPDocument category of subsequent documentnvarchar10
105OIKDCSTEPDelivery confirmation steps (temporary data)11VBTYPDocument category of subsequent documentnvarchar10
106OIKTPIDCTPI Relevance Fields and Ranking (by VBTYP)2VBTYPSD document categorynvarchar10
107OIKTPIPDTPI Rel.Fields - obsolete - but needed for XPRA ROIKXTPIREL2VBTYPSD document categorynvarchar10
108OIKTPIRDTPI: SD doc. - obsolete - but needed for XPRA ROIKXTPIREL2VBTYPSD document categorynvarchar10
109TOIKTRVLID TAS relevance determination2VBTYPSD document categorynvarchar10
TOPInterfaces
110VLBLExpress Delivery Company's Data Field2VBTYPSD document categorynvarchar10
111VTRKHTracking Data - Header2VBTYPSD document categorynvarchar10
112VTRKPTracking Data - Item2VBTYPSD document categorynvarchar10
113VXSITDLExpress Delivery Company: Meta Description Data Field5VBTYPSD document categorynvarchar10
TOPInventory Management
114MWXVM07MFields: Update Control of Module Pool SAPMM07M63VBTYPSD document categorynvarchar10
115MWZVM07MFields: Update Control of Module Pool SAPMM07M63VBTYPSD document categorynvarchar10
TOPLocalization
116IDMX_DI_DOCTYPDigital invoice Mexico: Document types (payment flows)1VBTYPSD document categorynvarchar10
117J_1IBILDETBilling Type Determination - India4VBTYPSD document categorynvarchar10
118J_1IDCLSDETDocument class Determination - India4VBTYPSD document categorynvarchar10
TOPLogistics - General
119OIG_TVFTKTD-F Determination: Valuation Class of Shipment Cost Items5VBTYPSD document categorynvarchar10
TOPMaterials Management
120/ISDFPS/DG_SUMDangerous Goods Management: Totalling in Trans. Processing2VBTYPSD document categorynvarchar10
TOPMedia Product Sales and Distribution
121JKSDORDERINDEXIndex Table for IS-M Orders20VBTYPSD document categorynvarchar10
TOPOther Functions
122WAPPTAppointments2VBTYPSD document categorynvarchar10
TOPPatient Accounting
123NVBRKIS-H: Billing document header data6VBTYPSD document categorynvarchar10
TOPPeriodical Sales and Distribution
124JFRKIS-M/SD: Billing - Header Data4VBTYPSD document categorynvarchar10
125JKAKSales Order Header Data7VBTYPSales document category, IS-Mnvarchar10
126JVTZAEM2Sales Order Header Data9VBTYPSD document categorynvarchar10
127TJAKIS-M/SD: Sales Document Type16VBTYPSales document category, IS-Mnvarchar10
128TJFKIS-M/SD: Billing Document Types13VBTYPSD document categorynvarchar10
129TJL11IS-M/SD: Object Types for Document Flow etc.10VBTYPSD document categorynvarchar10
TOPProduction and Revenue Accounting
130OIUCM_CONTRACTPRA Contracts9VBTYPSD document categorynvarchar10
TOPProfitability Analysis
131CEERRORCO-PA: Incorrect records from SD12VBTYPSD document categorynvarchar10
TOPRecycling Administration Core Functions
132J_7LC66REA Data Filters: Doc. Flow Evaluation Single Access4VBTYPSD document categorynvarchar10
133J_7LC67REA Data Filters: Filter Definition for Doc. Flow Evaluation2VBTYPSD document categorynvarchar10
134J_7LC671REA Data Filters: Doc. Flow Evaluation Sales Doc. Type2VBTYPSD document categorynvarchar10
135J_7LC672REA Data Filters: Document Flow Evaluation Billing Type2VBTYPSD document categorynvarchar10
136J_7LC673REA Data Filters: Document Flow Evaluation Delivery Type2VBTYPSD document categorynvarchar10
137J_7LC67TREA Data Filters: Filter Definition for Doc. Flow Evaluation3VBTYPSD document categorynvarchar10
138J_7LVBRKNON-SD Interface: Billing: Header Data5VBTYPSD document categorynvarchar10
TOPRemaining Beverage - Obsolete Objects
139/BEV1/BO_LEDGERReconciliation Accounts for Rebate Credit Memos5VBTYPSD document categorynvarchar10
140/BEV1/RBMITDRebate Reconciliation Accounts5VBTYPSD document categorynvarchar10
141/BEV1/RBVBAKSales Document: Header Data9VBTYPSD document categorynvarchar10
142/BEV1/REMIETERental Items: Shadow Table for VBAK/VBAP/VBEP14VBTYPRental Items: Document Categorynvarchar10
143/BEV1/TSSDBSPRColumn Reference for Main Table Statistics Telephone Sales14VBTYPSD document categorynvarchar10
144/BEV1/TSSDBTDTMain Table Statistics Data Telephone Sales - Line Types12VBTYPSD document categorynvarchar10
TOPResourcen Management
145RMXTT_TRIAL_FRMLTrial: Material Consumption (Formula)10VBTYPConsumption Typenvarchar10
TOPSales
146PVINXIndex of New Sales Documents for Product Proposal7VBTYPSD document categorynvarchar10
147VBAKSales Document: Header Data9VBTYPSD document categorynvarchar10
148VBPVSales Document: Product Proposal23VBTYPSD document categorynvarchar10
149VKDFSSD Index: Billing Initiator9VBTYPSD document categorynvarchar10
TOPSales Activities
150TVKKSales Activity Types7VBTYPSD document categorynvarchar10
151VBKASales Activities10VBTYPSD document categorynvarchar10
TOPSales and Distribution SD enhancements
152VSVBUK_CNSales Document: Header Status and Administrative Data24VBTYPSD document categorynvarchar10
TOPSelf-Billing Proced.
153VSBHDRIDoc Self-Billing Procedure w. Automatic Postings19VBTYPSD document categorynvarchar10
154VSBPLGProcessing Log: Self-Billing Procedure w. Autom. Postings14VBTYPSD document categorynvarchar10
TOPSerial Numbers
155SER01Document Header for Serial Numbers for Delivery11VBTYPSD document categorynvarchar10
156SER02Document Header for Serial Nos for Maint.Contract (SD Order)10VBTYPSD document categorynvarchar10
157T377XDocuments Allowed for Serial Number Management50VBTYPOptionality of Parameter Transfernvarchar10
TOPShipping
158LIKPSD Document: Delivery Header Data24VBTYPSD document categorynvarchar10
159SHP_IDX_GDSIOutbound Deliveries: Not Posted for Goods Issue16VBTYPSD document categorynvarchar10
TOPSimulation
160VSVBAK_CNVersion: Sales document: Header data10VBTYPSD document categorynvarchar10
TOPTraders and Schedulers Workbench
161OIJBRDDOCRundown item / document X-ref table for Batch - WILL EXPIR16VBTYPTSW Details document typenvarchar10
162OIJBRDNOMStock Projection item / nomination X-ref table15VBTYPSD document categorynvarchar10
163OIJDOCFLOIL-TSW : TICKET DOCUMENT FLOW TABLE Obsolete, do not use14VBTYPSD document categorynvarchar10
164OIJERRLOGTSW: Error log of create/change documents11VBTYPSD document categorynvarchar10
165OIJRDDOCRundown item / document X-ref table/ WILL EXPIRE IN FUTURE16VBTYPTSW Details document typenvarchar10
166OIJRDNOMStock Projection item / nomination X-ref table15VBTYPSD document categorynvarchar10
167OIJTCWLOIL-TSW: TC item worklist entries4VBTYPTSW Details document typenvarchar10
168OIJWLOIL-TSW: Worklist16VBTYPTSW Details document typenvarchar10
169OIJ_EL_CP_LAYTCharter party and laytime and demurrage agreement3VBTYPTSW Details document typenvarchar10
170OIJ_EL_CP_LOCCharter party contract: load and discharge locations3VBTYPTSW Details document typenvarchar10
171OIJ_EL_CP_PRODCharter contracts: products and product groups3VBTYPTSW Details document typenvarchar10
172OIJ_EL_DFLOW_SUBTSW - Document flow for sub items10VBTYPSD document categorynvarchar10
173OIJ_EL_DOC_EVRules for nomination events3VBTYPTSW Details document typenvarchar10
174OIJ_EL_DOC_FLOWOIL TSW: Document flow12VBTYPSD document categorynvarchar10
175OIJ_EL_DOC_H_REFOil TSW: Document header reference to nomination; not used3VBTYPTSW Details document typenvarchar10
176OIJ_EL_DOC_I_REFDocument item reference to nomination3VBTYPTSW Details document typenvarchar10
177OIJ_EL_DOC_MOTOil TSW: TSW Relevance of order item3VBTYPTSW Details document typenvarchar10
178OIJ_EL_DOC_M_MOTOIL TSW: TSW Details / Multiple MoT's3VBTYPTSW Details document typenvarchar10
179OIJ_EL_ELOG_SUBTSW: Error log for ticketing process at sub item11VBTYPSD document categorynvarchar10
180OIJ_EL_ERROR_LOGOIL-TSW: Error log for ticketing process15VBTYPSD document categorynvarchar10
181OIJ_EL_LAYT_EVLaytime start and end events3VBTYPTSW Details document typenvarchar10
182OIJ_EL_LAYT_INFLaytime terms3VBTYPTSW Details document typenvarchar10
183OIJ_NOMLTLaytime and demurrage for groups in nominations4VBTYPTSW Details document typenvarchar10
184S430SIS: (OIL-TSW) Sales document statistics by TSW object30VBTYPTSW Details document typenvarchar10
185S431PURCHIS: (OIL-TSW) Purchasing document stats by TSW object32VBTYPTSW Details document typenvarchar10
186TOI0_REL_DOCSSelect document types for relevance assignment3VBTYPSD document categorynvarchar10
187TOI0_REL_SDIS-OIL: Relevance customizing for SD Documents3VBTYPSD document categorynvarchar10
188TOIJ_EL_DOC_SETOil TSW: Control document flow and error log2VBTYPSD document categorynvarchar10
189TOIJ_EL_INCOMPIS-OIL TSW: Activate incompletion for sales and purchasing2VBTYPTSW Details document typenvarchar10
190TOIJ_EL_INC_FIS-OIL TSW: specify incompletion fields2VBTYPTSW Details document typenvarchar10
191TOIJ_EL_MVSCENTSW: Define Movement scenarios6VBTYPSD document categorynvarchar10
TOPTransportation
192TVTKShipment Types3VBTYPSD document categorynvarchar10
193VTRDIShipment Planning Index6VBTYPSD document categorynvarchar10
194VTTKShipment Header3VBTYPSD document categorynvarchar10
TOPWarehouse Management
195LTAKWM transfer order header55VBTYPSD document categorynvarchar10