I_ES_EDocVeriFactuExt

DDL: I_ES_EDOCVERIFACTUEXT Type: view_entity COMPOSITE Package: GLO-EDO-ES-VF
27 Fields 2 Data Sources

VeriFactu Electronic documents

I_ES_EDocVeriFactuExt (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Cross Applications

I_ES_EDocVeriFactuExt is a Composite 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 27 fields with key field ElectronicDocUUID. Part of development package GLO-EDO-ES-VF.

SAP API Hub

CategoryComposite
StateC1
Line of BusinessCross Applications
Application ComponentCA-GTF-CSC-EDO-ES
CapabilitiesData Source in SQL Select
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageCross Applications for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (2)

SourceAliasJoin Type
I_ElectronicDoc EDOC inner
R_ES_EDocVeriFactuSingleDoc SDOC from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label VeriFactu Electronic documents view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY ElectronicDocUUID R_ES_EDocVeriFactuSingleDoc ElectronicDocUUID eDocument: GUID
ElectronicDocSequenceNmbr R_ES_EDocVeriFactuSingleDoc ElectronicDocSequenceNmbr eDocument Sequence Number
ES_EDocVeriFactuPreIssuerTaxId R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuPreIssuerTaxId Veri*Factu Previous Issuer Identification Number
ES_EDocVeriFactuPreIssuerNmbr R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuPreIssuerNmbr Veri*Factu Previous Issuer Invoice Number
ES_EDocVeriFactuPreIssueInDate R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuPreIssueInDate Veri*Factu Previous Issuer Invoice Date
ES_EDocVeriFactuIssuerTaxId R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuIssuerTaxId Veri*Factu Issuer Identification Number
ES_EDocVeriFactuIssuerInvcNmbr R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuIssuerInvcNmbr Veri*Factu Issuer Invoice Number
ES_EDocVeriFactuIssueInDate R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuIssueInDate Veri*Factu Issuer Invoice Date
ES_EDocVeriFactuTotalAmount R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuTotalAmount Tax Base Amount
ES_EDocVeriFactuTaxAmount R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuTaxAmount VAT Amount Type
ES_EDocVeriFactuInvcType R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuInvcType Veri*Factu Invoice Type
ES_EDocVeriFactuSrceDocType R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuSrceDocType Veri*Factu Source Document Type
ES_EDocVeriFactuReversal R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuReversal Veri*Factu Document is a reversal document
ES_EDocVeriFactuNmbrRange R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuNmbrRange Number Range Number
ES_EDocVeriFactuInvcRecdNmbr R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuInvcRecdNmbr Veri*Factu Document Invoice Record Number
ES_EDocVeriFactuPreInvcRecd R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuPreInvcRecd Veri*Factu Document Previous Invoice Record Number
ES_EDocVeriFactuHashTxt R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuHashTxt Statement Hash
ES_EDocVeriFactuPrevHashTxt R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuPrevHashTxt
ES_EDocVeriFactuDocDteTme R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuDocDteTme Veri*Factu Record Generation Time Stamp
ES_EDocVeriFactuErrorCode R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuErrorCode Error Code Received from Tax Authorities
ES_EDocVeriFactuErrorDesc R_ES_EDocVeriFactuSingleDoc ES_EDocVeriFactuErrorDesc Error Desc.
ElectronicDocCreationDate I_ElectronicDoc ElectronicDocCreationDate Creation Date
ElectronicDocCreationTime I_ElectronicDoc ElectronicDocCreationTime Created on (Time)
ElectronicDocCompanyCode I_ElectronicDoc ElectronicDocCompanyCode Company Code
ElectronicDocSourceType I_ElectronicDoc ElectronicDocSourceType eDocument Source Type
ElectronicDocSourceKey I_ElectronicDoc ElectronicDocSourceKey eDocument Source Key
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_EDocVeriFactuExt.
-- 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_EDocVeriFactuExt 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,
  EDOC.ElectronicDocSourceKey AS ElectronicDocSourceKey,
  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