I_CN_InputVATDeclnCompanyCode

DDL: I_CN_INPUTVATDECLNCOMPANYCODE SQL: ICNDECLNCOCODE Type: view BASIC
5 Fields 1 Data Sources

China Input VAT Declaration Company Code

I_CN_InputVATDeclnCompanyCode is a Basic CDS View that provides data about "China Input VAT Declaration Company Code" in SAP S/4HANA. It reads from 1 data source (I_CompanyCode) and exposes 5 fields with key field CompanyCode.

Data Sources (1)

SourceAliasJoin Type
I_CompanyCode I_CompanyCode left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICNDECLNCOCODE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
VDM.private false view
EndUserText.label China Input VAT Declaration Company Code view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode cnf company_code Company Code
CompanyCodeName I_CompanyCode CompanyCodeName Company Name
CityName I_CompanyCode CityName Name
CompanyCodeCurrency I_CompanyCode Currency Valuation Crcy
LanguageCode I_CompanyCode Language Report Text Language

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_CN_InputVATDeclnCompanyCode.
-- 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: ICNDECLNCOCODE

CREATE VIEW I_CN_InputVATDeclnCompanyCode AS
SELECT
  cnf.company_code AS CompanyCode,
  I_CompanyCode.CompanyCodeName AS CompanyCodeName,
  I_CompanyCode.CityName AS CityName,
  I_CompanyCode.Currency AS CompanyCodeCurrency,
  I_CompanyCode.Language AS LanguageCode
LEFT OUTER JOIN I_CompanyCode ON /* join condition not captured in parsed metadata */
;

Learn More