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

90 columns | Print definition?ERP 6.0  | ACC_SYSTEM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAccounting Engine
1/EACC/ACCRMETH0CConfigured Methods for Accrual2ACC_SYSTEMAccounting Systemnvarchar80
2/EACC/ACCRMETH0TDescription of an Accrual Method3ACC_SYSTEMAccounting Systemnvarchar80
3/EACC/CHARNAMESCharacteristic Names for Fixed Fields3ACC_SYSTEMAccounting Systemnvarchar80
4/EACC/JOURNALSJournals in E-Accounting2ACC_SYSTEMAccounting Systemnvarchar80
5/EACC/JRNL_TRANSTransported Master Objects2ACC_SYSTEMAccounting Systemnvarchar80
6/EACC/TAR_OBJArchiving Objects2ACC_SYSTEMAccounting Systemnvarchar80
7/EACC/TAR_SELSelection Characteristics for Archiving2ACC_SYSTEMAccounting Systemnvarchar80
8/EACC/TBTA3003Transient Journal Characteristics for Generic BTA2ACC_SYSTEMAccounting Systemnvarchar80
9/EACC/TBTA3004Characteristics to Display Simulated Documents2ACC_SYSTEMAccounting Systemnvarchar80
10/EACC/T_DCCHECKCharacteristics to Display Simulated Documents2ACC_SYSTEMAccounting Systemnvarchar80
11/EACC/T_DCSEQProcess Step Sequences per Accounting System3ACC_SYSTEMAccounting Systemnvarchar80
12/EACC/V_CONDDerivation Steps Condition2ACC_SYSTEMAccounting Systemnvarchar80
13/EACC/V_CURCurrency Types2ACC_SYSTEMAccounting Systemnvarchar80
14/EACC/V_CUR_SUBNames of Views for Currency Types2ACC_SYSTEMAccounting Systemnvarchar80
15/EACC/V_DERIVDerivation Steps2ACC_SYSTEMAccounting Systemnvarchar80
16/EACC/V_DER_NAMEDerivation Steps - Name2ACC_SYSTEMAccounting Systemnvarchar80
17/EACC/V_HEAD_CHeader Data2ACC_SYSTEMAccounting Systemnvarchar80
18/EACC/V_HEAD_NHeader Data - View Name2ACC_SYSTEMAccounting Systemnvarchar80
19/EACC/V_JOURN_CJournals2ACC_SYSTEMAccounting Systemnvarchar80
20/EACC/V_JOURN_NJournals2ACC_SYSTEMAccounting Systemnvarchar80
21/EACC/V_QUANT_NQuantity Types2ACC_SYSTEMAccounting Systemnvarchar80
22/EACC/V_QUANT_TQuantity Types2ACC_SYSTEMAccounting Systemnvarchar80
23/EACC/V_TABLES_IJournal Tables - Indexes2ACC_SYSTEMAccounting Systemnvarchar80
24/EACC/V_TABLES_JJournal Tables2ACC_SYSTEMAccounting Systemnvarchar80
25/EACC/V_TABLES_TJournal Tables - Tables2ACC_SYSTEMAccounting Systemnvarchar80
26/EACC/V_TAB_I_IJournal Tables - Indexes - Index2ACC_SYSTEMAccounting Systemnvarchar80
27/EACC/V_TOTALS_FJournal Totals - Field List2ACC_SYSTEMAccounting Systemnvarchar80
28/EACC/V_TOTALS_IJournal Totals - Database Indexes2ACC_SYSTEMAccounting Systemnvarchar80
29/EACC/V_TOTALS_JJournal Totals2ACC_SYSTEMAccounting Systemnvarchar80
30/EACC/V_TOTALS_TJournal Totals - Texts3ACC_SYSTEMAccounting Systemnvarchar80
31/EACC/V_TOTAL_IIJournal Totals - Database Indexes - Index2ACC_SYSTEMAccounting Systemnvarchar80
32/EACC/V_TOTAL_ITJournal Totals - Database Indexes - Texts3ACC_SYSTEMAccounting Systemnvarchar80
33FINACHDAccounting Document Header3ACC_SYSTEMAccounting Systemnvarchar80
34FINB_TNOASS_NROAssignment of Accounting System to Number Range Object3ACC_SYSTEMAccounting Systemnvarchar80
TOPBusiness Accounting
35UAV0PRICE001Price Table with Period Dependency3ACC_SYSTEMAccounting Systemnvarchar80
36UAV0PRICE001HPrice History Table with Period Dependency3ACC_SYSTEMAccounting Systemnvarchar80
37UAV0PRICE002Price Table with Date Dependency3ACC_SYSTEMAccounting Systemnvarchar80
38UAV0PRICE002HPrice History Table with Date Dependency3ACC_SYSTEMAccounting Systemnvarchar80
39UAV0PRICE003Price Table with Period Dependency3ACC_SYSTEMAccounting Systemnvarchar80
40UAV0PRICE003HPrice History Table with Period Dependency3ACC_SYSTEMAccounting Systemnvarchar80
41UAV0PRICE004Price Table with Date Dependency3ACC_SYSTEMAccounting Systemnvarchar80
42UAV0PRICE004HPrice History Table with Date Dependency3ACC_SYSTEMAccounting Systemnvarchar80
TOPFinancials
43ACCSYSTEM01Settings for Company on Accounting System2ACC_SYSTEMAccounting Systemnvarchar80
44ACCSYSTEM02Number Range Object for Accounting System and Company2ACC_SYSTEMAccounting Systemnvarchar80
45ACCSYSTEM03Derivations for Accounting System2ACC_SYSTEMAccounting Systemnvarchar80
46ACCSYSTEM0CAccounting Systems2ACC_SYSTEMAccounting Systemnvarchar80
47ACCSYSTEM0TTexts of Accounting Systems3ACC_SYSTEMAccounting Systemnvarchar80
48FINGLACCTCOMP0CG/L Account on Accounting System/Company Level2ACC_SYSTEMAccounting Systemnvarchar80
49FINVALSTRATDERIVDerivation Table: Valuation Strategy for Business Transactio3ACC_SYSTEMAccounting Systemnvarchar80
50FINXCOSTCTR0CLocal Values for FIN_COSTCTR (Not Used in Live System)2ACC_SYSTEMAccounting Systemnvarchar80
51FINXPROFITCTR0CLocal Values for FIN_PROFITCTR (Not Used in Live System)2ACC_SYSTEMAccounting Systemnvarchar80
52FINXPROFITCTR0TLocal Texts for FIN_PROFITCTR (Not Used in Live System)3ACC_SYSTEMAccounting Systemnvarchar80
TOPFinancials Basis
53ACCACCOUNT11G/L account4ACC_SYSTEMAccounting Systemnvarchar80
54ACCACCTGROUP00Account Group3ACC_SYSTEMAccounting Systemnvarchar80
55ACCAREAIDCOMPArea ID of a Technical Component4ACC_SYSTEMAccounting Systemnvarchar80
56ACCCLSSTEP_ASGNAssignment of Period Rules for the Closing Phases2ACC_SYSTEMAccounting Systemnvarchar80
57ACCCLSSTPPERSetting for Period Lock2ACC_SYSTEMAccounting Systemnvarchar80
58ACCCLSSTPPERLEPeriod Lock Setting Depending on Legal Unit2ACC_SYSTEMAccounting Systemnvarchar80
59ACCPERSEL2Specify Selction Conditions for the Period Lock3ACC_SYSTEMAccounting Systemnvarchar80
60ACCROLE21Application Role Registration: FieldNames and FinObjectTypes3ACC_SYSTEMAccounting Systemnvarchar80
61ACCSYS02Accounting System: Assignment to Selection Condition2ACC_SYSTEMAccounting Systemnvarchar80
62ACCSYS04Customizing for Accounting System2ACC_SYSTEMAccounting Systemnvarchar80
63ACCSYS05Setting for Currency Translation2ACC_SYSTEMAccounting Systemnvarchar80
64ACCSYS08Currency IDs per Accounting System2ACC_SYSTEMAccounting Systemnvarchar80
65ACCSYS09Cust. of fiscal year variant per legal entity and acc system2ACC_SYSTEMAccounting Systemnvarchar80
66ACCSYS0CAccounting System2ACC_SYSTEMAccounting Systemnvarchar80
67ACCSYS0TName of Accounting System3ACC_SYSTEMAccounting Systemnvarchar80
68FINB_TPRFL_ATable for Result Elements (Amounts Only)2ACC_SYSTEMAccounting Systemnvarchar80
69FINB_TPRFL_QTable for Result Elements (Quantities Only)2ACC_SYSTEMAccounting Systemnvarchar80
70FINB_TPROFELTable for Result Elements2ACC_SYSTEMAccounting Systemnvarchar80
TOPGeneral Ledger
71/EACA/GL_DOCNR_TInverse Value Table for GL Number Range Subobject2ACC_SYSTEMAccounting Systemnvarchar80
72/EACA/TGLBALREPConfiguration for G/L Balance Reporting2ACC_SYSTEMAccounting Systemnvarchar80
73/EACA/TGLBAS_BSettings for Balance Tool2ACC_SYSTEMAccounting Systemnvarchar80
74/EACA/TGLBWINFOInformation for BW Objects2ACC_SYSTEMAccounting Systemnvarchar80
75/EACA/TGLCONTROLPosting Logic Control for Account Determination Fields2ACC_SYSTEMAccounting Systemnvarchar80
76/EACA/TGLMPCONASConfiguration of Manual Posting Transaction for Acc. System2ACC_SYSTEMAccounting Systemnvarchar80
77/EACA/TGLREADERAdministration of the GUIDs for the Reader Modules2ACC_SYSTEMAccounting Systemnvarchar80
78/EACA/TGLSYS01General Ledger Configuration in Accounting System2ACC_SYSTEMAccounting Systemnvarchar80
TOPIndustry Solution Catch Weight Management
79CON_FIN_CKOMPUAllowance for Price Update6ACC_SYSTEMAccounting Systemnvarchar80
TOPInventory Accounting
80FAIBSV01Incoming/Outgoing Invoices8ACC_SYSTEMAccounting Systemnvarchar80
81FAIBSV01CRule for Balance Sheet Valuation3ACC_SYSTEMAccounting Systemnvarchar80
82FAIBSV02Valuated Receipts6ACC_SYSTEMAccounting Systemnvarchar80
83FAIBSV03Logistical Goods Movements6ACC_SYSTEMAccounting Systemnvarchar80
84UAINVDEBCRHDocument for Revaluation Through Material Debit/Credit12ACC_SYSTEMAccounting Systemnvarchar80
85UAINVREVALHDocument for INV Price Change and Inventory Revaluation14ACC_SYSTEMAccounting Systemnvarchar80
86UAINVT4000Configuration Status of Inventory/WIP for Accounting Systems2ACC_SYSTEMAccounting Systemnvarchar80
87UAIQS_BALANCEQuantity Structure: Beginning/Ending Inventories and Values2ACC_SYSTEMAccounting Systemnvarchar80
88UAIQS_SNDRCVQuantity Structure: Valuated Quantity Structure2ACC_SYSTEMAccounting Systemnvarchar80
TOPLoans Management
89/FSIH/LINKTable of Links Between Loan and Insurance Policy3ACC_SYSTEMAccount Systemnvarchar20
TOPProfitability Analysis
90/EACA/TPMACCSYSAssignment of Accounting Systems4ACC_SYSTEMAccounting Systemnvarchar80