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

40 columns | Print definition?ERP 6.0  | CHAIN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1COPC_ACCT_GROUPCOPC: account group for cash concentration11CHAINID for bank chainnvarchar100
2RSPCTRACETrace: Process chain1CHAINProcess Chainnvarchar250
TOPAnalyzer
3AFWCH_FCAT_SAMPAFW: Sample Customizing Characteristics29CHAINCharacteristic Value Indicatornvarchar10
TOPBasic Functions
4T854Financial statement items for consolidation10CHAINIndicator: contra itemnvarchar10
TOPBW Service API
5ROPC_BORProcess Chains Started (Workflow)2CHAINUUID in compressed formnvarchar250
6ROPC_WFBORWorkflow Processes Started2CHAINUUID in compressed formnvarchar250
TOPChargeback
7TWCBCHAINField Chain1CHAINCondition Contract: Field Chainnvarchar40
8TWCBCHAINCHKEAssignment of Check Classes for Customer Checks on Chains4CHAINCondition Contract: Field Chainnvarchar40
9TWCBCHAINCHKIAssignment of Check Classes for Standard Chain Checks2CHAINCondition Contract: Field Chainnvarchar40
10TWCBCHAINCHKI_RReuse: Standard Chain Checks Check Classes2CHAINCondition Contract: Field Chainnvarchar40
11TWCBCHAINCOCKEAssgnmt o. Chck Classes f. Cust. Chcks on Cust. Flds in Chns7CHAINCondition Contract: Field Chainnvarchar40
12TWCBCHAINFIELDSFields in a Field Chain1CHAINCondition Contract: Field Chainnvarchar40
13TWCBCHAINTField Chain Texts2CHAINCondition Contract: Field Chainnvarchar40
TOPConsolidation
14TF90FActive Field Catalog, Consolidation29CHAINCharacteristic Value Indicatornvarchar10
15TF90SBasis Field Catalog Consolidation (Fixed Fields)29CHAINCharacteristic Value Indicatornvarchar10
16TF91FField Catalog, Consolidation29CHAINCharacteristic Value Indicatornvarchar10
TOPData Collection
17TKAFField catalog for Accounting30CHAINCharacteristic Value Indicatornvarchar10
18TKCFSAP-EIS Field Catalog29CHAINCharacteristic Value Indicatornvarchar10
19TKCSBasic field catalog SAP-EIS (fixed fields)29CHAINCharacteristic Value Indicatornvarchar10
20TKCTABFIEEC-EIS: Table-specific field properties9CHAINCharacteristic Value Indicatornvarchar10
TOPData Staging
21RSPCINTERRUPTLOGTable for Interrupt Processes2CHAINProcess Chainnvarchar250
TOPIncentive and Commission Management ICM
22TCACSFCommissions: Field Catalog Search30CHAINCharacteristic Value Indicatornvarchar10
TOPInformation System
23TKAF_USER_APPD_MField Catalog for Customer Characteristics20CHAINCharacteristic Value Indicatornvarchar10
TOPInvestment Programs
24TAIFIM Drilldown: Characteristic Catalog30CHAINCharacteristic Value Indicatornvarchar10
TOPPayment Transactions
25FIBL_RPCODEMaster Data for Repetitive Code6CHAINID for bank chainnvarchar100
TOPPerformance Monitors TCC
26AMDSEffective size of tables and indexes in the database10CHAINNumber of rows requiring block chainingdecimal150
27DBSTATHORAActual size of tables on the database (history)10CHAINNumber of rows requiring block chainingdecimal150
28DBSTATTORAActual size of tables on the database10CHAINNumber of rows requiring block chainingdecimal150
TOPProduct Cost Planning
29TCHAINSNamen der Prozeßketten2CHAINProzesskettennamen bei Cattsnvarchar300
TOPProfitability Analysis
30TJBFField Catalog IS-B-PA29CHAINCharacteristic Value Indicatornvarchar10
31TJBSBase Field Catalog IS-B-PA (Fixed Fields)29CHAINCharacteristic Value Indicatornvarchar10
32TKEFCO-PA field catalog29CHAINCharacteristic Value Indicatornvarchar10
33TKESCO-PA Basis Field Catalog (fixed fields)29CHAINCharacteristic Value Indicatornvarchar10
TOPRisk Analysis
34JBRRMTKEFRM: Copy of CO-PA Field Catalog29CHAINCharacteristic Value Indicatornvarchar10
35JBRRMTKESRM: Base Field Catalog CO-PA Fix.Char./Basic Key Figures29CHAINCharacteristic Value Indicatornvarchar10
TOPTravel Planning
36FTPT_HOTEL_COORDHotel Coordinates3CHAINHotel Chainnvarchar30
37FTPT_HOTEL_DATAHotel Data3CHAINHotel Chainnvarchar30
38TA23HOTELSHotel Data3CHAINHotel Chainnvarchar30
TOPTreasury
39TTMRFField catalog for Risk Management29CHAINCharacteristic Value Indicatornvarchar10
40TTMRSBasis field catalog Risk Management (fixed fields)29CHAINCharacteristic Value Indicatornvarchar10