P_RABusRecnclnDetWithCndnType

DDL: P_RABUSRECNCLNDETWITHCNDNTYPE Type: view_entity COMPOSITE Package: ODATA_FARR_BIZ_RECON

Business Reconciliation Detail with Condition Type

P_RABusRecnclnDetWithCndnType is a Composite CDS View that provides data about "Business Reconciliation Detail with Condition Type" in SAP S/4HANA. It reads from 2 data sources (I_RABusinessReconciliation, P_RABusRecnclnWithUnqCndnType) and exposes 86 fields with key fields CompanyCode, AccountingPrinciple, RevenueAccountingContract, PerformanceObligation, ConditionType. Part of development package ODATA_FARR_BIZ_RECON.

Data Sources (2)

SourceAliasJoin Type
I_RABusinessReconciliation _BusinessRecncln inner
P_RABusRecnclnWithUnqCndnType _BusRecnclnUnique from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (86)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_RABusRecnclnWithUnqCndnType CompanyCode Receiver Company Code
KEY AccountingPrinciple P_RABusRecnclnWithUnqCndnType AccountingPrinciple AP Ledger/CoCode
KEY RevenueAccountingContract P_RABusRecnclnWithUnqCndnType RevenueAccountingContract Revenue Contract
KEY PerformanceObligation P_RABusRecnclnWithUnqCndnType PerformanceObligation Performance Obligation
KEY ConditionType P_RABusRecnclnWithUnqCndnType ConditionType Condition type
FiscalYearPeriod P_RABusRecnclnWithUnqCndnType FiscalYearPeriod Period/Year
RABusinessRecnclnViewType P_RABusRecnclnWithUnqCndnType RABusinessRecnclnViewType Execution Type
RevnAcctgOperationalDocument P_RABusRecnclnWithUnqCndnType RevnAcctgOperationalDocument
RAOperationalDocumentItem P_RABusRecnclnWithUnqCndnType RAOperationalDocumentItem
OplContractualPrcInSlsDocCrcy I_RABusinessReconciliation OplContractualPrcInSlsDocCrcy
RAOplCostAmtInSlsDocCrcy I_RABusinessReconciliation RAOplCostAmtInSlsDocCrcy
TransactionCurrency P_RABusRecnclnWithUnqCndnType TransactionCurrency Transaction Currency
InvoiceCurrency P_RABusRecnclnWithUnqCndnType InvoiceCurrency
TotalInvoicedAmtInSlsDocCrcy I_RABusinessReconciliation TotalInvoicedAmtInSlsDocCrcy
CostCurrency P_RABusRecnclnWithUnqCndnType CostCurrency
RAOplCostPriceAmtInSlsDocCrcy I_RABusinessReconciliation RAOplCostPriceAmtInSlsDocCrcy
Material P_RABusRecnclnWithUnqCndnType Material Vehicle Model
MaterialName P_RABusRecnclnWithUnqCndnType MaterialName Material Description
SalesDocumentCurrency P_RABusRecnclnWithUnqCndnType SalesDocumentCurrency Currency
ContractualPrcInSlsDocCrcy I_RABusinessReconciliation ContractualPrcInSlsDocCrcy Contractual Price
RAPerfOblgnCostAmtInSlsDocCrcy I_RABusinessReconciliation RAPerfOblgnCostAmtInSlsDocCrcy
SSPriceInSalesDocCrcy I_RABusinessReconciliation SSPriceInSalesDocCrcy Standalone Selling Price
AllocatedPriceInSalesDocCrcy I_RABusinessReconciliation AllocatedPriceInSalesDocCrcy Allocated Amount
RARecognizedRevnInSlsDocCrcy P_RABusRecnclnWithUnqCndnType RARecognizedRevnInSlsDocCrcy
RARecgdCostAmountInSlsDocCrcy P_RABusRecnclnWithUnqCndnType RARecgdCostAmountInSlsDocCrcy
PerPerdInvoicedAmtInSlsDocCrcy P_RABusRecnclnWithUnqCndnType PerPerdInvoicedAmtInSlsDocCrcy
RADeltaRecgdCostInSlsDocCrcy P_RABusRecnclnWithUnqCndnType RADeltaRecgdCostInSlsDocCrcy Actual Cost
PostedRevnInSlsDocCrcy P_RABusRecnclnWithUnqCndnType PostedRevnInSlsDocCrcy
PostedInvoiceAmtInSlsDocCrcy P_RABusRecnclnWithUnqCndnType PostedInvoiceAmtInSlsDocCrcy
RAPostedCostInSlsDocCrcy P_RABusRecnclnWithUnqCndnType RAPostedCostInSlsDocCrcy
RAPostedUnbilldRblsAmount P_RABusRecnclnWithUnqCndnType RAPostedUnbilldRblsAmount
RADeferredRevenueInSlsDocCrcy P_RABusRecnclnWithUnqCndnType RADeferredRevenueInSlsDocCrcy
RAContractAssetsAmount P_RABusRecnclnWithUnqCndnType RAContractAssetsAmount
RAContrLiabilitiesAmount P_RABusRecnclnWithUnqCndnType RAContrLiabilitiesAmount
PostdDfrrdCostAmtInSlsDocCrcy P_RABusRecnclnWithUnqCndnType PostdDfrrdCostAmtInSlsDocCrcy
SuspendedRevnAmtInSlsDocCrcy P_RABusRecnclnWithUnqCndnType SuspendedRevnAmtInSlsDocCrcy
SuspendedCostAmtInSlsDocCrcy P_RABusRecnclnWithUnqCndnType SuspendedCostAmtInSlsDocCrcy
CompanyCodeCurrency P_RABusRecnclnWithUnqCndnType CompanyCodeCurrency Local Currency
RAPostedRevenueAmtInCoCodeCrcy P_RABusRecnclnWithUnqCndnType RAPostedRevenueAmtInCoCodeCrcy
RAPostedInvoiceAmtInCoCodeCrcy P_RABusRecnclnWithUnqCndnType RAPostedInvoiceAmtInCoCodeCrcy
RAPostedCostAmountInCoCodeCrcy P_RABusRecnclnWithUnqCndnType RAPostedCostAmountInCoCodeCrcy
PostdUnbilldRblAmtInCoCodeCrcy P_RABusRecnclnWithUnqCndnType PostdUnbilldRblAmtInCoCodeCrcy
PostedDfrrdRevnAmtInCoCodeCrcy P_RABusRecnclnWithUnqCndnType PostedDfrrdRevnAmtInCoCodeCrcy
RAPostdContrAstAmtInCoCodeCrcy P_RABusRecnclnWithUnqCndnType RAPostdContrAstAmtInCoCodeCrcy
PostdContrLbltyAmtInCoCodeCrcy P_RABusRecnclnWithUnqCndnType PostdContrLbltyAmtInCoCodeCrcy
PostdDfrrdCostAmtInCoCodeCrcy P_RABusRecnclnWithUnqCndnType PostdDfrrdCostAmtInCoCodeCrcy
AdditionalCurrency1 P_RABusRecnclnWithUnqCndnType AdditionalCurrency1 Local curr. 2
RAPostedRevenueAmtInAddlCrcy1 P_RABusRecnclnWithUnqCndnType RAPostedRevenueAmtInAddlCrcy1
RAPostedInvoiceAmtInAddlCrcy1 P_RABusRecnclnWithUnqCndnType RAPostedInvoiceAmtInAddlCrcy1
RAPostedCostAmountInAddlCrcy1 P_RABusRecnclnWithUnqCndnType RAPostedCostAmountInAddlCrcy1
PostedUnbilldRblAmtInAddlCrcy1 P_RABusRecnclnWithUnqCndnType PostedUnbilldRblAmtInAddlCrcy1
RAPostdDfrrdRevnAmtInAddlCrcy1 P_RABusRecnclnWithUnqCndnType RAPostdDfrrdRevnAmtInAddlCrcy1
RAPostedContrAstAmtInAddlCrcy1 P_RABusRecnclnWithUnqCndnType RAPostedContrAstAmtInAddlCrcy1
PostedContrLbltyAmtInAddlCrcy1 P_RABusRecnclnWithUnqCndnType PostedContrLbltyAmtInAddlCrcy1
RAPostdDfrrdCostAmtInAddlCrcy1 P_RABusRecnclnWithUnqCndnType RAPostdDfrrdCostAmtInAddlCrcy1
AdditionalCurrency2 P_RABusRecnclnWithUnqCndnType AdditionalCurrency2 Local curr. 3
RAPostedRevenueAmtInAddlCrcy2 P_RABusRecnclnWithUnqCndnType RAPostedRevenueAmtInAddlCrcy2
RAPostedInvoiceAmtInAddlCrcy2 P_RABusRecnclnWithUnqCndnType RAPostedInvoiceAmtInAddlCrcy2
RAPostedCostAmountInAddlCrcy2 P_RABusRecnclnWithUnqCndnType RAPostedCostAmountInAddlCrcy2
PostedUnbilldRblAmtInAddlCrcy2 P_RABusRecnclnWithUnqCndnType PostedUnbilldRblAmtInAddlCrcy2
RAPostdDfrrdRevnAmtInAddlCrcy2 P_RABusRecnclnWithUnqCndnType RAPostdDfrrdRevnAmtInAddlCrcy2
RAPostedContrAstAmtInAddlCrcy2 P_RABusRecnclnWithUnqCndnType RAPostedContrAstAmtInAddlCrcy2
PostedContrLbltyAmtInAddlCrcy2 P_RABusRecnclnWithUnqCndnType PostedContrLbltyAmtInAddlCrcy2
RAPostdDfrrdCostAmtInAddlCrcy2 P_RABusRecnclnWithUnqCndnType RAPostdDfrrdCostAmtInAddlCrcy2
RAContrLiabilityAssetIsCalcd I_RABusinessReconciliation RAContrLiabilityAssetIsCalcd
DataValidationHasError I_RABusinessReconciliation DataValidationHasError
ValidationDateTime I_RABusinessReconciliation ValidationDateTime Data Validation Run Time
RevnAcctgPerfOblgnStatus I_RABusinessReconciliation RevnAcctgPerfOblgnStatus Perf. Oblig. Status
RAGenLdgrCorrectionAccount I_RABusinessReconciliation RAGenLdgrCorrectionAccount
RAGenLdgrRecognitionAccount I_RABusinessReconciliation RAGenLdgrRecognitionAccount
BusRecnclnItemCreatedByUser I_RABusinessReconciliation BusRecnclnItemCreatedByUser User Name
BusRecnclnItmCreatedDateTime I_RABusinessReconciliation BusRecnclnItmCreatedDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
DeltaEffectiveAmtInSlsDocCrcy I_RABusinessReconciliation DeltaEffectiveAmtInSlsDocCrcy
SrceRecgdRevnAmtInSlsDocCrcy P_RABusRecnclnWithUnqCndnType SrceRecgdRevnAmtInSlsDocCrcy Recognized Revenue from Source Contract
SrceRecgdCostAmtInSlsDocCrcy P_RABusRecnclnWithUnqCndnType SrceRecgdCostAmtInSlsDocCrcy Recognized Cost from Source Contract
SrceRecgdInvcAmtInSlsDocCrcy P_RABusRecnclnWithUnqCndnType SrceRecgdInvcAmtInSlsDocCrcy Recognized Invoice from Source Contract
OperationalDocItemQty I_RABusinessReconciliation OperationalDocItemQty
PerfOblgnContractualQuantity I_RABusinessReconciliation PerfOblgnContractualQuantity Quantity
CARevnRecgnQtyUnit P_RABusRecnclnWithUnqCndnType CARevnRecgnQtyUnit Unit of Measure
RAPerfOblgnIsFrozen I_RABusinessReconciliation RAPerfOblgnIsFrozen
_Mapping P_RABusRecnclnWithUnqCndnType _Mapping
_Contract P_RABusRecnclnWithUnqCndnType _Contract
_SenderComponentMapping P_RABusRecnclnWithUnqCndnType _SenderComponentMapping
_RAPerformanceObligation P_RABusRecnclnWithUnqCndnType _RAPerformanceObligation
_CompanyCode P_RABusRecnclnWithUnqCndnType _CompanyCode
_AccountingPrinciple P_RABusRecnclnWithUnqCndnType _AccountingPrinciple

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_RABusRecnclnDetWithCndnType.
-- 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_RABusRecnclnDetWithCndnType AS
SELECT
  _BusRecnclnUnique.CompanyCode AS CompanyCode,
  _BusRecnclnUnique.AccountingPrinciple AS AccountingPrinciple,
  _BusRecnclnUnique.RevenueAccountingContract AS RevenueAccountingContract,
  _BusRecnclnUnique.PerformanceObligation AS PerformanceObligation,
  _BusRecnclnUnique.ConditionType AS ConditionType,
  _BusRecnclnUnique.FiscalYearPeriod AS FiscalYearPeriod,
  _BusRecnclnUnique.RABusinessRecnclnViewType AS RABusinessRecnclnViewType,
  _BusRecnclnUnique.RevnAcctgOperationalDocument AS RevnAcctgOperationalDocument,
  _BusRecnclnUnique.RAOperationalDocumentItem AS RAOperationalDocumentItem,
  _BusinessRecncln.OplContractualPrcInSlsDocCrcy AS OplContractualPrcInSlsDocCrcy,
  _BusinessRecncln.RAOplCostAmtInSlsDocCrcy AS RAOplCostAmtInSlsDocCrcy,
  _BusRecnclnUnique.TransactionCurrency AS TransactionCurrency,
  _BusRecnclnUnique.InvoiceCurrency AS InvoiceCurrency,
  _BusinessRecncln.TotalInvoicedAmtInSlsDocCrcy AS TotalInvoicedAmtInSlsDocCrcy,
  _BusRecnclnUnique.CostCurrency AS CostCurrency,
  _BusinessRecncln.RAOplCostPriceAmtInSlsDocCrcy AS RAOplCostPriceAmtInSlsDocCrcy,
  _BusRecnclnUnique.Material AS Material,
  _BusRecnclnUnique.MaterialName AS MaterialName,
  _BusRecnclnUnique.SalesDocumentCurrency AS SalesDocumentCurrency,
  _BusinessRecncln.ContractualPrcInSlsDocCrcy AS ContractualPrcInSlsDocCrcy,
  _BusinessRecncln.RAPerfOblgnCostAmtInSlsDocCrcy AS RAPerfOblgnCostAmtInSlsDocCrcy,
  _BusinessRecncln.SSPriceInSalesDocCrcy AS SSPriceInSalesDocCrcy,
  _BusinessRecncln.AllocatedPriceInSalesDocCrcy AS AllocatedPriceInSalesDocCrcy,
  _BusRecnclnUnique.RARecognizedRevnInSlsDocCrcy AS RARecognizedRevnInSlsDocCrcy,
  _BusRecnclnUnique.RARecgdCostAmountInSlsDocCrcy AS RARecgdCostAmountInSlsDocCrcy,
  _BusRecnclnUnique.PerPerdInvoicedAmtInSlsDocCrcy AS PerPerdInvoicedAmtInSlsDocCrcy,
  _BusRecnclnUnique.RADeltaRecgdCostInSlsDocCrcy AS RADeltaRecgdCostInSlsDocCrcy,
  _BusRecnclnUnique.PostedRevnInSlsDocCrcy AS PostedRevnInSlsDocCrcy,
  _BusRecnclnUnique.PostedInvoiceAmtInSlsDocCrcy AS PostedInvoiceAmtInSlsDocCrcy,
  _BusRecnclnUnique.RAPostedCostInSlsDocCrcy AS RAPostedCostInSlsDocCrcy,
  _BusRecnclnUnique.RAPostedUnbilldRblsAmount AS RAPostedUnbilldRblsAmount,
  _BusRecnclnUnique.RADeferredRevenueInSlsDocCrcy AS RADeferredRevenueInSlsDocCrcy,
  _BusRecnclnUnique.RAContractAssetsAmount AS RAContractAssetsAmount,
  _BusRecnclnUnique.RAContrLiabilitiesAmount AS RAContrLiabilitiesAmount,
  _BusRecnclnUnique.PostdDfrrdCostAmtInSlsDocCrcy AS PostdDfrrdCostAmtInSlsDocCrcy,
  _BusRecnclnUnique.SuspendedRevnAmtInSlsDocCrcy AS SuspendedRevnAmtInSlsDocCrcy,
  _BusRecnclnUnique.SuspendedCostAmtInSlsDocCrcy AS SuspendedCostAmtInSlsDocCrcy,
  _BusRecnclnUnique.CompanyCodeCurrency AS CompanyCodeCurrency,
  _BusRecnclnUnique.RAPostedRevenueAmtInCoCodeCrcy AS RAPostedRevenueAmtInCoCodeCrcy,
  _BusRecnclnUnique.RAPostedInvoiceAmtInCoCodeCrcy AS RAPostedInvoiceAmtInCoCodeCrcy,
  _BusRecnclnUnique.RAPostedCostAmountInCoCodeCrcy AS RAPostedCostAmountInCoCodeCrcy,
  _BusRecnclnUnique.PostdUnbilldRblAmtInCoCodeCrcy AS PostdUnbilldRblAmtInCoCodeCrcy,
  _BusRecnclnUnique.PostedDfrrdRevnAmtInCoCodeCrcy AS PostedDfrrdRevnAmtInCoCodeCrcy,
  _BusRecnclnUnique.RAPostdContrAstAmtInCoCodeCrcy AS RAPostdContrAstAmtInCoCodeCrcy,
  _BusRecnclnUnique.PostdContrLbltyAmtInCoCodeCrcy AS PostdContrLbltyAmtInCoCodeCrcy,
  _BusRecnclnUnique.PostdDfrrdCostAmtInCoCodeCrcy AS PostdDfrrdCostAmtInCoCodeCrcy,
  _BusRecnclnUnique.AdditionalCurrency1 AS AdditionalCurrency1,
  _BusRecnclnUnique.RAPostedRevenueAmtInAddlCrcy1 AS RAPostedRevenueAmtInAddlCrcy1,
  _BusRecnclnUnique.RAPostedInvoiceAmtInAddlCrcy1 AS RAPostedInvoiceAmtInAddlCrcy1,
  _BusRecnclnUnique.RAPostedCostAmountInAddlCrcy1 AS RAPostedCostAmountInAddlCrcy1,
  _BusRecnclnUnique.PostedUnbilldRblAmtInAddlCrcy1 AS PostedUnbilldRblAmtInAddlCrcy1,
  _BusRecnclnUnique.RAPostdDfrrdRevnAmtInAddlCrcy1 AS RAPostdDfrrdRevnAmtInAddlCrcy1,
  _BusRecnclnUnique.RAPostedContrAstAmtInAddlCrcy1 AS RAPostedContrAstAmtInAddlCrcy1,
  _BusRecnclnUnique.PostedContrLbltyAmtInAddlCrcy1 AS PostedContrLbltyAmtInAddlCrcy1,
  _BusRecnclnUnique.RAPostdDfrrdCostAmtInAddlCrcy1 AS RAPostdDfrrdCostAmtInAddlCrcy1,
  _BusRecnclnUnique.AdditionalCurrency2 AS AdditionalCurrency2,
  _BusRecnclnUnique.RAPostedRevenueAmtInAddlCrcy2 AS RAPostedRevenueAmtInAddlCrcy2,
  _BusRecnclnUnique.RAPostedInvoiceAmtInAddlCrcy2 AS RAPostedInvoiceAmtInAddlCrcy2,
  _BusRecnclnUnique.RAPostedCostAmountInAddlCrcy2 AS RAPostedCostAmountInAddlCrcy2,
  _BusRecnclnUnique.PostedUnbilldRblAmtInAddlCrcy2 AS PostedUnbilldRblAmtInAddlCrcy2,
  _BusRecnclnUnique.RAPostdDfrrdRevnAmtInAddlCrcy2 AS RAPostdDfrrdRevnAmtInAddlCrcy2,
  _BusRecnclnUnique.RAPostedContrAstAmtInAddlCrcy2 AS RAPostedContrAstAmtInAddlCrcy2,
  _BusRecnclnUnique.PostedContrLbltyAmtInAddlCrcy2 AS PostedContrLbltyAmtInAddlCrcy2,
  _BusRecnclnUnique.RAPostdDfrrdCostAmtInAddlCrcy2 AS RAPostdDfrrdCostAmtInAddlCrcy2,
  _BusinessRecncln.RAContrLiabilityAssetIsCalcd AS RAContrLiabilityAssetIsCalcd,
  _BusinessRecncln.DataValidationHasError AS DataValidationHasError,
  _BusinessRecncln.ValidationDateTime AS ValidationDateTime,
  _BusinessRecncln.RevnAcctgPerfOblgnStatus AS RevnAcctgPerfOblgnStatus,
  _BusinessRecncln.RAGenLdgrCorrectionAccount AS RAGenLdgrCorrectionAccount,
  _BusinessRecncln.RAGenLdgrRecognitionAccount AS RAGenLdgrRecognitionAccount,
  _BusinessRecncln.BusRecnclnItemCreatedByUser AS BusRecnclnItemCreatedByUser,
  _BusinessRecncln.BusRecnclnItmCreatedDateTime AS BusRecnclnItmCreatedDateTime,
  _BusinessRecncln.DeltaEffectiveAmtInSlsDocCrcy AS DeltaEffectiveAmtInSlsDocCrcy,
  _BusRecnclnUnique.SrceRecgdRevnAmtInSlsDocCrcy AS SrceRecgdRevnAmtInSlsDocCrcy,
  _BusRecnclnUnique.SrceRecgdCostAmtInSlsDocCrcy AS SrceRecgdCostAmtInSlsDocCrcy,
  _BusRecnclnUnique.SrceRecgdInvcAmtInSlsDocCrcy AS SrceRecgdInvcAmtInSlsDocCrcy,
  _BusinessRecncln.OperationalDocItemQty AS OperationalDocItemQty,
  _BusinessRecncln.PerfOblgnContractualQuantity AS PerfOblgnContractualQuantity,
  _BusRecnclnUnique.CARevnRecgnQtyUnit AS CARevnRecgnQtyUnit,
  _BusinessRecncln.RAPerfOblgnIsFrozen AS RAPerfOblgnIsFrozen,
  _BusRecnclnUnique._Mapping AS _Mapping,
  _BusRecnclnUnique._Contract AS _Contract,
  _BusRecnclnUnique._SenderComponentMapping AS _SenderComponentMapping,
  _BusRecnclnUnique._RAPerformanceObligation AS _RAPerformanceObligation,
  _BusRecnclnUnique._CompanyCode AS _CompanyCode,
  _BusRecnclnUnique._AccountingPrinciple AS _AccountingPrinciple
FROM P_RABusRecnclnWithUnqCndnType AS _BusRecnclnUnique
INNER JOIN I_RABusinessReconciliation AS _BusinessRecncln ON /* join condition not captured in parsed metadata */
;