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

102 columns | Print definition?ERP 6.0  | TPLST

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1MSPT_OIGSTD Shipment Header to store deleted records58TPLSTTransportation planning pointnvarchar40
2S950ES950 - Info structurelles3TPLSTPoint de planification du transportnvarchar40
3S951ES951 - Info structurelles3TPLSTPoint de planification du transportnvarchar40
4TMS_C_TRAExt. Transport Manag.: Determination of Transfer Relev. TRA2TPLSTTransportation planning pointnvarchar40
5TNAD8Output Control: Printers by Shipping Point4TPLSTTransportation planning pointnvarchar40
TOPConditions
6B022TrspPlPoint and Shipment Type4TPLSTTransportation planning pointnvarchar40
7B023TrspPlPoint, TrspProcessingType and Service Agent4TPLSTTransportation planning pointnvarchar40
TOPDangerous Goods Management
8TDGA9DG: Check Schema Determination Routines for Shipment Docs2TPLSTTransportation planning pointnvarchar40
9TDGB7DG: Assign DG check schemata for transport documents2TPLSTTransportation planning pointnvarchar40
10TDGD17EHS: Determ. Routine for Template Processing in Shipment2TPLSTTransportation planning pointnvarchar40
11TDGD19EHS: Validity Template Processing for Shipment Documents2TPLSTTransportation planning pointnvarchar40
TOPData Collection
12S050Shipment8TPLSTTransportation planning pointnvarchar40
13S050ES050 - Structural Information3TPLSTTransportation planning pointnvarchar40
14S051Shipment routes8TPLSTTransportation planning pointnvarchar40
15S051ES051 - Structural Information3TPLSTTransportation planning pointnvarchar40
16S052Means of transportation8TPLSTTransportation planning pointnvarchar40
17S052ES052 - Structural Information3TPLSTTransportation planning pointnvarchar40
18S053Shipment: shipping data8TPLSTTransportation planning pointnvarchar40
19S053ES053 - Structural Information3TPLSTTransportation planning pointnvarchar40
20S054Stages of shipment8TPLSTTransportation planning pointnvarchar40
21S054ES054 - Structural Information3TPLSTTransportation planning pointnvarchar40
22S055Shipment: materials8TPLSTTransportation planning pointnvarchar40
23S055ES055 - Structural Information3TPLSTTransportation planning pointnvarchar40
24S950TRANSPORTS8TPLSTPoint de planification du transportnvarchar40
25S951TRANSPORTS28TPLSTPoint de planification du transportnvarchar40
TOPDirect Store Delivery
26/DSD/C_OC_PRCDEFDef. of Sales Doc. Type & Item Usage for Price Determination3TPLSTTransportation planning pointnvarchar40
TOPDownloadUpload
27/DSD/HH_DRVTXTDSD: Download HH - Driver Messages3TPLSTTransportation planning pointnvarchar40
28/DSD/HH_TRADATDSD: Download HH - Volume of the Transferred Shipment Data3TPLSTTransportation planning pointnvarchar40
TOPFreight Processing
29TVFAPShipment Cost Information Profile Data3TPLSTTransportation planning pointnvarchar40
30TVFCSFPricing Procedure Determination2TPLSTTransportation planning pointnvarchar40
31TVFPAssignment of Purchasing Data for Shipment Costs2TPLSTTransportation planning pointnvarchar40
32TVFPTZTariff Zone Assignment for Postal Code Area2TPLSTTransportation planning pointnvarchar40
33TVFPTZHTariff Zone Assignment for Postal Code Area Header Data2TPLSTTransportation planning pointnvarchar40
34VFKPShipment Costs: Item Data14TPLSTTransportation planning pointnvarchar40
TOPGoods Receipt Process
35BORRTTSRoute schedule header (new)10TPLSTTransportation planning pointnvarchar40
TOPInterface to Terminal Automation System
36OIK01IS-OIL/TAS: LID Document Data78TPLSTTransportation planning pointnvarchar40
37OIK01DIS-OIL/TAS: deactivated LID Document Data79TPLSTTransportation planning pointnvarchar40
38OIKCFTAS - Control Field Data14TPLSTTransportation planning pointnvarchar40
39OIKCFWTAS - Control Field Data14TPLSTTransportation planning pointnvarchar40
40OIKLIDTAS active LIDs(NOTE:keep eq to DB OIKLIDW->append includes)45TPLSTTransportation planning pointnvarchar40
41OIKLIDRTD - TAS Reference Table45TPLSTTransportation planning pointnvarchar40
42OIKLIDWTAS LID Working version (NOTE: keep DB eq to DB OIKLID)45TPLSTTransportation planning pointnvarchar40
43OIKPEXLOCOIL: Status of gen. Location in ext. Transport Planning Sy4TPLSTTransportation planning pointnvarchar40
44OIKPEXORDStatus of Orders Within Transportation Planning4TPLSTTransportation planning pointnvarchar40
45OIKTPIRDTPI: SD doc. - obsolete - but needed for XPRA ROIKXTPIREL17TPLSTTransportation planning pointnvarchar40
46OIKTTDSOIL-TPI: Transportation planning point additional data2TPLSTTransportation planning pointnvarchar40
47OIKTTDSTXOIL-TPI: Text IDs per TPP and interface type2TPLSTTransportation planning pointnvarchar40
48OIKVDTPI: Vehicle/Driver assignment6TPLSTTransportation planning pointnvarchar40
49TOIKDCPDelivery Confirmatio Process3TPLSTTransportation planning pointnvarchar40
TOPLogistics - General
50OIFSPBLPhysical Location - Master Data35TPLSTTransportation planning pointnvarchar40
51OIJTSTransport system (IS-Oil TSW standard/core object )20TPLSTTransportation planning pointnvarchar40
TOPMain Process
52/VSO/M_PLT_TPAssignment Plant to Transportation Planning Point (VSO)2TPLSTTransportation planning pointnvarchar40
TOPProduct Safety
53TCGR5EHS: Condition Schema for RGV Selection - Table 54TPLSTTransportation planning pointnvarchar40
TOPRemaining Beverage - Obsolete Objects
54/BEV1/RPDBLARTPermissible Delivery and Order Types for Dynamic Dispatch2TPLSTTransportation planning pointnvarchar40
55/BEV1/RPFADriver Master (Route Planning)3TPLSTTransportation planning pointnvarchar40
56/BEV1/RPFZVehicle Master (Route Planning)4TPLSTTransportation planning pointnvarchar40
57/BEV1/RPTORoute Master (Route Planning)4TPLSTTransportation planning pointnvarchar40
58/BEV1/RSCOBARTDifference Document Types for Check-Out3TPLSTTransportation planning pointnvarchar40
59/BEV1/RSZABSTARoute Settlement - Permiss. Settlem. Types per Shipment Type3TPLSTTransportation planning pointnvarchar40
60/DSD/LD_CR_STATDSD - LD: Load Delivery Shipment Status2TPLSTTransportation planning pointnvarchar40
61/DSD/LD_DFTVALDSD - LD: Load Delivery Standard Value3TPLSTTransportation planning pointnvarchar40
62/DSD/ME_CPT_USERData from Handheld User5TPLSTTransportation planning pointnvarchar40
63/DSD/ME_CPT_VEHIMaintenance Table for Vehicles in DSD Cockpit4TPLSTTransportation planning pointnvarchar40
TOPReporting
64VTSFFUpdating Sequence: Statistics Shipment2TPLSTTransportation planning pointnvarchar40
TOPRoute Settlement
65/DSD/SL_ASL_EXCLDSD: Control of Automatic Settlement8TPLSTTransportation planning pointnvarchar40
66/DSD/SL_TBSOASSMDSD Route Settlement: Settlement Office Determ. for Shipm.2TPLSTTransportation planning pointnvarchar40
TOPSCM Basis
67CIF_IMSHPIntegration Model Reference Table for Shipments2TPLSTTransportation planning pointnvarchar40
TOPStock Visibility
68/DSD/SV_LC_CUSCustomizing Settings for Loading Confirmation Dialog2TPLSTTransportation planning pointnvarchar40
69/DSD/SV_LC_HDDSD LC: Loading Confirmation Header6TPLSTTransportation planning pointnvarchar40
TOPTour Status
70/DSD/ST_CSCEN_SHAssignment shipment <-> delivery scenario4TPLSTTransportation planning pointnvarchar40
71/DSD/ST_CTYPE_SHShipment relevant for DSD3TPLSTTransportation planning pointnvarchar40
72/DSD/ST_STATUSCurrent tour status12TPLSTTransportation planning pointnvarchar40
TOPTraders and Schedulers Workbench
73B453Shpm.type/Carrier/Inspector/Shipper/TranSys/TrspPlanPt9TPLSTTransportation planning pointnvarchar40
74OIJHCT01OIL-TSW: Ticket Holding Table (Draft version 1) - OBSOLETE23TPLSTTransportation planning pointnvarchar40
75OIJNOMHNomination Header71TPLSTTransportation planning pointnvarchar40
76OIJNOMHVERSNomination Header Version Table64TPLSTTransportation planning pointnvarchar40
77OIJ_EL_TICKET_HUniversal ticket table8TPLSTTransportation planning pointnvarchar40
78TOI0_REL_SDIS-OIL: Relevance customizing for SD Documents20TPLSTTransportation planning pointnvarchar40
TOPTransportation
79TTDSOrganizational Unit: Transportation Scheduling Point2TPLSTTransportation planning pointnvarchar40
80TTDSTOrganizational Unit: Transportation Scheduling Point: Texts3TPLSTTransportation planning pointnvarchar40
81TTPLSTDetermination of Transportation Planning Point f. BAPI Call4TPLSTTransportation planning pointnvarchar40
82TVARSArchiving Control Shipment2TPLSTTransportation planning pointnvarchar40
83TVT_CA_TRATransportation Basis Data for Forwarding Agent3TPLSTTransportation planning pointnvarchar40
84VTCFPPFreight Planning Transfer Profile3TPLSTTransportation planning pointnvarchar40
85VTDSTStatus of deliveries within transportation planning3TPLSTTransportation planning pointnvarchar40
86VTDSTCCondition of Deliveries for Freight Planning by Fwdng Agent22TPLSTTransportation planning pointnvarchar40
87VTLSTStatus of Gen. Location in Ext. Transportatn Planning System4TPLSTTransportation planning pointnvarchar40
88VTPRGTransport. planng system cumulation proc. for delivery item2TPLSTTransportation planning pointnvarchar40
89VTPRLTransportation Planning System Route Limitations2TPLSTTransportation planning pointnvarchar40
90VTTKShipment Header5TPLSTTransportation planning pointnvarchar40
TOPTransportation and Distribution
91B410Transportation Planning Point4TPLSTTransportation planning pointnvarchar40
92B411Transport Planning Point / Loading Plant4TPLSTTransportation planning pointnvarchar40
93OIGSTD Shipment Header58TPLSTTransportation planning pointnvarchar40
94TOIGTXTDefault Texts For Shipment Header3TPLSTTransportation planning pointnvarchar40
TOPTransportation Planning
95/BEV1/RPLMTCapacity Limit Dynamic Dispatch2TPLSTTransportation planning pointnvarchar40
96/DSD/RP_DRVTPLSTAssign Possible Transportation Planning Points to Driver3TPLSTTransportation planning pointnvarchar40
97/DSD/RP_FLTTPLSTTransportation Planning Point of a Vehicle3TPLSTTransportation planning pointnvarchar40
98/DSD/RP_LMTCapacity Limit: Dynamic Transportation Planning2TPLSTTransportation planning pointnvarchar40
99/DSD/RP_TOHTour Master, Header Data4TPLSTTransportation planning pointnvarchar40
TOPTransportation Planning Interface
100TOIKTPIRELTPI: Transportation Planning Point for Relevancy Type3TPLSTTransportation planning pointnvarchar40
TOPVisit Control
101/DSD/VC_DELIVERDSD: Delivery Types for DSD2TPLSTTransportation planning pointnvarchar40
102/DSD/VC_V7_PRNDSD: Message Types for Print Output for Shipment3TPLSTTransportation planning pointnvarchar40