P_ES_StRpWithholdingTaxItem

DDL: P_ES_STRPWITHHOLDINGTAXITEM Type: view_entity COMPOSITE
61 Fields 1 Data Sources

P_ES_StRpWithholdingTaxItem is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_StRpWhldgTaxItemLog) and exposes 61 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem, WithholdingTaxType.

Data Sources (1)

SourceAliasJoin Type
P_StRpWhldgTaxItemLog wht from

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
Metadata.ignorePropagatedAnnotations true view

Fields (61)

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
SupplierRecipientType P_StRpWhldgTaxItemLog SupplierRecipientType
Country P_StRpWhldgTaxItemLog Country Venue: Ctry/Reg
TaxSection P_StRpWhldgTaxItemLog TaxSection Tax Section
BusinessPlace P_StRpWhldgTaxItemLog BusinessPlace Business place
OfficialWhldgTaxCode
FinancialAccountType P_StRpWhldgTaxItemLog FinancialAccountType Fin. Account Type
Debtor P_StRpWhldgTaxItemLog Debtor Debtor
Creditor P_StRpWhldgTaxItemLog Creditor Supplier
BusinessPartner P_StRpWhldgTaxItemLog BusinessPartner Issuing Authority
BusinessPartnerNumber P_StRpWhldgTaxItemLog BusinessPartnerNumber
WhldgTaxRptgDateIsActive P_StRpWhldgTaxItemLog WhldgTaxRptgDateIsActive
DefaultWhldgTxRptgDateIsActive P_StRpWhldgTaxItemLog DefaultWhldgTxRptgDateIsActive
WithholdingTaxReportingDate P_StRpWhldgTaxItemLog WithholdingTaxReportingDate Withholding Tax Reporting Date
DocumentDate P_StRpWhldgTaxItemLog DocumentDate Journal Entry Date
ClearingDate P_StRpWhldgTaxItemLog ClearingDate Clearing Date
ClearingJournalEntry P_StRpWhldgTaxItemLog ClearingJournalEntry Clrng doc.
ClearingJournalEntryFiscalYear P_StRpWhldgTaxItemLog ClearingJournalEntryFiscalYear Fiscal Year of Clearing Journal Entry
InvoiceReference P_StRpWhldgTaxItemLog InvoiceReference Invoice Reference
InvoiceReferenceFiscalYear P_StRpWhldgTaxItemLog InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
IsReversed P_StRpWhldgTaxItemLog IsReversed Reversed?
IsReversal P_StRpWhldgTaxItemLog IsReversal Reversal doc.
ReportingCurrency P_StRpWhldgTaxItemLog ReportingCurrency Currency
AmountInCompanyCodeCurrency P_StRpWhldgTaxItemLog AmountInCompanyCodeCurrency Local Crcy Amt
AmountInLocalCurrency P_StRpWhldgTaxItemLog AmountInLocalCurrency Local Crcy Amt
TaxAmountInCoCodeCrcy P_StRpWhldgTaxItemLog TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
WhldgTaxBaseAmtInCoCodeCrcy P_StRpWhldgTaxItemLog WhldgTaxBaseAmtInCoCodeCrcy
WhldgTaxAmtInCoCodeCrcy P_StRpWhldgTaxItemLog WhldgTaxAmtInCoCodeCrcy
IsSelfWhldgTax P_StRpWhldgTaxItemLog IsSelfWhldgTax
IsGrossingUp P_StRpWhldgTaxItemLog IsGrossingUp
WithholdingTaxCertificate P_StRpWhldgTaxItemLog WithholdingTaxCertificate WHT Certificate
WhldgTaxCertDate P_StRpWhldgTaxItemLog WhldgTaxCertDate
WhldgTaxDocumentType P_StRpWhldgTaxItemLog WhldgTaxDocumentType 3-Byte field
ItemIsReportingRelevant P_StRpWhldgTaxItemLog ItemIsReportingRelevant Item Reporting Relv
Name P_StRpWhldgTaxItemLog Name Zone name
BusinessPartnerCountry P_StRpWhldgTaxItemLog BusinessPartnerCountry BP Ctry/Reg.
TaxNumber1 P_StRpWhldgTaxItemLog TaxNumber1 VAT Reg. No.
TaxNumber2 P_StRpWhldgTaxItemLog TaxNumber2 Tax Number 2
TaxNumber3 P_StRpWhldgTaxItemLog TaxNumber3
TaxNumber4 P_StRpWhldgTaxItemLog TaxNumber4
TaxNumber5 P_StRpWhldgTaxItemLog TaxNumber5
VATRegistration P_StRpWhldgTaxItemLog VATRegistration VAT Registration No.
TaxItemIsZeroRated P_StRpWhldgTaxItemLog TaxItemIsZeroRated
DocumentReferenceID P_StRpWhldgTaxItemLog DocumentReferenceID Reference
IsNaturalPerson P_StRpWhldgTaxItemLog IsNaturalPerson Natural person
SpecialGLCode P_StRpWhldgTaxItemLog SpecialGLCode Special G/L Ind
SpecialGLTransactionType P_StRpWhldgTaxItemLog SpecialGLTransactionType Transact.Type
_WithholdingTaxCode P_StRpWhldgTaxItemLog _WithholdingTaxCode
_CompanyCode P_StRpWhldgTaxItemLog _CompanyCode
_Supplier P_StRpWhldgTaxItemLog _Supplier
_Customer P_StRpWhldgTaxItemLog _Customer
_ReportingCurrency P_StRpWhldgTaxItemLog _ReportingCurrency
_Onetime P_StRpWhldgTaxItemLog _Onetime
_Branch P_StRpWhldgTaxItemLog _Branch
_JournalEntry P_StRpWhldgTaxItemLog _JournalEntry
_OperationalAcctgDocItem P_StRpWhldgTaxItemLog _OperationalAcctgDocItem

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_ES_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_ES_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.SupplierRecipientType AS SupplierRecipientType,
  wht.Country AS Country,
  wht.TaxSection AS TaxSection,
  wht.BusinessPlace AS BusinessPlace,
  wht._WithholdingTaxCode.OfficialWhldgTaxCode AS OfficialWhldgTaxCode,
  wht.FinancialAccountType AS FinancialAccountType,
  wht.Debtor AS Debtor,
  wht.Creditor AS Creditor,
  wht.BusinessPartner AS BusinessPartner,
  wht.BusinessPartnerNumber AS BusinessPartnerNumber,
  wht.WhldgTaxRptgDateIsActive AS WhldgTaxRptgDateIsActive,
  wht.DefaultWhldgTxRptgDateIsActive AS DefaultWhldgTxRptgDateIsActive,
  wht.WithholdingTaxReportingDate AS WithholdingTaxReportingDate,
  wht.DocumentDate AS DocumentDate,
  wht.ClearingDate AS ClearingDate,
  wht.ClearingJournalEntry AS ClearingJournalEntry,
  wht.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  wht.InvoiceReference AS InvoiceReference,
  wht.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  wht.IsReversed AS IsReversed,
  wht.IsReversal AS IsReversal,
  wht.ReportingCurrency AS ReportingCurrency,
  wht.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  wht.AmountInLocalCurrency AS AmountInLocalCurrency,
  wht.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  wht.WhldgTaxBaseAmtInCoCodeCrcy AS WhldgTaxBaseAmtInCoCodeCrcy,
  wht.WhldgTaxAmtInCoCodeCrcy AS WhldgTaxAmtInCoCodeCrcy,
  wht.IsSelfWhldgTax AS IsSelfWhldgTax,
  wht.IsGrossingUp AS IsGrossingUp,
  wht.WithholdingTaxCertificate AS WithholdingTaxCertificate,
  wht.WhldgTaxCertDate AS WhldgTaxCertDate,
  wht.WhldgTaxDocumentType AS WhldgTaxDocumentType,
  wht.ItemIsReportingRelevant AS ItemIsReportingRelevant,
  wht.Name AS Name,
  wht.BusinessPartnerCountry AS BusinessPartnerCountry,
  wht.TaxNumber1 AS TaxNumber1,
  wht.TaxNumber2 AS TaxNumber2,
  wht.TaxNumber3 AS TaxNumber3,
  wht.TaxNumber4 AS TaxNumber4,
  wht.TaxNumber5 AS TaxNumber5,
  wht.VATRegistration AS VATRegistration,
  wht.TaxItemIsZeroRated AS TaxItemIsZeroRated,
  wht.DocumentReferenceID AS DocumentReferenceID,
  wht.IsNaturalPerson AS IsNaturalPerson,
  wht.SpecialGLCode AS SpecialGLCode,
  wht.SpecialGLTransactionType AS SpecialGLTransactionType,
  wht._WithholdingTaxCode AS _WithholdingTaxCode,
  wht._CompanyCode AS _CompanyCode,
  wht._Supplier AS _Supplier,
  wht._Customer AS _Customer,
  wht._ReportingCurrency AS _ReportingCurrency,
  wht._Onetime AS _Onetime,
  wht._Branch AS _Branch,
  wht._JournalEntry AS _JournalEntry,
  wht._OperationalAcctgDocItem AS _OperationalAcctgDocItem
FROM P_StRpWhldgTaxItemLog AS wht
;

Learn More