P_MX_JrnlEntrNationalCompDets

DDL: P_MX_JRNLENTRNATIONALCOMPDETS SQL: PMXJENATCOMP Type: view CONSUMPTION Package: GLO_FIN_IS_GL_MX_JE
58 Fields 6 Data Sources

MX JE National Compensation Details

P_MX_JrnlEntrNationalCompDets is a Consumption CDS View that provides data about "MX JE National Compensation Details" in SAP S/4HANA. It reads from 6 data sources and exposes 58 fields with key fields SourceLedger, Ledger, CompanyCode, AccountingDocument, FiscalYear. Part of development package GLO_FIN_IS_GL_MX_JE.

Data Sources (6)

SourceAliasJoin Type
P_MX_JournalEntryGRHistory2 GoodsReceiptDetails inner
I_StRpJournalEntryHeaderLog I_StRpJournalEntryHeaderLog inner
P_MX_JrnlEntrItmInvcDetails P_MX_JrnlEntrItmInvcDetails from
P_MX_JrnlEntrItmInvcDetails P_MX_JrnlEntrItmInvcDetails inner
P_MX_JrnlEntrItmInvcDetails P_MX_JrnlEntrItmInvcDetails union_all
P_JrnlEntrAddlClrgInformation PaidInvoices union_all

Parameters (4)

NameTypeDefault
P_Ledger fins_ledger
P_FiscalYear fis_gjahr_no_conv
P_FromPostingDate fis_budat_from
P_ToPostingDate fis_budat_to

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PMXJENATCOMP view
AbapCatalog.compiler.compareFilter true view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #P view

Fields (58)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger DocumentDetails SourceLedger Source Ledger
KEY Ledger DocumentDetails Ledger Ledger
KEY CompanyCode DocumentDetails CompanyCode Receiver Company Code
KEY AccountingDocument DocumentDetails AccountingDocument Journal Entry
KEY FiscalYear DocumentDetails FiscalYear Material Document Year
KEY AccountingDocumentItem DocumentDetails AccountingDocumentItem Posting View Item
KEY StatryRptCategory DocumentDetails StatryRptCategory Report ID
KEY StatryRptgEntity DocumentDetails StatryRptgEntity Reporting Entity
KEY StatryRptRunID DocumentDetails StatryRptRunID Report Run ID
AmountInTransactionCurrency DocumentDetails AmountInTransactionCurrency Pt Crcy Amt
TransactionCurrency DocumentDetails TransactionCurrency Transaction Currency
ElectronicInvoiceUUID DocumentDetails ElectronicInvoiceUUID Mexico UUID
TaxNumber1 DocumentDetails TaxNumber1 VAT Reg. No.
TaxNumberLineItem DocumentDetails TaxNumberLineItem
ExchangeRate DocumentDetails ExchangeRate Exchange rate
PaymentMethod DocumentDetails PaymentMethod Pymt Meth.
JrnlEntryCntrySpecificRef5 DocumentDetails JrnlEntryCntrySpecificRef5 Country/Region Specific Reference 5
P_Ledger
P_FiscalYear
P_FromPostingDate
SourceLedgerasSourceLedger
KEY Ledger InvoiceDetails Ledger Ledger
KEY CompanyCode P_JrnlEntrAddlClrgInformation ClearingCompanyCode Receiver Company Code
KEY AccountingDocument P_JrnlEntrAddlClrgInformation ClearingAccountingDocument Journal Entry
KEY FiscalYear P_JrnlEntrAddlClrgInformation ClearingDocFiscalYear Material Document Year
KEY AccountingDocumentItem InvoiceDetails AccountingDocumentItem Posting View Item
KEY StatryRptCategory InvoiceDetails StatryRptCategory Report ID
KEY StatryRptgEntity InvoiceDetails StatryRptgEntity Reporting Entity
KEY StatryRptRunID InvoiceDetails StatryRptRunID Report Run ID
AmountInTransactionCurrency Pt Crcy Amt
TransactionCurrency InvoiceDetails TransactionCurrency Transaction Currency
ElectronicInvoiceUUID InvoiceDetails ElectronicInvoiceUUID Mexico UUID
TaxNumber1 InvoiceDetails TaxNumber1 VAT Reg. No.
TaxNumberLineItem InvoiceDetails TaxNumberLineItem
ExchangeRate InvoiceDetails ExchangeRate Exchange rate
PaymentMethod InvoiceDetails PaymentMethod Pymt Meth.
JrnlEntryCntrySpecificRef5 InvoiceDetails JrnlEntryCntrySpecificRef5 Country/Region Specific Reference 5
P_Ledger
P_FiscalYear
P_FromPostingDate
SourceLedgerasSourceLedger
KEY Ledger SupplierInvoiceDetails Ledger Ledger
KEY CompanyCode SupplierInvoiceDetails CompanyCode Receiver Company Code
KEY AccountingDocument P_MX_JournalEntryGRHistory2 MaterialDocumentNumber Journal Entry
KEY FiscalYear P_MX_JournalEntryGRHistory2 MaterialDocumentYear Material Document Year
KEY AccountingDocumentItem SupplierInvoiceDetails AccountingDocumentItem Posting View Item
KEY StatryRptCategory SupplierInvoiceDetails StatryRptCategory Report ID
KEY StatryRptgEntity SupplierInvoiceDetails StatryRptgEntity Reporting Entity
KEY StatryRptRunID SupplierInvoiceDetails StatryRptRunID Report Run ID
AmountInTransactionCurrency Pt Crcy Amt
TransactionCurrency SupplierInvoiceDetails TransactionCurrency Transaction Currency
ElectronicInvoiceUUID SupplierInvoiceDetails ElectronicInvoiceUUID Mexico UUID
TaxNumber1 SupplierInvoiceDetails TaxNumber1 VAT Reg. No.
TaxNumberLineItem SupplierInvoiceDetails TaxNumberLineItem
ExchangeRate SupplierInvoiceDetails ExchangeRate Exchange rate
PaymentMethod SupplierInvoiceDetails PaymentMethod Pymt Meth.
JrnlEntryCntrySpecificRef5 SupplierInvoiceDetails JrnlEntryCntrySpecificRef5 Country/Region Specific Reference 5
IsOriginalDocument

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_JrnlEntrNationalCompDets.
-- 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: PMXJENATCOMP
-- Parameters: P_Ledger : fins_ledger, P_FiscalYear : fis_gjahr_no_conv, P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to

CREATE VIEW P_MX_JrnlEntrNationalCompDets AS
SELECT
  DocumentDetails.SourceLedger AS SourceLedger,
  DocumentDetails.Ledger AS Ledger,
  DocumentDetails.CompanyCode AS CompanyCode,
  DocumentDetails.AccountingDocument AS AccountingDocument,
  DocumentDetails.FiscalYear AS FiscalYear,
  DocumentDetails.AccountingDocumentItem AS AccountingDocumentItem,
  DocumentDetails.StatryRptCategory AS StatryRptCategory,
  DocumentDetails.StatryRptgEntity AS StatryRptgEntity,
  DocumentDetails.StatryRptRunID AS StatryRptRunID,
  DocumentDetails.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  DocumentDetails.TransactionCurrency AS TransactionCurrency,
  DocumentDetails.ElectronicInvoiceUUID AS ElectronicInvoiceUUID,
  DocumentDetails.TaxNumber1 AS TaxNumber1,
  DocumentDetails.TaxNumberLineItem AS TaxNumberLineItem,
  DocumentDetails.ExchangeRate AS ExchangeRate,
  DocumentDetails.PaymentMethod AS PaymentMethod,
  DocumentDetails.JrnlEntryCntrySpecificRef5 AS JrnlEntryCntrySpecificRef5,
  'X' as IsOriginalDocument AS P_Ledger,
  P_FiscalYear : $parameters.P_FiscalYear AS P_FiscalYear,
  P_FromPostingDate : $parameters.P_FromPostingDate AS P_FromPostingDate,
  '' AS IsOriginalDocument
FROM P_MX_JrnlEntrItmInvcDetails
INNER JOIN P_MX_JrnlEntrItmInvcDetails ON /* join condition not captured in parsed metadata */
INNER JOIN I_StRpJournalEntryHeaderLog ON /* join condition not captured in parsed metadata */
INNER JOIN P_MX_JournalEntryGRHistory2 AS GoodsReceiptDetails ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_JrnlEntrAddlClrgInformation, P_MX_JrnlEntrItmInvcDetails
;

Learn More