C_StRpManageWhldgTaxItemQ

Manage Whldg Tax Item Activity - Qry | view: CSRMNGWHLDGTXITM | 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
Column Name Description
💲 Company Code Currency (ReportingCurrency):
WhldgTaxAmtInCoCodeCrcy null
WhldgTaxBaseAmtInCoCodeCrcy null
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
WithholdingTaxReportingDate Withholding Tax Reporting Date
NewWhldgTaxReportingDate New Withholding Tax Reporting Date
OldWhldgTaxReportingDate Old Withholding Tax Reporting Date
Column Name Description
WhldgTaxRptgDateIsActive Activate Withholding Tax Reporting Date Indicator Show values
Column Name Description Domain name
WithholdingTaxTypeName Text, 40 Characters Long TEXT40
WhldgTaxCodeName Text, 40 Characters Long TEXT40
CompanyCodeName Name of Company Code or Company TEXT25
AccountingDocumentTypeName Document Type Name TEXT20
AccountingDocumentHeaderText Document Header Text TEXT25
GLAccount General Ledger Account SAKNR
BusinessPartner Customer Number KUNNR
BusinessPartnerNumber Business Partner Number BU_PARTNER
Name null
StatryRptRunStatus null
TaxItemIsIncluded null
TotalNumberOfComments null
LastChangedByUser Last Changed by FIWT_MWHTI_USER
ChangedOnLongDateTime UTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun) TZNTSTMPL
SenderCompanyCode Company Code in Sender System CHAR4
SenderAccountingDocument Sender Journal Entry BELNR
SenderFiscalYear Fiscal Year of an Accounting Document in the Sender System GJAHR
SenderLogicalSystem Sender Logical System LOGSYS
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • C_STRPMANAGEWHLDGTAXITEMQ.MANDT == T003.MANDT
  • C_STRPMANAGEWHLDGTAXITEMQ.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Chart of Accounts
  • Client
  • Chart of Accounts
  • C_STRPMANAGEWHLDGTAXITEMQ.MANDT == T004.MANDT
  • C_STRPMANAGEWHLDGTAXITEMQ.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • C_STRPMANAGEWHLDGTAXITEMQ.MANDT == T001.MANDT
  • C_STRPMANAGEWHLDGTAXITEMQ.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Country/Region Key
  • Client
  • C_STRPMANAGEWHLDGTAXITEMQ.COUNTRY == T005.LAND1
  • C_STRPMANAGEWHLDGTAXITEMQ.MANDT == T005.MANDT
Withholding Tax Code
  • Country/Region Key
  • Indicator for Withholding Tax Type
  • Client
  • Withholding Tax Code
  • C_STRPMANAGEWHLDGTAXITEMQ.COUNTRY == T059Z.LAND1
  • C_STRPMANAGEWHLDGTAXITEMQ.WITHHOLDINGTAXTYPE == T059Z.WITHT
  • C_STRPMANAGEWHLDGTAXITEMQ.MANDT == T059Z.MANDT
  • C_STRPMANAGEWHLDGTAXITEMQ.WITHHOLDINGTAXCODE == T059Z.WT_WITHCD
Indicator for Withholding Tax Type
  • Country/Region Key
  • Indicator for Withholding Tax Type
  • Client
  • C_STRPMANAGEWHLDGTAXITEMQ.COUNTRY == T059P.LAND1
  • C_STRPMANAGEWHLDGTAXITEMQ.WITHHOLDINGTAXTYPE == T059P.WITHT
  • C_STRPMANAGEWHLDGTAXITEMQ.MANDT == T059P.MANDT