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

73 columns | Print definition?ERP 6.0  | PERCENTAGE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1RA/0SD010COItems for Class SD01 - Raw Data19PERCENTAGEPercentagedecimal118
2/1RA/0SD012COItems for Class SD01 - Processable19PERCENTAGEPercentagedecimal118
3/1RA/0SD014COItems for Class SD01 - Processed19PERCENTAGEPercentagedecimal118
4/1RA/0SD020COItems for Class SD02 - Raw Data19PERCENTAGEPercentagedecimal118
5/1RA/0SD022COItems for Class SD02 - Processable19PERCENTAGEPercentagedecimal118
6/1RA/0SD024COItems for Class SD02 - Processed19PERCENTAGEPercentagedecimal118
7/1RA/0SD030COItems for Class SD03 - Raw Data19PERCENTAGEPercentagedecimal118
8/1RA/0SD032COItems for Class SD03 - Processable19PERCENTAGEPercentagedecimal118
9/1RA/0SD034COItems for Class SD03 - Processed19PERCENTAGEPercentagedecimal118
10/CPD/PWSC_CALCalculated KPI4PERCENTAGEPercentagenvarchar10
11/LOCSRM/T_PCT_BRPercentage customizing for LAW1232PERCENTAGEPercentage for Re-bid Optionnvarchar30
12BCKTRDT_MULTASSGMultiple Account Assignment of Flows13PERCENTAGEPercentage Rate for Multiple Account Assignmentdecimal74
13CNVC_JSTATJob status11PERCENTAGEProgress indicatornvarchar800
14CNVC_SCNR_TNRODefinition of number range objects14PERCENTAGEPercentage for warning messagedecimal31
15CNV_NCE_KB_LOCALNumber conversion engine: Local Knowledge Base19PERCENTAGEPercentage for warning messagedecimal31
16FARR_D_DEFERRALDeferrals5PERCENTAGEPercentagedecimal118
17FMADB_TC_WEIGHTSFMADB: Trace - Saved Weights (Last Run)5PERCENTAGEPercentagedecimal107
18GRRMPOLICYRESPTranslation of policy status into response completeness3PERCENTAGEPercentagedecimal30
19IUUC_TNRO_SNAPDefinition der Nummernkreisobjekte13PERCENTAGEPercentage for warning messagedecimal31
20J_1UF_TP_PARTYControlled contractors28PERCENTAGEPercentage of ownership of corporate rightsdecimal62
21TMAS_D_RT2007Trados 2007 analysis results9PERCENTAGECounterint100
22ZPPMC_DPR_COSTPLBewegungsdaten für die Sachkostenplanung in cProjects14PERCENTAGEPercentagedecimal61
23ZTH_LOAD_INFOActual generated Program4PERCENTAGEChar 10nvarchar100
TOPBank Customer Accounts
24BKKSO_VAR_AMNTStanding Order: Variable Amounts8PERCENTAGEPercentage Execution of a Standing Ordernvarchar30
25RTP_US_BENBeneficiary table for a retirement plan5PERCENTAGEPercentage of the value the beneficiary will receivedecimal41
TOPBatch-Oriented Parallel Processing of Mass Data
26TBANK_MR_CNT_RCMass Runs Relationship of Edited Objects for Return Code6PERCENTAGEMass Runs - Limit Individual Errornvarchar30
TOPBusiness Planning and Simulation
27UPX_SLC_SPREADLead Columns: Distribution Techniques7PERCENTAGEColumn with Percentage of Total Valuenvarchar10
TOPCollections Management
28UDM_WL_ITEMWorklist Item12PERCENTAGEPercentage Valuationnvarchar40
TOPCommodity Pricing Engine
29CPEC_TERMGRPCPE Term - Grouping of Terms13PERCENTAGECPE Term - Percentagedecimal106
30CPED_DEFTERMGRPCPE Term - Default for Grouping and General Data in Docume13PERCENTAGECPE Term - Percentagedecimal106
31CPED_TERMGRPOUTCPE Term - Changed Grouping and General Term Result13PERCENTAGECPE Term - Percentagedecimal106
TOPContract Accounts Receivable and Payable
32DFKKWLIWork Items34PERCENTAGEPrecentage Rate of Valuationnvarchar40
33DFKKWLIAWork Items (Work Item Type)34PERCENTAGEPrecentage Rate of Valuationnvarchar40
TOPData Basis
34RSDCUBEDirectory of InfoCubes / InfoProvider87PERCENTAGEnvarchar30
TOPFinancial Accounting
35FERC_D1Paths per account, sender and receiver13PERCENTAGEPercentage for regulatory reportingdecimal1512
36FERC_F1Detailed audit trace file8PERCENTAGEPercentage for regulatory reportingdecimal1512
37FERC_F2Compact audit trace file5PERCENTAGEPercentage for regulatory reportingdecimal1512
TOPFunds Management
38KBLPAYPPayment Plan Items6PERCENTAGEPercentage amount per period (payment plan)decimal52
TOPHandheld Connectivity
39/DSD/PR_RSAMMDSD Promotions - Promotion Result Amounts4PERCENTAGEDSD Deal Conditions - Percentage Result Flagnvarchar10
TOPIncentive and Commission Management ICM
40CACS_QRULECommission: Quick Rule Engine17PERCENTAGEPercentage Rate for Fast Rule Enginedecimal50
TOPJoint Venture und Production Sharing Accounting
41T8JLP2Penalty Category Recovery Percentages*6PERCENTAGENon-signatory Recovery Percentagedecimal116
TOPLease Accounting
42/LSIERP/LATE_FEELeasing Late Fee Matrix: Calc. Based on Responsibility Area11PERCENTAGEPercentage of Outstanding Receivabledecimal53
TOPLocalization
43J_1IUTILIZEUtilization Determination4PERCENTAGEBED percentagenvarchar50
TOPManagement of Global Employees
44T76MGE_CALCCPIs calculation9PERCENTAGEPercentagedecimal63
TOPMaster Data
45GMGRCOSTSHARECost sharing master data9PERCENTAGECost Sharing Percentagedecimal63
46GMINDIRECTCOSTIDC rates for directly sponsored grants [incoming grants]7PERCENTAGEIndirect Overhead Ratedecimal63
47GMINDIRECTCOST_OIndirect costs for outgoing grants8PERCENTAGEIndirect Overhead Ratedecimal63
48GMINDIRECTCOST_RIndirect costs for recipient7PERCENTAGEIndirect Overhead Ratedecimal63
TOPMedia Product Sales and Distribution
49TJKSDLOCKNUMBERMaximum Number of Locks Allowed for an Application5PERCENTAGEMaximum Percentage of Lock Entries for an Applicationnvarchar30
TOPNumber Range Management
50TNRODefinition of number range objects11PERCENTAGEPercentage for warning messagedecimal31
51TNROSTNRO Shadow Table for Number Range Object Transport11PERCENTAGEPercentage for warning messagedecimal31
TOPObjective Setting and Appraisals
52T77HAP_RTG_DISTPerformance-Goal Distribution6PERCENTAGEtinyint30
53T77HAP_VH_DISTAppraisal Process: Performance Goal Distribution6PERCENTAGEtinyint30
TOPOffice Suite Program
54/OSP/T_RULE_INFOBook keeping table for rule information in budget monitoring7PERCENTAGERelative Threshold Values in Percentdecimal101
TOPProcess Controls
55GRPCQANSWERSurvey question answers7PERCENTAGEPercentagedecimal74
TOPProduction Allocation
56GHO_COM_WC_ICommingled Well Completion Item5PERCENTAGE3-Byte fieldnvarchar30
57GHO_NODE_DS_SPNode Down Stream Split (Obsolete)5PERCENTAGE3-Byte fieldnvarchar30
58GHO_NODE_DS_SP_INode Down Stream Split4PERCENTAGE3-Byte fieldnvarchar30
59GHO_RULE_LOG_IAllocation Rule Log Item20PERCENTAGE3-Byte fieldnvarchar30
60GHO_SIMU_DS_SP_ISimulation: Node Down Stream Split rules Item4PERCENTAGE3-Byte fieldnvarchar30
61GHO_SIMU_WCOM_ISimulation: Commingled Well Completion Item5PERCENTAGE3-Byte fieldnvarchar30
TOPPublic Sector Contract Accounts Receivable and Payable
62DFMCA_BRF051BRF: Parameter for Checking Address Data7PERCENTAGEBRF: Percentage for Normalized Searchdecimal53
TOPSales
63/CBAD/CON_DBSAdvanced Order Processing and Billing: DBS Item Data9PERCENTAGEPercentage of WBS Elementdecimal52
TOPSAP Healthcare - Industry-Specific Components for Hospitals
64/ISHFR/SERVF04IS-H FR: LPP Pricing9PERCENTAGEIS-H FR: Factor (Percentage Rate)decimal63
TOPTime Sheet
65CATS_DEF_ACCOUNTCATS Default Accounting8PERCENTAGEPercentagedecimal52
TOPTools
66T52SMSHRPAY-Status Management: Steps in a Process Model9PERCENTAGEMinimum percentage ratenvarchar30
TOPTraining and Event Management
67T77REFDOCReference Document Table: Training and Event Management43PERCENTAGEPercentage rate for cost distributiondecimal52
TOPTransaction Manager
68IDCFMFLCALCRLPDescription of simplified flow calc.procedure (percentages)9PERCENTAGEPercentage Rate to Determine Derived Amountdecimal107
69TEMT_POLICYHedging Policy16PERCENTAGEMaximum Percentage to Be Hedgeddecimal52
70TEMT_VERSEXPOSVersioned Exposure23PERCENTAGEMaximum Percentage to Be Hedgeddecimal52
71TRDT_MULTASSGNMultiple Account Assignment of Flows12PERCENTAGEPercentage Rate for Multiple Account Assignmentdecimal74
72VTBFASGTAccount Assignment of a Financial Transaction Flow11PERCENTAGEPercentage Rate for Multiple Account Assignmentdecimal74
TOPWorkforce Management Application
73WFA_EMP_CONTREmployee contract assignment8PERCENTAGEPercentagedecimal62