P_CN_TaxEntity

DDL: P_CN_TAXENTITY Type: view BASIC Package: GLO_FIN_TAX_INVC_MGMT_COMM_CN
9 Fields 2 Data Sources

CN Tax Entity

P_CN_TaxEntity is a Basic CDS View that provides data about "CN Tax Entity" in SAP S/4HANA. It reads from 2 data sources (txi_enty, txi_enty_map) and exposes 9 fields with key field CN_TaxEntityID. Part of development package GLO_FIN_TAX_INVC_MGMT_COMM_CN.

Data Sources (2)

SourceAliasJoin Type
txi_enty enty from
txi_enty_map map left_outer

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PCNTXIENTITY view
AbapCatalog.compiler.compareFilter true view
ObjectModel.representativeKey CN_TaxEntityID view
ObjectModel.usageType.serviceQuality #B view
VDM.viewType #BASIC view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #REQUIRED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CN_TaxEntityID txi_enty cntax_entity_id Tax Entity
CN_TaxParEntityID txi_enty cntax_parent_entity_id Tax Entity
CN_TaxEntityType txi_enty cntax_entity_type Tax Entity Type
CN_TaxRegnNmbr txi_enty tax_reg_nmbr Unfd Socl Crdt Code
CN_TaxEntityValidFrom txi_enty valid_from Validity Start Time
CN_TaxEntityValidTo txi_enty valid_to Validity End Time
CN_DeclnPerdVar txi_enty decln_perd_var Decln Timeline Var.
CompanyCode txi_enty_map company_code Company Code
ProfitCenter txi_enty_map profit_center Profit Center

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 P_CN_TaxEntity.
-- 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 P_CN_TaxEntity AS
SELECT
  enty.cntax_entity_id AS CN_TaxEntityID,
  enty.cntax_parent_entity_id AS CN_TaxParEntityID,
  enty.cntax_entity_type AS CN_TaxEntityType,
  enty.tax_reg_nmbr AS CN_TaxRegnNmbr,
  enty.valid_from AS CN_TaxEntityValidFrom,
  enty.valid_to AS CN_TaxEntityValidTo,
  enty.decln_perd_var AS CN_DeclnPerdVar,
  map.company_code AS CompanyCode,
  map.profit_center AS ProfitCenter
FROM txi_enty AS enty
LEFT OUTER JOIN txi_enty_map AS map ON /* join condition not captured in parsed metadata */
;

Learn More