P_MX_DueDeferredTaxItem

DDL: P_MX_DUEDEFERREDTAXITEM Type: view COMPOSITE Package: GLO_FIN_IS_VAT_MX
26 Fields 4 Data Sources

Mexico Due Deferred Tax Item

P_MX_DueDeferredTaxItem is a Composite CDS View that provides data about "Mexico Due Deferred Tax Item" in SAP S/4HANA. It reads from 4 data sources (P_MX_DefTaxDocSupplierDetails, I_StRpTaxItemBoxConfiguration, P_StRpTaxItem, I_TaxCode) and exposes 26 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, TaxBoxStrucValidityEndDate. Part of development package GLO_FIN_IS_VAT_MX.

Data Sources (4)

SourceAliasJoin Type
P_MX_DefTaxDocSupplierDetails DefTaxTransfer inner
I_StRpTaxItemBoxConfiguration I_StRpTaxItemBoxConfiguration inner
P_StRpTaxItem StRpTaxItem from
I_TaxCode TaxCode inner

Annotations (11)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName PMXDUEDEFTXITM view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #XL view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_StRpTaxItem CompanyCode Receiver Company Code
KEY AccountingDocument P_StRpTaxItem AccountingDocument Journal Entry
KEY FiscalYear
KEY TaxItem P_StRpTaxItem TaxItem Tax Item
KEY TaxBoxStrucValidityEndDate StRpTaxItemBox TaxBoxStrucValidityEndDate
ReportingDate P_StRpTaxItem ReportingDate
PostingDate P_StRpTaxItem PostingDate Posting Date for GR
DocumentDate P_StRpTaxItem DocumentDate Journal Entry Date
TaxReportingDate P_StRpTaxItem TaxReportingDate Tax Reporting Date
TaxReportingDocumentDate P_StRpTaxItem TaxReportingDocumentDate
DocumentReferenceID P_StRpTaxItem DocumentReferenceID Reference
AccountingDocumentType P_StRpTaxItem AccountingDocumentType Journal Entry Type
TransactionTypeDetermination P_StRpTaxItem TransactionTypeDetermination Transaction Key
GLAccount P_StRpTaxItem GLAccount General Ledger
BusinessPlace P_StRpTaxItem BusinessPlace Business place
TaxJurisdiction P_StRpTaxItem TaxJurisdiction Tax Jurisdiction
LowestLevelTaxJurisdiction P_StRpTaxItem LowestLevelTaxJurisdiction Jurisdict. Code
ReportingCountry P_StRpTaxItem ReportingCountry
SenderCompanyCode P_StRpTaxItem SenderCompanyCode Sender Company Code
SenderAccountingDocument P_StRpTaxItem SenderAccountingDocument Sender Journal Entry
SenderFiscalYear
TaxCode P_StRpTaxItem TaxCode Tax Code
TaxDeclnAmountType StRpTaxItemBox TaxDeclnAmountType
TaxBoxStrucValidityStartDate StRpTaxItemBox TaxBoxStrucValidityStartDate
TaxBoxStructureTypeasTaxBoxStructureType
BusinessType P_MX_DefTaxDocSupplierDetails BusinessType Type of Business

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_DueDeferredTaxItem.
-- 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.

CREATE VIEW P_MX_DueDeferredTaxItem AS
SELECT
  StRpTaxItem.CompanyCode AS CompanyCode,
  StRpTaxItem.AccountingDocument AS AccountingDocument,
  cast( StRpTaxItem.FiscalYear as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  StRpTaxItem.TaxItem AS TaxItem,
  StRpTaxItemBox.TaxBoxStrucValidityEndDate AS TaxBoxStrucValidityEndDate,
  StRpTaxItem.ReportingDate AS ReportingDate,
  StRpTaxItem.PostingDate AS PostingDate,
  StRpTaxItem.DocumentDate AS DocumentDate,
  StRpTaxItem.TaxReportingDate AS TaxReportingDate,
  StRpTaxItem.TaxReportingDocumentDate AS TaxReportingDocumentDate,
  StRpTaxItem.DocumentReferenceID AS DocumentReferenceID,
  StRpTaxItem.AccountingDocumentType AS AccountingDocumentType,
  StRpTaxItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  StRpTaxItem.GLAccount AS GLAccount,
  StRpTaxItem.BusinessPlace AS BusinessPlace,
  StRpTaxItem.TaxJurisdiction AS TaxJurisdiction,
  StRpTaxItem.LowestLevelTaxJurisdiction AS LowestLevelTaxJurisdiction,
  StRpTaxItem.ReportingCountry AS ReportingCountry,
  StRpTaxItem.SenderCompanyCode AS SenderCompanyCode,
  StRpTaxItem.SenderAccountingDocument AS SenderAccountingDocument,
  cast( StRpTaxItem.SenderFiscalYear as fis_gjahr_no_conv preserving type ) AS SenderFiscalYear,
  StRpTaxItem.TaxCode AS TaxCode,
  StRpTaxItemBox.TaxDeclnAmountType AS TaxDeclnAmountType,
  StRpTaxItemBox.TaxBoxStrucValidityStartDate AS TaxBoxStrucValidityStartDate,
  DefTaxTransfer.BusinessType AS BusinessType
FROM P_StRpTaxItem AS StRpTaxItem
INNER JOIN P_MX_DefTaxDocSupplierDetails AS DefTaxTransfer ON /* join condition not captured in parsed metadata */
INNER JOIN I_TaxCode AS TaxCode ON /* join condition not captured in parsed metadata */
INNER JOIN I_StRpTaxItemBoxConfiguration ON /* join condition not captured in parsed metadata */
;

Learn More