I_AstRtrmtOblgnOneTmePostgData

DDL: I_ASTRTRMTOBLGNONETMEPOSTGDATA SQL: IAROACDDATA Type: view COMPOSITE
19 Fields 3 Data Sources

One Time Posting Data for ARO

I_AstRtrmtOblgnOneTmePostgData is a Composite CDS View that provides data about "One Time Posting Data for ARO" in SAP S/4HANA. It reads from 3 data sources (I_AROAcctDocHeaderData, I_AROAcctPostingLineItemData, I_AROLineItemData) and exposes 19 fields with key fields CompanyCode, FiscalYear, AccountingDocument, AssetRetirementObligationUUID.

Data Sources (3)

SourceAliasJoin Type
I_AROAcctDocHeaderData AROAcctHeader inner
I_AROAcctPostingLineItemData AROAcctPosting from
I_AROLineItemData AROLineItem inner

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IAROACDDATA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label One Time Posting Data for ARO view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_AROAcctPostingLineItemData CompanyCode Receiver Company Code
KEY FiscalYear I_AROAcctPostingLineItemData FiscalYear G/L Fiscal Year
KEY AccountingDocument I_AROAcctPostingLineItemData AccountingDocument Journal Entry
KEY AssetRetirementObligationUUID I_AROLineItemData AssetRetirementObligationUUID Obl. GUID
AssetRetirementOblgnNumber I_AROLineItemData AssetRetirementOblgnNumber Obligation No.
SourceLedger I_AROAcctPostingLineItemData SourceLedger Source Ledger
FiscalYearVariant I_AROAcctPostingLineItemData FiscalYearVariant FY Variant
AROPostingDocumentDate I_AROAcctPostingLineItemData AROPostingDocumentDate Posting Date
PostingPeriod I_AROAcctPostingLineItemData PostingPeriod Posting Period
AROPostingPeriodAmount I_AROAcctPostingLineItemData AROPostingPeriodAmount OrigTrnsCrcyAmt
AmountInCompanyCodeCurrency I_AROAcctPostingLineItemData AmountInCompanyCodeCurrency Local Crcy Amt
AROPostingItemText I_AROAcctPostingLineItemData AROPostingItemText Text
AROPostingObjectKey I_AROAcctDocHeaderData AROPostingObjectKey
AROPostingDocumentNumber I_AROAcctDocHeaderData AROPostingDocumentNumber
AROTransactionNumber
AROAccountingPrinciple I_AROAcctDocHeaderData AROAccountingPrinciple
AssetRetirementObligationType I_AROLineItemData AssetRetirementObligationType Obl. Type
AROTransactionCurrency I_AROAcctPostingLineItemData AROTransactionCurrency Transaction Currency
CompanyCodeCurrency I_AROAcctPostingLineItemData CompanyCodeCurrency Local Currency

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_AstRtrmtOblgnOneTmePostgData.
-- 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: IAROACDDATA

CREATE VIEW I_AstRtrmtOblgnOneTmePostgData AS
SELECT
  AROAcctPosting.CompanyCode AS CompanyCode,
  AROAcctPosting.FiscalYear AS FiscalYear,
  AROAcctPosting.AccountingDocument AS AccountingDocument,
  AROLineItem.AssetRetirementObligationUUID AS AssetRetirementObligationUUID,
  AROLineItem.AssetRetirementOblgnNumber AS AssetRetirementOblgnNumber,
  AROAcctPosting.SourceLedger AS SourceLedger,
  AROAcctPosting.FiscalYearVariant AS FiscalYearVariant,
  AROAcctPosting.AROPostingDocumentDate AS AROPostingDocumentDate,
  AROAcctPosting.PostingPeriod AS PostingPeriod,
  AROAcctPosting.AROPostingPeriodAmount AS AROPostingPeriodAmount,
  AROAcctPosting.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  AROAcctPosting.AROPostingItemText AS AROPostingItemText,
  AROAcctHeader.AROPostingObjectKey AS AROPostingObjectKey,
  AROAcctHeader.AROPostingDocumentNumber AS AROPostingDocumentNumber,
  cast( right(AROAcctHeader.AROPostingDocumentNumber,3) as aro_ta_num) AS AROTransactionNumber,
  AROAcctHeader.AROAccountingPrinciple AS AROAccountingPrinciple,
  AROLineItem.AssetRetirementObligationType AS AssetRetirementObligationType,
  AROAcctPosting.AROTransactionCurrency AS AROTransactionCurrency,
  AROAcctPosting.CompanyCodeCurrency AS CompanyCodeCurrency
FROM I_AROAcctPostingLineItemData AS AROAcctPosting
INNER JOIN I_AROAcctDocHeaderData AS AROAcctHeader ON /* join condition not captured in parsed metadata */
INNER JOIN I_AROLineItemData AS AROLineItem ON /* join condition not captured in parsed metadata */
;

Learn More