P_MX_ElectronicInvcRspDetails

DDL: P_MX_ELECTRONICINVCRSPDETAILS SQL: PMXELINVDT Type: view CONSUMPTION
5 Fields 1 Data Sources

Electronic Invoice Details for MX

P_MX_ElectronicInvcRspDetails is a Consumption CDS View that provides data about "Electronic Invoice Details for MX" in SAP S/4HANA. It reads from 1 data source (cfdi_resp_mx) and exposes 5 fields with key fields CompanyCode, RefInvoiceDocumentNumber, ReferenceDocumentType, FiscalYear.

Data Sources (1)

SourceAliasJoin Type
cfdi_resp_mx cfdi_resp_mx from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PMXELINVDT view
VDM.viewType #CONSUMPTION view
VDM.private true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Electronic Invoice Details for MX view
ObjectModel.usageType.serviceQuality #A view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode bukrs Value
KEY RefInvoiceDocumentNumber refdoc Reference Doc
KEY ReferenceDocumentType reftyp Reference type
KEY FiscalYear Settlement Year
ElectronicInvoiceUUID uuid Waste Partner UUID

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 P_MX_ElectronicInvcRspDetails.
-- 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.
-- SQL view name: PMXELINVDT

CREATE VIEW P_MX_ElectronicInvcRspDetails AS
SELECT
  bukrs AS CompanyCode,
  refdoc AS RefInvoiceDocumentNumber,
  reftyp AS ReferenceDocumentType,
  cast( gjahr as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  uuid AS ElectronicInvoiceUUID
FROM cfdi_resp_mx
;

Learn More