I_CATransfRecdToRA

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_CATransfRecdToRA.
-- 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_CATransfRecdToRA AS
SELECT
  cast (rai_id as rai_id_gfn_kk preserving type) AS CARevenueAcctgDocumentItem,
  cast (srcdoc_comp as rai_srcco_gfn_kk preserving type) AS RevnAcctgSenderComponent,
  srcdoc_logsys AS RASndgCompLogicalSystem,
  cast(srcdoc_type as rai_srcty_gfn_kk preserving type ) AS RASndgCompDocumentItemType,
  cast (srcdoc_id as rai_srcid_gfn_kk preserving type) AS RASndgCompDocumentItem,
  cast(timestamp_utc as tzntstmps) AS RAItemCreationDateTime,
  header_id AS RevnAcctgOperationalDocument,
  item_id AS RAOperationalDocumentItem,
  service_type AS CARevenueAccountingServiceType,
  crdate AS RADocumentCreationDate,
  crtime AS RADocumentCreationTime,
  sentdate AS CASendingDate,
  senttime AS CASendingTime,
  cast(sentts as tzntstmps) AS CASendingDateTime,
  kunnr AS Customer,
  partner AS BusinessPartner,
  vkont AS ContractAccount,
  vtref AS CAContract,
  vtpos AS CAProviderContractItemNumber,
  subap AS CASubApplication,
  bukrs AS CompanyCode,
  cast(betrw as rai_mi_amount_tc_gfn_kk preserving type) AS AmountInTransactionCurrency,
  waers AS TransactionCurrency,
  hwaer AS CompanyCodeCurrency,
  hwae2 AS AdditionalCurrency1,
  hwae3 AS AdditionalCurrency2,
  quantity AS CARevenueAcctgQuantity,
  quantity_unit AS CARevenueAcctgQuantityUnit,
  quantity_rel AS RAItemQuantityIsRelevant,
  cast(origdoc_comp as rai_orico_gfn_kk preserving type) AS RAOriginalDocItemSenderComp,
  cast(origdoc_logsys as rai_orils_gfn_kk preserving type) AS RAOriginalDocItemLogicalSystem,
  cast(origdoc_type as rai_ority_gfn_kk preserving type) AS RAOriginalDocItemType,
  cast(origdoc_id as rai_oriid_gfn_kk preserving type) AS RAOriginalDocItemID,
  due_date AS RAInvoiceDueDate,
  invoice_type AS RAInvoiceType,
  cast(invoice_cat as rai_invoice_cat_gfn_kk preserving type) AS RAInvoiceCategory,
  final_invoice AS PerfOblgnIsFinallyInvoiced,
  invdocno AS CAInvoicingDocument,
  ra_invgr AS CAInvcgRevenueGrouping,
  posting_date AS PostingDate,
  event_date AS RAFulfillmentEventDate,
  event_time AS RAFulfillmentEventTime,
  event_type AS PerfOblgnEventType,
  reversal AS IsReversed,
  deletion_ind AS IsMarkedForDeletion,
  cast(abs(exchange_rate) as rai_kursf_abs_kk preserving type) AS AbsoluteExchangeRate,
  cast(abs(exchange_rate2) as rai_kurs2_abs_kk preserving type) AS AddlCrcy1AbsoluteExchangeRate,
  cast(abs(exchange_rate3) as rai_kurs3_abs_kk preserving type) AS AddlCrcy2AbsoluteExchangeRate,
  reference_type AS CARevenueAccountingRefType,
  reference_id AS RevenueAccountingReference,
  gsber AS BusinessArea,
  prctr AS ProfitCenter,
  Segment,
  start_date AS PerformanceObligationStartDate,
  end_date AS PerformanceObligationEndDate,
  cast (hildoc_comp as rai_hldco_gfn_kk preserving type) AS RAHigherDocItemSenderComp,
  cast(hildoc_logsys as rai_hldls_gfn_kk preserving type) AS RAHigherDocItemLogicalSystem,
  cast(hildoc_type as rai_hldty_gfn_kk preserving type) AS RAHigherDocItemType,
  cast(hildoc_id as rai_hldid_gfn_kk preserving type) AS RAHigherDocItemID,
  sales_org AS RevnAcctgSalesOrganization,
  inception_date AS PerfObligationInceptionDate,
  value_relevant AS RAInvoiceAmountIsRelevant,
  chrsn AS PerfObligationChangeReason,
  prdnr AS CAProduct,
  cast(prdnr_sp as rai_prdsp_gfn_kk preserving type) AS CASalesPackageProduct,
  spart AS Division,
  vtweg AS DistributionChannel,
  cast(x_estimated_quan as rai_x_estimated_quan_gfn_kk preserving type) AS QuantityAndPriceIsDtmndByRA,
  keypp AS CASubAreaForParallelization,
  cast (xrecacc_det as rai_xrecacc_det_gfn_kk preserving type) AS ReceivableAccountIsDtmndByRA,
  cast (xaccass_det as rai_xaccass_det_gfn_kk preserving type) AS AccountAssignmentIsDtmndByRA,
  chind AS CATransfRecdToRAChangeCode,
  receiv_account AS RevnAcctgReceivablesAccount,
  cast(item_type as rai_item_type_gfn_kk preserving type) AS RAItemType,
  mig_package AS CARevenueAcctgMigrationPackage,
  cast(initial_load as rai_xinitial_load_gfn_kk preserving type) AS RADocItemIsCreatedByInitLoad,
  final_date AS RAPerfOblgnFinalizationDate,
  cast(predoc_comp as rai_predoc_comp_gfn_kk preserving type ) AS RAPredecessorDocItemSenderComp,
  cast(predoc_logsys as rai_predoc_ls_gfn_kk preserving type) AS RAPredecessorDocItemLgclSystem,
  cast(predoc_type as rai_predoc_ty_gfn_kk preserving type) AS RAPredecessorDocItemType,
  predoc_id AS RAPredecessorDocItemID,
  crmet AS CACrtnMethOfTransfRecordsToRA,
  effective_date AS RevnAcctgContrChangeEffctvDate,
  cast (asset_impairment as rai_asset_impairment_gfn_kk preserving type) AS PerfOblgnHasAssetImpairment,
  charge_type AS CASubscriptionChargeType,
  aufnr AS OrderID,
  cast ( ps_psp_pnr as ps_s4_proj_pspnr preserving type ) AS WBSElementInternalID,
  matnr_copa AS SoldProduct,
  cast(x_vt_copa as x_vt_copa_gfn preserving type) AS PrvdrContrItmIsRlvtForPrfSgDrv,
  billplanno AS CABillgPlnNumber
FROM dfkkra_rai_mi
LEFT OUTER JOIN I_RevnAcctgSenderComponent AS _RevnAcctgSenderComponent ON RevnAcctgSenderComponent = _RevnAcctgSenderComponent.RevnAcctgSenderComponent  -- association [0..1]
LEFT OUTER JOIN I_LogicalSystem AS _RASndgCompLogicalSystem ON RASndgCompLogicalSystem = _RASndgCompLogicalSystem.LogicalSystem  -- association [0..1]
LEFT OUTER JOIN I_RASndgCompDocumentItemType AS _RASndgCompDocumentItemType ON RASndgCompDocumentItemType = _RASndgCompDocumentItemType.RASndgCompDocumentItemType  -- association [0..1]
LEFT OUTER JOIN I_CARevnAcctgServiceType AS _CARevnAcctgServiceType ON CARevenueAccountingServiceType = _CARevnAcctgServiceType.CARevenueAccountingServiceType  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _ContractAccountHeader ON ContractAccount = _ContractAccountHeader.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_CASubApplication AS _CASubApplication ON CASubApplication = _CASubApplication.CASubApplication  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.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 _CARevenueAcctgQuantityUnit ON CARevenueAcctgQuantityUnit = _CARevenueAcctgQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_RevnAcctgSenderComponent AS _RAOriginalDocItemSenderComp ON RAOriginalDocItemSenderComp = _RAOriginalDocItemSenderComp.RevnAcctgSenderComponent  -- association [0..1]
LEFT OUTER JOIN I_LogicalSystem AS _RAOriginalDocItemLogicalSyst ON RAOriginalDocItemLogicalSystem = _RAOriginalDocItemLogicalSyst.LogicalSystem  -- association [0..1]
LEFT OUTER JOIN I_RASndgCompDocumentItemType AS _RAOriginalDocItemType ON RAOriginalDocItemType = _RAOriginalDocItemType.RASndgCompDocumentItemType  -- association [0..1]
LEFT OUTER JOIN I_RAInvoiceType AS _RAInvoiceType ON RAInvoiceType = _RAInvoiceType.RAInvoiceType  -- association [0..1]
LEFT OUTER JOIN I_RAItemInvoiceItemCat AS _RAInvoiceCategory ON RAInvoiceCategory = _RAInvoiceCategory.RAInvoiceCategory  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgDocHeader AS _CAInvcgDocHeader ON CAInvoicingDocument = _CAInvcgDocHeader.CAInvoicingDocument  -- association [0..1]
LEFT OUTER JOIN I_RAPerfObligationEventType AS _PerfOblgnEventType ON PerfOblgnEventType = _PerfOblgnEventType.PerfOblgnEventType  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _Segment ON Segment = _Segment.Segment  -- association [0..1]
LEFT OUTER JOIN I_RevnAcctgSenderComponent AS _RAHigherDocItemSenderComp ON RAHigherDocItemSenderComp = _RAHigherDocItemSenderComp.RevnAcctgSenderComponent  -- association [0..1]
LEFT OUTER JOIN I_LogicalSystem AS _RAHigherDocItemLogicalSystem ON RAHigherDocItemLogicalSystem = _RAHigherDocItemLogicalSystem.LogicalSystem  -- association [0..1]
LEFT OUTER JOIN I_RASndgCompDocumentItemType AS _RAHigherDocItemType ON RAHigherDocItemType = _RAHigherDocItemType.RASndgCompDocumentItemType  -- association [0..1]
LEFT OUTER JOIN I_RAContrManualChgBusinessRsn AS _PerfObligationChangeReason ON PerfObligationChangeReason = _PerfObligationChangeReason.RAContrManualChgBusinessReason  -- association [0..1]
LEFT OUTER JOIN I_CAProduct AS _CAProduct ON CAProduct = _CAProduct.CAProduct  -- association [0..1]
LEFT OUTER JOIN I_CAProduct AS _CASalesPackageProduct ON CASalesPackageProduct = _CASalesPackageProduct.CAProduct  -- 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_CATransfRecdToRAChangeCode AS _CATransfRecdToRAChangeCode ON CATransfRecdToRAChangeCode = _CATransfRecdToRAChangeCode.CATransfRecdToRAChangeCode  -- association [0..1]
LEFT OUTER JOIN I_RAItemType AS _RAItemType ON RAItemType = _RAItemType.RAItemType  -- association [0..1]
LEFT OUTER JOIN I_RevnAcctgSenderComponent AS _RAPredecessorDocItemSndrComp ON RAPredecessorDocItemSenderComp = _RAPredecessorDocItemSndrComp.RevnAcctgSenderComponent  -- association [0..1]
LEFT OUTER JOIN I_LogicalSystem AS _RAPredecessorDocItemLgclSyst ON RAPredecessorDocItemLgclSystem = _RAPredecessorDocItemLgclSyst.LogicalSystem  -- association [0..1]
LEFT OUTER JOIN I_RASndgCompDocumentItemType AS _RAPredecessorDocItemType ON RAPredecessorDocItemType = _RAPredecessorDocItemType.RASndgCompDocumentItemType  -- association [0..1]
LEFT OUTER JOIN I_CASubscriptionChargeType AS _CASubscriptionChargeType ON CASubscriptionChargeType = _CASubscriptionChargeType.CASubscriptionChargeType  -- association [0..1]
LEFT OUTER JOIN I_OrderBasic AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON SoldProduct = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_CACrtnMethOfTransfRecdToRA AS _CACrtnMethOfTransfRecdToRA ON CACrtnMethOfTransfRecordsToRA = _CACrtnMethOfTransfRecdToRA.CACrtnMethOfTransfRecordsToRA  -- association [0..1]
LEFT OUTER JOIN I_CABillgPln AS _CABillgPln ON CABillgPlnNumber = _CABillgPln.CABillgPlnNumber  -- association [0..1]
LEFT OUTER JOIN I_CATransfRecdToRACondition AS _CATransfRecdToRACondition ON /* condition not available in parsed metadata */  -- association [0..*]
;