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

100 tablesERP 6.0 

Public Sector Management :: Grants Management :: Grantee Management :: Master Data
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0GMASPCLASS71Sponsored Class - Sponsor Specific DataMaster Data
2ERP EHP76.0GMASPPROG61Sponsored Program - Sponsor Specific DataMaster Data
3ERP EHP76.0GMASPREPORT71Reporting Records - - Sponsor Specific DataMaster Data
4ERP EHP76.0GMAUTHGRP31Grants Management: Authority GroupsMaster Data
5ERP EHP76.0GMAUTHGRPT51Grants Management: Authority Groups DescriptionsMaster Data
6ERP EHP76.0GMAWARDTYPE21User defined award types for sponsored program managementMaster Data
7ERP EHP76.0GMAWARDTYPETEXTS41Award type textsMaster Data
8ERP EHP76.0GMBDGTLAYOUT41Grants Management Budget LayoutMaster Data
9ERP EHP76.0GMBR51Billing RulesMaster Data
10ERP EHP76.0GMBRE31Billing Rule ElementsMaster Data
11ERP EHP76.0GMBRM31Rules for Manual BillingMaster Data
12ERP EHP76.0GMBRTEXTS41Billing RulesMaster Data
13ERP EHP76.0GMCFDA21CFDA CodesMaster Data
14ERP EHP76.0GMCFDAT41CFDA CodesMaster Data
15ERP EHP76.0GMCOA121Special GL accounts in chart of accounts for grants mgmtMaster Data
16ERP EHP76.0GMFGC101Obsolete - do not use.Master Data
17ERP EHP76.0GMFGC_1111Obsolete - do not useMaster Data
18ERP EHP76.0GMFGC_LIFE111Field group criteria (Grants)Master Data
19ERP EHP76.0GMFGC_USER121Field group criteria (Grants) system+user statusMaster Data
20ERP EHP76.0GMFUNDRECOVER_O101Fund recovery for outgoing grantsMaster Data
21ERP EHP76.0GMGAAP61Special GL accounts in chart of accounts for GM GAAPMaster Data
22ERP EHP76.0GMGAAPVT31GAAP Accruals VT customizingMaster Data
23ERP EHP76.0GMGBDGTLAYOUT41Grants Management Budget LayoutMaster Data
24ERP EHP76.0GMGFUND71Grant specific fund detailsMaster Data
25ERP EHP76.0GMGR645Grant MasterMaster Data
26ERP EHP76.0GMGRCOSTSHARE91Cost sharing master dataMaster Data
27ERP EHP76.0GMGRELATED72GM Grant relationshipsMaster Data
28ERP EHP76.0GMGRFUNDRECOVER81Fund recoveryMaster Data
29ERP EHP76.0GMGRIDCCAP81Grant IDC Cap (Program + Class)Master Data
30ERP EHP76.0GMGRIDCCAP261Grant IDC Cap (Grant level)Master Data
31ERP EHP76.0GMGRIDCCAP2_O71Grant IDC Cap (Grant level) for outgoing grantMaster Data
32ERP EHP76.0GMGRIDCCAP_O91Grant IDC Cap (Program + Class) for outgoing grantMaster Data
33ERP EHP76.0GMGRREPORT81Grant report trackingMaster Data
34ERP EHP76.0GMGRRESPONSIBLE72Objects responsible for the grantMaster Data
35ERP EHP76.0GMGRSPONSOREDOBJ91Grant sponsored objectsMaster Data
36ERP EHP76.0GMGRTEXTS51Texts for grant masterMaster Data
37ERP EHP76.0GMGRTYPE141Grant typeMaster Data
38ERP EHP76.0GMGRTYPEREPORT71GM Reports from Grant TypeMaster Data
39ERP EHP76.0GMGRTYPETEXTS41Grant type textsMaster Data
40ERP EHP76.0GMGRVALUETYPE71Value type settings for posting controlMaster Data
41ERP EHP76.0GMGRXCHNGCURR71GM grant master exchange currencyMaster Data
42ERP EHP76.0GMGRXCHNGCURRTXT41GM grant master exchange currency textMaster Data
43ERP EHP76.0GMGSPCLASS41Grant specific sponsored class detailsMaster Data
44ERP EHP76.0GMGSPPROGRAM31Grant specific sponsored program detailsMaster Data
45ERP EHP76.0GMGTSPONSOR111Sponsor Master: Grant Type dependant attributesMaster Data
46ERP EHP76.0GMIDCRULES61Indirect cost rulesMaster Data
47ERP EHP76.0GMIDCRULES_ELE31Billing Rule ElementsMaster Data
48ERP EHP76.0GMIDCRULETEXTS41Indirect cost rulesMaster Data
49ERP EHP76.0GMINDIRECTCOST71IDC rates for directly sponsored grants [incoming grants]Master Data
50ERP EHP76.0GMINDIRECTCOST_O81Indirect costs for outgoing grantsMaster Data
51ERP EHP76.0GMINDIRECTCOST_R71Indirect costs for recipientMaster Data
52ERP EHP76.0GMLDC21Legislative District CodesMaster Data
53ERP EHP76.0GMLDCT41Legislative District DescriptionsMaster Data
54ERP EHP76.0GMLOC21Letter of Credit DefinitionMaster Data
55ERP EHP76.0GMLOCTEXT41Letter of Credit DefinitionMaster Data
56ERP EHP76.0GMOMD111Grants Management Object Mapper TableMaster Data
57ERP EHP76.0GMPAYMENTRULE21Payment RuleMaster Data
58ERP EHP76.0GMPRTEXTS41Payment Rule TextMaster Data
59ERP EHP76.0GMRELATIONSHIP111GM Relationship definition between grants and other objectsMaster Data
60ERP EHP76.0GMRELATIONSHIPT61GM Relationship textMaster Data
61ERP EHP76.0GMREPCLASS21GM Report ClassMaster Data
62ERP EHP76.0GMREPCLASST41GM Reprot Class TextMaster Data
63ERP EHP76.0GMREPORT111GM Report TrackingMaster Data
64ERP EHP76.0GMREPORTRULE31GM Report RuleMaster Data
65ERP EHP76.0GMREPORTRULET41Description of GM Report RuleMaster Data
66ERP EHP76.0GMRESPEVENTS41Grant responsibility eventsMaster Data
67ERP EHP76.0GMRESPTYPE21Responsibility types - Sponsored programs managementMaster Data
68ERP EHP76.0GMRESPTYPET41Responsible type textMaster Data
69ERP EHP76.0GMRMBDGT_ACT31Budget Document Types- Records Management InterfaceMaster Data
70ERP EHP76.0GMRMBUPA91Business Partner - Records Management InterfaceMaster Data
71ERP EHP76.0GMRMBUPA_ACT51Business Partner - Records Management InterfaceMaster Data
72ERP EHP76.0GMRMELEMENTS31Parameters for Records Management InterfaceMaster Data
73ERP EHP76.0GMRMELEMENTSTEXT51Parameters for Records Management InterfaceMaster Data
74ERP EHP76.0GMRMGRTYPE71Grant Types - Records Managment InterfaceMaster Data
75ERP EHP76.0GMRMGRTYPE_ACT31Grant Types - Records Management InterfaceMaster Data
76ERP EHP76.0GMSCHEDULERULE71GM Schedule RuleMaster Data
77ERP EHP76.0GMSCHEDULERULET41Description for the GM schedule ruleMaster Data
78ERP EHP76.0GMSMVALUETYPE71Value type control by grant type and statusMaster Data
79ERP EHP76.0GMSMVALUETYPE_161Value type control by grant type and statusMaster Data
80ERP EHP76.0GMSPAGT51Allowed Grant Types for SponsorMaster Data
81ERP EHP76.0GMSPCLASS141Sponsored Class MasterMaster Data
82ERP EHP76.0GMSPCLASSTEXTS51Sponsored Class Description textsMaster Data
83ERP EHP76.0GMSPCLASS_FMBA41Sponsored Class Master Data - Budget Allowed ObjectMaster Data
84ERP EHP76.0GMSPCLASS_FMBT51Sponsored Class Master Data - Budget Transfer ObjectMaster Data
85ERP EHP76.0GMSPONSOR171Sponsor MasterMaster Data
86ERP EHP76.0GMSPONSORLOC31Sponsor Master: Letter of Credit ReferencesMaster Data
87ERP EHP76.0GMSPPROGRAM161Sponsored program masterMaster Data
88ERP EHP76.0GMSPPROGRAMTEXTS51Sponsored Program textsMaster Data
89ERP EHP76.0GMSPPROGRAM_FMBA61Sponsored Program Master Data - Budget Allowed ObjectMaster Data
90ERP EHP76.0GMSPPROGRAM_FMBT71Sponsored Program Master Data - Budget Transfer ObjectsMaster Data
91ERP EHP76.0GMSPRESPONSIBLE81Objects responsible for the sponsored programMaster Data
92ERP EHP76.0GMSPRESPTYP81Responsibility Defaults for SponsorMaster Data
93ERP EHP76.0GMSTATNET171Grants Management Status NetworkMaster Data
94ERP EHP76.0GMSTATNETHISTORY91Historical status information Sponsored Programs MgmtMaster Data
95ERP EHP76.0GMSTATNET_INT131Grants Management Status NetworkMaster Data
96ERP EHP76.0GMWFACTIVITIES31GM Workflow ActivitiesMaster Data
97ERP EHP76.0GMWFACTIVITIEST41GM Workflow Activities TextMaster Data
98ERP EHP76.0GMWFAVC41GM Workflow AVCMaster Data
99ERP EHP76.0GMWFBUDGET81GM Workflow Grant MasterMaster Data
100ERP EHP76.0GMWFGRANTM71GM Workflow Grant MasterMaster Data