C_RRBProposal

DDL: C_RRBPROPOSAL SQL: CRRBPRPSL Type: view CONSUMPTION
24 Fields 1 Data Sources 1 Associations

Billing Proposal Details

C_RRBProposal is a Consumption CDS View that provides data about "Billing Proposal Details" in SAP S/4HANA. It reads from 1 data source (P_RRBProposal) and exposes 24 fields with key fields BillingPlan, BillingPlanItem, SalesOrder, SalesOrderItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_RRBProposal P_RRBProposal from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Customer _Customer $projection.Customer = _Customer.Customer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CRRBPRPSL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Billing Proposal Details view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY BillingPlan BillingPlan Bill. Plan No.
KEY BillingPlanItem BillingPlanItem Item
KEY SalesOrder SalesOrder SD Document
KEY SalesOrderItem SalesOrderItem Sales Order Item
BillingPlanRelatedBillgStatus BillingPlanRelatedBillgStatus
BillingPlanAmount BillingPlanAmount
Currency TransactionCurrency Transaction Currency
EngagementProject EngagementProject Engmnt Project ID
ProjectName EngagementProjectName
EngagementProjectUUID EngagementProjectUUID Engmnt Project UUID
Customer Customer Sold-to Party
CustomerName CustomerName Name of Customer
BillingDate BillingDate Billing Date
BillingDocumentDate BillingDocumentDate Billing Date
BillingPlanItemUsage BillingPlanItemUsage Usage
PostponementReason PostponementReason
BillingPlanUsageCategory BillingPlanUsageCategory
BillingPlanItemUsageName
ApplicationJobName ApplicationJobName Job Name
IsInProcess IsInProcess
IsBusinessPurposeCompleted _Customer IsBusinessPurposeCompleted Purpose Completed
SalesDocumentItemText _SalesDocumentItem SalesDocumentItemText Item Descr.
_SalesDocumentItem _SalesDocumentItem
_TransactionCurrency _TransactionCurrency

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_RRBProposal.
-- 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: CRRBPRPSL

CREATE VIEW C_RRBProposal AS
SELECT
  BillingPlan,
  BillingPlanItem,
  SalesOrder,
  SalesOrderItem,
  BillingPlanRelatedBillgStatus,
  BillingPlanAmount,
  TransactionCurrency AS Currency,
  EngagementProject,
  EngagementProjectName AS ProjectName,
  EngagementProjectUUID,
  Customer,
  CustomerName,
  BillingDate,
  BillingDocumentDate,
  BillingPlanItemUsage,
  PostponementReason,
  BillingPlanUsageCategory,
  _BillingPlanItemUsageText[ Language = $session.system_language ].BillingPlanItemUsageName AS BillingPlanItemUsageName,
  ApplicationJobName,
  IsInProcess,
  _Customer.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _SalesDocumentItem.SalesDocumentItemText AS SalesDocumentItemText
FROM P_RRBProposal
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [1..1]
;

Learn More