C_PT_StampTaxItemQuery

Portugal Stamp Tax Item Query | view: CPTSTTAXQUERY | Extraction: Not supported | Component: Financials Portugal
Tables used: VBRK, CFIN_AV_CI_PART, CFIN_AV_SO_PART, BSEC, VBPA3, ACCT_SRF_REP_ITM, ACCT_SRF_RPIT_TI, ACCT_SRF_RPIT_WI, BKPF, BSEG, VBPA, VBPA, ADCP, ADRC, CVI_CUST_CT_LINK, BUT000, CFIN_AV_CI_ROOT, T005, KNA1, CVI_CUST_LINK, T685, T685A, LFA1, CVI_VEND_LINK, T007A, T001, T014, T007B, FIPT_D_ST_ASSIGN
Column Name Description
CompanyCode Company Code
FiscalYear Fiscal Year
AccountingDocument Document Number of an Accounting Document
TaxItem Number of Line Item Within Accounting Document
StampTaxValidityStartDate View Maintenance: Start of Validity
StatryRptCategory FK Report Category ID
StatryRptgEntity FK Reporting Entity
StatryRptRunID Report Run ID
Column Name Description
💲 Reporting Currency (ReportingCurrency):
TaxBaseAmountInRptgCrcy Tax Base Amount in Reporting Currency
TaxAmountInRptgCrcy Tax Amount in Reporting Currency
Column Name Description
Column Name Description
StampTaxValidityStartDate View Maintenance: Start of Validity
DocumentDate Journal Entry Date
PostingDate Posting Date in the Document
ReportingDate Reporting Date
StampTaxValidityEndDate View Maintenance: End of Validity
Column Name Description
StampTaxArticle Article of Law for Stamp Tax Show values
StampTaxRegion Stamp Tax Region Show values
Column Name Description Domain name
ReportingCountry Reporting Country/Region LAND1
AccountingDocumentType Document Type BLART
Customer Customer Number KUNNR
Supplier Supplier LIFNR
BusinessPartner Business Partner Number BU_PARTNER
BusinessPartnerCountry Business Partner Country/Region LAND1
CustomerSupplierVATRegn Partner VAT Registration STCEG
TaxNumber1 Tax Number 1 STCD1
TaxNumber2 Tax Number 2 STCD2
TaxNumber3 Tax Number 3 CHAR18
TaxNumber4 Tax Number 4 CHAR18
DomesticTaxNumber Domestic Tax Number BPTAXNUM
FrgnCountryThreeDigitISOCode Foreign Country/Region 3-Digit Numeric ISO Code NUM03
ForeignTaxNumber Foreign Tax Number BPTAXNUM
Master Data Relations Join Conditions
Stamp Tax Code
  • Stamp Tax Code
  • Client
Exemption Code for Stamp Tax
  • Client
  • Exemption Code for Stamp Tax
Reporting Entity
  • Reporting Entity
  • Client
  • C_PT_STAMPTAXITEMQUERY.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
  • C_PT_STAMPTAXITEMQUERY.MANDT == SRF_RPG_ENT.MANDT
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • Client
  • C_PT_STAMPTAXITEMQUERY.[column in domain "KALSM_D"] == T007A.KALSM
  • C_PT_STAMPTAXITEMQUERY.TAXCODE == T007A.MWSKZ
  • C_PT_STAMPTAXITEMQUERY.MANDT == T007A.MANDT
Account Key for Stamp Tax
  • ?
  • Account Key for Stamp Tax
  • Client
  • C_PT_STAMPTAXITEMQUERY.[column in domain "KAPPL"] == T687.KAPPL
  • C_PT_STAMPTAXITEMQUERY.TRANSACTIONTYPEDETERMINATION == T687.KVSL1
  • C_PT_STAMPTAXITEMQUERY.MANDT == T687.MANDT