P_ID_STRPWHLDGTAXFRGNITEMQ

DDL: P_ID_STRPWHLDGTAXFRGNITEMQ Type: view_entity COMPOSITE Package: GLO_FIN_IS_WHT_ID
37 Fields 1 Data Sources

Whldg Tax Item Query for ID BPNR report

P_ID_STRPWHLDGTAXFRGNITEMQ is a Composite CDS View that provides data about "Whldg Tax Item Query for ID BPNR report" in SAP S/4HANA. It reads from 1 data source (P_ID_StRpWhldgTaxFrgnItem) and exposes 37 fields with key fields CompanyCode, AccountingDocument, FiscalYear, WithholdingTaxType, StatryRptgEntity. Part of development package GLO_FIN_IS_WHT_ID.

Data Sources (1)

SourceAliasJoin Type
P_ID_StRpWhldgTaxFrgnItem doc from

Annotations (8)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.private true view
Analytics.technicalName PSRIDTAXITEMBPNRQ view
AccessControl.authorizationCheck #NOT_ALLOWED view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_ID_StRpWhldgTaxFrgnItem CompanyCode Receiver Company Code
KEY AccountingDocument P_ID_StRpWhldgTaxFrgnItem AccountingDocument Journal Entry
KEY FiscalYear P_ID_StRpWhldgTaxFrgnItem FiscalYear G/L Fiscal Year
KEY WithholdingTaxType P_ID_StRpWhldgTaxFrgnItem WithholdingTaxType WTax Type
KEY StatryRptgEntity P_ID_StRpWhldgTaxFrgnItem StatryRptgEntity Reporting Entity
KEY StatryRptCategory P_ID_StRpWhldgTaxFrgnItem StatryRptCategory Report ID
KEY StatryRptRunID P_ID_StRpWhldgTaxFrgnItem StatryRptRunID Report Run ID
AccountingDocumentType P_ID_StRpWhldgTaxFrgnItem AccountingDocumentType Journal Entry Type
BusinessPartnerNumber P_ID_StRpWhldgTaxFrgnItem BusinessPartnerNumber
BusinessPartner P_ID_StRpWhldgTaxFrgnItem BusinessPartner Issuing Authority
WithholdingTaxIncomeType P_ID_StRpWhldgTaxFrgnItem WithholdingTaxIncomeType
BusinessPlace P_ID_StRpWhldgTaxFrgnItem BusinessPlace Business place
IsReversal P_ID_StRpWhldgTaxFrgnItem IsReversal Reversal doc.
IsReversed P_ID_StRpWhldgTaxFrgnItem IsReversed Reversed?
WhldgTaxDocumentType P_ID_StRpWhldgTaxFrgnItem WhldgTaxDocumentType 3-Byte field
ItemIsReportingRelevant P_ID_StRpWhldgTaxFrgnItem ItemIsReportingRelevant Item Reporting Relv
InvoiceReference P_ID_StRpWhldgTaxFrgnItem InvoiceReference Invoice Reference
FiscalPeriod P_ID_StRpWhldgTaxFrgnItem FiscalPeriod Tax period
BPTaxNumber P_ID_StRpWhldgTaxFrgnItem BPTaxNumber Tax Number
BusinessPartnerName P_ID_StRpWhldgTaxFrgnItem BusinessPartnerName Extracted Customer Name
BusinessPartnerCountry P_ID_StRpWhldgTaxFrgnItem BusinessPartnerCountry BP Ctry/Reg.
WithholdingTaxCountry P_ID_StRpWhldgTaxFrgnItem WithholdingTaxCountry WTax C/R Key
address P_ID_StRpWhldgTaxFrgnItem address Subscription address
BPIdentificationNumber P_ID_StRpWhldgTaxFrgnItem BPIdentificationNumber Logical System
BPIdentificationNumberForEdit P_ID_StRpWhldgTaxFrgnItem BPIdentificationNumberForEdit ID Number
BirthDate P_ID_StRpWhldgTaxFrgnItem BirthDate Date of Birth
BusinessPartnerBirthplaceName P_ID_StRpWhldgTaxFrgnItem BusinessPartnerBirthplaceName Birthplace
BPCertNumber P_ID_StRpWhldgTaxFrgnItem BPCertNumber
WithholdingTaxCertificate P_ID_StRpWhldgTaxFrgnItem WithholdingTaxCertificate WHT Certificate
WhldgTaxReferenceText P_ID_StRpWhldgTaxFrgnItem WhldgTaxReferenceText
ReportingCurrency P_ID_StRpWhldgTaxFrgnItem ReportingCurrency Currency
WhldgTaxRelevantPercent P_ID_StRpWhldgTaxFrgnItem WhldgTaxRelevantPercent
WithholdingTaxPercent P_ID_StRpWhldgTaxFrgnItem WithholdingTaxPercent
AccountingDocumentTypeName P_ID_StRpWhldgTaxFrgnItem AccountingDocumentTypeName
DocumentReferenceID P_ID_StRpWhldgTaxFrgnItem DocumentReferenceID Reference
PostingDate P_ID_StRpWhldgTaxFrgnItem PostingDate Posting Date for GR
AccountingDocumentHeaderText P_ID_StRpWhldgTaxFrgnItem AccountingDocumentHeaderText Doc.Header Text

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_ID_STRPWHLDGTAXFRGNITEMQ.
-- 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.

CREATE VIEW P_ID_STRPWHLDGTAXFRGNITEMQ AS
SELECT
  doc.CompanyCode AS CompanyCode,
  doc.AccountingDocument AS AccountingDocument,
  doc.FiscalYear AS FiscalYear,
  doc.WithholdingTaxType AS WithholdingTaxType,
  doc.StatryRptgEntity AS StatryRptgEntity,
  doc.StatryRptCategory AS StatryRptCategory,
  doc.StatryRptRunID AS StatryRptRunID,
  doc.AccountingDocumentType AS AccountingDocumentType,
  doc.BusinessPartnerNumber AS BusinessPartnerNumber,
  doc.BusinessPartner AS BusinessPartner,
  doc.WithholdingTaxIncomeType AS WithholdingTaxIncomeType,
  doc.BusinessPlace AS BusinessPlace,
  doc.IsReversal AS IsReversal,
  doc.IsReversed AS IsReversed,
  doc.WhldgTaxDocumentType AS WhldgTaxDocumentType,
  doc.ItemIsReportingRelevant AS ItemIsReportingRelevant,
  doc.InvoiceReference AS InvoiceReference,
  doc.FiscalPeriod AS FiscalPeriod,
  doc.BPTaxNumber AS BPTaxNumber,
  doc.BusinessPartnerName AS BusinessPartnerName,
  doc.BusinessPartnerCountry AS BusinessPartnerCountry,
  doc.WithholdingTaxCountry AS WithholdingTaxCountry,
  doc.address AS address,
  doc.BPIdentificationNumber AS BPIdentificationNumber,
  doc.BPIdentificationNumberForEdit AS BPIdentificationNumberForEdit,
  doc.BirthDate AS BirthDate,
  doc.BusinessPartnerBirthplaceName AS BusinessPartnerBirthplaceName,
  doc.BPCertNumber AS BPCertNumber,
  doc.WithholdingTaxCertificate AS WithholdingTaxCertificate,
  doc.WhldgTaxReferenceText AS WhldgTaxReferenceText,
  doc.ReportingCurrency AS ReportingCurrency,
  doc.WhldgTaxRelevantPercent AS WhldgTaxRelevantPercent,
  doc.WithholdingTaxPercent AS WithholdingTaxPercent,
  doc.AccountingDocumentTypeName AS AccountingDocumentTypeName,
  doc.DocumentReferenceID AS DocumentReferenceID,
  doc.PostingDate AS PostingDate,
  doc.AccountingDocumentHeaderText AS AccountingDocumentHeaderText
FROM P_ID_StRpWhldgTaxFrgnItem AS doc
;

Learn More