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

128 tablesERP 6.0 

Public Sector Management :: Functions for U.S. Federal Government
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0CATT_DOCS71CATT recording documentsFunctions for U.S. Federal Government
2ERP EHP76.0FMABP_AREAS31Assignment of application areas for automated budget postingFunctions for U.S. Federal Government
3ERP EHP76.0FMCCRTUPDATES61CCR Vendor Update TableFunctions for U.S. Federal Government
4ERP EHP76.0FMCCRTVENDOR1201CCR Vendor TableFunctions for U.S. Federal Government
5ERP EHP76.0FMCCRTVENDORPOC211CCR Vendor Points of ContactFunctions for U.S. Federal Government
6ERP EHP76.0FMCCRVENDOR_CORP61PSM-FG: CCR Vendor Corporate InformationFunctions for U.S. Federal Government
7ERP EHP76.0FMCCRVENDOR_DISR51PSM-FG: Disaster Response Contractor Areas ServedFunctions for U.S. Federal Government
8ERP EHP76.0FMCCRVENDOR_EXEC61PSM-FG: CCR Executive CompensationFunctions for U.S. Federal Government
9ERP EHP76.0FMCCRVENDOR_EXTC51PSM-FG: CCR Vendor External CertificationsFunctions for U.S. Federal Government
10ERP EHP76.0FMCCRVENDOR_FLGS51PSM-FG: CCR Vendor FlagsFunctions for U.S. Federal Government
11ERP EHP76.0FMCCRVENDOR_GS81PSM-FG: Goods and ServicesFunctions for U.S. Federal Government
12ERP EHP76.0FMCCRVENDOR_HDR471PSM-FG: CCR Vendor TableFunctions for U.S. Federal Government
13ERP EHP76.0FMCCRVENDOR_NUMS61PSM-FG: CCR NumericsFunctions for U.S. Federal Government
14ERP EHP76.0FMCCRVENDOR_PROC101PSM-FG: Administrative, civil or criminal proceedingsFunctions for U.S. Federal Government
15ERP EHP76.0FMCCR_CON21CCR Vendor ConfigurationFunctions for U.S. Federal Government
16ERP EHP76.0FMFEE_CUSTOMER31Tell the system which document types are invoicesFunctions for U.S. Federal Government
17ERP EHP76.0FMFEE_HISTORY172Fee run history for interest calculationFunctions for U.S. Federal Government
18ERP EHP76.0FMFEE_LINK_FI81Link of fee schedule to FI documentFunctions for U.S. Federal Government
19ERP EHP76.0FMFEE_SCHEDULE31Fee schedule (Definition)Functions for U.S. Federal Government
20ERP EHP76.0FMFEE_SCHED_TYPE51Assignment of fee types to fee schedulesFunctions for U.S. Federal Government
21ERP EHP76.0FMFEE_TYPES221Fee typesFunctions for U.S. Federal Government
22ERP EHP76.0FMFGBLAREA61Budgetary Ledger areas for US Federal extensionFunctions for U.S. Federal Government
23ERP EHP76.0FMFGBLAREADOCTY31Document Type for BL postings in BL areaFunctions for U.S. Federal Government
24ERP EHP76.0FMFGBLAREAFLD41Budgetary Ledger areas for US Federal extensionFunctions for U.S. Federal Government
25ERP EHP76.0FMFGBLAREAT41Budgetary Ledger areas for US Federal extensionFunctions for U.S. Federal Government
26ERP EHP76.0FMFGBLDRVAREAEAA81Derivation rule:Set Expended Appropriations - Actuals (EAA)Functions for U.S. Federal Government
27ERP EHP76.0FMFGBLDRVAREAMR101Derivation rule:Set Miscellaneous Receipts - Actuals (MIR)Functions for U.S. Federal Government
28ERP EHP76.0FMFGKEY62Key for Facts-Attributes for Ledger 95/FMUSFGTFunctions for U.S. Federal Government
29ERP EHP76.0FMFGKEY96122Key for FACTS - Attributes for Ledger 96/FMUSFGFACTS1TFunctions for U.S. Federal Government
30ERP EHP76.0FMFGKEY97112Key for FACTS - Attributes for Ledger 97/FMUSFGFACTS2TFunctions for U.S. Federal Government
31ERP EHP76.0FMFGRLAYOUT41Reporting Layout for Federal GovernmentFunctions for U.S. Federal Government
32ERP EHP76.0FMFGRLAYOUT_DEF201Definition for reporting layoutFunctions for U.S. Federal Government
33ERP EHP76.0FMFGRLAYOUT_TEXT51Text table for reporting layoutFunctions for U.S. Federal Government
34ERP EHP76.0FMFGT_ALC_GWA51Assign. of Business Act. Type and Reporter Category to ALCFunctions for U.S. Federal Government
35ERP EHP76.0FMFGYECLAA81US Federal Gov't : Y/E Pre-Closing of Anticipated AccountsFunctions for U.S. Federal Government
36ERP EHP76.0FMFG_ABP81Parameters for Automatic Budget Postings FunctionalityFunctions for U.S. Federal Government
37ERP EHP76.0FMFG_ABP_HDR_DEF211ABP Budget Entry Document default attributesFunctions for U.S. Federal Government
38ERP EHP76.0FMFG_BL_YRCL101Customizing Budgetary Ledger Year End closingFunctions for U.S. Federal Government
39ERP EHP76.0FMFG_BL_YRCL_TOP41Customizing Budgetary Ledger Year End Multiple Closing RulesFunctions for U.S. Federal Government
40ERP EHP76.0FMFG_BL_YRCL_TXT61Multiple Closing Rule TextsFunctions for U.S. Federal Government
41ERP EHP76.0FMFG_BUTYPE71Budgetary ledger Attributes of the budget typeFunctions for U.S. Federal Government
42ERP EHP76.0FMFG_CCRFDDISP21CCR Fields to be "Display only" in Vendor Master ChangeFunctions for U.S. Federal Government
43ERP EHP76.0FMFG_DOCT_ADJ51Invoice Document types for adjustment deliveredFunctions for U.S. Federal Government
44ERP EHP76.0FMFG_FUND_ADJ31Customizing for adjustment on fund levelFunctions for U.S. Federal Government
45ERP EHP76.0FMFG_LFACCR82Vendor Master Central Contractor Registry (CCR)Functions for U.S. Federal Government
46ERP EHP76.0FMFG_MM_PEND_CHG112Purchasing document changes requiring Notification approvlFunctions for U.S. Federal Government
47ERP EHP76.0FMFG_PRIOR_RPT151Table for Prior Reported InformationFunctions for U.S. Federal Government
48ERP EHP76.0FMFG_PRIOR_RPTKF81Prior Reported KeyfiguresFunctions for U.S. Federal Government
49ERP EHP76.0FMFG_T09561Contra accounts asset accountingFunctions for U.S. Federal Government
50ERP EHP76.0FMFG_TRADE_ID31Non-federal trading partner exceptions for US governmentFunctions for U.S. Federal Government
51ERP EHP76.0FMFG_TROR_ACCTS71TROR G/L Account Group detailFunctions for U.S. Federal Government
52ERP EHP76.0FMFG_TROR_ACGRP31TROR G/L Account GroupFunctions for U.S. Federal Government
53ERP EHP76.0FMFG_TROR_ACGRPT41TROR G/L Account Group textFunctions for U.S. Federal Government
54ERP EHP76.0FMFG_TROR_CONFIG111Configuration for TROR linesFunctions for U.S. Federal Government
55ERP EHP76.0FMFG_TROR_DCTYPT41TROR Doctype group descriptionFunctions for U.S. Federal Government
56ERP EHP76.0FMFG_TROR_DOCTYP21TROR Doctype groupFunctions for U.S. Federal Government
57ERP EHP76.0FMFG_TROR_DTYP61TROR Document Type group detailsFunctions for U.S. Federal Government
58ERP EHP76.0FMFG_TROR_LINES71Report Layout for TRORFunctions for U.S. Federal Government
59ERP EHP76.0FMFG_TROR_RC71TROR Reason code group detailFunctions for U.S. Federal Government
60ERP EHP76.0FMFG_TROR_RCGRP41TROR Reason Code GroupFunctions for U.S. Federal Government
61ERP EHP76.0FMFG_TROR_RCGRPT41TROR Reason Code Group DescriptionFunctions for U.S. Federal Government
62ERP EHP76.0FMFG_TROR_RPT41TROR Report Configuration NameFunctions for U.S. Federal Government
63ERP EHP76.0FMFG_TROR_RPTT41TROR Report Configuration DescriptionFunctions for U.S. Federal Government
64ERP EHP76.0FMFG_TROR_TOTALS61Configuration for TROR Total LinesFunctions for U.S. Federal Government
65ERP EHP76.0FMFG_UO_BIL_FIDT21SO Adjustmnt Prog: FI Doc Types to exclude from BillingsFunctions for U.S. Federal Government
66ERP EHP76.0FMFG_UO_OBL_FIDT21SO Adjustmnt Prog: FI Doc Types to exclude from ObligationsFunctions for U.S. Federal Government
67ERP EHP76.0FMFG_UO_OBL_FMVT21SO Adjustmnt Prog: Value Types to include in ObligationsFunctions for U.S. Federal Government
68ERP EHP76.0FMFG_UO_OBL_MMDT31SO Adjustmnt Prog: Pur Doc Types to exclude from ObligationsFunctions for U.S. Federal Government
69ERP EHP76.0FMFG_USER_ADJ21Useer which correct reversalsFunctions for U.S. Federal Government
70ERP EHP76.0FMFG_VEKPO201JFMIP: Pending PO Line Item Changes TableFunctions for U.S. Federal Government
71ERP EHP76.0FMFG_YE_FLG131Collect fieldsFunctions for U.S. Federal Government
72ERP EHP76.0FMFONDS51Cancelled Fund, Current Fund JFMIPFunctions for U.S. Federal Government
73ERP EHP76.0FMFONDST51Cancelled Fund, Current FundFunctions for U.S. Federal Government
74ERP EHP76.0FMRES_INSTMTS91Complete log on ReschedulingFunctions for U.S. Federal Government
75ERP EHP76.0FMRES_INST_HIST111Log of all installments createdFunctions for U.S. Federal Government
76ERP EHP76.0FMRES_INST_PARAM71Maintain Installment parametersFunctions for U.S. Federal Government
77ERP EHP76.0FMRES_RECV_LIST141List of all rescheduled receivablesFunctions for U.S. Federal Government
78ERP EHP76.0FMROHDR131FM Recurring Obligations - schedule headerFunctions for U.S. Federal Government
79ERP EHP76.0FMROLINE111FM Recurring Obligations - schedule linesFunctions for U.S. Federal Government
80ERP EHP76.0FMROPOS51Recurring Obligation item amountsFunctions for U.S. Federal Government
81ERP EHP76.0FMSGLCLASS51Classification for SGL accountsFunctions for U.S. Federal Government
82ERP EHP76.0FMUSFG_GWA_ACTIO41Reporter Category ActionsFunctions for U.S. Federal Government
83ERP EHP76.0FMUSFG_GWA_ELIGI41Target System EligibilityFunctions for U.S. Federal Government
84ERP EHP76.0FMUSFG_GWA_RCVAL41Reporter Category ValidityFunctions for U.S. Federal Government
85ERP EHP76.0FMUSFG_TS31Treasury SubclassesFunctions for U.S. Federal Government
86ERP EHP76.0FMUSFG_TSA51Assign. of FI Doc Type/ Accnt/Fund to Treasury Subclass CodeFunctions for U.S. Federal Government
87ERP EHP76.0TFMFG_MM_AACT51Document Type for Account Assignment CategoryFunctions for U.S. Federal Government
Public Sector Management :: Functions for U.S. Federal Government :: Central Cash Desk Procedure
ProductVersionTableColumnsIndexesDescriptionModule
88ERP EHP76.0FM1081_FUND_ROW41Detail Application Fund Line of SF1081 Smart Form interfaceCentral Cash Desk Procedure
89ERP EHP76.0FMFGT_FSN31US Federal Fiscal Station NumberCentral Cash Desk Procedure
90ERP EHP76.0FMFGT_FSNT41Text table for Fiscal Station Number - US. Fed. GovernmentCentral Cash Desk Procedure
91ERP EHP76.0FMFGT_IPACD_PMS51IPACed Auto Doc Creation - Payment Method Suppl for InvoiceCentral Cash Desk Procedure
92ERP EHP76.0FMFGT_IPACED201US Federal IPACed transaction informationCentral Cash Desk Procedure
93ERP EHP76.0FMFGT_IPACED_ID111US Federal IPACed transaction informationCentral Cash Desk Procedure
94ERP EHP76.0FMFGT_IPAC_ACCT71List of DIT & FBT Accounts for IPAC Interface ProcessCentral Cash Desk Procedure
95ERP EHP76.0FMFGT_IPAC_FILE101US Federal IPAC outgoing file IDCentral Cash Desk Procedure
96ERP EHP76.0FMFGT_IPAC_FLAG41US Federal IPAC function activation flag tableCentral Cash Desk Procedure
97ERP EHP76.0FMFGT_IPAC_STATS151US Federal IPAC interface process status tableCentral Cash Desk Procedure
98ERP EHP76.0FMFGT_IPCD_BLRT71Document Type for Auto Creation of IPACed InvoicesCentral Cash Desk Procedure
99ERP EHP76.0FMFG_PMTMT_MRG41Merged Confirmation Assignment Payment MethodsCentral Cash Desk Procedure
100ERP EHP76.0FMFG_PPA_INV_LN92Reason Codes for Accounting Documents (Item Level)Central Cash Desk Procedure
101ERP EHP76.0FMFG_PPA_LOG_ATT51Activate U.S. Federal PPA message logCentral Cash Desk Procedure
102ERP EHP76.0FMFG_TC_MRG_D51Treasury Confirmation Merged Configuration DefaultsCentral Cash Desk Procedure
103ERP EHP76.0FMFG_ZLSCH_0D41Payment method for zero dollar transactionsCentral Cash Desk Procedure
104ERP EHP76.0FMTC_REJ_RANGE71Schedule Check Ranges for US Federal Treasury ConfirmationCentral Cash Desk Procedure
Public Sector Management :: Functions for U.S. Federal Government :: US Prompt Payment Act
ProductVersionTableColumnsIndexesDescriptionModule
105ERP EHP76.0FMFGRC31Reason Codes for InvoicesUS Prompt Payment Act
106ERP EHP76.0FMFGRCT51Reason Code textsUS Prompt Payment Act
107ERP EHP76.0FMFGT_EXCL61Invoice exclusion table for Fast PayUS Prompt Payment Act
108ERP EHP76.0FMFGT_SS0471Payment Statistical Sampling Proc. Batch/certify DatesUS Prompt Payment Act
109ERP EHP76.0FMFG_INVSTAGES41Invoice Stages ActivationUS Prompt Payment Act
110ERP EHP76.0FMFG_PPA_ACC_ZTM41Prompt Payment Act Accelerated Pay Payment TermsUS Prompt Payment Act
111ERP EHP76.0FMFG_PPA_ADV_ZTM51Prompt Payment Act Most Advantageous Payment Term MethodUS Prompt Payment Act
112ERP EHP76.0FMFG_PPA_ATTR21Activate client-specific U.S. Federal PPA functionalityUS Prompt Payment Act
113ERP EHP76.0FMFG_PPA_INVSTAT122PPA Invoice Status TableUS Prompt Payment Act
114ERP EHP76.0FMFG_PPA_INV_HD71PPA invoice header information (reason codes)US Prompt Payment Act
115ERP EHP76.0FMFG_PPA_INV_HIS152PPA Invoice Status Change HistoryUS Prompt Payment Act
116ERP EHP76.0FMFG_PPA_LINK61Link the application log to an Invoice (PPA)US Prompt Payment Act
117ERP EHP76.0FMFG_REASONS91Reason Codes for Accounting Documents (Item Level)US Prompt Payment Act
118ERP EHP76.0T023B51Minimum &maximum amount of interest penaltiesUS Prompt Payment Act
119ERP EHP76.0T023C31New document types for Prompt Payment ActUS Prompt Payment Act
120ERP EHP76.0T023E71Invoice line item handling rulesUS Prompt Payment Act
121ERP EHP76.0T023G71Activate company code dependent U.S. Federal functionalityUS Prompt Payment Act
122ERP EHP76.0T023N51Maximum amountUS Prompt Payment Act
123ERP EHP76.0T023P51Mapping of material groups to terms of payment keysUS Prompt Payment Act
124ERP EHP76.0T023Q31Fast/Accelerated Pay Payment TermUS Prompt Payment Act
125ERP EHP76.0T023R41Penalty interest rates & validity periodsUS Prompt Payment Act
126ERP EHP76.0T023U21Reason codes for interest penaltiesUS Prompt Payment Act
127ERP EHP76.0T023UT41Reason code texts for T023U with language keyUS Prompt Payment Act
128ERP EHP76.0T043U41Negative grace periodUS Prompt Payment Act