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

83 columns | Print definition?ERP 6.0  | RULEID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPPSSRM/IPTRULRules to be assigned to Item Process Type5RULEIDID for Alphanumeric Rulesnvarchar20
2/SAPPSSRM/LINRULLink of the Item Level to the Rule7RULEIDID for Alphanumeric Rulesnvarchar20
3/SAPPSSRM/NUMTYPType of Numbering Scheme for Long Procurement Numbering4RULEIDID for Alphanumeric Rulesnvarchar20
4/SAPPSSRM/RULCNTContent of alphanumeric numbering rules2RULEIDID for Alphanumeric Rulesnvarchar20
5/SAPPSSRM/RULEIDIDs for alphanumeric numbering rules2RULEIDID for Alphanumeric Rulesnvarchar20
6/SAPPSSRM/RULETDescription of IDs for alphanumeric Numbering Rules3RULEIDID for Alphanumeric Rulesnvarchar20
7ACMDTCONDITIONACM: GRANT Condition Persistence2RULEIDACM: UUID of a Rulevarbinary160
8ACMTSTDTCONDITIOACMTST: DTCondition (Expected test-results)2RULEIDACM: UUID of a Rulevarbinary160
9GHO_MEAS_RULESMeasurement Rules Mapped With Meas Point, Meas Grp, Meas5RULEIDUUID in character formnvarchar320
10LWM_RS_LINE_DATALine Item Monitors for SAP Real Spend4RULEIDRule Numbernvarchar60
11LWM_RS_VAR_DATAVariance Monitors for SAP Real Spend4RULEIDRule Numbernvarchar60
TOPBusiness Package for Manager Self-Service FI
12FCOM_KSTARCost Elements for Users5RULEIDRule Numbernvarchar60
13FCOM_OBJECTObjects for Users5RULEIDRule Numbernvarchar60
14FPB_LINE_DATAData Store for Line Item Monitors4RULEIDRule Numbernvarchar60
15FPB_LINE_DELDATAData Store for Line Item Monitors4RULEIDRule Numbernvarchar60
16FPB_LINE_RULEADMLine Item Monitor: Administration Rules3RULEIDRule Numbernvarchar60
17FPB_LINE_RULESLine Item Monitor: Rule Administration4RULEIDRule Numbernvarchar60
18FPB_RULEGUIDANCEMonitors: Guidance in Administration Rules4RULEIDRule Numbernvarchar60
19FPB_VAR_DATAData Storage Location for Variance Monitors4RULEIDRule Numbernvarchar60
20FPB_VAR_RULESVariance Monitor: Rule Administration4RULEIDRule Numbernvarchar60
21FPB_VAR_RULE_ADMVariance Monitor: Administration Rules3RULEIDRule Numbernvarchar60
TOPClinical System
22N2DPREFETCHIS-H*MED RAD: Prefetch rule2RULEIDCode of the prefetch rulenvarchar100
TOPCountry-Specific Objects
23TAXNUMCHKRules for checking tax codes4RULEIDRule Identifier for Tax Number Checksnvarchar60
24TAXNUMCHKPOSRules for Checking Tax Numbers - Positions4RULEIDRule Identifier for Tax Number Checksnvarchar60
TOPData Staging
25RSERRORLOCLocation of Check6RULEIDUnique Identifier of a Rule (Includes RSTRAN_RULEID)nvarchar100
26RSTRANFIELDMapping of Rule Parameters - Structure Fields4RULEIDNumber of Rule Within a Transformationsmallint50
27RSTRANRULETransformation Rule3RULEIDNumber of Rule Within a Transformationsmallint50
28RSTRANRULESTEPRule Steps for a Transformation Rule3RULEIDNumber of Rule Within a Transformationsmallint50
29RSTRANRULETTexts for a Transformation Rule4RULEIDNumber of Rule Within a Transformationsmallint50
30RSTRANRULE_TESTMapping Table for Single Rule Simulation2RULEIDNumber of Rule Within a Transformationsmallint50
31RSTRANSTEPCNSTRule Type: Constant3RULEIDNumber of Rule Within a Transformationsmallint50
32RSTRANSTEPIOBJRule Step: InfoObject Assignment3RULEIDNumber of Rule Within a Transformationsmallint50
33RSTRANSTEPMAPMapping for Rule Step Within a Rule3RULEIDNumber of Rule Within a Transformationsmallint50
34RSTRANSTEPMASTERRule Type: Read Master Data3RULEIDNumber of Rule Within a Transformationsmallint50
35RSTRANSTEPMOVERule Type: Direct or MOVE3RULEIDNumber of Rule Within a Transformationsmallint50
36RSTRANSTEPODSORule Type: Read DataStore Object3RULEIDNumber of Rule Within a Transformationsmallint50
37RSTRANSTEPROUTRule Type: Routine3RULEIDNumber of Rule Within a Transformationsmallint50
38RSTRANSTEPTIMERule Type: Direct or MOVE3RULEIDNumber of Rule Within a Transformationsmallint50
39RSTRANSTEPUNITRule Type: Direct or MOVE3RULEIDNumber of Rule Within a Transformationsmallint50
TOPEmployee Interaction Center
40THREIC_RULEDEFEIC: Rule Modeler: Rule Definition3RULEIDEIC: Rule Modeler: Rulenvarchar100
41THREIC_RULEDEF_TEIC: Rule Modeler: Rule Definition: Text4RULEIDEIC: Rule Modeler: Rulenvarchar100
42THREIC_RULE_ACTEIC: Rule Modeler: Action-to-Rule Assignment3RULEIDEIC: Rule Modeler: Rulenvarchar100
43THREIC_RULE_CONDEIC: Rule Modeler: Condition-to-Rule Assignment3RULEIDEIC: Rule Modeler: Rulenvarchar100
TOPFunds Management
44FMFGRCNFACTORReconciliation: Factors in a reconciliation rule2RULEIDReconciliation: Rule Identifiernvarchar100
45FMFGRCNFLDReconciliation: selection and sort/group fields for rule2RULEIDReconciliation: Rule Identifiernvarchar100
46FMFGRCNRULEReconciliation: Reconcilation Rule definition2RULEIDReconciliation: Rule Identifiernvarchar100
47FMFGRCNRULETReconciliation: Reconcilation Rule texts3RULEIDReconciliation: Rule Identifiernvarchar100
TOPGRC Access Control Plug-In
48/VIRSA/INT_TRIGHR Triggers - Trigger Information3RULEIDChar 20nvarchar200
49/VIRSA/RULEATTRHR Triggers - Rule Attributes2RULEIDChar 20nvarchar200
50/VIRSA/RULEATTRNHR Triggers - Rule Attributes2RULEIDChar 20nvarchar200
51/VIRSA/RULEDETHR Triggers - Rule Details2RULEIDChar 20nvarchar200
52/VIRSA/RULEDETTHR Triggers - Rule Descriptions2RULEIDChar 20nvarchar200
TOPMedia Product Sales and Distribution
53TJVSDSHPSTATRULEShipping Schedule, Change Rule for Issue Status2RULEIDRule for Changing Material Status in Shipping Plannvarchar30
54TJVSDSHPSTATRULTShipping Schedule, Change Rule for Issue Status2RULEIDRule for Changing Material Status in Shipping Plannvarchar30
55TJVSDSHPSTATUSCHShipping Schedule, Change Rule for Issue Status3RULEIDRule for Changing Material Status in Shipping Plannvarchar30
TOPOffice Suite Program
56/OSP/T_ALERT_INFBook keeping table for alert information in budget monitor5RULEIDRule ID of the rule from the backend (MSS Portal)nvarchar60
57/OSP/T_BM_PERSTo store personalization information for Budget monitoring5RULEIDRule ID of the rule from the backend (MSS Portal)nvarchar60
58/OSP/T_POSTINGTo store the Book keeping info of critical posting alerts5RULEIDRule ID of the rule from the backend (MSS Portal)nvarchar60
59/OSP/T_RULE_INFOBook keeping table for rule information in budget monitoring5RULEIDRule ID of the rule from the backend (MSS Portal)nvarchar60
60/OSP/T_RULE_OBJBook keeping table to store list of cost objects of a rule5RULEIDRule ID of the rule from the backend (MSS Portal)nvarchar60
61/OSP/T_VARIANCEBook Keeping information about critical variance alerts5RULEIDRule ID of the rule from the backend (MSS Portal)nvarchar60
TOPPayroll
62T5HAACumulation interrelations2RULEIDRule identificationnvarchar30
TOPProcess Controls
63GRPCRLSETTRule Parameters Description3RULEIDRulenvarchar200
64GRPCRLSETT_SNPRule Parameters Description4RULEIDRulenvarchar200
65GRPCRLSTEPTRule Parameters Description - obsolete3RULEIDRulenvarchar200
66GRPCRULERule2RULEIDRulenvarchar200
67GRPCRULETRule Description3RULEIDRulenvarchar200
68GRPCRULET_SNPRule Description4RULEIDRulenvarchar200
69GRPCRULE_SNPRule for Snapshot3RULEIDRulenvarchar200
70GRPCRULE_TEMPRule - Temporary table for installation2RULEIDRulenvarchar200
71GRPCRVVALRule Criteria Value2RULEIDRulenvarchar200
72GRPCRVVAL_SNPRule Criteria Value3RULEIDRulenvarchar200
73GRPCTRANSGRC Rules Analysis2RULEIDRulenvarchar200
74GRPCTRANS_SNPGRC Rules Analysis3RULEIDRulenvarchar200
75HRP5330DB Table for Infotype 533018RULEIDRulenvarchar200
TOPReceivablesPayment Management
76TDIMPLEMENTRULESProcessing Rules for Contracts with Stop Codes6RULEIDKey for Payment Rulenvarchar30
77TDIPDRULESCustomizing Table, Definition of Processing Rules2RULEIDKey for Payment Rulenvarchar30
78TDIPDRULESTText Table for Rule Key2RULEIDKey for Payment Rulenvarchar30
TOPSolution Directory
79SDTSRULEDTS: Recurrence Rules for Downtimes3RULEIDInternal Identification of Rules of Periodic Appointmentsnvarchar250
TOPTraders and Schedulers Workbench
80OIJHTNROIL-TSW: Ticket Number Rules2RULEIDOIL-TSW: Ticket number rulesnvarchar30
81OIJHTNRTOIL-TSW: Ticket Number Rules Texts3RULEIDOIL-TSW: Ticket number rulesnvarchar30
82OIJRRAOIL-TSW: Partner roles13RULEIDOIL-TSW: Ticket number rulesnvarchar30
TOPVisit Control
83/DSD/VC_VPHDSD: Visit Schedule - Header Data5RULEIDInternal Identification of Rules of Periodic Appointmentsnvarchar250