P_VE_WithholdingTaxItem

DDL: P_VE_WITHHOLDINGTAXITEM SQL: PVEWHLDGITM Type: view COMPOSITE
13 Fields 3 Data Sources

P_VE_WithholdingTaxItem is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_StRpJournalEntryLog, P_Withholdingtxtype, I_Withholdingtaxitem) and exposes 13 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, AccountingDocument.

Data Sources (3)

SourceAliasJoin Type
I_StRpJournalEntryLog ReportedItemLog inner
P_Withholdingtxtype TaxType inner
I_Withholdingtaxitem WhldgTaxItem from

Parameters (3)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PVEWHLDGITM view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.dataClass #MIXED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity I_StRpJournalEntryLog StatryRptgEntity Reporting Entity
KEY StatryRptCategory I_StRpJournalEntryLog StatryRptCategory Report ID
KEY StatryRptRunID I_StRpJournalEntryLog StatryRptRunID Report Run ID
KEY CompanyCode I_Withholdingtaxitem CompanyCode Receiver Company Code
KEY AccountingDocument I_Withholdingtaxitem AccountingDocument Journal Entry
KEY FiscalYear
KEY AccountingDocumentItem I_Withholdingtaxitem AccountingDocumentItem Posting View Item
KEY WithholdingTaxType I_Withholdingtaxitem WithholdingTaxType WTax Type
WithholdingTaxCode I_Withholdingtaxitem WithholdingTaxCode WTax Code
WhldgTaxAmtInCoCodeCrcy I_Withholdingtaxitem WhldgTaxAmtInCoCodeCrcy WTax Amt in LC
OfficialWhldgTaxCode
CompanyCodeCurrency I_Withholdingtaxitem CompanyCodeCurrency Local Currency
WithholdingTaxCertificate I_Withholdingtaxitem WithholdingTaxCertificate WHT Certificate

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_VE_WithholdingTaxItem.
-- 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: PVEWHLDGITM
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id

CREATE VIEW P_VE_WithholdingTaxItem AS
SELECT
  ReportedItemLog.StatryRptgEntity AS StatryRptgEntity,
  ReportedItemLog.StatryRptCategory AS StatryRptCategory,
  ReportedItemLog.StatryRptRunID AS StatryRptRunID,
  WhldgTaxItem.CompanyCode AS CompanyCode,
  WhldgTaxItem.AccountingDocument AS AccountingDocument,
  cast( WhldgTaxItem.FiscalYear as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  WhldgTaxItem.AccountingDocumentItem AS AccountingDocumentItem,
  WhldgTaxItem.WithholdingTaxType AS WithholdingTaxType,
  WhldgTaxItem.WithholdingTaxCode AS WithholdingTaxCode,
  WhldgTaxItem.WhldgTaxAmtInCoCodeCrcy AS WhldgTaxAmtInCoCodeCrcy,
  WhldgTaxItem._WithholdingTaxCode.OfficialWhldgTaxCode AS OfficialWhldgTaxCode,
  WhldgTaxItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  WhldgTaxItem.WithholdingTaxCertificate AS WithholdingTaxCertificate
FROM I_Withholdingtaxitem AS WhldgTaxItem
INNER JOIN I_StRpJournalEntryLog AS ReportedItemLog ON /* join condition not captured in parsed metadata */
INNER JOIN P_Withholdingtxtype AS TaxType ON /* join condition not captured in parsed metadata */
;

Learn More