C_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 C_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: CAROOBJPG

CREATE VIEW C_AstRtrmtOblgnObjectPage AS
SELECT
  AssetRetirementObligationUUID,
  AssetRetirementOblgnNumber,
  AROTransactionNumber,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  AROLegacyNumber,
  AROTransactionDescription,
  AROTransactionStatus,
  _AstRtrmtOblgnTransStatusText.AROTransactionStatusText AS AROTransactionStatusText,
  AROPostingDocumentNumber,
  AROObjectReferenceKey,
  AROSetupStartDate,
  AROEffectiveTransactionDate,
  AROItemDescription,
  AROSetupEndDate,
  AROTransReleaseDate,
  AROCalculationEndDate,
  AssetRtrmtOblgnCurrencyKey,
  AssetClassDescription,
  MasterFixedAsset,
  _MasterFixedAsset.MasterFixedAssetDescription AS MasterFixedAssetDescription,
  FixedAsset,
  cast(_FixedAsset.FixedAssetDescription as fis_txa50_anlt) AS FixedAssetDescription,
  AROCostEstnPlanNumber,
  AssetRetirementOblgnStatus,
  AROTransactionDate,
  AssetRetirementObligationType
FROM I_AstRtrmtOblgnObjectPage
LEFT OUTER JOIN I_AstRtrmtOblgnTransStatusText AS _AstRtrmtOblgnTransStatusText ON AROTransactionStatus = _AstRtrmtOblgnTransStatusText.AROTransactionStatus  -- association [0..*]
LEFT OUTER JOIN C_AstRtrmtOblgnCashFlowData AS _AstRtrmtOblgnCashFlowData ON AssetRetirementObligationUUID = _AstRtrmtOblgnCashFlowData.AssetRetirementObligationUUID AND AROTransactionNumber = _AstRtrmtOblgnCashFlowData.AROTransactionNumber  -- association [0..*]
LEFT OUTER JOIN C_AstRtrmtOblgnOneTmePostgData AS _AstRtrmtOblgnOneTmePostgData ON AssetRetirementObligationUUID = _AstRtrmtOblgnOneTmePostgData.AssetRetirementObligationUUID  -- association [0..*]
LEFT OUTER JOIN C_AstRtrmtOblgnAccrualData AS _AstRtrmtOblgnAccrualData ON AssetRetirementObligationUUID = _AstRtrmtOblgnAccrualData.AssetRetirementObligationUUID AND AROObjectReferenceKey = _AstRtrmtOblgnAccrualData.AROObjectReferenceKey AND AROTransactionDate = _AstRtrmtOblgnAccrualData.AROAssetLifeStartDate  -- association [0..*]
LEFT OUTER JOIN C_AstRtrmtOblgnCompanyCodeVH AS _AstRtrmtOblgnCompanyCodeVH ON CompanyCode = _AstRtrmtOblgnCompanyCodeVH.CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_AssetRtrmtOblgnNumberVH AS _AssetRtrmtOblgnNumberVH ON AssetRetirementOblgnNumber = _AssetRtrmtOblgnNumberVH.AssetRetirementOblgnNumber  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [0..1]
;