P_TH_StRpDeferTaxPayment

DDL: P_TH_STRPDEFERTAXPAYMENT Type: view_entity COMPOSITE
75 Fields 3 Data Sources

P_TH_StRpDeferTaxPayment is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_StRpTaxReturnBoxCube, I_OperationalAcctgDocItem, P_DefTaxTransfer0) and exposes 75 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, TaxCode.

Data Sources (3)

SourceAliasJoin Type
I_StRpTaxReturnBoxCube I_StRpTaxReturnBoxCube from
I_OperationalAcctgDocItem P_DebtorCreditorRblsPyblsItem inner
P_DefTaxTransfer0 P_DefTaxTransfer inner

Parameters (5)

NameTypeDefault
P_RelevantAmountPosition relevantamountposition
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id
P_ReportingCountry land1

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (75)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_TransferItem CompanyCode Receiver Company Code
KEY AccountingDocument I_TransferItem AccountingDocument Journal Entry
KEY FiscalYear I_TransferItem FiscalYear G/L Fiscal Year
KEY TaxItem I_TransferItem TaxItem Tax Item
KEY TaxCode I_TransferItem TaxCode Tax Code
KEY TransactionTypeDetermination I_TransferItem TransactionTypeDetermination Transaction Key
KEY TaxBox I_TransferItem TaxBox Tax.Bs.Gp.No.
KEY TaxDeclnAmountType I_TransferItem TaxDeclnAmountType
KEY TaxItemGroupingVersion I_TransferItem TaxItemGroupingVersion Tax Grping Ver.
KEY TaxBoxStrucValidityStartDate I_TransferItem TaxBoxStrucValidityStartDate
KEY TaxBoxStructureType I_TransferItem TaxBoxStructureType
KEY TaxGroup I_TransferItem TaxGroup Tax Group
TaxBoxStructure I_TransferItem TaxBoxStructure
TaxCalculationProcedure I_TransferItem TaxCalculationProcedure Tax Procedure
ReportingDate I_TransferItem ReportingDate
PostingDate I_TransferItem PostingDate Posting Date for GR
DocumentDate I_TransferItem DocumentDate Journal Entry Date
TaxReportingDate I_TransferItem TaxReportingDate Tax Reporting Date
FiscalPeriod I_TransferItem FiscalPeriod Tax period
TaxItemGroup I_TransferItem TaxItemGroup Tax doc. item number
AccountingDocumentType I_TransferItem AccountingDocumentType Journal Entry Type
ExchangeRate I_TransferItem ExchangeRate Exchange rate
ClearingDocFiscalYear I_OperationalAcctgDocItem ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry
ClearingAccountingDocument I_OperationalAcctgDocItem ClearingAccountingDocument Clearing Journal Entry
ClearingJournalEntry I_OperationalAcctgDocItem ClearingJournalEntry Clrng doc.
ClearingJournalEntryFiscalYear I_OperationalAcctgDocItem ClearingJournalEntryFiscalYear Fiscal Year of Clearing Journal Entry
PaymentDate
SupplierPaytCurrencyExchRate
PaymentNote I_OperationalAcctgDocItem DocumentItemText Text
DocumentReferenceID
CompanyCodeCountry I_TransferItem CompanyCodeCountry Reporting Ctry/Reg.
ReportingCountry I_TransferItem ReportingCountry
BusinessPartnerCountry I_TransferItem BusinessPartnerCountry BP Ctry/Reg.
TaxRate
TaxRateValidityStartDate I_TransferItem TaxRateValidityStartDate Tax Rate Validity Start Date
IsReversal I_TransferItem IsReversal Reversal doc.
IsReversed I_TransferItem IsReversed Reversed?
AccountingDocumentHeaderText I_TransferItem AccountingDocumentHeaderText Doc.Header Text
GLAccount I_TransferItem GLAccount General Ledger
BusinessPlace I_TransferItem BusinessPlace Business place
TaxJurisdiction I_TransferItem TaxJurisdiction Tax Jurisdiction
LowestLevelTaxJurisdiction I_TransferItem LowestLevelTaxJurisdiction Jurisdict. Code
TaxNumber1
TaxNumber2
TaxNumber3
BusinessPartner I_OperationalAcctgDocItem Supplier Supplier
BusinessPartnerName
AddressIDendasAddressID
SupplierendasSupplier
BusinessPartnerName411asTaxPayerName
CityName
Region
PostalCode
StreetName
Country
TaxType I_TransferItem TaxType Tax Type
CompanyCodeCurrency I_TransferItem CompanyCodeCurrency Local Currency
CountryCurrency I_TransferItem CountryCurrency Currency
DocumentCurrency I_TransferItem DocumentCurrency Document Currency
ReportingCurrencyendasReportingCurrency
AdditionalCurrency1 I_TransferItem AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 I_TransferItem AdditionalCurrency2 Local curr. 3
AmountInTransactionCurrency
TaxBaseAmountInCoCodeCrcy
TaxAmountInCoCodeCrcy
TaxBaseAmountInTransCrcy
TaxAmount
AmountInAdditionalCurrency1 I_TransferItem AmountInAdditionalCurrency1 Amount in Additional Currency 1
AmountInAdditionalCurrency2 I_TransferItem AmountInAdditionalCurrency2 LC2 Amount
TaxBaseAmtInAdditionalCrcy1 I_TransferItem TaxBaseAmtInAdditionalCrcy1 LC 2 Base
TaxBaseAmtInAdditionalCrcy2 I_TransferItem TaxBaseAmtInAdditionalCrcy2 LC 3 Base
TaxAmountInAdditionalCurrency1 I_TransferItem TaxAmountInAdditionalCurrency1 LC 2 Tax
TaxAmountInAdditionalCurrency2 I_TransferItem TaxAmountInAdditionalCurrency2 LC 3 Tax
TaxIsNotDeductible I_TransferItem TaxIsNotDeductible Non-Deductible
_TaxTypeText I_TransferItem _TaxTypeText

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_TH_StRpDeferTaxPayment.
-- 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_RelevantAmountPosition : relevantamountposition, P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_ReportingCountry : land1

CREATE VIEW P_TH_StRpDeferTaxPayment AS
SELECT
  I_TransferItem.CompanyCode AS CompanyCode,
  I_TransferItem.AccountingDocument AS AccountingDocument,
  I_TransferItem.FiscalYear AS FiscalYear,
  I_TransferItem.TaxItem AS TaxItem,
  I_TransferItem.TaxCode AS TaxCode,
  I_TransferItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  I_TransferItem.TaxBox AS TaxBox,
  I_TransferItem.TaxDeclnAmountType AS TaxDeclnAmountType,
  I_TransferItem.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  I_TransferItem.TaxBoxStrucValidityStartDate AS TaxBoxStrucValidityStartDate,
  I_TransferItem.TaxBoxStructureType AS TaxBoxStructureType,
  I_TransferItem.TaxGroup AS TaxGroup,
  I_TransferItem.TaxBoxStructure AS TaxBoxStructure,
  I_TransferItem.TaxCalculationProcedure AS TaxCalculationProcedure,
  I_TransferItem.ReportingDate AS ReportingDate,
  I_TransferItem.PostingDate AS PostingDate,
  I_TransferItem.DocumentDate AS DocumentDate,
  I_TransferItem.TaxReportingDate AS TaxReportingDate,
  I_TransferItem.FiscalPeriod AS FiscalPeriod,
  I_TransferItem.TaxItemGroup AS TaxItemGroup,
  I_TransferItem.AccountingDocumentType AS AccountingDocumentType,
  I_TransferItem.ExchangeRate AS ExchangeRate,
  P_DebtorCreditorRblsPyblsItem.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  P_DebtorCreditorRblsPyblsItem.ClearingAccountingDocument AS ClearingAccountingDocument,
  P_DebtorCreditorRblsPyblsItem.ClearingJournalEntry AS ClearingJournalEntry,
  P_DebtorCreditorRblsPyblsItem.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  P_DebtorCreditorRblsPyblsItem._ClearingAccountingDocument.PostingDate AS PaymentDate,
  P_DebtorCreditorRblsPyblsItem._ClearingAccountingDocument.ExchangeRate AS SupplierPaytCurrencyExchRate,
  P_DebtorCreditorRblsPyblsItem.DocumentItemText AS PaymentNote,
  P_DebtorCreditorRblsPyblsItem._ClearingAccountingDocument.DocumentReferenceID AS DocumentReferenceID,
  I_TransferItem.CompanyCodeCountry AS CompanyCodeCountry,
  I_TransferItem.ReportingCountry AS ReportingCountry,
  I_TransferItem.BusinessPartnerCountry AS BusinessPartnerCountry,
  cast(I_TransferItem.TaxRate as btaux ) AS TaxRate,
  I_TransferItem.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  I_TransferItem.IsReversal AS IsReversal,
  I_TransferItem.IsReversed AS IsReversed,
  I_TransferItem.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  I_TransferItem.GLAccount AS GLAccount,
  I_TransferItem.BusinessPlace AS BusinessPlace,
  I_TransferItem.TaxJurisdiction AS TaxJurisdiction,
  I_TransferItem.LowestLevelTaxJurisdiction AS LowestLevelTaxJurisdiction,
  P_DebtorCreditorRblsPyblsItem._Supplier.TaxNumber1 AS TaxNumber1,
  P_DebtorCreditorRblsPyblsItem._Supplier.TaxNumber2 AS TaxNumber2,
  P_DebtorCreditorRblsPyblsItem._Supplier.TaxNumber3 AS TaxNumber3,
  P_DebtorCreditorRblsPyblsItem.Supplier AS BusinessPartner,
  P_DebtorCreditorRblsPyblsItem._Supplier.SupplierName AS BusinessPartnerName,
  case when P_DebtorCreditorRblsPyblsItem._OneTimeAccountBP.AccountingDocument is null then P_DebtorCreditorRblsPyblsItem._Supplier.AddressID end as AddressID AS AddressIDendasAddressID,
  case when P_DebtorCreditorRblsPyblsItem._OneTimeAccountBP.AccountingDocument is null then P_DebtorCreditorRblsPyblsItem.Supplier end as Supplier AS SupplierendasSupplier,
  concat_with_space(concat_with_space(P_DebtorCreditorRblsPyblsItem._OneTimeAccountBP.BusinessPartnerName1,P_DebtorCreditorRblsPyblsItem._OneTimeAccountBP.BusinessPartnerName2, 1), concat_with_space(P_DebtorCreditorRblsPyblsItem._OneTimeAccountBP.BusinessPartnerName3,P_DebtorCreditorRblsPyblsItem._OneTimeAccountBP.BusinessPartnerName4, 1), 1 ) as TaxPayerName AS BusinessPartnerName411asTaxPayerName,
  P_DebtorCreditorRblsPyblsItem._OneTimeAccountBP.CityName AS CityName,
  P_DebtorCreditorRblsPyblsItem._OneTimeAccountBP.Region AS Region,
  P_DebtorCreditorRblsPyblsItem._OneTimeAccountBP.PostalCode AS PostalCode,
  P_DebtorCreditorRblsPyblsItem._OneTimeAccountBP.StreetAddressName AS StreetName,
  coalesce(P_DebtorCreditorRblsPyblsItem._OneTimeAccountBP.Country, P_DebtorCreditorRblsPyblsItem._Supplier.Country ) AS Country,
  I_TransferItem.TaxType AS TaxType,
  I_TransferItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_TransferItem.CountryCurrency AS CountryCurrency,
  I_TransferItem.DocumentCurrency AS DocumentCurrency,
  case $parameters.P_RelevantAmountPosition when '2' then I_TransferItem.AdditionalCurrency1 when '3' then I_TransferItem.AdditionalCurrency2 when '1' then I_TransferItem.CompanyCodeCurrency else I_TransferItem.ReportingCurrency end as ReportingCurrency AS ReportingCurrencyendasReportingCurrency,
  I_TransferItem.AdditionalCurrency1 AS AdditionalCurrency1,
  I_TransferItem.AdditionalCurrency2 AS AdditionalCurrency2,
  cast(I_TransferItem.AmountInTransactionCurrency as fis_wsl) AS AmountInTransactionCurrency,
  cast (I_TransferItem.TaxBaseAmountInCoCodeCrcy as hwbas_bses ) AS TaxBaseAmountInCoCodeCrcy,
  cast (I_TransferItem.TaxAmountInCoCodeCrcy as hwste) AS TaxAmountInCoCodeCrcy,
  cast(I_TransferItem.TaxBaseAmountInTransCrcy as fwbas_bses ) AS TaxBaseAmountInTransCrcy,
  cast(I_TransferItem.TaxAmount as fwste ) AS TaxAmount,
  I_TransferItem.AmountInAdditionalCurrency1 AS AmountInAdditionalCurrency1,
  I_TransferItem.AmountInAdditionalCurrency2 AS AmountInAdditionalCurrency2,
  I_TransferItem.TaxBaseAmtInAdditionalCrcy1 AS TaxBaseAmtInAdditionalCrcy1,
  I_TransferItem.TaxBaseAmtInAdditionalCrcy2 AS TaxBaseAmtInAdditionalCrcy2,
  I_TransferItem.TaxAmountInAdditionalCurrency1 AS TaxAmountInAdditionalCurrency1,
  I_TransferItem.TaxAmountInAdditionalCurrency2 AS TaxAmountInAdditionalCurrency2,
  I_TransferItem.TaxIsNotDeductible AS TaxIsNotDeductible,
  I_TransferItem._TaxTypeText AS _TaxTypeText
FROM I_StRpTaxReturnBoxCube
INNER JOIN P_DefTaxTransfer0 AS P_DefTaxTransfer ON /* join condition not captured in parsed metadata */
INNER JOIN I_OperationalAcctgDocItem AS P_DebtorCreditorRblsPyblsItem ON /* join condition not captured in parsed metadata */
;

Learn More