I_RAPostponedItem

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_RAPostponedItem.
-- 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_RAPostponedItem 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,
  cast (rai_type as farr_cds_rai_type preserving type ) AS RAItemType,
  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,
  cast (delivered_qty_diff as farr_cds_delivered_qty_diff preserving type ) AS RAItemDifferenceToDeliveredQty,
  quantity_unit AS QuantityUnit,
  waers AS SalesDocumentCurrency,
  bldat AS DocumentDate,
  kunnr AS Customer,
  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,
  partner AS BusinessPartner,
  rai_error AS RevenueAccountingItemHasError,
  postponement_reason AS RAItemPostponementReason,
  exemption_reason AS RAItemExemptionReason,
  wwert AS ExchangeRateDate,
  ignore_cost_based_copa AS RACostBasedProfAnlysIsIgnored,
  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,
  cast( ps_posid as ps_posid_edit ) 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) AS AccountAssignmentIsDtmndByRA,
  xnegative_item AS PerfObligationIsNegative,
  cast (xrecacc_det as farr_cds_xrecacc_det) 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,
  event_date AS RAFulfillmentEventDate,
  event_time AS RAFulfillmentEventTime,
  event_type AS PerfOblgnEventType,
  due_date AS RAInvoiceDueDate,
  final_invoice AS PerfOblgnIsFinallyInvoiced,
  cast (invoice_cat as farr_cds_invoice_cat preserving type ) AS RAInvoiceCategory,
  invoice_type AS RAInvoiceType,
  pinv_comp AS RAPlannedInvoiceSenderComp,
  pinv_id AS RAPlannedInvoiceItem,
  pinv_logsys AS RAPlannedInvoiceLogicalSystem,
  pinv_type AS RAPlannedInvoiceItemType,
  posting_date AS PostingDate,
  quantity_rel AS RAItemQuantityIsRelevant,
  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,
  wwert AS RAItemTranslationDate,
  cast(pob_category as farr_cds_pob_category preserving type ) AS RAPerfOblgnCategory,
  x_estimated_quan AS QuantityAndPriceIsDtmndByRA,
  amount AS FulfilledAmountInSlsDocCrcy,
  hildoc_comp AS RAHigherDocItemSenderComp,
  hildoc_logsys AS RAHigherDocItemLogicalSystem,
  hildoc_type AS RAHigherDocItemType,
  hildoc_id AS RAHigherDocItemID,
  manually_changed AS RAItemIsManuallyChanged,
  chg_timestamp_utc AS RAItemLastSaveDateTime,
  cast ( '1' as farr_cds_rai_status ) AS RAItemStatus,
  abgsl AS ResultAnalysisInternalID
FROM farr_d_inb_mi
LEFT OUTER JOIN I_RAPostponedConditionItem AS _ConditionItem ON RAItemType = _ConditionItem.RAItemType AND RevnAcctgSenderComponent = _ConditionItem.RevnAcctgSenderComponent AND RASndgCompLogicalSystem = _ConditionItem.RASndgCompLogicalSystem AND RASndgCompDocumentItemType = _ConditionItem.RASndgCompDocumentItemType AND RASndgCompDocumentItem = _ConditionItem.RASndgCompDocumentItem AND RAItemLastChangeDateTime = _ConditionItem.RAItemLastChangeDateTime  -- association [1..*]
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_RAPerfObligationEventType AS _PerfObligationEventType ON PerfOblgnEventType = _PerfObligationEventType.PerfOblgnEventType  -- 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]
;