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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

33 columns | Print definition?ERP 6.0  | POSITION_DATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBack Office
1TRET_PROTOCOLTransactions Generated for Endowments3POSITION_DATEPosition Value Datenvarchar80
2TRET_TRANSACTIONTransactions to Be Created for Endowments3POSITION_DATEPosition Value Datenvarchar80
3TRFT_BUSTRANSTreasury: TRF Business Transaction6POSITION_DATEPosition Value Datenvarchar80
4TRFT_FLOWTreasury: Table with TRF Flows12POSITION_DATEPosition Value Datenvarchar80
5TRFT_MAN_POSTManual Posting7POSITION_DATEPosition Value Datenvarchar80
6TRFT_MATCH_TRANSTreasury: Matching Process Business Transaction6POSITION_DATEPosting Date for the Subledgernvarchar80
7TRFT_SUBTOTALTreasury: Table with TRF Transaction Figure3POSITION_DATEPosition Value Datenvarchar80
8TRFT_SUBTRANSTreasury: TRF Business Subtransaction3POSITION_DATEPosition Value Datenvarchar80
9TRST_CLASFLOCFM: Class Flows in Securities Account20POSITION_DATEPosition Value Datenvarchar80
10TRST_CLASFLO_REVCFM: Reversed Class Flows in Securities Account20POSITION_DATEPosition Value Datenvarchar80
11TRST_NOM_CORRTreasury: Nominal Adjustment7POSITION_DATEPosition Value Datenvarchar80
12TRST_POS_CHGCFM: Securities Account Position Change6POSITION_DATEPosition Value Datenvarchar80
13TRST_RECON_RCETreasury: External Securities Account Statement7POSITION_DATEKey Date in External Securities Account Statementnvarchar80
14TRST_SECACCTRANSTreasury: Securities Account Transfer11POSITION_DATEPosition Value Datenvarchar80
15TRST_SUBTOTALTreasury: Table with Trans.Figs - Class Pos. in Sec. Acct8POSITION_DATEPosition Value Datenvarchar80
TOPTransaction Manager
16BCKTCAT_FLOWBACKUP: Flow Table of Capital Actions11POSITION_DATEPosition Date - Corporate Actionnvarchar80
17BCKTERT_FLOWBACKUP: Flow Table for Executable Rights13POSITION_DATEPosition Date: Rights that can be Exercisednvarchar80
18SLDT_TRANSACTIONSubledger Distributor Business Transactions15POSITION_DATEPosition Value Datenvarchar80
19TCAT_FLOWFlow Table of the Corporate Actions14POSITION_DATEPosition Date - Corporate Actionnvarchar80
20TCORT_COSASecurity Account Transfer: Main Data9POSITION_DATEKey Date in External Securities Account Statementnvarchar80
21TCORT_COSAFLSecurity Account Transfer: Flows10POSITION_DATEPosition Value Datenvarchar80
22TCORT_COSAPOSecurity Account Transfer: Positions10POSITION_DATEPosition Value Datenvarchar80
23TERT_FLOWFlow Table for Rights that can be Exercised35POSITION_DATEPosition Date: Rights that can be Exercisednvarchar80
24TRDT_TRDBUSTRANSTreasury: Persistent distributor business transaction16POSITION_DATEPosting Date for the Subledgernvarchar80
25TRQT_BUSTRANSTreasury: Business Transactions7POSITION_DATEPosition Value Datenvarchar80
26TRQT_FLOWTreasury: Flow Data Quantity Ledger14POSITION_DATEPosition Value Datenvarchar80
27TRQT_LOTTreasury: Lot3POSITION_DATEPosition Value Datenvarchar80
28TRQT_LOTFLOWTreasury: Table with Lot Flows12POSITION_DATEPosition Value Datenvarchar80
29TRQT_SUBTOTALTreasury: Table with Quantity Ledger Position Trans. Figures3POSITION_DATEPosition Value Datenvarchar80
TOPTransfer to Financial Accounting
30TRLT_DERIVTRANSDerived Business Transactions8POSITION_DATEPosition Value Datenvarchar80
31TRSET_BUSTRANSOLD! Preliminary Solution: Transferred Sec. Bus.Transactions4POSITION_DATEPosting Date in the Documentnvarchar80
TOPTreasury and Risk Management
32TREAT_FLOWTreasury: TREA Flows9POSITION_DATEPosition Value Datenvarchar80
33TREAT_SUBTOTALTREA: Position Subtotal5POSITION_DATEPosition Value Datenvarchar80