P_KR_StRpGenTaxPyrVATNonDedItm

DDL: P_KR_STRPGENTAXPYRVATNONDEDITM SQL: PKRGTPVATNONDITM Type: view COMPOSITE
18 Fields 2 Data Sources

Non-deductible item for General Taxpayer VAT

P_KR_StRpGenTaxPyrVATNonDedItm is a Composite CDS View that provides data about "Non-deductible item for General Taxpayer VAT" in SAP S/4HANA. It reads from 2 data sources (I_KR_RptdNoneDcblVATItmDetail, srf_rep_run) and exposes 18 fields.

Data Sources (2)

SourceAliasJoin Type
I_KR_RptdNoneDcblVATItmDetail nonded from
srf_rep_run srf_rep_run inner

Parameters (1)

NameTypeDefault
P_TaxReportingToDate vatdate

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PKRGTPVATNONDITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Non-deductible item for General Taxpayer VAT view

Fields (18)

KeyFieldSource TableSource FieldDescription
Statryrptrunid I_KR_RptdNoneDcblVATItmDetail StatryRptRunID Report Run ID
Statryrptgentity I_KR_RptdNoneDcblVATItmDetail StatryRptgEntity Reporting Entity
Statryrptcategory I_KR_RptdNoneDcblVATItmDetail StatryRptCategory Report ID
Companycode I_KR_RptdNoneDcblVATItmDetail CompanyCode Receiver Company Code
Accountingdocument I_KR_RptdNoneDcblVATItmDetail AccountingDocument Journal Entry
Fiscalyear I_KR_RptdNoneDcblVATItmDetail FiscalYear G/L Fiscal Year
TaxItem I_KR_RptdNoneDcblVATItmDetail TaxItem Tax Item
ReportingDate I_KR_RptdNoneDcblVATItmDetail ReportingDate Date
DeclarationPeriodNumber I_KR_RptdNoneDcblVATItmDetail DeclarationPeriodNumber Reporting Times
KR_TaxExemptRevenueInCCCrcy I_KR_RptdNoneDcblVATItmDetail KR_TaxExemptRevenueInCCCrcy Tax Exempt Revenue
TotalRevenueInCoCodeCrcy I_KR_RptdNoneDcblVATItmDetail TotalRevenueInCoCodeCrcy Total Revenue
Currency I_KR_RptdNoneDcblVATItmDetail Currency Valuation Crcy
KR_NoneDeductibleInputVATCat I_KR_RptdNoneDcblVATItmDetail KR_NoneDeductibleInputVATCat Non-Deductible Cat.
KR_NoneDeductibleInputVATSts I_KR_RptdNoneDcblVATItmDetail KR_NoneDeductibleInputVATSts Non-Deductible Sts
Financialaccounttype I_KR_RptdNoneDcblVATItmDetail FinancialAccountType Fin. Account Type
IsCompleted I_KR_RptdNoneDcblVATItmDetail IsCompleted
CAReconciliationKey TaxItem CAReconciliationKey Reconcil. Key
ReferenceDocumentType TaxItem ReferenceDocumentType Reference Document Type

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_StRpGenTaxPyrVATNonDedItm.
-- 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: PKRGTPVATNONDITM
-- Parameters: P_TaxReportingToDate : vatdate

CREATE VIEW P_KR_StRpGenTaxPyrVATNonDedItm AS
SELECT
  nonded.StatryRptRunID AS Statryrptrunid,
  nonded.StatryRptgEntity AS Statryrptgentity,
  nonded.StatryRptCategory AS Statryrptcategory,
  nonded.CompanyCode AS Companycode,
  nonded.AccountingDocument AS Accountingdocument,
  nonded.FiscalYear AS Fiscalyear,
  nonded.TaxItem AS TaxItem,
  nonded.ReportingDate AS ReportingDate,
  nonded.DeclarationPeriodNumber AS DeclarationPeriodNumber,
  nonded.KR_TaxExemptRevenueInCCCrcy AS KR_TaxExemptRevenueInCCCrcy,
  nonded.TotalRevenueInCoCodeCrcy AS TotalRevenueInCoCodeCrcy,
  nonded.Currency AS Currency,
  nonded.KR_NoneDeductibleInputVATCat AS KR_NoneDeductibleInputVATCat,
  nonded.KR_NoneDeductibleInputVATSts AS KR_NoneDeductibleInputVATSts,
  nonded.FinancialAccountType AS Financialaccounttype,
  nonded.IsCompleted AS IsCompleted,
  TaxItem.CAReconciliationKey AS CAReconciliationKey,
  TaxItem.ReferenceDocumentType AS ReferenceDocumentType
FROM I_KR_RptdNoneDcblVATItmDetail AS nonded
INNER JOIN srf_rep_run ON /* join condition not captured in parsed metadata */
;

Learn More