P_CndnTypeAmtMngRevnContr

DDL: P_CNDNTYPEAMTMNGREVNCONTR Type: view_entity CONSUMPTION
10 Fields 2 Data Sources 2 Associations

Conditions

P_CndnTypeAmtMngRevnContr is a Consumption CDS View that provides data about "Conditions" in SAP S/4HANA. It reads from 2 data sources (I_RAPerformanceObligation, I_RevnAcctgDeferralItem) and exposes 10 fields with key fields RevenueAccountingContract, PerformanceObligation, ConditionType, RAHigherLevelPerfOblgn. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_RAPerformanceObligation RAPerformanceObligation from
I_RevnAcctgDeferralItem RevnAcctgDeferralItem inner

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_RAConditionCategoryText _RAConditionCategoryText $projection.RevnAcctgConditionCategory = _RAConditionCategoryText.RevnAcctgConditionCategory
[0..*] I_GlAccountTextInCompanycode _AccountText $projection.GLAccount = _AccountText.GLAccount and $projection.CompanyCode = _AccountText.CompanyCode

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Conditions view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #NONE view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY RevenueAccountingContract I_RevnAcctgDeferralItem RevenueAccountingContract Revenue Contract
KEY PerformanceObligation I_RevnAcctgDeferralItem PerformanceObligation Performance Obligation
KEY ConditionType I_RevnAcctgDeferralItem ConditionType Condition type
KEY RAHigherLevelPerfOblgn I_RAPerformanceObligation PerformanceObligation Performance Obligation
CompanyCode I_RevnAcctgDeferralItem CompanyCode Receiver Company Code
SalesDocumentCurrency I_RevnAcctgDeferralItem SalesDocumentCurrency Currency
RevnAcctgConditionCategory I_RevnAcctgDeferralItem RevnAcctgConditionCategory Violation Category
ConditionIsForStatistics I_RevnAcctgDeferralItem ConditionIsForStatistics Statistical
_AccountText _AccountText
_RAConditionCategoryText _RAConditionCategoryText

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_CndnTypeAmtMngRevnContr.
-- 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 P_CndnTypeAmtMngRevnContr AS
SELECT
  RevnAcctgDeferralItem.RevenueAccountingContract AS RevenueAccountingContract,
  RevnAcctgDeferralItem.PerformanceObligation AS PerformanceObligation,
  RevnAcctgDeferralItem.ConditionType AS ConditionType,
  RAPerformanceObligation.PerformanceObligation AS RAHigherLevelPerfOblgn,
  RevnAcctgDeferralItem.CompanyCode AS CompanyCode,
  RevnAcctgDeferralItem.SalesDocumentCurrency AS SalesDocumentCurrency,
  RevnAcctgDeferralItem.RevnAcctgConditionCategory AS RevnAcctgConditionCategory,
  RevnAcctgDeferralItem.ConditionIsForStatistics AS ConditionIsForStatistics
FROM I_RAPerformanceObligation AS RAPerformanceObligation
INNER JOIN I_RevnAcctgDeferralItem AS RevnAcctgDeferralItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RAConditionCategoryText AS _RAConditionCategoryText ON RevnAcctgConditionCategory = _RAConditionCategoryText.RevnAcctgConditionCategory  -- association [1..*]
LEFT OUTER JOIN I_GlAccountTextInCompanycode AS _AccountText ON GLAccount = _AccountText.GLAccount AND CompanyCode = _AccountText.CompanyCode  -- association [0..*]
;

Learn More