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

107 columns | Print definition?ERP 6.0  | SBEWART

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TDB1Flow types for incoming payment rejections5SBEWARTFlow Typenvarchar40
2TDLOANFUNCFlow Types per Application Subfunction for Loans5SBEWARTFlow Typenvarchar40
3TISSR_MAP_FT_LOMapping: Country_Var / Loans-Flowtype / ISSR-Flowtype4SBEWARTBewegungsartnvarchar40
4TVZ02Definition of criteria/memo rec. grouping/inc.pmnt distrib.5SBEWARTFlow Typenvarchar40
5TVZ03Flow control of advance payments and overpayments10SBEWARTFlow Typenvarchar40
6TWB08Flow types per securities application subfunction5SBEWARTFlow Typenvarchar40
7TZB06Table of relationships between flow types (ref. flow types)5SBEWARTFlow Typenvarchar40
8TZB0TFlow types text table4SBEWARTFlow Typenvarchar40
9TZB11Activity-dependent one-time conditions7SBEWARTFlow Typenvarchar40
10VDPL_TRANS_ASSAssign Transactions4SBEWARTFlow Typenvarchar40
11VDSEPA_MND_USGOverview of mandates used in Loans Management16SBEWARTFlow Typenvarchar40
TOPAccounting
12TDIOA_FT_BALANCEAssignment of Flows to Flow Type Grouping - IOA Calculation5SBEWARTFlow Typenvarchar40
13TDIOA_NOPOSTCALCFlow Types Without Recalculation3SBEWARTFlow Typenvarchar40
14VDIOA_CALC_DETProgress (Interest) of Model Account IOA Calculation41SBEWARTFlow Typenvarchar40
15VDIOA_CALC_HEADCalculation Details for Interest on Arrears Calculation18SBEWARTFlow Typenvarchar40
TOPAssetLiability Management
16TTD_FLOW_MAPTime Deposit to Treasury Flow Map4SBEWARTFlow Typenvarchar40
TOPBack Office
17TPMT_DEDOC_POSDerivatives Document: Document Item21SBEWARTFlow Typenvarchar40
18TPMT_DEPAL_FLOWSListed Futures: Price Gain Records10SBEWARTFlow Typenvarchar40
TOPBank Components
19JBTBEWWERTAssignment of Flow Type to Value Fields4SBEWARTFlow Typenvarchar40
20JBTBEWZUSAAdditional Information for Flow Types3SBEWARTFlow Typenvarchar40
TOPFlexible Real Estate Management
21TIVHOIVGWEG-Mandate: Interne Vorgangsarten für Bankbewegungen3SBEWARTBewegungsartnvarchar40
22TIVHOSUPREinmalige Buchungen: Vorschlag Nebenkostenschlüssel2SBEWARTBewegungsartnvarchar40
23TIVPROTPK1Kontenfindung zum Buchungsvorgang: primär3SBEWARTprimäre Bewegungsartnvarchar40
24TIVPROTPK2Kontenfindung zum Buchungsvorgang: sekundär3SBEWARTprimäre Bewegungsartnvarchar40
25VIAKHO13WEG-Verwaltung: Umlage Eigentümerabrechnung35SBEWARTBewegungsartnvarchar40
26VIAKHO20WEG-Verwaltung: Guthaben/Forderungen Eigentümerabrechnung6SBEWARTBewegungsartnvarchar40
TOPInformation System
27TRGC_PAY_REL_LOPayment Relevance of Flow Type for Loans, Operative2SBEWARTFlow Typenvarchar40
TOPLoans Management
28TDB08Flow Types per Posting Application Additional Data4SBEWARTFlow Typenvarchar40
29TDCAP_CONDCondition amount for capitalization4SBEWARTFlow Typenvarchar40
30TDDEF_CONDCondition amount for deferral4SBEWARTFlow Typenvarchar40
31TDDEF_LIMITLimit table for deferral interest4SBEWARTFlow Typenvarchar40
32TDESRTZB0ACML Corr.: Sequence When Printing Items3SBEWARTCML Corr.: Relevant Flow Type for Invoice Printingnvarchar40
33TDFLOW_EXTPermitted Flow Types Per Region6SBEWARTFlow Typenvarchar40
34TDRP_FLOW_TYPERepayment schedule: relevant flow types5SBEWARTFlow Typenvarchar40
35TDWAIVE_BEWAFlow Types Excluded From Waiver Display4SBEWARTFlow Typenvarchar40
36TRDC_RECSummarization of Loan Document Items: Carryforward Records4SBEWARTFlow Typenvarchar40
37TRLET_LOAN_FLOWOBSOLETE: Previous Solution: Loans Flows Transferred14SBEWARTFlow Typenvarchar40
38TTONFTVZZBEPPTest neue FIMA: VZZBEPP15SBEWARTBewegungsartnvarchar40
39TVDSTPosting applications control table5SBEWARTFlow Typenvarchar40
40TVDSTXPosting applications control table6SBEWARTFlow Typenvarchar40
41TZB08Flow types per posting application6SBEWARTFlow Typenvarchar40
42TZB0JRelationship: Flow type - External flow type3SBEWARTFlow Typenvarchar40
43VDARC_DOC_INDIndex Table for the Loan Document Data Archiving16SBEWARTFlow Typenvarchar40
44VDARC_DOC_RECCarryforward Records for Reorganization of Loan Doc. Items4SBEWARTFlow Typenvarchar40
45VDARC_DOC_REC_EUCarry-Forward Recs of Loan Doc. Item Reorg. bef. EURO Convsn4SBEWARTFlow Typenvarchar40
46VDAUSZDrawings on Disbursement16SBEWARTFlow Typenvarchar40
47VDAVISPayment advice note table3SBEWARTFlow Typenvarchar40
48VDBEPIPosted line items for document header5SBEWARTFlow Typenvarchar40
49VDBEPI_SHADOWShadow Table for VDBEPI (Restrictions)5SBEWARTFlow Typenvarchar40
50VDBEPPFlow Data - Planned Item18SBEWARTFlow Typenvarchar40
51VDBOBEPPBusiness Operation: Entered and Activated Flow Data18SBEWARTFlow Typenvarchar40
52VDCFWAREHOUSECash Flow Management10SBEWARTFlow Typenvarchar40
53VDORDERBorrower's note loan order data14SBEWARTFlow Typenvarchar40
54VDREPAYMENTPayoff Master Data43SBEWARTPayoff Flow Typenvarchar40
55VDVORTRLoan carry-forward totals5SBEWARTFlow Typenvarchar40
56VDZVPayment Details for the Loan7SBEWARTFlow Typenvarchar40
57VZFZE_VDAUSZCentral Entry Table for Release Procedure18SBEWARTFlow Typenvarchar40
58VZFZE_VDBEPPCentral Entry Table for Release Procedure21SBEWARTFlow Typenvarchar40
TOPMarket Risk Analyzer
59VTVBEWZUMRMFlows Relevant to Market Risk3SBEWARTFlow Typenvarchar40
TOPMaster Data
60VDDISBTEMPDisbursements That Were Not Released6SBEWARTFlow Typenvarchar40
TOPPortfolio
61VDCOT_VER_CONConditions in the Condition Table6SBEWARTFlow Typenvarchar40
TOPPortfolio Analyzer
62PFAIM_FTYPEMATCHAssignment of Flow Types to PA Flow Types3SBEWARTFlow Typenvarchar40
TOPReal Estate Management
63IVBPLine Item (Settlement: Service Charge Collector) (Obsolete)32SBEWARTFlow Typenvarchar40
64TIV67Flow Types for Service Charge Key3SBEWARTFlow Typenvarchar40
65TIV68Flow types/SCKey for vacancy with tenant serv. charge sett.3SBEWARTFlow Typenvarchar40
66TIV8AAssignment Cost Type - Flow Type Directly Assigned Costs2SBEWARTFlow Typenvarchar40
67TIV99Allocation of Event-Oriented Fees to Transaction Types4SBEWARTFlow Typenvarchar40
68TIVBOLLOParameters Imposta di Bollo6SBEWARTFlow Typenvarchar40
69TIVFIRevenue elements for RE debit-side advance payments4SBEWARTFlow Typenvarchar40
70VIAK13Apportionment Result for List Evaluation (SCSettlement)34SBEWARTFlow Typenvarchar40
71VIAK14RA credit memo/receivable:now only used as structure!6SBEWARTFlow Typenvarchar40
72VIAK19Costs Directly Assigned to Lease-Out19SBEWARTFlow Typenvarchar40
73VIAK20RA credit memo/receivable (incid.exp.sttlmnt created)6SBEWARTFlow Typenvarchar40
74VIBEPPFlow data - Planned items for real estate management6SBEWARTFlow Typenvarchar40
75VIVW09Postings for management costs settlements8SBEWARTFlow Typenvarchar40
TOPReceivablesPayment Management
76TDNONDUEITEMS"Billed but Not Due" Charges5SBEWARTFlow Typenvarchar40
77TDPREPKRITFTFlow Type for Prepayment Criteria6SBEWARTFlow Typenvarchar40
78TDPREPKRITPRIOPriority of Prepayment Criteria11SBEWARTFlow Typenvarchar40
79TDSPECPAYMENTAssignment and Prioritizing of Flow Types to Payment Cat.6SBEWARTFlow Typenvarchar40
80TZB25Assign Flow Type to Flow Type Group3SBEWARTFlow Typenvarchar40
81TZB40Account Clearing: Excluded Flow Types3SBEWARTFlow Typenvarchar40
TOPRegulatory reporting for insurance companies
82TISSR_MASRFT_TRISSR: Zuordnung SBEWART zu MW-Bewegungsart3SBEWARTBewegungsartnvarchar40
83TZB0VUnterpositionen aus Bewegarten für OeNB-Meldung Österreich3SBEWARTBewegungsartnvarchar40
84TZB1VMelderelevante Bewegungsarten Österreich5SBEWARTBewegungsartnvarchar40
TOPRisk Analysis
85JBRVBRSPEZRM: Specific Settings for Summarization(with Valuation Rule)5SBEWARTFlow Typenvarchar40
86JBRVRCAAssignment of Flow Type to RM Cash Flow Type5SBEWARTFlow Typenvarchar40
87VTVBWCFAssignment of Flow Types to Cash Flow Indicator3SBEWARTFlow Typenvarchar40
TOPTransaction Data Pool
88JBDBEWEPosition Flows Generated by Position Changes16SBEWARTFlow Typenvarchar40
TOPTransaction Manager
89AT19Supplements to Flow Types3SBEWARTFlow Typenvarchar40
90BCKVWVORTRBACKUP: Carryover totals - securities6SBEWARTFlow Typenvarchar40
91IDCFM_BST_HISTHistory table for balance sheet transfer for Brazil6SBEWARTFlow Typenvarchar40
92TERTVWBWERTRTM-PM: Flow Table for Executable Rights20SBEWARTFlow Typenvarchar40
93TRDC_DFT_ASSIGNAssignment of Flow Types to Update Types4SBEWARTFlow Typenvarchar40
94TRQT_VWVORTR_LOT(obsolete)6SBEWARTFlow Typenvarchar40
95TWB08APermitted other flows (default)3SBEWARTFlow Typenvarchar40
96VTBZVPayment Details for Transaction7SBEWARTFlow Typenvarchar40
97VWBEPITreasury Securities: Actual Flows - Item13SBEWARTFlow Typenvarchar40
98VWBEPPTreasury Securities: Planned Flows18SBEWARTFlow Typenvarchar40
99VWBWKMTRTM-PM: Flow table for corporate actions20SBEWARTFlow Typenvarchar40
100VWFL_FT_DECFM: Assign Update Type to Flow Type4SBEWARTFlow Typenvarchar40
101VWORDEOrder Data19SBEWARTFlow Typenvarchar40
102VWVORTRSecurities: Carry-Forward Totals6SBEWARTFlow Typenvarchar40
TOPTreasury
103TZB0ADefinition of flow types3SBEWARTFlow Typenvarchar40
104TZBABGCustomizing: Accrual/Deferral Flow Types4SBEWARTFlow Typenvarchar40
105TZBABGZBFlow Types: Interest Basis for Accrual/Deferral4SBEWARTFlow Typenvarchar40
106TZC37Financial Assets Management status definition15SBEWARTFlow Typenvarchar40
107VZZUSPPayment splitting5SBEWARTFlow Typenvarchar40