ARO_DDL_OneTmePostgAmt_Subproc

DDL: ARO_DDL_ONETMEPOSTGAMT_SUBPROC SQL: IAROOTPSBPRC Type: view Package: ARO_GENERAL
29 Fields 3 Data Sources

One time posting amt with Sub Processes

ARO_DDL_OneTmePostgAmt_Subproc is a CDS View that provides data about "One time posting amt with Sub Processes" in SAP S/4HANA. It reads from 3 data sources (I_AROAcctgPrincipleHdrData, I_AROTransactionLineItemData, I_AstRtrmtOblgnOneTmePostgData) and exposes 29 fields with key fields CompanyCode, FiscalYear, AccountingDocument, AssetRetirementObligationUUID, AROTransactionNumber. Part of development package ARO_GENERAL.

Data Sources (3)

SourceAliasJoin Type
I_AROAcctgPrincipleHdrData _AROAcctgPrincipleHdrData inner
I_AROTransactionLineItemData _AROTransactionLineItemData inner
I_AstRtrmtOblgnOneTmePostgData _AstRtrmtOblgnOneTmePostgData from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IAROOTPSBPRC view
AbapCatalog.compiler.compareFilter true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label One time posting amt with Sub Processes view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_AstRtrmtOblgnOneTmePostgData CompanyCode Receiver Company Code
KEY FiscalYear I_AstRtrmtOblgnOneTmePostgData FiscalYear G/L Fiscal Year
KEY AccountingDocument I_AstRtrmtOblgnOneTmePostgData AccountingDocument Journal Entry
KEY AssetRetirementObligationUUID I_AstRtrmtOblgnOneTmePostgData AssetRetirementObligationUUID Obl. GUID
KEY AROTransactionNumber I_AROTransactionLineItemData AROTransactionNumber Transaction No.
AssetRetirementOblgnNumber I_AstRtrmtOblgnOneTmePostgData AssetRetirementOblgnNumber
AROTransactionType I_AROTransactionLineItemData AROTransactionType Trans.Type
AROTransactionStatus I_AROTransactionLineItemData AROTransactionStatus Trans.Stat.
AROTransactionDate I_AROTransactionLineItemData AROTransactionDate Transact. Date
AROTransactionDescription I_AROTransactionLineItemData AROTransactionDescription Trans.Desc.
AssetRetirementOblgnStatus I_AROTransactionLineItemData AssetRetirementOblgnStatus Workflow Status
AROTransReleaseDate I_AROTransactionLineItemData AROTransReleaseDate Released On
AROTransReverseDate I_AROTransactionLineItemData AROTransReverseDate Reverse Date
AROCostEstimationPlanUUID I_AROTransactionLineItemData AROCostEstimationPlanUUID Cost Est. Plan GUID
AROEffectiveTransactionDate I_AROTransactionLineItemData AROEffectiveTransactionDate Proc. Key Date
SourceLedger I_AstRtrmtOblgnOneTmePostgData SourceLedger Source Ledger
FiscalYearVariant I_AstRtrmtOblgnOneTmePostgData FiscalYearVariant FY Variant
AROPostingDocumentDate I_AstRtrmtOblgnOneTmePostgData AROPostingDocumentDate
PostingPeriod I_AstRtrmtOblgnOneTmePostgData PostingPeriod Posting Period
AROPostingPeriodAmount I_AstRtrmtOblgnOneTmePostgData AROPostingPeriodAmount
AmountInCompanyCodeCurrency I_AstRtrmtOblgnOneTmePostgData AmountInCompanyCodeCurrency Local Crcy Amt
AROPostingItemText I_AstRtrmtOblgnOneTmePostgData AROPostingItemText
AROPostingObjectKey I_AstRtrmtOblgnOneTmePostgData AROPostingObjectKey
AROPostingDocumentNumber I_AstRtrmtOblgnOneTmePostgData AROPostingDocumentNumber
AROAccountingPrinciple I_AstRtrmtOblgnOneTmePostgData AROAccountingPrinciple Accounting Principle
AROAccountingPrincipleUUID I_AROAcctgPrincipleHdrData AROAccountingPrincipleUUID AP GUID
AssetRetirementObligationType I_AstRtrmtOblgnOneTmePostgData AssetRetirementObligationType
AROTransactionCurrency I_AstRtrmtOblgnOneTmePostgData AROTransactionCurrency
CompanyCodeCurrency I_AstRtrmtOblgnOneTmePostgData 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 ARO_DDL_OneTmePostgAmt_Subproc.
-- 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: IAROOTPSBPRC

CREATE VIEW ARO_DDL_OneTmePostgAmt_Subproc AS
SELECT
  _AstRtrmtOblgnOneTmePostgData.CompanyCode AS CompanyCode,
  _AstRtrmtOblgnOneTmePostgData.FiscalYear AS FiscalYear,
  _AstRtrmtOblgnOneTmePostgData.AccountingDocument AS AccountingDocument,
  _AstRtrmtOblgnOneTmePostgData.AssetRetirementObligationUUID AS AssetRetirementObligationUUID,
  _AROTransactionLineItemData.AROTransactionNumber AS AROTransactionNumber,
  _AstRtrmtOblgnOneTmePostgData.AssetRetirementOblgnNumber AS AssetRetirementOblgnNumber,
  _AROTransactionLineItemData.AROTransactionType AS AROTransactionType,
  _AROTransactionLineItemData.AROTransactionStatus AS AROTransactionStatus,
  _AROTransactionLineItemData.AROTransactionDate AS AROTransactionDate,
  _AROTransactionLineItemData.AROTransactionDescription AS AROTransactionDescription,
  _AROTransactionLineItemData.AssetRetirementOblgnStatus AS AssetRetirementOblgnStatus,
  _AROTransactionLineItemData.AROTransReleaseDate AS AROTransReleaseDate,
  _AROTransactionLineItemData.AROTransReverseDate AS AROTransReverseDate,
  _AROTransactionLineItemData.AROCostEstimationPlanUUID AS AROCostEstimationPlanUUID,
  _AROTransactionLineItemData.AROEffectiveTransactionDate AS AROEffectiveTransactionDate,
  _AstRtrmtOblgnOneTmePostgData.SourceLedger AS SourceLedger,
  _AstRtrmtOblgnOneTmePostgData.FiscalYearVariant AS FiscalYearVariant,
  _AstRtrmtOblgnOneTmePostgData.AROPostingDocumentDate AS AROPostingDocumentDate,
  _AstRtrmtOblgnOneTmePostgData.PostingPeriod AS PostingPeriod,
  _AstRtrmtOblgnOneTmePostgData.AROPostingPeriodAmount AS AROPostingPeriodAmount,
  _AstRtrmtOblgnOneTmePostgData.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  _AstRtrmtOblgnOneTmePostgData.AROPostingItemText AS AROPostingItemText,
  _AstRtrmtOblgnOneTmePostgData.AROPostingObjectKey AS AROPostingObjectKey,
  _AstRtrmtOblgnOneTmePostgData.AROPostingDocumentNumber AS AROPostingDocumentNumber,
  _AstRtrmtOblgnOneTmePostgData.AROAccountingPrinciple AS AROAccountingPrinciple,
  _AROAcctgPrincipleHdrData.AROAccountingPrincipleUUID AS AROAccountingPrincipleUUID,
  _AstRtrmtOblgnOneTmePostgData.AssetRetirementObligationType AS AssetRetirementObligationType,
  _AstRtrmtOblgnOneTmePostgData.AROTransactionCurrency AS AROTransactionCurrency,
  _AstRtrmtOblgnOneTmePostgData.CompanyCodeCurrency AS CompanyCodeCurrency
FROM I_AstRtrmtOblgnOneTmePostgData AS _AstRtrmtOblgnOneTmePostgData
INNER JOIN I_AROTransactionLineItemData AS _AROTransactionLineItemData ON /* join condition not captured in parsed metadata */
INNER JOIN I_AROAcctgPrincipleHdrData AS _AROAcctgPrincipleHdrData ON /* join condition not captured in parsed metadata */
;

Learn More