C_PT_TaxReturnBoxAnnex40Cube

DDL: C_PT_TAXRETURNBOXANNEX40CUBE Type: view_entity CONSUMPTION Package: GLO_FIN_IS_VAT_PT
68 Fields 2 Data Sources

Portugal Tax Items for Annex 40 - Cube

C_PT_TaxReturnBoxAnnex40Cube is a Consumption CDS View (Cube) that provides data about "Portugal Tax Items for Annex 40 - Cube" in SAP S/4HANA. It reads from 2 data sources (I_PT_Annex40CodeClassification, I_PT_TaxReturnAnnex) and exposes 68 fields with key fields CompanyCode, AccountingDocument, CADocumentNumber, CAGLItemNumber, FiscalYear. Part of development package GLO_FIN_IS_VAT_PT.

Data Sources (2)

SourceAliasJoin Type
I_PT_Annex40CodeClassification a40class inner
I_PT_TaxReturnAnnex I_PT_TaxReturnAnnex 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 (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
Analytics.internalName #LOCAL view
EndUserText.label Portugal Tax Items for Annex 40 - Cube view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataCategory #CUBE view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (68)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_PT_TaxReturnBoxItem CompanyCode Receiver Company Code
KEY AccountingDocument P_PT_TaxReturnBoxItem AccountingDocument Journal Entry
KEY CADocumentNumber P_PT_TaxReturnBoxItem CADocumentNumber Document Number
KEY CAGLItemNumber P_PT_TaxReturnBoxItem CAGLItemNumber Item
KEY FiscalYear P_PT_TaxReturnBoxItem FiscalYear G/L Fiscal Year
KEY TaxItem P_PT_TaxReturnBoxItem TaxItem Tax Item
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 TransactionTypeDetermination P_PT_TaxReturnBoxItem TransactionTypeDetermination Transaction Key
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 PT_AnnexVATValidityStartDate I_PT_Annex40CodeClassification PT_AnnexVATValidityStartDate Valid From
KEY TaxCode P_PT_TaxReturnBoxItem TaxCode Tax Code
PT_AnnexVATValidityEndDate I_PT_Annex40CodeClassification PT_AnnexVATValidityEndDate Valid To
PT_Annex40Classification I_PT_Annex40CodeClassification PT_Annex40Classification Classification
PT_Annex4041TaxArticle I_PT_Annex40CodeClassification PT_Annex4041TaxArticle Material
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
FinancialAccountType P_PT_TaxReturnBoxItem FinancialAccountType Fin. Account Type
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
TaxType P_PT_TaxReturnBoxItem TaxType Tax Type
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
_TaxTypeText P_PT_TaxReturnBoxItem _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 C_PT_TaxReturnBoxAnnex40Cube.
-- 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 C_PT_TaxReturnBoxAnnex40Cube AS
SELECT
  P_PT_TaxReturnBoxItem.CompanyCode AS CompanyCode,
  P_PT_TaxReturnBoxItem.AccountingDocument AS AccountingDocument,
  P_PT_TaxReturnBoxItem.CADocumentNumber AS CADocumentNumber,
  P_PT_TaxReturnBoxItem.CAGLItemNumber AS CAGLItemNumber,
  P_PT_TaxReturnBoxItem.FiscalYear AS FiscalYear,
  P_PT_TaxReturnBoxItem.TaxItem AS TaxItem,
  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.TransactionTypeDetermination AS TransactionTypeDetermination,
  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,
  a40class.PT_AnnexVATValidityStartDate AS PT_AnnexVATValidityStartDate,
  P_PT_TaxReturnBoxItem.TaxCode AS TaxCode,
  a40class.PT_AnnexVATValidityEndDate AS PT_AnnexVATValidityEndDate,
  a40class.PT_Annex40Classification AS PT_Annex40Classification,
  a40class.PT_Annex4041TaxArticle AS PT_Annex4041TaxArticle,
  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.FinancialAccountType AS FinancialAccountType,
  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.TaxType AS TaxType,
  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,
  P_PT_TaxReturnBoxItem._TaxTypeText AS _TaxTypeText
FROM I_PT_TaxReturnAnnex
INNER JOIN I_PT_Annex40CodeClassification AS a40class ON /* join condition not captured in parsed metadata */
;

Learn More