CFDI_RESP_MX

Transparent Table Application Table

MX: CFDI Response Details

CFDI_RESP_MX is an SAP database table in S/4HANA. MX: CFDI Response Details. It contains 28 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_MX_ElectronicInvcRspDetails view from CONSUMPTION Electronic Invoice Details for MX

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bukrs BUKRS Company Code
KEY refdoc CFDI_REFDOC_MX Invoice Document Num
KEY reftyp CFDI_REFDOCTY_MX Ref. Doc. Type
KEY gjahr GJAHR Fiscal Year
refdocdt CFDI_REFDOCDT_MX Creation/Posting Dat
status CFDI_STATUS_MX Invoice Status
cfdirespt CFDI_RESPTIM_MX Fecha Timbrado
rejcode CFDI_REJC_MX Rejection Code
version CFDI_XML_VERSION XML Vers.
uuid CFDI_UUID Unique Identifier
sat_certno CFDI_NOCERT_SAT noCertificadoSAT
fecha_a CFDI_CACKT_MX Date and Time of ack
codestatus CFDI_CODESTATUS Status code
estatusuuid CFDI_ESTAT_UUID EStatus
rfc_of_pac CFDI_PAC_TAX_NUM PAC Tax ID
ernam CFDI_ERNAM_MX Created By
erdat CFDI_ERDAT_MX Created At
aenam CFDI_AENAM_MX Change By (Username)
aedat CFDI_AEDAT_MX Change At
sellosat_guid CFDI_SELLOSAT_MX GUID of SelloSAT
digest_val_guid CFDI_DIGVAL_MX GUID of Dig. Val.
sign_value_guid CFDI_SIGN_INFO_MX GUID of Sign. Info
x509_cert_guid CFDI_ISCERT_MX GUID of Certificate
srnr_value_guid CFDI_CER_SRNR_MX GUID of Sernr
x509_isn_guid CFDI_ISN_MX GUID of Issuer Name
qr_guid CFDI_QR_MX QR code
legend_guid CFDI_LEGEND_MX GUID of Legend

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.

-- MX: CFDI Response Details
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CFDI_RESP_MX (
    MANDT,            -- Client [MANDT]
    BUKRS,            -- Company Code [BUKRS]
    REFDOC,           -- Invoice Document Num [CFDI_REFDOC_MX]
    REFTYP,           -- Ref. Doc. Type [CFDI_REFDOCTY_MX]
    GJAHR,            -- Fiscal Year [GJAHR]
    REFDOCDT,         -- Creation/Posting Dat [CFDI_REFDOCDT_MX]
    STATUS,           -- Invoice Status [CFDI_STATUS_MX]
    CFDIRESPT,        -- Fecha Timbrado [CFDI_RESPTIM_MX]
    REJCODE,          -- Rejection Code [CFDI_REJC_MX]
    VERSION,          -- XML Vers. [CFDI_XML_VERSION]
    UUID,             -- Unique Identifier [CFDI_UUID]
    SAT_CERTNO,       -- noCertificadoSAT [CFDI_NOCERT_SAT]
    FECHA_A,          -- Date and Time of ack [CFDI_CACKT_MX]
    CODESTATUS,       -- Status code [CFDI_CODESTATUS]
    ESTATUSUUID,      -- EStatus [CFDI_ESTAT_UUID]
    RFC_OF_PAC,       -- PAC Tax ID [CFDI_PAC_TAX_NUM]
    ERNAM,            -- Created By [CFDI_ERNAM_MX]
    ERDAT,            -- Created At [CFDI_ERDAT_MX]
    AENAM,            -- Change By (Username) [CFDI_AENAM_MX]
    AEDAT,            -- Change At [CFDI_AEDAT_MX]
    SELLOSAT_GUID,    -- GUID of SelloSAT [CFDI_SELLOSAT_MX]
    DIGEST_VAL_GUID,  -- GUID of Dig. Val. [CFDI_DIGVAL_MX]
    SIGN_VALUE_GUID,  -- GUID of Sign. Info [CFDI_SIGN_INFO_MX]
    X509_CERT_GUID,   -- GUID of Certificate [CFDI_ISCERT_MX]
    SRNR_VALUE_GUID,  -- GUID of Sernr [CFDI_CER_SRNR_MX]
    X509_ISN_GUID,    -- GUID of Issuer Name [CFDI_ISN_MX]
    QR_GUID,          -- QR code [CFDI_QR_MX]
    LEGEND_GUID,      -- GUID of Legend [CFDI_LEGEND_MX]
    PRIMARY KEY (MANDT, BUKRS, REFDOC, REFTYP, GJAHR)
);