SAP Table RESRTMSBRPI_S
Assignment of a Reporting Rule to a Sales Rule (Grading)
RESRTMSBRPI_S (Assignment of a Reporting Rule to a Sales Rule (Grading)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link RESRTMSBRPI_S to other SAP tables.
Source: RESRTMSBRPI_S (Assignment of a Reporting Rule to a Sales Rule (Grading))
RESRTMSBRPI_S table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | 0 | |||
| INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | 0 | |||
| SBTERMNO | Term Number of Sales Rule | RESRTMSBTERMNO | VISRTMSB | CHAR | 4 | 0 | ||
| SBVALIDFROM | Valid-From Date of Term | RETMTERMVALIDFROM | DATS | 8 | 0 | |||
| RPTERMNO | Term Number of Reporting Rule | RESRTMRPTERMNO | VISRTMRP | CHAR | 4 | 0 | ||
| ITEMNO | Sequence number for sales amount and percentage | RESRGRADINGITEMNO | NUMC | 3 | 0 | |||
| SALESCURR | Currency Key | WAERS | CUKY | 5 | 0 | |||
| SALESUNIT | Unit of measurement of sales reporting values | RESRSALESUNIT | UNIT | 3 | 0 | |||
| MINSALES | Sales (minimum) | RESRMINSALESSALESGRADING | CURR | 15 | 2 | |||
| MAXSALES | Sales (maximum) | RESRMAXSALESSALESGRADING | CURR | 15 | 2 | |||
| RENTPERCENT | Percentage of sales as rent | RESRRENTPERCENT | DEC | 5 | 2 | |||
| MINQUANTITY | Quantitative Sales (Minimum) | RESRMINQUANTITY | QUAN | 17 | 4 | |||
| MAXQUANTITY | Quantitative Sales (Maximum) | RESRMAXQUANTITY | QUAN | 17 | 4 | |||
| PRICEPERUNIT | Amount per unit of measure | RESRPRICEPERUNIT | DEC | 19 | 6 | |||
| MINRENT | Minimum rent per sales grading | RESRMINRENTSALESGRADING | CURR | 15 | 2 | |||
RESRTMSBRPI_S foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| RESRTMSBRPI_S | RPTERMNO | SYST | MANDT | VISRTMRP | Reporting Rule | MANDT |
| RESRTMSBRPI_S | RPTERMNO | RESRTMSBRPI_S | INTRENO | VISRTMRP | Reporting Rule | .INCLUDE |
| RESRTMSBRPI_S | RPTERMNO | '1410' | VISRTMRP | Reporting Rule | .INCLUDE | |
| RESRTMSBRPI_S | RPTERMNO | RESRTMSBRPI_S | RPTERMNO | VISRTMRP | Reporting Rule | INTRENO |
| RESRTMSBRPI_S | RPTERMNO | * | VISRTMRP | Reporting Rule | TERMTYPE | |
| RESRTMSBRPI_S | SBTERMNO | SYST | MANDT | VISRTMSB | Sales Rule | MANDT |
| RESRTMSBRPI_S | SBTERMNO | RESRTMSBRPI_S | INTRENO | VISRTMSB | Sales Rule | .INCLUDE |
| RESRTMSBRPI_S | SBTERMNO | '1420' | VISRTMSB | Sales Rule | .INCLUDE | |
| RESRTMSBRPI_S | SBTERMNO | RESRTMSBRPI_S | SBTERMNO | VISRTMSB | Sales Rule | INTRENO |
| RESRTMSBRPI_S | SBTERMNO | RESRTMSBRPI_S | SBVALIDFROM | VISRTMSB | Sales Rule | TERMTYPE |
