I_BPMasterProject

DDL: I_BPMASTERPROJECT SQL: IBPMASTPROJ Type: view COMPOSITE
36 Fields 2 Data Sources 6 Associations

Master Project Billing Plans

I_BPMasterProject is a Composite CDS View (Dimension) that provides data about "Master Project Billing Plans" in SAP S/4HANA. It reads from 2 data sources (I_BPAllData, P_MPStructureElement) and exposes 36 fields with key fields MasterProject, BillingPlan, BillingPlanItem, SalesDocument, SalesDocumentItem. It has 6 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_BPAllData BillingPlan inner
P_MPStructureElement Hierarchy from

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_Customer _Customer _Customer.Customer = BillingPlan.SoldToParty
[0..1] I_SalesDocument _SalesDocument $projection.SalesDocument = _SalesDocument.SalesDocument
[0..1] I_SalesDocumentItem _SalesDocumentItem $projection.SalesDocument = _SalesDocumentItem.SalesDocument and $projection.SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem
[0..1] E_MPBillPlanRRB _ExtensionRRB $projection.BillingPlan = _ExtensionRRB.BillingPlan
[0..1] E_MPBillPlanBAP _ExtensionBAP $projection.BillingPlan = _ExtensionBAP.BillingPlan
[0..1] E_MPBillPlanFixed _ExtensionFixed $projection.BillingPlan = _ExtensionFixed.BillingPlan

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IBPMASTPROJ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
EndUserText.label Master Project Billing Plans view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
AccessControl.personalData.blocking #REQUIRED view
Metadata.allowExtensions true view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY MasterProject P_MPStructureElement MasterProject Project ID
KEY BillingPlan I_BPAllData BillingPlan Bill. Plan No.
KEY BillingPlanItem I_BPAllData BillingPlanItem Item
KEY SalesDocument I_BPAllData SalesDocument SD Document
KEY SalesDocumentItem I_BPAllData SalesDocumentItem Sales Document Item
MasterProjectName P_MPStructureElement MasterProjectName
MasterProjectIsConfidential P_MPStructureElement MasterProjectIsConfidential
MasterProjectType P_MPStructureElement MasterProjectType
MasterProjectOrganization P_MPStructureElement MasterProjectOrganization
ControllingObjectExternalID
ControllingObjectDescription P_MPStructureElement ControllingObjectDescription Item Descr.
BillingDate I_BPAllData BillingDate Billing Date
PostingDate I_BPAllData PostingDate Posting Date for GR
PricingDate I_BPAllData PricingDate Pricing Date
EventType I_BPAllData EventType Event date type
BillingEventTypeName I_BPAllData BillingEventTypeName
BillingPlanBillingDateText I_BPAllData BillingPlanBillingDateText
SDDocumentStatus I_BPAllData SDDocumentStatus
DocumentStatusName I_BPAllData DocumentStatusName Status Text
DocumentStatusDesc I_BPAllData DocumentStatusDesc
MaterialDesc
MaterialName I_BPAllData MaterialName Material Description
NetAmount
MstrProjResourceQuantity I_BPAllData MstrProjResourceQuantity
TransactionCurrency I_BPAllData TransactionCurrency Transaction Currency
UnitOfMeasure I_BPAllData UnitOfMeasure Unit Protected Qty
BillingBlockReasonDescription I_BPAllData BillingBlockReasonDescription
IsBillingCreatedInAdvance I_BPAllData IsBillingCreatedInAdvance
BillingPlanCategoryName I_BPAllData BillingPlanCategoryName
BillingPlanRuleName I_BPAllData BillingPlanRuleName
SoldToParty I_BPAllData SoldToParty Sold-to Party
CustomerName _Customer CustomerName Name of Customer
SalesOrganization _SalesDocument SalesOrganization Sales Organization
_Customer _Customer
_SalesDocument _SalesDocument
_SalesDocumentItem _SalesDocumentItem

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_BPMasterProject.
-- 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: IBPMASTPROJ

CREATE VIEW I_BPMasterProject AS
SELECT
  Hierarchy.MasterProject AS MasterProject,
  BillingPlan.BillingPlan AS BillingPlan,
  BillingPlan.BillingPlanItem AS BillingPlanItem,
  BillingPlan.SalesDocument AS SalesDocument,
  BillingPlan.SalesDocumentItem AS SalesDocumentItem,
  Hierarchy.MasterProjectName AS MasterProjectName,
  Hierarchy.MasterProjectIsConfidential AS MasterProjectIsConfidential,
  Hierarchy.MasterProjectType AS MasterProjectType,
  Hierarchy.MasterProjectOrganization AS MasterProjectOrganization,
  ltrim(Hierarchy.ControllingObjectExternalID,'0') AS ControllingObjectExternalID,
  Hierarchy.ControllingObjectDescription AS ControllingObjectDescription,
  BillingPlan.BillingDate AS BillingDate,
  BillingPlan.PostingDate AS PostingDate,
  BillingPlan.PricingDate AS PricingDate,
  BillingPlan.EventType AS EventType,
  BillingPlan.BillingEventTypeName AS BillingEventTypeName,
  BillingPlan.BillingPlanBillingDateText AS BillingPlanBillingDateText,
  BillingPlan.SDDocumentStatus AS SDDocumentStatus,
  BillingPlan.DocumentStatusName AS DocumentStatusName,
  BillingPlan.DocumentStatusDesc AS DocumentStatusDesc,
  cast(BillingPlan.MaterialDesc as /cpd/cpm_description ) AS MaterialDesc,
  BillingPlan.MaterialName AS MaterialName,
  cast(BillingPlan.NetAmount as /cpd/cpm_billingvalue) AS NetAmount,
  BillingPlan.MstrProjResourceQuantity AS MstrProjResourceQuantity,
  BillingPlan.TransactionCurrency AS TransactionCurrency,
  BillingPlan.UnitOfMeasure AS UnitOfMeasure,
  BillingPlan.BillingBlockReasonDescription AS BillingBlockReasonDescription,
  BillingPlan.IsBillingCreatedInAdvance AS IsBillingCreatedInAdvance,
  BillingPlan.BillingPlanCategoryName AS BillingPlanCategoryName,
  BillingPlan.BillingPlanRuleName AS BillingPlanRuleName,
  BillingPlan.SoldToParty AS SoldToParty,
  _Customer.CustomerName AS CustomerName,
  _SalesDocument.SalesOrganization AS SalesOrganization
FROM P_MPStructureElement AS Hierarchy
INNER JOIN I_BPAllData AS BillingPlan ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Customer AS _Customer ON _Customer.Customer = BillingPlan.SoldToParty  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesDocumentItem ON SalesDocument = _SalesDocumentItem.SalesDocument AND SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN E_MPBillPlanRRB AS _ExtensionRRB ON BillingPlan = _ExtensionRRB.BillingPlan  -- association [0..1]
LEFT OUTER JOIN E_MPBillPlanBAP AS _ExtensionBAP ON BillingPlan = _ExtensionBAP.BillingPlan  -- association [0..1]
LEFT OUTER JOIN E_MPBillPlanFixed AS _ExtensionFixed ON BillingPlan = _ExtensionFixed.BillingPlan  -- association [0..1]
;

Learn More