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

22 columns | Print definition?ERP 6.0  | VALID_DATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2RX_RT_GPPayroll Result: Payroll for Global Employees8VALID_DATEDate that controls the processing of wage typesnvarchar80
TOPBasic Market Data
2/BA1/F4_FXRATESExchange Rates7VALID_DATEValidity Datenvarchar140
3/BA1/F4_INTRATE2Interest Rates for Reference4VALID_DATEValidity Datenvarchar140
4/BA1/F4_INTSPRDInterest Rates for Reference5VALID_DATEValidity Datenvarchar140
5/BA1/F4_SEC_RATEMarket Data: Securities Values3VALID_DATEValidity Datenvarchar140
6/BA1/F4_VOLAVERSVolatility Versions3VALID_DATEValidity Datenvarchar140
7/BA1/TF4_PRINFODefinition of Price Information6VALID_DATEValid-From Datenvarchar80
TOPDownloadUpload
8/DSD/HH_RAECDSD Route Settlement: Receipts/Expenditures12VALID_DATEPayment Cards: Valid Tonvarchar80
TOPFinancial Services Localization
9/GSINS/OLR_PTERMOpen Loss Reserves: Pre-Term Terminations /Insurance Premium2VALID_DATEValidity Datenvarchar80
10/GSINS/OLR_RCLCDOpen Loss Reserves: Reserve Calculation (Items)12VALID_DATEValidity Datenvarchar80
TOPLogistics Basic Data
11WRF_REF_HEADAssignment of a Reference Module to Material/Plant5VALID_DATEValid to Datenvarchar80
12WRF_REF_MODULEHeader Data for a Reference Module4VALID_DATEValid-to Date of a Reference Modulenvarchar80
TOPMaterial BOM
13/PLMI/RDLN_DATAMaster Data for Redlining7VALID_DATEValid-From Datenvarchar80
TOPOLAP Technology
14RSDDSTATLOGUSERUser Names for which Logging in the OLAP Stats Is On3VALID_DATESystem Datenvarchar80
TOPPatient Management
15N1TC_MATRIX_BUFMatrix Temporary Storage3VALID_DATEValid-To Datenvarchar80
TOPProfitability Analysis
16/EACA/TPMCUCHARConditional Characteristic Use Profitability Analysis5VALID_DATEField of type DATSnvarchar80
17TKECCUCO-PA: Conditional Usage of Segment-Level Characteristics6VALID_DATEDatenvarchar80
18TKECONDCO-PA: Formula Storage4VALID_DATEDatenvarchar80
19TKENCGCO-PA Net Change: Groups4VALID_DATEValid fromnvarchar80
TOPPublic Sector Contract Accounts Receivable and Payable
20DFMCA_BRF030BRF: Parameter for Checking Bank Data6VALID_DATEBRF: Expressionnvarchar200
21DFMCA_BRF051BRF: Parameter for Checking Address Data9VALID_DATEBRF: Expressionnvarchar200
TOPSAP Utilities
22TEAMI_MSGMessages15VALID_DATEValidity Date of Messagenvarchar80