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_RABusRecnclnConditionType.
-- 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_RABusRecnclnConditionType 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,
SuspendedRevnAmtInSlsDocCrcy,
SuspendedCostAmtInSlsDocCrcy,
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
;