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

20 columns | Print definition?ERP 6.0  | UPDATED

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/SHAAMWithholding tax for vendors from shaam12UPDATEDRecord updatednvarchar10
2/IWFND/D_SUB_CNTSubscription content5UPDATEDCreated Ondecimal150
3/IWFND/L_NOTIF_PPull-oriented Push Notification Data(ODC) Payload8UPDATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
4/UI2/EDM_PAGEUI2: Page6UPDATEDUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
5/UI2/EDM_USAGEUI2: page usage6UPDATEDUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
6/UI2/PB_C_PAGECache for UI2 Pagebuilding Service: Page Header8UPDATEDUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
7/UI2/PB_C_PAGEMCache for UI2 Pagebuilding Service: Page Header9UPDATEDUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
8CNV_MBT_DEL_TABSDMIS: Table for Data Deletion8UPDATEDBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
9ECPAO_EE_MGNRManagers and Org. Mgmt Fields for Employee Replication7UPDATEDIs Activenvarchar10
10EHPRCD_COD_PSNDPSN Declaration12UPDATEDEhfnd data element for time stampsdecimal150
TOPBusiness Planning and Simulation
11UPX_LAYOUTEnhanced Planning Layouts: Main Table6UPDATEDSystem Datenvarchar80
TOPDirect Bank Communication
12LWM_D_USER_BADGEPayment Approval App - User number of batches for the badge5UPDATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPEnergy Data Management
13EEDMIMPORTLOG_DBEDM Import Log: Database Table16UPDATEDImported Profile Values Indicatornvarchar10
TOPGreat Britain
14T5GEF01HR-GB: filing - Store parsed recording coming in from GG24UPDATEDRecord updated to Infotypenvarchar10
TOPLanguage Transport
15TLANSUPTALanguage Transport: Tables to Be Supplemented6UPDATEDProcessed Table Linesnvarchar80
TOPMaintenance Program Definition
16MPDCYCLEMPD: Cycle Data for Maintenance Document Items23UPDATEDMaintenance Plan Already Updatednvarchar10
TOPOffice Suite Program
17/OSP/T_RAUI_ROLETable to store multiple roles assigned to a report template.6UPDATEDFlagnvarchar10
TOPPrice Planning Workbench
18WRF_PPW_PPDVERSVersion-Dependent Header Data9UPDATEDChanged onnvarchar140
TOPProcess Monitoring Infrastructure
19SSPICSTRPRSPI: Tracking Record / Instance of Lower-Level Process5UPDATEDGlobal SPI: Boolean Valuetinyint30
TOPRole Generator
20/ISDFPS/AGR_TIMECycle Control Table for the Role Generator12UPDATEDGeneral Flagnvarchar10