C_MX_JrnlEntrItmInvcDetailsQ

DDL: C_MX_JRNLENTRITMINVCDETAILSQ SQL: CMXJEINVDETQ Type: view CONSUMPTION Package: GLO_FIN_IS_GL_MX_JE
18 Fields 1 Data Sources

Journal Entries Items with Invoice Query

C_MX_JrnlEntrItmInvcDetailsQ is a Consumption CDS View that provides data about "Journal Entries Items with Invoice Query" in SAP S/4HANA. It reads from 1 data source (C_MX_JrnlEntrItmInvcDetailsC) and exposes 18 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, AccountingDocument. Part of development package GLO_FIN_IS_GL_MX_JE.

Data Sources (1)

SourceAliasJoin Type
C_MX_JrnlEntrItmInvcDetailsC C_MX_JrnlEntrItmInvcDetailsC from

Parameters (5)

NameTypeDefault
P_AlternativeGLAccount figlmx_prim
P_Ledger fins_ledger
P_FiscalYear fis_gjahr_no_conv
P_FromPostingDate fis_budat_from
P_ToPostingDate fis_budat_to

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CMXJEINVDETQ view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Journal Entries Items with Invoice Query view
VDM.viewType #CONSUMPTION view
Analytics.query true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity StatryRptgEntity Reporting Entity
KEY StatryRptCategory StatryRptCategory Report ID
KEY StatryRptRunID StatryRptRunID Report Run ID
KEY CompanyCode CompanyCode Receiver Company Code
KEY AccountingDocument AccountingDocument Journal Entry
KEY FiscalYear FiscalYear G/L Fiscal Year
PostingDate PostingDate Posting Date for GR
ElectronicInvoiceUUID ElectronicInvoiceUUID Mexico UUID
DocumentReferenceID DocumentReferenceID Reference
TaxNumber1 TaxNumber1 VAT Reg. No.
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
TransactionCurrency TransactionCurrency Transaction Currency
ExchangeRate Exchange rate
Country Country Venue: Ctry/Reg
Supplier Supplier Supplier
Customer Customer Sold-to Party
FinancialAccountType FinancialAccountType Fin. Account Type
CompensationType CompensationType

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 C_MX_JrnlEntrItmInvcDetailsQ.
-- 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: CMXJEINVDETQ
-- Parameters: P_AlternativeGLAccount : figlmx_prim, P_Ledger : fins_ledger, P_FiscalYear : fis_gjahr_no_conv, P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to

CREATE VIEW C_MX_JrnlEntrItmInvcDetailsQ AS
SELECT
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  PostingDate,
  ElectronicInvoiceUUID,
  DocumentReferenceID,
  TaxNumber1,
  AmountInTransactionCurrency,
  TransactionCurrency,
  cast(ExchangeRate as abap.dec(9,5)) AS ExchangeRate,
  Country,
  Supplier,
  Customer,
  FinancialAccountType,
  CompensationType
FROM C_MX_JrnlEntrItmInvcDetailsC
;

Learn More