P_RS_StrpWithholdingTaxItem

DDL: P_RS_STRPWITHHOLDINGTAXITEM Type: view_entity COMPOSITE
14 Fields 1 Data Sources 3 Associations

Private view - WTax Serbia DOCSEL query

P_RS_StrpWithholdingTaxItem is a Composite CDS View that provides data about "Private view - WTax Serbia DOCSEL query" in SAP S/4HANA. It reads from 1 data source (P_StRpWhldgTaxItemLog) and exposes 14 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem, WithholdingTaxType. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_StRpWhldgTaxItemLog wht from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_Extendedwhldgtaxcode _taxcode _taxcode.Country = wht.Country and _taxcode.WithholdingTaxType = wht.WithholdingTaxType and _taxcode.WithholdingTaxCode = wht.WithholdingTaxCode
[0..1] I_Businesspartnerwhldgtax lfbw lfbw.CompanyCode = wht.CompanyCode and lfbw.WithholdingTaxType = wht.WithholdingTaxType and lfbw.Supplier = wht.Creditor
[0..1] I_WhldgTaxCountryCategory _revcode _revcode.Country = 'RS' and _revcode.WithholdingRevenueCountry = wht.BusinessPartnerCountry

Annotations (8)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
EndUserText.label Private view - WTax Serbia DOCSEL query view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_StRpWhldgTaxItemLog CompanyCode Receiver Company Code
KEY AccountingDocument P_StRpWhldgTaxItemLog AccountingDocument Journal Entry
KEY FiscalYear P_StRpWhldgTaxItemLog FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem P_StRpWhldgTaxItemLog AccountingDocumentItem Posting View Item
KEY WithholdingTaxType P_StRpWhldgTaxItemLog WithholdingTaxType WTax Type
WithholdingTaxCode P_StRpWhldgTaxItemLog WithholdingTaxCode WTax Code
WithholdingTaxIncomeType P_StRpWhldgTaxItemLog WithholdingTaxIncomeType
BusinessPartner P_StRpWhldgTaxItemLog BusinessPartner Issuing Authority
PostingDate P_StRpWhldgTaxItemLog PostingDate Posting Date for GR
WhldgTaxDocumentType P_StRpWhldgTaxItemLog WhldgTaxDocumentType 3-Byte field
ReportingCurrency ReportingCurrency Currency
IsGrossingUp P_StRpWhldgTaxItemLog IsGrossingUp
IsReversed P_StRpWhldgTaxItemLog IsReversed Reversed?
IsReversal P_StRpWhldgTaxItemLog IsReversal Reversal doc.

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_RS_StrpWithholdingTaxItem.
-- 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_RS_StrpWithholdingTaxItem AS
SELECT
  wht.CompanyCode AS CompanyCode,
  wht.AccountingDocument AS AccountingDocument,
  wht.FiscalYear AS FiscalYear,
  wht.AccountingDocumentItem AS AccountingDocumentItem,
  wht.WithholdingTaxType AS WithholdingTaxType,
  wht.WithholdingTaxCode AS WithholdingTaxCode,
  wht.WithholdingTaxIncomeType AS WithholdingTaxIncomeType,
  wht.BusinessPartner AS BusinessPartner,
  wht.PostingDate AS PostingDate,
  wht.WhldgTaxDocumentType AS WhldgTaxDocumentType,
  ReportingCurrency,
  wht.IsGrossingUp AS IsGrossingUp,
  wht.IsReversed AS IsReversed,
  wht.IsReversal AS IsReversal
FROM P_StRpWhldgTaxItemLog AS wht
LEFT OUTER JOIN I_Extendedwhldgtaxcode AS _taxcode ON _taxcode.Country = wht.Country AND _taxcode.WithholdingTaxType = wht.WithholdingTaxType AND _taxcode.WithholdingTaxCode = wht.WithholdingTaxCode  -- association [0..1]
LEFT OUTER JOIN I_Businesspartnerwhldgtax AS lfbw ON lfbw.CompanyCode = wht.CompanyCode AND lfbw.WithholdingTaxType = wht.WithholdingTaxType AND lfbw.Supplier = wht.Creditor  -- association [0..1]
LEFT OUTER JOIN I_WhldgTaxCountryCategory AS _revcode ON _revcode.Country = 'RS' AND _revcode.WithholdingRevenueCountry = wht.BusinessPartnerCountry  -- association [0..1]
;

Learn More