C_WhldgTaxCodeVHTemp

DDL: C_WHLDGTAXCODEVHTEMP SQL: CWHLDGTAXCODEVH Type: view CONSUMPTION Package: VDM_MD_BP
5 Fields 1 Data Sources 2 Associations

Withholding Tax Code

C_WhldgTaxCodeVHTemp is a Consumption CDS View that provides data about "Withholding Tax Code" in SAP S/4HANA. It reads from 1 data source (I_Extendedwhldgtaxcode) and exposes 5 fields with key fields WithholdingTaxCode, WithholdingTaxType, WithholdingTaxCountry. It has 2 associations to related views. Part of development package VDM_MD_BP.

Data Sources (1)

SourceAliasJoin Type
I_Extendedwhldgtaxcode I_Extendedwhldgtaxcode from

Associations (2)

CardinalityTargetAliasCondition
[1..*] C_WhldgTaxCodeTextVHTemp _Text $projection.WithholdingTaxCode = _Text.WithholdingTaxCode and $projection.WithholdingTaxType = _Text.WithholdingTaxType and $projection.WithholdingTaxCountry = _Text.CountryCode
[0..1] I_Country _Country $projection.WithholdingTaxCountry = _Country.Country

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CWHLDGTAXCODEVH view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey WithholdingTaxCode view
AccessControl.authorizationCheck #NOT_REQUIRED view
Search.searchable true view
EndUserText.label Withholding Tax Code view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #VALUE_HELP view
Consumption.ranked true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY WithholdingTaxCode WithholdingTaxCode WTax Code
KEY WithholdingTaxType WithholdingTaxType WTax Type
KEY WithholdingTaxCountry Country Venue: Ctry/Reg
_Country _Country
_Text _Text

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 C_WhldgTaxCodeVHTemp.
-- 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: CWHLDGTAXCODEVH

CREATE VIEW C_WhldgTaxCodeVHTemp AS
SELECT
  WithholdingTaxCode,
  WithholdingTaxType,
  Country AS WithholdingTaxCountry
FROM I_Extendedwhldgtaxcode
LEFT OUTER JOIN C_WhldgTaxCodeTextVHTemp AS _Text ON WithholdingTaxCode = _Text.WithholdingTaxCode AND WithholdingTaxType = _Text.WithholdingTaxType AND WithholdingTaxCountry = _Text.CountryCode  -- association [1..*]
LEFT OUTER JOIN I_Country AS _Country ON WithholdingTaxCountry = _Country.Country  -- association [0..1]
;

Learn More