C_PT_TaxRetBoxAnnexCustCube

DDL: C_PT_TAXRETBOXANNEXCUSTCUBE Type: view_entity CONSUMPTION Package: GLO_FIN_IS_VAT_PT
67 Fields 2 Data Sources

PT Tax Items for Annex Cust - Cube

C_PT_TaxRetBoxAnnexCustCube is a Consumption CDS View (Cube) that provides data about "PT Tax Items for Annex Cust - Cube" in SAP S/4HANA. It reads from 2 data sources (I_PT_AnnexCustCodeClassfctn, I_PT_TaxReturnAnnex) and exposes 67 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_AnnexCustCodeClassfctn I_PT_AnnexCustCodeClassfctn inner
I_PT_TaxReturnAnnex I_PT_TaxReturnAnnex from

Parameters (6)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id
P_ReportingCountry land1
P_PT_ExportField fipt_vat_export_field
P_PT_RefundPeriodQuarter fipt_vat_refund_quarterly

Annotations (11)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label PT Tax Items for Annex Cust - Cube view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
Analytics.internalName #LOCAL 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 (67)

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 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
KEY PT_AnnexVATValidityStartDate I_PT_AnnexCustCodeClassfctn PT_AnnexVATValidityStartDate Valid From
PT_AnnexVATValidityEndDate I_PT_AnnexCustCodeClassfctn PT_AnnexVATValidityEndDate Valid To
PT_AnnexCustClassification I_PT_AnnexCustCodeClassfctn PT_AnnexCustClassification Classification
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 C_PT_TaxRetBoxAnnexCustCube.
-- 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, P_PT_ExportField : fipt_vat_export_field, P_PT_RefundPeriodQuarter : fipt_vat_refund_quarterly

CREATE VIEW C_PT_TaxRetBoxAnnexCustCube 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.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,
  I_PT_AnnexCustCodeClassfctn.PT_AnnexVATValidityStartDate AS PT_AnnexVATValidityStartDate,
  I_PT_AnnexCustCodeClassfctn.PT_AnnexVATValidityEndDate AS PT_AnnexVATValidityEndDate,
  I_PT_AnnexCustCodeClassfctn.PT_AnnexCustClassification AS PT_AnnexCustClassification,
  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 I_PT_TaxReturnAnnex
INNER JOIN I_PT_AnnexCustCodeClassfctn ON /* join condition not captured in parsed metadata */
;

Learn More