C_RABusRecnclnDetWithCndnType

DDL: C_RABUSRECNCLNDETWITHCNDNTYPE Type: view_entity CONSUMPTION Package: ODATA_FARR_BIZ_RECON
79 Fields 1 Data Sources 2 OData Services 1 Fiori Apps

Business Recncln with Condition Type

C_RABusRecnclnDetWithCndnType is a Consumption CDS View that provides data about "Business Recncln with Condition Type" in SAP S/4HANA. It reads from 1 data source (R_RABusRecnclnDetWthCndnTypeTP) and exposes 79 fields with key fields CompanyCode, AccountingPrinciple, RevenueAccountingContract, PerformanceObligation, ConditionType. It is exposed through 2 OData services (ASQL_F4830, 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_RABusRecnclnDetWthCndnTypeTP R_RABusRecnclnDetWthCndnTypeTP projection

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Business Recncln with Condition Type view
Metadata.allowExtensions true view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F4830 ASQL_F4830 C2 NOT_RELEASED
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 (79)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY AccountingPrinciple AccountingPrinciple AP Ledger/CoCode
KEY RevenueAccountingContract RevenueAccountingContract Revenue Contract
KEY PerformanceObligation PerformanceObligation Performance Obligation
KEY ConditionType ConditionType Condition type
RevnAcctgOperationalDocument RevnAcctgOperationalDocument
RABusinessRecnclnViewType RABusinessRecnclnViewType
RAOperationalDocumentItem RAOperationalDocumentItem
OplContractualPrcInSlsDocCrcy OplContractualPrcInSlsDocCrcy
RAOplCostAmtInSlsDocCrcy RAOplCostAmtInSlsDocCrcy
TransactionCurrency TransactionCurrency Transaction Currency
InvoiceCurrency InvoiceCurrency
TotalInvoicedAmtInSlsDocCrcy TotalInvoicedAmtInSlsDocCrcy
CostCurrency CostCurrency
RAOplCostPriceAmtInSlsDocCrcy RAOplCostPriceAmtInSlsDocCrcy
Material Material Vehicle Model
MaterialName MaterialName Material Description
SalesDocumentCurrency SalesDocumentCurrency Currency
ContractualPrcInSlsDocCrcy ContractualPrcInSlsDocCrcy Contractual Price
RAPerfOblgnCostAmtInSlsDocCrcy RAPerfOblgnCostAmtInSlsDocCrcy
SSPriceInSalesDocCrcy SSPriceInSalesDocCrcy Standalone Selling Price
AllocatedPriceInSalesDocCrcy AllocatedPriceInSalesDocCrcy Allocated Amount
RARecognizedRevnInSlsDocCrcy RARecognizedRevnInSlsDocCrcy
RARecgdCostAmountInSlsDocCrcy RARecgdCostAmountInSlsDocCrcy
PerPerdInvoicedAmtInSlsDocCrcy PerPerdInvoicedAmtInSlsDocCrcy
PostedRevnInSlsDocCrcy PostedRevnInSlsDocCrcy
PostedInvoiceAmtInSlsDocCrcy PostedInvoiceAmtInSlsDocCrcy
RAPostedCostInSlsDocCrcy RAPostedCostInSlsDocCrcy
RAPostedUnbilldRblsAmount RAPostedUnbilldRblsAmount
RADeferredRevenueInSlsDocCrcy RADeferredRevenueInSlsDocCrcy
RAContractAssetsAmount RAContractAssetsAmount
RAContrLiabilitiesAmount RAContrLiabilitiesAmount
PostdDfrrdCostAmtInSlsDocCrcy PostdDfrrdCostAmtInSlsDocCrcy
CompanyCodeCurrency CompanyCodeCurrency Local Currency
RAPostedRevenueAmtInCoCodeCrcy RAPostedRevenueAmtInCoCodeCrcy
RAPostedInvoiceAmtInCoCodeCrcy RAPostedInvoiceAmtInCoCodeCrcy
RAPostedCostAmountInCoCodeCrcy RAPostedCostAmountInCoCodeCrcy
PostdUnbilldRblAmtInCoCodeCrcy PostdUnbilldRblAmtInCoCodeCrcy
PostedDfrrdRevnAmtInCoCodeCrcy PostedDfrrdRevnAmtInCoCodeCrcy
RAPostdContrAstAmtInCoCodeCrcy RAPostdContrAstAmtInCoCodeCrcy
PostdContrLbltyAmtInCoCodeCrcy PostdContrLbltyAmtInCoCodeCrcy
PostdDfrrdCostAmtInCoCodeCrcy PostdDfrrdCostAmtInCoCodeCrcy
AdditionalCurrency1 AdditionalCurrency1 Local curr. 2
RAPostedRevenueAmtInAddlCrcy1 RAPostedRevenueAmtInAddlCrcy1
RAPostedInvoiceAmtInAddlCrcy1 RAPostedInvoiceAmtInAddlCrcy1
RAPostedCostAmountInAddlCrcy1 RAPostedCostAmountInAddlCrcy1
PostedUnbilldRblAmtInAddlCrcy1 PostedUnbilldRblAmtInAddlCrcy1
RAPostdDfrrdRevnAmtInAddlCrcy1 RAPostdDfrrdRevnAmtInAddlCrcy1
RAPostedContrAstAmtInAddlCrcy1 RAPostedContrAstAmtInAddlCrcy1
PostedContrLbltyAmtInAddlCrcy1 PostedContrLbltyAmtInAddlCrcy1
RAPostdDfrrdCostAmtInAddlCrcy1 RAPostdDfrrdCostAmtInAddlCrcy1
AdditionalCurrency2 AdditionalCurrency2 Local curr. 3
RAPostedRevenueAmtInAddlCrcy2 RAPostedRevenueAmtInAddlCrcy2
RAPostedInvoiceAmtInAddlCrcy2 RAPostedInvoiceAmtInAddlCrcy2
RAPostedCostAmountInAddlCrcy2 RAPostedCostAmountInAddlCrcy2
PostedUnbilldRblAmtInAddlCrcy2 PostedUnbilldRblAmtInAddlCrcy2
RAPostdDfrrdRevnAmtInAddlCrcy2 RAPostdDfrrdRevnAmtInAddlCrcy2
RAPostedContrAstAmtInAddlCrcy2 RAPostedContrAstAmtInAddlCrcy2
PostedContrLbltyAmtInAddlCrcy2 PostedContrLbltyAmtInAddlCrcy2
RAPostdDfrrdCostAmtInAddlCrcy2 RAPostdDfrrdCostAmtInAddlCrcy2
RAContrLiabilityAssetIsCalcd RAContrLiabilityAssetIsCalcd
DataValidationHasError DataValidationHasError
RevnAcctgPerfOblgnStatus RevnAcctgPerfOblgnStatus Perf. Oblig. Status
ValidationDateTime ValidationDateTime
RAGenLdgrCorrectionAccount RAGenLdgrCorrectionAccount
RAGenLdgrRecognitionAccount RAGenLdgrRecognitionAccount
DeltaEffectiveAmtInSlsDocCrcy DeltaEffectiveAmtInSlsDocCrcy
RADeltaRecgdCostInSlsDocCrcy RADeltaRecgdCostInSlsDocCrcy
OperationalDocItemQty OperationalDocItemQty
PerfOblgnContractualQuantity PerfOblgnContractualQuantity Quantity
CARevnRecgnQtyUnit CARevnRecgnQtyUnit
ContractualPriceCriticality ContractualPriceCriticality
TotalCostCriticality TotalCostCriticality
InvoicedAmountCriticality InvoicedAmountCriticality
OrderQuantityCriticality OrderQuantityCriticality
ActualCostCriticality ActualCostCriticality
RAContractIsInconsistent RAContractIsInconsistent
BusRecnclnItemCreatedByUser BusRecnclnItemCreatedByUser
BusRecnclnItmCreatedDateTime BusRecnclnItmCreatedDateTime

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_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 C_RABusRecnclnDetWithCndnType AS
SELECT
  CompanyCode,
  AccountingPrinciple,
  RevenueAccountingContract,
  PerformanceObligation,
  ConditionType,
  RevnAcctgOperationalDocument,
  RABusinessRecnclnViewType,
  RAOperationalDocumentItem,
  OplContractualPrcInSlsDocCrcy,
  RAOplCostAmtInSlsDocCrcy,
  TransactionCurrency,
  InvoiceCurrency,
  TotalInvoicedAmtInSlsDocCrcy,
  CostCurrency,
  RAOplCostPriceAmtInSlsDocCrcy,
  Material,
  MaterialName,
  SalesDocumentCurrency,
  ContractualPrcInSlsDocCrcy,
  RAPerfOblgnCostAmtInSlsDocCrcy,
  SSPriceInSalesDocCrcy,
  AllocatedPriceInSalesDocCrcy,
  RARecognizedRevnInSlsDocCrcy,
  RARecgdCostAmountInSlsDocCrcy,
  PerPerdInvoicedAmtInSlsDocCrcy,
  PostedRevnInSlsDocCrcy,
  PostedInvoiceAmtInSlsDocCrcy,
  RAPostedCostInSlsDocCrcy,
  RAPostedUnbilldRblsAmount,
  RADeferredRevenueInSlsDocCrcy,
  RAContractAssetsAmount,
  RAContrLiabilitiesAmount,
  PostdDfrrdCostAmtInSlsDocCrcy,
  CompanyCodeCurrency,
  RAPostedRevenueAmtInCoCodeCrcy,
  RAPostedInvoiceAmtInCoCodeCrcy,
  RAPostedCostAmountInCoCodeCrcy,
  PostdUnbilldRblAmtInCoCodeCrcy,
  PostedDfrrdRevnAmtInCoCodeCrcy,
  RAPostdContrAstAmtInCoCodeCrcy,
  PostdContrLbltyAmtInCoCodeCrcy,
  PostdDfrrdCostAmtInCoCodeCrcy,
  AdditionalCurrency1,
  RAPostedRevenueAmtInAddlCrcy1,
  RAPostedInvoiceAmtInAddlCrcy1,
  RAPostedCostAmountInAddlCrcy1,
  PostedUnbilldRblAmtInAddlCrcy1,
  RAPostdDfrrdRevnAmtInAddlCrcy1,
  RAPostedContrAstAmtInAddlCrcy1,
  PostedContrLbltyAmtInAddlCrcy1,
  RAPostdDfrrdCostAmtInAddlCrcy1,
  AdditionalCurrency2,
  RAPostedRevenueAmtInAddlCrcy2,
  RAPostedInvoiceAmtInAddlCrcy2,
  RAPostedCostAmountInAddlCrcy2,
  PostedUnbilldRblAmtInAddlCrcy2,
  RAPostdDfrrdRevnAmtInAddlCrcy2,
  RAPostedContrAstAmtInAddlCrcy2,
  PostedContrLbltyAmtInAddlCrcy2,
  RAPostdDfrrdCostAmtInAddlCrcy2,
  RAContrLiabilityAssetIsCalcd,
  DataValidationHasError,
  RevnAcctgPerfOblgnStatus,
  ValidationDateTime,
  RAGenLdgrCorrectionAccount,
  RAGenLdgrRecognitionAccount,
  DeltaEffectiveAmtInSlsDocCrcy,
  RADeltaRecgdCostInSlsDocCrcy,
  OperationalDocItemQty,
  PerfOblgnContractualQuantity,
  CARevnRecgnQtyUnit,
  ContractualPriceCriticality,
  TotalCostCriticality,
  InvoicedAmountCriticality,
  OrderQuantityCriticality,
  ActualCostCriticality,
  RAContractIsInconsistent,
  BusRecnclnItemCreatedByUser,
  BusRecnclnItmCreatedDateTime
FROM R_RABusRecnclnDetWthCndnTypeTP
;

Learn More