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
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

196 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 :: Grantor Management
ProductVersionTableColumnsIndexesDescriptionModule
18ERP EHP76.0CRMD_GRM_CASE72Case RelationGrantor Management
19ERP EHP76.0GTRCUST_ACCGRP31Assignment Customer -> Customer account groupsGrantor Management
20ERP EHP76.0GTRCUST_ARCHIVE41Grantor: Customizing Archiving GTR Billing Documents (AP/AR)Grantor Management
21ERP EHP76.0GTRC_CRM_CASECV21Grantor Management: Case Object ConvertGrantor Management
22ERP EHP76.0GTRC_CRM_PROXY41Grantor Management: Proxy processesGrantor Management
23ERP EHP76.0GTRFIAPAR31Grantor: FI AP/AR related dataGrantor Management
24ERP EHP76.0GTRFIAPARDOC51Grantor: FI AP/AR related data - Payment Type - Doc TypeGrantor Management
25ERP EHP76.0GTRFIBILLREL61Relationship Table Grantor Billing Doc <-> AP/AR DocGrantor Management
26ERP EHP76.0GTRFIBILL_H431Header of Grantor FI AP/AR Billing DocGrantor Management
27ERP EHP76.0GTRFIBILL_HT81Grantor FI AP/AR Billing Doc Header Text TableGrantor Management
28ERP EHP76.0GTRFIBILL_I191Grantor Billing Document ItemsGrantor Management
29ERP EHP76.0GTRFIBILL_IT81Grantor FI AP/AR Billing Doc Header Text TableGrantor Management
30ERP EHP76.0GTRFIINV_TRG81Trigger Table for Grantor Notification to CRMGrantor Management
31ERP EHP76.0GTRVEND_ACCGRP31Assignment Vendor -> Vendor account groupsGrantor Management
32ERP EHP76.0GTR_CRM_GPM41CRM Grantor Program Management: Mapping ID/LOGSYS -> GUIDGrantor Management
Public Sector Management :: Grants Management :: Grantee Management :: Actual Update and Commitment Update
ProductVersionTableColumnsIndexesDescriptionModule
33ERP EHP76.0GMA_ACE_BILLING61Accrual Engine: Grant Master Data Transfer by Billing RuleActual Update and Commitment Update
34ERP EHP76.0GMA_ACE_GMFI51Accrual Engine: Assignment for Grant Master Data TransferActual Update and Commitment Update
35ERP EHP76.0GMA_ACE_GRANT61Accrual Engine: Assignment for Grant Master Data TransferActual Update and Commitment Update
36ERP EHP76.0GMA_ACE_OBJECTS31GM Accruals: Accrual ObjectsActual Update and Commitment Update
37ERP EHP76.0GMREVBDGTFM191Defult settings for GM revaluation of currencyActual Update and Commitment Update
Public Sector Management :: Grants Management :: Grantee Management :: Budgeting and Availability Control
ProductVersionTableColumnsIndexesDescriptionModule
38ERP EHP76.0GMAVCBUDFILTH71AVC filter settings for GM budget values: header entriesBudgeting and Availability Control
39ERP EHP76.0GMAVCLDGRACT51Activation of availability ledger for Grants ManagementBudgeting and Availability Control
40ERP EHP76.0GMAVCLDGRATT81Attributes of Availability Control Ledger -Grants ManagementBudgeting and Availability Control
41ERP EHP76.0GMAVCLDGRGAT41Year-Independent Attributes of Control Ledger (GM)Budgeting and Availability Control
42ERP EHP76.0GMBASIDX32Index table for GM objectsBudgeting and Availability Control
43ERP EHP76.0GMBASOBJNR112Object numbers of GM addressesBudgeting and Availability Control
44ERP EHP76.0GMBDGTDISTHDR81GM Budgeting GM-FM Distribution HeaderBudgeting and Availability Control
45ERP EHP76.0GMBDGTDISTID41GM Budgeting GM-FM Distribution IDBudgeting and Availability Control
46ERP EHP76.0GMBDGTDISTLINES71GM Budgeting GM-FM Distribution LinesBudgeting and Availability Control
47ERP EHP76.0GMBDGTDOCTYPE91Budget Document TypeBudgeting and Availability Control
48ERP EHP76.0GMBDGTDOCTYPET41Budget Document Type DescriptionsBudgeting and Availability Control
49ERP EHP76.0GMBDGTFM51FM defaults for Interface with GM BudgetBudgeting and Availability Control
50ERP EHP76.0GMBDGTFYDLINE231GM Budgeting Fiscal Year Distribution LinesBudgeting and Availability Control
51ERP EHP76.0GMBDGTHDRPRCSS11User Interface GM ProcessBudgeting and Availability Control
52ERP EHP76.0GMBDGTHDRPRCSST31User Interface GM ProcessBudgeting and Availability Control
53ERP EHP76.0GMBDGTHEADER322Budget Document HeaderBudgeting and Availability Control
54ERP EHP76.0GMBDGTLINE291Budget Document LineBudgeting and Availability Control
55ERP EHP76.0GMBDGTLSTNUMBER81Last Budget Document StatusBudgeting and Availability Control
56ERP EHP76.0GMBDGTREASONCD21Reason Codes for Plan/Budget DocumentsBudgeting and Availability Control
57ERP EHP76.0GMBDGTREASONCDT41Reason Codes for Plan/Budget DocumentsBudgeting and Availability Control
58ERP EHP76.0GMBDGTSETTINGS81General GM Budgeting Transactions SettingsBudgeting and Availability Control
59ERP EHP76.0GMBDGTSETVERSION111General GM Budgeting Transactions SettingsBudgeting and Availability Control
60ERP EHP76.0GMBDGTVALIDITY101Grant budget validityBudgeting and Availability Control
61ERP EHP76.0GMBDGTVERSION31Plan/Budget VersionsBudgeting and Availability Control
62ERP EHP76.0GMCSRULES31Cost Sharing RulesBudgeting and Availability Control
63ERP EHP76.0GMCSRULESTEXTS41Cost sharing rule textsBudgeting and Availability Control
64ERP EHP76.0GMFMRECS121GM RIB: FM Receivers (obsolete)Budgeting and Availability Control
65ERP EHP76.0GMFMRECS191GM RIB: FM Budget ReceiversBudgeting and Availability Control
66ERP EHP76.0GMHBDGTFYDLINE241GM Budgeting Fiscal Year Distribution LinesBudgeting and Availability Control
67ERP EHP76.0GMHBDGTHEADER222Budget Header: Held DocumentsBudgeting and Availability Control
68ERP EHP76.0GMHBDGTLINE301Budget Line: Held DocumentsBudgeting and Availability Control
69ERP EHP76.0GMRBBOBJECTS121Master Data For Revenue Increasing the Budget: RIB ObjectsBudgeting and Availability Control
70ERP EHP76.0GMRBBRECS61GM Master Data For RIB: Budget Receivers per RIB ObjectBudgeting and Availability Control
71ERP EHP76.0GMRBFMREC71GM RIB: FM Budget ReceiversBudgeting and Availability Control
72ERP EHP76.0GMRMBDGT61Budget Document Types- Records Management InterfaceBudgeting and Availability Control
73ERP EHP76.0GMSPLITRULES31Splitting Rules re Time Intervals Used in Sponsored ProgramsBudgeting and Availability Control
74ERP EHP76.0GMSPLITRULEST41Splitting Rules TextBudgeting and Availability Control
75ERP EHP76.0GMSPLITRULES_ELE61Splitting Rule ElementsBudgeting and Availability Control
Public Sector Management :: Grants Management :: Grantee Management :: Grants Management - Specific Postings
ProductVersionTableColumnsIndexesDescriptionModule
76ERP EHP76.0GMBRSD51SD OBJECTS for a GRANTGrants Management - Specific Postings
Public Sector Management :: Grants Management :: Grantee Management :: Master Data
ProductVersionTableColumnsIndexesDescriptionModule
77ERP EHP76.0GMASPCLASS71Sponsored Class - Sponsor Specific DataMaster Data
78ERP EHP76.0GMASPPROG61Sponsored Program - Sponsor Specific DataMaster Data
79ERP EHP76.0GMASPREPORT71Reporting Records - - Sponsor Specific DataMaster Data
80ERP EHP76.0GMAUTHGRP31Grants Management: Authority GroupsMaster Data
81ERP EHP76.0GMAUTHGRPT51Grants Management: Authority Groups DescriptionsMaster Data
82ERP EHP76.0GMAWARDTYPE21User defined award types for sponsored program managementMaster Data
83ERP EHP76.0GMAWARDTYPETEXTS41Award type textsMaster Data
84ERP EHP76.0GMBDGTLAYOUT41Grants Management Budget LayoutMaster Data
85ERP EHP76.0GMBR51Billing RulesMaster Data
86ERP EHP76.0GMBRE31Billing Rule ElementsMaster Data
87ERP EHP76.0GMBRM31Rules for Manual BillingMaster Data
88ERP EHP76.0GMBRTEXTS41Billing RulesMaster Data
89ERP EHP76.0GMCFDA21CFDA CodesMaster Data
90ERP EHP76.0GMCFDAT41CFDA CodesMaster Data
91ERP EHP76.0GMCOA121Special GL accounts in chart of accounts for grants mgmtMaster Data
92ERP EHP76.0GMFGC101Obsolete - do not use.Master Data
93ERP EHP76.0GMFGC_1111Obsolete - do not useMaster Data
94ERP EHP76.0GMFGC_LIFE111Field group criteria (Grants)Master Data
95ERP EHP76.0GMFGC_USER121Field group criteria (Grants) system+user statusMaster Data
96ERP EHP76.0GMFUNDRECOVER_O101Fund recovery for outgoing grantsMaster Data
97ERP EHP76.0GMGAAP61Special GL accounts in chart of accounts for GM GAAPMaster Data
98ERP EHP76.0GMGAAPVT31GAAP Accruals VT customizingMaster Data
99ERP EHP76.0GMGBDGTLAYOUT41Grants Management Budget LayoutMaster Data
100ERP EHP76.0GMGFUND71Grant specific fund detailsMaster Data
101ERP EHP76.0GMGR645Grant MasterMaster Data
102ERP EHP76.0GMGRCOSTSHARE91Cost sharing master dataMaster Data
103ERP EHP76.0GMGRELATED72GM Grant relationshipsMaster Data
104ERP EHP76.0GMGRFUNDRECOVER81Fund recoveryMaster Data
105ERP EHP76.0GMGRIDCCAP81Grant IDC Cap (Program + Class)Master Data
106ERP EHP76.0GMGRIDCCAP261Grant IDC Cap (Grant level)Master Data
107ERP EHP76.0GMGRIDCCAP2_O71Grant IDC Cap (Grant level) for outgoing grantMaster Data
108ERP EHP76.0GMGRIDCCAP_O91Grant IDC Cap (Program + Class) for outgoing grantMaster Data
109ERP EHP76.0GMGRREPORT81Grant report trackingMaster Data
110ERP EHP76.0GMGRRESPONSIBLE72Objects responsible for the grantMaster Data
111ERP EHP76.0GMGRSPONSOREDOBJ91Grant sponsored objectsMaster Data
112ERP EHP76.0GMGRTEXTS51Texts for grant masterMaster Data
113ERP EHP76.0GMGRTYPE141Grant typeMaster Data
114ERP EHP76.0GMGRTYPEREPORT71GM Reports from Grant TypeMaster Data
115ERP EHP76.0GMGRTYPETEXTS41Grant type textsMaster Data
116ERP EHP76.0GMGRVALUETYPE71Value type settings for posting controlMaster Data
117ERP EHP76.0GMGRXCHNGCURR71GM grant master exchange currencyMaster Data
118ERP EHP76.0GMGRXCHNGCURRTXT41GM grant master exchange currency textMaster Data
119ERP EHP76.0GMGSPCLASS41Grant specific sponsored class detailsMaster Data
120ERP EHP76.0GMGSPPROGRAM31Grant specific sponsored program detailsMaster Data
121ERP EHP76.0GMGTSPONSOR111Sponsor Master: Grant Type dependant attributesMaster Data
122ERP EHP76.0GMIDCRULES61Indirect cost rulesMaster Data
123ERP EHP76.0GMIDCRULES_ELE31Billing Rule ElementsMaster Data
124ERP EHP76.0GMIDCRULETEXTS41Indirect cost rulesMaster Data
125ERP EHP76.0GMINDIRECTCOST71IDC rates for directly sponsored grants [incoming grants]Master Data
126ERP EHP76.0GMINDIRECTCOST_O81Indirect costs for outgoing grantsMaster Data
127ERP EHP76.0GMINDIRECTCOST_R71Indirect costs for recipientMaster Data
128ERP EHP76.0GMLDC21Legislative District CodesMaster Data
129ERP EHP76.0GMLDCT41Legislative District DescriptionsMaster Data
130ERP EHP76.0GMLOC21Letter of Credit DefinitionMaster Data
131ERP EHP76.0GMLOCTEXT41Letter of Credit DefinitionMaster Data
132ERP EHP76.0GMOMD111Grants Management Object Mapper TableMaster Data
133ERP EHP76.0GMPAYMENTRULE21Payment RuleMaster Data
134ERP EHP76.0GMPRTEXTS41Payment Rule TextMaster Data
135ERP EHP76.0GMRELATIONSHIP111GM Relationship definition between grants and other objectsMaster Data
136ERP EHP76.0GMRELATIONSHIPT61GM Relationship textMaster Data
137ERP EHP76.0GMREPCLASS21GM Report ClassMaster Data
138ERP EHP76.0GMREPCLASST41GM Reprot Class TextMaster Data
139ERP EHP76.0GMREPORT111GM Report TrackingMaster Data
140ERP EHP76.0GMREPORTRULE31GM Report RuleMaster Data
141ERP EHP76.0GMREPORTRULET41Description of GM Report RuleMaster Data
142ERP EHP76.0GMRESPEVENTS41Grant responsibility eventsMaster Data
143ERP EHP76.0GMRESPTYPE21Responsibility types - Sponsored programs managementMaster Data
144ERP EHP76.0GMRESPTYPET41Responsible type textMaster Data
145ERP EHP76.0GMRMBDGT_ACT31Budget Document Types- Records Management InterfaceMaster Data
146ERP EHP76.0GMRMBUPA91Business Partner - Records Management InterfaceMaster Data
147ERP EHP76.0GMRMBUPA_ACT51Business Partner - Records Management InterfaceMaster Data
148ERP EHP76.0GMRMELEMENTS31Parameters for Records Management InterfaceMaster Data
149ERP EHP76.0GMRMELEMENTSTEXT51Parameters for Records Management InterfaceMaster Data
150ERP EHP76.0GMRMGRTYPE71Grant Types - Records Managment InterfaceMaster Data
151ERP EHP76.0GMRMGRTYPE_ACT31Grant Types - Records Management InterfaceMaster Data
152ERP EHP76.0GMSCHEDULERULE71GM Schedule RuleMaster Data
153ERP EHP76.0GMSCHEDULERULET41Description for the GM schedule ruleMaster Data
154ERP EHP76.0GMSMVALUETYPE71Value type control by grant type and statusMaster Data
155ERP EHP76.0GMSMVALUETYPE_161Value type control by grant type and statusMaster Data
156ERP EHP76.0GMSPAGT51Allowed Grant Types for SponsorMaster Data
157ERP EHP76.0GMSPCLASS141Sponsored Class MasterMaster Data
158ERP EHP76.0GMSPCLASSTEXTS51Sponsored Class Description textsMaster Data
159ERP EHP76.0GMSPCLASS_FMBA41Sponsored Class Master Data - Budget Allowed ObjectMaster Data
160ERP EHP76.0GMSPCLASS_FMBT51Sponsored Class Master Data - Budget Transfer ObjectMaster Data
161ERP EHP76.0GMSPONSOR171Sponsor MasterMaster Data
162ERP EHP76.0GMSPONSORLOC31Sponsor Master: Letter of Credit ReferencesMaster Data
163ERP EHP76.0GMSPPROGRAM161Sponsored program masterMaster Data
164ERP EHP76.0GMSPPROGRAMTEXTS51Sponsored Program textsMaster Data
165ERP EHP76.0GMSPPROGRAM_FMBA61Sponsored Program Master Data - Budget Allowed ObjectMaster Data
166ERP EHP76.0GMSPPROGRAM_FMBT71Sponsored Program Master Data - Budget Transfer ObjectsMaster Data
167ERP EHP76.0GMSPRESPONSIBLE81Objects responsible for the sponsored programMaster Data
168ERP EHP76.0GMSPRESPTYP81Responsibility Defaults for SponsorMaster Data
169ERP EHP76.0GMSTATNET171Grants Management Status NetworkMaster Data
170ERP EHP76.0GMSTATNETHISTORY91Historical status information Sponsored Programs MgmtMaster Data
171ERP EHP76.0GMSTATNET_INT131Grants Management Status NetworkMaster Data
172ERP EHP76.0GMWFACTIVITIES31GM Workflow ActivitiesMaster Data
173ERP EHP76.0GMWFACTIVITIEST41GM Workflow Activities TextMaster Data
174ERP EHP76.0GMWFAVC41GM Workflow AVCMaster Data
175ERP EHP76.0GMWFBUDGET81GM Workflow Grant MasterMaster Data
176ERP EHP76.0GMWFGRANTM71GM Workflow Grant MasterMaster Data
Public Sector Management :: Grants Management :: Grantor Management :: Actual Update and Commitment Update
ProductVersionTableColumnsIndexesDescriptionModule
177ERP EHP76.0GTRCOND_CUST31Table for Customer Spec. Fields - Grantor Rule ConditionsActual Update and Commitment Update
178ERP EHP76.0GTRCOND_CUSTT41Rule Condition Text table for the Field texts.Actual Update and Commitment Update
179ERP EHP76.0GTRFINEXC_DEF21Default Financial Execution InterfaceActual Update and Commitment Update
180ERP EHP76.0GTRGLOB_SETTINGS51Global settings for Grantor (client level)Actual Update and Commitment Update
181ERP EHP76.0GTRMULTIBP21GTR Multi Business Partner recipents activationActual Update and Commitment Update
182ERP EHP76.0GTRPROG_PROFILCT51Rule Condition Text table for the assignment field texts.Actual Update and Commitment Update
183ERP EHP76.0GTRPROG_PROFILE121GTR Program ProfileActual Update and Commitment Update
184ERP EHP76.0GTRPROG_PROFILEC31GTR Program Profile Assignment to Rule ConditionsActual Update and Commitment Update
185ERP EHP76.0GTRPROG_PROFILET41Text table for customizing table GTRPROG_PROFILEActual Update and Commitment Update
186ERP EHP76.0GTRRULE_AGR31Assignment Split Rule -> Agreement (if no EFs are used)Actual Update and Commitment Update
187ERP EHP76.0GTRRULE_ASSIGN141GTR Multi-Funding Rules Assignment To CRM ObjectsActual Update and Commitment Update
188ERP EHP76.0GTRRULE_COND41Assignment Split IDs (Lines)--> Condition BlockActual Update and Commitment Update
189ERP EHP76.0GTRRULE_COND_V61Assignment Condition Block --> Condition ValuesActual Update and Commitment Update
190ERP EHP76.0GTRWRPEF_CUST31Grantor FR wrapper: create year dependant documentsActual Update and Commitment Update
191ERP EHP76.0GTR_NOTIFY_TRIG141Trigger table for Grantor ERP->CRM NotificationActual Update and Commitment Update
192ERP EHP76.0GTR_TRANSLATOR132Grantor: Translator of CRM and ERP Integration AttributesActual Update and Commitment Update
193ERP EHP76.0GTR_TRSLR_SUBKEY51Grantor Translator - SubkeyActual Update and Commitment Update
194ERP EHP76.0TFMSPLIT_FIELDS21Allowed fields per rule typeActual Update and Commitment Update
195ERP EHP76.0TGTRFINEXEC_VAL11Financial Execution Values - Domain GTR_FIN_EXEC_IFActual Update and Commitment Update
196ERP EHP76.0TGTRFINEXEC_VALT31Financial Execution Values - Domain GTR_FIN_EXEC_IFActual Update and Commitment Update

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