I_AstRtrmtOblgnCashFlowData

DDL: I_ASTRTRMTOBLGNCASHFLOWDATA SQL: IAROCASHFLOW Type: view BASIC Package: ARO_UI_ODATA
16 Fields 3 Data Sources

Cash Flow details for ARO

I_AstRtrmtOblgnCashFlowData is a Basic CDS View that provides data about "Cash Flow details for ARO" in SAP S/4HANA. It reads from 3 data sources (I_AROAcctgPrincipleHdrData, I_AROCashFlowLineItemData, I_AROLineItemData) and exposes 16 fields with key fields AROAccountingPrincipleUUID, AssetRetirementObligationUUID, AROTransactionNumber, AROCashFlowPeriodNumber. Part of development package ARO_UI_ODATA.

Data Sources (3)

SourceAliasJoin Type
I_AROAcctgPrincipleHdrData AROAPHdraData from
I_AROCashFlowLineItemData AROCashFlowLineItem inner
I_AROLineItemData AROLineItem inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IAROCASHFLOW view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Cash Flow details for ARO view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY AROAccountingPrincipleUUID I_AROAcctgPrincipleHdrData AROAccountingPrincipleUUID AP GUID
KEY AssetRetirementObligationUUID I_AROLineItemData AssetRetirementObligationUUID Obl. GUID
KEY AROTransactionNumber I_AROCashFlowLineItemData AROTransactionNumber Transaction No.
KEY AROCashFlowPeriodNumber I_AROCashFlowLineItemData AROCashFlowPeriodNumber Period No.
AROAccountingPrinciple I_AROAcctgPrincipleHdrData AROAccountingPrinciple Accounting Principle
CompanyCode I_AROLineItemData CompanyCode Receiver Company Code
AssetRetirementOblgnNumber I_AROLineItemData AssetRetirementOblgnNumber Obligation No.
AROPeriodStartDate I_AROCashFlowLineItemData AROPeriodStartDate Period Start
AROPeriodEndDate I_AROCashFlowLineItemData AROPeriodEndDate To Period
AssetRtrmtOblgnCurrencyKey I_AROCashFlowLineItemData AssetRtrmtOblgnCurrencyKey Valuation Crcy
AROStartPeriodProvisionAmount I_AROCashFlowLineItemData AROStartPeriodProvisionAmount Provision SOP
AROCostPeriodInterestAmount I_AROCashFlowLineItemData AROCostPeriodInterestAmount Int.Cost (Per.)
AROEndPeriodProvisionAmount I_AROCashFlowLineItemData AROEndPeriodProvisionAmount Provision EOP
AROInterestCostStrtOfPerdAmt I_AROCashFlowLineItemData AROInterestCostStrtOfPerdAmt Int.Cost SOP
AROBalTransCrcyAmt
AssetRetirementObligationType AssetRetirementObligationType Obl. Type

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_AstRtrmtOblgnCashFlowData.
-- 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: IAROCASHFLOW

CREATE VIEW I_AstRtrmtOblgnCashFlowData AS
SELECT
  AROAPHdraData.AROAccountingPrincipleUUID AS AROAccountingPrincipleUUID,
  AROLineItem.AssetRetirementObligationUUID AS AssetRetirementObligationUUID,
  AROCashFlowLineItem.AROTransactionNumber AS AROTransactionNumber,
  AROCashFlowLineItem.AROCashFlowPeriodNumber AS AROCashFlowPeriodNumber,
  AROAPHdraData.AROAccountingPrinciple AS AROAccountingPrinciple,
  AROLineItem.CompanyCode AS CompanyCode,
  AROLineItem.AssetRetirementOblgnNumber AS AssetRetirementOblgnNumber,
  AROCashFlowLineItem.AROPeriodStartDate AS AROPeriodStartDate,
  AROCashFlowLineItem.AROPeriodEndDate AS AROPeriodEndDate,
  AROCashFlowLineItem.AssetRtrmtOblgnCurrencyKey AS AssetRtrmtOblgnCurrencyKey,
  AROCashFlowLineItem.AROStartPeriodProvisionAmount AS AROStartPeriodProvisionAmount,
  AROCashFlowLineItem.AROCostPeriodInterestAmount AS AROCostPeriodInterestAmount,
  AROCashFlowLineItem.AROEndPeriodProvisionAmount AS AROEndPeriodProvisionAmount,
  AROCashFlowLineItem.AROInterestCostStrtOfPerdAmt AS AROInterestCostStrtOfPerdAmt,
  (AROInterestCostStrtOfPerdAmt + AROCostPeriodInterestAmount) AS AROBalTransCrcyAmt,
  AssetRetirementObligationType
FROM I_AROAcctgPrincipleHdrData AS AROAPHdraData
INNER JOIN I_AROLineItemData AS AROLineItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_AROCashFlowLineItemData AS AROCashFlowLineItem ON /* join condition not captured in parsed metadata */
;

Learn More