C_RABusRecnclnForContract

DDL: C_RABUSRECNCLNFORCONTRACT Type: view_entity CONSUMPTION Package: ODATA_FARR_BIZ_RECON

Business Reconciliation Contract Info

C_RABusRecnclnForContract is a Consumption CDS View that provides data about "Business Reconciliation Contract Info" in SAP S/4HANA. It reads from 1 data source (R_RABusRecnclnForContractTP) and exposes 82 fields with key fields CompanyCode, AccountingPrinciple, RevenueAccountingContract. It is exposed through 1 OData service (FARR_BUSINESS_RECNCLN). It is used in 1 Fiori application: Business Reconciliation. Part of development package ODATA_FARR_BIZ_RECON.

Data Sources (1)

SourceAliasJoin Type
R_RABusRecnclnForContractTP R_RABusRecnclnForContractTP projection

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Business Reconciliation Contract Info view
Metadata.allowExtensions true view
ObjectModel.query.implementedBy ABAP:CL_FARR_BUSINESS_RECNCLN_QUERY view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
FARR_BUSINESS_RECNCLN FARR_BUSINESS_RECNCLN V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F4830 Business Reconciliation Transactional Revenue Accountant can use this application to do reconciliation between sender components and revenue accounting engine side.

Business Reconciliation

Business Role: Revenue Accountant

You can have close integration with the universal journal by posting directly to the universal journal without persistence of the Revenue Accounting (RAR) subledger. The benefits of direct posting are the following:A simplified process for small- and medium-volume business scenarios When direct posting is used, no RAR subledger is used, and this leads to reduced reconciliation effort. A reduction in the number of period-end batch jobs required to execute the Transfer Revenue transaction for time-based revenues and the Calculate Contract Liabilities and Contract Assets transaction

Fields (82)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY AccountingPrinciple AccountingPrinciple AP Ledger/CoCode
KEY RevenueAccountingContract RevenueAccountingContract Revenue Contract
RevnAcctgContractDescription RevnAcctgContractDescription Description
RevnAcctgContractStatus RevnAcctgContractStatus Contract Status
RevnAcctgContractStatusName RevnAcctgContractStatusName Contract Status Description
BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerName BusinessPartnerName Extracted Customer Name
Customer Customer Sold-to Party
CustomerName CustomerName Name of Customer
RevnAcctgOperationalDocument RevnAcctgOperationalDocument
RevnAcctgSenderComponent RevnAcctgSenderComponent Sender Component
LogicalSystem LogicalSystem Logical System
ReportIsOnlineMode ReportIsOnlineMode
RAContractIsInconsistent RAContractIsInconsistent
SalesDocumentCurrency SalesDocumentCurrency Currency
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AdditionalCurrency1 AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 AdditionalCurrency2 Local curr. 3
RADeltaRecgdCostInSlsDocCrcy RADeltaRecgdCostInSlsDocCrcy
OplContractualPrcInSlsDocCrcy OplContractualPrcInSlsDocCrcy
DeltaEffectiveAmtInSlsDocCrcy DeltaEffectiveAmtInSlsDocCrcy
RAOplCostAmtInSlsDocCrcy RAOplCostAmtInSlsDocCrcy
TotalInvoicedAmtInSlsDocCrcy TotalInvoicedAmtInSlsDocCrcy
RAOplCostPriceAmtInSlsDocCrcy RAOplCostPriceAmtInSlsDocCrcy
ContractualPrcInSlsDocCrcy ContractualPrcInSlsDocCrcy Contractual Price
RAPerfOblgnCostAmtInSlsDocCrcy RAPerfOblgnCostAmtInSlsDocCrcy
RARecognizedRevnInSlsDocCrcy RARecognizedRevnInSlsDocCrcy
RARecgdCostAmountInSlsDocCrcy RARecgdCostAmountInSlsDocCrcy
PerPerdInvoicedAmtInSlsDocCrcy PerPerdInvoicedAmtInSlsDocCrcy
PostedRevnInSlsDocCrcy PostedRevnInSlsDocCrcy
PostedInvoiceAmtInSlsDocCrcy PostedInvoiceAmtInSlsDocCrcy
RAPostedCostInSlsDocCrcy RAPostedCostInSlsDocCrcy
RAPostedUnbilldRblsAmount RAPostedUnbilldRblsAmount
RADeferredRevenueInSlsDocCrcy RADeferredRevenueInSlsDocCrcy
RAContractAssetsAmount RAContractAssetsAmount
RAContrLiabilitiesAmount RAContrLiabilitiesAmount
PostdDfrrdCostAmtInSlsDocCrcy PostdDfrrdCostAmtInSlsDocCrcy
SrceRecgdRevnAmtInSlsDocCrcy SrceRecgdRevnAmtInSlsDocCrcy
SrceRecgdCostAmtInSlsDocCrcy SrceRecgdCostAmtInSlsDocCrcy
SrceRecgdInvcAmtInSlsDocCrcy SrceRecgdInvcAmtInSlsDocCrcy
RAPostedRevenueAmtInCoCodeCrcy RAPostedRevenueAmtInCoCodeCrcy
RAPostedInvoiceAmtInCoCodeCrcy RAPostedInvoiceAmtInCoCodeCrcy
RAPostedCostAmountInCoCodeCrcy RAPostedCostAmountInCoCodeCrcy
PostdUnbilldRblAmtInCoCodeCrcy PostdUnbilldRblAmtInCoCodeCrcy
PostedDfrrdRevnAmtInCoCodeCrcy PostedDfrrdRevnAmtInCoCodeCrcy
RAPostdContrAstAmtInCoCodeCrcy RAPostdContrAstAmtInCoCodeCrcy
PostdContrLbltyAmtInCoCodeCrcy PostdContrLbltyAmtInCoCodeCrcy
PostdDfrrdCostAmtInCoCodeCrcy PostdDfrrdCostAmtInCoCodeCrcy
RAPostedRevenueAmtInAddlCrcy1 RAPostedRevenueAmtInAddlCrcy1
RAPostedInvoiceAmtInAddlCrcy1 RAPostedInvoiceAmtInAddlCrcy1
RAPostedCostAmountInAddlCrcy1 RAPostedCostAmountInAddlCrcy1
PostedUnbilldRblAmtInAddlCrcy1 PostedUnbilldRblAmtInAddlCrcy1
RAPostdDfrrdRevnAmtInAddlCrcy1 RAPostdDfrrdRevnAmtInAddlCrcy1
RAPostedContrAstAmtInAddlCrcy1 RAPostedContrAstAmtInAddlCrcy1
PostedContrLbltyAmtInAddlCrcy1 PostedContrLbltyAmtInAddlCrcy1
RAPostdDfrrdCostAmtInAddlCrcy1 RAPostdDfrrdCostAmtInAddlCrcy1
RAPostedRevenueAmtInAddlCrcy2 RAPostedRevenueAmtInAddlCrcy2
RAPostedInvoiceAmtInAddlCrcy2 RAPostedInvoiceAmtInAddlCrcy2
RAPostedCostAmountInAddlCrcy2 RAPostedCostAmountInAddlCrcy2
PostedUnbilldRblAmtInAddlCrcy2 PostedUnbilldRblAmtInAddlCrcy2
RAPostdDfrrdRevnAmtInAddlCrcy2 RAPostdDfrrdRevnAmtInAddlCrcy2
RAPostedContrAstAmtInAddlCrcy2 RAPostedContrAstAmtInAddlCrcy2
PostedContrLbltyAmtInAddlCrcy2 PostedContrLbltyAmtInAddlCrcy2
RAPostdDfrrdCostAmtInAddlCrcy2 RAPostdDfrrdCostAmtInAddlCrcy2
SuspendedRevnAmtInSlsDocCrcy SuspendedRevnAmtInSlsDocCrcy
SuspendedCostAmtInSlsDocCrcy SuspendedCostAmtInSlsDocCrcy
DataValidationHasError DataValidationHasError
ValidationDateTime ValidationDateTime
RAContrLiabilityAssetIsCalcd RAContrLiabilityAssetIsCalcd
ContractualPriceCriticality ContractualPriceCriticality
TotalCostCriticality TotalCostCriticality
InvoicedAmountCriticality InvoicedAmountCriticality
ActualCostCriticality ActualCostCriticality
RAContrBalanceIsDfrrdRevn RAContrBalanceIsDfrrdRevn TRUE
RAContrBalanceIsLiability RAContrBalanceIsLiability TRUE
IsBusinessPurposeCompleted _Contract IsBusinessPurposeCompleted Purpose Completed
_Contract _Contract
_CompanyCode _CompanyCode
_AccountingPrinciple _AccountingPrinciple
_LogicalSystem _LogicalSystem
_RevnAcctgSenderComponent _RevnAcctgSenderComponent

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 C_RABusRecnclnForContract.
-- 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 C_RABusRecnclnForContract AS
SELECT
  CompanyCode,
  AccountingPrinciple,
  RevenueAccountingContract,
  RevnAcctgContractDescription,
  RevnAcctgContractStatus,
  RevnAcctgContractStatusName,
  BusinessPartner,
  BusinessPartnerName,
  Customer,
  CustomerName,
  RevnAcctgOperationalDocument,
  RevnAcctgSenderComponent,
  LogicalSystem,
  ReportIsOnlineMode,
  RAContractIsInconsistent,
  SalesDocumentCurrency,
  CompanyCodeCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  RADeltaRecgdCostInSlsDocCrcy,
  OplContractualPrcInSlsDocCrcy,
  DeltaEffectiveAmtInSlsDocCrcy,
  RAOplCostAmtInSlsDocCrcy,
  TotalInvoicedAmtInSlsDocCrcy,
  RAOplCostPriceAmtInSlsDocCrcy,
  ContractualPrcInSlsDocCrcy,
  RAPerfOblgnCostAmtInSlsDocCrcy,
  RARecognizedRevnInSlsDocCrcy,
  RARecgdCostAmountInSlsDocCrcy,
  PerPerdInvoicedAmtInSlsDocCrcy,
  PostedRevnInSlsDocCrcy,
  PostedInvoiceAmtInSlsDocCrcy,
  RAPostedCostInSlsDocCrcy,
  RAPostedUnbilldRblsAmount,
  RADeferredRevenueInSlsDocCrcy,
  RAContractAssetsAmount,
  RAContrLiabilitiesAmount,
  PostdDfrrdCostAmtInSlsDocCrcy,
  SrceRecgdRevnAmtInSlsDocCrcy,
  SrceRecgdCostAmtInSlsDocCrcy,
  SrceRecgdInvcAmtInSlsDocCrcy,
  RAPostedRevenueAmtInCoCodeCrcy,
  RAPostedInvoiceAmtInCoCodeCrcy,
  RAPostedCostAmountInCoCodeCrcy,
  PostdUnbilldRblAmtInCoCodeCrcy,
  PostedDfrrdRevnAmtInCoCodeCrcy,
  RAPostdContrAstAmtInCoCodeCrcy,
  PostdContrLbltyAmtInCoCodeCrcy,
  PostdDfrrdCostAmtInCoCodeCrcy,
  RAPostedRevenueAmtInAddlCrcy1,
  RAPostedInvoiceAmtInAddlCrcy1,
  RAPostedCostAmountInAddlCrcy1,
  PostedUnbilldRblAmtInAddlCrcy1,
  RAPostdDfrrdRevnAmtInAddlCrcy1,
  RAPostedContrAstAmtInAddlCrcy1,
  PostedContrLbltyAmtInAddlCrcy1,
  RAPostdDfrrdCostAmtInAddlCrcy1,
  RAPostedRevenueAmtInAddlCrcy2,
  RAPostedInvoiceAmtInAddlCrcy2,
  RAPostedCostAmountInAddlCrcy2,
  PostedUnbilldRblAmtInAddlCrcy2,
  RAPostdDfrrdRevnAmtInAddlCrcy2,
  RAPostedContrAstAmtInAddlCrcy2,
  PostedContrLbltyAmtInAddlCrcy2,
  RAPostdDfrrdCostAmtInAddlCrcy2,
  SuspendedRevnAmtInSlsDocCrcy,
  SuspendedCostAmtInSlsDocCrcy,
  DataValidationHasError,
  ValidationDateTime,
  RAContrLiabilityAssetIsCalcd,
  ContractualPriceCriticality,
  TotalCostCriticality,
  InvoicedAmountCriticality,
  ActualCostCriticality,
  RAContrBalanceIsDfrrdRevn,
  RAContrBalanceIsLiability,
  _Contract.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM R_RABusRecnclnForContractTP
;