I_RAProcdCostRevnAcctItem

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_RAProcdCostRevnAcctItem.
-- 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: IRAPROCDCOSTRAI

CREATE VIEW I_RAProcdCostRevnAcctItem AS
SELECT
  cast (srcdoc_comp as farr_cds_rai_srcdoc_comp preserving type ) AS RevnAcctgSenderComponent,
  srcdoc_logsys AS RASndgCompLogicalSystem,
  cast (srcdoc_type as farr_cds_rai_srcdoc_type preserving type ) AS RASndgCompDocumentItemType,
  cast (srcdoc_id as farr_cds_rai_srcdoc_id preserving type ) AS RASndgCompDocumentItem,
  cast (timestamp_utc as char23 ) AS RAItemLastChangeDateTimeValue,
  bukrs AS CompanyCode,
  cast (timestamp_utc as farr_cds_rai_timestamp preserving type ) AS RAItemLastChangeDateTime,
  crea_tmstp_utc AS RAItemCreationDateTime,
  crea_user AS RevnAcctgItemCreatedByUser,
  header_id AS RevnAcctgOperationalDocument,
  hwae2 AS AdditionalCurrency1,
  hwae3 AS AdditionalCurrency2,
  hwaer AS CompanyCodeCurrency,
  item_id AS RAOperationalDocumentItem,
  log_handle AS ApplicationLogHandle,
  cast (quantity as farr_cds_quantity ) AS Quantity,
  quantity_unit AS QuantityUnit,
  waers AS SalesDocumentCurrency,
  cast (origdoc_comp as farr_cds_rai_origdoc_comp preserving type ) AS RAOriginalDocItemSenderComp,
  cast (origdoc_logsys as farr_cds_rai_origdoc_logsys preserving type ) AS RAOriginalDocItemLogicalSystem,
  cast (origdoc_type as farr_cds_rai_origdoc_type preserving type ) AS RAOriginalDocItemType,
  cast (origdoc_id as farr_cds_rai_origdoc_id preserving type ) AS RAOriginalDocItemID,
  ignore_cost_based_copa AS RACostBasedProfAnlysIsIgnored,
  posting_date AS PostingDate,
  cast ( '2' as farr_cds_rai_status ) AS RAItemStatus,
  cast ( '04'as farr_cds_rai_type ) AS RAItemType,
  is_blocked AS IsBusinessPurposeCompleted,
  manually_changed AS RAItemIsManuallyChanged
FROM farr_d_cost_mi
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON RevnAcctgItemCreatedByUser = _CreatedByUser.UserID  -- association [0..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]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON QuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
;