SchemaSpy Analysis of idempiere9.adempiereComplete Generated by
Quality Systems & Solutions
Generated on 2021-12-25 14:43 +0100
Database Type: PostgreSQL - 9.6.24

XML Representation
Insertion Order Deletion Order

Table / View Children Parents Columns Rows Comments
a_asset 35 16 69 0 Asset used internally or by customers
a_asset_acct 21 50 0 A_Asset_Acct_ID
a_asset_addition 2 15 52 0 Asset Addition
a_asset_change 1 16 79 0 A_Asset_Change_ID
a_asset_change_amt 2 13 0
a_asset_class 3 20 0 Asset class
a_asset_delivery 4 25 0 Delivery of Asset
a_asset_disposed 1 6 39 0 Asset Disposed
a_asset_group 8 2 21 9 Group of Assets
a_asset_group_acct 20 53 6 Asset Group Accounting
a_asset_group_trl 6 14 9 Group of Assets
a_asset_info_fin 2 22 0 Asset Info Financial ID
a_asset_info_ins 17 0 A_Asset_Info_Ins_ID
a_asset_info_lic 1 17 0 A_Asset_Info_Lic_ID
a_asset_info_oth 26 0 A_Asset_Info_Oth_ID
a_asset_info_tax 16 0 Asset Info Tax
a_asset_product 4 15 0 Asset Product
a_asset_retirement 1 2 13 0 Internally used asset is not longer used.
a_asset_reval 1 24 0 Asset Revaluation
a_asset_reval_entry 5 26 0 Asset Reval. Entry
a_asset_reval_index 13 0 Asset Reval Index
a_asset_split 2 26 0 Asset Split
a_asset_spread 1 25 2 A_Asset_Spread_ID
a_asset_transfer 13 52 0 A_Asset_Transfer_ID
a_asset_type 3 15 0 Asset Type
a_asset_use 1 13 0 A_Asset_Use_ID
a_depreciation 4 15 11 Depreciation
a_depreciation_build 3 18 0 Build Depreciation
a_depreciation_convention 4 15 6 Depreciation Convention
a_depreciation_entry 1 5 27 0 Depreciation Entry
a_depreciation_exp 8 38 0 A_Depreciation_Exp_ID
a_depreciation_forecast 2 15 0 Depreciation Forecast
a_depreciation_method 4 14 3 Depreciation Method
a_depreciation_table_detail 14 2,579 Depreciation Table Detail
a_depreciation_table_header 4 14 122 A_Depreciation_Table_Header_ID
a_depreciation_workfile 3 45 0 A_Depreciation_Workfile_ID
a_fundingmode 2 12 0 Asset Funding Mode
a_fundingmode_acct 3 11 0 Asset Funding Mode Accounting
a_registration 1 4 24 0 User Asset Registration
a_registrationattribute 2 2 16 0 Asset Registration Attribute
a_registrationproduct 2 11 0 Registration Product
a_registrationvalue 2 12 0 A_RegistrationValue
ad_accesslog 2 17 0 Log of Access to the System
ad_alert 2 1 18 1 iDempiere Alert
ad_alertprocessor 2 2 19 1 Alert Processor/Server Parameter
ad_alertprocessorlog 1 16 0 Result of the execution of the Alert Processor
ad_alertrecipient 3 12 1 Recipient of the Alert Notification
ad_alertrule 2 20 1 Definition of the alert element
ad_allclients_v 13 view Client (All)
ad_allroles_v 26 view Role (All)
ad_alluserroles_v 27 view User Roles from All Tenants
ad_allusers_v 27 view User (All)
ad_archive 4 19 0 Document Archive
ad_attachment 1 2 15 1 Attachment for the document
ad_attachmentnote 2 13 0 Personal Attachment Note
ad_attribute 1 4 32 0 System Attribute
ad_attribute_value 1 6 0 AD_Attribute_Value
ad_authorizationaccount 1 2 21 0 Authorization Account
ad_authorizationcredential 1 1 16 0 Authorization Credential
ad_authorizationprovider 2 16 2 Authorization Provider
ad_authorizationscopeprov 1 12 3 Authorization Scope Provider
ad_broadcastmessage 2 3 24 0 Broadcast Messages for system users
ad_broadcastmessage_trl 6 12 0 Broadcast Message
ad_changelog 3 21 0 Log of data changes
ad_changelog_v 9 view AD_ChangeLog_v
ad_chart 4 1 21 4 Chart definition
ad_chart_trl 6 15 4 Chart Trl
ad_chartdatasource 3 22 6 Chart data definition
ad_client 105 3 40 2 Client/Tenant for this installation.
ad_clientinfo 24 36 2 AD_ClientInfo
ad_clientshare 3 13 0 Client Share
ad_color 4 1 26 0 Color for backgrounds or indicators
ad_color_trl 6 12 0 Color for backgrounds or indicators
ad_column 30 12 56 25,432 Column in the table
ad_column_access 3 13 0 AD_Column_Access
ad_column_trl 2 13 25,432 Column in the table
ad_ctxhelp 9 19 0 Context Help
ad_ctxhelpmsg 2 1 12 0 Context Help Message
ad_ctxhelpmsg_trl 2 12 0 Context Help Message Trl
ad_ctxhelpsuggestion 5 21 0 Suggestion for context help content
ad_desktop 2 2 14 1 Collection of Workbenches
ad_desktop_trl 2 14 1 Collection of Workbenches
ad_desktopworkbench 2 12 1 Desktop Workbench
ad_document_action_access 3 11 2,156 Define access to document type / document action / role combinations.
ad_element 6 1 20 5,783 System Element enables the central maintenance of column description and help.
ad_element_trl 2 20 5,783 System Element enables the central maintenance of column description and help.
ad_entitytype 59 17 12 System Entity Type
ad_error 1 12 0 Error
ad_field 5 13 57 20,329 Field on a database table
ad_field_trl 2 15 20,329 Field on a database table
ad_field_v 70 view AD_Field_v
ad_field_vt 71 view AD_Field_vt
ad_fieldgroup 5 1 13 72 Logical grouping of fields
ad_fieldgroup_trl 2 12 72 Logical grouping of fields
ad_fieldsuggestion 4 23 0 Suggestions for field label, description and help
ad_find 1 15 0 Find
ad_form 13 2 18 48 Special Form
ad_form_access 2 11 130 AD_Form_Access
ad_form_trl 2 14 48 Special Form
ad_housekeeping 1 22 9 House Keeping Configuration
ad_image 16 2 15 10 System Image or Icon
ad_impformat 3 1 15 15 Import Format
ad_impformat_row 2 23 163 Format Field
ad_importtemplate 1 6 16 0 Import Template
ad_importtemplateaccess 6 14 0 Import Template Access
ad_indexcolumn 3 14 1,355 Index definition for column
ad_infocolumn 5 7 37 134 Info Column
ad_infocolumn_trl 2 15 134 Info Window Column
ad_infoprocess 4 17 4 define process for info window
ad_inforelated 1 9 19 0 InfoRelated
ad_infowindow 12 4 30 11 Info Window
ad_infowindow_access 2 10 36 Info Window Access
ad_infowindow_trl 2 14 11 Info and search/select Window
ad_issue 9 50 0 System Issue
ad_labelprinter 2 11 0 Label Printer Definition
ad_labelprinterfunction 1 1 16 0 Function of Label Printer
ad_language 81 3 22 109 Language ID
ad_ldapaccess 3 15 0 Ldap Access Log
ad_ldapprocessor 2 1 17 1 LDAP Server
ad_ldapprocessorlog 1 16 0 LDAP Server Log
ad_menu 4 10 25 785 Identifies a Menu
ad_menu_trl 2 13 785 Identifies a Menu
ad_message 7 3 14 1,886 System Message
ad_message_trl 2 13 1,886 System Message
ad_migrationscript 21 793 Migration Scripts for the System
ad_modelvalidator 1 1 15 3 Global Model Validator
ad_modification 1 15 0 Modification
ad_note 5 20 0 System Notice
ad_org 171 2 13 10 Organizational entity within client
ad_org_v 19 view AD_Org_v
ad_orginfo 11 26 10 Organization Info
ad_orgtype 2 1 12 3 Organization Type allows you to categorize your organizations
ad_package_exp 1 23 0 Package Exp.
ad_package_exp_common 10 32 0 Common Package Exp.
ad_package_exp_detail 18 44 0 Package Exp. Detail
ad_package_imp 1 1 24 0 Package Imp.
ad_package_imp_backup 2 18 0 Imp. Package Backup
ad_package_imp_detail 2 21 0 Imp. Package Detail
ad_package_imp_inst 23 0 Package Imp. Inst.
ad_package_imp_proc 1 17 0 Package Imp. Proc.
ad_package_uuid_map 1 12 0 UUID Mapping between client
ad_password_history 5 13 0 Password History ID
ad_passwordrule 1 27 0 Password Policies
ad_pinstance 11 4 22 0 Instance of the process
ad_pinstance_log 2 9 0 (Non Standard Table)
ad_pinstance_para 1 19 0 AD_PInstance_Para
ad_postit 5 12 0 Post-it
ad_preference 6 16 17 Personal Preference
ad_printcolor 21 12 20 Color used for printing and display
ad_printcolor_trl 6 12 20 Color used for printing and display
ad_printfont 8 12 66 Maintain Print Font
ad_printform 15 25 2 Form
ad_printformat 23 9 31 89 Data Print Format
ad_printformat_trl 2 13 89 Data Print Format
ad_printformatitem 7 6 67 2,675 Item/Column in the Print format
ad_printformatitem_trl 2 14 2,675 Item/Column in the Print format
ad_printgraph 1 7 19 0 Graph included in Reports
ad_printheaderfooter 1 11 0 Print Header/Footer
ad_printlabel 1 2 17 0 Label Format to print
ad_printlabelline 1 3 18 0 Print Label Line Format
ad_printlabelline_trl 2 12 0 Print Label Line Format
ad_printpaper 2 22 4 Printer paper definition
ad_printtableformat 1 9 39 2 Table Format in Reports
ad_private_access 2 11 0 AD_Private_Access
ad_process 27 6 34 454 Process or Report
ad_process_access 4 11 1,252 Process Access
ad_process_para 6 7 38 1,145 Process Parameter
ad_process_para_trl 2 16 1,145 Process Parameter Trl
ad_process_trl 2 14 454 Process or Report
ad_recentitem 5 15 0 Recent Item
ad_record_access 2 14 0 AD_Record_Access
ad_ref_list 3 4 16 1,439 Reference List based on Table
ad_ref_list_trl 2 13 1,439 Reference List based on Table
ad_ref_table 9 18 223 Reference Table Definitions
ad_reference 31 4 17 553 System Reference (Pick List)
ad_reference_trl 2 14 553 System Reference and Validation
ad_registration 4 26 0 System Registration
ad_relationtype 3 18 6 Defines the sets of record pairs (and the conditions a given pair must fulfill to be part of one)
ad_replication 1 3 24 1 Data Replication Target
ad_replication_log 2 13 0 Data Replication Log Details
ad_replication_run 1 1 13 0 Data Replication Run
ad_replicationdocument 2 14 1 Replication Document
ad_replicationstrategy 4 2 15 2 Data Replication Strategy
ad_replicationtable 1 3 14 473 Data Replication Strategy Table Info
ad_reportview 6 2 15 102 View used to generate this report
ad_reportview_col 2 13 0 Report view Column
ad_reportview_column 6 10 0 Report View Selected column
ad_role 39 6 54 5 Responsibility Role
ad_role_included 2 11 0 Included Role
ad_role_orgaccess 2 10 18 AD_Role_OrgAccess
ad_rule 5 1 18 4 Rule
ad_schedule 5 20 5 Times for the Scheduler
ad_scheduler 3 6 30 10 Schedule Processes
ad_scheduler_para 2 13 11 AD_Scheduler_Para
ad_schedulerlog 1 16 0 Result of the execution of the Scheduler
ad_schedulerrecipient 4 15 1 Recipient of the Scheduler Notification
ad_searchdefinition 5 21 2 Search Definition
ad_sequence 6 2 27 1,412 Document Sequence
ad_sequence_audit 4 12 0 AD_Sequence_Audit
ad_sequence_no 3 11 0 AD_Sequence_No
ad_session 3 1 17 0 User Session Online or Web
ad_sessioninfo_v 23 view List of current logged in user
ad_smtp 18 0 SMTP Server
ad_statusline 1 6 13 4 Status Line
ad_statuslineusedin 9 16 13 AD_StatusLineUsedIn
ad_storageprovider 6 16 0 Storage Provider
ad_style 7 1 12 1 CSS style for field and label
ad_styleline 2 15 1 Style Line
ad_sysconfig 1 14 149 System Configurator
ad_system 2 43 1 System Definition
ad_tab 14 13 45 1,103 Tab within a Window
ad_tab_customization 2 15 0 Grid user customization
ad_tab_trl 2 15 1,103 Tab within a Window
ad_tab_v 43 view AD_Tab_v
ad_tab_vt 44 view AD_Tab_vt
ad_table 66 6 32 1,029 Table for the Fields
ad_table_access 4 15 1 AD_Table_Access
ad_table_scriptvalidator 2 13 0 Script model validator for tables
ad_table_trl 2 12 1,029 Database Table information
ad_tableindex 1 3 20 1,072 Index definition for table
ad_task 9 4 17 3 Operation System Task
ad_task_access 4 11 3 AD_Task_Access
ad_task_trl 2 14 3 Operation System Task
ad_taskinstance 3 10 0 Task Instance
ad_toolbarbutton 1 3 26 74 ToolBar Button
ad_toolbarbuttonrestrict 5 16 0 ToolBar Button Restrict
ad_tree 36 2 20 23 Identifies a Tree
ad_tree_favorite 1 1 10 4 Show user favorite menu on dashboard
ad_tree_favorite_node 1 3 18 24 Favorite Node Tree
ad_treebar 2 13 24 User Selected tree nodes
ad_treenode 1 12 406 Tree Node
ad_treenodebp 1 12 17 Tree Node BP
ad_treenodecmc 1 12 5 Tree Node CM Container
ad_treenodecmm 1 12 3 Tree Node CM Media
ad_treenodecms 1 12 5 Tree Node CM Stage
ad_treenodecmt 1 12 4 Tree Node CM Template
ad_treenodemm 1 12 786 Tree Node MM
ad_treenodepr 1 12 55 Tree Node PR
ad_treenodeu1 1 12 0 User defined tree 1
ad_treenodeu2 1 12 0 User defined tree 2
ad_treenodeu3 1 12 0 User defined tree 3
ad_treenodeu4 1 12 0 User defined tree 4
ad_user 218 14 68 8 User within the system - Internal or Business Partner Contact
ad_user_orgaccess 2 10 0 AD_User_OrgAccess
ad_user_roles 4 10 11 AD_User_Roles
ad_user_roles_v 2 view AD_User_Roles_v
ad_user_substitute 2 15 0 Substitute of the user
ad_userbpaccess 2 13 0 User/concat access to Business Partner information and resources
ad_userdef_field 10 44 0 User defined Field
ad_userdef_info 2 4 19 0 User defined Info Window
ad_userdef_info_column 6 31 0 User defined Info Column
ad_userdef_info_related 2 16 0 User defined Info Related
ad_userdef_proc 1 4 17 0 Primary Key : User defined Process
ad_userdef_proc_parameter 6 32 0 Primary Key : User defined Process Parameter
ad_userdef_tab 1 3 25 0 User defined Tab
ad_userdef_win 1 4 19 0 User defined Window
ad_usermail 3 21 1 Mail sent to the user
ad_userpreference 5 19 0 AD_UserPreference_ID
ad_userquery 5 18 1 Saved User Query
ad_val_rule 14 3 14 308 Dynamic Validation Rule
ad_viewcolumn 2 17 17,283 Database View Column
ad_viewcomponent 1 3 20 215 Database View Component
ad_wf_activity 3 7 25 12 Workflow Activity
ad_wf_activityapprover 2 11 0 Approvers of the Workflow Process Activity
ad_wf_activityresult 1 14 0 Result of the Workflow Process Activity
ad_wf_block 2 1 12 0 Workflow Transaction Execution Block
ad_wf_eventaudit 5 23 12 Workflow Process Activity Event Audit Information
ad_wf_nextcondition 3 18 1 Workflow Node Transition Condition
ad_wf_node 15 18 62 254 Workflow Node (activity) step or process
ad_wf_node_para 3 15 1 Workflow Node Execution Parameter
ad_wf_node_trl 2 14 254 Workflow Node (activity), step or process
ad_wf_nodenext 1 5 16 201 Workflow Node Transition
ad_wf_process 4 8 20 10 Actual Workflow Process Instance
ad_wf_processdata 1 12 0 Workflow Process Context
ad_wf_responsible 7 4 15 2 Responsible for Workflow Execution
ad_window 28 5 24 432 Data entry or display window
ad_window_access 4 11 1,216 AD_Window_Access
ad_window_trl 2 14 432 Data entry or display window
ad_window_vt 13 view AD_Window_vt
ad_wizardprocess 2 13 0 Wizard Process
ad_wlistbox_customization 1 12 0 Customization of the Wlistbox
ad_workbench 6 4 16 1 Collection of windows, reports
ad_workbench_trl 2 14 1 Collection of windows, reports
ad_workbenchwindow 6 17 2 Workbench Window
ad_workflow 22 9 48 56 Workflow or combination of tasks
ad_workflow_access 4 11 171 AD_Workflow_Access
ad_workflow_trl 2 14 56 Workflow or combination of tasks
ad_workflowprocessor 3 2 22 1 Workflow Processor Server
ad_workflowprocessorlog 1 16 0 Result of the execution of the Workflow Processor
ad_zoomcondition 3 17 6 Zoom condition
asp_clientexception 9 19 0 Client Exception
asp_clientlevel 2 12 0 Client Level
asp_field 2 12 0 ASP Field
asp_form 2 12 0 ASP Form
asp_level 7 1 15 0 ASP Level
asp_module 2 13 0 ASP Module
asp_process 1 2 12 0 ASP Process
asp_process_para 2 12 0 ASP Process Parameter
asp_ref_list 3 13 0 ASP_Ref_List
asp_tab 1 2 14 0 ASP Tab
asp_task 2 12 0 ASP Task
asp_window 1 2 12 0 ASP Window
asp_workflow 2 12 0 ASP Workflow
b_bid 4 16 0 Bid for a Topic
b_bidcomment 2 12 0 Make a comment to a Bid Topic
b_buyer 2 1 12 0 B_Buyer
b_buyerfunds 1 4 14 0 Buyer Funds for Bids on Topics
b_offer 4 16 0 Offer for a Topic
b_seller 2 1 13 0 B_Seller
b_sellerfunds 1 4 14 0 Seller Funds from Offers on Topics
b_topic 3 2 22 0 Auction Topic
b_topiccategory 1 1 12 0 Auction Topic Category
b_topictype 2 3 16 0 Auction Topic Type
c_1099box 3 14 0 1099 Box
c_acctprocessor 1 4 21 1 Accounting Processor/Server Parameters
c_acctprocessorlog 1 16 0 Result of the execution of the Accounting Processor
c_acctschema 51 6 35 2 Rules for accounting
c_acctschema_default 75 84 2 C_AcctSchema_Default
c_acctschema_element 14 26 12 Acct.Schema Element
c_acctschema_gl 11 22 2 C_AcctSchema_GL
c_activity 43 14 0 Business Activity
c_activity_trl 6 14 0 Business Activity
c_addresstransaction 6 24 0 Address Transaction
c_addressvalidation 2 5 17 0 Address Validation
c_addressvalidationcfg 1 4 19 0 Address Validation Configuration
c_allocationhdr 2 3 25 3 Payment allocation
c_allocationline 2 7 23 3 Allocation Line
c_bank 3 1 15 2 Bank
c_bankaccount 20 2 22 3 Account at the Bank
c_bankaccount_acct 14 22 6 C_BankAccount_Acct
c_bankaccount_processor 3 27 2 Bank Account Processor
c_bankaccountdoc 2 15 2 Checks, Transfers, etc.
c_bankstatement 2 1 31 2 Bank Statement of account
c_bankstatementline 1 6 42 2 Line on a statement from this Bank
c_bankstatementloader 1 28 0 Definition of Bank Statement Loader (SWIFT, OFX)
c_bankstatementmatcher 13 0 Algorithm to match Bank Statement Info to Business Partners, Invoices and Payments
c_bp_bankaccount 4 4 36 1 Bank Account of the Business Partner
c_bp_customer_acct 5 13 34 C_BP_Customer_Acct
c_bp_edi 1 3 28 0 Electronic Data Interchange
c_bp_employee_acct 4 12 17 C_BP_Employee_Acct
c_bp_group 11 6 23 3 Business Partner Group
c_bp_group_acct 15 24 6 Business Partner Group Acct
c_bp_relation 4 19 1 Business Partner Relation
c_bp_shippingacct 2 3 15 0 Business Partner Shipping Account
c_bp_vendor_acct 5 13 34 C_BP_Vendor_Acct
c_bp_withholding 2 13 0 C_BP_Withholding
c_bpartner 114 20 74 17 Identifies a Business Partner
c_bpartner_location 37 5 23 13 Identifies the (ship to) address for this Business Partner
c_bpartner_product 2 18 1 Product Business Partner
c_calendar 8 2 11 1 Accounting Calendar Name
c_campaign 42 1 17 2 Marketing Campaign
c_campaign_trl 6 13 2 Marketing Campaign
c_cash 1 8 30 3 Cash Journal
c_cashbook 10 1 13 2 Cash Book for recording petty cash transactions
c_cashbook_acct 7 15 4 C_CashBook_Acct
c_cashline 3 6 23 5 Cash Journal Line
c_cashplan 1 7 26 0 Cash Plan
c_cashplanline 2 12 29 0 Cash Plan Line
c_channel 1 1 12 2 Sales Channel
c_charge 32 3 18 3 Additional document charges
c_charge_acct 4 12 6 C_Charge_Acct
c_charge_trl 2 13 3 Additional document charges
c_chargetype 2 13 0 Charge Type
c_chargetype_doctype 2 12 0 Configuration table for charges to be used by document type
c_city 2 4 16 1 City
c_commission 2 4 21 1 Commission
c_commissionamt 1 2 14 0 Generated Commission Amount
c_commissiondetail 4 18 0 Supporting information for Commission Amounts
c_commissionline 1 7 25 1 Commission Line
c_commissionrun 1 1 16 0 Commission Run or Process
c_contactactivity 3 18 0 Events, tasks, communications related to a contact
c_conversion_rate 1 5 16 4 Rate used for converting currencies
c_conversiontype 14 13 4 Currency Conversion Rate Type
c_country 15 5 43 251 Country
c_country_trl 2 23 251 Country
c_countrygroup 4 4 15 0 Group of countries that share common needs like tax agreements
c_countrygroup_trl 6 13 0 Country Group Trl
c_countrygroupcountry 6 13 0 Country on Country Group
c_currency 62 2 19 175 The Currency for this record
c_currency_acct 6 14 0 C_Currency_Acct
c_currency_trl 2 13 175 The Currency for this record
c_cycle 1 1 12 2 Identifier for this Project Reporting Cycle
c_cyclephase 2 10 10 C_CyclePhase
c_cyclestep 1 1 13 4 The step for this Cycle
c_depositbatch 2 2 20 0 Deposit Batch
c_depositbatchline 2 15 0 Deposit Batch Line
c_doctype 51 8 42 52 Document type or rules
c_doctype_trl 2 14 52 Document type or rules
c_doctypecounter 2 17 1 Counter Document Relationship
c_dunning 4 14 2 Dunning Rules for overdue invoices
c_dunning_header_v 289 view Dunning Letter
c_dunning_header_vt 289 view C_Dunning_Header_vt
c_dunning_line_v 163 view Dunning Letter Lines
c_dunning_line_vt 163 view C_Dunning_Line_vt
c_dunninglevel 4 3 28 2 Dunning Level
c_dunninglevel_trl 2 13 2 Dunning Level Trl
c_dunningrun 1 2 16 0 Dunning Run
c_dunningrunentry 1 7 20 0 Dunning Run Entry
c_dunningrunline 4 23 0 Dunning Run Line
c_element 3 3 16 1 Accounting Element
c_elementvalue 78 5 30 379 Account Element
c_elementvalue_trl 2 13 379 Account Element
c_greeting 4 13 1 Greeting to print on correspondence
c_greeting_trl 2 13 1 Greeting to print on correspondence
c_interorg_acct 5 12 0 C_InterOrg_Acct
c_invoice 31 27 71 8 Invoice Identifier
c_invoice_candidate_v 8 view C_Invoice_Candidate_v
c_invoice_header_v 330 view Invoice Print View
c_invoice_header_vt 330 view C_Invoice_Header_vt
c_invoice_linetax_v 244 view Invoice Print View
c_invoice_linetax_vt 244 view C_Invoice_LineTax_vt
c_invoice_v 59 view C_Invoice_v
c_invoice_v1 51 view C_Invoice_v1
c_invoicebatch 1 3 20 0 Expense Invoice Batch Header
c_invoicebatchline 15 35 0 Expense Invoice Batch Line
c_invoiceline 16 23 51 24 Invoice Detail Line
c_invoiceline_v 27 view C_InvoiceLine_v
c_invoicepayschedule 1 2 18 2 Invoice Payment Schedule
c_invoiceschedule 1 20 1 Schedule for generating Invoices
c_invoicetax 3 15 8 C_InvoiceTax
c_job 4 1 14 4 Position
c_jobassignment 2 14 0 Position Assignment
c_jobcategory 1 12 4 Position Category
c_jobremuneration 2 14 0 Position Remuneration
c_landedcost 5 16 0 Landed Cost
c_landedcostallocation 5 16 0 Landed Cost Allocation
c_location 32 6 26 29 Location or Address
c_nonbusinessday 4 13 1 Day on which business is not transacted
c_onlinetrxhistory 1 14 0 Online Transaction History
c_opportunity 2 7 24 0 Sales Opportunity
c_order 31 38 92 8 Order
c_order_header_v 473 view Order Print View
c_order_header_vt 473 view C_Order_Header_vt
c_order_linetax_v 378 view Order Print View
c_order_linetax_vt 378 view C_Order_LineTax_vt
c_orderlandedcost 1 2 15 0 Estimated Landed Cost for Purchase Order
c_orderlandedcostallocation 2 15 0 Estimate landed cost allocation for order line
c_orderline 15 25 59 27 Sales Order Line
c_orderpayschedule 2 18 0 Order Payment Schedule
c_ordersource 2 4 13 0 Order Source
c_ordertax 3 15 8 Order Tax
c_orgassignment 2 13 0 Assigment to (transaction) Organization
c_payment 21 23 101 2 Payment identifier
c_payment_v 81 view Payment_v
c_paymentallocate 3 17 0 Allocate Payment to Invoices
c_paymentbatch 2 1 15 0 Payment batch for EFT
c_paymentprocessor 5 3 36 2 Payment processor for electronic payments
c_paymentterm 12 30 5 The terms for Payment of this transaction
c_paymentterm_trl 2 14 5 The terms of Payment (timing, discount)
c_paymenttransaction 1 20 79 0 Payment Transaction
c_payschedule 2 1 17 2 Payment Schedule Template
c_payselection 3 1 19 1 Payment Selection
c_payselection_check_v 202 view Check Print View
c_payselection_check_vt 202 view C_PaySelection_Check_vt
c_payselection_remittance_v 79 view Checl/Remittance View
c_payselection_remittance_vt 79 view C_PaySelection_Remittance_vt
c_payselectioncheck 1 4 23 1 Payment Selection Check
c_payselectionline 3 23 1 Payment Selection Line
c_period 17 3 16 264 Period of the Calendar
c_periodcontrol 1 14 7,392 Period Control
c_phase 4 2 16 13 Standard Phase of the Project Type
c_pos 1 10 26 1 Point of Sales Terminal
c_poskey 6 22 163 POS Function Key
c_poskeylayout 5 2 16 5 POS Function Key Layout
c_pospayment 3 30 0 POS Payment
c_postendertype 3 16 0 POS Tender Type
c_project 49 16 48 2 Financial Project
c_project_acct 4 12 4 C_Project_Acct
c_project_details_v 132 view Project Print View
c_project_details_vt 132 view C_Project_Details_vt
c_project_header_v 311 view Project Print View
c_project_header_vt 311 view C_Project_Header_vt
c_projectissue 6 7 27 0 Project Issues (Material, Labor)
c_projectissuema 2 11 0 C_ProjectIssueMA
c_projectline 9 31 1 Task or step in a project
c_projectphase 11 4 27 0 Phase of a Project
c_projecttask 10 3 20 0 Actual Project Task in a Phase
c_projecttype 3 13 4 Type of the project
c_recurring 1 6 26 1 Recurring Document
c_recurring_run 6 16 0 Recurring Document Run
c_recurringgroup 1 4 13 0 Recurring Group
c_region 10 3 13 399 Identifies a geographical Region
c_region_trl 6 12 399 Identifies a geographical Region
c_remuneration 2 18 0 Remuneration
c_revenuerecog_service 1 5 13 0 Plan for recognizing or recording revenue based on service
c_revenuerecognition 3 15 2 Method for recording revenue
c_revenuerecognition_plan 2 6 17 0 Plan for recognizing or recording revenue
c_revenuerecognition_run 3 14 0 Revenue Recognition Run or Process
c_rfq 2 7 38 1 Request for Quotation
c_rfq_topic 2 1 13 1 Topic for Request for Quotations
c_rfq_topicsubscriber 1 4 15 2 Request for Quotation Topic Subscriber
c_rfq_topicsubscriberonly 3 13 0 Include Subscriber only for certain products or product categories
c_rfqline 2 3 18 2 Request for Quotation Line
c_rfqlineqty 1 2 19 2 Request for Quotation Line Quantity
c_rfqresponse 1 6 31 0 Request for Quotation Response from a potential Vendor
c_rfqresponse_v 29 view C_RfQResponse_v
c_rfqresponse_vt 29 view C_RfQResponse_vt
c_rfqresponseline 1 2 18 0 Request for Quotation Response Line
c_rfqresponseline_v 31 view C_RfQResponseLine_v
c_rfqresponseline_vt 30 view C_RfQResponseLine_vt
c_rfqresponselineqty 2 14 0 Request for Quotation Response Line Quantity
c_rfqresponselineqty_v 16 view C_RfQResponseLineQty_v
c_rfqresponselineqty_vt 16 view C_RfQResponseLineQty_vt
c_salesdashboard 10 view Sales Dashboard
c_salesregion 14 1 15 2 Sales coverage region
c_salesregion_trl 6 13 2 Sales coverage region
c_salesstage 2 15 0 Stages of the sales process
c_salesstage_trl 6 13 0 Stages of the sales process
c_servicelevel 1 2 16 0 Product Revenue Recognition Service Level
c_servicelevelline 1 14 0 Product Revenue Recognition Service Level Line
c_subacct 4 1 14 0 Sub account for Element Value
c_subscription 1 3 17 0 Subscription of a Business Partner of a Product to renew
c_subscription_delivery 1 10 0 Optional Delivery Record for a Subscription
c_subscriptiontype 2 13 0 Type of subscription
c_task 1 2 16 9 Standard Project Type Task
c_tax 16 10 31 6 Tax identifier
c_tax_acct 7 15 12 C_Tax_Acct
c_tax_trl 2 14 6 Tax identifier
c_taxbase 1 15 0 Tax Base
c_taxcategory 8 13 1 Tax Category
c_taxcategory_trl 2 13 1 Tax Category
c_taxdeclaration 2 16 0 Define the declaration to the tax authorities
c_taxdeclarationacct 3 14 0 Tax Accounting Reconciliation
c_taxdeclarationline 7 22 0 Tax Declaration Document Information
c_taxdefinition 10 29 0 Tax Definition
c_taxgroup 2 13 0 Tax Group
c_taxpostal 1 12 0 Tax Postal/ZIP
c_taxprovider 4 5 16 0 Tax Provider
c_taxprovidercfg 1 4 13 0 Tax Provider Configuration
c_taxtype 1 13 0 Tax Type
c_uom 41 2 17 15 Unit of Measure
c_uom_conversion 5 14 1 Unit of Measure Conversion
c_uom_trl 2 14 15 Unit of Measure
c_userremuneration 2 18 0 Employee Wage or Salary Overwrite
c_validcombination 247 16 29 154 Valid Account Combination
c_withholding 2 2 23 0 Withholding type defined
c_withholding_acct 3 11 0 C_Withholding_Acct
c_year 5 3 13 22 Calendar Year
cm_accesscontainer 2 10 0 Web Access Container
cm_accesslistbpgroup 2 10 0 Web Access BP Group
cm_accesslistrole 2 10 0 Web Access Role
cm_accessmedia 2 10 0 Web Access Media
cm_accessnewschannel 2 10 0 Web Access NewsChannel
cm_accessprofile 6 13 0 Web Access Profile
cm_accessstage 2 10 0 Web Access Stage
cm_ad 2 26 0 An Advertisement is something like a banner
cm_ad_cat 2 1 13 0 Advertisement Categories define rotations and ad blocks
cm_broadcastserver 1 1 15 0 Web Broadcast Server
cm_chat 2 2 15 0 Chat
cm_chatentry 2 4 18 0 Chat Entry
cm_chattype 2 1 13 0 Chat Type
cm_chattypeupdate 2 11 0 Chat Type Update
cm_chatupdate 2 11 0 Chat Update
cm_container 7 3 35 5 Web Container contains content like images, text etc.
cm_container_element 1 1 15 6 Container element i.e. Headline, Content, Footer etc.
cm_container_element_trl 2 15 6 Container element i.e. Headline, Content, Footer etc.
cm_container_trl 2 17 5 Web Container contains content like images, text etc.
cm_container_url 1 13 0 Contains info on used URLs
cm_containerttable 2 16 0 Container Template Table
cm_cstage 5 3 37 5 Container Stage contains the staging content like images, text etc.
cm_cstage_element 1 1 15 7 Container element i.e. Headline, Content, Footer etc.
cm_cstage_element_trl 2 15 7 Container element i.e. Headline, Content, Footer etc.
cm_cstage_trl 2 17 5 Web Container Stage contains the staging content like images, text etc.
cm_cstagettable 2 16 0 Containet Stage Template Table
cm_media 4 2 18 3 Contains media content like images, flash movies etc.
cm_media_server 1 1 19 1 Media Server list to which content should get transfered
cm_mediadeploy 2 14 0 Media Deployment Log
cm_newschannel 2 2 15 0 News channel for rss feed
cm_newsitem 1 16 0 News item or article defines base content
cm_template 4 1 22 4 Template defines how content is displayed
cm_template_ad_cat 2 12 0 Get together the Template and the Advertising Category
cm_templatetable 2 2 15 0 CM Template Table Link
cm_webaccesslog 4 27 0 Web Access Log
cm_webproject 12 4 21 1 A web project is the main data container for Containers, URLs, Ads, Media etc.
cm_webproject_domain 2 15 1 Web Project Domain handling
cm_wikitoken 1 16 0 Wiki Token
dbreplicasyncverifier 1 1
dd_networkdistribution 3 1 20 2 Network Distribution
dd_networkdistributionline 4 18 10 Network Distribution Line
dd_order 3 17 64 0 Distribution Order
dd_order_header_v 53 view DD_Order_Header_v
dd_order_header_vt 53 view DD_Order_Header_vt
dd_orderline 2 15 43 0 Distribution Order Line
dual 1 1
exp_format 2 1 19 10 Export Format
exp_formatline 3 21 43 Format Line
exp_processor 2 1 18 2 Export Processor
exp_processor_type 1 14 2 Export Processor Type
exp_processorparameter 1 15 7 Processor Parameter
fact_acct 3 27 47 0 Accounting Fact
fact_acct_balance 31 view Fact_Acct_Balance
fact_acct_summary 19 34 0 Accounting Fact summary
fact_reconciliation 1 11 0 Accounting Fact Reconciliation
gl_budget 8 13 1 General Ledger Budget
gl_budgetcontrol 2 17 0 Budget Control
gl_category 11 14 10 General Ledger Category
gl_category_trl 6 12 10 General Ledger Category
gl_distribution 1 16 48 1 General Ledger Distribution
gl_distributionline 15 39 2 General Ledger Distribution Line
gl_fund 1 1 16 0 General Ledger Funds Control
gl_fundrestriction 2 13 0 Restriction of Funds
gl_journal 5 9 36 1 General Ledger Journal
gl_journalbatch 7 5 28 1 General Ledger Journal Batch
gl_journalgenerator 1 5 19 2 GL Journal Generator
gl_journalgeneratorline 1 4 22 6 Generator Line
gl_journalgeneratorsource 3 15 8 Generator Source
gl_journalline 2 23 43 2 General Ledger Journal Line
gl_journalline_acct_v 37 view GL_JournalLine_Acct_v
hr_attribute 8 28 0 Payroll Employee Attribute
hr_concept 5 5 30 0 Payroll Concept
hr_concept_acct 7 17 0 Payroll Concept Account
hr_concept_category 2 1 14 0 Payroll Concept Category
hr_contract 1 3 18 0 Payroll Contract
hr_department 7 1 13 0 Payroll Department
hr_employee 3 5 22 0 Payroll Employee
hr_job 6 3 17 0 Payroll Job
hr_list 2 4 18 0 Payroll List
hr_listline 1 21 0 Payroll List Line
hr_listtype 1 12 0 Payroll List Type
hr_listversion 1 2 15 0 Payroll List Version
hr_movement 1 18 39 0 Payroll Movement
hr_payroll 8 3 18 0 Payroll
hr_payrollconcept 3 17 0 Payroll Concept
hr_period 1 4 23 0 Payroll Period
hr_process 3 13 32 0 Payroll Process
hr_year 1 2 16 0 Payroll Year
i_asset 12 83 0 Asset
i_bankstatement 8 60 0 Import of the Bank Statement
i_bpartner 8 51 0 Import Business Partner
i_conversion_rate 4 25 2 Import Currency Conversion Rate
i_elementvalue 4 31 0 Import Account Value
i_fajournal 24 72 0 FA Journal
i_fixedasset 1 11 54 0 Imported Fixed Asset
i_gljournal 26 70 0 Import General Ledger Journal
i_hr_movement 4 26 0 Payroll Movement Import
i_inoutlineconfirm 1 19 0 Material Shipment or Receipt Confirmation Import Line
i_inventory 8 38 0 Import Inventory Transactions
i_invoice 22 64 0 Import Invoice
i_movement 12 44 0 I_Movement_ID
i_order 26 68 0 Import Orders
i_payment 7 71 0 Import Payment
i_pricelist 6 34 0 Import Price List and Versions
i_product 5 58 0 Import Item or Service
i_productplanning 12 52 0 Import Product Planning
i_reportline 4 30 0 Import Report Line Set values
imp_processor 2 1 24 2 Import Processor
imp_processor_type 1 14 2 Import Processor Type
imp_processorlog 1 17 0 Import Processor Log
imp_processorparameter 1 15 6 Import Processor Parameter
k_category 2 12 1 Knowledge Category
k_categoryvalue 1 1 12 0 The value of the category
k_comment 2 14 0 Knowledge Entry Comment
k_entry 4 3 19 0 Knowledge Entry
k_entrycategory 3 11 0 K_EntryCategory
k_entryrelated 2 11 0 Related Entry for this Enntry
k_index 4 17 0 Index
k_indexlog 12 0 Index Log
k_indexstop 3 14 0 Index Stop
k_source 1 11 1 Source of a Knowledge Entry
k_synonym 1 12 0 Knowlege Keyword Synonym
k_topic 1 1 15 1 Knowledge Topic
k_type 1 14 2 Knowledge Type
m_attribute 4 4 19 4 Product Attribute
m_attributeinstance 3 14 5 M_AttributeInstance
m_attributesearch 1 11 1 Common Search Attribute
m_attributeset 5 2 29 4 Product Attribute Set
m_attributesetexclude 2 12 0 Exclude the ability to enter Attribute Sets
m_attributesetinstance 47 2 15 4 Product Attribute Set Instance
m_attributeuse 2 11 5 M_AttributeUse
m_attributevalue 1 1 13 9 Product Attribute Value
m_bom 2 2 17 1 Bill of Material
m_bomalternative 1 1 12 1 Product BOM Alternative Group
m_bomproduct 6 23 0 Bill of Material Component (Product)
m_bp_price 3 22 0 Business Partner specific pricing that will override the price list
m_changenotice 11 16 1 Change Notice
m_changerequest 1 3 19 0 Change Request
m_commodityshipment 2 14 0 Commodity Shipment
m_cost 7 23 267 Product Cost
m_costdetail 1 15 33 0 Cost Detail Information
m_costelement 9 14 9 Cost Element
m_costhistory 4 21 0 Movement history for M_Cost
m_costmovement_v 35 view Cost movement for M_Cost
m_costqueue 5 16 0 FiFo/LiFo Cost Queue
m_costtype 5 12 1 Type of Cost
m_demand 1 2 16 0 Material Demand
m_demanddetail 4 13 0 Material Demand Line Source Detail
m_demandline 1 3 14 0 Material Demand Line
m_discountschema 7 19 3 Schema to calculate the trade discount percentage
m_discountschemabreak 3 16 1 Trade Discount Break
m_discountschemaline 5 43 11 Line of the pricelist trade discount schema
m_distributionlist 3 14 1 Distribution Lists allow to distribute products to a selected list of partners
m_distributionlistline 1 3 15 3 Distribution List Line with Business Partner and Quantity/Percentage
m_distributionrun 2 2 15 1 Distribution Run create Orders to distribute products to a selected list of partners
m_distributionrunline 1 3 16 1 Distribution Run Lines define Distribution List, the Product and Quantiries
m_edi 1 3 27 0 EDI Transaction
m_edi_info 1 10 0 EDI Log
m_forecast 3 3 17 4 Material Forecast
m_forecastline 3 5 17 50 Forecast Line
m_freight 7 20 3 Freight Rate
m_freightcategory 3 13 2 Category of the Freight
m_inout 10 26 77 9 Material Shipment Document
m_inout_candidate_v 12 view M_InOut_Candidate_v
m_inout_header_v 236 view Shipment Print View
m_inout_header_vt 236 view M_InOut_Header_vt
m_inout_line_v 191 view Shipment Print View
m_inout_line_vt 191 view M_InOut_Line_vt
m_inout_lineconfirm_v 40 view Confirmation Print View
m_inout_lineconfirm_vt 40 view M_InOut_LineConfirm_vt
m_inoutconfirm 1 3 25 1 Material Shipment or Receipt Confirmation
m_inoutconfirm_v 34 view Confirmation Print View
m_inoutconfirm_vt 34 view M_InOutConfirm_vt
m_inoutline 21 19 40 27 Line on Shipment or Receipt document
m_inoutlineconfirm 1 4 20 1 Material Shipment or Receipt Confirmation Line
m_inoutlinema 2 13 0 M_InOutLineMA
m_inoutlinema_returned 14 view M_InOutLineMA_Returned
m_inoutlinema_v 14 view M_InOutLineMA_v
m_inoutlinema_vt 14 view M_InOutLineMA_vt
m_inventory 5 13 35 3 Parameters for a Physical Inventory
m_inventoryline 11 6 25 1 Unique line in an Inventory document
m_inventorylinema 2 13 0 M_InventoryLineMA
m_locator 27 4 17 11 Warehouse Locator
m_locatortype 1 4 15 0 Locator Type
m_lot 1 2 16 0 Product Lot Definition
m_lotctl 3 16 1 Product Lot Control
m_lotctlexclude 2 12 0 Exclude the ability to create Lots in Attribute Sets
m_matchinv 4 6 24 18 Match Shipment/Receipt to Invoice
m_matchpo 2 7 27 37 Match Purchase Order to Shipment/Receipt and Invoice
m_movement 4 18 47 1 Movement of Inventory
m_movement_candidate_v 12 view M_Movement_Candidate_v
m_movementconfirm 1 2 19 0 Inventory Move Confirmation
m_movementline 7 8 24 1 Inventory Move document Line
m_movementlineconfirm 3 18 0 Inventory Move Line Confirmation
m_movementlinema 2 13 0 M_MovementLineMA
m_movementlinema_v 15 view M_MovementLineMA_v
m_movementlinema_vt 15 view M_MovementLineMA_vt
m_operationresource 3 18 0 Product Operation Resource
m_package 3 11 72 1 Shipment Package
m_packageline 4 15 1 The detail content of the Package
m_packagelines_avail_v 9 view M_PackageLines_Avail_v
m_packagemps 2 3 23 0 Package MPS
m_parttype 1 11 0 Manufacturing part type
m_perpetualinv 1 2 20 0 Rules for generating physical inventory
m_pricelist 22 2 20 3 Unique identifier of a Price List
m_pricelist_trl 6 13 3 Unique identifier of a Price List
m_pricelist_version 7 3 16 5 Identifies a unique instance of a Price List
m_pricelist_version_trl 6 12 5 Identifies a unique instance of a Price List
m_product 123 16 72 55 Product Service Item
m_product_acct 26 34 110 Product Acct
m_product_bom 15 view BOM Line
m_product_bom_old 2 15 20
m_product_category 16 3 19 14 Category of a Product
m_product_category_acct 26 37 28 Product Category Acct
m_product_category_trl 6 13 14 Category of a Product
m_product_po 6 32 29 Product Purchasing
m_product_qualitytest 2 12 0 Product Quality Test
m_product_stock_v 17 view Product Stock at Warehouses
m_product_substituterelated_v 18 view Product Substitute with Stock Info
m_product_trl 2 14 55 Product, Service, Item
m_productdownload 1 1 12 1 Product downloads
m_production 4 16 40 0 Plan for producing a product
m_productionline 6 5 21 0 Document Line representing a production
m_productionlinema 2 12 0 Production Line MA
m_productionplan 1 3 16 0 Plan for how a product is produced
m_productoperation 2 1 16 0 Product Operation
m_productprice 2 14 86 Product Price
m_productpricevendorbreak 3 16 0 Product Price Break
m_promotion 5 1 13 0 Promotion setup
m_promotiondistribution 2 2 16 0 Distribute order line items into multiple bucket for reward calculation
m_promotiongroup 2 11 0 Grouping of product for promotion setup
m_promotiongroupline 2 11 0 Line items of a promotion group
m_promotionline 1 2 13 0 Promotion line items
m_promotionprecondition 6 21 0 Pre condition for promotion
m_promotionreward 4 20 0 Setup reward for the promotion
m_qualitytest 2 12 0 Quality Test
m_qualitytestresult 2 14 0 Quality Test Result
m_relatedproduct 2 13 1 Product Related
m_replenish 4 16 19 M_Replenish
m_requisition 2 4 27 1 Material Requisition
m_requisitionline 2 7 21 1 Material Requisition Line
m_rma 7 8 30 1 Return Material Authorization
m_rmaline 3 6 23 1 Return Material Authorization Line
m_rmatax 3 15 0 Return Material Authorization Tax
m_rmatype 1 12 1 Return Material Authorization Type
m_sernoctl 2 16 1 Product Serial Number Control
m_sernoctlexclude 2 12 0 Exclude the ability to create Serial Numbers in Attribute Sets
m_shipper 15 3 14 3 Method or manner of product delivery
m_shippercfg 4 1 19 1 Method or manner of product delivery
m_shipperlabels 2 2 14 0 Shipper Labels
m_shipperlabelscfg 1 1 17 0 Shipper Labels Configuration
m_shipperpackaging 2 2 14 0 Shipper Packaging
m_shipperpackagingcfg 1 1 15 0 Shipper Packaging Configuration
m_shipperpickuptypes 2 2 13 0 Shipper Pickup Types
m_shipperpickuptypescfg 1 1 14 0 Shipper Pickup Types Configuration
m_shippingprocessor 3 1 14 1 Shipping Processor
m_shippingprocessorcfg 2 19 1 Shipping Processor Configuration
m_shippingtransaction 1 23 89 0 Shipping Transaction
m_shippingtransactionline 4 23 0 Shipping Transaction Line
m_storage 16 view M_Storage
m_storageonhand 3 14 20 M_StorageOnHand
m_storagereservation 3 14 2 M_StorageReservation
m_storagereservationlog 9 21 0 Log for every storage reservation quantity change
m_substitute 4 12 0 M_Substitute
m_transaction 3 9 21 28 Inventory Transaction
m_transaction_v 24 view M_Transaction_v
m_transactionallocation 10 22 0 M_TransactionAllocation
m_warehouse 42 5 19 11 Storage Warehouse and Service Point
m_warehouse_acct 6 14 22 M_Warehouse_Acct
mfa_method 2 2 21 2 Multi-factor Authentication Method
mfa_registereddevice 1 13 0 Multi-factor Authentication Registered Device
mfa_registration 2 24 0 Multi-factor Authentication Registration
mfa_rule 1 11 2 Multi-factor Authentication Rule
pa_achievement 1 17 0 Performance Achievement
pa_benchmark 2 13 0 Performance Benchmark
pa_benchmarkdata 1 14 0 Performance Benchmark Data Point
pa_colorschema 1 5 20 2 Performance Color Schema
pa_dashboardcontent 5 6 28 10 Dashboard Content
pa_dashboardcontent_access 7 12 2 PA_DashboardContent_Access_ID
pa_dashboardcontent_trl 2 14 10 Dashboard Content Trl
pa_dashboardpreference 3 16 0 Dashboard Preference
pa_documentstatus 2 11 24 6 Document Status
pa_documentstatus_trl 2 12 6 Document Status Trl
pa_documentstatusaccess 3 12 0 Document Status Access
pa_goal 3 5 29 4 Performance Goal
pa_goalrestriction 7 17 0 Performance Goal Restriction
pa_hierarchy 1 8 20 0 Reporting Hierarchy
pa_measure 2 6 22 4 Concrete Performance Measurement
pa_measurecalc 2 2 20 6 Calculation method for measuring performance
pa_ratio 3 1 13 1 Performace Ratio
pa_ratioelement 4 20 3 Performance Ratio Element
pa_report 8 24 3 Financial Report
pa_reportcolumn 3 15 57 17 Column in Report
pa_reportcolumn_trl 2 13 17 Column in Report
pa_reportcolumnset 2 12 3 Collection of Columns for Report
pa_reportcube 2 1 31 0 Define reporting cube for pre-calculation of summary accounting data.
pa_reportline 7 5 29 113 Report Line
pa_reportline_trl 2 13 113 Report Line Trl
pa_reportlineset 3 12 3 Report Line Set
pa_reportsource 1 11 36 93 Restriction of what will be shown in Report Line
pa_sla_criteria 1 14 2 Service Level Agreement Criteria
pa_sla_goal 1 2 21 1 Service Level Agreement Goal
pa_sla_measure 2 17 1 Service Level Agreement Measure
pp_cost_collector 6 20 47 0 Manufacturing Cost Collector
pp_cost_collectorma 2 12 0 Manufacturing Order MA
pp_mrp 15 41 56 Material Requirement Planning
pp_order 10 17 66 2 Manufacturing Order
pp_order_bom 2 5 26 2 Manufacturing Order BOM
pp_order_bom_header_v 63 view Manufacturing Order BOM Head *** Templete ***
pp_order_bom_header_vt 63 view PP_Order_BOM_Header_vt
pp_order_bom_trl 2 14 2 Manufacturing Order BOM Trl
pp_order_bomline 3 9 44 4 Manufacturing Order BOM Line
pp_order_bomline_trl 2 13 4 Manufacturing Order BOM Line Trl
pp_order_bomline_v 45 view Manufacturing Order BOM Lines *** Templete ***
pp_order_bomline_vt 46 view PP_Order_BOMLine_vt
pp_order_cost 7 24 0 Manufacturing Order Cost
pp_order_header_v 66 view PP_Order_Header_v
pp_order_header_vt 66 view PP_Order_Header_vt
pp_order_node 7 16 70 2 Manufacturing Order Activity
pp_order_node_asset 4 13 0 Manufacturing Order Activity Asset
pp_order_node_product 4 17 0 Manufacturing Order Activity Product
pp_order_node_trl 2 14 2 Workflow Node (activity), step or process
pp_order_node_v 44 view Manufacturing Order Node
pp_order_node_vt 44 view PP_Order_Node_vt
pp_order_nodenext 6 19 0 Manufacturing Order Activity Next
pp_order_workflow 5 9 47 2 Manufacturing Order Workflow
pp_order_workflow_header_v 71 view Manufacturing Order Workflow Header
pp_order_workflow_header_vt 72 view PP_Order_Workflow_Header_vt
pp_order_workflow_trl 2 14 2 Manufacturing Order Workflow Trl
pp_product_bom 9 4 25 7 BOM & Formula
pp_product_bom_trl 2 14 7 BOM & Formula
pp_product_bomline 1 5 32 21 BOM Line
pp_product_bomline_trl 2 13 21 BOM Line
pp_product_bomline_v 31 view PP_Product_BOMLine_v
pp_product_bomline_vt 31 view PP_Product_BOMLine_vt
pp_product_planning 1 7 34 219 Product Planning
pp_wf_node_asset 2 12 0 Workflow Node Asset
pp_wf_node_product 3 17 0 Workflow Node Product
qm_specification 1 4 18 0 Quality Specification
qm_specificationline 2 17 0 QM Specification Line
r_category 3 1 13 3 Request Category
r_categoryupdates 2 11 1 R_CategoryUpdates
r_contactinterest 2 12 1 R_ContactInterest
r_group 3 3 15 2 Request Group
r_groupupdates 2 11 1 R_GroupUpdates
r_interestarea 3 13 2 Interest Area or Topic
r_issueknown 1 3 21 0 Known Issue
r_issueproject 2 2 16 0 Issue Project
r_issuerecommendation 1 12 0 Issue Recommendation
r_issuesource 3 13 0
r_issuestatus 1 11 0 Issue Status
r_issuesystem 2 1 14 0 Issue System
r_issueuser 2 1 12 0 User who reported issues
r_mailtext 15 15 3 Text templates for mailings
r_mailtext_trl 2 16 3 Text templates for mailings
r_request 6 27 65 1 Request from a Business Partner or Prospect
r_request_v 64 view R_Request_v
r_requestaction 20 46 2 Request History
r_requestprocessor 2 3 24 1 Request Processor
r_requestprocessor_route 3 14 1 Automatic routing of requests
r_requestprocessorlog 1 16 0 Request Processor Log
r_requesttype 9 1 25 3 Type of request (e.g. Inquiry, Complaint, ..)
r_requesttypeupdates 2 11 1 Request Type Updates
r_requestupdate 2 17 1 Request Update
r_requestupdates 2 11 0 Request Update Recipiants
r_resolution 2 12 3 Request Resolution
r_standardresponse 1 11 1 Request Standard Response
r_status 4 3 23 4 Request Status
r_statuscategory 2 13 1 Request Status Category
rv_allocation 38 view Allocation
rv_asset_customer 23 view Asset Customer
rv_asset_delivery 28 view Asset Delivery
rv_asset_summonth 23 view Asset SumMonth
rv_bpartner 148 view BPartner
rv_bpartneropen 33 view BPartnerOpen
rv_c_invoice 167 view Invoice
rv_c_invoice_customerprodqtr 14 view Invoice CustomerProdQtr
rv_c_invoice_customervendqtr 13 view Invoice CustomerVendQtr
rv_c_invoice_day 12 view Invoice Day
rv_c_invoice_month 12 view Invoice Month
rv_c_invoice_prodmonth 13 view Invoice ProdMonth
rv_c_invoice_productmonth 13 view Invoice ProductMonth
rv_c_invoice_productqtr 13 view Invoice ProductQtr
rv_c_invoice_prodweek 13 view Invoice ProdWeek
rv_c_invoice_vendormonth 13 view Invoice VendorMonth
rv_c_invoice_week 12 view Invoice Week
rv_c_invoiceline 131 view InvoiceLine
rv_c_invoicetax 136 view InvoiceTax
rv_c_rfq_unanswered 20 view RfQ UnAnswered
rv_c_rfqresponse 33 view RfQ Response
rv_cash_detail 24 view Cash Detail
rv_click_month 8 view Click by Month
rv_click_unprocessed 18 view Click Unprocessed
rv_commissionrundetail 283 view Commission Run Detail
rv_cost 92 view Product Costs
rv_costdetail 106 view Product Cost Detail
rv_costsummary 19 view Product Cost Summary
rv_dd_orderdetail 48 view Distribution Order & Line View
rv_fact_acct 190 view Accounting Fact View
rv_fact_acct_day 31 view Fact Acct Day
rv_fact_acct_period 30 view Fact Acct Period
rv_fact_adaxa 43 view Complex Fact View
rv_fact_simple 17 view Simple Fact View
rv_inoutconfirm 21 view InOut Confirm
rv_inoutdetails 125 view InOut Details
rv_inoutlineconfirm 29 view InOut Line Confirm
rv_m_forecast 21 view Forecast Report
rv_m_forecast_period 12 view Forecast Report for Period
rv_m_product_whereused_v 12 view Product/Component Where Used
rv_m_requisition 30 view Requisition
rv_m_transaction 105 view With Product_PO info
rv_m_transaction_sum 8 view Transaction Sum
rv_openitem 69 view Open Item
rv_openitemtodate 24 view RV_OpenItemToDate
rv_orderdetail 158 view Order & Line View
rv_payment 89 view Payment
rv_pp_mrp 43 view View Material Requirement Planning
rv_pp_operation_activity 19 view View Operation_Activity
rv_pp_order 59 view RV_PP_Order
rv_pp_order_bomline 23 view View Order BOM Line
rv_pp_order_receipt_issue 23 view RV_PP_Order_Receipt_Issue
rv_pp_order_storage 28 view View Order Storage
rv_pp_order_transactions 24 view View Manufacturing Order Transactions
rv_pp_order_workflow 29 view View Order Workflow
rv_pp_product_bomline 29 view View Product BOM Line
rv_printformatdetail 67 view PrintFormat Detail
rv_projectcycle 41 view Project Cycle
rv_projectlineissue 32 view Project Line Issue
rv_requestupdates 13 view Recipient of Requests with Source
rv_requestupdates_only 9 view Distinct Recipients of Requests
rv_requestupdates_v 9 view RV_RequestUpdates_v
rv_storage 96 view Warehouse Storage
rv_storage_per_product 17 view Storage per Product
rv_t_1099extract 40 view 1099 Extract
rv_transaction 215 view Mat Transaction
rv_unposted 18 view Not Posted
rv_unprocessed 17 view Not Processed
rv_warehouseprice 26 view Warehouse Price
s_expensetype 1 3 16 1 Expense report type
s_resource 12 3 24 11 Resource
s_resourceassignment 3 1 16 2 Resource Assignment
s_resourcetype 1 3 29 3 Resource Type
s_resourceunavailable 1 13 2 Resource Unavailability
s_timeexpense 1 3 21 1 Time and Expense Report
s_timeexpenseline 1 14 38 4 Time and Expense Report Line
s_timetype 1 12 0 Type of time recorded
s_training 1 3 19 1 Repeated Training
s_training_class 2 13 0 The actual training class instance
t_1099extract 32 0 1099 Extract
t_aging 7 46 0 T_Aging
t_alter_column 5 0
t_bankregister 14 0 Bank Register
t_bom_indented 25 0 Indented BOM Report
t_bomline 30 0 Temporal BOM Line
t_bomline_costs 39 view Cost BOM Line
t_cashflow 30 0 T_CashFlow_ID
t_distributionrundetail 7 18 0 T_DistributionRunDetail
t_inventoryvalue 7 24 0 T_InventoryValue
t_invoicegl 5 25 0 Gain/Loss - actual data shown id T_InvoiceGL_v
t_invoicegl_v 126 view Gain/Loss
t_moveclient 4 0
t_mrp_crp 12 0 Temporal MRP & CRP
t_reconciliation 11 0 Account reconciliation report
t_replenish 5 21 0 T_Replenish
t_report 2 40 0 Temporary Reporting Table
t_reportstatement 1 11 0 T_ReportStatement
t_rv_reconciliation 192 view Accounting Fact Reconciliation Report View
t_selection 3 0
t_selection2 3 0
t_selection_infowindow 8 0
t_spool 1 3 0 Temporary Spool Table
t_transaction 10 29 0 T_Transaction
t_trialbalance 1 44 0 Trial Balance
test 1 31 1 Test ID
u_blacklistcheque 11 0 Black List Cheque
u_posterminal 15 37 1 POS Terminal
u_rolemenu 2 11 74 Role Menu
u_web_properties 11 143 Web Properties
u_webmenu 2 1 20 143 Web Menu
w_advertisement 4 28 1 Web Advertisement
w_basket 1 3 14 0 Web Basket
w_basketline 2 16 0 Web Basket Line
w_click 2 19 0 Individual Web Click
w_clickcount 2 1 13 1 Web Click Management
w_counter 2 19 0 Individual Count hit
w_countercount 2 1 13 1 Web Counter Count Management
w_mailmsg 2 1 17 0 Web Store Mail Message Template
w_mailmsg_trl 2 15 0 Web Store Mail Message Template
w_store 2 5 43 1 A Web Store of the Client
w_store_trl 2 20 1 A Web Store of the Client
ws_webservice 2 13 2 Web Service
ws_webservice_para 1 13 46 Web Service Parameters
ws_webservicefieldinput 4 17 45 Web Service Field Input
ws_webservicefieldoutput 2 11 8 Web Service Field Output
ws_webservicemethod 1 1 14 9 Web Service Method
ws_webservicetype 4 3 17 16 Web Service Type
ws_webservicetypeaccess 2 11 16 Web Service Type Access
x_packagelineweight 9 view X_PackageLineWeight
           
879 Tables     18,044 174,410  
157 Views     11,851