P_GteeMBillgItmsRRBNotBilledR4

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 P_GteeMBillgItmsRRBNotBilledR4.
-- 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: PGMGBRRBNOTB4

CREATE VIEW P_GteeMBillgItmsRRBNotBilledR4 AS
SELECT
  GBEE.Ledger AS Ledger,
  GBEE.CompanyCode AS CompanyCode,
  GBEE.FiscalYear AS FiscalYear,
  GBEE.AccountingDocument AS AccountingDocument,
  GBEE.LedgerGLLineItem AS LedgerGLLineItem,
  GBEE.SplitInformationSequenceNumber AS SplitInformationSequenceNumber,
  GBEE.GteeMBillgElmntEntrItmUUID AS GteeMBillgElmntEntrItmUUID,
  GBEE.GteeMBillingPlanItemUUID AS GteeMBillingPlanItemUUID,
  cast( '' as fis_awtyp ) AS ReferenceDocumentType,
  cast( '' as awref ) AS ReferenceDocument,
  cast( '000000' as fis_awitem ) AS ReferenceDocumentItem,
  GBEE.GrantID AS GrantID,
  GBEE.SponsoredProgram AS SponsoredProgram,
  GBEE.SponsoredClass AS SponsoredClass,
  GBEE.FinancialManagementArea AS FinancialManagementArea,
  GBEE.Fund AS Fund,
  cast( tstmp_to_dats( GBpItem._GteeMBillingPlanHeader.GteeMBillingPlanCrtedAtDteTme, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as fis_cpdat ) as CreationDate AS clientNULLasfis_cpdatasCreationDate,
  cast( '' as psm_bdgt_cnsmpn_type ) AS PubSecBudgetCnsmpnType,
  cast( GBpItem.GteeMBillingPlanItemBillgDate as psm_bdgt_cnsmpn_date ) AS PubSecBudgetCnsmpnDate,
  GBEE.DocumentCurrency AS DocumentCurrency,
  GBEE.GlobalCurrency AS GlobalCurrency,
  cast( '0' as gmbe_billedrevnindoccrcy ) AS BilledRevenueAmtInDocCrcy,
  cast( '0' as gmbe_notpaidrevnamtindoccrcy ) AS NotPaidRevenueAmtInDocCrcy,
  cast( '0' as gmbe_paidrevnindoccrcy ) AS PaidRevenueAmtInDocCrcy,
  cast( '0' as gmbee_billedrevninglobcrcy ) AS BilledRevenueAmtInGlobCrcy,
  cast( '0' as gmbe_notpaidrevnamtingcrcy ) AS NotPaidRevenueAmtInGCrcy,
  cast( '0' as gmbe_paidrevninglobcrcy ) AS PaidRevenueAmtInGlobalCrcy,
  GBEE._Grant AS _Grant,
  GBEE._SponsoredProgramCore AS _SponsoredProgram
FROM I_GteeMBillingElementEntry AS GBEE
INNER JOIN I_GteeMBillingPlanItem AS GBpItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_GteeMBillingElmntEntrFlwAgg2 AS _BillingElementEntryFlwAgg2 ON GteeMBillgElmntEntrItmUUID = _BillingElementEntryFlwAgg2.GteeMBillgElmntEntrItmUUID  -- association [0..1]
LEFT OUTER JOIN I_SponsoredClassCore AS _SponsoredClass ON SponsoredClass = _SponsoredClass.SponsoredClass  -- association [0..1]
;