SAPRecommendationAdjustmentReason Table

This table stores SAP Recommendation adjustment reasons.

Table 1. Database columns for SAPRecommendationAdjustmentReason table

Database Column

Details

SAPRecommendation AdjustmentReasonID

Type: integer. Key. Generated ID

A unique identifier for each SAPRecommendationAdjustmentReason. Possible values and the corresponding default strings are:

  • 1 = License ratio enforced
  • 2 = Excess purchase(s) of covering license type applied.
ResourceName

Type: text (max 256 characters). Key

A localizable resource string representing an SAP recommendation adjustment reason. Foreign key to the ComplianceResourceString table.

DefaultValue

Type: text (max 100 characters)

The text to display if the adjustment reason resource string has no translation.