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

53 columns | Print definition?ERP 6.0  | TKNUM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVTDMS_05_VTTKCollected Header Document Numbers for TDMS_Time-VTTK3TKNUMBELNR for CNVTDMS_05_*nvarchar100
2S950ES950 - Info structurelles5TKNUMNº du transportnvarchar100
3S951ES951 - Info structurelles5TKNUMNº du transportnvarchar100
TOPData Collection
4S950TRANSPORTS10TKNUMNº du transportnvarchar100
5S951TRANSPORTS210TKNUMNº du transportnvarchar100
TOPDownloadUpload
6/DSD/HH_DL_RECOVDSD: Download Recovery2TKNUMShipment Numbernvarchar100
7/DSD/HH_TRANSBELDSD: Documents for Shipment2TKNUMShipment Numbernvarchar100
TOPGoods Receipt Process
8BORGR_VTTP_NOEXNew inbound deliveries with references2TKNUMShipment Numbernvarchar100
TOPImplementation of Organizational Flexibility in Logistics
9/ISDFPS/REL_TPNRelocation Information for Shipment Document2TKNUMShipment Numbernvarchar100
TOPLocalization
10J_1I_INBDELVINBOUND DELIVERY DETAILS FROM sus3TKNUMShipment Numbernvarchar100
TOPMain Process
11/VSO/M_I_BELEGInput Data: Deliveries (Vehicle Space Optimization)2TKNUMShipment Number (Vehicle Space Optimization)nvarchar100
12/VSO/M_I_DLY_HDRInput Data: Delivery Header (Vehicle Space Optimization)2TKNUMShipment Number (Vehicle Space Optimization)nvarchar100
13/VSO/M_I_DLY_ITMInput Data: Delivery Items (Vehicle Space Optimization)2TKNUMShipment Number (Vehicle Space Optimization)nvarchar100
14/VSO/M_I_PAL_DATInput Data: Pallets (Vehicle Space Optimization)2TKNUMShipment Number (Vehicle Space Optimization)nvarchar100
15/VSO/M_I_POSInput Data: Delivery Items (Vehicle Space Optimization)2TKNUMShipment Number (Vehicle Space Optimization)nvarchar100
16/VSO/M_I_SHP_HDRInput Data: Shipment Header (Vehicle Space Optimization)2TKNUMShipment Number (Vehicle Space Optimization)nvarchar100
17/VSO/M_I_STACKInput Data: Overstackability (Vehicle Space Optimization)2TKNUMShipment Number (Vehicle Space Optimization)nvarchar100
18/VSO/M_I_SUBVEHInput Data: Loading Bays (Vehicle Space Optimization)2TKNUMShipment Number (Vehicle Space Optimization)nvarchar100
19/VSO/M_I_TRANSInput Data: Relevant Shipment Fields (VSO)2TKNUMShipment Number (Vehicle Space Optimization)nvarchar100
20/VSO/M_I_VEHInput Data: Vehicle Data (Vehicle Space Optimization)2TKNUMShipment Number (Vehicle Space Optimization)nvarchar100
21/VSO/M_O_SHP_HDRResult Data: Shipment Header (Vehicle Space Optimization)2TKNUMShipment Number (Vehicle Space Optimization)nvarchar100
TOPMaterials Management
22/ISDFPS/VTTKDGEHS: Supplement Table for Exceptions (DG Data, Transport)2TKNUMShipment Numbernvarchar100
TOPPicking
23/VSO/P_HU_SYNCSynchronizing the Deliveries of a Shipment (HU Creation)3TKNUMShipment Numbernvarchar100
24/VSO/P_LOG_IDLog ID of a Shipment in Vehicle Space Optimization2TKNUMShipment Numbernvarchar100
25/VSO/P_PAL_TOAssignment VSO Packing Proposal Items to WM TO Items2TKNUMShipment Numbernvarchar100
26/VSO/P_RSLT_PLTHResult of VSO: Packing Proposal (Header Data)2TKNUMShipment Numbernvarchar100
27/VSO/P_RSLT_PLTIResult of VSO: Packing Proposal Items2TKNUMShipment Numbernvarchar100
28/VSO/P_RSLT_VHCLResult of VSO: Vehicle2TKNUMShipment Numbernvarchar100
TOPRemaining Beverage - Obsolete Objects
29/BEV1/RSCOERFCOCIS: Check-Out Entry2TKNUMShipment Numbernvarchar100
30/BEV1/RSFFRBIBatch Input Table for Collection Assignment3TKNUMShipment Numbernvarchar100
31/BEV1/RSFFRCHGeneral Information About Collection3TKNUMShipment Numbernvarchar100
32/BEV1/RSFFRHDHeader Data for Collection Assignment2TKNUMShipment Numbernvarchar100
33/BEV1/RSFFRINTable of Invoice Data3TKNUMShipment Numbernvarchar100
34/BEV1/RSFFROROrder Information for Account Assignment3TKNUMShipment Numbernvarchar100
35/BEV1/RSQUSEQuick Settlement2TKNUMShipment Numbernvarchar100
36/BEV1/RSVBFTCOCIS Document Flow for Shipment2TKNUMShipment Numbernvarchar100
37/BEV1/TRVTKTransportation Report - Times Spent at Customers2TKNUMShipment Numbernvarchar100
38/BEV1/TRVTPTransportation Report - Breaks2TKNUMShipment Numbernvarchar100
39/BEV1/TRVTSTransportation Report - Rest Periods2TKNUMShipment Numbernvarchar100
TOPRemote Logistics Management
40OIO_CNTNR_HSTContainer history6TKNUMShipment Numbernvarchar100
41OIO_RT_RTDOC_CTReturns document - container items4TKNUMShipment Numbernvarchar100
42OIO_SP_DFLDADefault loading areas4TKNUMLoading areanvarchar100
TOPStructures Workbench
43/ISDFPS/VEKPTRKTracking Table for Delivery HU in Shipment2TKNUMShipment Numbernvarchar100
TOPTraders and Schedulers Workbench
44OIJ03_LOVTSW: Table for Left on Vehicle Entries6TKNUMShipment Numbernvarchar100
45OIJ03_LOVGLREFTSW Gain loss/LOV Reference table4TKNUMShipment Numbernvarchar100
46OIJNOMHNomination Header27TKNUMShipment Numbernvarchar100
47OIJNOMHVERSNomination Header Version Table29TKNUMShipment Numbernvarchar100
48OIJ_SCHEDPlanned Schedule Lines35TKNUMShipment Numbernvarchar100
TOPTransportation
49VTFAShipment Document Flow2TKNUMShipment Numbernvarchar100
50VTSPStage of Transport / Item Allocation2TKNUMShipment Numbernvarchar100
51VTTKShipment Header2TKNUMShipment Numbernvarchar100
52VTTPShipment Item2TKNUMShipment Numbernvarchar100
53VTTSStage of Shipment2TKNUMShipment Numbernvarchar100