I_UtilsBillgDocPrevYrInvcgDoc

DDL: I_UTILSBILLGDOCPREVYRINVCGDOC SQL: IEBILLGDOCPYINVD Type: view COMPOSITE
7 Fields 7 Data Sources

Previous Year Invoicing Document for Billing Document

I_UtilsBillgDocPrevYrInvcgDoc is a Composite CDS View that provides data about "Previous Year Invoicing Document for Billing Document" in SAP S/4HANA. It reads from 7 data sources and exposes 7 fields with key field UtilitiesBillingDocument.

Data Sources (7)

SourceAliasJoin Type
I_UtilitiesBillingDocument I_UtilitiesBillingDocument from
I_MeterReadingUnit MeterReadingUnit inner
I_UtilitiesBillingDocument PrevYearBill inner
I_UtilsBillgDocInvcgHistory PrevYearInvoice inner
I_UtilitiesPortionScheduleRecd PrevYearSchedRecord inner
I_UtilitiesContract UtilitiesContract inner
I_UtilitiesInstallationHist UtilitiesInstallationHist inner

Annotations (11)

NameValueLevelField
EndUserText.label Previous Year Invoicing Document for Billing Document view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName IEBILLGDOCPYINVD view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ObjectModel.representativeKey UtilitiesBillingDocument view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesBillingDocument I_UtilitiesBillingDocument UtilitiesBillingDocument
CompanyCode I_UtilitiesBillingDocument CompanyCode Receiver Company Code
Division I_UtilitiesBillingDocument Division Internal Division ID
AuthorizationGroup I_UtilitiesBillingDocument AuthorizationGroup AuthorizGroup
UtilsInvoicingDocumentPrevYear I_UtilsBillgDocInvcgHistory UtilitiesInvoicingDocument Reopen
BusinessPartner I_UtilitiesBillingDocument BusinessPartner Issuing Authority
_BusinessPartner I_UtilitiesBillingDocument _BusinessPartner

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_UtilsBillgDocPrevYrInvcgDoc.
-- 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: IEBILLGDOCPYINVD

CREATE VIEW I_UtilsBillgDocPrevYrInvcgDoc AS
SELECT
  I_UtilitiesBillingDocument.UtilitiesBillingDocument AS UtilitiesBillingDocument,
  I_UtilitiesBillingDocument.CompanyCode AS CompanyCode,
  I_UtilitiesBillingDocument.Division AS Division,
  I_UtilitiesBillingDocument.AuthorizationGroup AS AuthorizationGroup,
  PrevYearInvoice.UtilitiesInvoicingDocument AS UtilsInvoicingDocumentPrevYear,
  I_UtilitiesBillingDocument.BusinessPartner AS BusinessPartner,
  I_UtilitiesBillingDocument._BusinessPartner AS _BusinessPartner
FROM I_UtilitiesBillingDocument
INNER JOIN I_UtilitiesContract AS UtilitiesContract ON /* join condition not captured in parsed metadata */
INNER JOIN I_UtilitiesInstallationHist AS UtilitiesInstallationHist ON /* join condition not captured in parsed metadata */
INNER JOIN I_MeterReadingUnit AS MeterReadingUnit ON /* join condition not captured in parsed metadata */
INNER JOIN I_UtilitiesPortionScheduleRecd AS PrevYearSchedRecord ON /* join condition not captured in parsed metadata */
INNER JOIN I_UtilitiesBillingDocument AS PrevYearBill ON /* join condition not captured in parsed metadata */
INNER JOIN I_UtilsBillgDocInvcgHistory AS PrevYearInvoice ON /* join condition not captured in parsed metadata */
;

Learn More