I_OrglChangeSettlmtRuleTrace

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_OrglChangeSettlmtRuleTrace.
-- 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_OrglChangeSettlmtRuleTrace AS
SELECT
  objnr AS ControllingObject,
  orgl_change AS OrganizationalChange,
  obart AS ControllingObjectType,
  kokrs AS ControllingArea,
  bukrs AS CompanyCode,
  aufnr AS OrderID,
  cast ( vornr as fis_networkactivity_no_conv preserving type) AS NetworkActivity,
  cast(ps_psp_pnr as ps_s4_pspnr preserving type) AS WBSElementInternalID,
  intreno AS InternalRealEstateNumber,
  cast(recnr as recnvdmcnnr preserving type ) AS RealEstateContract,
  kdauf AS SalesDocument,
  kdpos AS SalesDocumentItem,
  service_doc_type AS ServiceDocumentType,
  service_doc_id AS ServiceDocument,
  service_doc_item_id AS ServiceDocumentItem,
  autyp AS OrderCategory,
  prctr_old AS ProfitCenterBeforeOrglChange,
  prctr_new AS ProfitCenterByOrglChange,
  segment_old AS SegmentBeforeOrglChange,
  segment_new AS SegmentByOrglChange
FROM finoc_settlmt
LEFT OUTER JOIN I_ControllingObject AS _ControllingObject ON ControllingObject = _ControllingObject.ControllingObject  -- association [1..1]
LEFT OUTER JOIN I_OrganizationalChange AS _OrglChange ON OrganizationalChange = _OrglChange.OrganizationalChange  -- association [1..1]
LEFT OUTER JOIN I_ControllingObjectType AS _ControllingObjectType ON ControllingObjectType = _ControllingObjectType.ControllingObjectType  -- association [1..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Order AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesDocumentItem ON SalesDocument = _SalesDocumentItem.SalesDocument AND SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentType AS _ServiceDocumentType ON ServiceDocumentType = _ServiceDocumentType.ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocument AS _ServiceDocument ON ServiceDocumentItem = _ServiceDocument.ServiceDocument AND ServiceDocumentType = _ServiceDocument.ServiceDocumentType  -- association [0..*]
LEFT OUTER JOIN I_ServiceDocumentItem AS _ServiceDocumentItem ON ServiceDocument = _ServiceDocumentItem.ServiceDocument AND ServiceDocumentType = _ServiceDocumentItem.ServiceDocumentType AND ServiceDocumentItem = _ServiceDocumentItem.ServiceDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_OrderCategory AS _OrderCategory ON OrderCategory = _OrderCategory.OrderCategory  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCtr ON ControllingArea = _ProfitCtr.ControllingArea AND ProfitCenterBeforeOrglChange = _ProfitCtr.ProfitCenter AND _ProfitCtr.ValidityEndDate = '99991231'  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCtrNew ON ControllingArea = _ProfitCtrNew.ControllingArea AND ProfitCenterByOrglChange = _ProfitCtrNew.ProfitCenter AND _ProfitCtrNew.ValidityEndDate = '99991231'  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _Segment ON SegmentBeforeOrglChange = _Segment.Segment  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _SegmentNew ON SegmentByOrglChange = _SegmentNew.Segment  -- association [0..1]
;