I_Be_Strpwhldgtaxitem

DDL: I_BE_STRPWHLDGTAXITEM Type: view_entity COMPOSITE
52 Fields 3 Associations

WHT Item For Statutory Reporting Belgium

I_Be_Strpwhldgtaxitem is a Composite CDS View (Cube) that provides data about "WHT Item For Statutory Reporting Belgium" in SAP S/4HANA. It has 3 associations to related views.

Associations (3)

CardinalityTargetAliasCondition
[1..*] I_ReceivablesPayablesItem _Doc I_StRpWhldgTaxItem.CompanyCode = _Doc.CompanyCode and ( I_StRpWhldgTaxItem.AccountingDocument = _Doc.ClearingAccountingDocument or I_StRpWhldgTaxItem.InvoiceReference = _Doc.AccountingDocument ) and ( _Doc.FollowOnDocumentType = 'Z' or _Doc.FollowOnDocumentType = ' ' ) and I_StRpWhldgTaxItem.AccountingDocument <> _Doc.AccountingDocument and I_StRpWhldgTaxItem.FinancialAccountType = _Doc.FinancialAccountType
[0..1] I_Currency _ReportingCurrency $projection.ReportingCurrency = _ReportingCurrency.Currency
[1..1] P_Withholdingtxtype _TaxType $projection.WithholdingTaxType = _TaxType.witht

Annotations (10)

NameValueLevelField
EndUserText.label WHT Item For Statutory Reporting Belgium view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #CUBE view
Analytics.technicalName ISRBEWHLDGTXITM view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
Metadata.allowExtensions true view

Fields (52)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_StRpWhldgTaxItem CompanyCode Receiver Company Code
KEY AccountingDocument I_StRpWhldgTaxItem AccountingDocument Journal Entry
KEY FiscalYear I_StRpWhldgTaxItem FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem I_StRpWhldgTaxItem AccountingDocumentItem Posting View Item
KEY WithholdingTaxType I_StRpWhldgTaxItem WithholdingTaxType WTax Type
KEY StatryRptgEntity I_StRpWhldgTaxItem StatryRptgEntity Reporting Entity
KEY StatryRptCategory I_StRpWhldgTaxItem StatryRptCategory Report ID
KEY StatryRptRunID I_StRpWhldgTaxItem StatryRptRunID Report Run ID
WithholdingTaxCode I_StRpWhldgTaxItem WithholdingTaxCode WTax Code
Country I_StRpWhldgTaxItem Country Venue: Ctry/Reg
Creditor I_StRpWhldgTaxItem Creditor Supplier
Debtor I_StRpWhldgTaxItem Debtor Debtor
BusinessPartner I_StRpWhldgTaxItem BusinessPartner Issuing Authority
BusinessPlace I_StRpWhldgTaxItem BusinessPlace Business place
FinancialAccountType I_StRpWhldgTaxItem FinancialAccountType Fin. Account Type
PostingDate I_StRpWhldgTaxItem PostingDate Posting Date for GR
DocumentDate I_StRpWhldgTaxItem DocumentDate Journal Entry Date
ReportingDate
ReportingCurrency I_StRpWhldgTaxItem ReportingCurrency Currency
TaxNumber1endendasstcd1asTaxNumber1
TaxNumber2endendasstcd2asTaxNumber2
VATRegistration
CompanyCodeName
PostalCode
CityCode
CityName
CompanyCodeCountryName
CustomerSupplierName
CustomerSupplierPostalCode
CustomerSupplierCityName
CountryName
ClearingJournalEntry I_StRpWhldgTaxItem ClearingJournalEntry Clrng doc.
ClearingDate I_StRpWhldgTaxItem ClearingDate Clearing Date
WhldgTaxDocumentType I_StRpWhldgTaxItem WhldgTaxDocumentType 3-Byte field
InvoiceReference I_StRpWhldgTaxItem InvoiceReference Invoice Reference
InvoiceReferenceFiscalYear I_StRpWhldgTaxItem InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
WhldgTaxPostingTimePoint _TaxType wt_postm Posting Time
IsOneTimeAccountendasIsOneTimeAccount
TransactionCurrency I_StRpWhldgTaxItem TransactionCurrency Transaction Currency
WhldgTaxBaseAmtInTransacCrcy I_StRpWhldgTaxItem WhldgTaxBaseAmtInTransacCrcy
WhldgTaxAmtInTransacCrcy I_StRpWhldgTaxItem WhldgTaxAmtInTransacCrcy
WhldgTaxAmtInCoCodeCrcy I_StRpWhldgTaxItem WhldgTaxAmtInCoCodeCrcy
AmountInCompanyCodeCurrency I_StRpWhldgTaxItem AmountInCompanyCodeCurrency Local Crcy Amt
AmountInTransactionCurrency I_StRpWhldgTaxItem AmountInTransactionCurrency Pt Crcy Amt
WithholdingTaxPercent I_StRpWhldgTaxItem WithholdingTaxPercent
OfficialWhldgTaxCode I_StRpWhldgTaxItem OfficialWhldgTaxCode
_ReportingCurrency _ReportingCurrency
SearchTerm2
IsNaturalPerson
ItemIsReportingRelevant I_StRpWhldgTaxItem ItemIsReportingRelevant Item Reporting Relv
IsReversal I_StRpWhldgTaxItem IsReversal Reversal doc.
IsReversed I_StRpWhldgTaxItem IsReversed Reversed?

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 I_Be_Strpwhldgtaxitem.
-- 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 I_Be_Strpwhldgtaxitem AS
SELECT
  I_StRpWhldgTaxItem.CompanyCode AS CompanyCode,
  I_StRpWhldgTaxItem.AccountingDocument AS AccountingDocument,
  I_StRpWhldgTaxItem.FiscalYear AS FiscalYear,
  I_StRpWhldgTaxItem.AccountingDocumentItem AS AccountingDocumentItem,
  I_StRpWhldgTaxItem.WithholdingTaxType AS WithholdingTaxType,
  I_StRpWhldgTaxItem.StatryRptgEntity AS StatryRptgEntity,
  I_StRpWhldgTaxItem.StatryRptCategory AS StatryRptCategory,
  I_StRpWhldgTaxItem.StatryRptRunID AS StatryRptRunID,
  I_StRpWhldgTaxItem.WithholdingTaxCode AS WithholdingTaxCode,
  I_StRpWhldgTaxItem.Country AS Country,
  I_StRpWhldgTaxItem.Creditor AS Creditor,
  I_StRpWhldgTaxItem.Debtor AS Debtor,
  I_StRpWhldgTaxItem.BusinessPartner AS BusinessPartner,
  I_StRpWhldgTaxItem.BusinessPlace AS BusinessPlace,
  I_StRpWhldgTaxItem.FinancialAccountType AS FinancialAccountType,
  I_StRpWhldgTaxItem.PostingDate AS PostingDate,
  I_StRpWhldgTaxItem.DocumentDate AS DocumentDate,
  cast( I_StRpWhldgTaxItem.ReportingDate as ftr_reporting_date) AS ReportingDate,
  I_StRpWhldgTaxItem.ReportingCurrency AS ReportingCurrency,
  cast( case when I_StRpWhldgTaxItem.Creditor <> '' then case I_StRpWhldgTaxItem._Supplier.IsNaturalPerson when 'X' then I_StRpWhldgTaxItem._Supplier.TaxNumberResponsible else I_StRpWhldgTaxItem.TaxNumber1 end else case when I_StRpWhldgTaxItem.Debtor <> '' then I_StRpWhldgTaxItem.TaxNumber1 end end as stcd1) as TaxNumber1 AS TaxNumber1endendasstcd1asTaxNumber1,
  cast( case when I_StRpWhldgTaxItem.Creditor <> '' then case I_StRpWhldgTaxItem._Supplier.IsNaturalPerson when 'X' then I_StRpWhldgTaxItem._Supplier.TaxNumberResponsible else I_StRpWhldgTaxItem.TaxNumber2 end else case when I_StRpWhldgTaxItem.Debtor <> '' then I_StRpWhldgTaxItem.TaxNumber2 end end as stcd2) as TaxNumber2 AS TaxNumber2endendasstcd2asTaxNumber2,
  I_StRpWhldgTaxItem._CompanyCode.VATRegistration AS VATRegistration,
  I_StRpWhldgTaxItem._CompanyCode.CompanyCodeName AS CompanyCodeName,
  I_StRpWhldgTaxItem._CompanyCode._Address.PostalCode AS PostalCode,
  I_StRpWhldgTaxItem._CompanyCode._Address.CityCode AS CityCode,
  I_StRpWhldgTaxItem._CompanyCode._Address.CityName AS CityName,
  I_StRpWhldgTaxItem._CompanyCode._Country._Text[1: Language = $session.system_language].CountryName AS CompanyCodeCountryName,
  cast( I_StRpWhldgTaxItem.Name as glo_partner) AS CustomerSupplierName,
  cast( I_StRpWhldgTaxItem.PostalCode as glo_partner_pocode) AS CustomerSupplierPostalCode,
  cast( I_StRpWhldgTaxItem.CityName as glo_partner_cityname) AS CustomerSupplierCityName,
  _Doc._Supplier._StandardAddress._Country._Text[1: Language = $session.system_language].CountryName AS CountryName,
  I_StRpWhldgTaxItem.ClearingJournalEntry AS ClearingJournalEntry,
  I_StRpWhldgTaxItem.ClearingDate AS ClearingDate,
  I_StRpWhldgTaxItem.WhldgTaxDocumentType AS WhldgTaxDocumentType,
  I_StRpWhldgTaxItem.InvoiceReference AS InvoiceReference,
  I_StRpWhldgTaxItem.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  _TaxType.wt_postm AS WhldgTaxPostingTimePoint,
  case when I_StRpWhldgTaxItem.Debtor = '' then I_StRpWhldgTaxItem._Supplier.IsOneTimeAccount else I_StRpWhldgTaxItem._Customer.IsOneTimeAccount end as IsOneTimeAccount AS IsOneTimeAccountendasIsOneTimeAccount,
  I_StRpWhldgTaxItem.TransactionCurrency AS TransactionCurrency,
  I_StRpWhldgTaxItem.WhldgTaxBaseAmtInTransacCrcy AS WhldgTaxBaseAmtInTransacCrcy,
  I_StRpWhldgTaxItem.WhldgTaxAmtInTransacCrcy AS WhldgTaxAmtInTransacCrcy,
  I_StRpWhldgTaxItem.WhldgTaxAmtInCoCodeCrcy AS WhldgTaxAmtInCoCodeCrcy,
  I_StRpWhldgTaxItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  I_StRpWhldgTaxItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  I_StRpWhldgTaxItem.WithholdingTaxPercent AS WithholdingTaxPercent,
  I_StRpWhldgTaxItem.OfficialWhldgTaxCode AS OfficialWhldgTaxCode,
  I_StRpWhldgTaxItem._Supplier._StandardAddress.SearchTerm2 AS SearchTerm2,
  I_StRpWhldgTaxItem._Supplier.IsNaturalPerson AS IsNaturalPerson,
  I_StRpWhldgTaxItem.ItemIsReportingRelevant AS ItemIsReportingRelevant,
  I_StRpWhldgTaxItem.IsReversal AS IsReversal,
  I_StRpWhldgTaxItem.IsReversed AS IsReversed
LEFT OUTER JOIN I_ReceivablesPayablesItem AS _Doc ON I_StRpWhldgTaxItem.CompanyCode = _Doc.CompanyCode AND ( I_StRpWhldgTaxItem.AccountingDocument = _Doc.ClearingAccountingDocument OR I_StRpWhldgTaxItem.InvoiceReference = _Doc.AccountingDocument ) AND ( _Doc.FollowOnDocumentType = 'Z' OR _Doc.FollowOnDocumentType = ' ' ) AND I_StRpWhldgTaxItem.AccountingDocument <> _Doc.AccountingDocument AND I_StRpWhldgTaxItem.FinancialAccountType = _Doc.FinancialAccountType  -- association [1..*]
LEFT OUTER JOIN I_Currency AS _ReportingCurrency ON ReportingCurrency = _ReportingCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN P_Withholdingtxtype AS _TaxType ON WithholdingTaxType = _TaxType.witht  -- association [1..1]
;

Learn More