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