I_UtilitiesInvoicingDocument

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_UtilitiesInvoicingDocument.
-- 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: IEINVOICINGDOC

CREATE VIEW I_UtilitiesInvoicingDocument AS
SELECT
  cast (erdk.opbel as e_printdoc_vdm preserving type) AS UtilitiesInvoicingDocument,
  erdk.druckdat AS UtilitiesInvoicingDocPrintDate,
  erdk.faedn AS NetDueDate,
  erdk.faeds AS CashDiscountDueDate,
  erdk.sktpz AS CashDiscountPercent,
  erdk.budat AS PostingDate,
  erdk.bldat AS DocumentDate,
  erdk.total_amnt AS TotalAmountInTransactionCrcy,
  erdk.total_waer AS TransactionCurrency,
  erdk.pymet AS PaymentMethod,
  erdk.ergrd AS UtilitiesInvoicingReason,
  erdk.stokz AS UtilsInvcgDocIsReversed,
  erdk.icreason AS UtilsInvcgDocReversalRsn,
  erdk.intopbel AS ReversalUtilsInvcgDocument,
  erdk.tobreleasd AS UtilsInvcgDocIsNotReleased,
  erdk.simulated AS UtilsInvcgDocIsSimulated,
  erdk.invoiced AS UtilsInvcgDocumentIsPosted,
  erdk.partner AS BusinessPartner,
  erdk.vkont AS ContractAccount,
  erdk.portion AS UtilitiesPortion,
  erdk.abrvorg AS UtilitiesBillingReason,
  erdk.fikey AS CAReconciliationKey,
  erdk.invoicing_party AS UtilitiesInvoicingParty,
  erdk.erdat AS UtilsInvcgDocCreationDate,
  erdk.ernam AS UtilsInvcgDocCreatedByUser,
  erdk.aedat AS UtilsInvcgDocLastChangeDate,
  erdk.aenam AS UtilsInvcgDocLastChangedByUser,
  erdk.sto_budat AS OriginalUtilsInvcgDocRvslDate,
  erdk.sto_opbel AS OriginalUtilsInvcgDocument,
  erdk.printlock AS UtilsInvcgDocPrintBlockRsn,
  erdk.begru AS AuthorizationGroup
FROM erdk
LEFT OUTER JOIN I_UtilitiesInvoicingReason AS _UtilitiesInvoicingReason ON UtilitiesInvoicingReason = _UtilitiesInvoicingReason.UtilitiesInvoicingReason  -- association [1..1]
LEFT OUTER JOIN I_UtilsInvcgDocReversalRsn AS _UtilsInvcgDocReversalRsn ON UtilsInvcgDocReversalRsn = _UtilsInvcgDocReversalRsn.UtilsInvcgDocReversalRsn  -- association [0..1]
LEFT OUTER JOIN I_UtilsInvcgPrntBlockRsn AS _UtilsInvcgPrntBlockRsn ON UtilsInvcgDocPrintBlockRsn = _UtilsInvcgPrntBlockRsn.UtilsInvcgDocPrintBlockRsn  -- association [1..1]
LEFT OUTER JOIN I_UtilitiesPortion AS _UtilitiesPortion ON UtilitiesPortion = _UtilitiesPortion.UtilitiesPortion  -- association [0..1]
LEFT OUTER JOIN I_UtilitiesBillingReason AS _UtilitiesBillingReason ON UtilitiesBillingReason = _UtilitiesBillingReason.UtilitiesBillingReason  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON TransactionCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON UtilsInvcgDocCreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON UtilsInvcgDocLastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
;