P_RABusRecnclnDetWithHeaderId

DDL: P_RABUSRECNCLNDETWITHHEADERID Type: view_entity COMPOSITE Package: ODATA_FARR_BIZ_RECON
87 Fields 1 Data Sources

Business Reconciliation Detail with Header id

P_RABusRecnclnDetWithHeaderId is a Composite CDS View that provides data about "Business Reconciliation Detail with Header id" in SAP S/4HANA. It reads from 1 data source (P_RABusRecnclnDetWithCndnType) and exposes 87 fields with key fields CompanyCode, AccountingPrinciple, RevenueAccountingContract, PerformanceObligation, ConditionType. Part of development package ODATA_FARR_BIZ_RECON.

Data Sources (1)

SourceAliasJoin Type
P_RABusRecnclnDetWithCndnType P_RABusRecnclnDetWithCndnType 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 (87)

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
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
RADeltaRecgdCostInSlsDocCrcy RADeltaRecgdCostInSlsDocCrcy
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
ValidationDateTime ValidationDateTime
RevnAcctgPerfOblgnStatus RevnAcctgPerfOblgnStatus Perf. Oblig. Status
RAGenLdgrCorrectionAccount RAGenLdgrCorrectionAccount
RAGenLdgrRecognitionAccount RAGenLdgrRecognitionAccount
BusRecnclnItemCreatedByUser BusRecnclnItemCreatedByUser
BusRecnclnItmCreatedDateTime BusRecnclnItmCreatedDateTime
DeltaEffectiveAmtInSlsDocCrcy DeltaEffectiveAmtInSlsDocCrcy
SrceRecgdRevnAmtInSlsDocCrcy SrceRecgdRevnAmtInSlsDocCrcy
SrceRecgdCostAmtInSlsDocCrcy SrceRecgdCostAmtInSlsDocCrcy
SrceRecgdInvcAmtInSlsDocCrcy SrceRecgdInvcAmtInSlsDocCrcy
OperationalDocItemQty OperationalDocItemQty
PerfOblgnContractualQuantity PerfOblgnContractualQuantity Quantity
CARevnRecgnQtyUnit CARevnRecgnQtyUnit
ContractualPriceCriticality ContractualPriceCriticality
TotalCostCriticality TotalCostCriticality
InvoicedAmountCriticality InvoicedAmountCriticality
OrderQuantityCriticality OrderQuantityCriticality
ActualCostCriticality ActualCostCriticality
RevnAcctgContractStatus
BusinessPartner
Customer
IsBusinessPurposeCompleted
_Mapping _Mapping
_Contract _Contract

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_RABusRecnclnDetWithHeaderId.
-- 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_RABusRecnclnDetWithHeaderId AS
SELECT
  CompanyCode,
  AccountingPrinciple,
  RevenueAccountingContract,
  PerformanceObligation,
  ConditionType,
  P_RABusRecnclnDetWithCndnType._Mapping.RevnAcctgOperationalDocument AS 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,
  RADeltaRecgdCostInSlsDocCrcy,
  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,
  ValidationDateTime,
  RevnAcctgPerfOblgnStatus,
  RAGenLdgrCorrectionAccount,
  RAGenLdgrRecognitionAccount,
  BusRecnclnItemCreatedByUser,
  BusRecnclnItmCreatedDateTime,
  DeltaEffectiveAmtInSlsDocCrcy,
  SrceRecgdRevnAmtInSlsDocCrcy,
  SrceRecgdCostAmtInSlsDocCrcy,
  SrceRecgdInvcAmtInSlsDocCrcy,
  OperationalDocItemQty,
  PerfOblgnContractualQuantity,
  CARevnRecgnQtyUnit,
  ContractualPriceCriticality,
  TotalCostCriticality,
  InvoicedAmountCriticality,
  OrderQuantityCriticality,
  ActualCostCriticality,
  P_RABusRecnclnDetWithCndnType._Contract.RevnAcctgContractStatus AS RevnAcctgContractStatus,
  P_RABusRecnclnDetWithCndnType._Contract.BusinessPartner AS BusinessPartner,
  P_RABusRecnclnDetWithCndnType._Contract.Customer AS Customer,
  P_RABusRecnclnDetWithCndnType._Contract.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM P_RABusRecnclnDetWithCndnType
;

Learn More