I_AstRtrmtOblgnObjectPage

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_AstRtrmtOblgnObjectPage.
-- 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: IAROOBJPG

CREATE VIEW I_AstRtrmtOblgnObjectPage AS
SELECT
  AROItemData.AssetRetirementObligationUUID AS AssetRetirementObligationUUID,
  AROItemData.AssetRetirementOblgnNumber AS AssetRetirementOblgnNumber,
  TransItem.AROTransactionNumber AS AROTransactionNumber,
  AROItemData.CompanyCode AS CompanyCode,
  TransItem.AROTransactionType AS AROTransactionType,
  TransItem.AROTransactionDescription AS AROTransactionDescription,
  TransItem.AssetRetirementOblgnStatus AS AssetRetirementOblgnStatus,
  TransItem.AROTransactionDate AS AROTransactionDate,
  concat( AROItemData.AssetRetirementOblgnNumber,cast(TransItem.AROTransactionNumber as abap.char( 6 ))) AS AROPostingDocumentNumber,
  AROHdrData.AROSetupStartDate AS AROSetupStartDate,
  AROHdrData.AROAssetClass AS AROAssetClass,
  AROHdrData.AROSetupEndDate AS AROSetupEndDate,
  AROHdrData.AROCalculationEndDate AS AROCalculationEndDate,
  AROHdrData.AssetRtrmtOblgnCurrencyKey AS AssetRtrmtOblgnCurrencyKey,
  TransItem.AROEffectiveTransactionDate AS AROEffectiveTransactionDate,
  TransItem.AROTransReleaseDate AS AROTransReleaseDate,
  AROItemData.AROItemDescription AS AROItemDescription,
  TransItem.AROTransactionStatus AS AROTransactionStatus,
  AROObjData.AROObjectType AS AROObjectType,
  AROObjData.AROObjectNumber AS AROObjectNumber,
  AROObjData.AROObjectCreatedByUser AS AROObjectCreatedByUser,
  AROObjData.AROObjectReferenceKey AS AROObjectReferenceKey,
  AROObjData.AROSubObjReferenceKey AS AROSubObjReferenceKey,
  AROItemData.AROLegacyNumber AS AROLegacyNumber,
  _AssetClassTxt[1: Language = $session.system_language ].AssetClassDescription AS AssetClassDescription,
  AssetRetirementObligationType,
  CEPHeaderData.AROCostEstnPlanNumber AS AROCostEstnPlanNumber,
  _AstRtrmtOblgnAssetData.MasterFixedAsset AS MasterFixedAsset,
  _AstRtrmtOblgnAssetData.FixedAsset AS FixedAsset
FROM I_AROLineItemData AS AROItemData
INNER JOIN I_AROTransactionLineItemData AS TransItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_AssetRtrmtOblgnHdrData AS AROHdrData ON /* join condition not captured in parsed metadata */
INNER JOIN I_AROObjectsHeaderData AS AROObjData ON /* join condition not captured in parsed metadata */
INNER JOIN I_AROCostEstnPlanHeaderData AS CEPHeaderData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AstRtrmtOblgnAssetClassText AS _AssetClassTxt ON AROAssetClass = _AssetClassTxt.AssetClass  -- association [1..*]
LEFT OUTER JOIN I_AssetRtrmtOblgnStatusText AS _AssetRtrmtOblgnStatusText ON AssetRetirementOblgnStatus = _AssetRtrmtOblgnStatusText.AssetRetirementOblgnStatus  -- association [0..*]
LEFT OUTER JOIN I_AstRtrmtOblgnAssetData AS _AstRtrmtOblgnAssetData ON AssetRetirementOblgnNumber = _AstRtrmtOblgnAssetData.AssetRetirementOblgnNumber AND AssetRetirementObligationUUID = _AstRtrmtOblgnAssetData.AssetRetirementObligationUUID  -- association [0..*]
;