I_MPBillPlanRRB

DDL: I_MPBILLPLANRRB SQL: IMPRRB Type: view BASIC
8 Fields 1 Data Sources 1 Associations

Master Project Billing Plan RRB

I_MPBillPlanRRB is a Basic CDS View that provides data about "Master Project Billing Plan RRB" in SAP S/4HANA. It reads from 1 data source (P_MstrProjBILLPLANRRB) and exposes 8 fields with key field BillingPlan. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_MstrProjBILLPLANRRB BillingPlan from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_MPBillPlanRRB _ExtensionRRB $projection.BillingPlan = _ExtensionRRB.BillingPlan

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IMPRRB view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Master Project Billing Plan RRB view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY BillingPlan P_MstrProjBILLPLANRRB BillingPlan Bill. Plan No.
BillingDate P_MstrProjBILLPLANRRB BillingDate Billing Date
SalesDocument P_MstrProjBILLPLANRRB SalesDocument SD Document
SalesDocumentItem P_MstrProjBILLPLANRRB SalesDocumentItem Sales Document Item
MasterProject MasterProject Project ID
MasterProjectIsConfidential MasterProjectIsConfidential Confidential
MasterProjectOrganization MasterProjectOrganization Service Org.
MasterProjectType MasterProjectType Mass Processing Type

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_MPBillPlanRRB.
-- 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: IMPRRB

CREATE VIEW I_MPBillPlanRRB AS
SELECT
  BillingPlan.BillingPlan AS BillingPlan,
  BillingPlan.BillingDate AS BillingDate,
  BillingPlan.SalesDocument AS SalesDocument,
  BillingPlan.SalesDocumentItem AS SalesDocumentItem,
  MasterProject,
  MasterProjectIsConfidential,
  MasterProjectOrganization,
  MasterProjectType
FROM P_MstrProjBILLPLANRRB AS BillingPlan
LEFT OUTER JOIN E_MPBillPlanRRB AS _ExtensionRRB ON BillingPlan = _ExtensionRRB.BillingPlan  -- association [0..1]
;

Learn More