P_PT_TaxRetBoxItemWithRegn

DDL: P_PT_TAXRETBOXITEMWITHREGN Type: view_entity COMPOSITE Package: GLO_FIN_IS_VAT_PT
64 Fields 1 Data Sources

PT Tax Items with Registration detail

P_PT_TaxRetBoxItemWithRegn is a Composite CDS View that provides data about "PT Tax Items with Registration detail" in SAP S/4HANA. It reads from 1 data source (P_PT_TaxReturnBoxItem) and exposes 64 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, TransactionTypeDetermination. Part of development package GLO_FIN_IS_VAT_PT.

Data Sources (1)

SourceAliasJoin Type
P_PT_TaxReturnBoxItem P_PT_TaxReturnBoxItem from

Parameters (4)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id
P_ReportingCountry land1

Annotations (7)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label PT Tax Items with Registration detail view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (64)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_PT_TaxReturnBoxItem CompanyCode Receiver Company Code
KEY AccountingDocument P_PT_TaxReturnBoxItem AccountingDocument Journal Entry
KEY FiscalYear P_PT_TaxReturnBoxItem FiscalYear G/L Fiscal Year
KEY TaxItem P_PT_TaxReturnBoxItem TaxItem Tax Item
KEY TransactionTypeDetermination P_PT_TaxReturnBoxItem TransactionTypeDetermination Transaction Key
KEY DebitCreditCode P_PT_TaxReturnBoxItem DebitCreditCode Single-Character Flag
KEY AccountingDocumentType P_PT_TaxReturnBoxItem AccountingDocumentType Journal Entry Type
KEY SupplierAccountGroup P_PT_TaxReturnBoxItem SupplierAccountGroup Account group
KEY TaxBox P_PT_TaxReturnBoxItem TaxBox Tax.Bs.Gp.No.
KEY TaxDeclnAmountType P_PT_TaxReturnBoxItem TaxDeclnAmountType
KEY ValidityStartDate P_PT_TaxReturnBoxItem ValidityStartDate Validity Start Date
KEY UnifiedTaxBoxStructureType P_PT_TaxReturnBoxItem UnifiedTaxBoxStructureType
KEY TaxGroup P_PT_TaxReturnBoxItem TaxGroup Tax Group
KEY TaxItemGrpgDebitCreditCode P_PT_TaxReturnBoxItem TaxItemGrpgDebitCreditCode
KEY TaxItemGrpgAcctgDocumentType P_PT_TaxReturnBoxItem TaxItemGrpgAcctgDocumentType
KEY TaxItemGrpgSupplierAcctGroup P_PT_TaxReturnBoxItem TaxItemGrpgSupplierAcctGroup
KEY TaxItemGrpgSpecialGLCode P_PT_TaxReturnBoxItem TaxItemGrpgSpecialGLCode
KEY StatryRptgEntity P_PT_TaxReturnBoxItem StatryRptgEntity Reporting Entity
KEY StatryRptCategory P_PT_TaxReturnBoxItem StatryRptCategory Report ID
KEY StatryRptRunID P_PT_TaxReturnBoxItem StatryRptRunID Report Run ID
KEY TaxCalculationProcedure P_PT_TaxReturnBoxItem TaxCalculationProcedure Tax Procedure
KEY TaxCode P_PT_TaxReturnBoxItem TaxCode Tax Code
PT_AnnexSuplrDocIssueMonth
PT_AnnexSuplrDocIssueYear
ReportingYear
DocumentReferenceID P_PT_TaxReturnBoxItem DocumentReferenceID Reference
AccountingDocumentHeaderText P_PT_TaxReturnBoxItem AccountingDocumentHeaderText Doc.Header Text
Country P_PT_TaxReturnBoxItem Country Venue: Ctry/Reg
TaxItemGroupingVersion P_PT_TaxReturnBoxItem TaxItemGroupingVersion Tax Grping Ver.
TaxBoxStructureType P_PT_TaxReturnBoxItem TaxBoxStructureType
ValidityEndDate P_PT_TaxReturnBoxItem ValidityEndDate ValidTo
TaxRate P_PT_TaxReturnBoxItem TaxRate Tax Rate
TaxRateValidityStartDate P_PT_TaxReturnBoxItem TaxRateValidityStartDate Tax Rate Validity Start Date
GLAccount P_PT_TaxReturnBoxItem GLAccount General Ledger
TaxItemGroup P_PT_TaxReturnBoxItem TaxItemGroup Tax doc. item number
ReferenceDocumentType P_PT_TaxReturnBoxItem ReferenceDocumentType Reference Document Type
PostingDate P_PT_TaxReturnBoxItem PostingDate Posting Date for GR
DocumentDate P_PT_TaxReturnBoxItem DocumentDate Journal Entry Date
TaxReportingDate P_PT_TaxReturnBoxItem TaxReportingDate Tax Reporting Date
ReportingDate P_PT_TaxReturnBoxItem ReportingDate
FiscalPeriod P_PT_TaxReturnBoxItem FiscalPeriod Tax period
CompanyCodeCountry P_PT_TaxReturnBoxItem CompanyCodeCountry Reporting Ctry/Reg.
ReportingCountry P_PT_TaxReturnBoxItem ReportingCountry
TaxReturnCountry P_PT_TaxReturnBoxItem TaxReturnCountry Reporting C/R
CompanyCodeCurrency P_PT_TaxReturnBoxItem CompanyCodeCurrency Local Currency
DocumentCurrency P_PT_TaxReturnBoxItem DocumentCurrency Document Currency
ReportingCurrency P_PT_TaxReturnBoxItem ReportingCurrency Currency
AmountInReportingCurrency P_PT_TaxReturnBoxItem AmountInReportingCurrency
TaxBaseAmountInRptgCrcy P_PT_TaxReturnBoxItem TaxBaseAmountInRptgCrcy Base Amount
TaxAmountInRptgCrcy P_PT_TaxReturnBoxItem TaxAmountInRptgCrcy Tax Rept. Crcy
NonDeductibleInputTaxAmount P_PT_TaxReturnBoxItem NonDeductibleInputTaxAmount Non-deductible
TaxBaseAmountInCoCodeCrcy P_PT_TaxReturnBoxItem TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxAmountInCoCodeCrcy P_PT_TaxReturnBoxItem TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxBaseAmountInTransCrcy P_PT_TaxReturnBoxItem TaxBaseAmountInTransCrcy Value-Added Tax
TaxAmount P_PT_TaxReturnBoxItem TaxAmount Tax Amt in Rptg Crcy
TargetTaxCode P_PT_TaxReturnBoxItem TargetTaxCode
CAReconciliationKey P_PT_TaxReturnBoxItem CAReconciliationKey Reconcil. Key
StatryRptRun P_PT_TaxReturnBoxItem StatryRptRun
TaxTypeName P_PT_TaxReturnBoxItem TaxTypeName
TaxIsNotDeductible P_PT_TaxReturnBoxItem TaxIsNotDeductible Non-Deductible
TaxBoxStructure P_PT_TaxReturnBoxItem TaxBoxStructure
TaxBoxStructureName P_PT_TaxReturnBoxItem TaxBoxStructureName
TaxBoxName P_PT_TaxReturnBoxItem TaxBoxName
TaxBoxCondition P_PT_TaxReturnBoxItem TaxBoxCondition

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_PT_TaxRetBoxItemWithRegn.
-- 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_ReportingCountry : land1

CREATE VIEW P_PT_TaxRetBoxItemWithRegn AS
SELECT
  P_PT_TaxReturnBoxItem.CompanyCode AS CompanyCode,
  P_PT_TaxReturnBoxItem.AccountingDocument AS AccountingDocument,
  P_PT_TaxReturnBoxItem.FiscalYear AS FiscalYear,
  P_PT_TaxReturnBoxItem.TaxItem AS TaxItem,
  P_PT_TaxReturnBoxItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  P_PT_TaxReturnBoxItem.DebitCreditCode AS DebitCreditCode,
  P_PT_TaxReturnBoxItem.AccountingDocumentType AS AccountingDocumentType,
  P_PT_TaxReturnBoxItem.SupplierAccountGroup AS SupplierAccountGroup,
  P_PT_TaxReturnBoxItem.TaxBox AS TaxBox,
  P_PT_TaxReturnBoxItem.TaxDeclnAmountType AS TaxDeclnAmountType,
  P_PT_TaxReturnBoxItem.ValidityStartDate AS ValidityStartDate,
  P_PT_TaxReturnBoxItem.UnifiedTaxBoxStructureType AS UnifiedTaxBoxStructureType,
  P_PT_TaxReturnBoxItem.TaxGroup AS TaxGroup,
  P_PT_TaxReturnBoxItem.TaxItemGrpgDebitCreditCode AS TaxItemGrpgDebitCreditCode,
  P_PT_TaxReturnBoxItem.TaxItemGrpgAcctgDocumentType AS TaxItemGrpgAcctgDocumentType,
  P_PT_TaxReturnBoxItem.TaxItemGrpgSupplierAcctGroup AS TaxItemGrpgSupplierAcctGroup,
  P_PT_TaxReturnBoxItem.TaxItemGrpgSpecialGLCode AS TaxItemGrpgSpecialGLCode,
  P_PT_TaxReturnBoxItem.StatryRptgEntity AS StatryRptgEntity,
  P_PT_TaxReturnBoxItem.StatryRptCategory AS StatryRptCategory,
  P_PT_TaxReturnBoxItem.StatryRptRunID AS StatryRptRunID,
  P_PT_TaxReturnBoxItem.TaxCalculationProcedure AS TaxCalculationProcedure,
  P_PT_TaxReturnBoxItem.TaxCode AS TaxCode,
  substring(P_PT_TaxReturnBoxItem.DocumentDate, 5, 2) AS PT_AnnexSuplrDocIssueMonth,
  left(P_PT_TaxReturnBoxItem.DocumentDate, 4) AS PT_AnnexSuplrDocIssueYear,
  cast(left(P_PT_TaxReturnBoxItem.ReportingDate, 4) as cds_reporting_year ) AS ReportingYear,
  P_PT_TaxReturnBoxItem.DocumentReferenceID AS DocumentReferenceID,
  P_PT_TaxReturnBoxItem.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  P_PT_TaxReturnBoxItem.Country AS Country,
  P_PT_TaxReturnBoxItem.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  P_PT_TaxReturnBoxItem.TaxBoxStructureType AS TaxBoxStructureType,
  P_PT_TaxReturnBoxItem.ValidityEndDate AS ValidityEndDate,
  P_PT_TaxReturnBoxItem.TaxRate AS TaxRate,
  P_PT_TaxReturnBoxItem.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  P_PT_TaxReturnBoxItem.GLAccount AS GLAccount,
  P_PT_TaxReturnBoxItem.TaxItemGroup AS TaxItemGroup,
  P_PT_TaxReturnBoxItem.ReferenceDocumentType AS ReferenceDocumentType,
  P_PT_TaxReturnBoxItem.PostingDate AS PostingDate,
  P_PT_TaxReturnBoxItem.DocumentDate AS DocumentDate,
  P_PT_TaxReturnBoxItem.TaxReportingDate AS TaxReportingDate,
  P_PT_TaxReturnBoxItem.ReportingDate AS ReportingDate,
  P_PT_TaxReturnBoxItem.FiscalPeriod AS FiscalPeriod,
  P_PT_TaxReturnBoxItem.CompanyCodeCountry AS CompanyCodeCountry,
  P_PT_TaxReturnBoxItem.ReportingCountry AS ReportingCountry,
  P_PT_TaxReturnBoxItem.TaxReturnCountry AS TaxReturnCountry,
  P_PT_TaxReturnBoxItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  P_PT_TaxReturnBoxItem.DocumentCurrency AS DocumentCurrency,
  P_PT_TaxReturnBoxItem.ReportingCurrency AS ReportingCurrency,
  P_PT_TaxReturnBoxItem.AmountInReportingCurrency AS AmountInReportingCurrency,
  P_PT_TaxReturnBoxItem.TaxBaseAmountInRptgCrcy AS TaxBaseAmountInRptgCrcy,
  P_PT_TaxReturnBoxItem.TaxAmountInRptgCrcy AS TaxAmountInRptgCrcy,
  P_PT_TaxReturnBoxItem.NonDeductibleInputTaxAmount AS NonDeductibleInputTaxAmount,
  P_PT_TaxReturnBoxItem.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  P_PT_TaxReturnBoxItem.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  P_PT_TaxReturnBoxItem.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  P_PT_TaxReturnBoxItem.TaxAmount AS TaxAmount,
  P_PT_TaxReturnBoxItem.TargetTaxCode AS TargetTaxCode,
  P_PT_TaxReturnBoxItem.CAReconciliationKey AS CAReconciliationKey,
  P_PT_TaxReturnBoxItem.StatryRptRun AS StatryRptRun,
  P_PT_TaxReturnBoxItem.TaxTypeName AS TaxTypeName,
  P_PT_TaxReturnBoxItem.TaxIsNotDeductible AS TaxIsNotDeductible,
  P_PT_TaxReturnBoxItem.TaxBoxStructure AS TaxBoxStructure,
  P_PT_TaxReturnBoxItem.TaxBoxStructureName AS TaxBoxStructureName,
  P_PT_TaxReturnBoxItem.TaxBoxName AS TaxBoxName,
  P_PT_TaxReturnBoxItem.TaxBoxCondition AS TaxBoxCondition
FROM P_PT_TaxReturnBoxItem
;

Learn More