R_ES_EDOCVERIFACTUSINGLEDOC

CDS View
22 Fields 2 CDS Views

VeriFactu single document view

R_ES_EDOCVERIFACTUSINGLEDOC is a CDS View in S/4HANA. VeriFactu single document view. It contains 22 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ES_EDocVeriFactuExt view_entity from COMPOSITE VeriFactu Electronic documents
I_ES_VeriFactuElectronicDoc view_entity from BASIC VeriFactu Electronic documents

Fields (22)

KeyField CDS FieldsUsed in Views
KEY ElectronicDocUUID ElectronicDocUUID 2
Currency Currency,ES_EDocVeriFactuCurrency 3
ElectronicDocSequenceNmbr ElectronicDocSequenceNmbr 2
ES_EDocVeriFactuDocDteTme ES_EDocVeriFactuDocDteTme 3
ES_EDocVeriFactuErrorCode ES_EDocVeriFactuErrorCode 3
ES_EDocVeriFactuErrorDesc ES_EDocVeriFactuErrorDesc 3
ES_EDocVeriFactuHashTxt ES_EDocVeriFactuHashTxt 3
ES_EDocVeriFactuInvcRecdNmbr ES_EDocVeriFactuInvcRecdNmbr 3
ES_EDocVeriFactuInvcType ES_EDocVeriFactuInvcType 4
ES_EDocVeriFactuIssueInDate ES_EDocVeriFactuIssueInDate 3
ES_EDocVeriFactuIssuerInvcNmbr ES_EDocVeriFactuIssuerInvcNmbr 4
ES_EDocVeriFactuIssuerTaxId ES_EDocVeriFactuIssuerTaxId 4
ES_EDocVeriFactuNmbrRange ES_EDocVeriFactuNmbrRange 3
ES_EDocVeriFactuPreInvcRecd ES_EDocVeriFactuPreInvcRecd 3
ES_EDocVeriFactuPreIssueInDate ES_EDocVeriFactuPreIssueInDate 3
ES_EDocVeriFactuPreIssuerNmbr ES_EDocVeriFactuPreIssuerNmbr 3
ES_EDocVeriFactuPreIssuerTaxId ES_EDocVeriFactuPreIssuerTaxId 3
ES_EDocVeriFactuPrevHashTxt ES_EDocVeriFactuPrevHashTxt 3
ES_EDocVeriFactuReversal ES_EDocVeriFactuReversal 3
ES_EDocVeriFactuSrceDocType ES_EDocVeriFactuSrceDocType 4
ES_EDocVeriFactuTaxAmount ES_EDocVeriFactuTaxAmount 3
ES_EDocVeriFactuTotalAmount ES_EDocVeriFactuTotalAmount 3

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- VeriFactu single document view
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_ES_EDOCVERIFACTUSINGLEDOC (
    ELECTRONICDOCUUID,
    CURRENCY,
    ELECTRONICDOCSEQUENCENMBR,
    ES_EDOCVERIFACTUDOCDTETME,
    ES_EDOCVERIFACTUERRORCODE,
    ES_EDOCVERIFACTUERRORDESC,
    ES_EDOCVERIFACTUHASHTXT,
    ES_EDOCVERIFACTUINVCRECDNMBR,
    ES_EDOCVERIFACTUINVCTYPE,
    ES_EDOCVERIFACTUISSUEINDATE,
    ES_EDOCVERIFACTUISSUERINVCNMBR,
    ES_EDOCVERIFACTUISSUERTAXID,
    ES_EDOCVERIFACTUNMBRRANGE,
    ES_EDOCVERIFACTUPREINVCRECD,
    ES_EDOCVERIFACTUPREISSUEINDATE,
    ES_EDOCVERIFACTUPREISSUERNMBR,
    ES_EDOCVERIFACTUPREISSUERTAXID,
    ES_EDOCVERIFACTUPREVHASHTXT,
    ES_EDOCVERIFACTUREVERSAL,
    ES_EDOCVERIFACTUSRCEDOCTYPE,
    ES_EDOCVERIFACTUTAXAMOUNT,
    ES_EDOCVERIFACTUTOTALAMOUNT,
    PRIMARY KEY (ELECTRONICDOCUUID)
);

Learn More