C_REValnMngValuationTP

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 C_REValnMngValuationTP.
-- 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.

CREATE VIEW C_REValnMngValuationTP AS
SELECT
  InternalRealEstateNumber,
  RETermNumber,
  ValidityStartEndDateValue,
  REValuationRuleUUID,
  RETermType,
  RETermName,
  REValuationRule,
  REStatusObject,
  RealEstateObjectType,
  REIdentification,
  virtual REObjectText : recnvdmobjname AS virtualREObjectTextrecnvdmobjname,
  ValidityStartDate,
  ValidityEndDate,
  ObjectValidFrom,
  REConsiderationStartDate,
  RECashFlowPostingFromDate,
  REStatusObjectAsset,
  REInterestRate,
  REProbableEndDate,
  REAssetRightOfUseEndDate,
  REValuationRuleStatus,
  REValuationStatus,
  REValuationStatusReason,
  REValuationBehavior,
  RETaxType,
  TaxGroup AS RETaxGroup,
  REAccountingObject,
  REInfoText,
  REValuationFactorNumerator,
  REValuationFactorDenominator,
  REValuationCurrency,
  REValuationQuestionnaireUUID,
  Country,
  REEntryValidity,
  REEntryValidityCriticality,
  _REContract.REContractType AS REContractType,
  _REContract.CompanyCode AS CompanyCode,
  REAccountingObjectType,
  REAccountingObjIdentification,
  virtual CostCenter : kostl AS virtualCostCenterkostl,
  virtual ControllingArea : kokrs AS virtualControllingAreakokrs,
  virtual WBSElementExternalID : ps_posid_edit AS virtualWBSElementExternalIDps_posid_edit,
  virtual InternalOrder : fins_int_aufnr AS virtualInternalOrderfins_int_aufnr,
  virtual SemanticObject : char40 AS virtualSemanticObjectchar40,
  virtual RealEstateSemanticObject : char40 AS virtualRealEstateSemanticObjectchar40,
  MasterFixedAsset,
  FixedAsset,
  virtual FixedAssetDescription : txa50_anlt AS virtualFixedAssetDescriptiontxa50_anlt,
  virtual REAssetFieldIsHidden : recabool AS virtualREAssetFieldIsHiddenrecabool,
  _Currency._Text.CurrencyName as CurrencyName : localized AS CurrencyNameasCurrencyNamelocalized,
  _REValuationRule.REValuationType AS REValuationType,
  _REContract.RealEstateContract AS RealEstateContract,
  virtual IsDraftEntity : recabool AS virtualIsDraftEntityrecabool,
  virtual REIsReductionFactorHidden : recabool AS virtualREIsReductionFactorHiddenrecabool,
  virtual REValuationStatusCriticality : abap.int1 AS int1,
  virtual NoteUUID : /bobf/conf_key AS virtualNoteUUIDbobfconf_key,
  virtual NoteObject : nte_objectid AS virtualNoteObjectnte_objectid
FROM R_REContrValuationTP
;