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

77 columns | Print definition?ERP 6.0  | ACCOUNT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CCEE/SIFI_CACCSI: Cash Sales Report - account assignment to payment type5ACCOUNTGeneral Ledger Accountnvarchar100
2BBP_PCACCProcurement Card: Accounting Data8ACCOUNTG/L Account Numbernvarchar100
3BBP_PCMODProcurement Card: Modified Statement Data10ACCOUNTG/L Account Numbernvarchar100
4CNV_20100_IC_POSStatus of postings per account and company code6ACCOUNTG/L Account Numbernvarchar100
5EPIC_DUM_BALBalance of Dummy Bank3ACCOUNT30 Charactersnvarchar300
6EPIC_DUM_TRANSACTransactions of Dummy Bank3ACCOUNT30 Charactersnvarchar300
7FIAPPTD_BALANCETable to store the Balances for Vendor/Customer/Bank Account6ACCOUNTAccount Numbernvarchar100
8FIAPPTD_BAL_SCBSCB codes for Vendor/Customer and House Bank Balances3ACCOUNTAccount Numbernvarchar100
9FIAPPTD_TRANSTable to store the transaction details of the CBR PT10ACCOUNTAccount Numbernvarchar100
10INTITFXFixed Interest Amounts per Invoice15ACCOUNTSD business partner identifier (number or code)nvarchar100
11REP_EAPS_DCOLN_CData Connector: Layout Customizing/Line Definition4ACCOUNTAdditional Texts for Accountnvarchar300
12TCORIT_SWIFT_PGNSWIFT MT535 depot statement pages - fragment adm. with CoCod2ACCOUNTSecurities Accountnvarchar100
13TCORIT_SWIFT_STNSWIFT MT535 depot statements - fragment administration CoCod2ACCOUNTSecurities Accountnvarchar100
14TCMAC05CDetermine Payment Card Authorization3ACCOUNTG/L Account Numbernvarchar100
TOPAccounting Interface
15GLE_ECS_BALECS+GL Balances by Company Code, Account, Fiscal Year, Crcy3ACCOUNTGeneral Ledger Accountnvarchar100
16GLE_ECS_BAL_ITEMGL open items that are not in ECS5ACCOUNTGeneral Ledger Accountnvarchar100
17GLE_ECS_ITEMECS: Error Correction Items20ACCOUNTGeneral Ledger Account of Posted Documentnvarchar100
18GLE_TECS_ACP04Threshold6ACCOUNTThreshold Check: Account Number for Write-Off Accountnvarchar100
TOPAssetLiability Management
19JBR_US_ACCTBalance Sheet Account Key2ACCOUNTBalancing Accountnvarchar30
20JBR_US_ACCT_MAPBalancing Account2ACCOUNTBalancing Accountnvarchar30
21TJBR_US_ACCT_TCustomizing Table for Balancing Account Texts3ACCOUNTBalancing Accountnvarchar30
TOPBack Office
22TRST_SECACC_BANKPayment Details for Securities Account8ACCOUNTShort key for house bank accountnvarchar50
23TRST_SECACC_PAYDownport Payment Information for Securities Management7ACCOUNTShort key for house bank accountnvarchar50
TOPBSI
24BTXRATEBSI: Tax Rates per Company Based on Degree of Experience9ACCOUNTBSI: Account numbernvarchar110
25BTXRATE_OBSI: Tax Rates per Company Based on Degree of Experience8ACCOUNTBSI: Account numbernvarchar110
TOPBusiness Server Pages
26AUUSERUser Table for the eRhine Auction House12ACCOUNTAuction - Amountdecimal102
TOPCollectionsDisbursements
27IBROSTMCFClarif. Cases from Broker Report9ACCOUNTContract Account Numbernvarchar120
28IBROSTMPISCD: Broker Report - Item Data17ACCOUNTContract Account Numbernvarchar120
29INSCUSTENVINS Information Cluster Builder: Parameters6ACCOUNTDisplay Activation for Cluster Builder Object Levelnvarchar10
30TFSCD_COV_PARIns: Parameter Cluster Builder Business Partner Environment6ACCOUNTDisplay Activation for Cluster Builder Object Levelnvarchar10
31TINS_COV_PARIS-PS-CA: Parameter Cluster Builder Business Partner Environ6ACCOUNTDisplay Activation for Cluster Builder Object Levelnvarchar10
TOPContract Accounts Receivable and Payable
32EBRLIVICMSRegistro de Apuração do ICMS: List control additional acct6ACCOUNTGeneral Ledger Accountnvarchar100
TOPCost Element Accounting
33COFISActual line items for reconciliation ledger62ACCOUNTReconciliation Account for Reconciliation Postingnvarchar100
TOPFinancial Accounting
34/CCEE/YUFI_PRACCDRQ Serbia: Public revenue accounts2ACCOUNTnvarchar50
35FDKMAILSender of External Mail3ACCOUNTSD business partner identifier (number or code)nvarchar100
36INTITHEUntil When Was Interest Calculated for Item?6ACCOUNTGL/Customer/Vendor Account Numbernvarchar100
37INTITITInterest Calculation Details per Item21ACCOUNTSD business partner identifier (number or code)nvarchar100
38J_1GALLG/L to A/L link deficiencies (Log file)3ACCOUNTAccount Numbernvarchar100
TOPFinancial Supply Chain Management
39IHC_PI_INB_ACCTSPI: Clearing Partner Details for Inbound IDOC8ACCOUNTPI: Account Number from BCA Current Accountnvarchar350
TOPFront Office
40EWCUSTENVIS-U Information Cluster Builder: Parameter7ACCOUNTDisplay Activation for Cluster Builder Object Levelnvarchar10
TOPFSCM In-House Cash
41IHC_DB_INB_ACCTSClearing Partner Details for PEXR20028ACCOUNTExternal Account Numbernvarchar350
TOPFunctions for U.S. Federal Government
42FMFG_T095Contra accounts asset accounting6ACCOUNTG/L Account Numbernvarchar100
TOPFunds Management
43FMFG_BL_BALACCBudgetary Ledger balancing account for document split3ACCOUNTG/L Account Numbernvarchar100
TOPGeneral Ledger Accounting
44T8G30BAcct determination for document splitting - accounts7ACCOUNTG/L Account Numbernvarchar100
TOPLocalization
45J_1BLB08Registro de Apuração do IPI: List control additional accts6ACCOUNTGeneral Ledger Accountnvarchar100
46J_1BLB09Registro de Apuração do ICMS: List control additional acct6ACCOUNTGeneral Ledger Accountnvarchar100
47J_1IUTILIZEUtilization Determination3ACCOUNTAccount Namenvarchar100
TOPMaster Data
48BKK620Account Hierarchy: Amount Definitions for Cash Concentration5ACCOUNTInternal Account Number for Current Accountnvarchar100
49BKK621Cash Concentration: Different Amount Defintions4ACCOUNTInternal Account Number for Current Accountnvarchar100
50BKK622Cash Concentration: Balancing Date of Last Execution3ACCOUNTInternal Account Number for Current Accountnvarchar100
51EPROPOwner Allocation4ACCOUNTContract Account Numbernvarchar120
TOPMobile Materials Management
52/ISDFPS/MEMMTRQLCustomizing: Requisition Type for Document Cat. (Mobile)7ACCOUNTAccount Assignmentnvarchar10
TOPMove-InOut
53ECAMIOPRMDKEYIS-U: Parked Document: Master Data Key5ACCOUNTContract Account Numbernvarchar120
TOPPerformance Monitors TCC
54SAPWLT000SAP workload: statistics data11ACCOUNTUser Name in User Master Recordnvarchar120
55SAPWLT001SAP workload: Table statistics11ACCOUNTUser Name in User Master Recordnvarchar120
56SAPWLT002SAP workload: RFC statistics data11ACCOUNTUser Name in User Master Recordnvarchar120
TOPPortfolio
57VDBILL_RES_HEADBill Results Header4ACCOUNTContract Numbernvarchar130
TOPProcess Monitoring Infrastructure
58SSPISTRECSCompressed Statistical Records Before Cumulation11ACCOUNTDSR Statistics: User Namenvarchar320
TOPPublic Sector Contract Accounts Receivable and Payable
59DFMCA_BRF901BRF: Form Bundle Accounting Data Update8ACCOUNTBRF: Expressionnvarchar200
60DFMCA_RETURNData Table for Tax Returns11ACCOUNTContract Account Numbernvarchar120
61DFMCA_RETURN_MData Table for Additional Accounting Data in Return5ACCOUNTContract Account Numbernvarchar120
62DFMCA_RETURN_OData Table for Tax Returns14ACCOUNTContract Account Numbernvarchar120
63DFMCA_RISK_PROFData Table for Risk Profiles3ACCOUNTContract Account Numbernvarchar120
64DFMCA_TAX_CASEData Table for Tax Cases4ACCOUNTContract Account Numbernvarchar120
65DFMCA_TF_CST_LLine Item Table of Consolidated SUT Member Schedule7ACCOUNTContract Account Numbernvarchar120
66TFMCA_COV_PARIS-PS-CA: Parameter Cluster Builder Business Partner Environ6ACCOUNTDisplay Activation for Cluster Builder Object Levelnvarchar10
TOPRevenue
67OIUAR_WO_CONFIGAccounts Receivable Writeoff Configuration3ACCOUNTAccount Numbernvarchar100
TOPService Data Download
68/SDF/BPM_ASTADBPMon Application Statistical Records6ACCOUNTUser Name in User Master Recordnvarchar120
69/SDF/BPM_ASTAD2BPMon Application Statistical Records6ACCOUNTUser Name in User Master Recordnvarchar120
70/SDF/BPM_TSTADBPMon Technical Statistical Records7ACCOUNTUser Name in User Master Recordnvarchar120
TOPTax Reporting
71OIUX4_WO_SETUPTaxes Payable Writeoff Configuration3ACCOUNTAccount IDnvarchar100
TOPThird Party Remittance
72T7US3PR_V0TYPE_TMaintain wage types for other HR payees of V0 type 'T'4ACCOUNTAccount identifier for V0 type 'T'nvarchar60
TOPTransaction Manager
73TCORIT_SWIFT_PGSWIFT MT535 depot statement pages - fragment administration2ACCOUNTSecurities Accountnvarchar100
74TCORIT_SWIFT_STSWIFT MT535 depot statements - fragment administration2ACCOUNTSecurities Accountnvarchar100
75TCORT_BP_BICBIC Codes/ Account numbers for Business partners7ACCOUNTExternal Securities Account IDnvarchar350
TOPTravel Planning
76FTPT_REQ_ACCOUNTTravel Request Cost Assignment6ACCOUNTSequential number of cost distribution in travel requestnvarchar20
TOPWaste Management
77EWACUSTENVIS-U Waste, Information Cluster Builder: Parameters10ACCOUNTDisplay Activation for Cluster Builder Object Levelnvarchar10