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

185 columns | Print definition?ERP 6.0  | RANL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TDR01Valuation of loan contract3RANLContract Numbernvarchar130
2VDSEPA_AUTODEBRecords for new auto debit (SEPA direct debit)3RANLContract Numbernvarchar130
3VDSEPA_AUTODEB_ORecords for new auto debit (SEPA direct debit) (up to 604)3RANLContract Numbernvarchar130
4VDSEPA_MND_USGOverview of mandates used in Loans Management3RANLContract Numbernvarchar130
5VTIULUnderlying Objects4RANLSecurity ID Numbernvarchar130
6ZCMM_MTM_01MtM Persistency per Transaction68RANLSecurity ID Numbernvarchar130
TOPAccounting
7VDDUNN_DISPDunning run data per loan and dunning run4RANLContract Numbernvarchar130
8VDIOA_CALC_CFOriginal Documents Without Model Account Int. on Arrears4RANLContract Numbernvarchar130
9VDIOA_CALC_DETProgress (Interest) of Model Account IOA Calculation4RANLContract Numbernvarchar130
10VDIOA_CALC_HEADCalculation Details for Interest on Arrears Calculation4RANLContract Numbernvarchar130
TOPBack Office
11PINT_STOCKEXStock Exchange per Company Code and Class3RANLSecurity ID Numbernvarchar130
12TPMT_DEDOC_POSDerivatives Document: Document Item15RANLSecurity ID Numbernvarchar130
13TPMT_DEPAL_FLOWSListed Futures: Price Gain Records7RANLSecurity ID Numbernvarchar130
14TPMT_LOT_HEADERSingle Position Master Data for TR Position Management5RANLSecurity ID Numbernvarchar130
15TPMT_POS_IND_DEAllocation of Acct Assignment Reference to Position3RANLSecurity ID Numbernvarchar130
TOPBank Components
16JBSSICHRegulatory Reporting - Collateral8RANLContract Numbernvarchar130
TOPBasic Functions
17FDD1Cash mgmt and forecast-Loan line items-Memo records3RANLContract Numbernvarchar130
18FDT1CMF Line Items for Forex, Money Market, Derivatives17RANLSecurity ID Numbernvarchar130
19FDW1Cash Mgt and Forecast - Securities Line Items- Planned Flows3RANLSecurity ID Numbernvarchar130
TOPDefault Risk and Limit System
20KLSI05Single-Transaction-Related Collateral (Item)9RANLSecuritynvarchar130
21KLSI05_BAKBackup for Euro Changeover for Single-Tran.-Rel. Collateral9RANLSecuritynvarchar130
TOPFinancial Services
22VDBIW_DATAExtractor Flow Data - Data of Last Extraction5RANLContract Numbernvarchar130
TOPFlexible Real Estate Management
23VIGA3DARLLUM: Grundbuch - Abteilung III Darlehensanbindung7RANLVertragsnummernvarchar130
TOPGermany
24DSALBESCompare Balance List Position Trend3RANLContract Numbernvarchar130
25TZFUNDZuordnung Gattung Fonds zur Zuführungsart BAV1RANLKennnummer Wertpapiernvarchar130
TOPInformation System
26FTI_MARKET_VALSReporting: Buffer Table for Market Values - Position Crcy3RANLSecurity ID Numbernvarchar130
27FTI_MARKET_VALSTReporting: Buffer Table for Market Values - Evaluation Crcy3RANLSecurity ID Numbernvarchar130
TOPLoans Management
28CML_ARC_DOC_ADMHAdmin. Table for Reorganization of Loan Document Data3RANLContract Numbernvarchar130
29TDESRVDINVIPCML Corr.: Invoice Positions14RANLContract Numbernvarchar130
30TDRXXForeign currency loan with special coverage4RANLContract Numbernvarchar130
31TDTRLE_PARAMETERCML: Link Parallel Position Management per Company Code4RANLContract Numbernvarchar130
32TRDC_ADMLoan Document Data Summarization: Administration Table3RANLContract Numbernvarchar130
33TRDC_RECSummarization of Loan Document Items: Carryforward Records3RANLContract Numbernvarchar130
34TTKWGDATAWork Table for GBA 24c3RANLContract Numbernvarchar130
35TTONFTEXCLOANVom Vergleich ausgeschlossene Darlehen4RANLVertragsnummernvarchar130
36TTONFTVDARLTest neue Fima: Grunddaten und VDARL5RANLVertragsnummernvarchar130
37TTONFTVZZBEPPTest neue FIMA: VZZBEPP10RANLVertragsnummernvarchar130
38VDARC_DOC_ADMAdmin. Table for Reorganization of Loan Document Data3RANLContract Numbernvarchar130
39VDARC_DOC_INDIndex Table for the Loan Document Data Archiving15RANLContract Numbernvarchar130
40VDARC_DOC_RECCarryforward Records for Reorganization of Loan Doc. Items3RANLContract Numbernvarchar130
41VDARC_DOC_REC_EUCarry-Forward Recs of Loan Doc. Item Reorg. bef. EURO Convsn3RANLContract Numbernvarchar130
42VDARLLoans4RANLContract Numbernvarchar130
43VDARLDVSPrint and dispatch control data for VDARL4RANLContract Numbernvarchar130
44VDARLINSUREDo Not Use: Insurance Policies for Loan (Relationship Table)4RANLContract Numbernvarchar130
45VDARLOBJLoan objects relationship table3RANLContract Numbernvarchar130
46VDARLSICCollateral for loan (relationship table)3RANLContract Numbernvarchar130
47VDARL_EULoans: Currency Data Before EURO Conversion4RANLContract Numbernvarchar130
48VDARL_RPadContract - Repayment Plan Data4RANLContract Numbernvarchar130
49VDAUSZDrawings on Disbursement3RANLContract Numbernvarchar130
50VDAUSZ_EUDisbursement Drawings Before EURO Conversion3RANLContract Numbernvarchar130
51VDBEKIFlow Data: Document Header for Actual Record5RANLContract Numbernvarchar130
52VDBEKI_SHADOWShadow Table for VDBEKI (Restrictions)5RANLContract Numbernvarchar130
53VDBEPPFlow Data - Planned Item3RANLContract Numbernvarchar130
54VDBEPP_EUFlow Data / Planned Items Before EURO Changeover3RANLContract Numbernvarchar130
55VDBOBEPPBusiness Operation: Entered and Activated Flow Data3RANLContract Numbernvarchar130
56VDBOBEPP_EUFlow Data / Planned Items Before EURO Changeover3RANLContract Numbernvarchar130
57VDBOHEADBusiness Operation: Header4RANLContract Numbernvarchar130
58VDBOHEAD_EUBusiness Operation: Header4RANLContract Numbernvarchar130
59VDBOINSBusiness Operation Insurance Data4RANLContract Numbernvarchar130
60VDCAPTRCAPTR: Master Data of Capital Transfer4RANLContract Numbernvarchar130
61VDCBR_CONTROLData Selection for Credit Bureau3RANLContract Numbernvarchar130
62VDCBR_HISTHistory of Data Supplied to Credit Bureau3RANLContract Numbernvarchar130
63VDCBR_RES_DATATable of Data Reported to Credit Bureau (Per Loan)3RANLContract Numbernvarchar130
64VDCBR_RES_PARTPartner Data Reported to Credit Bureau (Pro Loan)3RANLContract Numbernvarchar130
65VDCFWAREHOUSECash Flow Management8RANLContract Numbernvarchar130
66VDCHARACDOCProcessing Characteristics: Change Documents4RANLContract Numbernvarchar130
67VDCHGPTRChange Pointers Loan5RANLContract Numbernvarchar130
68VDCHK_AWKEYStorage of unique links between FI and CML doc3RANLLoan numbernvarchar130
69VDCHK_DOC_IPPayments for Subsequent Posting4RANLContract Numbernvarchar130
70VDCHK_GROSS_NETStorage of data for report RFVD_GROSS_TO_NET5RANLLoan numbernvarchar130
71VDCHK_IOAResults of Interest on Arrears Check3RANLContract Numbernvarchar130
72VDCHK_TRL_REVVDCHK_TRL_REV4RANLLoan numbernvarchar130
73VDCORR_ALOILoans: Search Index for Correspondence (Document Finder)3RANLContract Numbernvarchar130
74VDCORR_CNTRLControl Table for Creation of Correspondence4RANLContract Numbernvarchar130
75VDDABData Transfer - Loans - Flows - Actual Records4RANLContract Numbernvarchar130
76VDDARLTable for entering loan numbers and customers1RANLContract Numbernvarchar130
77VDDASTTR-EDT: Transfer Loans3RANLContract Numbernvarchar130
78VDDEBTTRANSBorrower Change Without Capital Transfer4RANLContract Numbernvarchar130
79VDDEF_COUNTERNumber of Times in Arrears per Days Past Due Category4RANLContract Numbernvarchar130
80VDDUNNDunning run data per loan and dunning run4RANLContract Numbernvarchar130
81VDKOREFWorklist File for Bal. Sheet Transfer / Acct Assignment Ref.4RANLContract Numbernvarchar130
82VDLOANCHARACProcessing Characteristics per Loan4RANLContract Numbernvarchar130
83VDNOTEPAYEENote to Payee3RANLContract Numbernvarchar130
84VDORDERBorrower's note loan order data3RANLContract Numbernvarchar130
85VDORDER_EUOrder Data for Borrower's Note Loans Before EURO Conversion3RANLContract Numbernvarchar130
86VDPOPOFile item9RANLContract Numbernvarchar130
87VDPOST_CONTROLData Selection for Debit Position4RANLContract Numbernvarchar130
88VDREPAYMENTPayoff Master Data4RANLContract Numbernvarchar130
89VDRISKCLASSRisk Classification for Individual Value Adjustment4RANLContract Numbernvarchar130
90VDSDV4Loan collateral in acc. with BAV/PRF426RANLContract Numbernvarchar130
91VDSTATStatus table for loan CATT procedures2RANLContract Numbernvarchar130
92VDSTOP_VDARL_AAssign Stop to Loan3RANLContract Numbernvarchar130
93VDVORKTable for preemption conditions4RANLContract Numbernvarchar130
94VDVORTRLoan carry-forward totals3RANLContract Numbernvarchar130
95VDWORKLISTLoan Worklist for Postprocessing6RANLContract Numbernvarchar130
96VZFZE_VDAUSZCentral Entry Table for Release Procedure5RANLContract Numbernvarchar130
97VZFZE_VDBEKICentral Entry Table for Release Procedure8RANLContract Numbernvarchar130
98VZFZE_VDBEPPCentral Entry Table for Release Procedure6RANLContract Numbernvarchar130
99VZFZE_VDNBZECentral Entry Table for Release Procedure10RANLContract Numbernvarchar130
TOPMarket Risk Analyzer
100VTVSZWPKURScenario Database: Security Prices4RANLTreasury ID numbernvarchar130
101VTVSZWPKUVScenario Database: Security Price Volatilities4RANLTreasury ID numbernvarchar130
TOPMaster Data
102VDCLI_CNCL_DISBusiness Operation: CLI Rescission/Notice4RANLContract Numbernvarchar130
103VDDISBTEMPDisbursements That Were Not Released4RANLContract Numbernvarchar130
104VDESCROWGUIDEscrow Reference Table for VDARL4RANLContract Numbernvarchar130
TOPOutgoing Payments
105VDDISBDisbursement Specific Header Data4RANLContract Numbernvarchar130
TOPPortfolio
106VDARL_PAYM_PLANReferences from Premium Plans to Relevant Objects3RANLContract Numbernvarchar130
107VDBILL_CONTROLBill Control3RANLContract Numbernvarchar130
108VDBILL_HISTBilling History4RANLContract Numbernvarchar130
109VDCAPITALData for Capitalization of Overdue Items4RANLContract Numbernvarchar130
110VDCNCLRescission of Business Operation4RANLContract Numbernvarchar130
111VDDEFERRALDeferral Data4RANLContract Numbernvarchar130
112VDEXTSKIPMaster Data Extension and Skip4RANLContract Numbernvarchar130
TOPPortfolio Analyzer
113BMA_GUIDRANLOLD <<Boundary>> CFM-BM: Assignment of BMGUID-WPKN3RANLSecurity ID Numbernvarchar130
TOPReceivablesPayment Management
114VDAD_CONTROLTable with Dates for Auto Debit Run3RANLContract Numbernvarchar130
115VDAD_HISTAuto Debits, Historical Data3RANLContract Numbernvarchar130
116VDAD_RESULTResult Table for Auto Debit Collection3RANLContract Numbernvarchar130
117VDARL_RLSDirect Debits Per Contract4RANLContract Numbernvarchar130
TOPRemaining Beverage - Obsolete Objects
118/BEV3/CHABEWEALTTest Transfer Structure: Flow Records in Cash Flow Calcul.3RANLContract Numbernvarchar130
119/BEV3/CHAKONDALTTest transfer structure cash flow for conditions3RANLContract Numbernvarchar130
120/BEV3/CHASTEUControl Table2RANLContract Numbernvarchar130
TOPRisk Analysis
121JBRDBKOETRM: DB Table Header, HIERA and BEST Extended Cat.Prim.Trans.25RANLSecuritynvarchar130
122JBRHKOETRM: Version Table Header, HIERA and BEST Ext.Cat.Prim.Trans.26RANLSecuritynvarchar130
123JBRSVKOETRM: Header Table of Cat. of Prim. Trans for Saved Datasets24RANLSecuritynvarchar130
TOPTransaction Data Pool
124JBDBAENDPosition Changes10RANLSource Security ID Numbernvarchar130
125JBDEUROIndicator Table for EURO Conversion (CC)7RANLContract Numbernvarchar130
126JBDGSCHIS-B: Transaction Master Data29RANLContract Numbernvarchar130
127JBDMANPOSTLOANIndicator Table for Manual Postings4RANLContract Numbernvarchar130
128TJBD_VDARL_ARCHArchiving Status for Loans4RANLContract Numbernvarchar130
TOPTransaction Management
129TCHT_HD_FGETSFGDT FGET Structure23RANLSecuritynvarchar130
TOPTransaction Manager
130/TRMKR/SEC_CUSTCustomer Additional Data for Security Class2RANLSecurity ID Numbernvarchar130
131BCKVWBEPPBACKUP: Flow data - Position/Planned3RANLSecurity ID Numbernvarchar130
132BCKVWBWKMBACKUP: Flow table for corporate actions12RANLSecurity ID numbernvarchar130
133BCKVWORDEBACKUP: Order data13RANLSecurity ID numbernvarchar130
134BCKVWPAKTIBACKUP: Stock, subscription rights, investment certificates2RANLContract Numbernvarchar130
135BCKVWPANLABACKUP: Asset master2RANLSecurity ID Numbernvarchar130
136BCKVWPANLEBACKUP: Interest-bearing securities2RANLContract Numbernvarchar130
137BCKVWVORTRBACKUP: Carryover totals - securities3RANLContract Numbernvarchar130
138BCKVWZUORDBACKUP: SEC assignment table for restraints on disposal8RANLSecurity ID numbernvarchar130
139BCKVZSKOKOBACKUP: Condition header for stock, sub.rgt, invest., share.2RANLContract Numbernvarchar130
140IDCFMBRSETX_HSTHistory table for taxation17RANLSecurity ID Numbernvarchar130
141IDCFMBRSE_PSTCustomizing for creation of sales transactions for tax pmnts5RANLSecurity ID Numbernvarchar130
142IDCFMSETX_COMPCompensating method for Funds (TRM)5RANLSecurity ID Numbernvarchar130
143IDCFMSETX_CUSTCusotmizing for tax posting to FI for funds - Brazil4RANLSecurity ID Numbernvarchar130
144IDCFM_BST_HISTHistory table for balance sheet transfer for Brazil3RANLContract Numbernvarchar130
145OTC_CONV_FHAPOBackup Table for Financial Transaction Flows97RANLSecurity ID Numbernvarchar130
146TERTINERKOHeader Information for Executing Security Rights8RANLID number of exercised securities rightnvarchar130
147TERTVWBWERTRTM-PM: Flow Table for Executable Rights19RANLSecurity ID Numbernvarchar130
148TERTVWERPOExecutable Rights (Items)5RANLID number of sec. to be transferred for executable rightsnvarchar130
149TPMTVMFLPosition management variation margin flows at sec. account8RANLSecurity ID Numbernvarchar130
150TRGT_TRANS_REVALTable with Revaluation Structures for Transfer to TR Ledger4RANLSecurity ID Numbernvarchar130
151TRQT_VWVORTR_LOT(obsolete)3RANLContract Numbernvarchar130
152VTBFHATransaction50RANLSecurity ID Numbernvarchar130
153VTBFHAPOTransaction Flow97RANLSecurity ID Numbernvarchar130
154VTBFHAPO_MIGRMigrated Financial Flows97RANLSecurity ID Numbernvarchar130
155VTBFHAPO_UNFIXEDNon-Fixed Financial Transaction Flows97RANLSecurity ID Numbernvarchar130
156VTBFSECSecurities Collateral4RANLSecurity ID Numbernvarchar130
157VTPPOLICross-Securities-Account Position3RANLSecurity ID Numbernvarchar130
158VVTIERLEVELTier Level for2RANLSecurity ID Numbernvarchar130
159VWBEKITreasury Securities: Actual Flows - Header4RANLSecurity ID Numbernvarchar130
160VWBEPPTreasury Securities: Planned Flows3RANLSecurity ID Numbernvarchar130
161VWBWKMTRTM-PM: Flow table for corporate actions19RANLSecurity ID Numbernvarchar130
162VWKMPOCorporate actions (items)7RANLID no. of security to be transferred in corporate actionnvarchar130
163VWORDEOrder Data15RANLSecurity ID Numbernvarchar130
164VWPANINAssign Security Class to Security Index2RANLSecurity ID Numbernvarchar130
165VWPANLEInterest-bearing securities2RANLSecurity ID numbernvarchar130
166VWPBDEPBank Securities Account Position3RANLSecurity ID Numbernvarchar130
167VWPBUKRCompany Code Position3RANLSecurity ID Numbernvarchar130
168VWPDEPOSecurities Account Position3RANLSecurity ID Numbernvarchar130
169VWPTERMWarrants2RANLContract Numbernvarchar130
170VWPWPKUSecurity prices2RANLSecurity ID Numbernvarchar130
171VWT_DEFDEP_SECCFM: Default Value Securities Account per ID Number4RANLSecurity ID Numbernvarchar130
172VWVORTRSecurities: Carry-Forward Totals3RANLContract Numbernvarchar130
173VWZUORDSecurities Assignment Table for Restraints on Disposal15RANLSecurity ID Numbernvarchar130
174VZSKOKOCondition header for stock, subscrip.rights, investments2RANLContract Numbernvarchar130
TOPTreasury
175ATRASTreasury Rates Table3RANLTreasury ID numbernvarchar130
176FLQITEMD1_FCLiquidity Calculation: Forecast Line Items from Loans3RANLContract Numbernvarchar130
177TWX2Sec.-index class data2RANLSecurity ID Numbernvarchar130
178VTIDERIMaster Data Listed Options and Futures2RANLSecurity ID Numbernvarchar130
179VWPAKTIStock, subscription rights, investment certificates2RANLSecurity ID Numbernvarchar130
180VWPANLAAsset master for securities2RANLSecurity ID Numbernvarchar130
181VWPBONOSecurities listing3RANLSecurity ID Numbernvarchar130
182VWPT_FREE_ATTRFree Security Attributes2RANLSecurity ID Numbernvarchar130
183VWPZUSASecurities additional information3RANLSecurity ID Numbernvarchar130
TOPTreasury and Risk Management
184TZWR0Valuation in cross-depot3RANLContract Numbernvarchar130
185TZWR1Valuation in sec.acct position3RANLContract Numbernvarchar130