I_PT_SAFTTaxNotConfigured

DDL: I_PT_SAFTTAXNOTCONFIGURED SQL: IPTSAFTAXNS Type: view BASIC Package: GLO_FIN_IS_SAFT_PT

SAF-T PT get tax NS

I_PT_SAFTTaxNotConfigured is a Basic CDS View that provides data about "SAF-T PT get tax NS" in SAP S/4HANA. It reads from 3 data sources (t005, saft_ptc_tax, saft_pti_taxecod) and exposes 11 fields with key fields TaxCalculationProcedure, TaxCode, EndDate. Part of development package GLO_FIN_IS_SAFT_PT.

Data Sources (3)

SourceAliasJoin Type
t005 country inner
saft_ptc_tax tax from
saft_pti_taxecod taxcod left_outer

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPTSAFTAXNS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #D view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label SAF-T PT get tax NS view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY TaxCalculationProcedure saft_ptc_tax kalsm Search Proced.
KEY TaxCode saft_ptc_tax mwskz Tax Code
KEY EndDate saft_ptc_tax endda Valid To
StartDate saft_ptc_tax begda Valid From
TaxCodeDescription saft_ptc_tax tax_descr Tax Type Description
TaxReturnCountry saft_ptc_tax country_region Tx. Ctry/Reg.
TaxType saft_ptc_tax tax_type Tax Type
TargetTaxCode saft_ptc_tax tax_code Tax Code
TaxAmount saft_ptc_tax tax_amount VAT Amount Type
ExemptionReason saft_ptc_tax tax_exempt_code Tax Exemption Reason
ExemptionReasonText saft_pti_taxecod text User Group

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 I_PT_SAFTTaxNotConfigured.
-- 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: IPTSAFTAXNS

CREATE VIEW I_PT_SAFTTaxNotConfigured AS
SELECT
  tax.kalsm AS TaxCalculationProcedure,
  tax.mwskz AS TaxCode,
  tax.endda AS EndDate,
  tax.begda AS StartDate,
  tax.tax_descr AS TaxCodeDescription,
  tax.country_region AS TaxReturnCountry,
  tax.tax_type AS TaxType,
  tax.tax_code AS TargetTaxCode,
  tax.tax_amount AS TaxAmount,
  tax.tax_exempt_code AS ExemptionReason,
  taxcod.text AS ExemptionReasonText
FROM saft_ptc_tax AS tax
INNER JOIN t005 AS country ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN saft_pti_taxecod AS taxcod ON /* join condition not captured in parsed metadata */
;