P_DueTaxItemCountAndWhdgTaxItm

DDL: P_DUETAXITEMCOUNTANDWHDGTAXITM SQL: PDUETITMCTWHTITM Type: view CONSUMPTION
12 Fields 2 Data Sources

P_DueTaxItemCountAndWhdgTaxItm is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (P_CountOfSameTaxInvDoc, I_Withholdingtaxitem) and exposes 12 fields with key fields CompanyCode, AccountingDocument, FiscalYear, WithholdingTaxType.

Data Sources (2)

SourceAliasJoin Type
P_CountOfSameTaxInvDoc CountTaxTransfer left_outer
I_Withholdingtaxitem WithholdingTaxItem from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PDUETITMCTWHTITM view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_Withholdingtaxitem CompanyCode Receiver Company Code
KEY AccountingDocument I_Withholdingtaxitem AccountingDocument Journal Entry
KEY FiscalYear
KEY WithholdingTaxType I_Withholdingtaxitem WithholdingTaxType WTax Type
WhldgTaxBaseAmtInCoCodeCrcy I_Withholdingtaxitem WhldgTaxBaseAmtInCoCodeCrcy W/Tax Base LC
WhldgTaxBaseAmtInTransacCrcy I_Withholdingtaxitem WhldgTaxBaseAmtInTransacCrcy W/Tax Base FC
WhldgTaxAmtInCoCodeCrcy I_Withholdingtaxitem WhldgTaxAmtInCoCodeCrcy WTax Amt in LC
WhldgTaxAmtInTransacCrcy I_Withholdingtaxitem WhldgTaxAmtInTransacCrcy WTax Amt in FC
DocumentCurrency I_Withholdingtaxitem DocumentCurrency Document Currency
CompanyCodeCurrency I_Withholdingtaxitem CompanyCodeCurrency Local Currency
OfficialWhldgTaxCode
NumberOfDocuments

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_DueTaxItemCountAndWhdgTaxItm.
-- 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: PDUETITMCTWHTITM

CREATE VIEW P_DueTaxItemCountAndWhdgTaxItm AS
SELECT
  WithholdingTaxItem.CompanyCode AS CompanyCode,
  WithholdingTaxItem.AccountingDocument AS AccountingDocument,
  cast( WithholdingTaxItem.FiscalYear as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  WithholdingTaxItem.WithholdingTaxType AS WithholdingTaxType,
  WithholdingTaxItem.WhldgTaxBaseAmtInCoCodeCrcy AS WhldgTaxBaseAmtInCoCodeCrcy,
  WithholdingTaxItem.WhldgTaxBaseAmtInTransacCrcy AS WhldgTaxBaseAmtInTransacCrcy,
  WithholdingTaxItem.WhldgTaxAmtInCoCodeCrcy AS WhldgTaxAmtInCoCodeCrcy,
  WithholdingTaxItem.WhldgTaxAmtInTransacCrcy AS WhldgTaxAmtInTransacCrcy,
  WithholdingTaxItem.DocumentCurrency AS DocumentCurrency,
  WithholdingTaxItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  WithholdingTaxItem._WithholdingTaxCode.OfficialWhldgTaxCode AS OfficialWhldgTaxCode,
  count( * ) AS NumberOfDocuments
FROM I_Withholdingtaxitem AS WithholdingTaxItem
LEFT OUTER JOIN P_CountOfSameTaxInvDoc AS CountTaxTransfer ON /* join condition not captured in parsed metadata */
;

Learn More