TIVBDVACREAS

Transparent Table Customizing Table

Vacancy Reason

TIVBDVACREAS is an SAP database table in S/4HANA. Vacancy Reason. It contains 9 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_REVacancyReason view from BASIC Real Estate Vacancy Reason

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY vacreason REBDVACREASON Vacancy Reason
diffacctype REBDDIFFACCTYPE Vac. AcctAssgmt
vacforceacc REBDVACFORCEACC FollPost.f.Chg
accdetkey RERAACCDETKEY AcctDeterm.Val.
isvacreasrodef REBDISVACREASRODEF Gen.at Creation
termnovac REBDTMNOVAC Posting Term
vacinflrental REBDVACINFLRENTAL Sub.RentalInfl.
isvacreasman REBDISVACREASMAN Manual Usage

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.

-- Vacancy Reason
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TIVBDVACREAS (
    MANDT,           -- Client [MANDT]
    VACREASON,       -- Vacancy Reason [REBDVACREASON]
    DIFFACCTYPE,     -- Vac. AcctAssgmt [REBDDIFFACCTYPE]
    VACFORCEACC,     -- FollPost.f.Chg [REBDVACFORCEACC]
    ACCDETKEY,       -- AcctDeterm.Val. [RERAACCDETKEY]
    ISVACREASRODEF,  -- Gen.at Creation [REBDISVACREASRODEF]
    TERMNOVAC,       -- Posting Term [REBDTMNOVAC]
    VACINFLRENTAL,   -- Sub.RentalInfl. [REBDVACINFLRENTAL]
    ISVACREASMAN,    -- Manual Usage [REBDISVACREASMAN]
    PRIMARY KEY (MANDT, VACREASON)
);