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

68 columns | Print definition?ERP 6.0  | MNDID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPF15/SMF15 SEPA Mandat14MNDIDEindeutige Referenz auf das Mandat je Zahlungsempfängernvarchar350
2BKKPOMNDPayment order Enriched with Mandate details4MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
3BKK_SEPA_LIM_EVEvent Table for Mandate Limits9MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
4BKK_SEPA_LIM_HISHistory Table for Mandate Limits10MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
5BSAD_BAKAccounting: Secondary index for customers (cleared items)172MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
6BSEGAccounting Document Segment327MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
7BSID_BAKAccounting: Secondary Index for Customers172MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
8DFKKPRNHSEPA: Direct Debit Pre-Notifications (FI-CA)8MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
9DFKK_SEPA_IDSSEPA: Short Key for Mandate Reference4MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
10GLPOS_C_CTFI Document: Entry View349MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
11GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items343MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
12GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items343MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
13GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items343MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
14GLPOS_N_CTNew General Ledger: Line Item with Currency Type358MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
15GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type352MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
16P2RX_BTPayroll Results: Bank Transfers35MNDIDSEPA Mandate: Unique Reference to Mandate per Creditornvarchar350
17P2RX_BT_PERSONPayment-Related Information (Person)37MNDIDSEPA Mandate: Unique Reference to Mandate per Creditornvarchar350
18RDPT_CONDITIONCondition within Redemption Schedule73MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
19SEPA_MDTENQ_MULTSEPA Mandate: Auxilliary Table for Multiple Enqueue7MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
20T77PAYKZBTBank Transfer Table Image (BTKZ)52MNDIDSEPA Mandate: Unique Reference to Mandate per Creditornvarchar350
21VDSEPA_MND_USGOverview of mandates used in Loans Management17MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
TOPAdvertising Management
22JHAISZIS-M/AM: Assignment Table of Advertisers for OPM Order68MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
23JHTFKIS-M/AM: Settlement Documents (Billing, Commission) - Header63MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
24JHWWWTEMP_ORDERIS-M/AM: Temporary Table for Order Data from the Internet58MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
TOPAgency Business Global Trade
25WBRKAgency business: Header172MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
TOPBank
26SEPA_MANDATESEPA Mandate3MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
27SEPA_MANDATE_ENQSEPA Mandate: Internal Table for ENQUEUE2MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
TOPBilling
28VBRKBilling Document: Header Data106MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
TOPCollectionsDisbursements
29VVSCPOSPayment Plan Item144MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
TOPContract Accounts Receivable and Payable
30DFKKDDADebit Memo Notification37MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
31DFKKIP_GRPPayment Specification: Header Data10MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
32DFKKIP_GRPHPayment Specification: Payment Data (History)12MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
33DPAYHPayment program - data for payment102MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
34FKKPREPACCMaster Data for Prepaid Account30MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
35FKKVKPContract Account Partner-Specific89MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
TOPFinancial Accounting
36BSADAccounting: Secondary Index for Customers (Cleared Items)172MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
37BSIDAccounting: Secondary Index for Customers172MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
TOPLoans Management
38VDBEPIPosted line items for document header155MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
39VDBEPI_SHADOWShadow Table for VDBEPI (Restrictions)154MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
40VDBEPPFlow Data - Planned Item179MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
41VDBOBEPPBusiness Operation: Entered and Activated Flow Data179MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
42VDCFWAREHOUSECash Flow Management88MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
43VDDEBTTRANSBorrower Change Without Capital Transfer22MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
44VDGPOLoan: Relationship Partner/Role Object22MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
45VDREPAYMENTPayoff Master Data88MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
46VDZVPayment Details for the Loan26MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
47VZFZE_VDBEPPCentral Entry Table for Release Procedure182MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
TOPLogistics - General
48WBHDTrading Contract: Commercial Data80MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
TOPOutgoing Payments
49VDDISBDisbursement Specific Header Data21MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
TOPPayment Transactions
50FPRL_ITEMItem Data171MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
TOPPeriodical Sales and Distribution
51JFRKIS-M/SD: Billing - Header Data88MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
52JKKDSales Order: Business Data44MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
53JKWWWTEMP_ORDERIS-M/SD: WWW Temporary Table for Order Data from Internet84MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
54JKWWWTEMP_PAYIS-M: Temporary Internet Table: Payment Data Change10MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
55JNTRECHIS-M/SD: Research71MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
TOPPortfolio
56VDDEFERRALDeferral Data57MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
TOPPublic Sector Contract Accounts Receivable and Payable
57DPSOB_BP_ACCData for Contract Object for Each Partner & Cont. Acct Cat.31MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
TOPSales
58VBKDSales Document: Business Data94MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
TOPTransaction Manager
59OTC_CONV_FHAPOBackup Table for Financial Transaction Flows171MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
60TRDT_FLOWPersistent distributor flows87MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
61VTBFHAPOTransaction Flow171MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
62VTBFHAPO_MIGRMigrated Financial Flows171MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
63VTBFHAPO_UNFIXEDNon-Fixed Financial Transaction Flows171MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
64VTBZVPayment Details for Transaction31MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
TOPTransfer to Financial Accounting
65TRACT_ACCITEMAccounting Items44MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
66TRPRT_PAYMENTSPersistent Data for Payment Requests58MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
TOPTreasury
67VZZKOPOTable condition items100MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350
68VZZUSPPayment splitting20MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350