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

59 columns | Print definition?ERP 6.0  | VSART

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1A514ServcAgent/Ship.type5VSARTShipping type for shipment stagenvarchar20
2MSPT_OIGSTD Shipment Header to store deleted records39VSARTShipping typenvarchar20
TOPBasic Functions
3ANKPAsset classes: Fld Cont Dpndnt on Chart of Depreciation12VSARTAsset insurance typenvarchar20
4ANKVAsset classes: insurance types4VSARTAsset insurance typenvarchar20
5ANLVInsurance data6VSARTAsset insurance typenvarchar20
6T099Insurance types2VSARTAsset insurance typenvarchar20
7T099TDescription of Insurance Types3VSARTAsset insurance typenvarchar20
TOPClinical System
8N2DLV_RECEIVERi.s.h.med: Dispatch - Recipient9VSARTDispatch Type - Keynvarchar100
9TN2DLV_RECARTi.s.h.med: Dispatch Control - Recipient Types5VSARTDispatch Type - Keynvarchar100
10TN2DLV_VSARTi.s.h.med: Dispatch - Dispatch Types3VSARTDispatch Type - Keynvarchar100
11TN2DLV_VSART_Ti.s.h.med: Dispatch Control - Dispatch Type (Text)3VSARTDispatch Type - Keynvarchar100
TOPCollectionsDisbursements
12TKKVINVERDunning Information Procedure13VSARTDispatch Mediumnvarchar10
TOPConditions
13A135Transp. service agent/shipping type/bulk group5VSARTShipping type for shipment stagenvarchar20
14A508ServcAgent/Ship.type5VSARTShipping type for shipment stagenvarchar20
TOPFreight Processing
15TVFPTZTariff Zone Assignment for Postal Code Area4VSARTShipping typenvarchar20
16TVFPTZHTariff Zone Assignment for Postal Code Area Header Data4VSARTShipping typenvarchar20
17VFKPShipment Costs: Item Data15VSARTShipping type for shipment stagenvarchar20
TOPGermany
18PA0026HR Master Record: Infotype 0026 (Company Insurance)30VSARTInsurance typenvarchar40
19PA0126Infotype: Supplementary Pension Germany24VSARTPension Typenvarchar40
20T5D15EDI Funds9VSARTEDI - Encryption Typenvarchar20
21T5DP8Conversion of Infotype 0026 -> PAISY3VSARTInsurance typenvarchar40
TOPLogistics - General
22OIJTSTransport system (IS-Oil TSW standard/core object )5VSARTShipping typenvarchar20
23WBHDTrading Contract: Commercial Data56VSARTShipping typenvarchar20
TOPMaterials Management
24/ISDFPS/DG_EXCPTDG Management: Exception Requests DG Check OBSOLETE3VSARTShipping typenvarchar20
TOPPension Administration
25PA0782HR Master Record Infotype 078228VSARTPension Typenvarchar800
TOPPersonnel Administration
26PA0037HR Master Record: Infotype 0037 (Insurance)24VSARTInsurance typenvarchar40
TOPProduct Safety
27TCGR5EHS: Condition Schema for RGV Selection - Table 55VSARTShipping typenvarchar20
TOPPublic Sector
28PA0484HR Master Record Infotype 0484 (Joint Taxation A)24VSARTType of Taxationnvarchar40
29T5D5GSupplementary Pension Public Sector: Combination Table3VSARTInsurance Type to Be Reportednvarchar20
30T5D5GTInsurance Types for Supplementary Pension in Public Sector1VSARTInsurance Type to Be Reportednvarchar20
TOPPurchasing
31EKKOPurchasing Document Header92VSARTShipping typenvarchar20
32EKPOPurchasing Document Item123VSARTShipping typenvarchar20
TOPR2-R3 Link
33LDK04Communication Rec. 04 LVS Decentr.: DN Supplem. R/2 -> ERP13VSARTDispatch type from delivery document for WMS linknvarchar20
TOPSales
34VBKDSales Document: Business Data71VSARTShipping typenvarchar20
TOPShipping
35LDA01Decentralized WMS: Delivery Document Appendix12VSARTDispatch type from delivery document for WMS linknvarchar20
36LIKPSD Document: Delivery Header Data123VSARTShipping typenvarchar20
TOPSimulation
37VSVBKD_CNVersion: Sales document - commercial data72VSARTShipping typenvarchar20
TOPSwitzerland
38PA0046HR Master Record: Infotype 0046 (Company Pension Fund CH)24VSARTInsurance typenvarchar20
39T5C18Pension Funds - Insurance Types3VSARTKey specification for insurance typenvarchar20
40T5C1DTexts for Pension Funds4VSARTKey specification for insurance typenvarchar20
TOPTraders and Schedulers Workbench
41B450OIL-TSW: Carrier/Shipping Type5VSARTShipping typenvarchar20
42OIJNOMHNomination Header57VSARTShipping typenvarchar20
43OIJNOMHVERSNomination Header Version Table50VSARTShipping typenvarchar20
44OIJ_STAGESTSW (&TD) Shipment Stages15VSARTShipping type for shipment stagenvarchar20
TOPTransportation
45T173Routes: Mode of Transport for Each Shipping Type2VSARTShipping typenvarchar20
46T173TRoutes: Mode of Transport by Shipping Type: Texts3VSARTShipping typenvarchar20
47TGAVFDetermine Freight Code Set4VSARTShipping typenvarchar20
48TTPLSTDetermination of Transportation Planning Point f. BAPI Call3VSARTShipping typenvarchar20
49TVRABRoute Stages19VSARTShipping typenvarchar20
50TVRORoutes15VSARTShipping typenvarchar20
51TVRSZRoutes: Legs for each Route5VSARTShipping typenvarchar20
52TVTKShipment Types11VSARTShipping typenvarchar20
53VTRDIShipment Planning Index30VSARTShipping typenvarchar20
54VTTKShipment Header16VSARTShipping typenvarchar20
55VTTSStage of Shipment14VSARTShipping type for shipment stagenvarchar20
TOPTransportation and Distribution
56OIGSTD Shipment Header39VSARTShipping typenvarchar20
57OIGSSTD Shipment Stages15VSARTShipping type for shipment stagenvarchar20
58TOIGSTD Shipment Types39VSARTShipping typenvarchar20
TOPVehicle Management System
59VLCBATCHACTVELO : Variant for Action Execution in Batch75VSARTShipping typenvarchar20