I_MX_DIOTTxItmBusinessPartner

DDL: I_MX_DIOTTXITMBUSINESSPARTNER Type: view_entity COMPOSITE Package: GLO_FIN_IS_VAT_MX
61 Fields 5 Data Sources

MX DIOT Tax Details with BP info

I_MX_DIOTTxItmBusinessPartner is a Composite CDS View that provides data about "MX DIOT Tax Details with BP info" in SAP S/4HANA. It reads from 5 data sources (I_MX_BusinessPartner, I_MX_BusinessPartner, I_JournalEntryItemOneTimeData, P_MX_DIOTTaxItemSupplier, P_MX_DIOTTaxItemSupplier) and exposes 61 fields with key fields CompanyCode, AccountingDocument, AccountingDocumentItem, FiscalYear, StatryRptCategory. Part of development package GLO_FIN_IS_VAT_MX.

Data Sources (5)

SourceAliasJoin Type
I_MX_BusinessPartner I_MX_BusinessPartner inner
I_MX_BusinessPartner I_MX_BusinessPartner inner
I_JournalEntryItemOneTimeData OneTimeBPItem inner
P_MX_DIOTTaxItemSupplier P_MX_DIOTTaxItemSupplier from
P_MX_DIOTTaxItemSupplier P_MX_DIOTTaxItemSupplier union_all

Parameters (6)

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

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label MX DIOT Tax Details with BP info view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view

Fields (61)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode TaxItem CompanyCode Receiver Company Code
KEY AccountingDocument TaxItem AccountingDocument Journal Entry
KEY AccountingDocumentItem TaxItem AccountingDocumentItem Posting View Item
KEY FiscalYear TaxItem FiscalYear G/L Fiscal Year
KEY StatryRptCategory TaxItem StatryRptCategory Report ID
KEY StatryRptgEntity TaxItem StatryRptgEntity Reporting Entity
KEY StatryRptRunID TaxItem StatryRptRunID Report Run ID
KEY TaxTransferDocument TaxItem TaxTransferDocument Document Number
KEY TaxTransferDocumentYear TaxItem TaxTransferDocumentYear
KEY PaymentDocument TaxItem PaymentDocument Payment Document Number
KEY SenderFiscalYear TaxItem SenderFiscalYear Sender FiscalYr
KEY TaxCode TaxItem TaxCode Tax Code
KEY TaxBox TaxItem TaxBox Tax.Bs.Gp.No.
KEY TaxDeclnAmountType TaxItem TaxDeclnAmountType
KEY Supplier TaxItem Supplier Supplier
KEY MX_DIOTOperationType TaxItem MX_DIOTOperationType
KEY MX_SupplierType TaxItem MX_SupplierType
ReportingCurrency TaxItem ReportingCurrency Currency
BusinessPartnerName BusinessPartner BusinessPartnerName Extracted Customer Name
Country BusinessPartner Country Venue: Ctry/Reg
CountryThreeLetterISOCode BusinessPartner CountryThreeLetterISOCode
MX_BorderClassification RegionClassification MX_BorderClassification
IsOneTimeAccount BusinessPartner IsOneTimeAccount One-time acct
TaxNumber1 BusinessPartner TaxNumber1 Tax Number 1
TaxNumberResponsible BusinessPartner TaxNumberResponsible
NationalityName
CountryNameasMX_FullAddressText
TaxBaseAmountInRptgCrcy TaxItem TaxBaseAmountInRptgCrcy Base Amount
P_CompanyCode
P_FiscalYear
P_StatryRptgEntity
P_StatryRptCategory
P_StatryRptRunID
CompanyCode Receiver Company Code
KEY AccountingDocument TaxItem AccountingDocument Journal Entry
KEY AccountingDocumentItem TaxItem AccountingDocumentItem Posting View Item
KEY FiscalYear TaxItem FiscalYear G/L Fiscal Year
KEY StatryRptCategory TaxItem StatryRptCategory Report ID
KEY StatryRptgEntity TaxItem StatryRptgEntity Reporting Entity
KEY StatryRptRunID TaxItem StatryRptRunID Report Run ID
KEY TaxTransferDocument TaxItem TaxTransferDocument Document Number
KEY TaxTransferDocumentYear TaxItem TaxTransferDocumentYear
KEY PaymentDocument TaxItem PaymentDocument Payment Document Number
KEY SenderFiscalYear TaxItem SenderFiscalYear Sender FiscalYr
KEY TaxCode TaxItem TaxCode Tax Code
KEY TaxBox TaxItem TaxBox Tax.Bs.Gp.No.
KEY TaxDeclnAmountType TaxItem TaxDeclnAmountType
KEY Supplier TaxItem Supplier Supplier
KEY MX_DIOTOperationType TaxItem MX_DIOTOperationType
KEY MX_SupplierType TaxItem MX_SupplierType
ReportingCurrency TaxItem ReportingCurrency Currency
Country I_JournalEntryItemOneTimeData Country Venue: Ctry/Reg
CountryThreeLetterISOCode BusinessPartner CountryThreeLetterISOCode
MX_BorderClassification RegionClassification MX_BorderClassification
IsOneTimeAccount BusinessPartner IsOneTimeAccount One-time acct
TaxNumber1 I_JournalEntryItemOneTimeData TaxID1 Tax Number 1
TaxNumberResponsible BusinessPartner TaxNumberResponsible
NationalityName
CountryNameasMX_FullAddressText
TaxBaseAmountInRptgCrcy TaxItem TaxBaseAmountInRptgCrcy Base Amount
TaxAmountInRptgCrcy TaxItem TaxAmountInRptgCrcy Tax Rept. Crcy

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

CREATE VIEW I_MX_DIOTTxItmBusinessPartner AS
SELECT
  TaxItem.CompanyCode AS CompanyCode,
  TaxItem.AccountingDocument AS AccountingDocument,
  TaxItem.AccountingDocumentItem AS AccountingDocumentItem,
  TaxItem.FiscalYear AS FiscalYear,
  TaxItem.StatryRptCategory AS StatryRptCategory,
  TaxItem.StatryRptgEntity AS StatryRptgEntity,
  TaxItem.StatryRptRunID AS StatryRptRunID,
  TaxItem.TaxTransferDocument AS TaxTransferDocument,
  TaxItem.TaxTransferDocumentYear AS TaxTransferDocumentYear,
  TaxItem.PaymentDocument AS PaymentDocument,
  TaxItem.SenderFiscalYear AS SenderFiscalYear,
  TaxItem.TaxCode AS TaxCode,
  TaxItem.TaxBox AS TaxBox,
  TaxItem.TaxDeclnAmountType AS TaxDeclnAmountType,
  TaxItem.Supplier AS Supplier,
  TaxItem.MX_DIOTOperationType AS MX_DIOTOperationType,
  TaxItem.MX_SupplierType AS MX_SupplierType,
  TaxItem.ReportingCurrency AS ReportingCurrency,
  BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  BusinessPartner.Country AS Country,
  BusinessPartner.CountryThreeLetterISOCode AS CountryThreeLetterISOCode,
  RegionClassification.MX_BorderClassification AS MX_BorderClassification,
  BusinessPartner.IsOneTimeAccount AS IsOneTimeAccount,
  BusinessPartner.TaxNumber1 AS TaxNumber1,
  BusinessPartner.TaxNumberResponsible AS TaxNumberResponsible,
  '' AS NationalityName,
  concat(BusinessPartner.StreetName, concat(', ', concat(BusinessPartner.PostalCode, concat(', ', concat(BusinessPartner.CityName, concat(', ', concat(BusinessPartner.Region, concat(', ', BusinessPartner.CountryName)))))))) as MX_FullAddressText AS CountryNameasMX_FullAddressText,
  TaxItem.TaxBaseAmountInRptgCrcy AS TaxBaseAmountInRptgCrcy,
  TaxItem.TaxAmountInRptgCrcy AS P_CompanyCode,
  P_FiscalYear : $parameters.P_FiscalYear AS P_FiscalYear,
  P_StatryRptgEntity : $parameters.P_StatryRptgEntity AS P_StatryRptgEntity,
  P_StatryRptCategory : $parameters.P_StatryRptCategory AS P_StatryRptCategory,
  P_StatryRptRunID : $parameters.P_StatryRptRunID AS P_StatryRptRunID,
  TaxItem.TaxAmountInRptgCrcy AS TaxAmountInRptgCrcy
FROM P_MX_DIOTTaxItemSupplier
INNER JOIN I_MX_BusinessPartner ON /* join condition not captured in parsed metadata */
INNER JOIN I_JournalEntryItemOneTimeData AS OneTimeBPItem ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_MX_DIOTTaxItemSupplier
;

Learn More