C_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 C_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 C_RAPostponedItem AS
SELECT
  RASndgCompLogicalSystem,
  RevnAcctgSenderComponent,
  RASndgCompDocumentItemType,
  RASndgCompDocumentItem,
  RAItemType,
  RAItemLastChangeDateTimeValue,
  case when RAItmIsPrtlyProcdForAcctgPrncp = 'X' then '3' when RAItemExemptionReason is not initial then '4' else MainItem.RAItemStatus end as RAItemStatus AS RAItemStatusendasRAItemStatus,
  RAItemLastChangeDateTime,
  RAItemCreationDateTime,
  CreationDate,
  CreationTime,
  CreatedByUserDescription,
  RevnAcctgItemCreatedByUser,
  RevnAcctgOperationalDocument,
  AdditionalCurrency1,
  AdditionalCurrency2,
  CompanyCodeCurrency,
  RAOperationalDocumentItem,
  Quantity,
  RAItemDifferenceToDeliveredQty,
  QuantityUnit,
  SalesDocumentCurrency,
  DocumentDate,
  RAItemTranslationDate,
  Customer,
  CustomerName,
  RAOriginalDocItemSenderComp,
  RAOriginalDocItemType,
  RAOriginalDocItemID,
  RAOriginalDocItemLogicalSystem,
  BusinessPartner,
  BusinessPartnerName,
  RevnAcctgAssetImpairment,
  _RevnAcctgAssetImpairment[1:Language =$session.system_language].RevnAcctgAssetImpairmentName AS RevnAcctgAssetImpairmentName,
  PerfOblgnHasAssetImpairment,
  OrderID,
  RABillingPlanType,
  RAItemIsBillingRelevant,
  PerfObligationChangeReason,
  PerfObligationInceptionDate,
  PerfObligationIsToBeDeleted,
  RAItemIsDeliveryRelevant,
  RevnAcctgContrChangeEffctvDate,
  PerformanceObligationStartDate,
  PerformanceObligationEndDate,
  CostCenter,
  RAPredecessorDocItemSenderComp,
  RAPredecessorDocItemLgclSystem,
  RAPredecessorDocItemType,
  RAPredecessorDocItemID,
  WBSElementExternalID,
  RevnAcctgReceivablesAccount,
  RevenueAccountingReference,
  RevenueAccountingRefType,
  _RAItemReferenceTypeText[1:Language =$session.system_language].RevenueAccountingRefTypeName AS RevenueAccountingRefTypeName,
  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.CompanyCodeName AS CompanyCodeName,
  CompanyCode,
  FunctionalArea,
  _FunctionalAreaText.FunctionalAreaName AS FunctionalAreaName,
  BusinessArea,
  _BusinessAreaText.BusinessAreaName AS BusinessAreaName,
  CustomerGroup,
  MaterialGroup,
  ProfitCenter,
  Segment,
  _SegmentText.SegmentName AS SegmentName,
  Division,
  DistributionChannel,
  Plant,
  RAPerfOblgnFinalizationDate,
  RevenueAccountingItemHasError,
  RAItemPostponementReason,
  RAPerfOblgnCategory,
  RAItemQuantityIsRelevant,
  QuantityAndPriceIsDtmndByRA,
  RACostBasedProfAnlysIsIgnored,
  FulfilledAmountInSlsDocCrcy,
  ApplicationLogHandle,
  ApplicationLogDateTimeValue,
  RAItemIsOrderRelated,
  RAItemIsFulfillmentRelated,
  RAItemIsInvoiceRelated,
  RAItemIsCostRelated,
  RAItemTypeName,
  RAItemExemptionReason,
  _RAItemExemptionReasonText.RAItemExemptionReasonName AS RAItemExemptionReasonName,
  RevnAcctgOrderHeader,
  RAContractHasPostponedItem,
  RAItemLastSaveDateTime,
  RAItemIsManuallyChanged,
  RAItmIsPrtlyProcdForAcctgPrncp,
  cast('' as boole_d) AS RAItemEditAuthznCheckIsPassed,
  ResultAnalysisInternalID,
  cast('' as boole_d) AS RAItemExemptIsAuthorized
FROM I_MngRAPostponedItem AS MainItem
LEFT OUTER JOIN C_RAPostponedConditionObjPg 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 [*]
LEFT OUTER JOIN C_RevenueAccountingMapping AS _RevenueAccountingMapping ON RAOriginalDocItemSenderComp = _RevenueAccountingMapping.RevnAcctgSenderComponent AND RAOriginalDocItemLogicalSystem = _RevenueAccountingMapping.RASndgCompLogicalSystem AND RAOriginalDocItemType = _RevenueAccountingMapping.RASndgCompDocumentItemType AND RAOriginalDocItemID = _RevenueAccountingMapping.RASndgCompDocumentItem  -- association [*]
LEFT OUTER JOIN E_RAPostponedItem AS _E_RAItemExtensibility ON RevnAcctgSenderComponent = _E_RAItemExtensibility.RevnAcctgSenderComponent AND RASndgCompDocumentItem = _E_RAItemExtensibility.RASndgCompDocumentItem AND RASndgCompDocumentItemType = _E_RAItemExtensibility.RASndgCompDocumentItemType AND RASndgCompLogicalSystem = _E_RAItemExtensibility.RASndgCompLogicalSystem AND RAItemLastChangeDateTime = _E_RAItemExtensibility.RAItemLastChangeDateTime AND RAItemType = _E_RAItemExtensibility.RAItemType  -- association [1..1]
LEFT OUTER JOIN E_RAProcdRevnAcctItem AS _E_RAProcdRevnAcctItem ON RevnAcctgSenderComponent = _E_RAProcdRevnAcctItem.RevnAcctgSenderComponent AND RASndgCompDocumentItem = _E_RAProcdRevnAcctItem.RASndgCompDocumentItem AND RASndgCompDocumentItemType = _E_RAProcdRevnAcctItem.RASndgCompDocumentItemType AND RASndgCompLogicalSystem = _E_RAProcdRevnAcctItem.RASndgCompLogicalSystem AND RAItemLastChangeDateTime = _E_RAProcdRevnAcctItem.RAItemLastChangeDateTime  -- association [1..1]
LEFT OUTER JOIN I_RAItemStatusText AS _ItemStatusText ON RAItemStatus = _ItemStatusText.RAItemStatus  -- association [1..*]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON _BusinessAreaText.BusinessArea = BusinessArea AND _BusinessAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionalAreaText ON _FunctionalAreaText.FunctionalArea = FunctionalArea AND _FunctionalAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SegmentText AS _SegmentText ON _SegmentText.Segment = Segment AND _SegmentText.Language = $session.system_language  -- association [0..1]
;