CFDI_RESP_MX
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_MX_ElectronicInvcRspDetails | view | from | CONSUMPTION | Electronic Invoice Details for MX |
Fields (28)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA