P_MX_DIOTReportingItem

DDL: P_MX_DIOTREPORTINGITEM Type: view_entity CONSUMPTION Package: GLO_FIN_IS_VAT_MX
39 Fields 1 Data Sources

Mexico DIOT Reporting Item

P_MX_DIOTReportingItem is a Consumption CDS View that provides data about "Mexico DIOT Reporting Item" in SAP S/4HANA. It reads from 1 data source (P_MX_DIOTTaxItemAggregated) and exposes 39 fields with key fields StatryRptCategory, StatryRptgEntity, StatryRptRunID, CompanyCode, Supplier. Part of development package GLO_FIN_IS_VAT_MX.

Data Sources (1)

SourceAliasJoin Type
P_MX_DIOTTaxItemAggregated P_MX_DIOTTaxItemAggregated from

Parameters (6)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id
P_CompanyCode fis_bukrs
P_FiscalYear fis_gjahr
P_Ledger fins_ledger

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
VDM.private true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY StatryRptCategory TaxItem StatryRptCategory Report ID
KEY StatryRptgEntity TaxItem StatryRptgEntity Reporting Entity
KEY StatryRptRunID TaxItem StatryRptRunID Report Run ID
KEY CompanyCode TaxItem CompanyCode Receiver Company Code
KEY Supplier TaxItem Supplier Supplier
KEY MX_SupplierType TaxItem MX_SupplierType
KEY MX_DIOTOperationType TaxItem MX_DIOTOperationType
ReportingCurrency TaxItem ReportingCurrency Currency
TaxNumberResponsible TaxItem TaxNumberResponsible
Country TaxItem Country Venue: Ctry/Reg
MX_FiscalEffectManifest TaxItem MX_FiscalEffectManifest
MX_BorderClassification TaxItem MX_BorderClassification
TaxBox08AmtInReportingCurrency TaxItem TaxBox08AmtInReportingCurrency
TaxBox09AmtInReportingCurrency TaxItem TaxBox09AmtInReportingCurrency
TaxBox10AmtInReportingCurrency TaxItem TaxBox10AmtInReportingCurrency
TaxBox11AmtInReportingCurrency TaxItem TaxBox11AmtInReportingCurrency
TaxBox12AmtInReportingCurrency TaxItem TaxBox12AmtInReportingCurrency
TaxBox13AmtInReportingCurrency TaxItem TaxBox13AmtInReportingCurrency
TaxBox14AmtInReportingCurrency TaxItem TaxBox14AmtInReportingCurrency
TaxBox15AmtInReportingCurrency TaxItem TaxBox15AmtInReportingCurrency
TaxBox16AmtInReportingCurrency TaxItem TaxBox16AmtInReportingCurrency
TaxBox17AmtInReportingCurrency TaxItem TaxBox17AmtInReportingCurrency
TaxBox18AmtInReportingCurrency TaxItem TaxBox18AmtInReportingCurrency
TaxBox19AmtInReportingCurrency TaxItem TaxBox19AmtInReportingCurrency
TaxBox20AmtInReportingCurrency TaxItem TaxBox20AmtInReportingCurrency
TaxBox21AmtInReportingCurrency TaxItem TaxBox21AmtInReportingCurrency
TaxBox22AmtInReportingCurrency TaxItem TaxBox22AmtInReportingCurrency
TaxBox23AmtInReportingCurrency TaxItem TaxBox23AmtInReportingCurrency
TaxBox24AmtInReportingCurrency TaxItem TaxBox24AmtInReportingCurrency
TaxBox25AmtInReportingCurrency TaxItem TaxBox25AmtInReportingCurrency
TaxBox26AmtInReportingCurrency TaxItem TaxBox26AmtInReportingCurrency
TaxBox27AmtInReportingCurrency TaxItem TaxBox27AmtInReportingCurrency
TaxBox29AmtInReportingCurrency TaxItem TaxBox29AmtInReportingCurrency
TaxBox30AmtInReportingCurrency TaxItem TaxBox30AmtInReportingCurrency
TaxBox31AmtInReportingCurrency TaxItem TaxBox31AmtInReportingCurrency
TaxBox32AmtInReportingCurrency TaxItem TaxBox32AmtInReportingCurrency
TaxBox33AmtInReportingCurrency TaxItem TaxBox33AmtInReportingCurrency
WhldgTaxAmtInReportingCrcy WithholdingTaxItem WhldgTaxAmtInReportingCrcy
TaxNumber1elseendasTaxNumber1

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_DIOTReportingItem.
-- 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.
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_CompanyCode : fis_bukrs, P_FiscalYear : fis_gjahr, P_Ledger : fins_ledger

CREATE VIEW P_MX_DIOTReportingItem AS
SELECT
  TaxItem.StatryRptCategory AS StatryRptCategory,
  TaxItem.StatryRptgEntity AS StatryRptgEntity,
  TaxItem.StatryRptRunID AS StatryRptRunID,
  TaxItem.CompanyCode AS CompanyCode,
  TaxItem.Supplier AS Supplier,
  TaxItem.MX_SupplierType AS MX_SupplierType,
  TaxItem.MX_DIOTOperationType AS MX_DIOTOperationType,
  TaxItem.ReportingCurrency AS ReportingCurrency,
  TaxItem.TaxNumberResponsible AS TaxNumberResponsible,
  TaxItem.Country AS Country,
  TaxItem.MX_FiscalEffectManifest AS MX_FiscalEffectManifest,
  TaxItem.MX_BorderClassification AS MX_BorderClassification,
  TaxItem.TaxBox08AmtInReportingCurrency AS TaxBox08AmtInReportingCurrency,
  TaxItem.TaxBox09AmtInReportingCurrency AS TaxBox09AmtInReportingCurrency,
  TaxItem.TaxBox10AmtInReportingCurrency AS TaxBox10AmtInReportingCurrency,
  TaxItem.TaxBox11AmtInReportingCurrency AS TaxBox11AmtInReportingCurrency,
  TaxItem.TaxBox12AmtInReportingCurrency AS TaxBox12AmtInReportingCurrency,
  TaxItem.TaxBox13AmtInReportingCurrency AS TaxBox13AmtInReportingCurrency,
  TaxItem.TaxBox14AmtInReportingCurrency AS TaxBox14AmtInReportingCurrency,
  TaxItem.TaxBox15AmtInReportingCurrency AS TaxBox15AmtInReportingCurrency,
  TaxItem.TaxBox16AmtInReportingCurrency AS TaxBox16AmtInReportingCurrency,
  TaxItem.TaxBox17AmtInReportingCurrency AS TaxBox17AmtInReportingCurrency,
  TaxItem.TaxBox18AmtInReportingCurrency AS TaxBox18AmtInReportingCurrency,
  TaxItem.TaxBox19AmtInReportingCurrency AS TaxBox19AmtInReportingCurrency,
  TaxItem.TaxBox20AmtInReportingCurrency AS TaxBox20AmtInReportingCurrency,
  TaxItem.TaxBox21AmtInReportingCurrency AS TaxBox21AmtInReportingCurrency,
  TaxItem.TaxBox22AmtInReportingCurrency AS TaxBox22AmtInReportingCurrency,
  TaxItem.TaxBox23AmtInReportingCurrency AS TaxBox23AmtInReportingCurrency,
  TaxItem.TaxBox24AmtInReportingCurrency AS TaxBox24AmtInReportingCurrency,
  TaxItem.TaxBox25AmtInReportingCurrency AS TaxBox25AmtInReportingCurrency,
  TaxItem.TaxBox26AmtInReportingCurrency AS TaxBox26AmtInReportingCurrency,
  TaxItem.TaxBox27AmtInReportingCurrency AS TaxBox27AmtInReportingCurrency,
  TaxItem.TaxBox29AmtInReportingCurrency AS TaxBox29AmtInReportingCurrency,
  TaxItem.TaxBox30AmtInReportingCurrency AS TaxBox30AmtInReportingCurrency,
  TaxItem.TaxBox31AmtInReportingCurrency AS TaxBox31AmtInReportingCurrency,
  TaxItem.TaxBox32AmtInReportingCurrency AS TaxBox32AmtInReportingCurrency,
  TaxItem.TaxBox33AmtInReportingCurrency AS TaxBox33AmtInReportingCurrency,
  WithholdingTaxItem.WhldgTaxAmtInReportingCrcy AS WhldgTaxAmtInReportingCrcy,
  case when TaxItem.Country = 'MX' then TaxItem.TaxNumber1 else '' end as TaxNumber1 AS TaxNumber1elseendasTaxNumber1
FROM P_MX_DIOTTaxItemAggregated
;

Learn More