I_ES_VeriFactuElectronicDoc

DDL: I_ES_VERIFACTUELECTRONICDOC Type: view_entity BASIC
26 Fields 2 Data Sources

VeriFactu Electronic documents

I_ES_VeriFactuElectronicDoc is a Basic CDS View that provides data about "VeriFactu Electronic documents" in SAP S/4HANA. It reads from 2 data sources (I_ElectronicDoc, R_ES_EDocVeriFactuSingleDoc) and exposes 26 fields with key field ElectronicDocUUID.

Data Sources (2)

SourceAliasJoin Type
I_ElectronicDoc EDOC inner
R_ES_EDocVeriFactuSingleDoc SDOC from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label VeriFactu Electronic documents view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY ElectronicDocUUID R_ES_EDocVeriFactuSingleDoc ElectronicDocUUID eDocument GUID
ElectronicDocSequenceNmbr R_ES_EDocVeriFactuSingleDoc ElectronicDocSequenceNmbr Value Number
ES_EDocVeriFactuPreIssuerTaxId R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuPreIssuerTaxId
ES_EDocVeriFactuPreIssuerNmbr R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuPreIssuerNmbr
ES_EDocVeriFactuPreIssueInDate R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuPreIssueInDate
ES_EDocVeriFactuIssuerTaxId R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuIssuerTaxId Issuer ID Number
ES_EDocVeriFactuIssuerInvcNmbr R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuIssuerInvcNmbr Invoice No.
ES_EDocVeriFactuIssueInDate R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuIssueInDate Invoice Date
ES_EDocVeriFactuTotalAmount R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuTotalAmount Total Amount
ES_EDocVeriFactuTaxAmount R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuTaxAmount VAT Amount Type
ES_EDocVeriFactuInvcType R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuInvcType SAF-T Inv. Type
ES_EDocVeriFactuSrceDocType R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuSrceDocType Rep. rec. doc. type
ES_EDocVeriFactuReversal R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuReversal Reversed
ES_EDocVeriFactuNmbrRange R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuNmbrRange No. Range No.
ES_EDocVeriFactuInvcRecdNmbr R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuInvcRecdNmbr
ES_EDocVeriFactuPreInvcRecd R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuPreInvcRecd
ES_EDocVeriFactuHashTxt R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuHashTxt Statement Hash
ES_EDocVeriFactuPrevHashTxt R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuPrevHashTxt
ES_EDocVeriFactuDocDteTme R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuDocDteTme
ES_EDocVeriFactuErrorCode R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuErrorCode INT4
ES_EDocVeriFactuErrorDesc R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuErrorDesc Error Desc.
ElectronicDocCreationDate I_ElectronicDoc ElectronicDocCreationDate Time Stamp
ElectronicDocCreationTime I_ElectronicDoc ElectronicDocCreationTime Time
ElectronicDocCompanyCode I_ElectronicDoc ElectronicDocCompanyCode Value
ElectronicDocSourceType I_ElectronicDoc ElectronicDocSourceType SRVC Source Type
Currency R_ES_EDocVeriFactuSingleDoc Currency Valuation Crcy

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_ES_VeriFactuElectronicDoc.
-- 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 I_ES_VeriFactuElectronicDoc AS
SELECT
  SDOC.ElectronicDocUUID AS ElectronicDocUUID,
  SDOC.ElectronicDocSequenceNmbr AS ElectronicDocSequenceNmbr,
  SDOC.ES_EDocVeriFactuPreIssuerTaxId AS ES_EDocVeriFactuPreIssuerTaxId,
  SDOC.ES_EDocVeriFactuPreIssuerNmbr AS ES_EDocVeriFactuPreIssuerNmbr,
  SDOC.ES_EDocVeriFactuPreIssueInDate AS ES_EDocVeriFactuPreIssueInDate,
  SDOC.ES_EDocVeriFactuIssuerTaxId AS ES_EDocVeriFactuIssuerTaxId,
  SDOC.ES_EDocVeriFactuIssuerInvcNmbr AS ES_EDocVeriFactuIssuerInvcNmbr,
  SDOC.ES_EDocVeriFactuIssueInDate AS ES_EDocVeriFactuIssueInDate,
  SDOC.ES_EDocVeriFactuTotalAmount AS ES_EDocVeriFactuTotalAmount,
  SDOC.ES_EDocVeriFactuTaxAmount AS ES_EDocVeriFactuTaxAmount,
  SDOC.ES_EDocVeriFactuInvcType AS ES_EDocVeriFactuInvcType,
  SDOC.ES_EDocVeriFactuSrceDocType AS ES_EDocVeriFactuSrceDocType,
  SDOC.ES_EDocVeriFactuReversal AS ES_EDocVeriFactuReversal,
  SDOC.ES_EDocVeriFactuNmbrRange AS ES_EDocVeriFactuNmbrRange,
  SDOC.ES_EDocVeriFactuInvcRecdNmbr AS ES_EDocVeriFactuInvcRecdNmbr,
  SDOC.ES_EDocVeriFactuPreInvcRecd AS ES_EDocVeriFactuPreInvcRecd,
  SDOC.ES_EDocVeriFactuHashTxt AS ES_EDocVeriFactuHashTxt,
  SDOC.ES_EDocVeriFactuPrevHashTxt AS ES_EDocVeriFactuPrevHashTxt,
  SDOC.ES_EDocVeriFactuDocDteTme AS ES_EDocVeriFactuDocDteTme,
  SDOC.ES_EDocVeriFactuErrorCode AS ES_EDocVeriFactuErrorCode,
  SDOC.ES_EDocVeriFactuErrorDesc AS ES_EDocVeriFactuErrorDesc,
  EDOC.ElectronicDocCreationDate AS ElectronicDocCreationDate,
  EDOC.ElectronicDocCreationTime AS ElectronicDocCreationTime,
  EDOC.ElectronicDocCompanyCode AS ElectronicDocCompanyCode,
  EDOC.ElectronicDocSourceType AS ElectronicDocSourceType,
  SDOC.Currency AS Currency
FROM R_ES_EDocVeriFactuSingleDoc AS SDOC
INNER JOIN I_ElectronicDoc AS EDOC ON /* join condition not captured in parsed metadata */
;

Learn More