The CFDI_RESP_MX table in SAP ERP or S/4HANA stores MX: CFDI Response Details data. There are total 24 fields in CFDI_RESP_MX table. The MX: CFDI Response Details table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CFDI_RESP_MX table. It is in Localization Mexico – CFDI (ID-LO-MX) ABAP package and is part of the Localization Logistics (FI-LOC-LO) module.
SAP CFDI_RESP_MX Table Fields
Following is the list of fields that are available in SAP CFDI_RESP_MX table. The primary key fields of MX: CFDI Response Details table in SAP are MANDT (Client), BUKRS (Company Code), REFDOC (Reference Invoice Document Number), REFTYP (Reference Document Type), GJAHR (Fiscal Year).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| BUKRS | Company Code | BUKRS | T001 | CHAR (4) |
| REFDOC | Reference Invoice Document Number | CFDI_REFDOC_MX | CFDI_REQ_MX | CHAR (10) |
| REFTYP | Reference Document Type | CFDI_REFDOCTY_MX | CHAR (1) | |
| GJAHR | Fiscal Year | GJAHR | NUMC (4) | |
| REFDOCDT | Reference Document Creation/Posting Date | CFDI_REFDOCDT_MX | DATS (8) | |
| STATUS | Invoice Status (For CFDI Process) | CFDI_STATUS_MX | CHAR (2) | |
| CFDIRESPT | Timestamp of gen. of dig. stamp by the SAT (ISO 8601 Format) | CFDI_RESPTIM_MX | CHAR (19) | |
| VERSION | (1.a) XML/DI/CFDI Version | CFDI_XML_VERSION | CHAR (6) | |
| FECHA_A | Date and Time of generation of the acknowledgement | CFDI_CACKT_MX | CHAR (19) | |
| CODESTATUS | Status code of the cancellation | CFDI_CODESTATUS | CHAR (3) | |
| ESTATUSUUID | Element to define the status of tax folios (UUID) | CFDI_ESTAT_UUID | CHAR (3) | |
| ERNAM | Created By (Username) | CFDI_ERNAM_MX | CHAR (12) | |
| ERDAT | Created At (Timestamp) | CFDI_ERDAT_MX | CHAR (19) | |
| AENAM | Change By (Username) | CFDI_AENAM_MX | CHAR (12) | |
| AEDAT | Change At (Timestamp) | CFDI_AEDAT_MX | CHAR (19) | |
| SELLOSAT_GUID | GUID of the SELLOSAT Character Chain (Response) | CFDI_SELLOSAT_MX | RAW (16) | |
| DIGEST_VAL_GUID | GUID of the Digest Value character chain (Cancellation) | CFDI_DIGVAL_MX | RAW (16) | |
| SIGN_VALUE_GUID | GUID of the Signed info value (Cancellation) | CFDI_SIGN_INFO_MX | RAW (16) | |
| X509_CERT_GUID | GUID for X509 Certificate(Base 64) (Cancellation) | CFDI_ISCERT_MX | RAW (16) | |
| SRNR_VALUE_GUID | X509 Serial Number (Cancellation) | CFDI_CER_SRNR_MX | RAW (16) | |
| X509_ISN_GUID | GUID for the Issuer Name (Cancellation) | CFDI_ISN_MX | RAW (16) | |
| QR_GUID | GUID of the QR code (invoice approval) | CFDI_QR_MX | RAW (16) | |
| LEGEND_GUID | GUID of the Legend (Invoice Approval) | CFDI_LEGEND_MX | RAW (16) |
