R_GR_ElectronicDocInvoice

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 R_GR_ElectronicDocInvoice.
-- 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.

CREATE VIEW R_GR_ElectronicDocInvoice AS
SELECT
  edoc_guid AS ElectronicDocUUID,
  legaldoc AS GR_ElectronicDocRefDocNumber,
  prntsk AS GR_ElectronicDocPrintTaskCode,
  stext AS GR_ElectronicDocSeriesPrefix,
  series AS GR_ElectronicDocumentSeries,
  numbr AS GR_ElectronicDocLegalNumber,
  prdate AS GR_PrintDate,
  prtime AS GR_PrintTime,
  move_purpose AS GR_MovePurpose,
  inv_uid AS GR_ElectronicDocUniqueID,
  inv_mark AS GR_ElectronicDocMarkID,
  classif_mark AS GR_ElectronicDocClfnMarkID,
  cancel_mark AS GR_ElectronicDocCancelMarkID,
  customer_vat_reg_id AS GR_ElectronicDocCustVATID,
  invoice_date AS GR_ElectronicDocIssueDate,
  invoice_type AS GR_ElectronicDocInvoiceType,
  vendor_vat_reg_id AS GR_ElectronicDocSupplierVATID,
  issuer_branch_id AS GR_ElectronicDocBranchID,
  total_gross_amount AS GR_ElectronicDocGrossAmount,
  total_payable_amount AS GR_ElectronicDocPayableAmount,
  total_net_amount AS GR_ElectronicDocNetAmount,
  fuel_invoice AS GR_ElectronicDocFuelInvoice
FROM edogrinv
;