VISRTMSBRP

Assignment of a Reporting Rule to a Sales Rule | #masterdata | Component: Sales-Based Rent and Settlement
Column Name Description
MANDT Client
INTRENO Internal Key of Real Estate Object
SBTERMNO FK Term Number of Sales Rule
SBVALIDFROM Valid-From Date of Term
RPTERMNO FK Term Number of Reporting Rule
Column Name Description
πŸ’² Currency Key (SALESCURR):
MINSALESREP Minimum sales in reporting interval
MINSALES Minimum Monetary Sales in the Settlement Period
MAXSALES Maximum (Monetary) Sales in the Settlement Period
Column Name Description
πŸ“ Unit of measurement of sales reporting values (SALESUNIT):
MINQUANTITYREP Minimum Quantitative Sales in Reporting Interval
MINQUANTITY Minimum Quantitative Sales in Settlement Period
MAXQUANTITY Maximum Quantitative Sales in Settlement Period
Column Name Description
SBVALIDFROM Valid-From Date of Term
Column Name Description
AMOUNTTYPE What Sales Should Be Used for Calculation Show values
AMOUNTTYPE_QUAN Is Price per Unit of Measure a Net or Gross Pricee Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Term Number of Reporting Rule
  • Term Number of Reporting Rule
  • ?
  • VISRTMSBRP.MANDT == VISRTMRP.MANDT
  • VISRTMSBRP.RPTERMNO == VISRTMRP.INTRENO
  • VISRTMSBRP.[column in domain "RETMTERMTYPE"] == VISRTMRP.TERMTYPE