I_RAUnifiedPosting

DDL: I_RAUNIFIEDPOSTING Type: view_entity COMPOSITE
98 Fields 2 Data Sources 1 Associations

Revenue Accounting VDM Union of POSTING Table and ACDOCA

I_RAUnifiedPosting is a Composite CDS View that provides data about "Revenue Accounting VDM Union of POSTING Table and ACDOCA" in SAP S/4HANA. It reads from 2 data sources (I_RevenueAccountingPosting, I_RAJournalEntryItem) and exposes 98 fields with key fields CompanyCode, AccountingPrinciple, RevnAcctgReconciliationKey, PerformanceObligation, RevnAcctgPostingCategory. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_RevenueAccountingPosting _posting from
I_RAJournalEntryItem I_RAJournalEntryItem union_all

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_RevnAcctgReconciliationKey _reconkey _reconkey.RevnAcctgReconciliationKey = _posting.RevnAcctgReconciliationKey and _reconkey.CompanyCode = _posting.CompanyCode and _reconkey.AccountingPrinciple = _posting.AccountingPrinciple and _reconkey.RevenueAccountingContract = _posting.RevenueAccountingContract

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
EndUserText.label Revenue Accounting VDM Union of POSTING Table and ACDOCA view

Fields (98)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_RevenueAccountingPosting CompanyCode Receiver Company Code
KEY AccountingPrinciple I_RevenueAccountingPosting AccountingPrinciple AP Ledger/CoCode
KEY RevnAcctgReconciliationKey I_RevenueAccountingPosting RevnAcctgReconciliationKey Reconcil. Key
KEY PerformanceObligation I_RevenueAccountingPosting PerformanceObligation Performance Obligation
KEY RevnAcctgPostingCategory I_RevenueAccountingPosting RevnAcctgPostingCategory Update to FI
KEY DebitCreditCode I_RevenueAccountingPosting DebitCreditCode Single-Character Flag
KEY ConditionType I_RevenueAccountingPosting ConditionType Condition type
KEY FiscalYear I_RevenueAccountingPosting FiscalYear G/L Fiscal Year
KEY AccountingDocument Journal Entry
KEY GLAccountLineItem Matching Document Line Item
KEY RevnAcctgPostingItemUUID I_RevenueAccountingPosting RevnAcctgPostingItemUUID UUID 22 char.
FiscalPeriod FiscalPeriod Tax period
RevnAcctgPostgAmtInSlsDocCrcy RevnAcctgPostgAmtInSlsDocCrcy Reduction Amt
SalesDocumentCurrency SalesDocumentCurrency Currency
RevnAcctgPostgAmtInCoCodeCrcy RevnAcctgPostgAmtInCoCodeCrcy
CompanyCodeCurrency CompanyCodeCurrency Local Currency
RevnAcctgPostgAmtInAddlCrcy1 RevnAcctgPostgAmtInAddlCrcy1 Second Local Crcy
AdditionalCurrency1 AdditionalCurrency1 Local curr. 2
RevnAcctgPostgAmtInAddlCrcy2 RevnAcctgPostgAmtInAddlCrcy2 Third Local Crcy
AdditionalCurrency2 AdditionalCurrency2 Local curr. 3
RevenueAccountingContract RevenueAccountingContract Revenue Contract
GLAccount GLAccount General Ledger
DeferralItemCatPerCndnType DeferralItemCatPerCndnType Special Indicator
ConditionIsForStatistics ConditionIsForStatistics Statistical
RASndgCompLogicalSystem RASndgCompLogicalSystem Source System
RASndgCompDocumentItemType RASndgCompDocumentItemType SrcItemType
RASndgCompDocumentItem RASndgCompDocumentItem Src. Item ID
RevnAcctgSenderComponent RevnAcctgSenderComponent Sender Component
OrderID OrderID Order ID
SalesOrder SalesOrder SD Document
RevnAcctgRecnclnKeyStatus _reconkey RevnAcctgRecnclnKeyStatus
OriginalReferenceDocumentType Reference Document Type
ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
ReferenceDocumentContext Reference Document Context
ReferenceDocument Reference Document
RAPostingItemLastChgDateTime RAPostingItemLastChgDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
_CompanyCode _CompanyCode
_AccountingPrinciple _AccountingPrinciple
_RAPerformanceObligation _RAPerformanceObligation
_RAPostingCategory _RAPostingCategory
_DebitCreditCode _DebitCreditCode
_RevenueAccountingContract _RevenueAccountingContract
_Currency _Currency
_CompanyCodeCurrency _CompanyCodeCurrency
_AdditionalCurrency1 _AdditionalCurrency1
_AdditionalCurrency2 _AdditionalCurrency2
_FiscalYear _FiscalYear
_GLAccountInCompanyCode _GLAccountInCompanyCode
_Order _Order
KEY AccountingPrinciple AccountingPrinciple AP Ledger/CoCode
KEY RevnAcctgReconciliationKey RevnAcctgReconciliationKey Reconcil. Key
KEY PerformanceObligation PerformanceObligation Performance Obligation
KEY RevnAcctgPostingCategory RevnAcctgPostingCategory Update to FI
KEY DebitCreditCode DebitCreditCode Single-Character Flag
KEY ConditionType ConditionType Condition type
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY GLAccountLineItem GLAccountLineItem Matching Document Line Item
KEY RevnAcctgPostingItemUUID UUID 22 char.
FiscalPeriod FiscalPeriod Tax period
RevnAcctgPostgAmtInSlsDocCrcy RevnAcctgPostgAmtInSlsDocCrcy Reduction Amt
SalesDocumentCurrency SalesDocumentCurrency Currency
RevnAcctgPostgAmtInCoCodeCrcy RevnAcctgPostgAmtInCoCodeCrcy
CompanyCodeCurrency CompanyCodeCurrency Local Currency
RevnAcctgPostgAmtInAddlCrcy1 RevnAcctgPostgAmtInAddlCrcy1 Second Local Crcy
AdditionalCurrency1 AdditionalCurrency1 Local curr. 2
RevnAcctgPostgAmtInAddlCrcy2 RevnAcctgPostgAmtInAddlCrcy2 Third Local Crcy
AdditionalCurrency2 AdditionalCurrency2 Local curr. 3
RevenueAccountingContract RevenueAccountingContract Revenue Contract
GLAccount GLAccount General Ledger
DeferralItemCatPerCndnType DeferralItemCatPerCndnType Special Indicator
ConditionIsForStatistics ConditionIsForStatistics Statistical
RASndgCompLogicalSystem RASndgCompLogicalSystem Source System
RASndgCompDocumentItemType RASndgCompDocumentItemType SrcItemType
RASndgCompDocumentItem RASndgCompDocumentItem Src. Item ID
RevnAcctgSenderComponent RevnAcctgSenderComponent Sender Component
OrderID OrderID Order ID
SalesOrder SalesOrder SD Document
RevnAcctgRecnclnKeyStatus RevnAcctgRecnclnKeyStatus
OriginalReferenceDocumentType OriginalReferenceDocumentType Reference Document Type
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
ReferenceDocumentContext ReferenceDocumentContext Reference Document Context
ReferenceDocument ReferenceDocument Reference Document
RAPostingItemLastChgDateTime RAPostingItemLastChgDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
_CompanyCode _CompanyCode
_AccountingPrinciple _AccountingPrinciple
_RAPerformanceObligation _RAPerformanceObligation
_RAPostingCategory _RAPostingCategory
_DebitCreditCode _DebitCreditCode
_RevenueAccountingContract _RevenueAccountingContract
_Currency _Currency
_CompanyCodeCurrency _CompanyCodeCurrency
_AdditionalCurrency1 _AdditionalCurrency1
_AdditionalCurrency2 _AdditionalCurrency2
_FiscalYear _FiscalYear
_GLAccountInCompanyCode _GLAccountInCompanyCode
_Order _Order
_SalesOrder _SalesOrder

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_RAUnifiedPosting.
-- 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.

CREATE VIEW I_RAUnifiedPosting AS
SELECT
  _posting.CompanyCode AS CompanyCode,
  _posting.AccountingPrinciple AS AccountingPrinciple,
  _posting.RevnAcctgReconciliationKey AS RevnAcctgReconciliationKey,
  _posting.PerformanceObligation AS PerformanceObligation,
  _posting.RevnAcctgPostingCategory AS RevnAcctgPostingCategory,
  _posting.DebitCreditCode AS DebitCreditCode,
  _posting.ConditionType AS ConditionType,
  _posting.FiscalYear AS FiscalYear,
  cast('' as fis_belnr) AS AccountingDocument,
  cast( '' as fis_docln ) AS GLAccountLineItem,
  _posting.RevnAcctgPostingItemUUID AS RevnAcctgPostingItemUUID,
  FiscalPeriod,
  RevnAcctgPostgAmtInSlsDocCrcy,
  SalesDocumentCurrency,
  RevnAcctgPostgAmtInCoCodeCrcy,
  CompanyCodeCurrency,
  RevnAcctgPostgAmtInAddlCrcy1,
  AdditionalCurrency1,
  RevnAcctgPostgAmtInAddlCrcy2,
  AdditionalCurrency2,
  RevenueAccountingContract,
  GLAccount,
  DeferralItemCatPerCndnType,
  ConditionIsForStatistics,
  RASndgCompLogicalSystem,
  RASndgCompDocumentItemType,
  RASndgCompDocumentItem,
  RevnAcctgSenderComponent,
  OrderID,
  SalesOrder,
  _reconkey.RevnAcctgRecnclnKeyStatus AS RevnAcctgRecnclnKeyStatus,
  cast( ' ' as awtyp ) AS OriginalReferenceDocumentType,
  cast( ' ' as awsys ) AS ReferenceDocumentLogicalSystem,
  cast( ' ' as aworg ) AS ReferenceDocumentContext,
  cast( ' ' as awref ) AS ReferenceDocument,
  RAPostingItemLastChgDateTime
FROM I_RevenueAccountingPosting AS _posting
LEFT OUTER JOIN I_RevnAcctgReconciliationKey AS _reconkey ON _reconkey.RevnAcctgReconciliationKey = _posting.RevnAcctgReconciliationKey AND _reconkey.CompanyCode = _posting.CompanyCode AND _reconkey.AccountingPrinciple = _posting.AccountingPrinciple AND _reconkey.RevenueAccountingContract = _posting.RevenueAccountingContract  -- association [1..1]
-- UNION ALL with additional select branch(es): I_RAJournalEntryItem
;

Learn More