I_RAProcdOrderConditionItem

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_RAProcdOrderConditionItem.
-- 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: IRAPROCDORDERCO

CREATE VIEW I_RAProcdOrderConditionItem AS
SELECT
  srcdoc_comp AS RevnAcctgSenderComponent,
  srcdoc_logsys AS RASndgCompLogicalSystem,
  srcdoc_type AS RASndgCompDocumentItemType,
  srcdoc_id AS RASndgCompDocumentItem,
  condition_type AS ConditionType,
  _ProcdOrderMain.RAItemLastChangeDateTime AS RAItemLastChangeDateTime,
  pl_account AS RAProfitAndLossAccount,
  betrw AS RevnAcctgPostgAmtInSlsDocCrcy,
  waers AS SalesDocumentCurrency,
  betrh AS RevnAcctgPostgAmtInCoCodeCrcy,
  hwaer AS CompanyCodeCurrency,
  betr2 AS RevnAcctgPostgAmtInAddlCrcy1,
  hwae2 AS AdditionalCurrency1,
  betr3 AS RevnAcctgPostgAmtInAddlCrcy2,
  hwae3 AS AdditionalCurrency2,
  cast (percentage as farr_cds_percentage preserving type ) AS RAConditionItemPercent,
  statistic AS RAConditionItemIsStatistical,
  category AS RevnAcctgConditionCategory,
  main_cond_type AS RAConditionItemIsMainCondition,
  xplacc_det AS ProfitLostAccountIsDtmndByRA,
  cast ( '2' as farr_cds_rai_status ) AS RAItemStatus,
  cast ( '01'as farr_cds_rai_type ) AS RAItemType,
  _ProcdOrderMain.CompanyCode AS CompanyCode
FROM farr_d_ord_co
LEFT OUTER JOIN I_RAProcdRevnAcctItem AS _ProcdOrderMain ON RevnAcctgSenderComponent = _ProcdOrderMain.RevnAcctgSenderComponent AND RASndgCompLogicalSystem = _ProcdOrderMain.RASndgCompLogicalSystem AND RASndgCompDocumentItemType = _ProcdOrderMain.RASndgCompDocumentItemType AND RASndgCompDocumentItem = _ProcdOrderMain.RASndgCompDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON SalesDocumentCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _AdditionalCurrency1 ON AdditionalCurrency1 = _AdditionalCurrency1.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _AdditionalCurrency2 ON AdditionalCurrency2 = _AdditionalCurrency2.Currency  -- association [0..1]
;