VISRTMSBRPI

Transparent Table Application Table
15 Fields 1 CDS Views

Assignment of Reporting Rule to Sales Rule (Grading)

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RESalesRuleRptgAssgmtGrading view from BASIC Real Estate Sales Reporting Grading

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.
KEY itemno RESRGRADINGITEMNO Sequence number
salescurr WAERS Currency
salesunit RESRSALESUNIT Unit
minsales RESRMINSALESSALESGRADING Sales from
maxsales RESRMAXSALESSALESGRADING Sales To
rentpercent RESRRENTPERCENT % rate
minquantity RESRMINQUANTITY Q.Sales From
maxquantity RESRMAXQUANTITY Q.Sales To
priceperunit RESRPRICEPERUNIT Amount/UnitMeas
minrent RESRMINRENTSALESGRADING MinRent/SalGrad

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 Reporting Rule to Sales Rule (Grading)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VISRTMSBRPI (
    MANDT,         -- Client [MANDT]
    INTRENO,       -- RE Key [RECAINTRENO]
    SBTERMNO,      -- SR No. [RESRTMSBTERMNO]
    SBVALIDFROM,   -- Valid From [RETMTERMVALIDFROM]
    RPTERMNO,      -- RepRuleNo. [RESRTMRPTERMNO]
    ITEMNO,        -- Sequence number [RESRGRADINGITEMNO]
    SALESCURR,     -- Currency [WAERS]
    SALESUNIT,     -- Unit [RESRSALESUNIT]
    MINSALES,      -- Sales from [RESRMINSALESSALESGRADING]
    MAXSALES,      -- Sales To [RESRMAXSALESSALESGRADING]
    RENTPERCENT,   -- % rate [RESRRENTPERCENT]
    MINQUANTITY,   -- Q.Sales From [RESRMINQUANTITY]
    MAXQUANTITY,   -- Q.Sales To [RESRMAXQUANTITY]
    PRICEPERUNIT,  -- Amount/UnitMeas [RESRPRICEPERUNIT]
    MINRENT,       -- MinRent/SalGrad [RESRMINRENTSALESGRADING]
    PRIMARY KEY (MANDT, INTRENO, SBTERMNO, SBVALIDFROM, RPTERMNO, ITEMNO)
);

Learn More