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

34 columns | Print definition?ERP 6.0  | LINENUM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DFKKSAFTINV_ISAF-T Source Document: Item8LINENUMSAF-T Source Document Item Numbernvarchar60
2FIBKRUC_TACCRULESelection criteria4LINENUMLine numbertinyint30
3J_3RFREP_ATTRSELReporting Object Attribut Selections5LINENUMNumeric field: Length 6nvarchar60
4J_3RFREP_OBJSELTax reporting object selections4LINENUMNumeric field: Length 6nvarchar60
5TXX_C_RELA_GCDERelationships Between Segments3LINENUMSequential Numbernvarchar30
TOPAdvertising Management
6TJHCUSTENVCLUBIS-M: Cluster Builder Levels for Business Partner Environmnt1LINENUMIS-M: Sequence Number for Entrynvarchar30
7TJHCUSTENVCLUBHIS-M: Cluster Builder Hierarchy for Business Partner Envrnmt2LINENUMnvarchar30
8TJHCUSTENVCLUBSTIS-M: Texts for Structure Folders in the Cluster Builder1LINENUMIS-M: Sequence Number for Entrynvarchar30
9TJHCUSTENVCLUBTIS-M: Cluster Builder Levels for Business Partner Environmnt2LINENUMIS-M: Sequence Number for Entrynvarchar30
TOPBSI
10BTXFDOCBSI: Tax Formula Documentation5LINENUMBSI: Line numbernvarchar40
TOPCollectionsDisbursements
11INSCUSTENVCLUBLevels of the IS-U CIC Cluster Builder1LINENUMSequence Number for Entrynvarchar30
12INSCUSTENVCLUBHHierarchy of the IS-U CIC Cluster Builder2LINENUMSequence Number for Entrynvarchar30
13INSCUSTENVCLUBTLevels of the IS-U CIC Cluster Builder (Text Table)2LINENUMSequence Number for Entrynvarchar30
14TFSCD_COV_CLUBFSCD: Levels Cluster Builder Business Partner Environment1LINENUMIS-IS: Sequence Number for Entrynvarchar30
15TFSCD_COV_CLUBHFSCD: Hierarchy Cluster Builder Business Partner Environment2LINENUMIS-IS: Sequence Number for Entrynvarchar30
16TFSCD_COV_CLUBTIS-PS-CA: Set Hierarchy Cluster Builder Business Part. Envir2LINENUMIS-IS: Sequence Number for Entrynvarchar30
TOPData Retention Tool
17TXW_C_RELARelations of tables and domains3LINENUMRelation line numbernvarchar20
18TXX_C_RELARelationships Between Segments3LINENUMSequential Numbernvarchar30
TOPDatabase Monitors
19INFCFGDBGINFCFGCHECK: debugging, ...1LINENUMLogfile output line numberint100
TOPFront Office
20EWCUSTENVCLUBLevels of the IS-U CIC Cluster Builder1LINENUMSequential Number of Entrynvarchar30
21EWCUSTENVCLUBHHierarchy of the IS-U CIC Cluster Builder2LINENUMSequential Number of Entrynvarchar30
22EWCUSTENVCLUBTLevels of the IS-U CIC Cluster Builder (Text Table)2LINENUMSequential Number of Entrynvarchar30
TOPLocalization
23J_3RFF4ACCTCash flow statement accounts5LINENUMNumeric field: Length 6nvarchar60
24J_3RFF4PARACash flow statement additional parameters5LINENUMNumeric field: Length 6nvarchar60
25J_3RFTAX_OBJSELTax object selections4LINENUMNumeric field: Length 6nvarchar60
TOPPublic Sector Contract Accounts Receivable and Payable
26TFMCA_COV_CLUBIS-PS-CA: Set Hierarchy Cluster Builder Business Part. Envir1LINENUMSequential Number of Entrynvarchar30
27TFMCA_COV_CLUBHIS-PS-CA: Hierarchy Cluster Builder Business Partner Environ2LINENUMSequential Number of Entrynvarchar30
28TFMCA_COV_CLUBTIS-PS-CA: Set Hierarchy Cluster Builder Business Part. Envir2LINENUMSequential Number of Entrynvarchar30
TOPSecurity
29LAWINBOXDATALicense Measurement Data from Component Systems6LINENUMNumeric field 12nvarchar120
TOPUser Administration
30SPERS_GMAGeneric Personalization for MiniApps3LINENUMnvarchar80
31SPERS_GMASGeneric Personalization for MiniApps for Access by ITS3LINENUMnvarchar80
TOPWaste Management
32EWACUSTENVCLUBLevels of Waste CIC Cluster Builder1LINENUMSequential Number of Entrynvarchar30
33EWACUSTENVCLUBHHierarchy of Waste CIC Cluster Builder2LINENUMSequential Number of Entrynvarchar30
34EWACUSTENVCLUBTLevels of Waste CIC Cluster Builder (Text Table)2LINENUMSequential Number of Entrynvarchar30