I_RAPerformanceObligationTP

DDL: I_RAPERFORMANCEOBLIGATIONTP SQL: IRAPERFOBLGTP Type: view TRANSACTIONAL

Manage Performance Obligation TP

I_RAPerformanceObligationTP is a Transactional CDS View that provides data about "Manage Performance Obligation TP" in SAP S/4HANA. It reads from 1 data source (I_RAPerfOblgnWithToCurPerdAmt) and exposes 47 fields with key field PerformanceObligation. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_RAPerfOblgnWithToCurPerdAmt PerfOblgn from

Associations (2)

CardinalityTargetAliasCondition
[0..1] P_RAPerfOblgnHasFreezeDate RAPerfOblgnHasFreezeDate $projection.PerformanceObligation = RAPerfOblgnHasFreezeDate.PerformanceObligation
[0..1] P_RAPerfOblgnIsFrozen RAPerfOblgnIsFrozen $projection.PerformanceObligation = RAPerfOblgnIsFrozen.PerformanceObligation

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IRAPERFOBLGTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Manage Performance Obligation TP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.preserveKey true view

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY PerformanceObligation I_RAPerfOblgnWithToCurPerdAmt PerformanceObligation Performance Obligation
RevenueAccountingContract I_RAPerfOblgnWithToCurPerdAmt RevenueAccountingContract Revenue Contract
PerformanceObligationClass I_RAPerfOblgnWithToCurPerdAmt PerformanceObligationClass Performance Obligation Name
RevnAcctgPerfOblgnStatus I_RAPerfOblgnWithToCurPerdAmt RevnAcctgPerfOblgnStatus Perf. Oblig. Status
RAPerfOblgnCompletionDate I_RAPerfOblgnWithToCurPerdAmt RAPerfOblgnCompletionDate Completion Date
SalesDocumentCurrency I_RAPerfOblgnWithToCurPerdAmt SalesDocumentCurrency Currency
ContractualPrcInSlsDocCrcy I_RAPerfOblgnWithToCurPerdAmt ContractualPrcInSlsDocCrcy Contractual Price
SSPriceInSalesDocCrcy I_RAPerfOblgnWithToCurPerdAmt SSPriceInSalesDocCrcy Standalone Selling Price
AllocatedPriceInSalesDocCrcy I_RAPerfOblgnWithToCurPerdAmt AllocatedPriceInSalesDocCrcy Allocated Amount
AllocEffctAmountInSalesDocCrcy I_RAPerfOblgnWithToCurPerdAmt AllocEffctAmountInSalesDocCrcy Allocation Effect
PerfOblgnEffectiveQuantityUnit I_RAPerfOblgnWithToCurPerdAmt PerfOblgnEffectiveQuantityUnit Unit of Measure
PerfOblgnEffectiveQuantity I_RAPerfOblgnWithToCurPerdAmt PerfOblgnEffectiveQuantity Effective Quantity
PerfOblgnFulfillmentType I_RAPerfOblgnWithToCurPerdAmt PerfOblgnFulfillmentType Fulfillment Type
PerfOblgnEventType I_RAPerfOblgnWithToCurPerdAmt PerfOblgnEventType Event Type
RevnAcctgOperationalDocument I_RAPerfOblgnWithToCurPerdAmt RevnAcctgOperationalDocument
RevnAcctgSenderComponent I_RAPerfOblgnWithToCurPerdAmt RevnAcctgSenderComponent Sender Component
PerfOblgnStartDateType I_RAPerfOblgnWithToCurPerdAmt PerfOblgnStartDateType Start Date Type
PerformanceObligationStartDate I_RAPerfOblgnWithToCurPerdAmt PerformanceObligationStartDate Start Date
PerformanceObligationEndDate I_RAPerfOblgnWithToCurPerdAmt PerformanceObligationEndDate End Date
PerfObligationDeferralMethod I_RAPerfOblgnWithToCurPerdAmt PerfObligationDeferralMethod Deferral Method
PerfOblgnContractualQuantity I_RAPerfOblgnWithToCurPerdAmt PerfOblgnContractualQuantity Quantity
PerfOblgnContractualQtyUnit I_RAPerfOblgnWithToCurPerdAmt PerfOblgnContractualQtyUnit Unit of Measure
SSPriceToleranceAmount I_RAPerfOblgnWithToCurPerdAmt SSPriceToleranceAmount SSP Tolerance
SSPriceTolerancePercent I_RAPerfOblgnWithToCurPerdAmt SSPriceTolerancePercent SSP Tolerance Percentage
SSPriceToleranceMethod I_RAPerfOblgnWithToCurPerdAmt SSPriceToleranceMethod Single-Character Flag
RAPerfOblgnInvoiceEffectType I_RAPerfOblgnWithToCurPerdAmt RAPerfOblgnInvoiceEffectType Invoice Effect
PerUnitSSPriceInSlsDocCrcy I_RAPerfOblgnWithToCurPerdAmt PerUnitSSPriceInSlsDocCrcy SSP per Unit
PerfOblgnIsExclFromPriceAlloc I_RAPerfOblgnWithToCurPerdAmt PerfOblgnIsExclFromPriceAlloc Excluded from Allocation
PerfOblgnIsFullyFulfilled I_RAPerfOblgnWithToCurPerdAmt PerfOblgnIsFullyFulfilled Is Fully Fulfilled
PerfOblgnIsFinallyInvoiced I_RAPerfOblgnWithToCurPerdAmt PerfOblgnIsFinallyInvoiced Final Invoice
BusinessPartner I_RAPerfOblgnWithToCurPerdAmt BusinessPartner Issuing Authority
BusinessPartnerName
Customer I_RAPerfOblgnWithToCurPerdAmt Customer Sold-to Party
CustomerName
CostCenter I_RAPerfOblgnWithToCurPerdAmt CostCenter Cost Center
ProfitCenter I_RAPerfOblgnWithToCurPerdAmt ProfitCenter Profit Center
WBSElementExternalID I_RAPerfOblgnWithToCurPerdAmt WBSElementExternalID WBS Element External ID
Segment I_RAPerfOblgnWithToCurPerdAmt Segment Segment number
CompanyCode I_RAPerfOblgnWithToCurPerdAmt CompanyCode Receiver Company Code
RevnAcctgSalesOrganization I_RAPerfOblgnWithToCurPerdAmt RevnAcctgSalesOrganization Sales Org.
AccountingPrinciple I_RAPerfOblgnWithToCurPerdAmt AccountingPrinciple AP Ledger/CoCode
PerfOblgnCreatedByUser I_RAPerfOblgnWithToCurPerdAmt PerfOblgnCreatedByUser Created By
PerfOblgnCreationDate I_RAPerfOblgnWithToCurPerdAmt PerfOblgnCreationDate Created On
PerfOblgnLastChangeDate I_RAPerfOblgnWithToCurPerdAmt PerfOblgnLastChangeDate Changed on
PerfOblgnLastChangedByUsr I_RAPerfOblgnWithToCurPerdAmt PerfOblgnLastChangedByUsr Last Changed By
RAFulfillmentTypeIsTimeBased I_RAPerfOblgnWithToCurPerdAmt RAFulfillmentTypeIsTimeBased TRUE
RAFulfillmentTypeIsEventBased I_RAPerfOblgnWithToCurPerdAmt RAFulfillmentTypeIsEventBased TRUE

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_RAPerformanceObligationTP.
-- 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: IRAPERFOBLGTP

CREATE VIEW I_RAPerformanceObligationTP AS
SELECT
  PerfOblgn.PerformanceObligation AS PerformanceObligation,
  PerfOblgn.RevenueAccountingContract AS RevenueAccountingContract,
  PerfOblgn.PerformanceObligationClass AS PerformanceObligationClass,
  PerfOblgn.RevnAcctgPerfOblgnStatus AS RevnAcctgPerfOblgnStatus,
  PerfOblgn.RAPerfOblgnCompletionDate AS RAPerfOblgnCompletionDate,
  PerfOblgn.SalesDocumentCurrency AS SalesDocumentCurrency,
  PerfOblgn.ContractualPrcInSlsDocCrcy AS ContractualPrcInSlsDocCrcy,
  PerfOblgn.SSPriceInSalesDocCrcy AS SSPriceInSalesDocCrcy,
  PerfOblgn.AllocatedPriceInSalesDocCrcy AS AllocatedPriceInSalesDocCrcy,
  PerfOblgn.AllocEffctAmountInSalesDocCrcy AS AllocEffctAmountInSalesDocCrcy,
  PerfOblgn.PerfOblgnEffectiveQuantityUnit AS PerfOblgnEffectiveQuantityUnit,
  PerfOblgn.PerfOblgnEffectiveQuantity AS PerfOblgnEffectiveQuantity,
  PerfOblgn.PerfOblgnFulfillmentType AS PerfOblgnFulfillmentType,
  PerfOblgn.PerfOblgnEventType AS PerfOblgnEventType,
  PerfOblgn.RevnAcctgOperationalDocument AS RevnAcctgOperationalDocument,
  PerfOblgn.RevnAcctgSenderComponent AS RevnAcctgSenderComponent,
  PerfOblgn.PerfOblgnStartDateType AS PerfOblgnStartDateType,
  PerfOblgn.PerformanceObligationStartDate AS PerformanceObligationStartDate,
  PerfOblgn.PerformanceObligationEndDate AS PerformanceObligationEndDate,
  PerfOblgn.PerfObligationDeferralMethod AS PerfObligationDeferralMethod,
  PerfOblgn.PerfOblgnContractualQuantity AS PerfOblgnContractualQuantity,
  PerfOblgn.PerfOblgnContractualQtyUnit AS PerfOblgnContractualQtyUnit,
  PerfOblgn.SSPriceToleranceAmount AS SSPriceToleranceAmount,
  PerfOblgn.SSPriceTolerancePercent AS SSPriceTolerancePercent,
  PerfOblgn.SSPriceToleranceMethod AS SSPriceToleranceMethod,
  PerfOblgn.RAPerfOblgnInvoiceEffectType AS RAPerfOblgnInvoiceEffectType,
  PerfOblgn.PerUnitSSPriceInSlsDocCrcy AS PerUnitSSPriceInSlsDocCrcy,
  PerfOblgn.PerfOblgnIsExclFromPriceAlloc AS PerfOblgnIsExclFromPriceAlloc,
  PerfOblgn.PerfOblgnIsFullyFulfilled AS PerfOblgnIsFullyFulfilled,
  PerfOblgn.PerfOblgnIsFinallyInvoiced AS PerfOblgnIsFinallyInvoiced,
  PerfOblgn.BusinessPartner AS BusinessPartner,
  PerfOblgn._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  PerfOblgn.Customer AS Customer,
  PerfOblgn._Customer.CustomerName AS CustomerName,
  PerfOblgn.CostCenter AS CostCenter,
  PerfOblgn.ProfitCenter AS ProfitCenter,
  PerfOblgn.WBSElementExternalID AS WBSElementExternalID,
  PerfOblgn.Segment AS Segment,
  PerfOblgn.CompanyCode AS CompanyCode,
  PerfOblgn.RevnAcctgSalesOrganization AS RevnAcctgSalesOrganization,
  PerfOblgn.AccountingPrinciple AS AccountingPrinciple,
  PerfOblgn.PerfOblgnCreatedByUser AS PerfOblgnCreatedByUser,
  PerfOblgn.PerfOblgnCreationDate AS PerfOblgnCreationDate,
  PerfOblgn.PerfOblgnLastChangeDate AS PerfOblgnLastChangeDate,
  PerfOblgn.PerfOblgnLastChangedByUsr AS PerfOblgnLastChangedByUsr,
  PerfOblgn.RAFulfillmentTypeIsTimeBased AS RAFulfillmentTypeIsTimeBased,
  PerfOblgn.RAFulfillmentTypeIsEventBased AS RAFulfillmentTypeIsEventBased
FROM I_RAPerfOblgnWithToCurPerdAmt AS PerfOblgn
LEFT OUTER JOIN P_RAPerfOblgnHasFreezeDate AS RAPerfOblgnHasFreezeDate ON PerformanceObligation = RAPerfOblgnHasFreezeDate.PerformanceObligation  -- association [0..1]
LEFT OUTER JOIN P_RAPerfOblgnIsFrozen AS RAPerfOblgnIsFrozen ON PerformanceObligation = RAPerfOblgnIsFrozen.PerformanceObligation  -- association [0..1]
;