I_Be_Strpwhldgtaxitem

Withholding Tax Item For Statutory Reporting Belgium | view: ISRBEWHLDGTXITM | TRAN | Extraction: Not supported | Component: Withholding Tax Reporting
Column Name Description
CompanyCode FK Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
AccountingDocumentItem Number of Line Item Within Accounting Document
WithholdingTaxType FK Indicator for Withholding Tax Type
StatryRptgEntity FK Reporting Entity
StatryRptCategory FK Report Category ID
StatryRptRunID Report Run ID
Column Name Description
💲 Company Code Currency (ReportingCurrency):
PaymentAmountInCoCodeCrcy Withholding Tax Payment Amount
WhldgTaxBaseAmtInCoCodeCrcy Withholding Tax Base Amount in Company Code Currency
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
ReportingDate Reporting Date
Column Name Description
FinancialAccountType Account type Show values
WhldgTaxBeneficiaryType Withholding Tax Beneficiary Type Show values
IsNaturalPerson Natural Person Show values
IsReversal Indicator: Item is Reversing Another Item Show values
Column Name Description Domain name
BusinessPartner Business Partner Number /SCMB/DO_BU_PARTNER
TaxNumber1 Tax Number 1 STCD1
TaxNumber2 Tax Number 2 STCD2
VATRegistration VAT Registration Number STCEG
CompanyCodeName Name of Company Code or Company TEXT25
TaxFilingAgencyAddress Address Text
PostalCode City postal code CHAR10
CityName City TEXT40
CompanyCodeCountryName Country/Region Name TEXT50
CustomerSupplierVATRegn Partner VAT Registration STCEG
CustomerSupplierName Business Partner Name TEXT80
CustomerSupplierAddress Business Partner Address
CustomerSupplierPostalCode Business Partner Postal Code CHAR10
CustomerSupplierCityCode Business partner City Code CITY_CODE
CustomerSupplierCityName Business partner City Name TEXT40
CustomerSupplierCountryCode Partner's Withholding Tax Country/Region Code
CountryName Country/Region Name TEXT50
Language Language Key SPRAS
NaturalPersonVATRegistration Natural Person VAT Registration Number STCEG
SearchTerm2 Search Term 2 CHAR20
ItemIsReportingRelevant null
Master Data Relations Join Conditions
City code for city/street file
  • Client
  • ?
  • City code for city/street file
  • I_BE_STRPWHLDGTAXITEM.MANDT == ADRCITY.CLIENT
  • I_BE_STRPWHLDGTAXITEM.[column in domain "LAND1"] == ADRCITY.COUNTRY
  • I_BE_STRPWHLDGTAXITEM.CITYCODE == ADRCITY.CITY_CODE
Company Code
  • Client
  • Company Code
  • I_BE_STRPWHLDGTAXITEM.MANDT == T001.MANDT
  • I_BE_STRPWHLDGTAXITEM.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Country/Region Key
  • Client
  • I_BE_STRPWHLDGTAXITEM.COUNTRY == T005.LAND1
  • I_BE_STRPWHLDGTAXITEM.MANDT == T005.MANDT
Supplier
  • Client
  • Supplier
  • I_BE_STRPWHLDGTAXITEM.MANDT == LFA1.MANDT
  • I_BE_STRPWHLDGTAXITEM.CREDITOR == LFA1.LIFNR
Customer Number
  • Client
  • Customer Number
  • I_BE_STRPWHLDGTAXITEM.MANDT == KNA1.MANDT
  • I_BE_STRPWHLDGTAXITEM.DEBTOR == KNA1.KUNNR
Official Withholding Tax Key
  • Official Withholding Tax Key
  • Country/Region Key
  • Client
  • I_BE_STRPWHLDGTAXITEM.OFFICIALWHLDGTAXCODE == T059O.WT_QSCOD
  • I_BE_STRPWHLDGTAXITEM.COUNTRY == T059O.LAND1
  • I_BE_STRPWHLDGTAXITEM.MANDT == T059O.MANDT
Reporting Entity
  • Reporting Entity
  • Client
  • I_BE_STRPWHLDGTAXITEM.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
  • I_BE_STRPWHLDGTAXITEM.MANDT == SRF_RPG_ENT.MANDT
Withholding Tax Code
  • Indicator for Withholding Tax Type
  • Country/Region Key
  • Client
  • Withholding Tax Code
  • I_BE_STRPWHLDGTAXITEM.WITHHOLDINGTAXTYPE == T059Z.WITHT
  • I_BE_STRPWHLDGTAXITEM.COUNTRY == T059Z.LAND1
  • I_BE_STRPWHLDGTAXITEM.MANDT == T059Z.MANDT
  • I_BE_STRPWHLDGTAXITEM.WITHHOLDINGTAXCODE == T059Z.WT_WITHCD
Indicator for Withholding Tax Type
  • Indicator for Withholding Tax Type
  • Country/Region Key
  • Client
  • I_BE_STRPWHLDGTAXITEM.WITHHOLDINGTAXTYPE == T059P.WITHT
  • I_BE_STRPWHLDGTAXITEM.COUNTRY == T059P.LAND1
  • I_BE_STRPWHLDGTAXITEM.MANDT == T059P.MANDT