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

59 columns | Print definition?ERP 6.0  | SECURITY_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1FTBB_YC_REF_ENTAttributes of Reference Entity5SECURITY_IDSecurity ID Numbernvarchar130
2TRCCT_TRANSCurrency Changeover Transaction11SECURITY_IDSecurity ID Numbernvarchar130
3TREAT_FUT_DIFFTreasury: TREA Differentiation for Deal Position4SECURITY_IDSecurity ID Numbernvarchar130
TOPBack Office
4TRET_POOLAdditional Pool Data for Fund7SECURITY_IDSecurity ID Numbernvarchar130
5TRET_SEC_POOLAdditional Pool Data for Security2SECURITY_IDInvestment Pool ID Numbernvarchar130
6TRFT_MATCH_TRANSTreasury: Matching Process Business Transaction8SECURITY_IDSecurity ID Numbernvarchar130
7TRST_CLASPOSTreasury: Class position in Securities Account5SECURITY_IDSecurity ID Numbernvarchar130
8TRST_NOM_CORRTreasury: Nominal Adjustment5SECURITY_IDSecurity ID Numbernvarchar130
9TRST_RECON_POSReconciliation Positions4SECURITY_IDSecurity ID Numbernvarchar130
10TRST_SECACCTRANSTreasury: Securities Account Transfer8SECURITY_IDSecurity ID Numbernvarchar130
TOPInformation System
11FTI_BI_REP_ODSReparation Records for Inconsistent Data in ODS 0CFM_O01 /BW10SECURITY_IDSecurity ID Numbernvarchar130
TOPProvisions for Awards
12ACE_SOP_SCRT_SECHypothetical Security Price Performance for Simulation3SECURITY_IDSecurity Identification Numbernvarchar130
TOPTransaction Management
13THXT_MD_PVmarket data present value7SECURITY_IDTreasury ID numbernvarchar130
14THXT_MD_SECmarket data securities price3SECURITY_IDTreasury ID numbernvarchar130
TOPTransaction Manager
15/TRMKR/SEC_DATAFWZZ Master Data Additional Fields2SECURITY_IDSecurity ID Numbernvarchar130
16BCKTCAT_FLOWBACKUP: Flow Table of Capital Actions6SECURITY_IDSecurity ID Numbernvarchar130
17BCKTERT_FLOWBACKUP: Flow Table for Executable Rights6SECURITY_IDSecurity ID Numbernvarchar130
18DIFT_POS_IDENTPersistent Flow Selectors13SECURITY_IDSecurity ID Numbernvarchar130
19FDC1Cash Management Shadow table12SECURITY_IDSecurity ID Numbernvarchar130
20IDCFM_DATA_SECValuation-Area-Independent Data for Securities6SECURITY_IDSecurity ID Numbernvarchar130
21IDCFM_FRIM_DATAImpairment Main Data6SECURITY_IDSecurity ID Numbernvarchar130
22IDCFM_FRIM_DEXPImpairment: BAdI Example Values: Expected & Expert Values6SECURITY_IDSecurity ID Numbernvarchar130
23MIGC_COM_VALCLSDerive General Valuation Class for Migration to CFM 1.03SECURITY_IDSecurity ID Numbernvarchar130
24POGT_POS_GUARDLock Objects27SECURITY_IDSecurity ID Numbernvarchar130
25RDPT_FACTOR2Treasury: Drawing Factor2SECURITY_IDSecurity ID Numbernvarchar130
26RDPT_FACTOR_HDR2Treasury: Drawing Factors Header2SECURITY_IDSecurity ID Numbernvarchar130
27RDPT_SETQuantity of Redemption Schedules3SECURITY_IDSecurity ID Numbernvarchar130
28SLDT_FLOWSubledger Distributor Transactions14SECURITY_IDSecurity ID Numbernvarchar130
29TCAT_FLOWFlow Table of the Corporate Actions9SECURITY_IDSecurity ID Numbernvarchar130
30TCORT_CODMDDeal: Main Data67SECURITY_IDSecurity ID Numbernvarchar130
31TCORT_COSAFLSecurity Account Transfer: Flows6SECURITY_IDSecurity ID Numbernvarchar130
32TCORT_COSAPOSecurity Account Transfer: Positions6SECURITY_IDSecurity ID Numbernvarchar130
33TCORT_SI_DERIVESettlement Instructions: Derivation table7SECURITY_IDSecurity ID Numbernvarchar130
34TERT_FLOWFlow Table for Rights that can be Exercised9SECURITY_IDSecurity ID Numbernvarchar130
35TERT_TRANSACTIONBusiness Transaction: Exercise of Rights4SECURITY_IDID number of exercised securities rightnvarchar130
36TPM_MIG_LOT_MIXDCFM: (Mig) ID Nos. by Coll. Pos. Man -> Corrspnd. PA by Lot5SECURITY_IDSecurity ID Numbernvarchar130
37TRCT_FLOWTable of business transactions flows10SECURITY_IDSecurity ID Numbernvarchar130
38TRDTT_DATA_ADMINLegacy Data Transfer Admin. Entries Business Transactions6SECURITY_IDSecurity ID Numbernvarchar130
39TRDTT_DATA_SECValuation-Area-Independent Data for Securities5SECURITY_IDSecurity ID Numbernvarchar130
40TRDTT_IGTDATA_SEIntragroup Transaction (IGT) Data for Securities6SECURITY_IDSecurity ID Numbernvarchar130
41TRDTT_POS_ADMINLegacy Data Transfer Admin. Entries Subledger Positions5SECURITY_IDSecurity ID Numbernvarchar130
42TRDTT_POS_SECPosition Information for Securities5SECURITY_IDSecurity ID Numbernvarchar130
43TRDTT_VADATA_FUTValuation-Area-Dependent Data for Futures6SECURITY_IDSecurity ID Numbernvarchar130
44TRDTT_VADATA_SECValuation-Area-Dependent Data for Securities6SECURITY_IDSecurity ID Numbernvarchar130
45TRDT_FLOWPersistent distributor flows12SECURITY_IDSecurity ID Numbernvarchar130
46TRGT_MIGPS_SECAssignment of PS Account Assignments to Securities Positions3SECURITY_IDSecurity ID Numbernvarchar130
47TRGT_MIGR_PMPConversion: Assign to Parallel Position Mangmnt Procedures3SECURITY_IDSecurity ID Numbernvarchar130
48TRLIT_AD_MIGRATEAccrual/Deferral: Log Data of Migration to EP 2:5SECURITY_IDContract Numbernvarchar130
49TRLT_VCL_FLOWFlows Valuation Class Transfer13SECURITY_IDSecurity ID Numbernvarchar130
50TWSPVSecurity Prices for Special Valuation4SECURITY_IDSecurity ID Numbernvarchar130
51VWPCSPREADCredit Spread per Security2SECURITY_IDSecurity ID Numbernvarchar130
TOPTransfer to Financial Accounting
52TLVT_MANUAL_VALBook Values for Manual Valuation of Positions7SECURITY_IDSecurity ID Numbernvarchar130
53TRACT_QUEUEResubmission for Reversal8SECURITY_IDSecurity ID Numbernvarchar130
54TRLT_BACKUPVORABBackup Flow Table from Preliminary Solution - Pos. Mgmt Sol.6SECURITY_IDSecurity ID Numbernvarchar130
55TRLT_INIT_IGT_SEInitialization Values for Intragroup Transactions7SECURITY_IDSecurity ID Numbernvarchar130
56TRLT_INIT_TRANSList of Initializing Business Transactions6SECURITY_IDSecurity ID Numbernvarchar130
57TRLT_INIT_VAL_FUInitialization Values for TRL Futures Positions6SECURITY_IDSecurity ID Numbernvarchar130
58TRLT_INIT_VAL_SEInitialization Values for TRL Positions: Securities7SECURITY_IDSecurity ID Numbernvarchar130
59VALT_SP_VAL_SECSecurity Prices and NPV for Special Valuation6SECURITY_IDSecurity ID Numbernvarchar130