I_REVacancyReason

DDL: I_REVACANCYREASON SQL: IREVACREASON Type: view BASIC
9 Fields 1 Data Sources 1 Associations

Real Estate Vacancy Reason

I_REVacancyReason is a Basic CDS View (Dimension) that provides data about "Real Estate Vacancy Reason" in SAP S/4HANA. It reads from 1 data source (tivbdvacreas) and exposes 9 fields with key field REContractVacancyReason. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
tivbdvacreas tivbdvacreas from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_REVacancyReasonText _Text $projection.REContractVacancyReason = _Text.REContractVacancyReason

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IREVACREASON view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Real Estate Vacancy Reason view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY REContractVacancyReason vacreason Vacancy Reason
REVacancyAccountingType diffacctype Vac. AcctAssgmt
REVacancyHasFlagGenPostings vacforceacc FollPost.f.Chg
REVacancyAccountDetermination accdetkey AcctDeterm.Val.
REVacancyHasPostingOnCreation isvacreasrodef Gen.at Creation
REVacancyPostingTermNumber termnovac Posting Term
REVacancyPeriodImpact vacinflrental Sub.RentalInfl.
REVacancyIsManualSetReason isvacreasman Manual Usage
_Text _Text

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_REVacancyReason.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IREVACREASON

CREATE VIEW I_REVacancyReason AS
SELECT
  vacreason AS REContractVacancyReason,
  diffacctype AS REVacancyAccountingType,
  vacforceacc AS REVacancyHasFlagGenPostings,
  accdetkey AS REVacancyAccountDetermination,
  isvacreasrodef AS REVacancyHasPostingOnCreation,
  termnovac AS REVacancyPostingTermNumber,
  vacinflrental AS REVacancyPeriodImpact,
  isvacreasman AS REVacancyIsManualSetReason
FROM tivbdvacreas
LEFT OUTER JOIN I_REVacancyReasonText AS _Text ON REContractVacancyReason = _Text.REContractVacancyReason  -- association [0..*]
;

Learn More