VISRTMSBRH

Transparent Table Application Table
13 Fields 1 CDS Views

Assignment of Frequency Rule to Sales Rule

VISRTMSBRH is an SAP database table in S/4HANA. Assignment of Frequency Rule to Sales Rule. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RESlsRuleFrequencyTermBasic view from BASIC Real Estate Sales Rule frequency Basic

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY intreno RECAINTRENO RE Key
KEY sbtermtype RETMTERMTYPE Term Category
KEY sbtermno RESRTMSBTERMNO SR No.
KEY sbvalidfrom RETMTERMVALIDFROM Valid From
KEY rhythmtype RESRRHYTHMTYPE Frequency Type
rhytmbegin RESRRHBEGIN Frequency Start
frequency RESRFREQUENCY Frequency
frequencyunit RESRFREQUENCYUNIT Frequency Unit
fixper RECDFIXPER Fixed Periods
prorate RECDPRORATE Pro Rata
calcmethper RECDCALCMETHPER Calculat.Method
creditpayback RESRCREDITPAYBACK Pay

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 Frequency Rule to Sales Rule
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VISRTMSBRH (
    MANDT,          -- Client [MANDT]
    INTRENO,        -- RE Key [RECAINTRENO]
    SBTERMTYPE,     -- Term Category [RETMTERMTYPE]
    SBTERMNO,       -- SR No. [RESRTMSBTERMNO]
    SBVALIDFROM,    -- Valid From [RETMTERMVALIDFROM]
    RHYTHMTYPE,     -- Frequency Type [RESRRHYTHMTYPE]
    RHYTMBEGIN,     -- Frequency Start [RESRRHBEGIN]
    FREQUENCY,      -- Frequency [RESRFREQUENCY]
    FREQUENCYUNIT,  -- Frequency Unit [RESRFREQUENCYUNIT]
    FIXPER,         -- Fixed Periods [RECDFIXPER]
    PRORATE,        -- Pro Rata [RECDPRORATE]
    CALCMETHPER,    -- Calculat.Method [RECDCALCMETHPER]
    CREDITPAYBACK,  -- Pay [RESRCREDITPAYBACK]
    PRIMARY KEY (MANDT, INTRENO, SBTERMTYPE, SBTERMNO, SBVALIDFROM, RHYTHMTYPE)
);

Learn More