P_ES_STRPMANAGEWHLDGTAXITEMC

DDL: P_ES_STRPMANAGEWHLDGTAXITEMC Type: view_entity COMPOSITE
57 Fields 2 Data Sources

Spain MWTI View

P_ES_STRPMANAGEWHLDGTAXITEMC is a Composite CDS View that provides data about "Spain MWTI View" in SAP S/4HANA. It reads from 2 data sources (I_StRpManageWhldgTaxItemC, I_ES_WithholdingKey) and exposes 57 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem, WithholdingTaxType.

Data Sources (2)

SourceAliasJoin Type
I_StRpManageWhldgTaxItemC I_StRpManageWhldgTaxItemC from
I_ES_WithholdingKey wthkey inner

Parameters (2)

NameTypeDefault
P_WhldgTaxReportingFromDate whtdate
P_WhldgTaxReportingToDate whtdate

Annotations (9)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
EndUserText.label Spain MWTI View view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode wht CompanyCode Receiver Company Code
KEY AccountingDocument wht AccountingDocument Journal Entry
KEY FiscalYear wht FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem wht AccountingDocumentItem Posting View Item
KEY WithholdingTaxType wht WithholdingTaxType WTax Type
ES_WhldgReportType I_ES_WithholdingKey ES_WhldgReportType Report Type
WithholdingTaxCode wht WithholdingTaxCode WTax Code
PostingDate wht PostingDate Posting Date for GR
DocumentDate wht DocumentDate Journal Entry Date
WithholdingTaxReportingDate wht WithholdingTaxReportingDate Withholding Tax Reporting Date
OriginalReferenceDocument wht OriginalReferenceDocument Reference Key
CompanyCodeName wht CompanyCodeName Company Name
AccountingDocumentType wht AccountingDocumentType Journal Entry Type
AccountingDocumentTypeName wht AccountingDocumentTypeName
AccountingDocumentHeaderText wht AccountingDocumentHeaderText Doc.Header Text
GLAccount wht GLAccount General Ledger
OfficialWhldgTaxCode wht OfficialWhldgTaxCode
SupplierRecipientType wht SupplierRecipientType Recipient Type
WithholdingTaxIncomeType wht WithholdingTaxIncomeType
BusinessPlace wht BusinessPlace Business place
TaxSection wht TaxSection Tax Section
Country wht Country Venue: Ctry/Reg
Creditor wht Creditor Supplier
Debtor wht Debtor Debtor
Customer wht Customer Sold-to Party
Supplier wht Supplier Supplier
BusinessPartner wht BusinessPartner Issuing Authority
BusinessPartnerNumber wht BusinessPartnerNumber
BusinessPartnerCategory wht BusinessPartnerCategory Partner Cat.
Name wht Name Zone name
BusinessPartnerCountry wht BusinessPartnerCountry BP Ctry/Reg.
ReportingCurrency wht ReportingCurrency Currency
WhldgTaxBaseAmtInCoCodeCrcy wht WhldgTaxBaseAmtInCoCodeCrcy
WhldgTaxAmtInCoCodeCrcy wht WhldgTaxAmtInCoCodeCrcy
StatryRptRunStatus wht StatryRptRunStatus
WithholdingTaxTypeName wht WithholdingTaxTypeName
WhldgTaxCodeName wht WhldgTaxCodeName
SenderCompanyCode wht SenderCompanyCode Sender Company Code
SenderAccountingDocument wht SenderAccountingDocument Sender Journal Entry
SenderFiscalYear wht SenderFiscalYear Sender FiscalYr
SenderLogicalSystem wht SenderLogicalSystem Sender Logical System
TransactionTypeDetermination wht TransactionTypeDetermination Transaction Key
ChartOfAccounts wht ChartOfAccounts Node Class
TaxItemIsIncluded wht TaxItemIsIncluded
TotalNumberOfComments wht TotalNumberOfComments
NewWhldgTaxReportingDate wht NewWhldgTaxReportingDate
OldWhldgTaxReportingDate wht OldWhldgTaxReportingDate
LastChangedByUser wht LastChangedByUser User Name
UserDescription wht UserDescription Full Name
ChangedOnLongDateTime wht ChangedOnLongDateTime
IsReversal wht IsReversal Reversal doc.
IsReversed wht IsReversed Reversed?
WhldgTaxRptgDateIsActive wht WhldgTaxRptgDateIsActive
ClearingDate wht ClearingDate Clearing Date
ItemIsReportingRelevant wht ItemIsReportingRelevant Item Reporting Relv
InvoiceReference
WhldgTaxReferenceText I_ES_WithholdingKey WhldgTaxReferenceText WTax Key

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_STRPMANAGEWHLDGTAXITEMC.
-- 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.
-- Parameters: P_WhldgTaxReportingFromDate : whtdate, P_WhldgTaxReportingToDate : whtdate

CREATE VIEW P_ES_STRPMANAGEWHLDGTAXITEMC AS
SELECT
  wht.CompanyCode AS CompanyCode,
  wht.AccountingDocument AS AccountingDocument,
  wht.FiscalYear AS FiscalYear,
  wht.AccountingDocumentItem AS AccountingDocumentItem,
  wht.WithholdingTaxType AS WithholdingTaxType,
  wthkey.ES_WhldgReportType AS ES_WhldgReportType,
  wht.WithholdingTaxCode AS WithholdingTaxCode,
  wht.PostingDate AS PostingDate,
  wht.DocumentDate AS DocumentDate,
  wht.WithholdingTaxReportingDate AS WithholdingTaxReportingDate,
  wht.OriginalReferenceDocument AS OriginalReferenceDocument,
  wht.CompanyCodeName AS CompanyCodeName,
  wht.AccountingDocumentType AS AccountingDocumentType,
  wht.AccountingDocumentTypeName AS AccountingDocumentTypeName,
  wht.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  wht.GLAccount AS GLAccount,
  wht.OfficialWhldgTaxCode AS OfficialWhldgTaxCode,
  wht.SupplierRecipientType AS SupplierRecipientType,
  wht.WithholdingTaxIncomeType AS WithholdingTaxIncomeType,
  wht.BusinessPlace AS BusinessPlace,
  wht.TaxSection AS TaxSection,
  wht.Country AS Country,
  wht.Creditor AS Creditor,
  wht.Debtor AS Debtor,
  wht.Customer AS Customer,
  wht.Supplier AS Supplier,
  wht.BusinessPartner AS BusinessPartner,
  wht.BusinessPartnerNumber AS BusinessPartnerNumber,
  wht.BusinessPartnerCategory AS BusinessPartnerCategory,
  wht.Name AS Name,
  wht.BusinessPartnerCountry AS BusinessPartnerCountry,
  wht.ReportingCurrency AS ReportingCurrency,
  wht.WhldgTaxBaseAmtInCoCodeCrcy AS WhldgTaxBaseAmtInCoCodeCrcy,
  wht.WhldgTaxAmtInCoCodeCrcy AS WhldgTaxAmtInCoCodeCrcy,
  wht.StatryRptRunStatus AS StatryRptRunStatus,
  wht.WithholdingTaxTypeName AS WithholdingTaxTypeName,
  wht.WhldgTaxCodeName AS WhldgTaxCodeName,
  wht.SenderCompanyCode AS SenderCompanyCode,
  wht.SenderAccountingDocument AS SenderAccountingDocument,
  wht.SenderFiscalYear AS SenderFiscalYear,
  wht.SenderLogicalSystem AS SenderLogicalSystem,
  wht.TransactionTypeDetermination AS TransactionTypeDetermination,
  wht.ChartOfAccounts AS ChartOfAccounts,
  wht.TaxItemIsIncluded AS TaxItemIsIncluded,
  wht.TotalNumberOfComments AS TotalNumberOfComments,
  wht.NewWhldgTaxReportingDate AS NewWhldgTaxReportingDate,
  wht.OldWhldgTaxReportingDate AS OldWhldgTaxReportingDate,
  wht.LastChangedByUser AS LastChangedByUser,
  wht.UserDescription AS UserDescription,
  wht.ChangedOnLongDateTime AS ChangedOnLongDateTime,
  wht.IsReversal AS IsReversal,
  wht.IsReversed AS IsReversed,
  wht.WhldgTaxRptgDateIsActive AS WhldgTaxRptgDateIsActive,
  wht.ClearingDate AS ClearingDate,
  wht.ItemIsReportingRelevant AS ItemIsReportingRelevant,
  wht._OperationalAcctgDocItem.InvoiceReference AS InvoiceReference,
  wthkey.WhldgTaxReferenceText AS WhldgTaxReferenceText
FROM I_StRpManageWhldgTaxItemC
INNER JOIN I_ES_WithholdingKey AS wthkey ON /* join condition not captured in parsed metadata */
;

Learn More