I_AstRtrmtOblgnObjectPage

DDL: I_ASTRTRMTOBLGNOBJECTPAGE SQL: IAROOBJPG Type: view COMPOSITE
32 Fields 5 Data Sources 3 Associations

Main ARO Object Page

I_AstRtrmtOblgnObjectPage is a Composite CDS View that provides data about "Main ARO Object Page" in SAP S/4HANA. It reads from 5 data sources (I_AssetRtrmtOblgnHdrData, I_AROLineItemData, I_AROObjectsHeaderData, I_AROCostEstnPlanHeaderData, I_AROTransactionLineItemData) and exposes 32 fields with key fields AssetRetirementObligationUUID, AssetRetirementOblgnNumber, AROTransactionNumber. It has 3 associations to related views.

Data Sources (5)

SourceAliasJoin Type
I_AssetRtrmtOblgnHdrData AROHdrData inner
I_AROLineItemData AROItemData from
I_AROObjectsHeaderData AROObjData inner
I_AROCostEstnPlanHeaderData CEPHeaderData inner
I_AROTransactionLineItemData TransItem inner

Associations (3)

CardinalityTargetAliasCondition
[1..*] I_AstRtrmtOblgnAssetClassText _AssetClassTxt $projection.AROAssetClass = _AssetClassTxt.AssetClass
[0..*] I_AssetRtrmtOblgnStatusText _AssetRtrmtOblgnStatusText $projection.AssetRetirementOblgnStatus = _AssetRtrmtOblgnStatusText.AssetRetirementOblgnStatus
[0..*] I_AstRtrmtOblgnAssetData _AstRtrmtOblgnAssetData $projection.AssetRetirementOblgnNumber = _AstRtrmtOblgnAssetData.AssetRetirementOblgnNumber and $projection.AssetRetirementObligationUUID = _AstRtrmtOblgnAssetData.AssetRetirementObligationUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IAROOBJPG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Main ARO Object Page view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY AssetRetirementObligationUUID I_AROLineItemData AssetRetirementObligationUUID Obl. GUID
KEY AssetRetirementOblgnNumber I_AROLineItemData AssetRetirementOblgnNumber Obligation No.
KEY AROTransactionNumber I_AROTransactionLineItemData AROTransactionNumber Transaction No.
CompanyCode I_AROLineItemData CompanyCode Receiver Company Code
AROTransactionType I_AROTransactionLineItemData AROTransactionType Trans.Type
AROTransactionDescription I_AROTransactionLineItemData AROTransactionDescription Trans.Desc.
AssetRetirementOblgnStatus I_AROTransactionLineItemData AssetRetirementOblgnStatus Workflow Status
AROTransactionDate I_AROTransactionLineItemData AROTransactionDate Transact. Date
AROPostingDocumentNumber
AROSetupStartDate I_AssetRtrmtOblgnHdrData AROSetupStartDate ARO Setup Date
AROAssetClass I_AssetRtrmtOblgnHdrData AROAssetClass ARO Asset Class
AROSetupEndDate I_AssetRtrmtOblgnHdrData AROSetupEndDate ARO End Date
AROCalculationEndDate I_AssetRtrmtOblgnHdrData AROCalculationEndDate ARO 1st End
AssetRtrmtOblgnCurrencyKey I_AssetRtrmtOblgnHdrData AssetRtrmtOblgnCurrencyKey Valuation Crcy
AROEffectiveTransactionDate I_AROTransactionLineItemData AROEffectiveTransactionDate Proc. Key Date
AROTransReleaseDate I_AROTransactionLineItemData AROTransReleaseDate Released On
AROItemDescription I_AROLineItemData AROItemDescription Obl. Desc.
AROTransactionStatus I_AROTransactionLineItemData AROTransactionStatus Trans.Stat.
AROObjectType I_AROObjectsHeaderData AROObjectType Object Type
AROObjectNumber I_AROObjectsHeaderData AROObjectNumber Obligation No.
AROObjectCreatedByUser I_AROObjectsHeaderData AROObjectCreatedByUser Employee
AROObjectReferenceKey I_AROObjectsHeaderData AROObjectReferenceKey Source Reference Key
AROSubObjReferenceKey I_AROObjectsHeaderData AROSubObjReferenceKey Ext Ref of Subobject
AROLegacyNumber I_AROLineItemData AROLegacyNumber Legacy Obligation
AssetClassDescription
AssetRetirementObligationType AssetRetirementObligationType Obl. Type
AROCostEstnPlanNumber I_AROCostEstnPlanHeaderData AROCostEstnPlanNumber CEP Number
MasterFixedAsset _AstRtrmtOblgnAssetData MasterFixedAsset Fixed Asset
FixedAsset _AstRtrmtOblgnAssetData FixedAsset Sub-number
_AstRtrmtOblgnAssetData _AstRtrmtOblgnAssetData
_AssetRtrmtOblgnStatusText _AssetRtrmtOblgnStatusText
_AssetClassTxt _AssetClassTxt

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..*]
;

Learn More