P_PT_TaxReturnBoxItem

DDL: P_PT_TAXRETURNBOXITEM Type: view_entity COMPOSITE Package: GLO_FIN_IS_VAT_PT
69 Fields 1 Data Sources

Portugal Tax Items

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

Data Sources (1)

SourceAliasJoin Type
I_StRpTaxReturnBoxCube I_StRpTaxReturnBoxCube 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 (6)

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

Fields (69)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_StRpTaxReturnBoxCube CompanyCode Receiver Company Code
KEY AccountingDocument I_StRpTaxReturnBoxCube AccountingDocument Journal Entry
KEY FiscalYear I_StRpTaxReturnBoxCube FiscalYear G/L Fiscal Year
KEY TaxItem I_StRpTaxReturnBoxCube TaxItem Tax Item
KEY TransactionTypeDetermination I_StRpTaxReturnBoxCube TransactionTypeDetermination Transaction Key
KEY DebitCreditCode I_StRpTaxReturnBoxCube DebitCreditCode Single-Character Flag
KEY AccountingDocumentType I_StRpTaxReturnBoxCube AccountingDocumentType Journal Entry Type
KEY SupplierAccountGroup I_StRpTaxReturnBoxCube SupplierAccountGroup Account group
KEY TaxBox I_StRpTaxReturnBoxCube TaxBox Tax.Bs.Gp.No.
KEY TaxDeclnAmountType I_StRpTaxReturnBoxCube TaxDeclnAmountType
KEY ValidityStartDate I_StRpTaxReturnBoxCube TaxBoxStrucValidityStartDate
KEY UnifiedTaxBoxStructureType I_StRpTaxReturnBoxCube UnifiedTaxBoxStructureType
KEY TaxGroup I_StRpTaxReturnBoxCube TaxGroup Tax Group
KEY TaxItemGrpgDebitCreditCode I_StRpTaxReturnBoxCube TaxItemGrpgDebitCreditCode
KEY TaxItemGrpgAcctgDocumentType I_StRpTaxReturnBoxCube TaxItemGrpgAcctgDocumentType
KEY TaxItemGrpgSupplierAcctGroup I_StRpTaxReturnBoxCube TaxItemGrpgSupplierAcctGroup
KEY TaxItemGrpgSpecialGLCode I_StRpTaxReturnBoxCube TaxItemGrpgSpecialGLCode
KEY StatryRptgEntity I_StRpTaxReturnBoxCube StatryRptgEntity Reporting Entity
KEY StatryRptCategory I_StRpTaxReturnBoxCube StatryRptCategory Report ID
KEY StatryRptRunID I_StRpTaxReturnBoxCube StatryRptRunID Report Run ID
Country I_StRpTaxReturnBoxCube Country Venue: Ctry/Reg
TaxCode I_StRpTaxReturnBoxCube TaxCode Tax Code
TaxItemGroupingVersion I_StRpTaxReturnBoxCube TaxItemGroupingVersion Tax Grping Ver.
TaxBoxStructureType I_StRpTaxReturnBoxCube TaxBoxStructureType
ValidityEndDate I_StRpTaxReturnBoxCube TaxBoxStrucValidityEndDate
TaxCalculationProcedure I_StRpTaxReturnBoxCube TaxCalculationProcedure Tax Procedure
TaxRate I_StRpTaxReturnBoxCube TaxRate Tax Rate
TaxRateValidityStartDate I_StRpTaxReturnBoxCube TaxRateValidityStartDate Tax Rate Validity Start Date
GLAccount I_StRpTaxReturnBoxCube GLAccount General Ledger
TaxItemGroup I_StRpTaxReturnBoxCube TaxItemGroup Tax doc. item number
ReferenceDocumentType I_StRpTaxReturnBoxCube ReferenceDocumentType Reference Document Type
DocumentReferenceID I_StRpTaxReturnBoxCube DocumentReferenceID Reference
PostingDate I_StRpTaxReturnBoxCube PostingDate Posting Date for GR
DocumentDate I_StRpTaxReturnBoxCube DocumentDate Journal Entry Date
TaxReportingDate I_StRpTaxReturnBoxCube TaxReportingDate Tax Reporting Date
ReportingDate I_StRpTaxReturnBoxCube ReportingDate
FiscalPeriod I_StRpTaxReturnBoxCube FiscalPeriod Tax period
AccountingDocumentHeaderText I_StRpTaxReturnBoxCube AccountingDocumentHeaderText Doc.Header Text
CompanyCodeCountry I_StRpTaxReturnBoxCube CompanyCodeCountry Reporting Ctry/Reg.
ReportingCountry I_StRpTaxReturnBoxCube ReportingCountry
TaxReturnCountry I_StRpTaxReturnBoxCube TaxReturnCountry Reporting C/R
CompanyCodeCurrency I_StRpTaxReturnBoxCube CompanyCodeCurrency Local Currency
DocumentCurrency I_StRpTaxReturnBoxCube DocumentCurrency Document Currency
ReportingCurrency I_StRpTaxReturnBoxCube ReportingCurrency Currency
AmountInReportingCurrency I_StRpTaxReturnBoxCube AmountInReportingCurrency
TaxBaseAmountInRptgCrcy I_StRpTaxReturnBoxCube TaxBaseAmountInRptgCrcy Base Amount
TaxAmountInRptgCrcy I_StRpTaxReturnBoxCube TaxAmountInRptgCrcy Tax Rept. Crcy
NonDeductibleInputTaxAmount I_StRpTaxReturnBoxCube NonDeductibleInputTaxAmount Non-deductible
TaxBaseAmountInCoCodeCrcy I_StRpTaxReturnBoxCube TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxAmountInCoCodeCrcy I_StRpTaxReturnBoxCube TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxBaseAmountInTransCrcy I_StRpTaxReturnBoxCube TaxBaseAmountInTransCrcy Value-Added Tax
TaxAmount I_StRpTaxReturnBoxCube TaxAmount Tax Amt in Rptg Crcy
TaxType I_StRpTaxReturnBoxCube TaxType Tax Type
InvoiceReference BP InvoiceReference Invoice Reference
InvoiceReferenceFiscalYear BP InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
Customer BP Customer Sold-to Party
Supplier BP Supplier Supplier
VATRegistration BP VATRegistration VAT Registration No.
FinancialAccountType BP FinancialAccountType Fin. Account Type
TargetTaxCode I_StRpTaxReturnBoxCube TargetTaxCode
CAReconciliationKey I_StRpTaxReturnBoxCube CAReconciliationKey Reconcil. Key
StatryRptRun I_StRpTaxReturnBoxCube StatryRptRun
TaxTypeName I_StRpTaxReturnBoxCube TaxTypeName
TaxIsNotDeductible I_StRpTaxReturnBoxCube TaxIsNotDeductible Non-Deductible
TaxBoxStructure I_StRpTaxReturnBoxCube TaxBoxStructure
TaxBoxStructureName I_StRpTaxReturnBoxCube TaxBoxStructureName
TaxBoxName I_StRpTaxReturnBoxCube TaxBoxName
TaxBoxCondition I_StRpTaxReturnBoxCube TaxBoxCondition
_TaxTypeText I_StRpTaxReturnBoxCube _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_PT_TaxReturnBoxItem.
-- 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_TaxReturnBoxItem AS
SELECT
  I_StRpTaxReturnBoxCube.CompanyCode AS CompanyCode,
  I_StRpTaxReturnBoxCube.AccountingDocument AS AccountingDocument,
  I_StRpTaxReturnBoxCube.FiscalYear AS FiscalYear,
  I_StRpTaxReturnBoxCube.TaxItem AS TaxItem,
  I_StRpTaxReturnBoxCube.TransactionTypeDetermination AS TransactionTypeDetermination,
  I_StRpTaxReturnBoxCube.DebitCreditCode AS DebitCreditCode,
  I_StRpTaxReturnBoxCube.AccountingDocumentType AS AccountingDocumentType,
  I_StRpTaxReturnBoxCube.SupplierAccountGroup AS SupplierAccountGroup,
  I_StRpTaxReturnBoxCube.TaxBox AS TaxBox,
  I_StRpTaxReturnBoxCube.TaxDeclnAmountType AS TaxDeclnAmountType,
  I_StRpTaxReturnBoxCube.TaxBoxStrucValidityStartDate AS ValidityStartDate,
  I_StRpTaxReturnBoxCube.UnifiedTaxBoxStructureType AS UnifiedTaxBoxStructureType,
  I_StRpTaxReturnBoxCube.TaxGroup AS TaxGroup,
  I_StRpTaxReturnBoxCube.TaxItemGrpgDebitCreditCode AS TaxItemGrpgDebitCreditCode,
  I_StRpTaxReturnBoxCube.TaxItemGrpgAcctgDocumentType AS TaxItemGrpgAcctgDocumentType,
  I_StRpTaxReturnBoxCube.TaxItemGrpgSupplierAcctGroup AS TaxItemGrpgSupplierAcctGroup,
  I_StRpTaxReturnBoxCube.TaxItemGrpgSpecialGLCode AS TaxItemGrpgSpecialGLCode,
  I_StRpTaxReturnBoxCube.StatryRptgEntity AS StatryRptgEntity,
  I_StRpTaxReturnBoxCube.StatryRptCategory AS StatryRptCategory,
  I_StRpTaxReturnBoxCube.StatryRptRunID AS StatryRptRunID,
  I_StRpTaxReturnBoxCube.Country AS Country,
  I_StRpTaxReturnBoxCube.TaxCode AS TaxCode,
  I_StRpTaxReturnBoxCube.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  I_StRpTaxReturnBoxCube.TaxBoxStructureType AS TaxBoxStructureType,
  I_StRpTaxReturnBoxCube.TaxBoxStrucValidityEndDate AS ValidityEndDate,
  I_StRpTaxReturnBoxCube.TaxCalculationProcedure AS TaxCalculationProcedure,
  I_StRpTaxReturnBoxCube.TaxRate AS TaxRate,
  I_StRpTaxReturnBoxCube.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  I_StRpTaxReturnBoxCube.GLAccount AS GLAccount,
  I_StRpTaxReturnBoxCube.TaxItemGroup AS TaxItemGroup,
  I_StRpTaxReturnBoxCube.ReferenceDocumentType AS ReferenceDocumentType,
  I_StRpTaxReturnBoxCube.DocumentReferenceID AS DocumentReferenceID,
  I_StRpTaxReturnBoxCube.PostingDate AS PostingDate,
  I_StRpTaxReturnBoxCube.DocumentDate AS DocumentDate,
  I_StRpTaxReturnBoxCube.TaxReportingDate AS TaxReportingDate,
  I_StRpTaxReturnBoxCube.ReportingDate AS ReportingDate,
  I_StRpTaxReturnBoxCube.FiscalPeriod AS FiscalPeriod,
  I_StRpTaxReturnBoxCube.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  I_StRpTaxReturnBoxCube.CompanyCodeCountry AS CompanyCodeCountry,
  I_StRpTaxReturnBoxCube.ReportingCountry AS ReportingCountry,
  I_StRpTaxReturnBoxCube.TaxReturnCountry AS TaxReturnCountry,
  I_StRpTaxReturnBoxCube.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_StRpTaxReturnBoxCube.DocumentCurrency AS DocumentCurrency,
  I_StRpTaxReturnBoxCube.ReportingCurrency AS ReportingCurrency,
  I_StRpTaxReturnBoxCube.AmountInReportingCurrency AS AmountInReportingCurrency,
  I_StRpTaxReturnBoxCube.TaxBaseAmountInRptgCrcy AS TaxBaseAmountInRptgCrcy,
  I_StRpTaxReturnBoxCube.TaxAmountInRptgCrcy AS TaxAmountInRptgCrcy,
  I_StRpTaxReturnBoxCube.NonDeductibleInputTaxAmount AS NonDeductibleInputTaxAmount,
  I_StRpTaxReturnBoxCube.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  I_StRpTaxReturnBoxCube.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  I_StRpTaxReturnBoxCube.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  I_StRpTaxReturnBoxCube.TaxAmount AS TaxAmount,
  I_StRpTaxReturnBoxCube.TaxType AS TaxType,
  BP.InvoiceReference AS InvoiceReference,
  BP.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  BP.Customer AS Customer,
  BP.Supplier AS Supplier,
  BP.VATRegistration AS VATRegistration,
  BP.FinancialAccountType AS FinancialAccountType,
  I_StRpTaxReturnBoxCube.TargetTaxCode AS TargetTaxCode,
  I_StRpTaxReturnBoxCube.CAReconciliationKey AS CAReconciliationKey,
  I_StRpTaxReturnBoxCube.StatryRptRun AS StatryRptRun,
  I_StRpTaxReturnBoxCube.TaxTypeName AS TaxTypeName,
  I_StRpTaxReturnBoxCube.TaxIsNotDeductible AS TaxIsNotDeductible,
  I_StRpTaxReturnBoxCube.TaxBoxStructure AS TaxBoxStructure,
  I_StRpTaxReturnBoxCube.TaxBoxStructureName AS TaxBoxStructureName,
  I_StRpTaxReturnBoxCube.TaxBoxName AS TaxBoxName,
  I_StRpTaxReturnBoxCube.TaxBoxCondition AS TaxBoxCondition,
  I_StRpTaxReturnBoxCube._TaxTypeText AS _TaxTypeText
FROM I_StRpTaxReturnBoxCube
;

Learn More