I_MPBillPlanFixed

DDL: I_MPBILLPLANFIXED SQL: IBPFP Type: view BASIC
9 Fields 1 Data Sources 1 Associations

Mstr Proj Billing Plan Fixed Plan

I_MPBillPlanFixed is a Basic CDS View that provides data about "Mstr Proj Billing Plan Fixed Plan" in SAP S/4HANA. It reads from 1 data source (P_MstrProjBillPlanFixed) and exposes 9 fields with key fields BillingPlan, SalesDocument. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_MstrProjBillPlanFixed BillingPlan from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_MPBillPlanFixed _ExtensionFixed $projection.BillingPlan = _ExtensionFixed.BillingPlan

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IBPFP view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Mstr Proj Billing Plan Fixed Plan view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY BillingPlan P_MstrProjBillPlanFixed BillingPlan Bill. Plan No.
KEY SalesDocument P_MstrProjBillPlanFixed SalesDocument SD Document
SalesDocumentItem P_MstrProjBillPlanFixed SalesDocumentItem Sales Document Item
NetAmount P_MstrProjBillPlanFixed NetAmount Stated Amount
SDDocumentStatus P_MstrProjBillPlanFixed SDDocumentStatus Status
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_MPBillPlanFixed.
-- 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: IBPFP

CREATE VIEW I_MPBillPlanFixed AS
SELECT
  BillingPlan.BillingPlan AS BillingPlan,
  BillingPlan.SalesDocument AS SalesDocument,
  BillingPlan.SalesDocumentItem AS SalesDocumentItem,
  BillingPlan.NetAmount AS NetAmount,
  BillingPlan.SDDocumentStatus AS SDDocumentStatus,
  MasterProject,
  MasterProjectIsConfidential,
  MasterProjectOrganization,
  MasterProjectType
FROM P_MstrProjBillPlanFixed AS BillingPlan
LEFT OUTER JOIN E_MPBillPlanFixed AS _ExtensionFixed ON BillingPlan = _ExtensionFixed.BillingPlan  -- association [0..1]
;

Learn More