I_PT_TaxReturnAnnex

DDL: I_PT_TAXRETURNANNEX Type: view_entity COMPOSITE Package: GLO_FIN_IS_VAT_PT
144 Fields 2 Data Sources

FI and FICA tax items for PT Annexes

I_PT_TaxReturnAnnex is a Composite CDS View that provides data about "FI and FICA tax items for PT Annexes" in SAP S/4HANA. It reads from 2 data sources (I_StRpTaxReturnBoxCube, P_PT_CADocumentTaxBoxConfig) and exposes 144 fields with key fields CompanyCode, AccountingDocument, CADocumentNumber, CAGLItemNumber, FiscalYear. Part of development package GLO_FIN_IS_VAT_PT.

Data Sources (2)

SourceAliasJoin Type
I_StRpTaxReturnBoxCube I_StRpTaxReturnBoxCube from
P_PT_CADocumentTaxBoxConfig I_StRpTaxReturnBoxCube union_all

Parameters (4)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id
P_ReportingCountry land1

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
EndUserText.label FI and FICA tax items for PT Annexes view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (144)

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

Learn More