P_RevenueRecognitionWBSElement

DDL: P_REVENUERECOGNITIONWBSELEMENT SQL: PIRRWBSELEMENT Type: view CONSUMPTION
12 Fields 1 Data Sources 1 Associations

P_RevenueRecognitionWBSElement is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_WBSElementByInternalKey) and exposes 12 fields with key field WBSElementInternalID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_WBSElementByInternalKey I_WBSElementByInternalKey from

Associations (1)

CardinalityTargetAliasCondition
[1..1] P_RevnRecgnWBSElementPeriod _RevnRecgnWBSElementPeriod $projection.WBSElementInternalID = _RevnRecgnWBSElementPeriod.WBSElementInternalID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PIRRWBSELEMENT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY WBSElementInternalID WBSElementInternalID WBS Internal ID
WBSDescription WBSDescription WBS Element Name
WBSElementObject WBSElementObject Object number
WBSElementIsBillingElement WBSElementIsBillingElement Billing elem.
ProjectInternalID ProjectInternalID Project Def.
CompanyCode CompanyCode Receiver Company Code
Currency Currency Valuation Crcy
ResultAnalysisInternalID ResultAnalysisInternalID Results Analysis Key
ToFiscalYearPeriod _RevnRecgnWBSElementPeriod ToFiscalYearPeriod
RevnRecgnAcctAssgmtObjIntID WBS Internal ID
RevnRecgnAcctAssignmentObject WBS Internal ID
RevnRecgnAcctAssgmtObjectType

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_RevenueRecognitionWBSElement.
-- 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: PIRRWBSELEMENT

CREATE VIEW P_RevenueRecognitionWBSElement AS
SELECT
  WBSElementInternalID,
  WBSDescription,
  WBSElementObject,
  WBSElementIsBillingElement,
  ProjectInternalID,
  CompanyCode,
  Currency,
  ResultAnalysisInternalID,
  _RevnRecgnWBSElementPeriod.ToFiscalYearPeriod AS ToFiscalYearPeriod,
  cast(WBSElementInternalID as fco_accountassignmentobjectid preserving type ) AS RevnRecgnAcctAssgmtObjIntID,
  cast(WBSElement as fco_accountassignmentobject preserving type ) AS RevnRecgnAcctAssignmentObject,
  cast('PR' as fco_accountassignmenttype preserving type ) AS RevnRecgnAcctAssgmtObjectType
FROM I_WBSElementByInternalKey
LEFT OUTER JOIN P_RevnRecgnWBSElementPeriod AS _RevnRecgnWBSElementPeriod ON WBSElementInternalID = _RevnRecgnWBSElementPeriod.WBSElementInternalID  -- association [1..1]
;

Learn More