I_REValuationObjControlParam

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_REValuationObjControlParam.
-- 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: IREVALOBJCONPAR

CREATE VIEW I_REValuationObjControlParam AS
SELECT
  bukrs AS CompanyCode,
  objtype AS RealEstateObjectType,
  objtypediff AS REObjectTypeDiffntn,
  recntype AS REContractType,
  anlkl AS REAssetClass1,
  anlklb AS REAssetClass2,
  accdetkey AS REAcctDeterminationKey,
  _AssetClass1._Text[1: Language = $session.system_language ].AssetClassName AS REAssetClass1Name,
  _AssetClass2._Text[1: Language = $session.system_language ].AssetClassName AS REAssetClass2Name
FROM tivceassetdif AS _REValuationObjControlParam
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_REObjectType AS _REObjectType ON RealEstateObjectType = _REObjectType.RealEstateObjectType  -- association [1..1]
LEFT OUTER JOIN I_REContractType AS _REContractType ON REContractType = _REContractType.REContractType  -- association [1..1]
LEFT OUTER JOIN I_AssetClass AS _AssetClass1 ON REAssetClass1 = _AssetClass1.AssetClass  -- association [1..1]
LEFT OUTER JOIN I_AssetClass AS _AssetClass2 ON REAssetClass2 = _AssetClass2.AssetClass  -- association [1..1]
;