P_KR_StRpGenTaxPyrVATItem00

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_KR_StRpGenTaxPyrVATItem00.
-- 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: PKRGTPVATITM00
-- Parameters: P_TaxIsDeferredRelevant : figen_deferred_check, P_TaxIsMossRelevant : figen_moss_check, P_ReportingCountry : land1, P_TaxBoxConfiguration : figen_tdt_taxbox_config, P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_TaxReportingToDate : idkr_non_rep_key_date

CREATE VIEW P_KR_StRpGenTaxPyrVATItem00 AS
SELECT
  taxbox_item.Statryrptrunid AS Statryrptrunid,
  taxbox_item.Statryrptgentity AS Statryrptgentity,
  taxbox_item.Statryrptcategory AS Statryrptcategory,
  taxbox_item.Companycode AS Companycode,
  taxbox_item.Accountingdocument AS Accountingdocument,
  taxbox_item.Fiscalyear AS Fiscalyear,
  ' ' AS Documentitem,
  ' ' AS Reporteddate,
  ' ' AS Declarationperiodno,
  ' ' AS Sequenceid,
  taxbox_item.TaxCode AS TaxCode,
  taxbox_item.TaxBox AS TaxBox,
  taxbox_item.TaxBoxStructureType AS TaxBoxStructureType,
  cast( 0 as idkr_exemptrevenue) AS Taxexemptrevenue,
  cast( 0 as idkr_totrevenue ) AS Totalrevenue,
  ' ' AS Currency,
  ' ' AS Nondeductiblecat,
  ' ' AS Nondeductiblestatus,
  taxbox_item.Financialaccounttype AS Financialaccounttype,
  ' ' AS Isfinished,
  taxbox_item.TaxBoxStructure AS TaxBoxStructure,
  taxbox_item.TaxBoxStructureName AS TaxBoxStructureName,
  taxbox_item.TaxBoxName AS TaxBoxName,
  taxbox_item.TaxBoxCondition AS TaxBoxCondition,
  taxbox_item.TaxGroup AS TaxGroup,
  taxbox_item.AccountingDocumentType AS AccountingDocumentType,
  taxbox_item.TaxGroupFreeClassification AS TaxGroupFreeClassification,
  taxbox_item.Ledger AS Ledger,
  taxbox_item.GLAccount AS GLAccount,
  taxbox_item.PostingDate AS PostingDate,
  taxbox_item.DocumentDate AS DocumentDate,
  ' ' AS AccountingDocumentItem,
  taxbox_item.Country AS Country,
  taxbox_item.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  taxbox_item.TransactionTypeDetermination AS TransactionTypeDetermination,
  taxbox_item.DebitCreditCode AS DebitCreditCode,
  taxbox_item.TaxDeclnAmountType AS TaxDeclnAmountType,
  taxbox_item.TaxBoxStrucValidityStartDate AS TaxBoxStrucValidityStartDate,
  taxbox_item.UnifiedTaxBoxStructureType AS UnifiedTaxBoxStructureType,
  taxbox_item.ValidFrom AS ValidFrom,
  taxbox_item.ValidTo AS ValidTo,
  taxbox_item.TaxBoxStrucValidityEndDate AS TaxBoxStrucValidityEndDate,
  taxbox_item.TaxRate AS TaxRate,
  taxbox_item.TaxGroupOperation AS TaxGroupOperation,
  taxbox_item.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  taxbox_item.SpecialGLCode AS SpecialGLCode,
  taxbox_item.TaxCountry AS TaxCountry,
  taxbox_item.TaxItemGroupingAccountNumber AS TaxItemGroupingAccountNumber,
  taxbox_item.CompanyCodeCurrency AS CompanyCodeCurrency,
  taxbox_item.TaxType AS TaxType,
  taxbox_item.TaxItem AS TaxItem,
  taxbox_item.TaxItemGroup AS TaxItemGroup,
  taxbox_item.BusinessPlace AS BusinessPlace,
  taxbox_item.TaxReportingDate AS TaxReportingDate,
  taxbox_item.ReportingDate AS ReportingDate,
  taxbox_item.TaxReportingDocumentDate AS TaxReportingDocumentDate,
  taxbox_item.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  taxbox_item.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  taxbox_item.Customer AS Customer,
  taxbox_item.Supplier AS Supplier,
  taxbox_item.CAReconciliationKey AS CAReconciliationKey,
  taxbox_item.ReferenceDocumentType AS ReferenceDocumentType,
  cast(concat_with_space( concat_with_space( taxbox_item.Statryrptgentity,taxbox_item.Statryrptcategory,1),taxbox_item.Statryrptrunid,1 ) as srf_reportrun) as StatryRptRun AS StatryrptrunidasStatryrptrunid,
  cast(concat_with_space( concat_with_space( nonded_item.Statryrptgentity,nonded_item.Statryrptcategory,1),nonded_item.Statryrptrunid,1 ) as srf_reportrun) as StatryRptRun AS P_TaxBoxConfiguration,
  P_StatryRptgEntity :$parameters.P_StatryRptgEntity AS P_StatryRptgEntity,
  P_StatryRptCategory:$parameters.P_StatryRptCategory AS P_StatryRptCategory,
  cast(concat_with_space( concat_with_space( glitem.Statryrptgentity,glitem.Statryrptcategory,1),glitem.Statryrptrunid,1 ) as srf_reportrun) AS StatryRptRun
FROM P_KR_StRpGenTaxPyrVATTaxBoxItm
-- UNION with additional select branch(es): P_KR_StRpGenTaxPyrVATNonDedItm, P_KR_StRpGenTaxPyrVATGLItem
;