| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SAPPSSRM/IPTRUL | Rules to be assigned to Item Process Type | 5 | RULEID | ID for Alphanumeric Rules | nvarchar | 2 | 0 | | |
2 | /SAPPSSRM/LINRUL | Link of the Item Level to the Rule | 7 | RULEID | ID for Alphanumeric Rules | nvarchar | 2 | 0 | | |
3 | /SAPPSSRM/NUMTYP | Type of Numbering Scheme for Long Procurement Numbering | 4 | RULEID | ID for Alphanumeric Rules | nvarchar | 2 | 0 | | |
4 | /SAPPSSRM/RULCNT | Content of alphanumeric numbering rules | 2 | RULEID | ID for Alphanumeric Rules | nvarchar | 2 | 0 | | |
5 | /SAPPSSRM/RULEID | IDs for alphanumeric numbering rules | 2 | RULEID | ID for Alphanumeric Rules | nvarchar | 2 | 0 | | |
6 | /SAPPSSRM/RULET | Description of IDs for alphanumeric Numbering Rules | 3 | RULEID | ID for Alphanumeric Rules | nvarchar | 2 | 0 | | |
7 | ACMDTCONDITION | ACM: GRANT Condition Persistence | 2 | RULEID | ACM: UUID of a Rule | varbinary | 16 | 0 | | |
8 | ACMTSTDTCONDITIO | ACMTST: DTCondition (Expected test-results) | 2 | RULEID | ACM: UUID of a Rule | varbinary | 16 | 0 | | |
9 | GHO_MEAS_RULES | Measurement Rules Mapped With Meas Point, Meas Grp, Meas | 5 | RULEID | UUID in character form | nvarchar | 32 | 0 | | |
10 | LWM_RS_LINE_DATA | Line Item Monitors for SAP Real Spend | 4 | RULEID | Rule Number | nvarchar | 6 | 0 | | |
11 | LWM_RS_VAR_DATA | Variance Monitors for SAP Real Spend | 4 | RULEID | Rule Number | nvarchar | 6 | 0 | | |
TOPBusiness Package for Manager Self-Service FI |
12 | FCOM_KSTAR | Cost Elements for Users | 5 | RULEID | Rule Number | nvarchar | 6 | 0 | | |
13 | FCOM_OBJECT | Objects for Users | 5 | RULEID | Rule Number | nvarchar | 6 | 0 | | |
14 | FPB_LINE_DATA | Data Store for Line Item Monitors | 4 | RULEID | Rule Number | nvarchar | 6 | 0 | | |
15 | FPB_LINE_DELDATA | Data Store for Line Item Monitors | 4 | RULEID | Rule Number | nvarchar | 6 | 0 | | |
16 | FPB_LINE_RULEADM | Line Item Monitor: Administration Rules | 3 | RULEID | Rule Number | nvarchar | 6 | 0 | | |
17 | FPB_LINE_RULES | Line Item Monitor: Rule Administration | 4 | RULEID | Rule Number | nvarchar | 6 | 0 | | |
18 | FPB_RULEGUIDANCE | Monitors: Guidance in Administration Rules | 4 | RULEID | Rule Number | nvarchar | 6 | 0 | | |
19 | FPB_VAR_DATA | Data Storage Location for Variance Monitors | 4 | RULEID | Rule Number | nvarchar | 6 | 0 | | |
20 | FPB_VAR_RULES | Variance Monitor: Rule Administration | 4 | RULEID | Rule Number | nvarchar | 6 | 0 | | |
21 | FPB_VAR_RULE_ADM | Variance Monitor: Administration Rules | 3 | RULEID | Rule Number | nvarchar | 6 | 0 | | |
TOPClinical System |
22 | N2DPREFETCH | IS-H*MED RAD: Prefetch rule | 2 | RULEID | Code of the prefetch rule | nvarchar | 10 | 0 | | |
TOPCountry-Specific Objects |
23 | TAXNUMCHK | Rules for checking tax codes | 4 | RULEID | Rule Identifier for Tax Number Checks | nvarchar | 6 | 0 | | |
24 | TAXNUMCHKPOS | Rules for Checking Tax Numbers - Positions | 4 | RULEID | Rule Identifier for Tax Number Checks | nvarchar | 6 | 0 | | |
TOPData Staging |
25 | RSERRORLOC | Location of Check | 6 | RULEID | Unique Identifier of a Rule (Includes RSTRAN_RULEID) | nvarchar | 10 | 0 | | |
26 | RSTRANFIELD | Mapping of Rule Parameters - Structure Fields | 4 | RULEID | Number of Rule Within a Transformation | smallint | 5 | 0 | | |
27 | RSTRANRULE | Transformation Rule | 3 | RULEID | Number of Rule Within a Transformation | smallint | 5 | 0 | | |
28 | RSTRANRULESTEP | Rule Steps for a Transformation Rule | 3 | RULEID | Number of Rule Within a Transformation | smallint | 5 | 0 | | |
29 | RSTRANRULET | Texts for a Transformation Rule | 4 | RULEID | Number of Rule Within a Transformation | smallint | 5 | 0 | | |
30 | RSTRANRULE_TEST | Mapping Table for Single Rule Simulation | 2 | RULEID | Number of Rule Within a Transformation | smallint | 5 | 0 | | |
31 | RSTRANSTEPCNST | Rule Type: Constant | 3 | RULEID | Number of Rule Within a Transformation | smallint | 5 | 0 | | |
32 | RSTRANSTEPIOBJ | Rule Step: InfoObject Assignment | 3 | RULEID | Number of Rule Within a Transformation | smallint | 5 | 0 | | |
33 | RSTRANSTEPMAP | Mapping for Rule Step Within a Rule | 3 | RULEID | Number of Rule Within a Transformation | smallint | 5 | 0 | | |
34 | RSTRANSTEPMASTER | Rule Type: Read Master Data | 3 | RULEID | Number of Rule Within a Transformation | smallint | 5 | 0 | | |
35 | RSTRANSTEPMOVE | Rule Type: Direct or MOVE | 3 | RULEID | Number of Rule Within a Transformation | smallint | 5 | 0 | | |
36 | RSTRANSTEPODSO | Rule Type: Read DataStore Object | 3 | RULEID | Number of Rule Within a Transformation | smallint | 5 | 0 | | |
37 | RSTRANSTEPROUT | Rule Type: Routine | 3 | RULEID | Number of Rule Within a Transformation | smallint | 5 | 0 | | |
38 | RSTRANSTEPTIME | Rule Type: Direct or MOVE | 3 | RULEID | Number of Rule Within a Transformation | smallint | 5 | 0 | | |
39 | RSTRANSTEPUNIT | Rule Type: Direct or MOVE | 3 | RULEID | Number of Rule Within a Transformation | smallint | 5 | 0 | | |
TOPEmployee Interaction Center |
40 | THREIC_RULEDEF | EIC: Rule Modeler: Rule Definition | 3 | RULEID | EIC: Rule Modeler: Rule | nvarchar | 10 | 0 | | |
41 | THREIC_RULEDEF_T | EIC: Rule Modeler: Rule Definition: Text | 4 | RULEID | EIC: Rule Modeler: Rule | nvarchar | 10 | 0 | | |
42 | THREIC_RULE_ACT | EIC: Rule Modeler: Action-to-Rule Assignment | 3 | RULEID | EIC: Rule Modeler: Rule | nvarchar | 10 | 0 | | |
43 | THREIC_RULE_COND | EIC: Rule Modeler: Condition-to-Rule Assignment | 3 | RULEID | EIC: Rule Modeler: Rule | nvarchar | 10 | 0 | | |
TOPFunds Management |
44 | FMFGRCNFACTOR | Reconciliation: Factors in a reconciliation rule | 2 | RULEID | Reconciliation: Rule Identifier | nvarchar | 10 | 0 | | |
45 | FMFGRCNFLD | Reconciliation: selection and sort/group fields for rule | 2 | RULEID | Reconciliation: Rule Identifier | nvarchar | 10 | 0 | | |
46 | FMFGRCNRULE | Reconciliation: Reconcilation Rule definition | 2 | RULEID | Reconciliation: Rule Identifier | nvarchar | 10 | 0 | | |
47 | FMFGRCNRULET | Reconciliation: Reconcilation Rule texts | 3 | RULEID | Reconciliation: Rule Identifier | nvarchar | 10 | 0 | | |
TOPGRC Access Control Plug-In |
48 | /VIRSA/INT_TRIG | HR Triggers - Trigger Information | 3 | RULEID | Char 20 | nvarchar | 20 | 0 | | |
49 | /VIRSA/RULEATTR | HR Triggers - Rule Attributes | 2 | RULEID | Char 20 | nvarchar | 20 | 0 | | |
50 | /VIRSA/RULEATTRN | HR Triggers - Rule Attributes | 2 | RULEID | Char 20 | nvarchar | 20 | 0 | | |
51 | /VIRSA/RULEDET | HR Triggers - Rule Details | 2 | RULEID | Char 20 | nvarchar | 20 | 0 | | |
52 | /VIRSA/RULEDETT | HR Triggers - Rule Descriptions | 2 | RULEID | Char 20 | nvarchar | 20 | 0 | | |
TOPMedia Product Sales and Distribution |
53 | TJVSDSHPSTATRULE | Shipping Schedule, Change Rule for Issue Status | 2 | RULEID | Rule for Changing Material Status in Shipping Plan | nvarchar | 3 | 0 | | |
54 | TJVSDSHPSTATRULT | Shipping Schedule, Change Rule for Issue Status | 2 | RULEID | Rule for Changing Material Status in Shipping Plan | nvarchar | 3 | 0 | | |
55 | TJVSDSHPSTATUSCH | Shipping Schedule, Change Rule for Issue Status | 3 | RULEID | Rule for Changing Material Status in Shipping Plan | nvarchar | 3 | 0 | | |
TOPOffice Suite Program |
56 | /OSP/T_ALERT_INF | Book keeping table for alert information in budget monitor | 5 | RULEID | Rule ID of the rule from the backend (MSS Portal) | nvarchar | 6 | 0 | | |
57 | /OSP/T_BM_PERS | To store personalization information for Budget monitoring | 5 | RULEID | Rule ID of the rule from the backend (MSS Portal) | nvarchar | 6 | 0 | | |
58 | /OSP/T_POSTING | To store the Book keeping info of critical posting alerts | 5 | RULEID | Rule ID of the rule from the backend (MSS Portal) | nvarchar | 6 | 0 | | |
59 | /OSP/T_RULE_INFO | Book keeping table for rule information in budget monitoring | 5 | RULEID | Rule ID of the rule from the backend (MSS Portal) | nvarchar | 6 | 0 | | |
60 | /OSP/T_RULE_OBJ | Book keeping table to store list of cost objects of a rule | 5 | RULEID | Rule ID of the rule from the backend (MSS Portal) | nvarchar | 6 | 0 | | |
61 | /OSP/T_VARIANCE | Book Keeping information about critical variance alerts | 5 | RULEID | Rule ID of the rule from the backend (MSS Portal) | nvarchar | 6 | 0 | | |
TOPPayroll |
62 | T5HAA | Cumulation interrelations | 2 | RULEID | Rule identification | nvarchar | 3 | 0 | | |
TOPProcess Controls |
63 | GRPCRLSETT | Rule Parameters Description | 3 | RULEID | Rule | nvarchar | 20 | 0 | | |
64 | GRPCRLSETT_SNP | Rule Parameters Description | 4 | RULEID | Rule | nvarchar | 20 | 0 | | |
65 | GRPCRLSTEPT | Rule Parameters Description - obsolete | 3 | RULEID | Rule | nvarchar | 20 | 0 | | |
66 | GRPCRULE | Rule | 2 | RULEID | Rule | nvarchar | 20 | 0 | | |
67 | GRPCRULET | Rule Description | 3 | RULEID | Rule | nvarchar | 20 | 0 | | |
68 | GRPCRULET_SNP | Rule Description | 4 | RULEID | Rule | nvarchar | 20 | 0 | | |
69 | GRPCRULE_SNP | Rule for Snapshot | 3 | RULEID | Rule | nvarchar | 20 | 0 | | |
70 | GRPCRULE_TEMP | Rule - Temporary table for installation | 2 | RULEID | Rule | nvarchar | 20 | 0 | | |
71 | GRPCRVVAL | Rule Criteria Value | 2 | RULEID | Rule | nvarchar | 20 | 0 | | |
72 | GRPCRVVAL_SNP | Rule Criteria Value | 3 | RULEID | Rule | nvarchar | 20 | 0 | | |
73 | GRPCTRANS | GRC Rules Analysis | 2 | RULEID | Rule | nvarchar | 20 | 0 | | |
74 | GRPCTRANS_SNP | GRC Rules Analysis | 3 | RULEID | Rule | nvarchar | 20 | 0 | | |
75 | HRP5330 | DB Table for Infotype 5330 | 18 | RULEID | Rule | nvarchar | 20 | 0 | | |
TOPReceivablesPayment Management |
76 | TDIMPLEMENTRULES | Processing Rules for Contracts with Stop Codes | 6 | RULEID | Key for Payment Rule | nvarchar | 3 | 0 | | |
77 | TDIPDRULES | Customizing Table, Definition of Processing Rules | 2 | RULEID | Key for Payment Rule | nvarchar | 3 | 0 | | |
78 | TDIPDRULEST | Text Table for Rule Key | 2 | RULEID | Key for Payment Rule | nvarchar | 3 | 0 | | |
TOPSolution Directory |
79 | SDTSRULE | DTS: Recurrence Rules for Downtimes | 3 | RULEID | Internal Identification of Rules of Periodic Appointments | nvarchar | 25 | 0 | | |
TOPTraders and Schedulers Workbench |
80 | OIJHTNR | OIL-TSW: Ticket Number Rules | 2 | RULEID | OIL-TSW: Ticket number rules | nvarchar | 3 | 0 | | |
81 | OIJHTNRT | OIL-TSW: Ticket Number Rules Texts | 3 | RULEID | OIL-TSW: Ticket number rules | nvarchar | 3 | 0 | | |
82 | OIJRRA | OIL-TSW: Partner roles | 13 | RULEID | OIL-TSW: Ticket number rules | nvarchar | 3 | 0 | | |
TOPVisit Control |
83 | /DSD/VC_VPH | DSD: Visit Schedule - Header Data | 5 | RULEID | Internal Identification of Rules of Periodic Appointments | nvarchar | 25 | 0 | | |