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

70 columns | Print definition?ERP 6.0  | BUSTRANSID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BCKTRLIT_AD_TRANAccrual/Deferral Business Transactions Backup7BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
2BCKTRLT_VCL_FLOWFlows Valuation Class Transfer3BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
3TRCCT_TRANSCurrency Changeover Transaction3BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
4TRLT_BUSTRANS_BWTreasury Ledger Business Transactions for BW Extraction7BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
TOPBack Office
5TPMT_DEDOC_HDRDerivatives Document: Document Header10BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
6TRFT_BUSTRANSTreasury: TRF Business Transaction3BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
7TRFT_MAN_POSTManual Posting3BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
8TRFT_MATCH_TRANSTreasury: Matching Process Business Transaction3BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
9TRST_NOM_CORRTreasury: Nominal Adjustment14BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
TOPInformation System
10FTI_BI_REP_ODSReparation Records for Inconsistent Data in ODS 0CFM_O01 /BW3BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
TOPLoans Management
11TRLET_BUSTRANSOBSOLETE: Previous Solution: BOs Transferred from Loans Area6BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
12TTONFTVZZBEPPTest neue FIMA: VZZBEPP266BUSTRANSIDIdentifikator des Distributor-Geschäftsvorfallsvarbinary160
TOPTransaction Management
13TCHT_HD_SFGDTSFGDT Representation of Instruments17BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
14THXT_HR_TRANSTreasury: Hedging Relationship Transactions6BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
15THXT_MD_HEADERmarket data: header information3BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
TOPTransaction Manager
16FDC1Cash Management Shadow table3BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
17IDCFM_DATA_SECValuation-Area-Independent Data for Securities44BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
18SLDT_TRANSACTIONSubledger Distributor Business Transactions9BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
19TCAT_TRANSACTIONBusiness Transaction: Corporate Action8BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
20TCORT_COCorrespondence Administrative Data8BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
21TERT_TRANSACTIONBusiness Transaction: Exercise of Rights14BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
22TRADT_LOCKTR: Accrual/Deferral: TRL Position Lock7BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
23TRCT_BUSTRANSTable of business transactions3BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
24TRDTT_DATA_ADMINLegacy Data Transfer Admin. Entries Business Transactions15BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
25TRDTT_DATA_SECValuation-Area-Independent Data for Securities43BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
26TRDTT_DATSUB_ADMLegacy Data Trnsfr: Admin., Designation of Subposition6BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
27TRDTT_DES_ADMINLDT: Admin. of Bus.Trans.Designation in Hedging Relationship4BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
28TRDTT_IGTDATA_SEIntragroup Transaction (IGT) Data for Securities25BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
29TRDTT_VADATA_FUTValuation-Area-Dependent Data for Futures22BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
30TRDTT_VADATA_OTCValuation-Area-Dependent Data for MM, FX, OTC Derivatives.40BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
31TRDTT_VADATA_SECValuation-Area-Dependent Data for Securities67BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
32TRDTT_VAD_FUTSUBValuation Area-Dependent Data for Futures with Subpositions18BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
33TRDTT_VAD_OTCSUBVal.Area-Dependent Data for MM, FX, OTC Deriv. w. Subpos.31BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
34TRDTT_VAD_SECSUBValuation Area-Dependent Data for Securities w. Subpositions54BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
35TRDT_INIT_BTTRL Initialization: Transfer Business Transactions5BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
36TRDT_INIT_FIXTRL Initialization: Fix/Post Business Transactions5BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
37TRDT_TRDBUSTRANSTreasury: Persistent distributor business transaction9BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
38TRGT_MIG_BTACTData Table for Flows4BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
39TRLIT_AD_TRANSAccrual/Deferral Business Transactions (Documentation avail)6BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
40TRLT_TRANS_DELDeleted TRL Transactions (BW Only)4BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
41TRLT_VCL_FLOWFlows Valuation Class Transfer2BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
42TRLT_VCL_TRANSValuation Class Transfers3BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
43TRQT_BUSTRANSTreasury: Business Transactions3BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
44TRQT_INIT_LOT(obsolete)12BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
45TRQT_LOTTreasury: Lot5BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
46TRQT_VWVORTR_LOT(obsolete)14BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
47TRXT_TRANSACTIONTRM Tax Transactions3BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
48VTBFHAPO_MIGRMigrated Financial Flows177BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
49VWBEPITreasury Securities: Actual Flows - Item110BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
50VWBEPPTreasury Securities: Planned Flows165BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
51VWVORTRSecurities: Carry-Forward Totals18BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
TOPTransfer to Financial Accounting
52ADJT_TRANSACTIONTreasury: Reconciliation business transactions8BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
53TRACT_DOCUMENTTreasury: Accounting Adaptor Document3BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
54TRACT_QUEUEResubmission for Reversal2BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
55TRATT_TRANSAccount Assignment Reference Transfer Business Transactions7BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
56TRLT_BACKUPVORABBackup Flow Table from Preliminary Solution - Pos. Mgmt Sol.11BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
57TRLT_INIT_DESInit.Hedging Relationship: Bus.Trans.Mgmt, Designation4BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
58TRLT_INIT_IGT_SEInitialization Values for Intragroup Transactions27BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
59TRLT_INIT_POSAdmin. Table: (Obsolete as from Support Package 01)5BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
60TRLT_INIT_SUB_OTInit.Hedging Rel.: Data for MM, FX, OTC Deriv.with Subpos.55BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
61TRLT_INIT_SUB_SEInit.Hedging Relationship for Securities with Subpositions77BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
62TRLT_INIT_SUB_TRInit.Hedging Rel.: Bus.Trans.Mgmnt, Designation Subpositions6BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
63TRLT_INIT_TRANSList of Initializing Business Transactions2BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
64TRLT_INIT_VAL_FUInitialization Values for TRL Futures Positions24BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
65TRLT_INIT_VAL_LOInitialization Values for TRL Positions: Loans42BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
66TRLT_INIT_VAL_SEInitialization Values for TRL Positions: Securities77BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
67TRLT_TRANSACTIONTreasury Ledger Business Transactions6BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
68TRPRT_PAYMENTSPersistent Data for Payment Requests6BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
69TRSET_BUSTRANSOLD! Preliminary Solution: Transferred Sec. Bus.Transactions6BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160
TOPTreasury and Risk Management
70TREAT_FLOWTreasury: TREA Flows3BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160