I_RESettlementUnit

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_RESettlementUnit.
-- 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: IRESETTLUNIT

CREATE VIEW I_RESettlementUnit AS
SELECT
  intreno AS InternalRealEstateNumber,
  bukrs AS CompanyCode,
  cast(swenr as rebdvdmbeno preserving type) AS REBusinessEntity,
  cast(snksl as rescvdmsckey preserving type ) AS REServiceChargeKey,
  cast(sempsl as rescvdmsuid preserving type ) AS RESettlementUnitID,
  objnr AS REStatusObject,
  cast(imkey as recaimkeyfi preserving type) AS REInternalFinNumber,
  creationtype AS RECreationType,
  rerf AS CreatedByUser,
  derf AS CreationDate,
  terf AS CreationTime,
  reher AS RESourceOfCreation,
  rbear AS LastChangedByUser,
  dbear AS LastChangeDate,
  tbear AS LastChangeTime,
  rbher AS RESourceOfChange,
  Responsible,
  userexclusive AS REUserExclusive,
  authgrp AS REAuthorizationGroup,
  cast( validfrom as rebdvdmvalidfrom ) AS ValidityStartDate,
  cast( validto as rebdvdmvalidto ) AS ValidityEndDate,
  xsu AS RESettlementUnitName,
  sutype AS RESettlementUnitType,
  tenancylaw AS RETenancyLaw,
  hascostobject AS RESettlementUnitHasCostObject,
  notaxcorr AS RESettlementUnitHasNoInputTax,
  exchangetype AS REDataExchangeType,
  settladvpay AS REAdvancedPaytSetldByCo,
  perheating AS RERateOfBasicHeatingCostValue,
  perhotwater AS RERateOfHotWaterBasicCostValue,
  msucrossovercc AS REIndepMasterSettlmtIsAllowed,
  _REKeyAssgmt.RealEstateObjectType AS RealEstateObjectType,
  _REKeyAssgmt.REIdentificationKey AS REIdentificationKey
FROM viscsu AS _RESettlementUnit
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _ChangedByUser ON LastChangedByUser = _ChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _ResponsibleUser ON Responsible = _ResponsibleUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_RECreationType AS _RECreationType ON RECreationType = _RECreationType.RECreationType  -- association [0..1]
LEFT OUTER JOIN I_REKeyAssgmt AS _REKeyAssgmt ON InternalRealEstateNumber = _REKeyAssgmt.InternalRealEstateNumber  -- association [1..1]
LEFT OUTER JOIN I_REObjectType AS _REObjectType ON RealEstateObjectType = _REObjectType.RealEstateObjectType  -- association [1..1]
LEFT OUTER JOIN I_REAuthorizationGroup AS _REAuthorizationGroup ON REAuthorizationGroup = _REAuthorizationGroup.REAuthorizationGroup AND RealEstateObjectType = _REAuthorizationGroup.RealEstateObjectType  -- association [0..1]
LEFT OUTER JOIN I_RETenancyLaw AS _RETenancyLaw ON RETenancyLaw = _RETenancyLaw.RETenancyLaw  -- association [0..1]
LEFT OUTER JOIN I_StatusObject AS _StatusObject ON REStatusObject = _StatusObject.StatusObject  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectStatus AS _StatusObjectStatus ON REStatusObject = _StatusObjectStatus.StatusObject  -- association [1..*]
LEFT OUTER JOIN I_REObjectAddress AS _ObjectAddress ON InternalRealEstateNumber = _ObjectAddress.InternalRealEstateNumber  -- association [0..1]
LEFT OUTER JOIN I_REBusinessEntity AS _REBusinessEntity ON CompanyCode = _REBusinessEntity.CompanyCode AND REBusinessEntity = _REBusinessEntity.REBusinessEntity  -- association [1..1]
LEFT OUTER JOIN I_REServiceChargeKey AS _REServiceChargeKey ON REServiceChargeKey = _REServiceChargeKey.REServiceChargeKey  -- association [1..1]
LEFT OUTER JOIN I_REDataExchangeType AS _REDataExchangeType ON REDataExchangeType = _REDataExchangeType.REDataExchangeType  -- association [0..1]
LEFT OUTER JOIN I_REAdvancedPaytSetldByCo AS _REAdvancedPaytSetldByCo ON REAdvancedPaytSetldByCo = _REAdvancedPaytSetldByCo.REAdvancedPaytSetldByCo  -- association [0..1]
LEFT OUTER JOIN I_REPartnerAssgmt AS _REPartnerAssgmt ON InternalRealEstateNumber = _REPartnerAssgmt.InternalRealEstateNumber  -- association [0..*]
LEFT OUTER JOIN I_REOrganizationalAssgmtTerm AS _REOrganizationalAssgmtTerm ON InternalRealEstateNumber = _REOrganizationalAssgmtTerm.InternalRealEstateNumber  -- association [1..*]
LEFT OUTER JOIN I_REReminderObjRule AS _REReminderRule ON InternalRealEstateNumber = _REReminderRule.InternalRealEstateNumber  -- association [0..*]
;