I_RAProcdRevnAcctItem

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_RAProcdRevnAcctItem.
-- 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 I_RAProcdRevnAcctItem AS
SELECT
  srcdoc_comp AS RevnAcctgSenderComponent,
  srcdoc_logsys AS RASndgCompLogicalSystem,
  srcdoc_type AS RASndgCompDocumentItemType,
  srcdoc_id AS RASndgCompDocumentItem,
  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,
  paobjnr AS ProfitabilitySegment,
  cast(quantity as farr_cds_quantity) AS Quantity,
  quantity_unit AS QuantityUnit,
  waers AS SalesDocumentCurrency,
  kunnr AS Customer,
  partner AS BusinessPartner,
  asset_impairment AS RevnAcctgAssetImpairment,
  aufnr AS OrderID,
  bill_plan_type AS RABillingPlanType,
  bilrel AS RAItemIsBillingRelevant,
  business_change_reason AS PerfObligationChangeReason,
  delrel AS RAItemIsDeliveryRelevant,
  effective_date AS RevnAcctgContrChangeEffctvDate,
  end_date AS PerformanceObligationEndDate,
  inception_date AS PerfObligationInceptionDate,
  kostl AS CostCenter,
  cast(predoc_comp as farr_cds_rai_predoc_comp preserving type) AS RAPredecessorDocItemSenderComp,
  cast(predoc_logsys as farr_cds_rai_predoc_logsys preserving type) AS RAPredecessorDocItemLgclSystem,
  cast(predoc_type as farr_cds_rai_predoc_type preserving type) AS RAPredecessorDocItemType,
  predoc_id AS RAPredecessorDocItemID,
  cast(ps_psp_pnr as ps_s4_pspnr preserving type) AS WBSElementInternalID,
  _WBSElement.WBSElementExternalID AS WBSElementExternalID,
  receiv_account AS RevnAcctgReceivablesAccount,
  reference_id AS RevenueAccountingReference,
  reference_type AS RevenueAccountingRefType,
  sales_org AS RevnAcctgSalesOrganization,
  start_date AS PerformanceObligationStartDate,
  value_relevant AS RAInvoiceAmountIsRelevant,
  cast(xaccass_det as farr_cds_xaccass_det preserving type) AS AccountAssignmentIsDtmndByRA,
  xnegative_item AS PerfObligationIsNegative,
  cast(xrecacc_det as farr_cds_xrecacc_det preserving type) AS ReceivableAccountIsDtmndByRA,
  prdnr AS CAProduct,
  service_type AS CARevenueAccountingServiceType,
  auart AS SalesDocumentType,
  lgort AS StorageLocation,
  matnr AS Material,
  posnv AS OriginSDDocumentItem,
  pstyv AS SalesDocumentItemCategory,
  vbelv AS OriginSDDocument,
  vbtyp AS SDDocumentCategory,
  bukrs AS CompanyCode,
  fkber AS FunctionalArea,
  kdgrp AS CustomerGroup,
  matkl AS MaterialGroup,
  prctr AS ProfitCenter,
  Segment,
  spart AS Division,
  vtweg AS DistributionChannel,
  werks AS Plant,
  final_date AS RAPerfOblgnFinalizationDate,
  gsber AS BusinessArea,
  cast(pob_category as farr_cds_pob_category preserving type) AS RAPerfOblgnCategory,
  x_estimated_quan AS QuantityAndPriceIsDtmndByRA,
  hildoc_comp AS RAHigherDocItemSenderComp,
  hildoc_logsys AS RAHigherDocItemLogicalSystem,
  hildoc_type AS RAHigherDocItemType,
  hildoc_id AS RAHigherDocItemID,
  is_blocked AS IsBusinessPurposeCompleted,
  cast(abap.char'2' as farr_cds_rai_status preserving type) AS RAItemStatus,
  cast(abap.char'01' as farr_cds_rai_type preserving type) AS RAItemType,
  manually_changed AS RAItemIsManuallyChanged,
  abgsl AS ResultAnalysisInternalID
FROM farr_d_ord_mi
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
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_SalesOrganization AS _SalesOrganization ON RevnAcctgSalesOrganization = _SalesOrganization.SalesOrganization  -- 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_Order AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CostCenter = _CostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _ReceivablesAccount ON RevnAcctgReceivablesAccount = _ReceivablesAccount.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_SalesDocumentType AS _SalesDocumentType ON SalesDocumentType = _SalesDocumentType.SalesDocumentType  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_CustomerGroup AS _CustomerGroup ON CustomerGroup = _CustomerGroup.CustomerGroup  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItemCategory AS _SalesDocumentItemCategory ON SalesDocumentItemCategory = _SalesDocumentItemCategory.SalesDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentCategory AS _SDDocumentCategory ON SDDocumentCategory = _SDDocumentCategory.SDDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_CARevnAcctgServiceType AS _RevnAcctgServiceType ON CARevenueAccountingServiceType = _RevnAcctgServiceType.CARevenueAccountingServiceType  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _Segment ON Segment = _Segment.Segment  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON QuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_RAPerfOblgnCategory AS _RAPerfOblgnCategory ON RAPerfOblgnCategory = _RAPerfOblgnCategory.RAPerfOblgnCategory  -- association [1..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
;