I_MPBillingSummary

DDL: I_MPBILLINGSUMMARY SQL: IMPBILLSUMMARY Type: view COMPOSITE
34 Fields 4 Data Sources 3 Associations

Master Project Billing and Receivable Summary

I_MPBillingSummary is a Composite CDS View that provides data about "Master Project Billing and Receivable Summary" in SAP S/4HANA. It reads from 4 data sources (I_MPCustomerClearedItem, I_MstrProjAcctDocHdr, I_BillingDocumentItem, I_MstrProjBillDocItem) and exposes 34 fields with key fields SalesDocument, SalesDocumentItem, BillingDocument. It has 3 associations to related views.

Data Sources (4)

SourceAliasJoin Type
I_MPCustomerClearedItem _ClearingAccountingDocument left_outer
I_MstrProjAcctDocHdr AccountDocumentHeader left_outer
I_BillingDocumentItem BillingDocumentItem inner
I_MstrProjBillDocItem BillingDocumentItemTable inner

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_MPPartialPayment _PartiallyReceivable $projection.BillingDocument = _PartiallyReceivable.BillingDocument
[0..1] I_SalesDocument _SalesDocument $projection.SalesDocument = _SalesDocument.SalesDocument
[0..1] I_Customer _Customer $projection.soldtoparty = _Customer.Customer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMPBILLSUMMARY view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Master Project Billing and Receivable Summary view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument Hierarchy SalesDocument SD Document
KEY SalesDocumentItem Hierarchy SalesDocumentItem Sales Document Item
KEY BillingDocument I_BillingDocumentItem BillingDocument SD Document
SDDocumentCategory Hierarchy SDDocumentCategory Document Cat.
BillingQuantity I_BillingDocumentItem BillingQuantity Invoiced Qty
BillingQuantityUnit I_BillingDocumentItem BillingQuantityUnit Sales Unit
BaseUnit I_BillingDocumentItem BaseUnit Unit of Measure
TaxAmountendasItemNetAmountOfBillingDoc
ItemGrossAmountOfBillingDoc I_BillingDocumentItem GrossAmount Gross value
BillDocItemTaxAmt I_BillingDocumentItem TaxAmount Tax Amt in Rptg Crcy
Material I_BillingDocumentItem Material Vehicle Model
TotalNetAmount
InvoiceListStatus
BillingDocumentDate
TransactionCurrency
BillingDocumentType
CreationDate
ExchangeRateDate I_BillingDocumentItem PriceDetnExchangeRateDate
NetAmountendasPurchasingDocumentAmount
MasterProject
MasterProjectType Hierarchy MasterProjectType
MasterProjectIsConfidential Hierarchy MasterProjectIsConfidential
MasterProjectOrganization Hierarchy MasterProjectOrganization
MasterProjectUUID Hierarchy MasterProjectUUID NodeID
MasterProjectName Hierarchy MasterProjectName
ControllingObjectExternalID
ControllingObjectDescription Hierarchy ControllingObjectDescription
UserIsInvolved Hierarchy UserIsInvolved
SoldToParty _SalesDocument SoldToParty Sold-to Party
SalesOrganization _SalesDocument SalesOrganization Sales Organization
SubsequentDocumentCategory Hierarchy SubsequentDocumentCategory
_Customer _Customer
_SalesDocument _SalesDocument
_BillingDocument _BillingDocument

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_MPBillingSummary.
-- 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: IMPBILLSUMMARY

CREATE VIEW I_MPBillingSummary AS
SELECT
  Hierarchy.SalesDocument AS SalesDocument,
  Hierarchy.SalesDocumentItem AS SalesDocumentItem,
  BillingDocumentItem.BillingDocument AS BillingDocument,
  Hierarchy.SDDocumentCategory AS SDDocumentCategory,
  BillingDocumentItem.BillingQuantity AS BillingQuantity,
  BillingDocumentItem.BillingQuantityUnit AS BillingQuantityUnit,
  BillingDocumentItem.BaseUnit AS BaseUnit,
  case BillingDocumentItem.BillingPlanRule when '4' then ((BillingDocumentItem.NetAmount + BillingDocumentItem.TaxAmount) * -1) when '5' then ((BillingDocumentItem.NetAmount + BillingDocumentItem.TaxAmount) * -1) else BillingDocumentItem.NetAmount + BillingDocumentItem.TaxAmount end as ItemNetAmountOfBillingDoc AS TaxAmountendasItemNetAmountOfBillingDoc,
  BillingDocumentItem.GrossAmount AS ItemGrossAmountOfBillingDoc,
  BillingDocumentItem.TaxAmount AS BillDocItemTaxAmt,
  BillingDocumentItem.Material AS Material,
  (BillingDocumentItem._BillingDocument.TotalNetAmount + BillingDocumentItem._BillingDocument.TotalTaxAmount) AS TotalNetAmount,
  BillingDocumentItem._BillingDocument.OverallBillingStatus AS InvoiceListStatus,
  BillingDocumentItem._BillingDocument.BillingDocumentDate AS BillingDocumentDate,
  BillingDocumentItem._BillingDocument.TransactionCurrency AS TransactionCurrency,
  BillingDocumentItem._BillingDocument.BillingDocumentType AS BillingDocumentType,
  cast(BillingDocumentItem.CreationDate as /cpd/cpm_creationdate ) AS CreationDate,
  BillingDocumentItem.PriceDetnExchangeRateDate AS ExchangeRateDate,
  case when _ClearingAccountingDocument.PurchasingDocumentAmount is not null then _ClearingAccountingDocument.PurchasingDocumentAmount when _PartiallyReceivable.AmountInCompanyCodeCurrency is not null then -(_PartiallyReceivable.AmountInCompanyCodeCurrency) when _ClearingAccountingDocument.SalesDocument is initial and _ClearingAccountingDocument.ReferenceDocument = BillingDocumentItem.BillingDocument then BillingDocumentItem.NetAmount when AccountDocumentHeader.AccountingDocumentCategory = 'A' then BillingDocumentItem.NetAmount end as PurchasingDocumentAmount AS NetAmountendasPurchasingDocumentAmount,
  cast(Hierarchy.MasterProject as /cpd/cpm_comlprojid) AS MasterProject,
  Hierarchy.MasterProjectType AS MasterProjectType,
  Hierarchy.MasterProjectIsConfidential AS MasterProjectIsConfidential,
  Hierarchy.MasterProjectOrganization AS MasterProjectOrganization,
  Hierarchy.MasterProjectUUID AS MasterProjectUUID,
  Hierarchy.MasterProjectName AS MasterProjectName,
  ltrim(Hierarchy.ControllingObjectExternalID,'0') AS ControllingObjectExternalID,
  Hierarchy.ControllingObjectDescription AS ControllingObjectDescription,
  Hierarchy.UserIsInvolved AS UserIsInvolved,
  _SalesDocument.SoldToParty AS SoldToParty,
  _SalesDocument.SalesOrganization AS SalesOrganization,
  Hierarchy.SubsequentDocumentCategory AS SubsequentDocumentCategory
INNER JOIN I_BillingDocumentItem AS BillingDocumentItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_MstrProjBillDocItem AS BillingDocumentItemTable ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MstrProjAcctDocHdr AS AccountDocumentHeader ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MPCustomerClearedItem AS _ClearingAccountingDocument ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MPPartialPayment AS _PartiallyReceivable ON BillingDocument = _PartiallyReceivable.BillingDocument  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON soldtoparty = _Customer.Customer  -- association [0..1]
;

Learn More