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

84 columns | Print definition?ERP 6.0  | FREQUENCY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMFND/DSF30Data Staging Framework - Scheduling7FREQUENCYData Staging Frequency (Hours)int100
2EHFNDD_TS_ROOTTime Series - Root11FREQUENCYFrequencynvarchar30
3GHO_ALC_SRC_FORMFormula Source data for Allocation results invalidation6FREQUENCYAllocation Frequencynvarchar20
4GHO_ALC_SRC_NDRLSource Table for Node Rule5FREQUENCYAllocation Frequencynvarchar20
5GHO_ALC_SRC_NRULSource Table for Network Rule5FREQUENCYAllocation Frequencynvarchar20
6GHO_ALC_SRC_TRTheoretical Source data for Allocation results invalidation5FREQUENCYAllocation Frequencynvarchar20
7GHO_ALERTStore Network Alerts5FREQUENCYAllocation Frequencynvarchar20
8GHO_ALLOC_PREPAllocation Results Header6FREQUENCYAllocation Frequencynvarchar20
9GHO_ALLOC_RUN_JBAllocation Results Header6FREQUENCYAllocation Frequencynvarchar20
10GHO_AUDT_STA_PROAudit Status Profile3FREQUENCYAllocation Frequencynvarchar20
11GHO_FORM_MEAS_HAllocation Formula Measurements Header7FREQUENCYAllocation Frequencynvarchar20
12GHO_MEAS_PRIO_HAllocation Rules Measurement Priority Header6FREQUENCYAllocation Frequencynvarchar20
13GHO_PPA_DATAPPA request details23FREQUENCYAllocation Frequencynvarchar20
14GRACALHDRAlerts Header Info15FREQUENCY2 byte integer (signed)smallint50
15GRFNBRACTLBusiness Rule Assignment - Data for local control9FREQUENCYTimeframe Frequencynvarchar100
16GRFNCNREPORTAC Report Assignment on Control5FREQUENCYAC Frequencysmallint50
17GRPC_UPG_HRP5315Data Backup for HRP531520FREQUENCYFrequencynvarchar100
18TIVXCESPOSTINGPosting Deposits4FREQUENCYNumber of Frequency Units of Periodnvarchar30
19VIBDOBJASSIFRSValuation Data for Contract Objects10FREQUENCYFrequencynvarchar30
20VIYCRHYTHMCAM Expense Recovery Frequency Rule8FREQUENCYNumber of Frequency Units of Periodnvarchar30
21PIQDBOFFERTMPLRSTemplates for Business Event Offerings (Resources)13FREQUENCYRecurrence Intervaldecimal20
TOPABAP Search Engine for ERP Solution Database
22SRTMOCCURText Retrieval: Occurence of lex.entry in doc. (client spec)6FREQUENCYText Retrieval: Frequency of Lexicon Entry in Documentint100
23SRTVOCCURText Retrieval: Occurence of lexicon entry in documents5FREQUENCYText Retrieval: Frequency of Lexicon Entry in Documentint100
TOPApplication-Specific Upgrade
24/ASU/UACC_STEPUpgrade Accelerator Steps13FREQUENCYUpgrade Accelerator Step Execution Frequencynvarchar10
25UACC_STEPTable holding steps with their properties12FREQUENCYFrequency of Checksnvarchar10
TOPBasic Data
26NCMONIS-HCM: Function Modules for Monitoring Program6FREQUENCYFrequency of Executionnvarchar10
TOPBatch-Oriented Parallel Processing of Mass Data
27PPF_TST_EMPLOYEEMaster Data for PPF Test Application9FREQUENCYSettlement Period in Daystinyint30
TOPBudget Management
28T7PMITime base2FREQUENCYTime basenvarchar10
29T7PMJTexts for Time Reference3FREQUENCYTime basenvarchar10
TOPBusiness Objects, Common Components
30EHFNDD_AMN_ROOTData Series for Amounts - Root19FREQUENCYExposure Frequency for Personint100
TOPDevice installation
31TE406Operation Code per Reg. Relationship4FREQUENCYMaximum number of operation codes in a register relationshiptinyint30
TOPFunctions for U.S. Federal Government
32FMRES_INST_PARAMMaintain Installment parameters4FREQUENCYFrequency at which installments must be paidnvarchar20
TOPGovernance, Risk and Compliance
33GRFNFREQUENCYTimeframe Frequencies2FREQUENCYTimeframe Frequencynvarchar100
34GRFNFREQUENCYATimeframe Frequencies2FREQUENCYTimeframe Frequencynvarchar100
35GRFNFREQUENCYSTimeframe Frequencies - SAP delivered entries1FREQUENCYTimeframe Frequencynvarchar100
36GRFNFREQUENCYSTTimeframe Frequencies - SAP delivered entries2FREQUENCYTimeframe Frequencynvarchar100
37GRFNFREQUENCYTTimeframe Frequencies3FREQUENCYTimeframe Frequencynvarchar100
38GRFNTASKPLANGRPData for task plan group17FREQUENCYFrequency of schedulenvarchar20
39GRFNTIMEFRAMETimeframes3FREQUENCYTimeframe Frequencynvarchar100
40GRFN_BI_TF_CUSTGRC BI Extraction Customizing2FREQUENCYTimeframe Frequencynvarchar100
TOPGRC Access Control Plug-In
41/VIRSA/MITREPORTMitigating Reports5FREQUENCYFrequencynvarchar30
TOPGRC Risk Management
42GRRMSIMRISKMASTRMonte Carlo Simulation Risk Master table4FREQUENCYNumberint100
TOPIncident Recording
43EHHSSD_INC_RIASSIncident - Risk Assessment12FREQUENCYIncident Frequencynvarchar210
TOPInformation System
44TIVISPFCONDRELReport Profile for Conditions: Properties8FREQUENCYNumber of Frequency Units of Periodnvarchar30
TOPInvoicing
45TE632APS Unmeasured Customer: Frequency-Specific Settings for Year3FREQUENCYPS Unmeasured Customers: Payment Scheme Frequencynvarchar10
TOPManagement of Internal Controls
46FOPCTASKFREQFrequency of the Tasks4FREQUENCYFrequencynvarchar100
47HRP1804DB Table for InfoType 180424FREQUENCYFrequencynvarchar100
TOPMaterials Management
48J_1GVL_WHB000Material valuation: global settings5FREQUENCYValuation frequencynvarchar10
49J_1GVL_WHB013Analytical ledger material postings after valuation11FREQUENCYPosting Frequencynvarchar10
TOPMeasurement System
50GHO_IMRG_STD_HHeader for Standardized QCI Volumes8FREQUENCYAllocation Frequencynvarchar20
TOPMigration
51TIVMISETSRRHSettlement Variant for Frequency4FREQUENCYNumber of Frequency Units of Periodnvarchar30
TOPOracle Database Monitors
52ORAISQCTRLRSORAISQ Index Storage Quality Maintenance Control Table3FREQUENCYnvarchar10
TOPProcess Controls
53GRPCREPFRQsettings for frequency of repeat work4FREQUENCYAttribute Valuenvarchar100
54GRPCSCHEDULERScheduler4FREQUENCYFrequency Typenvarchar100
55GRPCTASKFREQObsolete: Frequency of the Tasks4FREQUENCYFrequencynvarchar100
56GRPC_SCOPIN_FREQScoping Freqency Configuration2FREQUENCYTimeframe Frequencynvarchar100
57HRP5304DB Table for Infotype 530424FREQUENCYFrequencynvarchar100
58HRP5306DB Table for Infotype 530620FREQUENCYFrequencynvarchar100
59HRP5315DB Table for Infotype 531520FREQUENCYFrequencynvarchar100
TOPProduction Allocation
60GHO_ALLOCRES_HAllocation Results Header6FREQUENCYAllocation Frequencynvarchar20
61GHO_ALLOC_OVROBSOLETE - GHO Allocation Theoratical Override7FREQUENCYAllocation Frequencynvarchar20
62GHO_ALLOC_RES_HOBSOLETE - Table for storing allocation results (Header)6FREQUENCYAllocation Frequencynvarchar20
63GHO_NODERULE_HNode Allocation Rules Header6FREQUENCYAllocation Frequencynvarchar20
64GHO_NODE_DS_SP_HNode Down Stream Split header table6FREQUENCYAllocation Frequencynvarchar20
65GHO_NODE_RULE_HOBSOLETE - Node Allocation Rules Header5FREQUENCYAllocation Frequencynvarchar20
66GHO_NWRULE_HNetwork Allocation Rules Header5FREQUENCYAllocation Frequencynvarchar20
67GHO_NW_RULE_HOBSOLETE - Production Flow Network Allocation Rules Header4FREQUENCYAllocation Frequencynvarchar20
68GHO_RULE_LOG_HAllocation Rule Log Header8FREQUENCYAllocation Frequencynvarchar20
69GHO_SIMU_DS_SP_HSimulation: Node Down Stream Split rules header7FREQUENCYAllocation Frequencynvarchar20
70GHO_SIMU_NDRHSimulation: Node Allocation Rules Header7FREQUENCYAllocation Frequencynvarchar20
71GHO_SIMU_NWRHSimulation: Network Allocation Rules Header6FREQUENCYAllocation Frequencynvarchar20
72GHO_SIMU_TOR_HSimulation: Theoretical Override Header8FREQUENCYAllocation Frequencynvarchar20
73GHO_THEO_OVR_HAllocation Theoretical Override Header7FREQUENCYAllocation Frequencynvarchar20
TOPRental Accounting
74VITMRHTerms: Frequency Rule7FREQUENCYNumber of Frequency Units of Periodnvarchar30
TOPRoom Reservations and Seating Arrangements
75TIVORRSOBJTYPEReservation Object Type14FREQUENCYNumber of Frequency Units of Periodnvarchar30
TOPRoyalty Reporting
76OIUREP_LGL_RPTSLegal Reports for Tax and Royalty Reporting11FREQUENCYReporting Frequencynvarchar10
77OIUREP_REPORTSSupported Regulatory reports16FREQUENCYReporting Frequencynvarchar10
78OIUREP_ROY_AGYReporting Agencies for Tax and Royalty20FREQUENCYReporting Frequencynvarchar10
TOPSales-Based Rent and Settlement
79VISRTMRPRHAssignment of Frequency Rule to Reporting Rule7FREQUENCYNumber of Frequency Units of Periodnvarchar30
80VISRTMSBRHAssignment of Frequency Rule to Sales Rule8FREQUENCYNumber of Frequency Units of Periodnvarchar30
TOPService Charge Settlement
81VISCSURHAllocation of Settlement Variants to Settlement Unit6FREQUENCYNumber of Frequency Units of Periodnvarchar30
TOPTransaction Management
82TIDX_PRICE_INDEXPrice Index Main Entity8FREQUENCYIncrement of Interpolationnvarchar10
TOPTransaction Manager
83TCORT_CODCODeal: Conditions54FREQUENCYCyclenvarchar30
84TCORT_CODULCODeal : Underlying's Conditions55FREQUENCYCyclenvarchar30