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

41 columns | Print definition?ERP 6.0  | ZWELS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1REGUPProcessed items from payment program88ZWELSList of the Payment Methods to be Considerednvarchar100
2T042GGroups of company codes ( payment program )4ZWELSList of the Payment Methods to be Considerednvarchar100
3TREAT_FLOW_PMTreasury: TREA Flow Payment Details14ZWELSList of the Payment Methods to be Considerednvarchar100
4TZD0BDarwin: Customer default values per co.cd/trn.type for KNB117ZWELSList of the Payment Methods to be Considerednvarchar100
5ZPR13MM Profile Other Objects4ZWELSList of Payment Methods that Should be Used in a Payment Runnvarchar100
TOPAutomatic Payments
6PAYRQPayment Requests127ZWELSList of the Payment Methods to be Considerednvarchar100
TOPBack Office
7TRFT_PACC_BANKPayment Information18ZWELSList of the Payment Methods to be Considerednvarchar100
8TRST_CLASFLOCFM: Class Flows in Securities Account45ZWELSList of the Payment Methods to be Considerednvarchar100
9TRST_CLASFLO_REVCFM: Reversed Class Flows in Securities Account45ZWELSList of the Payment Methods to be Considerednvarchar100
10TRST_SECACC_BANKPayment Details for Securities Account18ZWELSList of the Payment Methods to be Considerednvarchar100
11TRST_SECACC_PAYDownport Payment Information for Securities Management17ZWELSList of the Payment Methods to be Considerednvarchar100
TOPBank Customer Accounts
12TBKKIHB4FI Data for Manual Outgoing Payments In-House Bank7ZWELSList of the Payment Methods to be Considerednvarchar100
13TBKKIHB5Payt Method Determination HQ FI for Payment In-House Bank10ZWELSList of the Payment Methods to be Considerednvarchar100
TOPBasic Functions
14TFBWEPersonal Customizing for Transaction FBWE8ZWELSPayment methods to be includednvarchar100
TOPBusiness Partner
15TIVBPVENDORCMPVendor Preassignment (CoCd Data)12ZWELSList of the Payment Methods to be Considerednvarchar100
16VTBSTC1Components of Payment Details for Standing Instruction18ZWELSList of the Payment Methods to be Considerednvarchar100
TOPFinancial Accounting
17KNB1Customer Master (Company Code)20ZWELSList of the Payment Methods to be Considerednvarchar100
18LFB1Vendor Master (Company Code)13ZWELSList of the Payment Methods to be Considerednvarchar100
19T012OORBIAN Details: Bank Accounts and Other Data12ZWELSList of the Payment Methods to be Considerednvarchar100
TOPInformation System
20DKKOSBalance Audit Trail63ZWELSList of the Payment Methods to be Considerednvarchar100
21DKOKSOpen Item Account Balance Audit Trail Master Record66ZWELSList of the Payment Methods to be Considerednvarchar100
TOPLoans Management
22TTONFTVZZBEPPTest neue FIMA: VZZBEPP250ZWELSListe der Zahlwege, die zu berücksichtigen sindnvarchar100
23VDBEPIPosted line items for document header137ZWELSList of the Payment Methods to be Considerednvarchar100
24VDBEPPFlow Data - Planned Item161ZWELSList of the Payment Methods to be Considerednvarchar100
25VDBOBEPPBusiness Operation: Entered and Activated Flow Data161ZWELSList of the Payment Methods to be Considerednvarchar100
26VDORDERBorrower's note loan order data76ZWELSList of the Payment Methods to be Considerednvarchar100
27VDZVPayment Details for the Loan25ZWELSList of the Payment Methods to be Considerednvarchar100
28VZFZE_VDBEPPCentral Entry Table for Release Procedure164ZWELSList of the Payment Methods to be Considerednvarchar100
TOPPayment Transactions
29PCECPrenumbered Checks15ZWELSList of Pmnt Methods Permitted for this Check Lotnvarchar100
TOPTransaction Manager
30OTC_CONV_FHAPOBackup Table for Financial Transaction Flows38ZWELSList of the Payment Methods to be Considerednvarchar100
31REFCCReferences between CO object numbers, currency differences21ZWELSList of the Payment Methods to be Considerednvarchar100
32SLDT_FLOWSubledger Distributor Transactions63ZWELSList of the Payment Methods to be Considerednvarchar100
33TERT_FLOWFlow Table for Rights that can be Exercised32ZWELSList of the Payment Methods to be Considerednvarchar100
34TRDT_FLOWPersistent distributor flows61ZWELSList of the Payment Methods to be Considerednvarchar100
35VTBFHAPOTransaction Flow38ZWELSList of the Payment Methods to be Considerednvarchar100
36VTBFHAPO_MIGRMigrated Financial Flows38ZWELSList of the Payment Methods to be Considerednvarchar100
37VTBFHAPO_UNFIXEDNon-Fixed Financial Transaction Flows38ZWELSList of the Payment Methods to be Considerednvarchar100
38VTBZVPayment Details for Transaction25ZWELSList of the Payment Methods to be Considerednvarchar100
TOPTransfer to Financial Accounting
39TRPRT_PAYMENTSPersistent Data for Payment Requests26ZWELSList of the Payment Methods to be Considerednvarchar100
TOPTreasury
40VZKNB1Collector for batch input KNB1 from RF-VV15ZWELSList of the Payment Methods to be Considerednvarchar100
TOPTreasury and Risk Management
41TREAT_EXT_ACC_PMTreasury: External Account Payment Details18ZWELSList of the Payment Methods to be Considerednvarchar100