C_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 C_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 C_CATransfRecdToRA AS
SELECT
  CARevenueAcctgDocumentItem,
  RevnAcctgSenderComponent,
  RASndgCompLogicalSystem,
  RASndgCompDocumentItemType,
  RASndgCompDocumentItem,
  RAItemCreationDateTime,
  RevnAcctgOperationalDocument,
  RAOperationalDocumentItem,
  CARevenueAccountingServiceType,
  RADocumentCreationDate,
  RADocumentCreationTime,
  CASendingDate,
  CASendingTime,
  CASendingDateTime,
  Customer,
  _Customer.BPCustomerFullName AS BPCustomerFullName,
  BusinessPartner,
  _BusinessPartner.FirstName AS FirstName,
  _BusinessPartner.LastName AS LastName,
  _BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  ContractAccount,
  _ContractAccountHeader.ContractAccountName AS ContractAccountName,
  CAContract,
  CAProviderContractItemNumber,
  CASubApplication,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  AmountInTransactionCurrency,
  TransactionCurrency,
  CompanyCodeCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  CARevenueAcctgQuantity,
  CARevenueAcctgQuantityUnit,
  RAItemQuantityIsRelevant,
  RAOriginalDocItemSenderComp,
  RAOriginalDocItemLogicalSystem,
  RAOriginalDocItemType,
  RAOriginalDocItemID,
  RAInvoiceDueDate,
  RAInvoiceType,
  RAInvoiceCategory,
  PerfOblgnIsFinallyInvoiced,
  CAInvoicingDocument,
  CAInvcgRevenueGrouping,
  PostingDate,
  RAFulfillmentEventDate,
  RAFulfillmentEventTime,
  PerfOblgnEventType,
  IsReversed,
  IsMarkedForDeletion,
  AbsoluteExchangeRate,
  ExchRateIsIndirectQuotation,
  AddlCrcy1AbsoluteExchangeRate,
  AddlCrcy1ExchRateIsIndrctQtan,
  AddlCrcy2AbsoluteExchangeRate,
  AddlCrcy2ExchRateIsIndrctQtan,
  CARevenueAccountingRefType,
  RevenueAccountingReference,
  BusinessArea,
  ProfitCenter,
  Segment,
  _Segment._Text.SegmentName as SegmentName : localized AS SegmentNameasSegmentNamelocalized,
  PerformanceObligationStartDate,
  PerformanceObligationEndDate,
  RAHigherDocItemSenderComp,
  RAHigherDocItemLogicalSystem,
  RAHigherDocItemType,
  RAHigherDocItemID,
  RevnAcctgSalesOrganization,
  PerfObligationInceptionDate,
  RAInvoiceAmountIsRelevant,
  PerfObligationChangeReason,
  CAProduct,
  _CAProduct._CAProductText.CAProductText as CAProductText : localized AS CAProductTextasCAProductTextlocalized,
  CASalesPackageProduct,
  Division,
  _Division._Text.DivisionName as DivisionName : localized AS DivisionNameasDivisionNamelocalized,
  DistributionChannel,
  QuantityAndPriceIsDtmndByRA,
  CASubAreaForParallelization,
  ReceivableAccountIsDtmndByRA,
  AccountAssignmentIsDtmndByRA,
  CATransfRecdToRAChangeCode,
  RevnAcctgReceivablesAccount,
  RAItemType,
  _RAItemType._Text.RAItemTypeName as RAItemTypeName : localized AS RAItemTypeNameasRAItemTypeNamelocalized,
  CARevenueAcctgMigrationPackage,
  RADocItemIsCreatedByInitLoad,
  RAPerfOblgnFinalizationDate,
  RAPredecessorDocItemSenderComp,
  RAPredecessorDocItemLgclSystem,
  RAPredecessorDocItemType,
  RAPredecessorDocItemID,
  CACrtnMethOfTransfRecordsToRA,
  RevnAcctgContrChangeEffctvDate,
  PerfOblgnHasAssetImpairment,
  CASubscriptionChargeType,
  OrderID,
  _Order.OrderDescription AS OrderDescription,
  WBSElementInternalID,
  _WBSElementBasicData.WBSDescription AS WBSDescription,
  SoldProduct,
  _Material._Text.MaterialName as SoldProductName : localized AS MaterialNameasSoldProductNamelocalized,
  PrvdrContrItmIsRlvtForPrfSgDrv,
  CABillgPlnNumber
FROM I_CATransfRecdToRA
;