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

176 tablesERP 6.0 

Financial Accounting :: General Ledger Accounting :: Basic Functions
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0BSACC_HIST_CUST41General Settings for Account HistoryBasic Functions
2ERP EHP76.0BSACC_HIST_GRP61Account Groups for Account HistoryBasic Functions
3ERP EHP76.0BSACC_HIST_GRPT51Account Groups for Account HistoryBasic Functions
4ERP EHP76.0BSACC_HIST_TA41Account History: Transaction Types UsedBasic Functions
5ERP EHP76.0ETXDCH385External tax document: header infoBasic Functions
6ERP EHP76.0ETXDCI491External tax document: line item infoBasic Functions
7ERP EHP76.0ETXDCJ141Ext. tax document: tax rates and amounts by Jurisdict. levelBasic Functions
8ERP EHP76.0ETXDCLOG141Temporay table for storing last error message of an updateBasic Functions
9ERP EHP76.0FIGLDOC91G/L accounting: Subsequent derivationsBasic Functions
10ERP EHP76.0FIGLREP41Settings for G/L Posting ReportsBasic Functions
11ERP EHP76.0FIGL_USER_DATA51User-Specific Data for Individual TransactionsBasic Functions
12ERP EHP76.0FIGL_USER_OWNER11Applications for User-Specific DataBasic Functions
13ERP EHP76.0FIGL_USER_OWNERT31Applications for User-Specific DataBasic Functions
14ERP EHP76.0GLACCREFH41G/L Account Master Record: Create with ReferenceBasic Functions
15ERP EHP76.0GLACCREFI91G/L Account Master Record: Create with ReferenceBasic Functions
16ERP EHP76.0SKAS52G/L account master (chart of accounts: key word list)Basic Functions
17ERP EHP76.0SKB1422G/L account master (company code)Basic Functions
18ERP EHP76.0SKM1381Sample G/L accountsBasic Functions
19ERP EHP76.0T011151Financial Statement VersionsBasic Functions
20ERP EHP76.0T011A51Calendar - task descriptionBasic Functions
21ERP EHP76.0T011B41FI financial calendar - job text tableBasic Functions
22ERP EHP76.0T011E61Calendar of person responsible for unitBasic Functions
23ERP EHP76.0T011F41FI fin.calendar - person responsible for unit text tableBasic Functions
24ERP EHP76.0T011T41Financial statement version namesBasic Functions
25ERP EHP76.0T011V31FI financial calendar task-schedule linkBasic Functions
26ERP EHP76.0T051A81Account Balances for Statutory ReportingBasic Functions
27ERP EHP76.0T060K41FI constantsBasic Functions
28ERP EHP76.0T060L41FI constant nameBasic Functions
29ERP EHP76.0T060M71FI constant valuesBasic Functions
30ERP EHP76.0TAXMSD81Tax Interface Manager Status Diagram "Tax Per document"Basic Functions
31ERP EHP76.0TGSBG21Cross-system business areasBasic Functions
32ERP EHP76.0TGSBH41Texts for table TGSBGBasic Functions
33ERP EHP76.0TGSB_CUS51Additional Settings for Business Area Financial StatementsBasic Functions
34ERP EHP76.0TGSB_CUST31Additional Settings for Business Area Financial StatementsBasic Functions
35ERP EHP76.0TTXI81External tax interface: index fileBasic Functions
36ERP EHP76.0TTXP41Product codes (external tax interface)Basic Functions
37ERP EHP76.0TTXPT51Product code description (external interface)Basic Functions
38ERP EHP76.0TTXU141External tax interface: Audit file update informationBasic Functions
39ERP EHP76.0TTXY991External tax interface: tax informationBasic Functions
Financial Accounting :: General Ledger Accounting :: Basic Functions :: Accrual Engine
ProductVersionTableColumnsIndexesDescriptionModule
40ERP EHP76.0ACEDSASSGMT121Standard Account Assignments for Accrual ObjectsAccrual Engine
41ERP EHP76.0ACEDSOH141Accrual Subobject Header DataAccrual Engine
42ERP EHP76.0ACEDSOI171Item Data for Accrual SubobjectAccrual Engine
43ERP EHP76.0ACEDSOI_ACCOUNTS181Accounts for Accrual Postings per Accrual ItemAccrual Engine
44ERP EHP76.0ACEDSOP101Accrual Subobject ParametersAccrual Engine
45ERP EHP76.0ACEOBJ62Accrual ObjectsAccrual Engine
46ERP EHP76.0ACEPSOH131Accrual Subobject: Header Data in Posting ComponentAccrual Engine
47ERP EHP76.0ACEPSOI151Accrual Item: Values in Posting ComponentAccrual Engine
48ERP EHP76.0ACEPSOIT244Line Items for Accrual Item in Accrual EngineAccrual Engine
49ERP EHP76.0ACEPSPPLOG121Logical Periodic Accrual RunAccrual Engine
50ERP EHP76.0ACEPSPPSEL91Select Options Periodic Posting RunAccrual Engine
51ERP EHP76.0TACE00161Company Code SettingsAccrual Engine
52ERP EHP76.0TACE001T51Texts for Company Codes in the Accrual EngineAccrual Engine
53ERP EHP76.0TACECOMP201Accrual Engine Application ComponentAccrual Engine
54ERP EHP76.0TACECOMPC71Customer Settings for ComponentsAccrual Engine
55ERP EHP76.0TACECOMPT41Application Components of Accrual FunctionAccrual Engine
56ERP EHP76.0TACEDS_LEGACYM71Legacy Data Transfer ControlAccrual Engine
57ERP EHP76.0TACEDS_OPASGMT31Assignment of Operator to Function ModuleAccrual Engine
58ERP EHP76.0TACEDS_OPERATR21Operators for Derived Accrual TypesAccrual Engine
59ERP EHP76.0TACEDS_OPERATRT41Texts for Operators for Derived Accrual TypesAccrual Engine
60ERP EHP76.0TACEDS_OP_PERC41Percentages for Derived Accrual Types (Operator "P")Accrual Engine
61ERP EHP76.0TACEPSRULE31ACE Account Determination: Account Determination RuleAccrual Engine
62ERP EHP76.0TACEPSRULET51ACE Account Determination: Account Determination RuleAccrual Engine
63ERP EHP76.0TACEPSSYM31ACE Account Determination: Account SymbolAccrual Engine
64ERP EHP76.0TACEPSSYMT51ACE Account Determination: Account SymbolAccrual Engine
65ERP EHP76.0TACESYSTEVENTS61Events in the Accrual EngineAccrual Engine
66ERP EHP76.0TACE_ACCMETHODS41Methods for Calculation of Periodic Accrual AmountAccrual Engine
67ERP EHP76.0TACE_ACCMETHODST51Texts of Accrual MethodsAccrual Engine
68ERP EHP76.0TACE_ACRTYPE81Accrual TypesAccrual Engine
69ERP EHP76.0TACE_ACRTYPET51Text for Accrual TypesAccrual Engine
70ERP EHP76.0TACE_ACRTYPE_OPN81Calculation Rules for Derived Accrual TypesAccrual Engine
71ERP EHP76.0TACE_COMBINATION41Possible Combinations in the Accrual EngineAccrual Engine
72ERP EHP76.0TACE_COMP_SPEC271Component-Specific Program ComponentsAccrual Engine
73ERP EHP76.0TACE_DE_MAPPING41Application-Dependent Data Elements for Accrual EngineAccrual Engine
74ERP EHP76.0TACE_DS_CALC71Distribution Server: Accrual Type SettingsAccrual Engine
75ERP EHP76.0TACE_ENVIR_EVENT41Events Depending on the Environement (ERP or Business Acc.)Accrual Engine
76ERP EHP76.0TACE_EXISTEVENTS31Possible Events in the Accrual EngineAccrual Engine
77ERP EHP76.0TACE_EXISTEVENTT41Possible Events in the Accrual EngineAccrual Engine
78ERP EHP76.0TACE_FUNC_MOD21Function Modules Used in the Accrual EngineAccrual Engine
79ERP EHP76.0TACE_FUNC_MODT41Accrual Engine Function Module TextsAccrual Engine
80ERP EHP76.0TACE_PS_POST81Posting Server: Posting ControlAccrual Engine
81ERP EHP76.0TACE_TREEORDER61Table for the Sequence in the Tree StructureAccrual Engine
82ERP EHP76.0TACE_TREEVARI31Table for Tree Structure VariantsAccrual Engine
83ERP EHP76.0TACE_TREEVARIT51Text Table of Tree Structure VariantsAccrual Engine
84ERP EHP76.0TACE_TRNSFERTYPE51Selection Methods for Data Transfer to the Accrual EngineAccrual Engine
85ERP EHP76.0TACE_TRNSFERTYPT51Texts for Selection MethodsAccrual Engine
86ERP EHP76.0TACE_VSR_00181Assignment of ValidationsAccrual Engine
Financial Accounting :: General Ledger Accounting :: Basic Functions :: Average Daily Balance
ProductVersionTableColumnsIndexesDescriptionModule
87ERP EHP76.0GLE_FDOCREF92ECS / ADB Document Reference for ReversalAverage Daily Balance
88ERP EHP76.0GLE_TADB_DOCT41FI-SL Document Types for Average Daily BalanceAverage Daily Balance
89ERP EHP76.0GLE_TADB_DX61Database for Temp. Data (Eg Transfer Complex Param.btw Jobs)Average Daily Balance
90ERP EHP76.0GLE_TADB_EX_CUST191Settings for Extracting Average Daily Balance DataAverage Daily Balance
91ERP EHP76.0GLE_TADB_LCUST41Ledger Customizing for Average Daily BalanceAverage Daily Balance
92ERP EHP76.0GLE_TADB_LGROUP31ADB Ledger GroupAverage Daily Balance
93ERP EHP76.0GLE_TADB_LGROUPT41Text Table for Ledger EnvironmentsAverage Daily Balance
Financial Accounting :: General Ledger Accounting :: Basic Functions :: Closing Operations
ProductVersionTableColumnsIndexesDescriptionModule
94ERP EHP76.0FBRC0001C21Application IDsClosing Operations
95ERP EHP76.0FBRC0001T41Application IDs: TextsClosing Operations
96ERP EHP76.0FBRC0010C111Reconciliation Processes: AttributesClosing Operations
97ERP EHP76.0FBRC0010T41Reconciliation Processes: TextsClosing Operations
98ERP EHP76.0FBRC002041Reconciliation Processes: Field CatalogsClosing Operations
99ERP EHP76.0FBRC0030C31Display CategoriesClosing Operations
100ERP EHP76.0FBRC0030T51Display Categories: TextsClosing Operations
101ERP EHP76.0FBRC004091Display SubcategoriesClosing Operations
102ERP EHP76.0FBRC005051Tree Display Hierarchy SetupClosing Operations
103ERP EHP76.0FBRC006091Reconciliation Processes: User SettingsClosing Operations
104ERP EHP76.0FBRC0070C61Reconciliation Processes: Status Value and IconsClosing Operations
105ERP EHP76.0FBRC0070T61Reconciliation Processes: Status TextsClosing Operations
106ERP EHP76.0FBRC007531Status Relevant FieldsClosing Operations
107ERP EHP76.0FBRC0080C51Reconciliation Processes: RulesClosing Operations
108ERP EHP76.0FBRC0080T51Reconciliation Processes: Rule TextsClosing Operations
109ERP EHP76.0FBRC008571Reconciliation Processes: Rule DefinitionsClosing Operations
110ERP EHP76.0FBRC0090C81SetsClosing Operations
111ERP EHP76.0FBRC0090T51Sets: TextsClosing Operations
112ERP EHP76.0FBRC009571Sets: Single EntriesClosing Operations
113ERP EHP76.0FBRC1100C51Contact Person DatabasesClosing Operations
114ERP EHP76.0FBRC1100T51Contact Person Databases: TextsClosing Operations
115ERP EHP76.0FBRC111091Contact PersonsClosing Operations
116ERP EHP76.0FBRC111521Contact Persons: Organization AddressesClosing Operations
117ERP EHP76.0FBRC1200C31Message Template GroupsClosing Operations
118ERP EHP76.0FBRC1200T51Message Template Groups: TextsClosing Operations
119ERP EHP76.0FBRC1210C61Message TemplatesClosing Operations
120ERP EHP76.0FBRC1210T71Message Templates: TextsClosing Operations
121ERP EHP76.0FBRC121571Message Templates: TextlinesClosing Operations
122ERP EHP76.0FBRC1220C41Message PlaceholdersClosing Operations
123ERP EHP76.0FBRC1220T61Placeholders: TextsClosing Operations
Financial Accounting :: General Ledger Accounting :: Basic Functions :: CRM Accruals
ProductVersionTableColumnsIndexesDescriptionModule
124ERP EHP76.0CRM_ACE_CU_ACRTY61CRM Accruals: Assignment of Accruals Type to Transact. TypeCRM Accruals
125ERP EHP76.0CRM_ACE_CU_COND51Customizing for CRM Accruals: Relevant Revenue ElementsCRM Accruals
126ERP EHP76.0CRM_ACE_CU_COPA41CRM Accruals: Assgmt of Accruals Type to Cond.Type for CO-PACRM Accruals
127ERP EHP76.0CRM_ACE_CU_METH41CRM Accruals Customizing: Find Accrual MethodCRM Accruals
128ERP EHP76.0CRM_ACE_OH_DATA143CRM Accruals: Object HeaderCRM Accruals
129ERP EHP76.0CRM_ACE_OI_DATA151CRM Accruals: Item Detail Data of ObjectCRM Accruals
130ERP EHP76.0CRM_ACE_REFKEY62CRM Accruals: REFKEY DecryptionCRM Accruals
131ERP EHP76.0IPM_ACE_BTA_DATA64Assignment Table for Revenue Distribution from CRMCRM Accruals
132ERP EHP76.0IPM_ACE_CU_BVAL51Customizing Settings for Data Values for Rights Usage Conf.CRM Accruals
133ERP EHP76.0IPM_ACE_CU_VALTY51Customizing Data Values Relevant to Accrual TypesCRM Accruals
Financial Accounting :: General Ledger Accounting :: Basic Functions :: GL Account Posting
ProductVersionTableColumnsIndexesDescriptionModule
134ERP EHP76.0TCJ_CHECK_STACKS101Check Lists in Cash JournalGL Account Posting
135ERP EHP76.0TCJ_CJ_NAMES51Cash Journal NamesGL Account Posting
136ERP EHP76.0TCJ_CPD411FBCJ: One-Time Account Data of Cash Journal Document ItemsGL Account Posting
137ERP EHP76.0TCJ_C_JOURNALS221Cash JournalsGL Account Posting
138ERP EHP76.0TCJ_DOCUMENTS403Cash Journal Documents (Header Data)GL Account Posting
139ERP EHP76.0TCJ_MAX_AMOUNT71Cash Journal: Amount LimitGL Account Posting
140ERP EHP76.0TCJ_NUMB_GROUP21Numbering Group for Cash DocumentsGL Account Posting
141ERP EHP76.0TCJ_NUMB_GROUPT41Numbering Group for Cash Documents (Text)GL Account Posting
142ERP EHP76.0TCJ_POSITIONS991Cash Journal Document ItemsGL Account Posting
143ERP EHP76.0TCJ_PRINT81Cash Journal Print ParametersGL Account Posting
144ERP EHP76.0TCJ_TRANSACTIONS111Cash Journal Business TransactionsGL Account Posting
145ERP EHP76.0TCJ_TRANS_NAMES61Cash Journal Business Transaction NamesGL Account Posting
146ERP EHP76.0TCJ_WTAX_ITEMS581Withholding Tax Items for Cash Journal Document ItemsGL Account Posting
Financial Accounting :: General Ledger Accounting :: Basic Functions :: Manual Accruals
ProductVersionTableColumnsIndexesDescriptionModule
147ERP EHP76.0ACAC_OBJECTS82Manual Accruals: Accrual ObjectsManual Accruals
148ERP EHP76.0TACAC_OBJTYP21Accrual Object Types in Accrual AccountingManual Accruals
149ERP EHP76.0TACAC_OBJTYPT41Text Table for Accrual Object TypesManual Accruals
150ERP EHP76.0TACAC_PO_ASSIGN31ACAC Assignment of Object Types and ParametersManual Accruals
Financial Accounting :: General Ledger Accounting :: Basic Functions :: Planning
ProductVersionTableColumnsIndexesDescriptionModule
151ERP EHP76.0T8PL0091FI Planning: Installed Plan TablesPlanning
152ERP EHP76.0T8PL01251FI-Planning: Summary Table Dimensions to be PlannedPlanning
153ERP EHP76.0T8PL01DD221FI Planning: Dimensions Table Index - Dictionary InformationPlanning
154ERP EHP76.0T8PL01DP101FI Planning : Field Dependency for ValidationPlanning
155ERP EHP76.0T8PL01S141FI-Planning: Dimensions that Allow SetsPlanning
156ERP EHP76.0T8PL01SF91FI Planning: Special Handling of DimensionsPlanning
157ERP EHP76.0T8PL01SV161FI-Planning: Comb. fixed values/attr. for key fig. and dim.Planning
158ERP EHP76.0T8PL02201FI-Planning: User attributesPlanning
159ERP EHP76.0T8PL02CC81FI Planning: Currency TranslationPlanning
160ERP EHP76.0T8PL03181FI Planning: Configuration of Plan TasksPlanning
161ERP EHP76.0T8PLUATTR161FI-Planning: Key Figures for PlanningPlanning
Financial Accounting :: General Ledger Accounting :: Basic Functions :: Provisions for Awards
ProductVersionTableColumnsIndexesDescriptionModule
162ERP EHP76.0ACE_SOP_BSMODATA111Data for the Black & Scholes ModelProvisions for Awards
163ERP EHP76.0ACE_SOP_DESTINTN21Connection Data to the HR SystemProvisions for Awards
164ERP EHP76.0ACE_SOP_FFVERSNS21Versions for Simulation of Forfeiture RatesProvisions for Awards
165ERP EHP76.0ACE_SOP_FFVRSTXT41Version for Simulation of Performance of Stock PricesProvisions for Awards
166ERP EHP76.0ACE_SOP_HRFI61Accrual Engine: Assignment for HR Data TransferProvisions for Awards
167ERP EHP76.0ACE_SOP_INDTYPE71Type of Index Used for Award ProgramProvisions for Awards
168ERP EHP76.0ACE_SOP_INVERSNS21Versions for Simulation of Performance of IndexesProvisions for Awards
169ERP EHP76.0ACE_SOP_INVRSTXT41Version for Simulation of Performance of Stock PricesProvisions for Awards
170ERP EHP76.0ACE_SOP_METH_IND31Method <-> Version Assignment for Index PerformanceProvisions for Awards
171ERP EHP76.0ACE_SOP_REFKEY62Decoding of Accrual Engine RefKeyProvisions for Awards
172ERP EHP76.0ACE_SOP_SCRT_FRF51Hypothetical Forfeiture Rates for SimulationProvisions for Awards
173ERP EHP76.0ACE_SOP_SCRT_IND51Hypothetical Index Performance for SimulationProvisions for Awards
174ERP EHP76.0ACE_SOP_SCRT_SEC61Hypothetical Security Price Performance for SimulationProvisions for Awards
175ERP EHP76.0ACE_SOP_VERSNS21Version for Simulation of Performance of Stock PricesProvisions for Awards
176ERP EHP76.0ACE_SOP_VERSNTXT41Version for Simulation of Performance of Stock PricesProvisions for Awards