I_BusPartTaxNumberGovTP

DDL: I_BUSPARTTAXNUMBERGOVTP Type: view_entity TRANSACTIONAL
13 Fields 1 Data Sources 1 Associations

BP Tax Number Governance TP

I_BusPartTaxNumberGovTP is a Transactional CDS View that provides data about "BP Tax Number Governance TP" in SAP S/4HANA. It reads from 1 data source (I_BusPartTaxNumberGov) and exposes 13 fields with key fields BusinessPartnerUUID, BPTaxNumberUUID, MasterDataChangeProcess, MDChgProcessSrceSystem, MDChgProcessSrceObject. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_BusPartTaxNumberGov _BusinessPartnerTaxNumber from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_BusPartTaxType _BusinessPartnerTaxType $projection.BPTaxType = _BusinessPartnerTaxType.BPTaxType

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label BP Tax Number Governance TP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Search.searchable true view
VDM.viewType #TRANSACTIONAL view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerUUID
KEY BPTaxNumberUUID
KEY MasterDataChangeProcess MasterDataChangeProcess Process ID
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject MDChgProcessSrceObject Source ID
KEY BPTaxType BPTaxType Category
BusinessPartner BusinessPartner Issuing Authority
MDChgProcessStep MDChgProcessStep Step Number
BPTaxTypeForEdit BPTaxType Category
BPTaxNumber BPTaxNumber Tax Number
BPTaxLongNumber BPTaxLongNumber Tax Number Long
_BusinessPartnerGov _BusinessPartnerGov
_BusinessPartnerTaxType _BusinessPartnerTaxType

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_BusPartTaxNumberGovTP.
-- 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_BusPartTaxNumberGovTP AS
SELECT
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) AS BusinessPartnerUUID,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) AS BPTaxNumberUUID,
  MasterDataChangeProcess,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  BPTaxType,
  BusinessPartner,
  MDChgProcessStep,
  BPTaxType AS BPTaxTypeForEdit,
  BPTaxNumber,
  BPTaxLongNumber
FROM I_BusPartTaxNumberGov AS _BusinessPartnerTaxNumber
LEFT OUTER JOIN I_BusPartTaxType AS _BusinessPartnerTaxType ON BPTaxType = _BusinessPartnerTaxType.BPTaxType  -- association [0..1]
;

Learn More