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

110 columns | Print definition?ERP 6.0  | UZAWE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000168000PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items52UZAWEnvarchar20
2/BIC/B0000169000PSA for 0FI_GL_41 T90CLNT090 Documents, Compact52UZAWEnvarchar20
3/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items60UZAWEnvarchar20
4/SMD/MD_____00J4SID-Tabelle fuer Pmt meth. supplement3UZAWEPayment Method Supplementnvarchar20
5/SMD/MD_____010ESID-Tabelle fuer Pmt meth. supplement3UZAWEPayment Method Supplementnvarchar20
6BSAD_BAKAccounting: Secondary index for customers (cleared items)111UZAWEPayment Method Supplementnvarchar20
7BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)120UZAWEPayment Method Supplementnvarchar20
8BSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)71UZAWEPayment Method Supplementnvarchar20
9BSEGAccounting Document Segment255UZAWEPayment Method Supplementnvarchar20
10BSID_BAKAccounting: Secondary Index for Customers111UZAWEPayment Method Supplementnvarchar20
11BSIK_BAKAccounting: Secondary index for vendors120UZAWEPayment Method Supplementnvarchar20
12BSIS_BAKAccounting: Secondary Index for G/L Accounts71UZAWEPayment Method Supplementnvarchar20
13BSSEGAccounting Document Segment244UZAWEPayment Method Supplementnvarchar20
14FAGLBSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)71UZAWEPayment Method Supplementnvarchar20
15FAGLBSIS_BAKAccounting: Secondary Index for G/L Accounts71UZAWEPayment Method Supplementnvarchar20
16FSEPA_INST_CDLocal Instrument and Lead Times for SEPA Direct Debits13UZAWEPayment Method Supplementnvarchar20
17FUDT_VDOCBSECLRHAdditional Data for Document Segment: Clearing Information35UZAWEPayment Method Supplementnvarchar20
18FUDT_VDOCBSEGVerification Document Item with Additional Info244UZAWEPayment Method Supplementnvarchar20
19FUDT_VDOCBSEGEVVerification Document Item in the Entry View244UZAWEPayment Method Supplementnvarchar20
20FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)244UZAWEPayment Method Supplementnvarchar20
21FUDT_VDOCBSE_CLRAdditional Data for Document Segment: Clearing Information35UZAWEPayment Method Supplementnvarchar20
22GLPOS_C_CTFI Document: Entry View250UZAWEPayment Method Supplementnvarchar20
23GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items250UZAWEPayment Method Supplementnvarchar20
24GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items250UZAWEPayment Method Supplementnvarchar20
25GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items250UZAWEPayment Method Supplementnvarchar20
26GLPOS_N_CTNew General Ledger: Line Item with Currency Type259UZAWEPayment Method Supplementnvarchar20
27GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type259UZAWEPayment Method Supplementnvarchar20
28REGUPProcessed items from payment program117UZAWEPayment Method Supplementnvarchar20
29T042FPayment method supplements2UZAWEPayment Method Supplementnvarchar20
30T042HText table for additional payment methods3UZAWEPayment Method Supplementnvarchar20
31TREAT_FLOW_PMTreasury: TREA Flow Payment Details9UZAWEPayment Method Supplementnvarchar20
32VDSEPA_DDSepa DD - Lead Time Determination12UZAWEPayment Method Supplementnvarchar20
TOPAccounting Interface
33GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)109UZAWEPayment Method Supplementnvarchar20
34GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)109UZAWEPayment Method Supplementnvarchar20
TOPAutomatic Payments
35PAYRQPayment Requests126UZAWEPayment Method Supplementnvarchar20
TOPBack Office
36TRFT_PACC_BANKPayment Information13UZAWEPayment Method Supplementnvarchar20
37TRST_CLASFLOCFM: Class Flows in Securities Account44UZAWEPayment Method Supplementnvarchar20
38TRST_CLASFLO_REVCFM: Reversed Class Flows in Securities Account44UZAWEPayment Method Supplementnvarchar20
39TRST_SECACC_BANKPayment Details for Securities Account13UZAWEPayment Method Supplementnvarchar20
40TRST_SECACC_PAYDownport Payment Information for Securities Management12UZAWEPayment Method Supplementnvarchar20
TOPBank Customer Accounts
41TBKKIHB4FI Data for Manual Outgoing Payments In-House Bank8UZAWEPayment Method Supplementnvarchar20
42TBKKIHB5Payt Method Determination HQ FI for Payment In-House Bank11UZAWEPayment Method Supplementnvarchar20
TOPBank Master Data
43TBCHAIN1Bank chains7UZAWEPayment Method Supplementnvarchar20
44TBCHAIN2Bank Chains per Business Partner Account8UZAWEPayment Method Supplementnvarchar20
45TBCHAIN21Bank chains per business partner account (allocation)8UZAWEPayment Method Supplementnvarchar20
TOPBusiness Partner
46TIVBPVENDORCMPVendor Preassignment (CoCd Data)41UZAWEPayment Method Supplementnvarchar20
47VTBSTC1Components of Payment Details for Standing Instruction11UZAWEPayment Method Supplementnvarchar20
TOPCentral Cash Desk Procedure
48FMFGT_IPACD_PMSIPACed Auto Doc Creation - Payment Method Suppl for Invoice5UZAWEPayment Method Supplementnvarchar20
49FMFGT_IPCD_BLRTDocument Type for Auto Creation of IPACed Invoices7UZAWEPayment Method Supplementnvarchar20
TOPContract Accounts Receivable and Payable
50DPAYHPayment program - data for payment65UZAWEPayment Method Supplementnvarchar20
TOPCross-Application Components
51BBSIDAccounting: Secondary index for customers111UZAWEPayment Method Supplementnvarchar20
TOPData Retention Tool
52TXW_S_BSEGRetrieve BSEG from archive85UZAWEPayment Method Supplementnvarchar20
TOPData Transfer
53PPDITTransfer to Accounting: Lines in HR IDOCs30UZAWEPayment Method Supplementnvarchar20
TOPFinancial Accounting
54BSADAccounting: Secondary Index for Customers (Cleared Items)111UZAWEPayment Method Supplementnvarchar20
55BSAKAccounting: Secondary Index for Vendors (Cleared Items)120UZAWEPayment Method Supplementnvarchar20
56BSASAccounting: Secondary Index for G/L Accounts (Cleared Items)71UZAWEPayment Method Supplementnvarchar20
57BSE_CLRAdditional Data for Document Segment: Clearing Information35UZAWEPayment Method Supplementnvarchar20
58BSIDAccounting: Secondary Index for Customers111UZAWEPayment Method Supplementnvarchar20
59BSIKAccounting: Secondary Index for Vendors120UZAWEPayment Method Supplementnvarchar20
60BSISAccounting: Secondary Index for G/L Accounts71UZAWEPayment Method Supplementnvarchar20
61KNB1Customer Master (Company Code)55UZAWEPayment Method Supplementnvarchar20
62LFB1Vendor Master (Company Code)42UZAWEPayment Method Supplementnvarchar20
63T076EFI-EDI: Assignment Pymt Method - External Pymt Method (Bank)8UZAWEPayment Method Supplementnvarchar20
64VACSPLTFI Document Parking (Enjoy): Amount Split9UZAWEPayment Method Supplementnvarchar20
65VBSEGDDocument Segment for Customer Document Parking62UZAWEPayment Method Supplementnvarchar20
66VBSEGKDocument Segment for Vendor Document Parking68UZAWEPayment Method Supplementnvarchar20
67VBSEGSDocument Segment for Document Parking - G/L Account Database141UZAWEPayment Method Supplementnvarchar20
TOPFSCM In-House Cash
68IHC_DB_PAY_MAPPIHC: Clearing Agreement8UZAWEDelivered Payment Method Supplementnvarchar20
TOPFunds Management
69T042F_FMFG_TCPmt Method Supp map to ALC and Pmt Office - US Treas Conf2UZAWEPayment Method Supplementnvarchar20
TOPFunds Management-Specific Postings
70PSOSEGDDocument Segment: Recurring Request, Customer63UZAWEPayment Method Supplementnvarchar20
71PSOSEGKRecurring Request Document Segment, Vendors69UZAWEPayment Method Supplementnvarchar20
TOPGeneral Ledger Accounting
72FAGLBSASAccounting: Secondary Index for G/L Accounts (Cleared Items)71UZAWEPayment Method Supplementnvarchar20
73FAGLBSISAccounting: Secondary Index for G/L Accounts71UZAWEPayment Method Supplementnvarchar20
TOPInvoice Verification
74RBKPDocument Header: Invoice Receipt119UZAWEPayment Method Supplementnvarchar20
75RBVSInvoice Verification: Split Invoice Amount8UZAWEPayment Method Supplementnvarchar20
TOPLoans Management
76TTONFTVZZBEPPTest neue FIMA: VZZBEPP247UZAWEZusatz zum Zahlwegnvarchar20
77VDBEPIPosted line items for document header134UZAWEPayment Method Supplementnvarchar20
78VDBEPI_SHADOWShadow Table for VDBEPI (Restrictions)134UZAWEPayment Method Supplementnvarchar20
79VDBEPPFlow Data - Planned Item158UZAWEPayment Method Supplementnvarchar20
80VDBOBEPPBusiness Operation: Entered and Activated Flow Data158UZAWEPayment Method Supplementnvarchar20
81VDORDERBorrower's note loan order data73UZAWEPayment Method Supplementnvarchar20
82VDREPAYMENTPayoff Master Data89UZAWEPayment Method Supplementnvarchar20
83VDZVPayment Details for the Loan20UZAWEPayment Method Supplementnvarchar20
84VZFZE_VDBEPPCentral Entry Table for Release Procedure161UZAWEPayment Method Supplementnvarchar20
TOPLocalization
85J_3R0Payment with correspondent account9UZAWEPayment Method Supplementnvarchar20
86J_3RFTAX_EXTRDTax Extract Detail Lines62UZAWEPayment Method Supplementnvarchar20
87RFITEMAP_NO_ITEMItem wise detail for the Vendor Transactions61UZAWEPayment Method Supplementnvarchar20
88RFITEMAR_NO_ITEMItem wise detail for the Customer Transactions61UZAWEPayment Method Supplementnvarchar20
89RFITEMGL_NO_ITEMItem wise detail for the GL Account Transactions61UZAWEPayment Method Supplementnvarchar20
TOPPayment Transactions
90FPRL_ITEMItem Data146UZAWEPayment Method Supplementnvarchar20
91PAYRPayment Medium File60UZAWEPayment Method Supplementnvarchar20
92REGUHSettlement data from payment program104UZAWEPayment Method Supplementnvarchar20
93REGUHHREGUH version before the 'n'th change33UZAWEPayment Method Supplementnvarchar20
94REGUHMPayment Data for Cross-Payment Run Payment Medium14UZAWEPayment Method Supplementnvarchar20
TOPRemaining Beverage - Obsolete Objects
95/BEV3/CH1030BSG2Document Segment CH Event Ledger Part211UZAWEPayment Method Supplementnvarchar20
TOPTransaction Manager
96OTC_CONV_FHAPOBackup Table for Financial Transaction Flows33UZAWEPayment Method Supplementnvarchar20
97OTC_CONV_IFHAPOBackup Table for Underlying Transaction Flows31UZAWEPayment Method Supplementnvarchar20
98REFCCReferences between CO object numbers, currency differences20UZAWEPayment Method Supplementnvarchar20
99SLDT_FLOWSubledger Distributor Transactions58UZAWEPayment Method Supplementnvarchar20
100TERT_FLOWFlow Table for Rights that can be Exercised27UZAWEPayment Method Supplementnvarchar20
101TRDT_FLOWPersistent distributor flows56UZAWEPayment Method Supplementnvarchar20
102VTBFHAPOTransaction Flow33UZAWEPayment Method Supplementnvarchar20
103VTBFHAPO_MIGRMigrated Financial Flows33UZAWEPayment Method Supplementnvarchar20
104VTBFHAPO_UNFIXEDNon-Fixed Financial Transaction Flows33UZAWEPayment Method Supplementnvarchar20
105VTBPFHAPOTreasury: Flow Shells32UZAWEPayment Method Supplementnvarchar20
106VTBZVPayment Details for Transaction20UZAWEPayment Method Supplementnvarchar20
107VTIFHAPOUnderlying transaction flows31UZAWEPayment Method Supplementnvarchar20
TOPTransfer to Financial Accounting
108TRACT_ACCITEMAccounting Items26UZAWEPayment Method Supplementnvarchar20
109TRPRT_PAYMENTSPersistent Data for Payment Requests47UZAWEPayment Method Supplementnvarchar20
TOPTreasury and Risk Management
110TREAT_EXT_ACC_PMTreasury: External Account Payment Details13UZAWEPayment Method Supplementnvarchar20