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

52 columns | Print definition?ERP 6.0  | REPORT_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/XPPM/CAR_C_AUCustomize Authorizations for Reports2REPORT_IDReporting IDnvarchar150
2/XPPM/CAR_C_AUROCustomize role based authorizations for Reports2REPORT_IDReporting IDnvarchar150
3/XPPM/CAR_C_GRCustomize Merge Groups2REPORT_IDReporting IDnvarchar150
4/XPPM/CAR_C_KPReporting Tool: KPI Customizing2REPORT_IDReporting IDnvarchar150
5/XPPM/CAR_C_KPSOKPI Selection definition2REPORT_IDReporting IDnvarchar150
6/XPPM/CAR_C_OPOutput and selection definiton2REPORT_IDReporting IDnvarchar150
7/XPPM/CAR_C_REReporting Tool: Report Definition CLIENT MANDT2REPORT_IDReporting IDnvarchar150
8/XPPM/CAR_C_REOBreport specific object type selection2REPORT_IDReporting IDnvarchar150
9/XPPM/CAR_C_RE_TText Table for Reporting Definition3REPORT_IDReporting IDnvarchar150
10/XPPM/CAR_C_SOAdvanced selection definition2REPORT_IDReporting IDnvarchar150
11/XPPM/CAR_VARIANSave variants3REPORT_IDReporting IDnvarchar150
12GRFNREPSNAPSHOTReporting snapshot header2REPORT_IDObject IDnvarchar500
TOPBusiness Package for Manager Self-Service FI
13FPB_LP6_F_R_CFolder <---> Reports Assignment4REPORT_IDApplication Namenvarchar120
14FPB_LP6_F_R_UCFolder <---> Reports Assignment4REPORT_IDApplication Namenvarchar120
15FPB_LP6_REP_LTLong Texts For Reports3REPORT_IDApplication Namenvarchar120
16FPB_LP6_REP_TTexts for Reports3REPORT_IDApplication Namenvarchar120
17FPB_LP6_REP_U_TTexts for Reports for Users3REPORT_IDApplication Namenvarchar120
18FPB_LP6_R_BWT_CParameters for BI Reports with Template3REPORT_IDApplication Namenvarchar120
19FPB_LP6_R_BW_CParameters for BI Reports3REPORT_IDApplication Namenvarchar120
20FPB_LP6_R_MDT_CParameters for Manager's Desktop Reports3REPORT_IDApplication Namenvarchar120
21FPB_LP6_R_RW_CParameters for Report Writer3REPORT_IDApplication Namenvarchar120
22FPB_LP6_R_RW_UCParameters for Report Writer for Users3REPORT_IDApplication Namenvarchar120
23FPB_LP6_R_TRA_CParameters for Transactions3REPORT_IDApplication Namenvarchar120
24FPB_LP6_R_TRA_UCParameters for Transactions for Users3REPORT_IDApplication Namenvarchar120
25FPB_LP6_R_TYP_CType of Report3REPORT_IDApplication Namenvarchar120
26FPB_LP6_R_URL_CParameters for URL Reports3REPORT_IDApplication Namenvarchar120
TOPEnd User Technology
27RSERDATAReport Designer: Database Table1REPORT_IDReport Designer: Report ID for Loading and Savingnvarchar300
28RSERERPTTEXTSLanguage-Specific Texts for Enterprise Reports1REPORT_IDReport Designer: Report ID for Loading and Savingnvarchar300
29RSERERPTXREFDependent TLogo Objects1REPORT_IDReport Designer: Report ID for Loading and Savingnvarchar300
30RSERHEADERReport Designer: Header Table BEx Report1REPORT_IDReport Designer: Report ID for Loading and Savingnvarchar300
31RSERTEXTReport Designer: Text Table1REPORT_IDReport Designer: Report ID for Loading and Savingnvarchar300
TOPFunctions for U.S. Federal Government
32FMFG_TROR_CONFIGConfiguration for TROR lines3REPORT_IDTROR: Report Configuration Namenvarchar100
33FMFG_TROR_LINESReport Layout for TROR3REPORT_IDTROR: Report Configuration Namenvarchar100
34FMFG_TROR_RPTTROR Report Configuration Name2REPORT_IDTROR: Report Configuration Namenvarchar100
35FMFG_TROR_RPTTTROR Report Configuration Description2REPORT_IDTROR: Report Configuration Namenvarchar100
36FMFG_TROR_TOTALSConfiguration for TROR Total Lines2REPORT_IDTROR: Report Configuration Namenvarchar100
TOPFunds Management
37FMFGRCN_SAV_ITEMSaved reconciliation match item data2REPORT_IDIdentifies a run of the reconciliation reportnvarchar40
38PSBM_REPORTBudget Monitoring Reports3REPORT_IDReport IDnvarchar100
39PSBM_REPORT_TBudget Monitoring Reports4REPORT_IDReport IDnvarchar100
40PSBM_USER_REPORTFM Budget Monitoring User Reports6REPORT_IDReport IDnvarchar100
TOPGovernance, Risk and Compliance
41GRFNBATCHRESULTReport results from batch processing2REPORT_IDObject IDnvarchar500
42GRFNREPLOGSETReport: Log settings for further check3REPORT_IDReport IDnvarchar200
TOPHR Administrative Services
43T5ASRSELFLDDFEntity Table 'Additional Criteria' (LPA)2REPORT_IDReport IDnvarchar40
44T5ASRSELFLDIDDefine Reports for Default Field Values6REPORT_IDReport IDnvarchar40
45T5ASRSELFLDID_TDefine Reports for Default Field Values7REPORT_IDReport IDnvarchar40
46T5ASRSELFLDSFSpecify Report Selection Fields for Reports: Stat.Field Sel.2REPORT_IDReport IDnvarchar40
47T5ASRSELFLDVARCreate Variants for Reports2REPORT_IDReport IDnvarchar40
TOPMaintenance Processing
48ALM_ME_SIG_LINKMAM Signature to Order Link3REPORT_IDNot More Closely Defined Area, Possibly Used for Patchlevelsnvarchar40
TOPProduction and Revenue Accounting
49OIU_RV_VLRPTValuation Reporting2REPORT_IDReport IDnvarchar120
50OIU_RV_VLRPTHValuation Report Detail Header2REPORT_IDReport IDnvarchar120
TOPUser Interface
51WCF_UST_REPORTShared Favorite reports4REPORT_IDBI Report IDnvarchar400
TOPValuation
52OIUVL_RPTValuation reporting header2REPORT_IDReport IDnvarchar120