P_RAPostingItemWthRecgdAmt

DDL: P_RAPOSTINGITEMWTHRECGDAMT Type: view_entity COMPOSITE
131 Fields 2 Data Sources 2 Associations

P_RAPostingItemWthRecgdAmt is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_RAJournalEntryItem, I_RevenueAccountingPosting) and exposes 131 fields with key fields CompanyCode, AccountingPrinciple, RevnAcctgReconciliationKey, PerformanceObligation, ConditionType. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_RAJournalEntryItem RADirectPosting union_all
I_RevenueAccountingPosting RevenueAccountingPosting from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_RAReconciliationKeyStatus _RAReconciliationKeyStatus $projection.revnacctgrecnclnkeystatus = _RAReconciliationKeyStatus.RevnAcctgRecnclnKeyStatus
[1..1] I_RevnAcctgReconciliationKey _RevnAcctgReconciliationKey $projection.CompanyCode = _RevnAcctgReconciliationKey.CompanyCode and $projection.AccountingPrinciple = _RevnAcctgReconciliationKey.AccountingPrinciple and $projection.RevenueAccountingContract = _RevnAcctgReconciliationKey.RevenueAccountingContract and $projection.RevnAcctgReconciliationKey = _RevnAcctgReconciliationKey.RevnAcctgReconciliationKey

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (131)

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 ConditionType I_RevenueAccountingPosting ConditionType Condition type
KEY RevnAcctgPostingCategory I_RevenueAccountingPosting RevnAcctgPostingCategory Update to FI
KEY DebitCreditCode I_RevenueAccountingPosting DebitCreditCode Single-Character Flag
KEY RevenueAccountingContract I_RevenueAccountingPosting RevenueAccountingContract Revenue Contract
KEY AccountingDocument Journal Entry
KEY GLAccountLineItem Matching Document Line Item
KEY RevnAcctgPostingItemUUID I_RevenueAccountingPosting RevnAcctgPostingItemUUID UUID 22 char.
FiscalYear I_RevenueAccountingPosting FiscalYear G/L Fiscal Year
FiscalPeriod Tax period
FiscalYearPeriod I_RevenueAccountingPosting FiscalYearPeriod Period/Year
Segment I_RevenueAccountingPosting Segment Segment number
GLAccount I_RevenueAccountingPosting GLAccount General Ledger
FunctionalArea I_RevenueAccountingPosting FunctionalArea Sendr Fctl Area
BusinessArea I_RevenueAccountingPosting BusinessArea Business Area
ProfitCenter I_RevenueAccountingPosting ProfitCenter Profit Center
CostCenter I_RevenueAccountingPosting CostCenter Cost Center
OrderID I_RevenueAccountingPosting OrderID Order ID
SalesOrder I_RevenueAccountingPosting SalesOrder SD Document
WBSElementExternalID I_RevenueAccountingPosting WBSElementExternalID WBS Element External ID
RevnAcctgContractCreationDate
BusinessPartner
Customer
PerfOblgnFulfillmentType
RAPerformanceObligationType
RevnAcctgSalesOrganization
RevnAcctgPostgAmtInCoCodeCrcy I_RevenueAccountingPosting RevnAcctgPostgAmtInCoCodeCrcy
CompanyCodeCurrency I_RevenueAccountingPosting CompanyCodeCurrency Local Currency
RevnAcctgPostgAmtInSlsDocCrcy I_RevenueAccountingPosting RevnAcctgPostgAmtInSlsDocCrcy Reduction Amt
SalesDocumentCurrency I_RevenueAccountingPosting SalesDocumentCurrency Currency
RevnAcctgPostgAmtInAddlCrcy1 I_RevenueAccountingPosting RevnAcctgPostgAmtInAddlCrcy1 Second Local Crcy
AdditionalCurrency1 I_RevenueAccountingPosting AdditionalCurrency1 Local curr. 2
RevnAcctgPostgAmtInAddlCrcy2 I_RevenueAccountingPosting RevnAcctgPostgAmtInAddlCrcy2 Third Local Crcy
AdditionalCurrency2 I_RevenueAccountingPosting AdditionalCurrency2 Local curr. 3
ConditionIsForStatistics I_RevenueAccountingPosting ConditionIsForStatistics Statistical
RevnAcctgRecnclnKeyStatus
ControllingArea I_RevenueAccountingPosting ControllingArea Controlling Area
_CompanyCode I_RevenueAccountingPosting _CompanyCode
_AccountingPrinciple I_RevenueAccountingPosting _AccountingPrinciple
_RevenueAccountingContract I_RevenueAccountingPosting _RevenueAccountingContract
_ProfitCenter I_RevenueAccountingPosting _ProfitCenter
_CurrentProfitCenter I_RevenueAccountingPosting _CurrentProfitCenter
_ControllingArea I_RevenueAccountingPosting _ControllingArea
_Segment I_RevenueAccountingPosting _Segment
_CostCenter I_RevenueAccountingPosting _CostCenter
_CurrentCostCenter I_RevenueAccountingPosting _CurrentCostCenter
_WBSElement I_RevenueAccountingPosting _WBSElement
_Currency I_RevenueAccountingPosting _Currency
_CompanyCodeCurrency I_RevenueAccountingPosting _CompanyCodeCurrency
_RevnAcctgReconciliationKey _RevnAcctgReconciliationKey
_RAPerformanceObligation _RAPerformanceObligation
_FiscalYear _FiscalYear
_GLAccountInCompanyCode _GLAccountInCompanyCode
_BusinessArea _BusinessArea
_FunctionalArea _FunctionalArea
_Order _Order
_SalesOrder _SalesOrder
_RAPostingCategory _RAPostingCategory
_DebitCreditCode _DebitCreditCode
_RAReconciliationKeyStatus _RAReconciliationKeyStatus
_BusinessPartner _RAPerformanceObligation _BusinessPartner
_Customer _RAPerformanceObligation _Customer
CompanyCode Receiver Company Code
KEY AccountingPrinciple I_RAJournalEntryItem AccountingPrinciple AP Ledger/CoCode
KEY RevnAcctgReconciliationKey I_RAJournalEntryItem RevnAcctgReconciliationKey Reconcil. Key
KEY PerformanceObligation I_RAJournalEntryItem PerformanceObligation Performance Obligation
KEY ConditionType I_RAJournalEntryItem ConditionType Condition type
KEY RevnAcctgPostingCategory I_RAJournalEntryItem RevnAcctgPostingCategory Update to FI
KEY DebitCreditCode I_RAJournalEntryItem DebitCreditCode Single-Character Flag
KEY RevenueAccountingContract I_RAJournalEntryItem RevenueAccountingContract Revenue Contract
KEY AccountingDocument AccountingDocument Journal Entry
KEY GLAccountLineItem GLAccountLineItem Matching Document Line Item
KEY RevnAcctgPostingItemUUID UUID 22 char.
FiscalYear I_RAJournalEntryItem FiscalYear G/L Fiscal Year
FiscalPeriod I_RAJournalEntryItem FiscalPeriod Tax period
FiscalYearPeriod I_RAJournalEntryItem FiscalYearPeriod Period/Year
Segment I_RAJournalEntryItem Segment Segment number
GLAccount I_RAJournalEntryItem GLAccount General Ledger
FunctionalArea I_RAJournalEntryItem FunctionalArea Sendr Fctl Area
BusinessArea I_RAJournalEntryItem BusinessArea Business Area
ProfitCenter I_RAJournalEntryItem ProfitCenter Profit Center
CostCenter I_RAJournalEntryItem CostCenter Cost Center
OrderID I_RAJournalEntryItem OrderID Order ID
SalesOrder I_RAJournalEntryItem SalesOrder SD Document
WBSElementExternalID I_RAJournalEntryItem WBSElementExternalID WBS Element External ID
RevnAcctgContractCreationDate
BusinessPartner
Customer
PerfOblgnFulfillmentType
RAPerformanceObligationType
RevnAcctgSalesOrganization
RevnAcctgPostgAmtInCoCodeCrcy I_RAJournalEntryItem RevnAcctgPostgAmtInCoCodeCrcy
CompanyCodeCurrency I_RAJournalEntryItem CompanyCodeCurrency Local Currency
RevnAcctgPostgAmtInSlsDocCrcy I_RAJournalEntryItem RevnAcctgPostgAmtInSlsDocCrcy Reduction Amt
SalesDocumentCurrency I_RAJournalEntryItem SalesDocumentCurrency Currency
RevnAcctgPostgAmtInAddlCrcy1 I_RAJournalEntryItem RevnAcctgPostgAmtInAddlCrcy1 Second Local Crcy
AdditionalCurrency1 I_RAJournalEntryItem AdditionalCurrency1 Local curr. 2
RevnAcctgPostgAmtInAddlCrcy2 I_RAJournalEntryItem RevnAcctgPostgAmtInAddlCrcy2 Third Local Crcy
AdditionalCurrency2 I_RAJournalEntryItem AdditionalCurrency2 Local curr. 3
ConditionIsForStatistics I_RAJournalEntryItem ConditionIsForStatistics Statistical
RevnAcctgRecnclnKeyStatus I_RAJournalEntryItem RevnAcctgRecnclnKeyStatus
ControllingArea I_RAJournalEntryItem ControllingArea Controlling Area
_CompanyCode I_RAJournalEntryItem _CompanyCode
_AccountingPrinciple I_RAJournalEntryItem _AccountingPrinciple
_RevenueAccountingContract I_RAJournalEntryItem _RevenueAccountingContract
_ProfitCenter I_RAJournalEntryItem _ProfitCenter
_CurrentProfitCenter I_RAJournalEntryItem _CurrentProfitCenter
_ControllingArea I_RAJournalEntryItem _ControllingArea
_Segment I_RAJournalEntryItem _Segment
_CostCenter I_RAJournalEntryItem _CostCenter
_CurrentCostCenter I_RAJournalEntryItem _CurrentCostCenter
_WBSElement I_RAJournalEntryItem _WBSElement
_Currency I_RAJournalEntryItem _Currency
_CompanyCodeCurrency I_RAJournalEntryItem _CompanyCodeCurrency
_RevnAcctgReconciliationKey _RevnAcctgReconciliationKey
_RAPerformanceObligation _RAPerformanceObligation
_FiscalYear _FiscalYear
_GLAccountInCompanyCode _GLAccountInCompanyCode
_BusinessArea _BusinessArea
_FunctionalArea _FunctionalArea
_Order _Order
_SalesOrder _SalesOrder
_RAPostingCategory _RAPostingCategory
_DebitCreditCode _DebitCreditCode
_RAReconciliationKeyStatus _RAReconciliationKeyStatus
_BusinessPartner _RAPerformanceObligation _BusinessPartner
_Customer _RAPerformanceObligation _Customer
_FulfillmentType _RAPerformanceObligation _FulfillmentType

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 P_RAPostingItemWthRecgdAmt.
-- 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 P_RAPostingItemWthRecgdAmt AS
SELECT
  RevenueAccountingPosting.CompanyCode AS CompanyCode,
  RevenueAccountingPosting.AccountingPrinciple AS AccountingPrinciple,
  RevenueAccountingPosting.RevnAcctgReconciliationKey AS RevnAcctgReconciliationKey,
  RevenueAccountingPosting.PerformanceObligation AS PerformanceObligation,
  RevenueAccountingPosting.ConditionType AS ConditionType,
  RevenueAccountingPosting.RevnAcctgPostingCategory AS RevnAcctgPostingCategory,
  RevenueAccountingPosting.DebitCreditCode AS DebitCreditCode,
  RevenueAccountingPosting.RevenueAccountingContract AS RevenueAccountingContract,
  cast('' as fis_belnr) AS AccountingDocument,
  cast( '' as fis_docln ) AS GLAccountLineItem,
  RevenueAccountingPosting.RevnAcctgPostingItemUUID AS RevnAcctgPostingItemUUID,
  RevenueAccountingPosting.FiscalYear AS FiscalYear,
  cast(RevenueAccountingPosting.FiscalPeriod as fins_fiscalperiod preserving type) AS FiscalPeriod,
  RevenueAccountingPosting.FiscalYearPeriod AS FiscalYearPeriod,
  RevenueAccountingPosting.Segment AS Segment,
  RevenueAccountingPosting.GLAccount AS GLAccount,
  RevenueAccountingPosting.FunctionalArea AS FunctionalArea,
  RevenueAccountingPosting.BusinessArea AS BusinessArea,
  RevenueAccountingPosting.ProfitCenter AS ProfitCenter,
  RevenueAccountingPosting.CostCenter AS CostCenter,
  RevenueAccountingPosting.OrderID AS OrderID,
  RevenueAccountingPosting.SalesOrder AS SalesOrder,
  RevenueAccountingPosting.WBSElementExternalID AS WBSElementExternalID,
  RevenueAccountingPosting._RevenueAccountingContract.RevnAcctgContractCreationDate AS RevnAcctgContractCreationDate,
  RevenueAccountingPosting._RAPerformanceObligation.BusinessPartner AS BusinessPartner,
  RevenueAccountingPosting._RAPerformanceObligation.Customer AS Customer,
  RevenueAccountingPosting._RAPerformanceObligation.PerfOblgnFulfillmentType AS PerfOblgnFulfillmentType,
  RevenueAccountingPosting._RAPerformanceObligation.RAPerformanceObligationType AS RAPerformanceObligationType,
  RevenueAccountingPosting._RAPerformanceObligation.RevnAcctgSalesOrganization AS RevnAcctgSalesOrganization,
  RevenueAccountingPosting.RevnAcctgPostgAmtInCoCodeCrcy AS RevnAcctgPostgAmtInCoCodeCrcy,
  RevenueAccountingPosting.CompanyCodeCurrency AS CompanyCodeCurrency,
  RevenueAccountingPosting.RevnAcctgPostgAmtInSlsDocCrcy AS RevnAcctgPostgAmtInSlsDocCrcy,
  RevenueAccountingPosting.SalesDocumentCurrency AS SalesDocumentCurrency,
  RevenueAccountingPosting.RevnAcctgPostgAmtInAddlCrcy1 AS RevnAcctgPostgAmtInAddlCrcy1,
  RevenueAccountingPosting.AdditionalCurrency1 AS AdditionalCurrency1,
  RevenueAccountingPosting.RevnAcctgPostgAmtInAddlCrcy2 AS RevnAcctgPostgAmtInAddlCrcy2,
  RevenueAccountingPosting.AdditionalCurrency2 AS AdditionalCurrency2,
  RevenueAccountingPosting.ConditionIsForStatistics AS ConditionIsForStatistics,
  RevenueAccountingPosting._RevnAcctgReconciliationKey.RevnAcctgRecnclnKeyStatus AS RevnAcctgRecnclnKeyStatus,
  RevenueAccountingPosting.ControllingArea AS ControllingArea,
  RevenueAccountingPosting._CompanyCode AS _CompanyCode,
  RevenueAccountingPosting._AccountingPrinciple AS _AccountingPrinciple,
  RevenueAccountingPosting._RevenueAccountingContract AS _RevenueAccountingContract,
  RevenueAccountingPosting._ProfitCenter AS _ProfitCenter,
  RevenueAccountingPosting._CurrentProfitCenter AS _CurrentProfitCenter,
  RevenueAccountingPosting._ControllingArea AS _ControllingArea,
  RevenueAccountingPosting._Segment AS _Segment,
  RevenueAccountingPosting._CostCenter AS _CostCenter,
  RevenueAccountingPosting._CurrentCostCenter AS _CurrentCostCenter,
  RevenueAccountingPosting._WBSElement AS _WBSElement,
  RevenueAccountingPosting._Currency AS _Currency,
  RevenueAccountingPosting._CompanyCodeCurrency AS _CompanyCodeCurrency,
  _RAPerformanceObligation._BusinessPartner AS _BusinessPartner,
  _RAPerformanceObligation._Customer AS _Customer,
  _RAPerformanceObligation._FulfillmentType AS _FulfillmentType
FROM I_RevenueAccountingPosting AS RevenueAccountingPosting
LEFT OUTER JOIN I_RAReconciliationKeyStatus AS _RAReconciliationKeyStatus ON revnacctgrecnclnkeystatus = _RAReconciliationKeyStatus.RevnAcctgRecnclnKeyStatus  -- association [1..1]
LEFT OUTER JOIN I_RevnAcctgReconciliationKey AS _RevnAcctgReconciliationKey ON CompanyCode = _RevnAcctgReconciliationKey.CompanyCode AND AccountingPrinciple = _RevnAcctgReconciliationKey.AccountingPrinciple AND RevenueAccountingContract = _RevnAcctgReconciliationKey.RevenueAccountingContract AND RevnAcctgReconciliationKey = _RevnAcctgReconciliationKey.RevnAcctgReconciliationKey  -- association [1..1]
-- UNION ALL with additional select branch(es): I_RAJournalEntryItem
;

Learn More