P_ES_TaxReturnBoxCheckCorr

DDL: P_ES_TAXRETURNBOXCHECKCORR SQL: PESBOXCHKCORR Type: view COMPOSITE
31 Fields 4 Data Sources

P_ES_TaxReturnBoxCheckCorr is a Composite CDS View in SAP S/4HANA. It reads from 4 data sources (I_AdvancedTaxReportingCountry, P_ES_StrpTxItemGrpCheckCorr, P_ES_TaxReturnBoxATRCheckCorr, P_TimeDepdntVersAssgmtNext) and exposes 31 fields with key fields Country, TaxCode, TransactionTypeDetermination, DebitCreditCode, TaxDeclnAmountType.

Data Sources (4)

SourceAliasJoin Type
I_AdvancedTaxReportingCountry I_AdvancedTaxReportingCountry from
P_ES_StrpTxItemGrpCheckCorr P_ES_StrpTxItemGrpCheckCorr union_all
P_ES_TaxReturnBoxATRCheckCorr P_ES_TaxReturnBoxATRCheckCorr inner
P_TimeDepdntVersAssgmtNext P_TimeDepdntVersAssgmtNext inner

Parameters (1)

NameTypeDefault
P_ReportingCountry land1

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PESBOXCHKCORR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #CUSTOMIZING view
AbapCatalog.preserveKey true view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY Country P_ES_TaxReturnBoxATRCheckCorr Country Venue: Ctry/Reg
KEY TaxCode P_ES_TaxReturnBoxATRCheckCorr TaxCode Tax Code
KEY TransactionTypeDetermination P_ES_TaxReturnBoxATRCheckCorr TransactionTypeDetermination Transaction Key
KEY DebitCreditCode P_ES_TaxReturnBoxATRCheckCorr DebitCreditCode Single-Character Flag
KEY TaxDeclnAmountType P_ES_TaxReturnBoxATRCheckCorr TaxDeclnAmountType
KEY TaxBoxStrucValidityStartDate P_ES_TaxReturnBoxATRCheckCorr TaxBoxStrucValidityStartDate From Date
KEY UnifiedTaxBoxStructureType P_ES_TaxReturnBoxATRCheckCorr UnifiedTaxBoxStructureType
KEY AccountingDocumentType P_ES_TaxReturnBoxATRCheckCorr AccountingDocumentType Journal Entry Type
KEY SupplierAccountGroup P_ES_TaxReturnBoxATRCheckCorr SupplierAccountGroup Account group
KEY TaxRateValidityStartDate P_ES_TaxReturnBoxATRCheckCorr TaxRateValidityStartDate Tax Rate Validity Start Date
KEY SpecialGLCode P_ES_TaxReturnBoxATRCheckCorr SpecialGLCode Special G/L Ind
KEY TaxCountry P_ES_TaxReturnBoxATRCheckCorr TaxCountry Tax Ctry/Reg.
KEY TaxCalculationProcedure Tax Procedure
TaxBoxStrucValidityEndDate P_ES_TaxReturnBoxATRCheckCorr TaxBoxStrucValidityEndDate
TaxRateValidityEndDate P_ES_TaxReturnBoxATRCheckCorr TaxRateValidityEndDate
Country Venue: Ctry/Reg
KEY TaxCode P_ES_StrpTxItemGrpCheckCorr TaxCode Tax Code
KEY TransactionTypeDetermination P_ES_StrpTxItemGrpCheckCorr TransactionTypeDetermination Transaction Key
KEY DebitCreditCode P_ES_StrpTxItemGrpCheckCorr DebitCreditCode Single-Character Flag
KEY TaxDeclnAmountType P_ES_StrpTxItemGrpCheckCorr TaxDeclnAmountType
KEY TaxBoxStrucValidityStartDate P_TimeDepdntVersAssgmtNext fdatu From Date
KEY UnifiedTaxBoxStructureType
KEY AccountingDocumentType P_ES_StrpTxItemGrpCheckCorr AccountingDocumentType Journal Entry Type
KEY SupplierAccountGroup P_ES_StrpTxItemGrpCheckCorr SupplierAccountGroup Account group
KEY TaxRateValidityStartDate Tax Rate Validity Start Date
KEY SpecialGLCode Special G/L Ind
KEY TaxCountry Tax Ctry/Reg.
KEY TaxCalculationProcedure P_ES_StrpTxItemGrpCheckCorr TaxCalculationProcedure Tax Procedure
TaxBoxStrucValidityEndDate P_TimeDepdntVersAssgmtNext fdatu_to
TaxRateValidityEndDate
InCorrectionBox P_ES_StrpTxItemGrpCheckCorr InCorrectionBox

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_ES_TaxReturnBoxCheckCorr.
-- 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.
-- SQL view name: PESBOXCHKCORR
-- Parameters: P_ReportingCountry : land1

CREATE VIEW P_ES_TaxReturnBoxCheckCorr AS
SELECT
  P_ES_TaxReturnBoxATRCheckCorr.Country AS Country,
  P_ES_TaxReturnBoxATRCheckCorr.TaxCode AS TaxCode,
  P_ES_TaxReturnBoxATRCheckCorr.TransactionTypeDetermination AS TransactionTypeDetermination,
  P_ES_TaxReturnBoxATRCheckCorr.DebitCreditCode AS DebitCreditCode,
  P_ES_TaxReturnBoxATRCheckCorr.TaxDeclnAmountType AS TaxDeclnAmountType,
  P_ES_TaxReturnBoxATRCheckCorr.TaxBoxStrucValidityStartDate AS TaxBoxStrucValidityStartDate,
  P_ES_TaxReturnBoxATRCheckCorr.UnifiedTaxBoxStructureType AS UnifiedTaxBoxStructureType,
  P_ES_TaxReturnBoxATRCheckCorr.AccountingDocumentType AS AccountingDocumentType,
  P_ES_TaxReturnBoxATRCheckCorr.SupplierAccountGroup AS SupplierAccountGroup,
  P_ES_TaxReturnBoxATRCheckCorr.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  P_ES_TaxReturnBoxATRCheckCorr.SpecialGLCode AS SpecialGLCode,
  P_ES_TaxReturnBoxATRCheckCorr.TaxCountry AS TaxCountry,
  cast( '' as kalsm_d ) AS TaxCalculationProcedure,
  P_ES_TaxReturnBoxATRCheckCorr.TaxBoxStrucValidityEndDate AS TaxBoxStrucValidityEndDate,
  P_ES_TaxReturnBoxATRCheckCorr.TaxRateValidityEndDate AS TaxRateValidityEndDate,
  P_ES_StrpTxItemGrpCheckCorr.InCorrectionBox AS InCorrectionBox
FROM I_AdvancedTaxReportingCountry
INNER JOIN P_ES_TaxReturnBoxATRCheckCorr ON /* join condition not captured in parsed metadata */
INNER JOIN P_TimeDepdntVersAssgmtNext ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_ES_StrpTxItemGrpCheckCorr
;

Learn More