I_BG_SAFTWhgdTaxMapping

DDL: I_BG_SAFTWHGDTAXMAPPING Type: view_entity BASIC Package: GLO_FIN_IS_SAFT_BG
13 Fields 1 Data Sources

SAFT BG Mapping Withholding Tax Type

I_BG_SAFTWhgdTaxMapping is a Basic CDS View that provides data about "SAFT BG Mapping Withholding Tax Type" in SAP S/4HANA. It reads from 1 data source (bgsaft_whtmap) and exposes 13 fields with key fields CompanyCode, WithholdingTaxType, TargetTaxCode, ExpirationDate, GLAccount. Part of development package GLO_FIN_IS_SAFT_BG.

Data Sources (1)

SourceAliasJoin Type
bgsaft_whtmap WitholdingTaxMap from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label SAFT BG Mapping Withholding Tax Type view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode bgsaft_whtmap bukrs Value
KEY WithholdingTaxType bgsaft_whtmap witht WTax Type
KEY TargetTaxCode bgsaft_whtmap withcd WTax Code
KEY ExpirationDate bgsaft_whtmap endda Valid To
KEY GLAccount bgsaft_whtmap hkont Transfer acct
KEY BG_SAFTTaxType bgsaft_whtmap tax_type Tax Type
KEY BG_SAFTTaxCode bgsaft_whtmap tax_code Tax Code
TaxRateValidityStartDate bgsaft_whtmap begda Valid From
TaxRateValidityEndDate bgsaft_whtmap endda Valid To
EffectiveDate bgsaft_whtmap begda Valid From
TaxRateInPercent bgsaft_whtmap tax_percentage Tax Rate Code
TaxRate
Country

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_BG_SAFTWhgdTaxMapping.
-- 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.

CREATE VIEW I_BG_SAFTWhgdTaxMapping AS
SELECT
  WitholdingTaxMap.bukrs AS CompanyCode,
  WitholdingTaxMap.witht AS WithholdingTaxType,
  WitholdingTaxMap.withcd AS TargetTaxCode,
  WitholdingTaxMap.endda AS ExpirationDate,
  WitholdingTaxMap.hkont AS GLAccount,
  WitholdingTaxMap.tax_type AS BG_SAFTTaxType,
  WitholdingTaxMap.tax_code AS BG_SAFTTaxCode,
  WitholdingTaxMap.begda AS TaxRateValidityStartDate,
  WitholdingTaxMap.endda AS TaxRateValidityEndDate,
  WitholdingTaxMap.begda AS EffectiveDate,
  WitholdingTaxMap.tax_percentage AS TaxRateInPercent,
  FLTP_TO_DEC(1.0000 as bgsaft_base_rate) AS TaxRate,
  cast('BG' as land1) AS Country
FROM bgsaft_whtmap AS WitholdingTaxMap
;

Learn More