P_PT_STAMPTAXITEMASSIGN

DDL: P_PT_STAMPTAXITEMASSIGN SQL: PPTSTTAXITEMA Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_PT
33 Fields 2 Data Sources

Portugal Stamp Tax Item Selection

P_PT_STAMPTAXITEMASSIGN is a Consumption CDS View that provides data about "Portugal Stamp Tax Item Selection" in SAP S/4HANA. It reads from 2 data sources (I_PT_StampCodeAssign, I_StRpTaxItem) and exposes 33 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, TaxCalculationProcedure. Part of development package GLO_FIN_IS_VAT_PT.

Data Sources (2)

SourceAliasJoin Type
I_PT_StampCodeAssign I_PT_StampCodeAssign inner
I_StRpTaxItem I_StRpTaxItem from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PPTSTTAXITEMA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Portugal Stamp Tax Item Selection view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_StRpTaxItem CompanyCode Receiver Company Code
KEY AccountingDocument I_StRpTaxItem AccountingDocument Journal Entry
KEY FiscalYear I_StRpTaxItem FiscalYear G/L Fiscal Year
KEY TaxItem I_StRpTaxItem TaxItem Tax Item
KEY TaxCalculationProcedure I_PT_StampCodeAssign TaxCalculationProcedure Tax Procedure
KEY TaxCode I_PT_StampCodeAssign TaxCode Tax Code
KEY TransactionTypeDetermination I_PT_StampCodeAssign TransactionTypeDetermination Transaction Key
KEY StampTaxValidityStartDate I_PT_StampCodeAssign StampTaxValidityStartDate Valid from Date
ReportingCurrency I_StRpTaxItem ReportingCurrency Currency
TaxBaseAmountInRptgCrcy I_StRpTaxItem TaxBaseAmountInRptgCrcy Base Amount
TaxAmountInRptgCrcy I_StRpTaxItem TaxAmountInRptgCrcy Tax Rept. Crcy
ReportingCountry I_StRpTaxItem ReportingCountry
TaxRateValidityStartDate I_StRpTaxItem TaxRateValidityStartDate Tax Rate Validity Start Date
AccountingDocumentType I_StRpTaxItem AccountingDocumentType Journal Entry Type
DocumentDate I_StRpTaxItem DocumentDate Journal Entry Date
PostingDate I_StRpTaxItem PostingDate Posting Date for GR
ReportingDate I_StRpTaxItem ReportingDate
Customer I_StRpTaxItem Customer Sold-to Party
Supplier I_StRpTaxItem Supplier Supplier
BusinessPartner I_StRpTaxItem BusinessPartner Issuing Authority
BusinessPartnerCountry I_StRpTaxItem BusinessPartnerCountry BP Ctry/Reg.
CustomerSupplierVATRegn I_StRpTaxItem CustomerSupplierVATRegn
VATRegistrationCountry
VATRegistration
TaxNumber1 I_StRpTaxItem TaxNumber1 VAT Reg. No.
TaxNumber2 I_StRpTaxItem TaxNumber2 Tax Number 2
TaxNumber3 I_StRpTaxItem TaxNumber3
TaxNumber4 I_StRpTaxItem TaxNumber4
StampTaxValidityEndDate I_PT_StampCodeAssign StampTaxValidityEndDate Valid to Date
StampTaxArticle I_PT_StampCodeAssign StampTaxArticle ST Article of Law
StampTaxCode I_PT_StampCodeAssign StampTaxCode Stamp Tax Code
StampTaxRegion I_PT_StampCodeAssign StampTaxRegion Stamp Tax Region
StampTaxExemptionCode I_PT_StampCodeAssign StampTaxExemptionCode Exemption Code

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 P_PT_STAMPTAXITEMASSIGN.
-- 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.
-- SQL view name: PPTSTTAXITEMA

CREATE VIEW P_PT_STAMPTAXITEMASSIGN AS
SELECT
  I_StRpTaxItem.CompanyCode AS CompanyCode,
  I_StRpTaxItem.AccountingDocument AS AccountingDocument,
  I_StRpTaxItem.FiscalYear AS FiscalYear,
  I_StRpTaxItem.TaxItem AS TaxItem,
  I_PT_StampCodeAssign.TaxCalculationProcedure AS TaxCalculationProcedure,
  I_PT_StampCodeAssign.TaxCode AS TaxCode,
  I_PT_StampCodeAssign.TransactionTypeDetermination AS TransactionTypeDetermination,
  I_PT_StampCodeAssign.StampTaxValidityStartDate AS StampTaxValidityStartDate,
  I_StRpTaxItem.ReportingCurrency AS ReportingCurrency,
  I_StRpTaxItem.TaxBaseAmountInRptgCrcy AS TaxBaseAmountInRptgCrcy,
  I_StRpTaxItem.TaxAmountInRptgCrcy AS TaxAmountInRptgCrcy,
  I_StRpTaxItem.ReportingCountry AS ReportingCountry,
  I_StRpTaxItem.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  I_StRpTaxItem.AccountingDocumentType AS AccountingDocumentType,
  I_StRpTaxItem.DocumentDate AS DocumentDate,
  I_StRpTaxItem.PostingDate AS PostingDate,
  I_StRpTaxItem.ReportingDate AS ReportingDate,
  I_StRpTaxItem.Customer AS Customer,
  I_StRpTaxItem.Supplier AS Supplier,
  I_StRpTaxItem.BusinessPartner AS BusinessPartner,
  I_StRpTaxItem.BusinessPartnerCountry AS BusinessPartnerCountry,
  I_StRpTaxItem.CustomerSupplierVATRegn AS CustomerSupplierVATRegn,
  LEFT(I_StRpTaxItem.CustomerSupplierVATRegn, 2) AS VATRegistrationCountry,
  SUBSTRING(I_StRpTaxItem.CustomerSupplierVATRegn , 3, 20 ) AS VATRegistration,
  I_StRpTaxItem.TaxNumber1 AS TaxNumber1,
  I_StRpTaxItem.TaxNumber2 AS TaxNumber2,
  I_StRpTaxItem.TaxNumber3 AS TaxNumber3,
  I_StRpTaxItem.TaxNumber4 AS TaxNumber4,
  I_PT_StampCodeAssign.StampTaxValidityEndDate AS StampTaxValidityEndDate,
  I_PT_StampCodeAssign.StampTaxArticle AS StampTaxArticle,
  I_PT_StampCodeAssign.StampTaxCode AS StampTaxCode,
  I_PT_StampCodeAssign.StampTaxRegion AS StampTaxRegion,
  I_PT_StampCodeAssign.StampTaxExemptionCode AS StampTaxExemptionCode
FROM I_StRpTaxItem
INNER JOIN I_PT_StampCodeAssign ON /* join condition not captured in parsed metadata */
;

Learn More