C_SK_StRpWhldgTaxItemQuery

Query View for Slovakia Withholding Tax | view: CSKWHLDGTXITMQ | 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):
WhldgTaxBaseAmtInCoCodeCrcy null
WithholdingTaxAmount null
💲 Transaction Currency (TransactionCurrency):
WhldgTaxBaseAmtInTransacCrcy null
WhldgTaxAmtInTransacCrcy null
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
ClearingDate Clearing Date
BirthDate Date of Birth of Business Partner
WhldgTaxCertDate Issue or Print Date of Withholding Tax Certificate
Column Name Description
IsReversed Indicator: Item is Reversed Show values
IsReversal Indicator: Item is Reversing Another Item Show values
WhldgTaxBaseIsEnteredManually Indicator: Withholding Tax Base Amount Entered Manually Show values
WhldgTaxIsEnteredManually Indicator: Withholding Tax Amount Entered Manually Show values
WhldgTaxItemStatus Line Item Status Show values
IsNaturalPerson Natural Person Show values
IsSelfWhldgTax Indicator: Entry Posted as Self-Withholding Tax Show values
IsGrossingUp Indicator: Entry Posted as "Grossing Up" Show values
WhldgTaxBaseIsInherited Indicator: Base Amount Equals Amount of Other Type Show values
Column Name Description Domain name
CurrentDay null
CurrentMonth null
CalendarYear null
BusinessPartner Business Partner Number BU_PARTNER
WithholdingTaxPercent Withholding Tax Rate PRZ34
WhldgTaxDocumentType null
StreetName null
HouseNumber null
PostalCode null
CityName null
PayerTIN Business Partner Tax Number BPTAXNUM
FirstName First name of business partner (person) BU_NAME
LastName Last name of business partner (person) BU_NAME
SupplierName Name of Supplier TEXT80
BusinessPartnerNumber Business Partner Number BU_PARTNER
FiscalPeriod Fiscal Period POPER
SpecialGLTransactionType Special G/L Transaction Type UMSKS
InvoiceReference Invoice Reference BELNR
ReverseDocument Reverse Document BELNR
ClearingAccountingDocument Clearing Journal Entry BELNR
WithholdingTaxCertificate Withholding Tax Certificate Number CHAR10
ItemIsReportingRelevant null
Name null
TaxNumber1 null
TaxNumber2 null
TaxNumber3 null
TaxNumber4 null
TaxNumber5 null
VATRegistration VAT Registration Number STCEG
HouseNumberSupplementText null
OrganizationBPName1 null
SearchTerm1 null
OrganizationBPName2 null
POBoxPostalCode null
POBox null
Region null
BusinessPartnerCountry null
CountryName Country/Region Name TEXT50
TaxNumberType Tax Number Type TEXT2
PaymentIsNotified null
Language Language Key SPRAS
TaxItemIsZeroRated null
DocumentReferenceID Reference Document Number XBLNR1
TransactionCode Transaction Code TCODE
AccountingDocumentHeaderText Document Header Text TEXT25
DocumentItemText Item Text TEXT50
EmailAddress E-Mail Address AD_SMTPADR
SqntlNmbrOfWhldgTaxType Sequential Number of a Withholding Tax Type WT_TPNR
DependencyNmbrOfWhldgTaxType Withholding Tax Type Number on Which This W/Tax Type Depends WT_TPNR
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_SK_STRPWHLDGTAXITEMQUERY.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_SK_STRPWHLDGTAXITEMQUERY.MANDT == T003.MANDT
Company Code
  • Company Code
  • Client
  • C_SK_STRPWHLDGTAXITEMQUERY.COMPANYCODE == T001.BUKRS
  • C_SK_STRPWHLDGTAXITEMQUERY.MANDT == T001.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • C_SK_STRPWHLDGTAXITEMQUERY.COUNTRY == T005.LAND1
  • C_SK_STRPWHLDGTAXITEMQUERY.MANDT == T005.MANDT
Supplier
  • Supplier
  • Client
  • C_SK_STRPWHLDGTAXITEMQUERY.CREDITOR == LFA1.LIFNR
  • C_SK_STRPWHLDGTAXITEMQUERY.MANDT == LFA1.MANDT
Customer Number
  • Customer Number
  • Client
  • C_SK_STRPWHLDGTAXITEMQUERY.DEBTOR == KNA1.KUNNR
  • C_SK_STRPWHLDGTAXITEMQUERY.MANDT == KNA1.MANDT
Official Withholding Tax Key
  • Country/Region Key
  • Client
  • Official Withholding Tax Key
  • C_SK_STRPWHLDGTAXITEMQUERY.COUNTRY == T059O.LAND1
  • C_SK_STRPWHLDGTAXITEMQUERY.MANDT == T059O.MANDT
  • C_SK_STRPWHLDGTAXITEMQUERY.OFFICIALWHLDGTAXCODE == T059O.WT_QSCOD
Posting Key
  • Posting Key
  • Client
  • C_SK_STRPWHLDGTAXITEMQUERY.POSTINGKEY == TBSL.BSCHL
  • C_SK_STRPWHLDGTAXITEMQUERY.MANDT == TBSL.MANDT
Special G/L Indicator
  • Special G/L Indicator
  • ?
  • Client
  • C_SK_STRPWHLDGTAXITEMQUERY.SPECIALGLCODE == T074U.UMSKZ
  • C_SK_STRPWHLDGTAXITEMQUERY.[column in domain "KOART"] == T074U.KOART
  • C_SK_STRPWHLDGTAXITEMQUERY.MANDT == T074U.MANDT
Reporting Entity
  • Reporting Entity
  • Client
  • C_SK_STRPWHLDGTAXITEMQUERY.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
  • C_SK_STRPWHLDGTAXITEMQUERY.MANDT == SRF_RPG_ENT.MANDT
Type of Recipient
  • Country/Region Key
  • Type of Recipient
  • Indicator for Withholding Tax Type
  • Client
  • C_SK_STRPWHLDGTAXITEMQUERY.COUNTRY == T059C.LAND1
  • C_SK_STRPWHLDGTAXITEMQUERY.SUPPLIERRECIPIENTTYPE == T059C.QSREC
  • C_SK_STRPWHLDGTAXITEMQUERY.WITHHOLDINGTAXTYPE == T059C.WITHT
  • C_SK_STRPWHLDGTAXITEMQUERY.MANDT == T059C.MANDT
Tax Section
  • Company Code
  • Tax Section
  • Client
  • C_SK_STRPWHLDGTAXITEMQUERY.COMPANYCODE == SECCODE.BUKRS
  • C_SK_STRPWHLDGTAXITEMQUERY.TAXSECTION == SECCODE.SECCODE
  • C_SK_STRPWHLDGTAXITEMQUERY.MANDT == SECCODE.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • C_SK_STRPWHLDGTAXITEMQUERY.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_SK_STRPWHLDGTAXITEMQUERY.MANDT == TCURC.MANDT
Withholding Tax Code
  • Country/Region Key
  • Indicator for Withholding Tax Type
  • Withholding Tax Code
  • Client
  • C_SK_STRPWHLDGTAXITEMQUERY.COUNTRY == T059Z.LAND1
  • C_SK_STRPWHLDGTAXITEMQUERY.WITHHOLDINGTAXTYPE == T059Z.WITHT
  • C_SK_STRPWHLDGTAXITEMQUERY.WITHHOLDINGTAXCODE == T059Z.WT_WITHCD
  • C_SK_STRPWHLDGTAXITEMQUERY.MANDT == T059Z.MANDT
Income Type
  • Country/Region Key
  • Income Type
  • Client
  • C_SK_STRPWHLDGTAXITEMQUERY.COUNTRY == T059E.LAND1
  • C_SK_STRPWHLDGTAXITEMQUERY.WITHHOLDINGTAXINCOMETYPE == T059E.QEKAR
  • C_SK_STRPWHLDGTAXITEMQUERY.MANDT == T059E.MANDT
Indicator for Withholding Tax Type
  • Country/Region Key
  • Indicator for Withholding Tax Type
  • Client
  • C_SK_STRPWHLDGTAXITEMQUERY.COUNTRY == T059P.LAND1
  • C_SK_STRPWHLDGTAXITEMQUERY.WITHHOLDINGTAXTYPE == T059P.WITHT
  • C_SK_STRPWHLDGTAXITEMQUERY.MANDT == T059P.MANDT