P_TxDocStRpActy1

DDL: P_TXDOCSTRPACTY1 SQL: PTXDOCSTRPACTY1 Type: view COMPOSITE
56 Fields 2 Data Sources

P_TxDocStRpActy1 is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_TaxItem, P_TxDocStRpActy0) and exposes 56 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, TaxItemUUID.

Data Sources (2)

SourceAliasJoin Type
I_TaxItem I_TaxItem inner
P_TxDocStRpActy0 P_TxDocStRpActy0 from

Parameters (2)

NameTypeDefault
P_TaxReportingFromDate vatdate
P_TaxReportingToDate vatdate

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PTXDOCSTRPACTY1 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view

Fields (56)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode TaxItem CompanyCode Receiver Company Code
KEY AccountingDocument TaxItem AccountingDocument Journal Entry
KEY FiscalYear TaxItem FiscalYear G/L Fiscal Year
KEY TaxItem TaxItem TaxItem Tax Item
KEY TaxItemUUID TaxItem TaxItemUUID
TaxCode TaxItem TaxCode Tax Code
GLAccount TaxItem GLAccount General Ledger
TaxItemGroup TaxItem TaxItemGroup Tax doc. item number
TaxBaseAmountInCoCodeCrcy TaxItem TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxBaseAmountInTransCrcy TaxItem TaxBaseAmountInTransCrcy Value-Added Tax
TaxAmountInCoCodeCrcy TaxItem TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxAmount TaxItem TaxAmount Tax Amt in Rptg Crcy
TransactionTypeDetermination TaxItem TransactionTypeDetermination Transaction Key
ConditionRecord TaxItem ConditionRecord Cond.Record No.
VATRegistration TaxItem VATRegistration VAT Registration No.
DestinationCountry TaxItem DestinationCountry Dest. Ctry/Reg
SupplyingCountry TaxItem SupplyingCountry Supplying Ctry/Reg.
TaxJurisdiction TaxItem TaxJurisdiction Tax Jurisdiction
TaxAmountInAdditionalCurrency1 TaxItem TaxAmountInAdditionalCurrency1 LC 2 Tax
TaxAmountInAdditionalCurrency2 TaxItem TaxAmountInAdditionalCurrency2 LC 3 Tax
TaxBaseAmtInAdditionalCrcy1 TaxItem TaxBaseAmtInAdditionalCrcy1 LC 2 Base
TaxBaseAmtInAdditionalCrcy2 TaxItem TaxBaseAmtInAdditionalCrcy2 LC 3 Base
ConditionType TaxItem ConditionType Condition type
TaxReturnDate TaxItem TaxReturnDate
TaxReturnExecutionTime TaxItem TaxReturnExecutionTime
TaxReportingDate TaxItem TaxReportingDate Tax Reporting Date
TaxRate TaxItem TaxRate Tax Rate
TaxReturnCountry TaxItem TaxReturnCountry Reporting C/R
TaxAmountInCountryCrcy TaxItem TaxAmountInCountryCrcy Tax Rept. Crcy
TaxBaseAmountInCountryCrcy TaxItem TaxBaseAmountInCountryCrcy Base Amount
TaxDeterminationDate TaxItem TaxDeterminationDate Tx Determination Dte
BusinessPlace TaxItem BusinessPlace Business place
LowestLevelTaxJurisdiction TaxItem LowestLevelTaxJurisdiction Jurisdict. Code
TaxJurisdictionLevel TaxItem TaxJurisdictionLevel Jurisdiction level
TaxItemAcctgDocItemRef TaxItem TaxItemAcctgDocItemRef Tax doc. item number
TaxResultManualModification TaxItem TaxResultManualModification Tax Modified
DebitCreditCode TaxItem DebitCreditCode Single-Character Flag
TaxRateValidityStartDate TaxItem TaxRateValidityStartDate Tax Rate Validity Start Date
TaxCountry TaxItem TaxCountry Tax Ctry/Reg.
CompanyCodeCurrency TaxItem CompanyCodeCurrency Local Currency
CompanyCodeCountry TaxItem CompanyCodeCountry Reporting Ctry/Reg.
DocumentCurrency TaxItem DocumentCurrency Document Currency
AdditionalCurrency1 TaxItem AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 TaxItem AdditionalCurrency2 Local curr. 3
CountryCurrency TaxItem CountryCurrency Currency
TaxDataSource TaxItem TaxDataSource
_AccountingDocument TaxItem _AccountingDocument
_CompanyCodeCountry TaxItem _CompanyCodeCountry
_CompanyCodeCurrency TaxItem _CompanyCodeCurrency
_Currency TaxItem _Currency
_DebtorCreditorRblsPyblsItem TaxItem _DebtorCreditorRblsPyblsItem
_GLAccount TaxItem _GLAccount
_JournalEntry TaxItem _JournalEntry
_ReceivablesPayablesItem TaxItem _ReceivablesPayablesItem
_TaxJurisdiction TaxItem _TaxJurisdiction
_TaxReceivablesPayablesItem TaxItem _TaxReceivablesPayablesItem

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_TxDocStRpActy1.
-- 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.
-- SQL view name: PTXDOCSTRPACTY1
-- Parameters: P_TaxReportingFromDate : vatdate, P_TaxReportingToDate : vatdate

CREATE VIEW P_TxDocStRpActy1 AS
SELECT
  TaxItem.CompanyCode AS CompanyCode,
  TaxItem.AccountingDocument AS AccountingDocument,
  TaxItem.FiscalYear AS FiscalYear,
  TaxItem.TaxItem AS TaxItem,
  TaxItem.TaxItemUUID AS TaxItemUUID,
  TaxItem.TaxCode AS TaxCode,
  TaxItem.GLAccount AS GLAccount,
  TaxItem.TaxItemGroup AS TaxItemGroup,
  TaxItem.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  TaxItem.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  TaxItem.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  TaxItem.TaxAmount AS TaxAmount,
  TaxItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  TaxItem.ConditionRecord AS ConditionRecord,
  TaxItem.VATRegistration AS VATRegistration,
  TaxItem.DestinationCountry AS DestinationCountry,
  TaxItem.SupplyingCountry AS SupplyingCountry,
  TaxItem.TaxJurisdiction AS TaxJurisdiction,
  TaxItem.TaxAmountInAdditionalCurrency1 AS TaxAmountInAdditionalCurrency1,
  TaxItem.TaxAmountInAdditionalCurrency2 AS TaxAmountInAdditionalCurrency2,
  TaxItem.TaxBaseAmtInAdditionalCrcy1 AS TaxBaseAmtInAdditionalCrcy1,
  TaxItem.TaxBaseAmtInAdditionalCrcy2 AS TaxBaseAmtInAdditionalCrcy2,
  TaxItem.ConditionType AS ConditionType,
  TaxItem.TaxReturnDate AS TaxReturnDate,
  TaxItem.TaxReturnExecutionTime AS TaxReturnExecutionTime,
  TaxItem.TaxReportingDate AS TaxReportingDate,
  TaxItem.TaxRate AS TaxRate,
  TaxItem.TaxReturnCountry AS TaxReturnCountry,
  TaxItem.TaxAmountInCountryCrcy AS TaxAmountInCountryCrcy,
  TaxItem.TaxBaseAmountInCountryCrcy AS TaxBaseAmountInCountryCrcy,
  TaxItem.TaxDeterminationDate AS TaxDeterminationDate,
  TaxItem.BusinessPlace AS BusinessPlace,
  TaxItem.LowestLevelTaxJurisdiction AS LowestLevelTaxJurisdiction,
  TaxItem.TaxJurisdictionLevel AS TaxJurisdictionLevel,
  TaxItem.TaxItemAcctgDocItemRef AS TaxItemAcctgDocItemRef,
  TaxItem.TaxResultManualModification AS TaxResultManualModification,
  TaxItem.DebitCreditCode AS DebitCreditCode,
  TaxItem.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  TaxItem.TaxCountry AS TaxCountry,
  TaxItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  TaxItem.CompanyCodeCountry AS CompanyCodeCountry,
  TaxItem.DocumentCurrency AS DocumentCurrency,
  TaxItem.AdditionalCurrency1 AS AdditionalCurrency1,
  TaxItem.AdditionalCurrency2 AS AdditionalCurrency2,
  TaxItem.CountryCurrency AS CountryCurrency,
  TaxItem.TaxDataSource AS TaxDataSource,
  TaxItem._AccountingDocument AS _AccountingDocument,
  TaxItem._CompanyCodeCountry AS _CompanyCodeCountry,
  TaxItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
  TaxItem._Currency AS _Currency,
  TaxItem._DebtorCreditorRblsPyblsItem AS _DebtorCreditorRblsPyblsItem,
  TaxItem._GLAccount AS _GLAccount,
  TaxItem._JournalEntry AS _JournalEntry,
  TaxItem._ReceivablesPayablesItem AS _ReceivablesPayablesItem,
  TaxItem._TaxJurisdiction AS _TaxJurisdiction,
  TaxItem._TaxReceivablesPayablesItem AS _TaxReceivablesPayablesItem
FROM P_TxDocStRpActy0
INNER JOIN I_TaxItem ON /* join condition not captured in parsed metadata */
;

Learn More