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

33 columns | Print definition?ERP 6.0  | LONGITUDE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OEE/MPH_COORDSObsolete5LONGITUDEObsoletedecimal3114
2/RCFUIX/LOCTNSLocation hierarchy5LONGITUDEGeo location longitudedecimal1512
3/SAPQUERY/TA03Geographical position of a city5LONGITUDELongitudefloat1516
4DSH_GEOCITYCheck table for GEOCITY stuff4LONGITUDELongitudefloat1516
5EHFNDD_SPLNG_SPLSample - #GENERATED#24LONGITUDEGeo Location for Longitudedecimal1512
6SNWD_AD_EXTExtension table for geo coordinates4LONGITUDEEPM HANA: Longitudefloat1516
7VERGEOCITYContext-Veri: Geographische Lage einer Stadt3LONGITUDEGeogr. Längefloat1516
TOPABAP Workbench, Java IDE and Infrastructure
8SGEOCITYGeographical position of a city5LONGITUDELongitudefloat1516
TOPCross-Application Components
9LWM_CC_LOCATIONlocation of issue3LONGITUDELongitudedecimal1613
TOPGeographical Functions
10GEOLOCGeo location (lon/lat/alt/...)3LONGITUDEGeo location longitudedecimal1512
11GEOT005Table Containing Geocoordinates at Country Level3LONGITUDEGeo location longitudedecimal1512
12GEOT005STable Containing Geocoordinates at Country- and Region Level4LONGITUDEGeo location longitudedecimal1512
13GEOZ5GOLDTable for ZIP5GOLD Geo-Coder (Zipcodes USA)7LONGITUDEGeo location longitudedecimal1512
TOPLOGFAS
14/ISDFPS/GEOLOCGeolocation Database Table14LONGITUDELongitudenvarchar80
TOPLogistics - General
15OIFSPBLPhysical Location - Master Data37LONGITUDEGeo location longitudedecimal1512
TOPMaintenance Orders
16/MRSS/D_ADDRESSStores Primary/Secondary address14LONGITUDEGeolocation Longitudedecimal1512
17/MRSS/D_GEO_GPSData table to hold actual GPS coordinates of a resource4LONGITUDEGeolocation Longitudedecimal1512
18/MRSS/D_GEO_ZIPPostal Codes for Georeferencing9LONGITUDEGeolocation Longitudedecimal1512
19/MRSS/D_TOUR_ATTAttributes of Tour (Centroid)6LONGITUDEGeolocation Longitudedecimal1512
TOPNetWeaver Demonstration
20SNWD_ADEPM: Address Table12LONGITUDEEPM: Longitudedecimal1512
TOPProcess Controls
21GRPC_BW_EVT_LOCPC Events: BI Location Id -> Region/Country/... mapping8LONGITUDELongitudedecimal1512
TOPProduction Network
22GHO_PRDENTY_TYPETable for Holding Oil and Gas Entity19LONGITUDEGeo location longitudedecimal1512
TOPStructures Workbench
23HRP1952DB Table for Infotype 195221LONGITUDEGeolocation Longitudedecimal1512
TOPTransportation Planning
24/DSD/RP_DEBGEOCustomer's Geo-Coordinates3LONGITUDEGeo location longitudedecimal1512
TOPTravel Management
25TA23ADRPredefined Addresses in Travel Management11LONGITUDEGeo location longitudedecimal1512
TOPTravel Planning
26FTPT_HOTEL_COORDHotel Coordinates6LONGITUDEGeo location longitudedecimal1512
27FTPT_HOTEL_DATAHotel Data7LONGITUDEGeo location longitudedecimal1512
28FTPT_REQUESTTravel Plan Requests32LONGITUDEGeo location longitudedecimal1512
29TA21LIATA Locations16LONGITUDELongitude of locationnvarchar70
30TA23HOTELSHotel Data7LONGITUDEGeo location longitudedecimal1512
TOPWorkbench Utilities
31GEOCITYABAP/4 book: Geographical position of a city3LONGITUDELongitudefloat1516
TOPWorkforce Management Core
32/SAPAPO/LRPLOCDDemand Locations7LONGITUDEGeo location longitudedecimal1512
33/SAPAPO/LRPLOCRWFM Supplied Location Table for Resources9LONGITUDEGeo location longitudedecimal1512