I_RAProcdFlfmtRevnAcctItem

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_RAProcdFlfmtRevnAcctItem.
-- 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: IRAPROCDFLFRAI

CREATE VIEW I_RAProcdFlfmtRevnAcctItem AS
SELECT
  srcdoc_comp AS RevnAcctgSenderComponent,
  srcdoc_logsys AS RASndgCompLogicalSystem,
  srcdoc_type AS RASndgCompDocumentItemType,
  srcdoc_id AS RASndgCompDocumentItem,
  header_id AS RevnAcctgOperationalDocument,
  bukrs AS CompanyCode,
  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,
  event_type AS PerfOblgnEventType,
  cast (timestamp_utc as farr_cds_rai_timestamp preserving type ) AS RAItemLastChangeDateTime,
  crea_tmstp_utc AS RAItemCreationDateTime,
  crea_user AS RevnAcctgItemCreatedByUser,
  item_id AS RAOperationalDocumentItem,
  log_handle AS ApplicationLogHandle,
  cast (quantity as farr_cds_quantity ) AS Quantity,
  cast (delivered_qty_diff as farr_cds_delivered_qty_diff preserving type ) AS RAItemDifferenceToDeliveredQty,
  quantity_unit AS QuantityUnit,
  waers AS SalesDocumentCurrency,
  amount AS FulfilledAmountInSlsDocCrcy,
  event_date AS RAFulfillmentEventDate,
  event_time AS RAFulfillmentEventTime,
  is_blocked AS IsBusinessPurposeCompleted,
  cast ( '2' as farr_cds_rai_status ) AS RAItemStatus,
  cast ( '02'as farr_cds_rai_type ) AS RAItemType,
  manually_changed AS RAItemIsManuallyChanged
FROM farr_d_flfmt_mi
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_RAPerfObligationEventType AS _PerfObligationEventType ON PerfOblgnEventType = _PerfObligationEventType.PerfOblgnEventType  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON QuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON SalesDocumentCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON RevnAcctgItemCreatedByUser = _CreatedByUser.UserID  -- association [0..1]
;