P_RevenueAccountingItem

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 P_RevenueAccountingItem.
-- 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: PREVNACCTITEM

CREATE VIEW P_RevenueAccountingItem AS
SELECT
  RASndgCompLogicalSystem,
  RevnAcctgSenderComponent,
  RASndgCompDocumentItemType,
  RASndgCompDocumentItem,
  RAItemType,
  RAItemLastChangeDateTimeValue,
  RAItemLastChangeDateTime,
  RAItemCreationDateTime,
  RevnAcctgItemCreatedByUser,
  RevnAcctgOperationalDocument,
  AdditionalCurrency1,
  AdditionalCurrency2,
  CompanyCodeCurrency,
  RAOperationalDocumentItem,
  Quantity,
  RAItemDifferenceToDeliveredQty,
  QuantityUnit,
  SalesDocumentCurrency,
  DocumentDate,
  RAItemTranslationDate,
  Customer,
  RAOriginalDocItemSenderComp,
  RAOriginalDocItemType,
  RAOriginalDocItemID,
  RAOriginalDocItemLogicalSystem,
  BusinessPartner,
  RevnAcctgAssetImpairment,
  PerfOblgnHasAssetImpairment,
  OrderID,
  RABillingPlanType,
  RAItemIsBillingRelevant,
  PerfObligationChangeReason,
  PerfObligationInceptionDate,
  PerfObligationIsToBeDeleted,
  RAItemIsDeliveryRelevant,
  RevnAcctgContrChangeEffctvDate,
  PerformanceObligationStartDate,
  PerformanceObligationEndDate,
  CostCenter,
  RAPredecessorDocItemSenderComp,
  RAPredecessorDocItemLgclSystem,
  RAPredecessorDocItemType,
  RAPredecessorDocItemID,
  WBSElementExternalID,
  RevnAcctgReceivablesAccount,
  RevenueAccountingReference,
  RevenueAccountingRefType,
  RevnAcctgSalesOrganization,
  RAInvoiceAmountIsRelevant,
  AccountAssignmentIsDtmndByRA,
  PerfObligationIsNegative,
  ReceivableAccountIsDtmndByRA,
  CAProduct,
  CARevenueAccountingServiceType,
  SalesDocumentType,
  StorageLocation,
  Material,
  OriginSDDocumentItem,
  SalesDocumentItemCategory,
  OriginSDDocument,
  SDDocumentCategory,
  RAFulfillmentEventDate,
  RAFulfillmentEventTime,
  PerfOblgnEventType,
  RAInvoiceDueDate,
  ExchangeRate,
  AdditionalCrcy1ExchangeRate,
  AdditionalCrcy2ExchangeRate,
  PerfOblgnIsFinallyInvoiced,
  RAInvoiceCategory,
  RAInvoiceType,
  PostingDate,
  CompanyCode,
  FunctionalArea,
  BusinessArea,
  CustomerGroup,
  MaterialGroup,
  ProfitCenter,
  Segment,
  Division,
  DistributionChannel,
  Plant,
  RAPerfOblgnFinalizationDate,
  RevenueAccountingItemHasError,
  RAItemPostponementReason,
  RAItemExemptionReason,
  RAPerfOblgnCategory,
  RAItemQuantityIsRelevant,
  QuantityAndPriceIsDtmndByRA,
  RACostBasedProfAnlysIsIgnored,
  FulfilledAmountInSlsDocCrcy,
  cast (ApplicationLogHandle as char22 ) AS ApplicationLogHandle,
  cast (RAItemLastChangeDateTime as char23 ) AS ApplicationLogDateTimeValue,
  RevnAcctgOrderHeader,
  RAItemStatus,
  RAItemLastSaveDateTime,
  RAItemIsManuallyChanged,
  ResultAnalysisInternalID,
  cast ('A' as farr_rai_origin_type preserving type ) AS RAItemOriginType,
  'X' AS RAContractHasPostponedItem,
  _OrdItem2._BusinessPartner AS _BusinessPartner,
  _OrdItem2._Customer AS _Customer
FROM P_RAPostponedItmWthOrderHdr AS PostPonedMainItem
LEFT OUTER JOIN P_RADistinctMappingKeys AS _DistinctMapping ON RAOriginalDocItemSenderComp = _DistinctMapping.RevnAcctgSenderComponent AND RAOriginalDocItemLogicalSystem = _DistinctMapping.RASndgCompLogicalSystem AND RevnAcctgOrderHeader = _DistinctMapping.RevnAcctgOperationalDocument  -- association [1..1]
LEFT OUTER JOIN I_RAProcdRevnAcctItem AS _OrdItem2 ON _OrdItem2.RevnAcctgSenderComponent = ProcdFlfmtMainItem.RAOriginalDocItemSenderComp AND _OrdItem2.RASndgCompLogicalSystem = ProcdFlfmtMainItem.RAOriginalDocItemLogicalSystem AND _OrdItem2.RASndgCompDocumentItemType = ProcdFlfmtMainItem.RAOriginalDocItemType AND _OrdItem2.RASndgCompDocumentItem = ProcdFlfmtMainItem.RAOriginalDocItemID  -- association [1..1]
LEFT OUTER JOIN I_RAProcdRevnAcctItem AS _OrdItem3 ON RAOriginalDocItemSenderComp = _OrdItem3.RevnAcctgSenderComponent AND RAOriginalDocItemLogicalSystem = _OrdItem3.RASndgCompLogicalSystem AND RAOriginalDocItemType = _OrdItem3.RASndgCompDocumentItemType AND RAOriginalDocItemID = _OrdItem3.RASndgCompDocumentItem  -- association [1..1]
-- UNION ALL with additional select branch(es): I_RAProcdRevnAcctItem, I_RAProcdFlfmtRevnAcctItem, I_RAProcdInvoiceRevnAcctItem
;