C_MPBillnRecvSummary

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_MPBillnRecvSummary.
-- 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: CMPBILLRCVSUM

CREATE VIEW C_MPBillnRecvSummary AS
SELECT
  Invoice.MasterProject AS MasterProject,
  ltrim(Invoice.SalesDocument,'0') AS SalesDocument,
  ltrim(Invoice.SalesDocumentItem,'0') AS SalesDocumentItem,
  Invoice.BillingDocument AS BillingDocument,
  Invoice.SalesDocument AS SalesOrder,
  Invoice.SalesDocumentItem AS SalesOrderItem,
  _SalesDocumentItem.SalesDocumentItemText AS SalesDocumentItemText,
  Invoice.SDDocumentCategory AS SDDocumentCategory,
  Invoice.MasterProjectName AS MasterProjectName,
  Invoice.BillingDocumentType AS BillingDocumentType,
  _BillingDocumentTypeText.BillingDocumentTypeName AS BillingDocumentTypeName,
  Invoice.SalesOrganization AS SalesOrganization,
  _SalesOrganizationText.SalesOrganizationName AS SalesOrganizationName,
  _SalesDocumentItem.NetAmount AS NetAmount,
  Invoice.Material AS Material,
  _SalesDocumentItem._Material._Text[1:Language = $session.system_language].MaterialName AS MaterialName,
  cast(Invoice.PurchasingDocumentAmount as /cpd/cpm_receivedamount) AS ItemGrossAmountOfBillingDoc,
  Invoice.TransactionCurrency AS TransactionCurrency,
  cast(Invoice.ControllingObjectExternalID as /cpd/cpm_struct_elm) AS ControllingObjectExternalID,
  cast(Invoice.ControllingObjectDescription as /cpd/cpm_str_elm_nm) AS ControllingObjectDescription,
  Invoice.SoldToParty AS SoldToParty,
  cast( _Customer.CustomerName as /cpd/cpm_customer) AS CustomerName,
  Invoice.AddressID AS AddressID,
  Invoice.Person AS Person,
  _DefaultEmailAddress.EmailAddress AS EmailAddress,
  cast(_DefaultPhoneNumber[PhoneNumberType='3'].PhoneNumber as /cpd/cpm_custmobno) AS MobilePhoneNumber,
  cast(_DefaultPhoneNumber[PhoneNumberType='1'].PhoneNumber as /cpd/cpm_custcontactno) AS PhoneNumber,
  Invoice.UserIsInvolved AS UserIsInvolved,
  Invoice.MasterProjectType AS MasterProjectType
FROM I_MstrProjSummary AS Invoice
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesDocumentItem ON SalesOrder = _SalesDocumentItem.SalesDocument AND SalesOrderItem = _SalesDocumentItem.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_MasterProjectVH AS _MasterProject ON MasterProject = _MasterProject.MasterProject  -- association [0..1]
LEFT OUTER JOIN I_MPStructureElementVH AS _ControllingObject ON ControllingObjectExternalID = _ControllingObject.ControllingObjectExternalID  -- association [0..*]
LEFT OUTER JOIN I_Customer AS _Customer ON SoldToParty = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganizationText AS _SalesOrganizationText ON SalesOrganization = _SalesOrganizationText.SalesOrganization AND _SalesOrganizationText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BillingDocumentTypeText AS _BillingDocumentTypeText ON BillingDocumentType = _BillingDocumentTypeText.BillingDocumentType AND _BillingDocumentTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MstrProjCreditSummary AS _MstrProjCreditSummary ON MasterProject = _MstrProjCreditSummary.MasterProject AND Invoice.SalesDocument = _MstrProjCreditSummary.SalesDocument AND Invoice.SalesDocumentItem = _MstrProjCreditSummary.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_AddressPhoneNumber AS _DefaultPhoneNumber ON _DefaultPhoneNumber.AddressID = AddressID AND ( _DefaultPhoneNumber.Person = Person OR _DefaultPhoneNumber.Person = ' ' )  -- association [0..1]
LEFT OUTER JOIN I_AddressEmailAddress AS _DefaultEmailAddress ON _DefaultEmailAddress.AddressID = AddressID AND ( _DefaultEmailAddress.Person = Person OR _DefaultEmailAddress.Person = ' ' ) AND _DefaultEmailAddress.IsDefaultEmailAddress = 'X'  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _Extension ON SalesOrder = _Extension.SalesDocument AND SalesOrderItem = _Extension.SalesDocumentItem  -- association [0..1]
;