VISRTMSBRP

Transparent Table Application Table
15 Fields 1 CDS Views

Assignment of a Reporting Rule to a Sales Rule

VISRTMSBRP is an SAP database table in S/4HANA. Assignment of a Reporting Rule to a Sales Rule. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RESalesRuleReportingAssgmt view from BASIC Real Estate Sales Reporting Assignment

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY intreno RECAINTRENO RE Key
KEY sbtermno RESRTMSBTERMNO SR No.
KEY sbvalidfrom RETMTERMVALIDFROM Valid From
KEY rptermno RESRTMRPTERMNO RepRuleNo.
salescurr WAERS Currency
salesunit RESRSALESUNIT Unit
amounttype RESRCALCAMOUNTTYPE What Sales
minsalesrep RESRMINSALESREP Min.sales/rep.
minsales RESRMINSALESSEPER Min.sales (Amt)
maxsales RESRMAXSALESSEPER Max.sales(amnt)
minquantityrep RESRMINQUANREP MinQSales/RepI
minquantity RESRMINQUANSEPER Min.Q.Sales
maxquantity RESRMAXQUANSEPER Max.Q.Sales
amounttype_quan RESRPRICEPERUNITAMOUNTTYPE Net/Gross

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Assignment of a Reporting Rule to a Sales Rule
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VISRTMSBRP (
    MANDT,            -- Client [MANDT]
    INTRENO,          -- RE Key [RECAINTRENO]
    SBTERMNO,         -- SR No. [RESRTMSBTERMNO]
    SBVALIDFROM,      -- Valid From [RETMTERMVALIDFROM]
    RPTERMNO,         -- RepRuleNo. [RESRTMRPTERMNO]
    SALESCURR,        -- Currency [WAERS]
    SALESUNIT,        -- Unit [RESRSALESUNIT]
    AMOUNTTYPE,       -- What Sales [RESRCALCAMOUNTTYPE]
    MINSALESREP,      -- Min.sales/rep. [RESRMINSALESREP]
    MINSALES,         -- Min.sales (Amt) [RESRMINSALESSEPER]
    MAXSALES,         -- Max.sales(amnt) [RESRMAXSALESSEPER]
    MINQUANTITYREP,   -- MinQSales/RepI [RESRMINQUANREP]
    MINQUANTITY,      -- Min.Q.Sales [RESRMINQUANSEPER]
    MAXQUANTITY,      -- Max.Q.Sales [RESRMAXQUANSEPER]
    AMOUNTTYPE_QUAN,  -- Net/Gross [RESRPRICEPERUNITAMOUNTTYPE]
    PRIMARY KEY (MANDT, INTRENO, SBTERMNO, SBVALIDFROM, RPTERMNO)
);

Learn More