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

71 columns | Print definition?ERP 6.0  | ACINST

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAccounting Engine
1/EACC/BT_ACTIVActivate Configurations of the Business Transactions2ACINSTAccounting Systemnvarchar80
2/EACC/BT_CNF_AAll Configurations by the Business Transactions2ACINSTAccounting Systemnvarchar80
3/EACC/COND_PRConditions for Generated Programs2ACINSTAccounting Systemnvarchar80
4/EACC/CONFIGS_LIConfigurations3ACINSTAccounting Systemnvarchar80
5/EACC/CONF_DELEGDelegation of Line Item Processing2ACINSTAccounting Systemnvarchar80
6/EACC/DERIVCHARSTarget Characteristics in Derivation Steps2ACINSTAccounting Systemnvarchar80
7/EACC/DERIV_CONDConditions for Derivation Steps2ACINSTAccounting Systemnvarchar80
8/EACC/DERIV_EXITMethods for Derviation Exits2ACINSTAccounting Systemnvarchar80
9/EACC/DM_COUNTERCounter Readings in Tranche Management2ACINSTData Basisnvarchar50
10/EACC/DM_DTRANCHDefault Tranche2ACINSTData Basisnvarchar50
11/EACC/DM_FC_REQUData Retention - Flow Control: Requests2ACINSTAccounting Structure IDnvarchar220
12/EACC/DM_SERIMAXData Retention - Flow Control: Highest Serial No. of DataSrc2ACINSTAccounting Structure IDnvarchar220
13/EACC/DM_TRNCHTranches2ACINSTData Basisnvarchar50
14/EACC/DOC_PROGSGenerated Programs2ACINSTAccounting Systemnvarchar80
15/EACC/GEN_PROGSGenerated Programs2ACINSTAccounting Systemnvarchar80
16/EACC/HEAD_TBLSList of Document Header Tables2ACINSTAccounting Systemnvarchar80
17/EACC/JRNL_ACTIVActive Journal Configurations2ACINSTAccounting Systemnvarchar80
18/EACC/JRNL_CNF_AAll Journal Configurations2ACINSTAccounting Systemnvarchar80
19/EACC/JRNL_CURTPAll Journal Configurations2ACINSTAccounting Systemnvarchar80
20/EACC/JRNL_DERIVDerivation Configuration for the Journal2ACINSTAccounting Systemnvarchar80
21/EACC/JRNL_QNTTPAll Journal Configurations2ACINSTAccounting Systemnvarchar80
22/EACC/JRNL_TOTLSJournal Totals2ACINSTAccounting Systemnvarchar80
23/EACC/LASTPSTDATLest Posting Date Posted to2ACINSTAccounting Systemnvarchar80
24/EACC/PROGCONDConditions for Generated Programs2ACINSTAccounting Systemnvarchar80
25/EACC/TACCOMPComponents of the Accounting Instance2ACINSTObsolete - to be deletednvarchar220
26/EACC/TDOCJRCONFConfiguration of the Document Journal Component2ACINSTAccounting Systemnvarchar80
27/EACC/TOT_DELEGDelegation of Totals Administration2ACINSTAccounting Systemnvarchar80
28/EACC/VIEWDCHARSSource Characteristics in Derivation Steps2ACINSTAccounting Systemnvarchar80
29/EACC/VIEW_ACTIVActive View Configurations2ACINSTAccounting Systemnvarchar80
30/EACC/VIEW_CNF_AAll View Configurations2ACINSTAccounting Systemnvarchar80
31/EACC/VIEW_CURTPAll View Configurations2ACINSTAccounting Systemnvarchar80
32/EACC/VIEW_DERIVDerivation Configuration Requirements in a View2ACINSTAccounting Systemnvarchar80
33/EACC/VIEW_QNTTPQuantity Types2ACINSTAccounting Systemnvarchar80
34/EACC/VIEW_TOT_AAll View Configurations2ACINSTAccounting Systemnvarchar80
TOPBusiness Accounting
35/EACC/DMM_BWINFOBW System for Transaction Data2ACINSTAccounting Structure IDnvarchar220
36/EACC/DMM_CHACharacteristics of the Accounting Views2ACINSTAccounting Structure IDnvarchar220
37/EACC/DMM_COMPONComponents with Data Retention2ACINSTAccounting Structure IDnvarchar220
38/EACC/DMM_DICDimension Assignment of the Characteristics of Accntng Views2ACINSTAccounting Structure IDnvarchar220
39/EACC/DMM_DIMDimensions of the Accounting Views2ACINSTAccounting Structure IDnvarchar220
40/EACC/DMM_DIMTTest e for Dimensions of Accounting Views2ACINSTAccounting Structure IDnvarchar220
41/EACC/DMM_KYFKey Figures in the Accounting Views2ACINSTAccounting Structure IDnvarchar220
42/EACC/DMM_QUEEXTechnical Info for Extraction2ACINSTAccounting Structure IDnvarchar220
43/EACC/DMM_QUEUEBW Objects in the Extraction Lines2ACINSTAccounting Structure IDnvarchar220
TOPFinancials Basis
44/EACC/TCHAR_OBLIObsolete2ACINSTObsolete - to be deletednvarchar220
45/EACC/TIOBJ_CATObsolete2ACINSTObsolete - to be deletednvarchar220
46/EACC/TIOBJ_CUBEObsolete2ACINSTObsolete - to be deletednvarchar220
47/EACC/TIOBJ_OBLIObsolete2ACINSTObsolete - to be deletednvarchar220
48/EACC/TIOBJ_REGIObsolete2ACINSTObsolete - to be deletednvarchar220
49/EACC/TLEAD_BWObsolete2ACINSTObsolete - to be deletednvarchar220
50/EACC/TLEAD_STObsolete2ACINSTObsolete - to be deletednvarchar220
51FINB_TACCOMMObsolete !!! Accounting Community2ACINSTObsolete - to be deletednvarchar220
52FINB_TACCOMMTObsolete !!! Accounting Community: Texts2ACINSTObsolete - to be deletednvarchar220
53FINB_TACCOMM_MBObsolete !!! Members of an Accounting Community2ACINSTObsolete - to be deletednvarchar220
54FINB_TACINSTObsolete - to be deleted2ACINSTObsolete - to be deletednvarchar220
55FINB_TACINSTTObsolete - to be deleted3ACINSTObsolete - to be deletednvarchar220
56FINB_TACSYSTObsolete !!! Valuation System2ACINSTObsolete - to be deletednvarchar220
57FINB_TACSYSTTObsolete !!! Valuation System Texts2ACINSTObsolete - to be deletednvarchar220
58FINB_TACSYST_DCRObsolete !!! Valuation System: Description in Form of Chars2ACINSTObsolete - to be deletednvarchar220
59FINB_TACSYST_GRObsolete !!! Valuation System: Description Groups2ACINSTObsolete - to be deletednvarchar220
TOPGeneral Ledger
60/EACA/TGLDYNCOLSLayout of the Document Header Screen2ACINSTText string 22 charactersnvarchar220
61/EACA/TGLDYNFLDSPosition of the Screen Fields2ACINSTText string 22 charactersnvarchar220
62/EACA/TGLDYNPROSScreen Numbers for Posting Transactions2ACINSTText string 22 charactersnvarchar220
63/EACA/TGLDYNTABSTitle Element for the Header of a Document3ACINSTText string 22 charactersnvarchar220
TOPProfitability Analysis
64/EACA/TPMDTSTMeta Data for Data Retention in Profitability Analysis3ACINSTAccounting Structure IDnvarchar220
65/EACA/TPMINSTANCProfitability Analysis Instance2ACINSTAccounting Structure IDnvarchar220
66/EACA/TPMINSTTText Table for Profitability Analysis Instance2ACINSTAccounting Structure IDnvarchar220
67/EACA/TPMSTRUCTStructural Configuration for Profitability Analysis3ACINSTAccounting Structure IDnvarchar220
68/EACA/TPMVARIProfitabiliy Analysis Variant2ACINSTAccounting Structure IDnvarchar220
69/EACA/TPMVARIASSVariant: Assignments2ACINSTAccounting Structure IDnvarchar220
70/EACA/TPMVARIMETAssignment of Meta Data Continers to Variant2ACINSTAccounting Structure IDnvarchar220
71/EACA/TPMVARITText Table for Variant2ACINSTAccounting Structure IDnvarchar220