I_RECostSettlmtClassfctnItem

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_RECostSettlmtClassfctnItem.
-- 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 I_RECostSettlmtClassfctnItem AS
SELECT
  classificationuuid AS RECostSettlmtClassfctnUUID,
  rbukrs AS CompanyCode,
  gjahr AS FiscalYear,
  belnr AS AccountingDocument,
  docln AS LedgerGLLineItem,
  status AS RECostSettlmtClassfctnStatus,
  ignoreitem AS RECostSettlmtItemIsIgnored,
  service_date AS RECostSettlementServiceDate,
  costcategory AS RECostCategory,
  objectuuid_sg AS REServiceGroupUUID,
  objectuuid_go AS REGenericRentalObjectUUID,
  intreno_cn AS REContractIntRealEstateNumber,
  CreationDateTime,
  LastChangeDateTime
FROM vicssettlclfn
LEFT OUTER JOIN I_RECostSettlmtClfnStatus AS _RECostSettlmtClfnStatus ON RECostSettlmtClassfctnStatus = _RECostSettlmtClfnStatus.RECostSettlmtClassfctnStatus  -- association [1..1]
LEFT OUTER JOIN I_REGenericRentalObject AS _REGenericRentalObject ON REGenericRentalObjectUUID = _REGenericRentalObject.REGenericRentalObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_REContract AS _REContract ON REContractIntRealEstateNumber = _REContract.InternalRealEstateNumber  -- association [0..1]
LEFT OUTER JOIN I_REServiceGroup AS _REServiceGroup ON REServiceGroupUUID = _REServiceGroup.REServiceGroupUUID  -- association [0..1]
LEFT OUTER JOIN I_RECostCategory AS _RECostCategory ON RECostCategory = _RECostCategory.RECostCategory  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
;