C_RAPerfOblgnManualSpreadingTP

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_RAPerfOblgnManualSpreadingTP.
-- 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_RAPerfOblgnManualSpreadingTP AS
SELECT
  PerformanceObligation.PerformanceObligation AS PerformanceObligation,
  PerformanceObligation.RevenueAccountingContract AS RevenueAccountingContract,
  PerformanceObligation.PerformanceObligationClass AS PerformanceObligationClass,
  PerformanceObligation.RAPerfOblgnDistinctType AS RAPerfOblgnDistinctType,
  PerformanceObligation._PerfOblgnDistinctType._Text[1:Language=$session.system_language].RAPerfOblgnDistinctTypeName AS RAPerfOblgnDistinctTypeName,
  PerformanceObligation.RevnAcctgPerfOblgnStatus AS RevnAcctgPerfOblgnStatus,
  _RAPerfOblgnStatusText.RevnAcctgPerfOblgnStatusName AS RevnAcctgPerfOblgnStatusName,
  PerformanceObligation.RAPerfOblgnCompletionDate AS RAPerfOblgnCompletionDate,
  PerformanceObligation.PerformanceObligationStartDate AS PerformanceObligationStartDate,
  PerformanceObligation.PerformanceObligationEndDate AS PerformanceObligationEndDate,
  PerformanceObligation.AccountingPrinciple AS AccountingPrinciple,
  PerformanceObligation.CompanyCode AS CompanyCode,
  PerformanceObligation.PerfOblgnHasManualSpreading AS PerfOblgnHasManualSpreading,
  PerformanceObligation.RevnAcctgSuspensionDate AS RevnAcctgSuspensionDate,
  PerformanceObligation.RevnAcctgSuspensionReason AS RevnAcctgSuspensionReason,
  _RASuspensionReasonText.RevnAcctgSuspensionReasonName AS RevnAcctgSuspensionReasonName,
  PerformanceObligation.AllocatedPriceInSalesDocCrcy AS AllocatedPriceInSalesDocCrcy,
  PerformanceObligation.RAPerfOblgnCategory AS RAPerfOblgnCategory,
  PerformanceObligation._RAPerfOblgnCategory._Text[1:Language=$session.system_language].RAPerfOblgnCategoryName AS RAPerfOblgnCategoryName,
  PerformanceObligation.PerfObligationDeferralMethod AS PerfObligationDeferralMethod,
  _DeferralMethodTxt.PerfOblgnDeferralMethodText AS PerfOblgnDeferralMethodText,
  cast (' ' as farr_manual_changed ) AS RAPerfOblgnIsSetToSystSprdg,
  cast ( 0 as farr_nmlsprdg_revntobespread ) AS RAPerfOblgnToBeSpreadRevnAmt,
  cast( ' ' as farr_mnlsprdg_is_edited ) AS RAPerfOblgnRevnSprdgIsEdited,
  PerformanceObligation.SalesDocumentCurrency AS SalesDocumentCurrency,
  cast (coalesce(_ManualChange.RAAttributeHasConflict, '') as farr_has_conflict preserving type ) AS RAAttributeHasConflict,
  PerformanceObligation._Mapping.RevnAcctgOperationalDocument AS RevnAcctgOperationalDocument,
  PerformanceObligation.PerfOblgnHasSprdgConflict AS PerfOblgnHasSprdgConflict,
  PerformanceObligation.BusinessPartner AS BusinessPartner,
  PerformanceObligation._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  PerformanceObligation.Customer AS Customer,
  PerformanceObligation._Customer.CustomerName AS CustomerName,
  _Contract.RAContrHasMnlPrcAllocConflict AS RAContrHasMnlPrcAllocConflict,
  PerformanceObligation.PerfOblgnIsSoftDeleted AS PerfOblgnIsSoftDeleted,
  PerformanceObligation.PerfOblgnFulfillmentType AS PerfOblgnFulfillmentType,
  cast (coalesce(_FreezePeriods.PerfOblgnHasPerdsWthFrozenRevn, '') as farr_cds_pob_has_frozen_perds preserving type ) AS PerfOblgnHasPerdsWthFrozenRevn,
  PerformanceObligation.PerfOblgnEffectiveQuantityUnit AS PerfOblgnEffectiveQuantityUnit,
  PerformanceObligation.RAUnivRevnRecgnIntegType AS RAUnivRevnRecgnIntegType,
  _RAUnivRevnRecgnIntegTypeText.RAUnivRevnRecgnIntegTypeName AS RAUnivRevnRecgnIntegTypeName,
  PerformanceObligation.PerfOblgnAssetImpairmentDate AS PerfOblgnAssetImpairmentDate,
  PerformanceObligation._PerfOblgnDistinctType AS _PerfOblgnDistinctType,
  PerformanceObligation._AccountingPrinciple AS _AccountingPrinciple
FROM I_RAPerformanceObligation AS PerformanceObligation
LEFT OUTER JOIN I_RAPerfOblgnStatusText AS _RAPerfOblgnStatusText ON RevnAcctgPerfOblgnStatus = _RAPerfOblgnStatusText.RevnAcctgPerfOblgnStatus AND _RAPerfOblgnStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_RASuspensionReasonText AS _RASuspensionReasonText ON RevnAcctgSuspensionReason = _RASuspensionReasonText.RevnAcctgSuspensionReason AND _RASuspensionReasonText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_RAPerfOblgnDeferralMethodTxt AS _DeferralMethodTxt ON PerfObligationDeferralMethod = _DeferralMethodTxt.PerfObligationDeferralMethod AND _DeferralMethodTxt.Language = $session.system_language  -- association [1..*]
LEFT OUTER JOIN I_RAUnivRevnRecgnIntegTypeText AS _RAUnivRevnRecgnIntegTypeText ON RAUnivRevnRecgnIntegType = _RAUnivRevnRecgnIntegTypeText.RAUnivRevnRecgnIntegType AND _RAUnivRevnRecgnIntegTypeText.Language = $session.system_language  -- association [1..*]
LEFT OUTER JOIN C_RAMnlRevnSprdgByPeriodTP AS _RAMnlRevnSprdgByPeriod ON /* condition not available in parsed metadata */  -- association [0..*]
;