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  | RREFKONT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T037RTexts for T037S5RREFKONTAccount Assignment Reference in Financial Assets Managementnvarchar80
2T037SAccount Assignment References acc. to Transaction Type4RREFKONTAccount Assignment Reference in Financial Assets Managementnvarchar80
TOPBack Office
3TPMT_DEDOC_POSDerivatives Document: Document Item19RREFKONTAccount Assignment Reference in Financial Assets Managementnvarchar80
4TPMT_POS_IND_DEAllocation of Acct Assignment Reference to Position6RREFKONTAccount Assignment Reference in Financial Assets Managementnvarchar80
TOPLoans Management
5TDS1Possible assignees3RREFKONTAccount Assignment Reference in Financial Assets Managementnvarchar80
6TTONFTVDARLTest neue Fima: Grunddaten und VDARL31RREFKONTKontierungsreferenz in der Vermögensverwaltungnvarchar80
7TTONFTVZZBEPPTest neue FIMA: VZZBEPP26RREFKONTKontierungsreferenz in der Vermögensverwaltungnvarchar80
8VDARC_DOC_RECCarryforward Records for Reorganization of Loan Doc. Items67RREFKONTAccount Assignment Reference in Financial Assets Managementnvarchar80
9VDARLLoans17RREFKONTAccount Assignment Reference in Financial Assets Managementnvarchar80
10VDBEKIFlow Data: Document Header for Actual Record13RREFKONTAccount Assignment Reference in Financial Assets Managementnvarchar80
11VDBEKI_SHADOWShadow Table for VDBEKI (Restrictions)13RREFKONTAccount Assignment Reference in Financial Assets Managementnvarchar80
12VDBEPPFlow Data - Planned Item33RREFKONTAccount Assignment Reference in Financial Assets Managementnvarchar80
13VDBOBEPPBusiness Operation: Entered and Activated Flow Data33RREFKONTAccount Assignment Reference in Financial Assets Managementnvarchar80
14VDDEBTTRANSBorrower Change Without Capital Transfer27RREFKONTAccount Assignment Reference in Financial Assets Managementnvarchar80
15VDORDERBorrower's note loan order data21RREFKONTAccount Assignment Reference in Financial Assets Managementnvarchar80
16VDVORTRLoan carry-forward totals12RREFKONTAccount Assignment Reference in Financial Assets Managementnvarchar80
17VZFZE_VDBEKICentral Entry Table for Release Procedure16RREFKONTAccount Assignment Reference in Financial Assets Managementnvarchar80
18VZFZE_VDBEPPCentral Entry Table for Release Procedure36RREFKONTAccount Assignment Reference in Financial Assets Managementnvarchar80
TOPTransaction Manager
19IDCFM_BST_CFMAVCustomizing for Balance Sheet Transfer with VA (obsolete)7RREFKONTAccount Assignment Reference of Position Managementnvarchar120
20IDCFM_BST_CFMITCustomizing for Balance Sheet Transfer for Brazil (obsolete)6RREFKONTAccount Assignment Reference in Financial Assets Managementnvarchar80
21IDCFM_BST_CFMIT1Customizing for Balance Sheet Transfer for Brazil (obsolete)6RREFKONTAccount Assignment Reference of Position Managementnvarchar120
22IDCFM_BST_CUSAVCustomizing for Balance Sheet Transfer for Brazil (obsolete)8RREFKONTAccount Assignment Reference in Financial Assets Managementnvarchar80
23IDCFM_BST_CUSTITCustomizing for Balance Sheet Transfer for Brazil7RREFKONTAccount Assignment Reference in Financial Assets Managementnvarchar80
24OTC_CONV_FHAPOBackup Table for Financial Transaction Flows25RREFKONTObsolete: Accnt Assignment Ref. in Fin. Assets Managementnvarchar80
25OTC_CONV_IFHAPOBackup Table for Underlying Transaction Flows23RREFKONTObsolete: Accnt Assignment Ref. in Fin. Assets Managementnvarchar80
26TZKN7Acct assignment reference via the invoice no.5RREFKONTAccount Assignment Reference in Financial Assets Managementnvarchar80
27VTBFHATransaction23RREFKONTObsolete: Accnt Assignment Ref. in Fin. Assets Managementnvarchar80
28VTBFHAPOTransaction Flow25RREFKONTObsolete: Accnt Assignment Ref. in Fin. Assets Managementnvarchar80
29VTBFHAPO_MIGRMigrated Financial Flows25RREFKONTObsolete: Accnt Assignment Ref. in Fin. Assets Managementnvarchar80
30VTBFHAPO_UNFIXEDNon-Fixed Financial Transaction Flows25RREFKONTObsolete: Accnt Assignment Ref. in Fin. Assets Managementnvarchar80
31VTBPFHAPOTreasury: Flow Shells24RREFKONTObsolete: Accnt Assignment Ref. in Fin. Assets Managementnvarchar80
32VTIFHAUnderlying transaction20RREFKONTObsolete: Accnt Assignment Ref. in Fin. Assets Managementnvarchar80
33VTIFHAPOUnderlying transaction flows23RREFKONTObsolete: Accnt Assignment Ref. in Fin. Assets Managementnvarchar80
34VWBEKITreasury Securities: Actual Flows - Header10RREFKONTAccount Assignment Reference in Financial Assets Managementnvarchar80
35VWBEPPTreasury Securities: Planned Flows114RREFKONTAccount Assignment Reference in Financial Assets Managementnvarchar80
36VWPBUKRCompany Code Position11RREFKONTAccount Assignment Reference in Financial Assets Managementnvarchar80
37VWPDEPOSecurities Account Position7RREFKONTAccount Assignment Reference in Financial Assets Managementnvarchar80
38VWVORTRSecurities: Carry-Forward Totals13RREFKONTAccount Assignment Reference in Financial Assets Managementnvarchar80
TOPTransfer to Financial Accounting
39TRACC_ACCASSREF1OLD: TR: Account Assignment Ref. Allocation Old->New3RREFKONTAccount Assignment Reference in Financial Assets Managementnvarchar80
40TRACC_MIG_AAREFMigration of Definitions of Account Assignment References4RREFKONTAccount Assignment Reference in Financial Assets Managementnvarchar80