What is I_TaxAuthorityValueHelp in SAP S/4HANA?

I_TaxAuthorityValueHelp is a composite CDS view in SAP S/4HANA. Tax Authority It contains 24 fields.

What VDM layer is I_TaxAuthorityValueHelp?

I_TaxAuthorityValueHelp is classified as a Composite view that combines data from multiple basic views.

I_TaxAuthorityValueHelp

Q: Which tables does I_TaxAuthorityValueHelp read from?

I_TaxAuthorityValueHelp reads data from: I_BusinessPartner, I_BusinessPartner_to_BP_Role, I_SupplierCompany, I_SupplierToBusinessPartner.

DDL: I_TAXAUTHORITYVALUEHELP Type: view_entity COMPOSITE

24 Fields 4 Data Sources

Tax Authority

I_TaxAuthorityValueHelp is a Composite CDS View that provides data about "Tax Authority" in SAP S/4HANA. It reads from 4 data sources (I_BusinessPartner, I_BusinessPartner_to_BP_Role, I_SupplierCompany, I_SupplierToBusinessPartner) and exposes 24 fields with key fields BusinessPartner, CompanyCode.

Data Sources (4)

Source	Alias	Join Type
I_BusinessPartner	BusinessPartner	from
I_BusinessPartner_to_BP_Role	BusinessPartnerRole	inner
I_SupplierCompany	SupplierToCompanyCode	inner
I_SupplierToBusinessPartner	SupptoBusinesspartner	inner

Annotations (13)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.dataCategory	#VALUE_HELP	view
ObjectModel.representativeKey	BusinessPartner	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.sizeCategory	#XL	view
Search.searchable	true	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view
VDM.viewType	#COMPOSITE	view
EndUserText.label	Tax Authority	view
Consumption.ranked	true	view

Fields (24)

Key	Field	Source Table	Source Field	Description
KEY	BusinessPartner	I_BusinessPartner_to_BP_Role	BusinessPartner	Issuing Authority
KEY	CompanyCode	I_SupplierCompany	CompanyCode	Receiver Company Code
	BusinessPartnerUUID	I_BusinessPartner	BusinessPartnerUUID	UUID
	Supplier	I_SupplierToBusinessPartner	Supplier	Supplier
	BusinessPartnerName	I_BusinessPartner	BusinessPartnerName	Business Partner Name
	_Supplier	I_SupplierToBusinessPartner	_Supplier
	ValidFrom	I_BusinessPartner_to_BP_Role	ValidFrom	Vers.Valid From
	ValidTo	I_BusinessPartner_to_BP_Role	ValidTo	Vers.Valid To
	_BusinessPartner	I_BusinessPartner_to_BP_Role	_BusinessPartner
	BusinessPartnerRole	I_BusinessPartner_to_BP_Role	BusinessPartnerRole	BP Role
	AuthorizationGroup	I_BusinessPartner	AuthorizationGroup	AuthorizGroup
	IsBusinessPurposeCompleted	I_BusinessPartner	IsBusinessPurposeCompleted	Purpose Completed
	DataControllerSet	I_BusinessPartner	DataControllerSet	Data Ctrlr. Set
	DataController1	I_BusinessPartner	DataController1	Data Controller
	DataController2	I_BusinessPartner	DataController2	Data Controller
	DataController3	I_BusinessPartner	DataController3	Data Controller
	DataController4	I_BusinessPartner	DataController4	Data Controller
	DataController5	I_BusinessPartner	DataController5	Data Controller
	DataController6	I_BusinessPartner	DataController6	Data Controller
	DataController7	I_BusinessPartner	DataController7	Data Controller
	DataController8	I_BusinessPartner	DataController8	Data Controller
	DataController9	I_BusinessPartner	DataController9	Data Controller
	DataController10	I_BusinessPartner	DataController10	Data Controller
	_SupplierCompany		_SupplierCompany

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_TaxAuthorityValueHelp.
-- 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_TaxAuthorityValueHelp AS
SELECT
  BusinessPartnerRole.BusinessPartner AS BusinessPartner,
  SupplierToCompanyCode.CompanyCode AS CompanyCode,
  BusinessPartner.BusinessPartnerUUID AS BusinessPartnerUUID,
  SupptoBusinesspartner.Supplier AS Supplier,
  BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  SupptoBusinesspartner._Supplier AS _Supplier,
  BusinessPartnerRole.ValidFrom AS ValidFrom,
  BusinessPartnerRole.ValidTo AS ValidTo,
  BusinessPartnerRole._BusinessPartner AS _BusinessPartner,
  BusinessPartnerRole.BusinessPartnerRole AS BusinessPartnerRole,
  BusinessPartner.AuthorizationGroup AS AuthorizationGroup,
  BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  BusinessPartner.DataControllerSet AS DataControllerSet,
  BusinessPartner.DataController1 AS DataController1,
  BusinessPartner.DataController2 AS DataController2,
  BusinessPartner.DataController3 AS DataController3,
  BusinessPartner.DataController4 AS DataController4,
  BusinessPartner.DataController5 AS DataController5,
  BusinessPartner.DataController6 AS DataController6,
  BusinessPartner.DataController7 AS DataController7,
  BusinessPartner.DataController8 AS DataController8,
  BusinessPartner.DataController9 AS DataController9,
  BusinessPartner.DataController10 AS DataController10
FROM I_BusinessPartner AS BusinessPartner
INNER JOIN I_BusinessPartner_to_BP_Role AS BusinessPartnerRole ON /* join condition not captured in parsed metadata */
INNER JOIN I_SupplierToBusinessPartner AS SupptoBusinesspartner ON /* join condition not captured in parsed metadata */
INNER JOIN I_SupplierCompany AS SupplierToCompanyCode ON /* join condition not captured in parsed metadata */
;

Depth:

I_TaxAuthorityValueHelp view_entity