I_RABusRecnclnDetWithCndnType

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 I_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 I_RABusRecnclnDetWithCndnType AS
SELECT
  CompanyCode,
  AccountingPrinciple,
  RevenueAccountingContract,
  PerformanceObligation,
  ConditionType,
  RevnAcctgOperationalDocument,
  RABusinessRecnclnViewType,
  RAOperationalDocumentItem,
  cast(OplContractualPrcInSlsDocCrcy as farr_cds_op_cond_price preserving type) AS OplContractualPrcInSlsDocCrcy,
  cast(RAOplCostAmtInSlsDocCrcy as farr_cds_op_cond_cost preserving type) AS RAOplCostAmtInSlsDocCrcy,
  TransactionCurrency,
  InvoiceCurrency,
  cast(TotalInvoicedAmtInSlsDocCrcy as farr_opl_invoiced_amt preserving type) AS TotalInvoicedAmtInSlsDocCrcy,
  CostCurrency,
  cast(RAOplCostPriceAmtInSlsDocCrcy as farr_cds_cost_price preserving type) AS RAOplCostPriceAmtInSlsDocCrcy,
  Material,
  MaterialName,
  SalesDocumentCurrency,
  cast(ContractualPrcInSlsDocCrcy as farr_transaction_price preserving type) AS ContractualPrcInSlsDocCrcy,
  cast(RAPerfOblgnCostAmtInSlsDocCrcy as farr_cost_total preserving type) AS RAPerfOblgnCostAmtInSlsDocCrcy,
  cast(SSPriceInSalesDocCrcy as farr_cds_standalone_price preserving type) AS SSPriceInSalesDocCrcy,
  cast(AllocatedPriceInSalesDocCrcy as farr_alloc_amt preserving type) AS AllocatedPriceInSalesDocCrcy,
  cast(RARecognizedRevnInSlsDocCrcy as farr_recog_amt preserving type) AS RARecognizedRevnInSlsDocCrcy,
  cast(RARecgdCostAmountInSlsDocCrcy as farr_recog_cost preserving type) AS RARecgdCostAmountInSlsDocCrcy,
  cast(PerPerdInvoicedAmtInSlsDocCrcy as farr_invoiced_amt preserving type) AS PerPerdInvoicedAmtInSlsDocCrcy,
  cast(PostedRevnInSlsDocCrcy as farr_cds_posted_rv preserving type) AS PostedRevnInSlsDocCrcy,
  cast(PostedInvoiceAmtInSlsDocCrcy as farr_cds_posted_ic preserving type) AS PostedInvoiceAmtInSlsDocCrcy,
  cast(RAPostedCostInSlsDocCrcy as farr_cds_posted_co preserving type) AS RAPostedCostInSlsDocCrcy,
  cast(RAPostedUnbilldRblsAmount as farr_cds_posted_ur preserving type) AS RAPostedUnbilldRblsAmount,
  cast(RADeferredRevenueInSlsDocCrcy as farr_cds_posted_dr preserving type) AS RADeferredRevenueInSlsDocCrcy,
  cast(RAContractAssetsAmount as farr_cds_posted_ca preserving type) AS RAContractAssetsAmount,
  cast(RAContrLiabilitiesAmount as farr_cds_posted_cl preserving type) AS RAContrLiabilitiesAmount,
  cast(PostdDfrrdCostAmtInSlsDocCrcy as farr_cds_posted_cj preserving type) AS PostdDfrrdCostAmtInSlsDocCrcy,
  cast(RADeltaRecgdCostInSlsDocCrcy as farr_actual_cost preserving type) AS RADeltaRecgdCostInSlsDocCrcy,
  CompanyCodeCurrency,
  cast(RAPostedRevenueAmtInCoCodeCrcy as farr_cds_posted_rv_lc1 preserving type) AS RAPostedRevenueAmtInCoCodeCrcy,
  cast(RAPostedInvoiceAmtInCoCodeCrcy as farr_cds_posted_ic_lc1 preserving type) AS RAPostedInvoiceAmtInCoCodeCrcy,
  cast(RAPostedCostAmountInCoCodeCrcy as farr_cds_posted_co_lc1 preserving type) AS RAPostedCostAmountInCoCodeCrcy,
  cast(PostdUnbilldRblAmtInCoCodeCrcy as farr_cds_posted_ur_lc1 preserving type) AS PostdUnbilldRblAmtInCoCodeCrcy,
  cast(PostedDfrrdRevnAmtInCoCodeCrcy as farr_cds_posted_dr_lc1 preserving type) AS PostedDfrrdRevnAmtInCoCodeCrcy,
  cast(RAPostdContrAstAmtInCoCodeCrcy as farr_cds_posted_ca_lc1 preserving type) AS RAPostdContrAstAmtInCoCodeCrcy,
  cast(PostdContrLbltyAmtInCoCodeCrcy as farr_cds_posted_cl_lc1 preserving type) AS PostdContrLbltyAmtInCoCodeCrcy,
  cast(PostdDfrrdCostAmtInCoCodeCrcy as farr_cds_posted_cj_lc1 preserving type) AS PostdDfrrdCostAmtInCoCodeCrcy,
  AdditionalCurrency1,
  cast(RAPostedRevenueAmtInAddlCrcy1 as farr_cds_posted_rv_lc2 preserving type) AS RAPostedRevenueAmtInAddlCrcy1,
  cast(RAPostedInvoiceAmtInAddlCrcy1 as farr_cds_posted_ic_lc2 preserving type) AS RAPostedInvoiceAmtInAddlCrcy1,
  cast(RAPostedCostAmountInAddlCrcy1 as farr_cds_posted_co_lc2 preserving type) AS RAPostedCostAmountInAddlCrcy1,
  cast(PostedUnbilldRblAmtInAddlCrcy1 as farr_cds_posted_ur_lc2 preserving type) AS PostedUnbilldRblAmtInAddlCrcy1,
  cast(RAPostdDfrrdRevnAmtInAddlCrcy1 as farr_cds_posted_dr_lc2 preserving type) AS RAPostdDfrrdRevnAmtInAddlCrcy1,
  cast(RAPostedContrAstAmtInAddlCrcy1 as farr_cds_posted_ca_lc2 preserving type) AS RAPostedContrAstAmtInAddlCrcy1,
  cast(PostedContrLbltyAmtInAddlCrcy1 as farr_cds_posted_cl_lc2 preserving type) AS PostedContrLbltyAmtInAddlCrcy1,
  cast(RAPostdDfrrdCostAmtInAddlCrcy1 as farr_cds_posted_cj_lc2 preserving type) AS RAPostdDfrrdCostAmtInAddlCrcy1,
  AdditionalCurrency2,
  cast(RAPostedRevenueAmtInAddlCrcy2 as farr_cds_posted_rv_lc3 preserving type) AS RAPostedRevenueAmtInAddlCrcy2,
  cast(RAPostedInvoiceAmtInAddlCrcy2 as farr_cds_posted_ic_lc3 preserving type) AS RAPostedInvoiceAmtInAddlCrcy2,
  cast(RAPostedCostAmountInAddlCrcy2 as farr_cds_posted_co_lc3 preserving type) AS RAPostedCostAmountInAddlCrcy2,
  cast(PostedUnbilldRblAmtInAddlCrcy2 as farr_cds_posted_ur_lc3 preserving type) AS PostedUnbilldRblAmtInAddlCrcy2,
  cast(RAPostdDfrrdRevnAmtInAddlCrcy2 as farr_cds_posted_dr_lc3 preserving type) AS RAPostdDfrrdRevnAmtInAddlCrcy2,
  cast(RAPostedContrAstAmtInAddlCrcy2 as farr_cds_posted_ca_lc3 preserving type) AS RAPostedContrAstAmtInAddlCrcy2,
  cast(PostedContrLbltyAmtInAddlCrcy2 as farr_cds_posted_cl_lc3 preserving type) AS PostedContrLbltyAmtInAddlCrcy2,
  cast(RAPostdDfrrdCostAmtInAddlCrcy2 as farr_cds_posted_cj_lc3 preserving type) AS RAPostdDfrrdCostAmtInAddlCrcy2,
  cast(SrceRecgdRevnAmtInSlsDocCrcy as farr_sched_rv_cumltv preserving type) AS SrceRecgdRevnAmtInSlsDocCrcy,
  cast(SrceRecgdCostAmtInSlsDocCrcy as farr_sched_co_cumltv preserving type) AS SrceRecgdCostAmtInSlsDocCrcy,
  cast(SrceRecgdInvcAmtInSlsDocCrcy as farr_sched_ic_cumltv preserving type) AS SrceRecgdInvcAmtInSlsDocCrcy,
  RAContrLiabilityAssetIsCalcd,
  DataValidationHasError,
  RevnAcctgPerfOblgnStatus,
  ValidationDateTime,
  RAGenLdgrCorrectionAccount,
  RAGenLdgrRecognitionAccount,
  BusRecnclnItemCreatedByUser,
  BusRecnclnItmCreatedDateTime,
  cast(DeltaEffectiveAmtInSlsDocCrcy as farr_contractual_price_org preserving type) AS DeltaEffectiveAmtInSlsDocCrcy,
  OperationalDocItemQty,
  PerfOblgnContractualQuantity,
  CARevnRecgnQtyUnit,
  ContractualPriceCriticality,
  TotalCostCriticality,
  InvoicedAmountCriticality,
  OrderQuantityCriticality,
  ActualCostCriticality
FROM P_RABusRecnclnDetWithCndnType
;