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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

40 columns | Print definition?ERP 6.0  | SBEWZITI

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TDP4Alloc. of activity type and flow category to condition type3SBEWZITIFlow categorynvarchar40
2TWBBBAllocation of program-internal flow types3SBEWZITIFlow categorynvarchar40
3TZB0CFlow category texts2SBEWZITIFlow categorynvarchar40
4TZBBBAllocation of program-internal flow types3SBEWZITIFlow categorynvarchar40
5TZK05Allocation: Calculation type - KOPO fields1SBEWZITIFlow categorynvarchar40
TOPAccounting
6VDIOA_CALC_DETProgress (Interest) of Model Account IOA Calculation14SBEWZITIFlow categorynvarchar40
TOPBack Office
7TPMT_DEPAL_FLOWSListed Futures: Price Gain Records9SBEWZITIFlow categorynvarchar40
TOPLoans Management
8TDCONDVER_SBZITICondition Verfication: Permitted Calculation Categories2SBEWZITIFlow categorynvarchar40
9TDREPAY_PRCONDCondition Type Determination for the Payoff4SBEWZITIFlow categorynvarchar40
10TDTZB0A_CHECKInternal Checks for Flow Types in Customizing2SBEWZITIFlow categorynvarchar40
11TRDC_RECSummarization of Loan Document Items: Carryforward Records8SBEWZITIFlow categorynvarchar40
12TRLET_LOAN_FLOWOBSOLETE: Previous Solution: Loans Flows Transferred15SBEWZITIFlow categorynvarchar40
13TTONFTVVZZKOPOTest neue Fima: VVZZKOPO79SBEWZITIBewegungstypnvarchar40
14TTONFTVZZBEPPTest neue FIMA: VZZBEPP32SBEWZITIBewegungstypnvarchar40
15TZB05Trans. type - Trans. type groups allocation for cash flow1SBEWZITIFlow categorynvarchar40
16VDARC_DOC_RECCarryforward Records for Reorganization of Loan Doc. Items9SBEWZITIFlow categorynvarchar40
17VDBEPIPosted line items for document header7SBEWZITIFlow categorynvarchar40
18VDBEPI_SHADOWShadow Table for VDBEPI (Restrictions)7SBEWZITIFlow categorynvarchar40
19VDBEPPFlow Data - Planned Item20SBEWZITIFlow categorynvarchar40
20VDBOBEPPBusiness Operation: Entered and Activated Flow Data20SBEWZITIFlow categorynvarchar40
21VDCFWAREHOUSECash Flow Management13SBEWZITIFlow categorynvarchar40
22VDORDERBorrower's note loan order data15SBEWZITIFlow categorynvarchar40
23VDPOST_CONTROLData Selection for Debit Position2SBEWZITIFlow categorynvarchar40
24VZFZE_VDBEPPCentral Entry Table for Release Procedure23SBEWZITIFlow categorynvarchar40
TOPReal Estate Management
25TIV85G/L acct/transaction category alloc. for down pmnts made3SBEWZITIFlow categorynvarchar40
26TZK01Condition types7SBEWZITIFlow categorynvarchar40
27VIBEPPFlow data - Planned items for real estate management50SBEWZITIFlow categorynvarchar40
TOPTransaction Data Pool
28JBDBEWEPosition Flows Generated by Position Changes17SBEWZITIFlow categorynvarchar40
TOPTransaction Management
29TIDX_FLOW_CATTreasury: Flow Categories for Price Indexes2SBEWZITIFlow categorynvarchar40
TOPTransaction Manager
30TERTVWBWERTRTM-PM: Flow Table for Executable Rights21SBEWZITIFlow categorynvarchar40
31TWBBBSAssign Additional Flow Types for Valuation3SBEWZITIFlow categorynvarchar40
32VWBEPITreasury Securities: Actual Flows - Item14SBEWZITIFlow categorynvarchar40
33VWBEPPTreasury Securities: Planned Flows19SBEWZITIFlow categorynvarchar40
34VWBWKMTRTM-PM: Flow table for corporate actions21SBEWZITIFlow categorynvarchar40
35VWFL1Assign Flow Categories from TR Transaction to Security3SBEWZITIFlow categorynvarchar40
36VWORDEOrder Data20SBEWZITIFlow categorynvarchar40
37VWVORTRSecurities: Carry-Forward Totals15SBEWZITIFlow categorynvarchar40
TOPTreasury
38TDBBBAllocation of program-internal flow types3SBEWZITIFlow categorynvarchar40
39TZB03Flow categories1SBEWZITIFlow categorynvarchar40
40TZB0ADefinition of flow types5SBEWZITIFlow categorynvarchar40