C_CN_TaxCompanyCode

DDL: C_CN_TAXCOMPANYCODE SQL: CCNTXICOCODE Type: view CONSUMPTION Package: GLO_FIN_TAX_INVC_MGMT_COMM_CN
30 Fields 2 Data Sources 3 OData Services

China Tax Company Code

C_CN_TaxCompanyCode is a Consumption CDS View (Dimension) that provides data about "China Tax Company Code" in SAP S/4HANA. It reads from 2 data sources (I_CompanyCode, I_CN_TaxCompanyConfign) and exposes 30 fields with key field CompanyCode. It is exposed through 3 OData services (ASQL_F0859, ASQL_F6852, ASQL_F7900). Part of development package GLO_FIN_TAX_INVC_MGMT_COMM_CN.

Data Sources (2)

SourceAliasJoin Type
I_CompanyCode cocode from
I_CN_TaxCompanyConfign config inner

Annotations (17)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CCNTXICOCODE view
AbapCatalog.compiler.compareFilter true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey CompanyCode view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private false view
EndUserText.label China Tax Company Code view
Search.searchable true view
Consumption.ranked true view
Analytics.dataCategory #DIMENSION view
Metadata.allowExtensions true view

OData Services (3)

ServiceBindingVersionContractRelease
ASQL_F0859 ASQL_F0859 C2 NOT_RELEASED
ASQL_F6852 ASQL_F6852 C2 NOT_RELEASED
ASQL_F7900 ASQL_F7900 C2 NOT_RELEASED

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CompanyCode CompanyCode Receiver Company Code
CompanyCodeName I_CompanyCode CompanyCodeName Company Name
CityName I_CompanyCode CityName Name
Country I_CompanyCode Country Venue: Ctry/Reg
Currency I_CompanyCode Currency Valuation Crcy
Language I_CompanyCode Language Report Text Language
ChartOfAccounts I_CompanyCode ChartOfAccounts Node Class
FiscalYearVariant I_CompanyCode FiscalYearVariant FY Variant
Company I_CompanyCode Company Owner
CreditControlArea I_CompanyCode CreditControlArea Credit Control Area
CountryChartOfAccounts I_CompanyCode CountryChartOfAccounts Chart of Accts
FinancialManagementArea I_CompanyCode FinancialManagementArea FM Area
AddressID I_CompanyCode AddressID Ship-to address
TaxableEntity I_CompanyCode TaxableEntity Tax Group
VATRegistration I_CompanyCode VATRegistration VAT Registration No.
ExtendedWhldgTaxIsActive I_CompanyCode ExtendedWhldgTaxIsActive Extended WTax Active
ControllingArea I_CompanyCode ControllingArea Controlling Area
FieldStatusVariant I_CompanyCode FieldStatusVariant Fld stat.var.
_Address I_CompanyCode _Address
_ChartOfAccounts I_CompanyCode _ChartOfAccounts
_ControllingArea I_CompanyCode _ControllingArea
_Country I_CompanyCode _Country
_CountryChartOfAccounts I_CompanyCode _CountryChartOfAccounts
_CreditControlArea I_CompanyCode _CreditControlArea
_Currency I_CompanyCode _Currency
_FieldStatusVariant I_CompanyCode _FieldStatusVariant
_FiscalYearVariant I_CompanyCode _FiscalYearVariant
_GlobalCompany I_CompanyCode _GlobalCompany
_Language I_CompanyCode _Language
IsProcessable I_CN_TaxCompanyConfign IsProcessable Processable

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_CN_TaxCompanyCode.
-- 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: CCNTXICOCODE

CREATE VIEW C_CN_TaxCompanyCode AS
SELECT
  cocode.CompanyCode AS CompanyCode,
  cocode.CompanyCodeName AS CompanyCodeName,
  cocode.CityName AS CityName,
  cocode.Country AS Country,
  cocode.Currency AS Currency,
  cocode.Language AS Language,
  cocode.ChartOfAccounts AS ChartOfAccounts,
  cocode.FiscalYearVariant AS FiscalYearVariant,
  cocode.Company AS Company,
  cocode.CreditControlArea AS CreditControlArea,
  cocode.CountryChartOfAccounts AS CountryChartOfAccounts,
  cocode.FinancialManagementArea AS FinancialManagementArea,
  cocode.AddressID AS AddressID,
  cocode.TaxableEntity AS TaxableEntity,
  cocode.VATRegistration AS VATRegistration,
  cocode.ExtendedWhldgTaxIsActive AS ExtendedWhldgTaxIsActive,
  cocode.ControllingArea AS ControllingArea,
  cocode.FieldStatusVariant AS FieldStatusVariant,
  cocode._Address AS _Address,
  cocode._ChartOfAccounts AS _ChartOfAccounts,
  cocode._ControllingArea AS _ControllingArea,
  cocode._Country AS _Country,
  cocode._CountryChartOfAccounts AS _CountryChartOfAccounts,
  cocode._CreditControlArea AS _CreditControlArea,
  cocode._Currency AS _Currency,
  cocode._FieldStatusVariant AS _FieldStatusVariant,
  cocode._FiscalYearVariant AS _FiscalYearVariant,
  cocode._GlobalCompany AS _GlobalCompany,
  cocode._Language AS _Language,
  config.IsProcessable AS IsProcessable
FROM I_CompanyCode AS cocode
INNER JOIN I_CN_TaxCompanyConfign AS config ON /* join condition not captured in parsed metadata */
;

Learn More