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

33 columns | Print definition?ERP 6.0  | SSTATI

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1RDPT_CONDITIONCondition within Redemption Schedule7SSTATIStatus of data recordnvarchar20
TOPBank Components
2JBSWPOFFOpen, Non-Fulfilled Spot Securities Transactions (RR)6SSTATIStatus of data recordnvarchar20
TOPBasic Functions
3T036VAllocation of planning levels for Financial Assets Mgmt4SSTATIStatus of data recordnvarchar20
TOPLoans Management
4TDA5Non-Accept.Reason5SSTATIStatus which can be reached as target statusnvarchar20
5TDALE_EXP_LOANALE Export Relevance Per Loan4SSTATIStatus of data recordnvarchar20
6TTONFTVDARLTest neue Fima: Grunddaten und VDARL28SSTATIStatus, in dem sich der Datensatz befindetnvarchar20
7TTONFTVVZZKOPOTest neue Fima: VVZZKOPO10SSTATIStatus, in dem sich der Datensatz befindetnvarchar20
8TTONFTVZZBEPPTest neue FIMA: VZZBEPP27SSTATIStatus, in dem sich der Datensatz befindetnvarchar20
9TTONFTVZZKOKOTest neue FIMA: VZZKOKO8SSTATIStatus, in dem sich der Datensatz befindetnvarchar20
10VDARLLoans14SSTATIStatus of data recordnvarchar20
11VDBEKIFlow Data: Document Header for Actual Record12SSTATIStatus of data recordnvarchar20
12VDBEKI_SHADOWShadow Table for VDBEKI (Restrictions)12SSTATIStatus of data recordnvarchar20
13VDBEPPFlow Data - Planned Item31SSTATIStatus of data recordnvarchar20
14VDBOBEPPBusiness Operation: Entered and Activated Flow Data31SSTATIStatus of data recordnvarchar20
15VDORDERBorrower's note loan order data19SSTATIOrder Statusnvarchar20
16VZFGDRelease data (Informative data for the release procedure)14SSTATIStatus of data recordnvarchar20
17VZFZE_VDBEKICentral Entry Table for Release Procedure15SSTATIStatus of data recordnvarchar20
18VZFZE_VDBEPPCentral Entry Table for Release Procedure34SSTATIStatus of data recordnvarchar20
TOPMaster Data
19VDESCROWKOKO0TEMPORARY USE: Escrow Condition Headers10SSTATIStatus of data recordnvarchar20
20VDESCROWKOPO0TEMPORARY USE: Escrow Condition Items9SSTATIStatus of data recordnvarchar20
TOPReal Estate Management
21VIBEPPFlow data - Planned items for real estate management11SSTATIStatus of data recordnvarchar20
22VIKOKOReal Estate condition header9SSTATIStatus of data recordnvarchar20
TOPRegulatory reporting for insurance companies
23TZC3ASteuerung Großkreditmeldung Ö (Vertrag/Promesse)4SSTATIVertragsstatusnvarchar20
TOPTransaction Manager
24VTBFININHeader Table for Financial Products6SSTATIUpdate statisticsnvarchar10
25VWBEKITreasury Securities: Actual Flows - Header8SSTATIStatus of data recordnvarchar20
26VWBEPPTreasury Securities: Planned Flows16SSTATIStatus of data recordnvarchar20
27VWORDEOrder Data17SSTATIStatus of data recordnvarchar20
28VWPBUKRCompany Code Position4SSTATIStatus of data recordnvarchar20
29VWPDEPOSecurities Account Position5SSTATIStatus of data recordnvarchar20
30VZSKOKOCondition header for stock, subscrip.rights, investments5SSTATIStatus of data recordnvarchar20
TOPTreasury
31VWPANLAAsset master for securities4SSTATIStatus of a securitynvarchar20
32VZZKOPOTable condition items12SSTATIStatus of data recordnvarchar20
TOPTreasury and Risk Management
33VZZKOKOTable condition header7SSTATIStatus of data recordnvarchar20