P_MY_TxItmWithSlsDeductionAmt

DDL: P_MY_TXITMWITHSLSDEDUCTIONAMT Type: view COMPOSITE Package: GLO_FIN_IS_VAT_MY
74 Fields 2 Data Sources

Tax Item with Sales Deduction Amount

P_MY_TxItmWithSlsDeductionAmt is a Composite CDS View that provides data about "Tax Item with Sales Deduction Amount" in SAP S/4HANA. It reads from 2 data sources (I_Supplier, P_MY_TDTTAXRATE) and exposes 74 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, TaxCode. Part of development package GLO_FIN_IS_VAT_MY.

Data Sources (2)

SourceAliasJoin Type
I_Supplier _Supplier left_outer
P_MY_TDTTAXRATE P_MY_TDTTAXRATE from

Parameters (3)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id

Annotations (7)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName PMYTXIMWSTDAMT view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (74)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_StRpTaxItemBoxCube CompanyCode Receiver Company Code
KEY AccountingDocument I_StRpTaxItemBoxCube AccountingDocument Journal Entry
KEY FiscalYear I_StRpTaxItemBoxCube FiscalYear G/L Fiscal Year
KEY TaxItem TaxItem Tax Item
KEY TaxCode I_StRpTaxItemBoxCube TaxCode Tax Code
KEY TransactionTypeDetermination I_StRpTaxItemBoxCube TransactionTypeDetermination Transaction Key
KEY TaxBox I_StRpTaxItemBoxCube TaxBox Tax.Bs.Gp.No.
KEY TaxDeclnAmountType I_StRpTaxItemBoxCube TaxDeclnAmountType
KEY TaxItemGroupingVersion I_StRpTaxItemBoxCube TaxItemGroupingVersion Tax Grping Ver.
KEY ValidFrom I_StRpTaxItemBoxCube ValidFrom Vers.Valid From
KEY TaxBoxStructureType I_StRpTaxItemBoxCube TaxBoxStructureType
KEY TaxGroup I_StRpTaxItemBoxCube TaxGroup Tax Group
KEY TaxBoxAggregationOperation TaxBoxAggregationOperation
StatryRptRun StatryRptRun
CAReconciliationKey CAReconciliationKey Reconcil. Key
TaxRate TaxRate Tax Rate
TaxRateValidityStartDate TaxRateValidityStartDate Tax Rate Validity Start Date
GLAccount GLAccount General Ledger
BusinessPlace BusinessPlace Business place
TaxJurisdiction I_StRpTaxItemBoxCube TaxJurisdiction Tax Jurisdiction
LowestLevelTaxJurisdiction LowestLevelTaxJurisdiction Jurisdict. Code
AccountingDocumentType AccountingDocumentType Journal Entry Type
ReferenceDocumentType ReferenceDocumentType Reference Document Type
ReverseDocument ReverseDocument Reversed With
ReverseDocumentFiscalYear ReverseDocumentFiscalYear Year
DocumentReferenceID DocumentReferenceID Reference
Ledger Ledger Ledger
LedgerGroup LedgerGroup Ledger Group
ReportingDate ReportingDate
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
TaxReportingDate TaxReportingDate Tax Reporting Date
FiscalPeriod FiscalPeriod Tax period
ExchangeRate ExchangeRate Exchange rate
IsReversal IsReversal Reversal doc.
IsReversed IsReversed Reversed?
AccountingDocumentHeaderText AccountingDocumentHeaderText Doc.Header Text
TaxType I_StRpTaxItemBoxCube TaxType Tax Type
ReportingCountry ReportingCountry
CompanyCodeCountry CompanyCodeCountry Reporting Ctry/Reg.
BusinessPartner I_StRpTaxItemBoxCube BusinessPartner Issuing Authority
BusinessPartnerCountry BusinessPartnerCountry BP Ctry/Reg.
BusinessPartnerName BusinessPartnerName Extracted Customer Name
CustomerSupplierAddress CustomerSupplierAddress
MY_CompanyRegistrationNumber
TaxNumber1 I_StRpTaxItemBoxCube TaxNumber1 VAT Reg. No.
TaxNumber2 I_StRpTaxItemBoxCube TaxNumber2 Tax Number 2
TaxNumber3 I_StRpTaxItemBoxCube TaxNumber3 Tax Number 3
CountryCurrency CountryCurrency Currency
TaxBaseAmountInCountryCrcy TaxBaseAmountInCountryCrcy Base Amount
TaxAmountInCountryCrcy TaxAmountInCountryCrcy Tax Rept. Crcy
ReportingCurrency I_StRpTaxItemBoxCube ReportingCurrency Currency
fltpendasAmountInReportingCurrency
TaxBaseAmountInRptgCrcy I_StRpTaxItemBoxCube TaxBaseAmountInRptgCrcy Base Amount
TaxAmountInRptgCrcy I_StRpTaxItemBoxCube TaxAmountInRptgCrcy Tax Rept. Crcy
DocumentCurrency I_StRpTaxItemBoxCube DocumentCurrency Document Currency
fltpendasAmountInTransactionCurrency
TaxBaseAmountInTransCrcy I_StRpTaxItemBoxCube TaxBaseAmountInTransCrcy Value-Added Tax
TaxAmount I_StRpTaxItemBoxCube TaxAmount Tax Amt in Rptg Crcy
CompanyCodeCurrency CompanyCodeCurrency Local Currency
TaxBaseAmountInCoCodeCrcy I_StRpTaxItemBoxCube TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxAmountInCoCodeCrcy I_StRpTaxItemBoxCube TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
AdditionalCurrency1 AdditionalCurrency1 Local curr. 2
fltpendasAmountInAdditionalCurrency1
TaxBaseAmtInAdditionalCrcy1 TaxBaseAmtInAdditionalCrcy1 LC 2 Base
TaxAmountInAdditionalCurrency1 TaxAmountInAdditionalCurrency1 LC 2 Tax
AdditionalCurrency2 AdditionalCurrency2 Local curr. 3
fltpendasAmountInAdditionalCurrency2
TaxBaseAmtInAdditionalCrcy2 TaxBaseAmtInAdditionalCrcy2 LC 3 Base
TaxAmountInAdditionalCurrency2 TaxAmountInAdditionalCurrency2 LC 3 Tax
_AccountingDocument _AccountingDocument
_GLAccount _GLAccount
_TaxJurisdiction _TaxJurisdiction
_ReportedItemsLog _ReportedItemsLog

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

CREATE VIEW P_MY_TxItmWithSlsDeductionAmt AS
SELECT
  I_StRpTaxItemBoxCube.CompanyCode AS CompanyCode,
  I_StRpTaxItemBoxCube.AccountingDocument AS AccountingDocument,
  I_StRpTaxItemBoxCube.FiscalYear AS FiscalYear,
  TaxItem,
  I_StRpTaxItemBoxCube.TaxCode AS TaxCode,
  I_StRpTaxItemBoxCube.TransactionTypeDetermination AS TransactionTypeDetermination,
  I_StRpTaxItemBoxCube.TaxBox AS TaxBox,
  I_StRpTaxItemBoxCube.TaxDeclnAmountType AS TaxDeclnAmountType,
  I_StRpTaxItemBoxCube.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  I_StRpTaxItemBoxCube.ValidFrom AS ValidFrom,
  I_StRpTaxItemBoxCube.TaxBoxStructureType AS TaxBoxStructureType,
  I_StRpTaxItemBoxCube.TaxGroup AS TaxGroup,
  TaxBoxAggregationOperation,
  StatryRptRun,
  CAReconciliationKey,
  TaxRate,
  TaxRateValidityStartDate,
  GLAccount,
  BusinessPlace,
  I_StRpTaxItemBoxCube.TaxJurisdiction AS TaxJurisdiction,
  LowestLevelTaxJurisdiction,
  AccountingDocumentType,
  ReferenceDocumentType,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  DocumentReferenceID,
  Ledger,
  LedgerGroup,
  ReportingDate,
  PostingDate,
  DocumentDate,
  TaxReportingDate,
  FiscalPeriod,
  ExchangeRate,
  IsReversal,
  IsReversed,
  AccountingDocumentHeaderText,
  I_StRpTaxItemBoxCube.TaxType AS TaxType,
  ReportingCountry,
  CompanyCodeCountry,
  I_StRpTaxItemBoxCube.BusinessPartner AS BusinessPartner,
  BusinessPartnerCountry,
  BusinessPartnerName,
  CustomerSupplierAddress,
  cast(_Supplier._AddressRepresentation.AddressSearchTerm2 as fimy_crn) AS MY_CompanyRegistrationNumber,
  I_StRpTaxItemBoxCube.TaxNumber1 AS TaxNumber1,
  I_StRpTaxItemBoxCube.TaxNumber2 AS TaxNumber2,
  I_StRpTaxItemBoxCube.TaxNumber3 AS TaxNumber3,
  CountryCurrency,
  TaxBaseAmountInCountryCrcy,
  TaxAmountInCountryCrcy,
  I_StRpTaxItemBoxCube.ReportingCurrency AS ReportingCurrency,
  case I_StRpTaxItemBoxCube.TaxGroupOperation when '' then I_StRpTaxItemBoxCube.AmountInReportingCurrency else cast (TaxCodeRatePointer as abap.fltp) * cast( I_StRpTaxItemBoxCube.TaxBaseAmountInRptgCrcy as abap.fltp) end as AmountInReportingCurrency AS fltpendasAmountInReportingCurrency,
  I_StRpTaxItemBoxCube.TaxBaseAmountInRptgCrcy AS TaxBaseAmountInRptgCrcy,
  I_StRpTaxItemBoxCube.TaxAmountInRptgCrcy AS TaxAmountInRptgCrcy,
  I_StRpTaxItemBoxCube.DocumentCurrency AS DocumentCurrency,
  case I_StRpTaxItemBoxCube.TaxGroupOperation when '' then I_StRpTaxItemBoxCube.AmountInTransactionCurrency else cast (TaxCodeRatePointer as abap.fltp) * cast( I_StRpTaxItemBoxCube.TaxBaseAmountInTransCrcy as abap.fltp) end as AmountInTransactionCurrency AS fltpendasAmountInTransactionCurrency,
  I_StRpTaxItemBoxCube.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  I_StRpTaxItemBoxCube.TaxAmount AS TaxAmount,
  CompanyCodeCurrency,
  I_StRpTaxItemBoxCube.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  I_StRpTaxItemBoxCube.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  AdditionalCurrency1,
  case I_StRpTaxItemBoxCube.TaxGroupOperation when '' then I_StRpTaxItemBoxCube.AmountInAdditionalCurrency1 else cast (TaxCodeRatePointer as abap.fltp) * cast( I_StRpTaxItemBoxCube.TaxBaseAmtInAdditionalCrcy1 as abap.fltp) end as AmountInAdditionalCurrency1 AS fltpendasAmountInAdditionalCurrency1,
  TaxBaseAmtInAdditionalCrcy1,
  TaxAmountInAdditionalCurrency1,
  AdditionalCurrency2,
  case I_StRpTaxItemBoxCube.TaxGroupOperation when '' then I_StRpTaxItemBoxCube.AmountInAdditionalCurrency2 else cast (TaxCodeRatePointer as abap.fltp) * cast( I_StRpTaxItemBoxCube.TaxBaseAmtInAdditionalCrcy2 as abap.fltp) end as AmountInAdditionalCurrency2 AS fltpendasAmountInAdditionalCurrency2,
  TaxBaseAmtInAdditionalCrcy2,
  TaxAmountInAdditionalCurrency2
FROM P_MY_TDTTAXRATE
LEFT OUTER JOIN I_Supplier AS _Supplier ON /* join condition not captured in parsed metadata */
;

Learn More