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

35 columns | Print definition?ERP 6.0  | RUNDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/AANLCAsset-value fields, like anlc, for areas 11,12...79RUNDATESystem Datenvarchar80
2/ATL/FORECPYMNTForeclosure payments6RUNDATEDate on Which the Program Is to Be Runnvarchar80
3/GSINS/NLG_FILESGBA NL: Values of Importing/Exporting Reports2RUNDATEDate of Runnvarchar80
4/GSINS/NLG_FIMSGGBA NL: Link Import/Export Report to Incoming/Outgoing Msg2RUNDATEDate of Runnvarchar80
5/OPT/IT_BJLOGTable to store last run time stamp4RUNDATEDate of the Last Document Updatenvarchar80
6CNVCMIS_POSTPROSCMIS: Status table post-processing16RUNDATEDatenvarchar80
7HRBW_CNTB_DELTATime stamps for Payroll Reconcilliation Extractors5RUNDATEField of type DATSnvarchar80
TOPAccounting Interface
8GLE_ECS_DI_ADM0Management of ECS Direct Input8RUNDATEDate of Program Runnvarchar80
TOPBackground Processing
9TBTCRBatch scheduler execution time2RUNDATEBatch scheduler start datenvarchar80
TOPBatch-Oriented Parallel Processing of Mass Data
10BANK_PP_PARUNHDGeneral Data on Mass Runs (Header)11RUNDATEDate of Mass Runnvarchar80
TOPClaims Management
11IMP_TRIGGERSIMP: Trigger (Runtime)6RUNDATEIMP: Desired Execution Datenvarchar80
TOPCross-Application Components
12/OPT/VIM_LOAD_LGLog of data load3RUNDATESystem Datenvarchar80
TOPData Basis
13RSCNVMONTable to store the general data for Monitor7RUNDATELast Run Date for Conversion Requestnvarchar80
TOPFunds Management
14FMTC_SCHTOTLimit Treasury Schedules3RUNDATEnvarchar80
TOPGRC Access Control Plug-In
15/VIRSA/ALERTLISTCompliance Calibrator Alert List34RUNDATEDatenvarchar80
TOPInterestCharge Calculation
16BKKM3BCA: Parameters for Mass Runs in Parallel Processing10RUNDATEDate of Mass Runnvarchar80
17BKKMPARUNHDGeneral Data for Mass Runs (Header)9RUNDATEDate of Mass Runnvarchar80
TOPLocalization
18J_3RNDSINVTarget use of ingoing invoice positions for AuC42RUNDATERun datenvarchar80
19J_3RTSESecondary index table for VAT35RUNDATERun datenvarchar80
TOPMonitoring
20ALDBSTOOLCCMS Monitoring Arch.: Database Segment: MTE Method Data13RUNDATEAlert: datenvarchar80
TOPPayroll
21T7SKEC0009Logovacia tabulka pre EURO konverziu - IT 000910RUNDATEDátum poslednej zmenynvarchar80
22T7SKEC0011Logovacia tabulka pre EURO konverziu - IT 001110RUNDATEDátum poslednej zmenynvarchar80
TOPPerformance Assessment Workbench
23SLS_BLOGPAW - logging table for BAPIs5RUNDATEStart Datenvarchar80
24SLS_CEVENTPAW - Comments for an event5RUNDATEStart Datenvarchar80
25SLS_CPETPAW -Comments for an event / test / participant assignment3RUNDATEStart Datenvarchar80
26SLS_CXETPAW - Comments for an event / test assignment6RUNDATEStart Datenvarchar80
27SLS_LOGPAW - Logging Table (remake)7RUNDATEStart Datenvarchar80
28SLS_LOG2PAW - Logging Table (remake)7RUNDATEStart Datenvarchar80
29SLS_QPROTPAW - Batch Qualification Generation Protocol5RUNDATEPAW - Program Run Datenvarchar80
TOPSAP Business Partner
30BUT_TDAPPLIBP Non-Distributable Time-Dependent Data (from BUT_TDTRANS)3RUNDATEDate of Last Distribution Run for Time-Dependent BP Datadecimal150
TOPShared Service Center Framework
31SSCSRservice request in backend16RUNDATEService Request Run Datenvarchar80
TOPUSA
32BTXEERRBSI: Error messages3RUNDATEBSI: Run datenvarchar80
33BTXERESBSI: Employee/Employer tax3RUNDATEBSI: Run datenvarchar80
34BTXTERRBSI: Employee Payroll Error Message Grouping8RUNDATEBSI: Run datenvarchar80
35BTXTRESBSI: Tax Results8RUNDATEBSI: Run datenvarchar80