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

Home | ERP 6.0 
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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

161 tablesERP 6.0 

Public Sector Management :: Grants Management :: Grantee Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0GMAVCA444Actual line item tableGrantee Management
2ERP EHP76.0GMAVCC72Object table 2Grantee Management
3ERP EHP76.0GMAVCO122Object table 1Grantee Management
4ERP EHP76.0GMAVCP1084Plan line items tableGrantee Management
5ERP EHP76.0GMAVCT943Summary tableGrantee Management
6ERP EHP76.0GMCCSETTINGS81Company code settingsGrantee Management
7ERP EHP76.0GMCOUPD61CO Settings for Grants Management UpdateGrantee Management
8ERP EHP76.0GMDEFARCHIVE41Define Archiving Settings for GMGrantee Management
9ERP EHP76.0GMFIUPD81FI Settings for Grants Management UpdateGrantee Management
10ERP EHP76.0GMGRANTNONE21Definition of Grant used as "Non-Relevant"Grantee Management
11ERP EHP76.0GMIA907Actual Line Item TableGrantee Management
12ERP EHP76.0GMIC42Object table GMICGrantee Management
13ERP EHP76.0GMIO162Object table GMIOGrantee Management
14ERP EHP76.0GMIP904Plan line items tableGrantee Management
15ERP EHP76.0GMIT763Summary tableGrantee Management
16ERP EHP76.0GMVALUETYPE61Value Type definitionGrantee Management
17ERP EHP76.0GMVALUETYPE_TEXT41Value Type textsGrantee Management
Public Sector Management :: Grants Management :: Grantee Management :: Actual Update and Commitment Update
ProductVersionTableColumnsIndexesDescriptionModule
18ERP EHP76.0GMA_ACE_BILLING61Accrual Engine: Grant Master Data Transfer by Billing RuleActual Update and Commitment Update
19ERP EHP76.0GMA_ACE_GMFI51Accrual Engine: Assignment for Grant Master Data TransferActual Update and Commitment Update
20ERP EHP76.0GMA_ACE_GRANT61Accrual Engine: Assignment for Grant Master Data TransferActual Update and Commitment Update
21ERP EHP76.0GMA_ACE_OBJECTS31GM Accruals: Accrual ObjectsActual Update and Commitment Update
22ERP EHP76.0GMREVBDGTFM191Defult settings for GM revaluation of currencyActual Update and Commitment Update
Public Sector Management :: Grants Management :: Grantee Management :: Budgeting and Availability Control
ProductVersionTableColumnsIndexesDescriptionModule
23ERP EHP76.0GMAVCBUDFILTH71AVC filter settings for GM budget values: header entriesBudgeting and Availability Control
24ERP EHP76.0GMAVCLDGRACT51Activation of availability ledger for Grants ManagementBudgeting and Availability Control
25ERP EHP76.0GMAVCLDGRATT81Attributes of Availability Control Ledger -Grants ManagementBudgeting and Availability Control
26ERP EHP76.0GMAVCLDGRGAT41Year-Independent Attributes of Control Ledger (GM)Budgeting and Availability Control
27ERP EHP76.0GMBASIDX32Index table for GM objectsBudgeting and Availability Control
28ERP EHP76.0GMBASOBJNR112Object numbers of GM addressesBudgeting and Availability Control
29ERP EHP76.0GMBDGTDISTHDR81GM Budgeting GM-FM Distribution HeaderBudgeting and Availability Control
30ERP EHP76.0GMBDGTDISTID41GM Budgeting GM-FM Distribution IDBudgeting and Availability Control
31ERP EHP76.0GMBDGTDISTLINES71GM Budgeting GM-FM Distribution LinesBudgeting and Availability Control
32ERP EHP76.0GMBDGTDOCTYPE91Budget Document TypeBudgeting and Availability Control
33ERP EHP76.0GMBDGTDOCTYPET41Budget Document Type DescriptionsBudgeting and Availability Control
34ERP EHP76.0GMBDGTFM51FM defaults for Interface with GM BudgetBudgeting and Availability Control
35ERP EHP76.0GMBDGTFYDLINE231GM Budgeting Fiscal Year Distribution LinesBudgeting and Availability Control
36ERP EHP76.0GMBDGTHDRPRCSS11User Interface GM ProcessBudgeting and Availability Control
37ERP EHP76.0GMBDGTHDRPRCSST31User Interface GM ProcessBudgeting and Availability Control
38ERP EHP76.0GMBDGTHEADER322Budget Document HeaderBudgeting and Availability Control
39ERP EHP76.0GMBDGTLINE291Budget Document LineBudgeting and Availability Control
40ERP EHP76.0GMBDGTLSTNUMBER81Last Budget Document StatusBudgeting and Availability Control
41ERP EHP76.0GMBDGTREASONCD21Reason Codes for Plan/Budget DocumentsBudgeting and Availability Control
42ERP EHP76.0GMBDGTREASONCDT41Reason Codes for Plan/Budget DocumentsBudgeting and Availability Control
43ERP EHP76.0GMBDGTSETTINGS81General GM Budgeting Transactions SettingsBudgeting and Availability Control
44ERP EHP76.0GMBDGTSETVERSION111General GM Budgeting Transactions SettingsBudgeting and Availability Control
45ERP EHP76.0GMBDGTVALIDITY101Grant budget validityBudgeting and Availability Control
46ERP EHP76.0GMBDGTVERSION31Plan/Budget VersionsBudgeting and Availability Control
47ERP EHP76.0GMCSRULES31Cost Sharing RulesBudgeting and Availability Control
48ERP EHP76.0GMCSRULESTEXTS41Cost sharing rule textsBudgeting and Availability Control
49ERP EHP76.0GMFMRECS121GM RIB: FM Receivers (obsolete)Budgeting and Availability Control
50ERP EHP76.0GMFMRECS191GM RIB: FM Budget ReceiversBudgeting and Availability Control
51ERP EHP76.0GMHBDGTFYDLINE241GM Budgeting Fiscal Year Distribution LinesBudgeting and Availability Control
52ERP EHP76.0GMHBDGTHEADER222Budget Header: Held DocumentsBudgeting and Availability Control
53ERP EHP76.0GMHBDGTLINE301Budget Line: Held DocumentsBudgeting and Availability Control
54ERP EHP76.0GMRBBOBJECTS121Master Data For Revenue Increasing the Budget: RIB ObjectsBudgeting and Availability Control
55ERP EHP76.0GMRBBRECS61GM Master Data For RIB: Budget Receivers per RIB ObjectBudgeting and Availability Control
56ERP EHP76.0GMRBFMREC71GM RIB: FM Budget ReceiversBudgeting and Availability Control
57ERP EHP76.0GMRMBDGT61Budget Document Types- Records Management InterfaceBudgeting and Availability Control
58ERP EHP76.0GMSPLITRULES31Splitting Rules re Time Intervals Used in Sponsored ProgramsBudgeting and Availability Control
59ERP EHP76.0GMSPLITRULEST41Splitting Rules TextBudgeting and Availability Control
60ERP EHP76.0GMSPLITRULES_ELE61Splitting Rule ElementsBudgeting and Availability Control
Public Sector Management :: Grants Management :: Grantee Management :: Grants Management - Specific Postings
ProductVersionTableColumnsIndexesDescriptionModule
61ERP EHP76.0GMBRSD51SD OBJECTS for a GRANTGrants Management - Specific Postings
Public Sector Management :: Grants Management :: Grantee Management :: Master Data
ProductVersionTableColumnsIndexesDescriptionModule
62ERP EHP76.0GMASPCLASS71Sponsored Class - Sponsor Specific DataMaster Data
63ERP EHP76.0GMASPPROG61Sponsored Program - Sponsor Specific DataMaster Data
64ERP EHP76.0GMASPREPORT71Reporting Records - - Sponsor Specific DataMaster Data
65ERP EHP76.0GMAUTHGRP31Grants Management: Authority GroupsMaster Data
66ERP EHP76.0GMAUTHGRPT51Grants Management: Authority Groups DescriptionsMaster Data
67ERP EHP76.0GMAWARDTYPE21User defined award types for sponsored program managementMaster Data
68ERP EHP76.0GMAWARDTYPETEXTS41Award type textsMaster Data
69ERP EHP76.0GMBDGTLAYOUT41Grants Management Budget LayoutMaster Data
70ERP EHP76.0GMBR51Billing RulesMaster Data
71ERP EHP76.0GMBRE31Billing Rule ElementsMaster Data
72ERP EHP76.0GMBRM31Rules for Manual BillingMaster Data
73ERP EHP76.0GMBRTEXTS41Billing RulesMaster Data
74ERP EHP76.0GMCFDA21CFDA CodesMaster Data
75ERP EHP76.0GMCFDAT41CFDA CodesMaster Data
76ERP EHP76.0GMCOA121Special GL accounts in chart of accounts for grants mgmtMaster Data
77ERP EHP76.0GMFGC101Obsolete - do not use.Master Data
78ERP EHP76.0GMFGC_1111Obsolete - do not useMaster Data
79ERP EHP76.0GMFGC_LIFE111Field group criteria (Grants)Master Data
80ERP EHP76.0GMFGC_USER121Field group criteria (Grants) system+user statusMaster Data
81ERP EHP76.0GMFUNDRECOVER_O101Fund recovery for outgoing grantsMaster Data
82ERP EHP76.0GMGAAP61Special GL accounts in chart of accounts for GM GAAPMaster Data
83ERP EHP76.0GMGAAPVT31GAAP Accruals VT customizingMaster Data
84ERP EHP76.0GMGBDGTLAYOUT41Grants Management Budget LayoutMaster Data
85ERP EHP76.0GMGFUND71Grant specific fund detailsMaster Data
86ERP EHP76.0GMGR645Grant MasterMaster Data
87ERP EHP76.0GMGRCOSTSHARE91Cost sharing master dataMaster Data
88ERP EHP76.0GMGRELATED72GM Grant relationshipsMaster Data
89ERP EHP76.0GMGRFUNDRECOVER81Fund recoveryMaster Data
90ERP EHP76.0GMGRIDCCAP81Grant IDC Cap (Program + Class)Master Data
91ERP EHP76.0GMGRIDCCAP261Grant IDC Cap (Grant level)Master Data
92ERP EHP76.0GMGRIDCCAP2_O71Grant IDC Cap (Grant level) for outgoing grantMaster Data
93ERP EHP76.0GMGRIDCCAP_O91Grant IDC Cap (Program + Class) for outgoing grantMaster Data
94ERP EHP76.0GMGRREPORT81Grant report trackingMaster Data
95ERP EHP76.0GMGRRESPONSIBLE72Objects responsible for the grantMaster Data
96ERP EHP76.0GMGRSPONSOREDOBJ91Grant sponsored objectsMaster Data
97ERP EHP76.0GMGRTEXTS51Texts for grant masterMaster Data
98ERP EHP76.0GMGRTYPE141Grant typeMaster Data
99ERP EHP76.0GMGRTYPEREPORT71GM Reports from Grant TypeMaster Data
100ERP EHP76.0GMGRTYPETEXTS41Grant type textsMaster Data
101ERP EHP76.0GMGRVALUETYPE71Value type settings for posting controlMaster Data
102ERP EHP76.0GMGRXCHNGCURR71GM grant master exchange currencyMaster Data
103ERP EHP76.0GMGRXCHNGCURRTXT41GM grant master exchange currency textMaster Data
104ERP EHP76.0GMGSPCLASS41Grant specific sponsored class detailsMaster Data
105ERP EHP76.0GMGSPPROGRAM31Grant specific sponsored program detailsMaster Data
106ERP EHP76.0GMGTSPONSOR111Sponsor Master: Grant Type dependant attributesMaster Data
107ERP EHP76.0GMIDCRULES61Indirect cost rulesMaster Data
108ERP EHP76.0GMIDCRULES_ELE31Billing Rule ElementsMaster Data
109ERP EHP76.0GMIDCRULETEXTS41Indirect cost rulesMaster Data
110ERP EHP76.0GMINDIRECTCOST71IDC rates for directly sponsored grants [incoming grants]Master Data
111ERP EHP76.0GMINDIRECTCOST_O81Indirect costs for outgoing grantsMaster Data
112ERP EHP76.0GMINDIRECTCOST_R71Indirect costs for recipientMaster Data
113ERP EHP76.0GMLDC21Legislative District CodesMaster Data
114ERP EHP76.0GMLDCT41Legislative District DescriptionsMaster Data
115ERP EHP76.0GMLOC21Letter of Credit DefinitionMaster Data
116ERP EHP76.0GMLOCTEXT41Letter of Credit DefinitionMaster Data
117ERP EHP76.0GMOMD111Grants Management Object Mapper TableMaster Data
118ERP EHP76.0GMPAYMENTRULE21Payment RuleMaster Data
119ERP EHP76.0GMPRTEXTS41Payment Rule TextMaster Data
120ERP EHP76.0GMRELATIONSHIP111GM Relationship definition between grants and other objectsMaster Data
121ERP EHP76.0GMRELATIONSHIPT61GM Relationship textMaster Data
122ERP EHP76.0GMREPCLASS21GM Report ClassMaster Data
123ERP EHP76.0GMREPCLASST41GM Reprot Class TextMaster Data
124ERP EHP76.0GMREPORT111GM Report TrackingMaster Data
125ERP EHP76.0GMREPORTRULE31GM Report RuleMaster Data
126ERP EHP76.0GMREPORTRULET41Description of GM Report RuleMaster Data
127ERP EHP76.0GMRESPEVENTS41Grant responsibility eventsMaster Data
128ERP EHP76.0GMRESPTYPE21Responsibility types - Sponsored programs managementMaster Data
129ERP EHP76.0GMRESPTYPET41Responsible type textMaster Data
130ERP EHP76.0GMRMBDGT_ACT31Budget Document Types- Records Management InterfaceMaster Data
131ERP EHP76.0GMRMBUPA91Business Partner - Records Management InterfaceMaster Data
132ERP EHP76.0GMRMBUPA_ACT51Business Partner - Records Management InterfaceMaster Data
133ERP EHP76.0GMRMELEMENTS31Parameters for Records Management InterfaceMaster Data
134ERP EHP76.0GMRMELEMENTSTEXT51Parameters for Records Management InterfaceMaster Data
135ERP EHP76.0GMRMGRTYPE71Grant Types - Records Managment InterfaceMaster Data
136ERP EHP76.0GMRMGRTYPE_ACT31Grant Types - Records Management InterfaceMaster Data
137ERP EHP76.0GMSCHEDULERULE71GM Schedule RuleMaster Data
138ERP EHP76.0GMSCHEDULERULET41Description for the GM schedule ruleMaster Data
139ERP EHP76.0GMSMVALUETYPE71Value type control by grant type and statusMaster Data
140ERP EHP76.0GMSMVALUETYPE_161Value type control by grant type and statusMaster Data
141ERP EHP76.0GMSPAGT51Allowed Grant Types for SponsorMaster Data
142ERP EHP76.0GMSPCLASS141Sponsored Class MasterMaster Data
143ERP EHP76.0GMSPCLASSTEXTS51Sponsored Class Description textsMaster Data
144ERP EHP76.0GMSPCLASS_FMBA41Sponsored Class Master Data - Budget Allowed ObjectMaster Data
145ERP EHP76.0GMSPCLASS_FMBT51Sponsored Class Master Data - Budget Transfer ObjectMaster Data
146ERP EHP76.0GMSPONSOR171Sponsor MasterMaster Data
147ERP EHP76.0GMSPONSORLOC31Sponsor Master: Letter of Credit ReferencesMaster Data
148ERP EHP76.0GMSPPROGRAM161Sponsored program masterMaster Data
149ERP EHP76.0GMSPPROGRAMTEXTS51Sponsored Program textsMaster Data
150ERP EHP76.0GMSPPROGRAM_FMBA61Sponsored Program Master Data - Budget Allowed ObjectMaster Data
151ERP EHP76.0GMSPPROGRAM_FMBT71Sponsored Program Master Data - Budget Transfer ObjectsMaster Data
152ERP EHP76.0GMSPRESPONSIBLE81Objects responsible for the sponsored programMaster Data
153ERP EHP76.0GMSPRESPTYP81Responsibility Defaults for SponsorMaster Data
154ERP EHP76.0GMSTATNET171Grants Management Status NetworkMaster Data
155ERP EHP76.0GMSTATNETHISTORY91Historical status information Sponsored Programs MgmtMaster Data
156ERP EHP76.0GMSTATNET_INT131Grants Management Status NetworkMaster Data
157ERP EHP76.0GMWFACTIVITIES31GM Workflow ActivitiesMaster Data
158ERP EHP76.0GMWFACTIVITIEST41GM Workflow Activities TextMaster Data
159ERP EHP76.0GMWFAVC41GM Workflow AVCMaster Data
160ERP EHP76.0GMWFBUDGET81GM Workflow Grant MasterMaster Data
161ERP EHP76.0GMWFGRANTM71GM Workflow Grant MasterMaster Data

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy