I_CN_TaxInvoiceHeader

DDL: I_CN_TAXINVOICEHEADER Type: view_entity COMPOSITE Package: GLO_FIN_TAX_INVC_MGMT_COMM_CN

China Tax Invoice Header

I_CN_TaxInvoiceHeader (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Country or Region-Specific Functions for Finance

I_CN_TaxInvoiceHeader is a Composite CDS View that provides data about "China Tax Invoice Header" in SAP S/4HANA. It reads from 1 data source (I_CN_TaxInputInvc) and exposes 50 fields with key field CN_TaxInvcUUID. It has 2 associations to related views. Part of development package GLO_FIN_TAX_INVC_MGMT_COMM_CN.

SAP Help Documentation

CategoryTax
Purpose
This CDS view is designed to provide a comprehensive overview of tax invoice headers specific to China. It aggregates and presents key information related to tax invoices, including details about the invoice type, supplier, amounts, and other relevant attributes. The view is structured to facilitate the retrieval and analysis of transactional data associated with Chinese tax invoices. This CDS view provides the data to answer the following business questions: What are the details of tax invoices issued in China, including invoice numbers, dates, and types? Who are the suppliers associated with these tax invoices, and what are their registration numbers? What are the net and tax amounts in the invoice currency for each tax invoice? What is the status of each tax invoice in terms of system processing and deduction type? How are tax invoices categorized, and what are their usage and data sources? What are the details related to vehicle invoices, such as vehicle type, factory model, and production place? What are the purchasing organization and group associated with each tax invoice? Are there any specific comments or notes attached to the tax invoices? What are the buyer and seller details, including addresses, phone numbers, and bank accounts? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: TXI_TE (Authorization Group for China VAT Business Place) EKGRP (Purchasing Group) You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included.

Structure
Important Fields Important fields in this view include the following: Field Name Description CN_TAXINVOICEVEHICLECERTNUMBER Vehicle Certificate Number CN_TAXINVOICEVEHIMPORTCERTNMBR Important Certificate Number CN_TAXINVOICEVEHICLENUMBER Vehicle Number CN_TAXINVOICEVEHICLEENGINENMBR Vehicle Engine Number CN_TAXINVOICEVEHTXNRECORDNMBR Vehicle Taxation Number CN_TAXINVOICEVEHICLETONNAGE Vehicle Tonnage CN_TAXINVOICEVEHPASSENGERLIMIT Vehicle Passenger Limit COMPANYCODE Company Code CN_TAXINVCTYPE VAT Invoice Type CN_TAXINVCINPTPROCGSTS Processing Status CN_TAXINVOICEUSAGE Usage ISPOSTEDONACCOUNT Invoice Posted CN_TAXINVCDATE VAT Invoice Date CN_TAXINVCCRCY Currency CN_TAXDECLNYEAR Year CN_TAXDECLNMONTH Month TAXRATE VAT Tax Rate SUPPLIER Supplier CN_TAXINVCNETAMTININVCCRCY Net Amount CN_TAXINVCTAXAMTININVCCRCY Tax Amount CN_TAXINVCDEDUCTAMTININVCCRCY Deductible Tax Amount CN_TAXINVCDISCNETAMTININVCCRCY Net Amount CN_TAXINVCDISCTAXAMTININVCCRCY Tax Amount CN_TAXINVCVEHTOTAMTININVCCRCY Vehicle Total Amount CREATEDBYUSER Created By PURCHASINGORGANIZATION Purchasing Organization PURCHASINGGROUP Purchasing Group CN_TAXINVCNMBR VAT Invoice Number CN_TAXINVCUUID Invoice UUID CN_TAXINVCCODE VAT Invoice Code CN_TAXSELLERREGNNMBR Seller Social Code CN_TAXSELLERNAME Seller Name CN_TAXENTITYID Tax Entity CN_TAXBUYERREGNNMBR Buyer Social Code CN_TAXINVCGLDNTXSYSTSTS GT Status CN_TAXINVCDEDUCTIONTYPE Deduction Type CN_TAXINVCCOMMENT Comment CN_TAXINVOICEDATASOURCE Data Source CN_TAXINVOICEEXPENSEREPORTNMBR Expense Report Number TAXCATEGORY Input VAT Category TAXINVOICEBUYERADDRESSPHONE Buyer Address Phone TAXINVOICEBUYERBANKACCOUNT Buyer Bank Account TAXINVOICESELLERBANKACCOUNT Seller Bank Account TAXINVOICESELLERADDRESSPHONE Seller Address Phone CN_TAXINVOICEVEHICLETYPE Vehicle Type CN_TAXINVOICEVEHFACTORYMODEL Vehicle Factory Model CN_TAXINVOICEVEHICLEPRODNPLACE Vehicle Production Place CN_TAXINVOICEVEHICLEINS

View on SAP Help Portal →

SAP API Hub

CategoryComposite
StateC1
Line of BusinessCountry or Region-Specific Functions for Finance
Application ComponentFI-LOC-TIM-CN
CapabilitiesData Source in SQL Select,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageCountry/Region-Specific Functions for Finance for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view is designed to provide a comprehensive overview of tax invoice headers specific to China. It aggregates and presents key information related to tax invoices, including details about the invoice type, supplier, amounts, and other relevant attributes. The view is structured to facilitate the retrieval and analysis of transactional data associated with Chinese tax invoices.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What are the details of tax invoices issued in China, including invoice numbers, dates, and types?</p></li> <li><p>Who are the suppliers associated with these tax invoices, and what are their registration numbers?</p></li> <li><p>What are the net and tax amounts in the invoice currency for each tax invoice?</p></li> <li><p>What is the status of each tax invoice in terms of system processing and deduction type?</p></li> <li><p>How are tax invoices categorized, and what are their usage and data sources?</p></li> <li><p>What are the details related to vehicle invoices, such as vehicle type, factory model, and production place?</p></li> <li><p>What are the purchasing organization and group associated with each tax invoice?</p></li> <li><p>Are there any specific comments or notes attached to the tax invoices?</p></li> <li><p>What are the buyer and seller details, including addresses, phone numbers, and bank accounts?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_CN_TaxInputInvc hdr from

Associations (2)

CardinalityTargetAliasCondition
[1] I_CN_TaxInvcType _InvoiceType $projection.CN_TaxInvcType = _InvoiceType.CN_TaxInvcType
[0..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label China Tax Invoice Header view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY CN_TaxInvcUUID I_CN_TaxInputInvc CN_TaxInvcUUID China Tax Invoice UUID
CN_TaxInvcCode I_CN_TaxInputInvc CN_TaxInvcCode China Tax Invoice Code
CN_TaxInvcNmbr I_CN_TaxInputInvc CN_TaxInvcNmbr China Tax Invoice Number
CN_TaxInvcType China Tax Invoice Type
CN_TaxInvcDate I_CN_TaxInputInvc CN_TaxInvcDate China Tax Invoice Date
CN_TaxSellerRegnNmbr I_CN_TaxInputInvc CN_TaxSellerRegnNmbr China Seller Unified Social Credit Code
CN_TaxSellerName I_CN_TaxInputInvc CN_TaxSellerName China Tax Invoice Seller Name
CN_TaxInvcCrcy I_CN_TaxInputInvc CN_TaxInvcCrcy Currency Key
CN_TaxInvcNetAmtInInvcCrcy I_CN_TaxInputInvc CN_TaxInvcNetAmtInInvcCrcy China Tax Invoice Net Amount in Invoice Currency
CN_TaxInvcTaxAmtInInvcCrcy I_CN_TaxInputInvc CN_TaxInvcTaxAmtInInvcCrcy China Tax Invoice Tax Amount in Invoice Currency
CreatedByUser I_CN_TaxInputInvc CreatedByUser China Tax Invoice Administration Data Creation User
CompanyCode Company Code
Supplier Supplier's Account Number
CN_TaxEntityID I_CN_TaxInputInvc CN_TaxEntityID China Tax Invoice Tax Entity ID
CN_TaxBuyerRegnNmbr I_CN_TaxInputInvc CN_TaxBuyerRegnNmbr China Buyer Unified Social Credit Code
CN_TaxInvcDeductAmtInInvcCrcy I_CN_TaxInputInvc CN_TaxInvcDeductAmtInInvcCrcy China Tax Invoice Deductive Tax Amount in Invoice Currency
CN_TaxInvcDiscNetAmtInInvcCrcy I_CN_TaxInputInvc CN_TaxInvcDiscNetAmtInInvcCrcy China Tax Invoice Net Amount in Invoice Currency
CN_TaxInvcDiscTaxAmtInInvcCrcy I_CN_TaxInputInvc CN_TaxInvcDiscTaxAmtInInvcCrcy China Tax Invoice Tax Amount in Invoice Currency
TaxRate I_CN_TaxInputInvc TaxRate VAT Tax Rate
CN_TaxInvcGldnTxSystSts I_CN_TaxInputInvc CN_TaxInvcGldnTxSystSts China Tax Invoice Status in Golden Tax System
CN_TaxInvcInptProcgSts I_CN_TaxInputInvc CN_TaxInvcInptProcgSts China Tax Invoice Incoming Invoice Processing Status
CN_TaxInvcDeductionType China Tax Invoice Deduction Type
CN_TaxInvcComment I_CN_TaxInputInvc CN_TaxInvcComment China Tax Invoice Comment
CN_TaxInvoiceUsage I_CN_TaxInputInvc CN_TaxInvoiceUsage China Tax Invoice Usage
CN_TaxInvoiceDataSource I_CN_TaxInputInvc CN_TaxInvoiceDataSource China Tax Invoice Data Source
CN_TaxInvoiceExpenseReportNmbr I_CN_TaxInputInvc CN_TaxInvoiceExpenseReportNmbr China Tax Invoice Expense Report Number
IsPostedOnAccount I_CN_TaxInputInvc IsPostedOnAccount China Tax Invoice Posted Indicator
TaxCategory China Tax Input VAT Category
CN_TaxDeclnYear I_CN_TaxInputInvc CN_TaxDeclnYear China Tax Declaration Year
CN_TaxDeclnMonth I_CN_TaxInputInvc CN_TaxDeclnMonth China Tax Declaration Month
TaxInvoiceBuyerAddressPhone I_CN_TaxInputInvc TaxInvoiceBuyerAddressPhone China Tax Invoice Buyer Address, Phone
TaxInvoiceBuyerBankAccount I_CN_TaxInputInvc TaxInvoiceBuyerBankAccount China Tax Invoice Buyer Bank Account Info
TaxInvoiceSellerAddressPhone I_CN_TaxInputInvc TaxInvoiceSellerAddressPhone China Tax Invoice Seller Address, Phone
TaxInvoiceSellerBankAccount I_CN_TaxInputInvc TaxInvoiceSellerBankAccount China Tax Invoice Seller Bank Account Info
CN_TaxInvoiceVehicleType I_CN_TaxInputInvc CN_TaxInvoiceVehicleType China Tax Invoice Vehicle Type
CN_TaxInvoiceVehFactoryModel I_CN_TaxInputInvc CN_TaxInvoiceVehFactoryModel Tax Invoice Vehicle Factory Model
CN_TaxInvoiceVehicleProdnPlace I_CN_TaxInputInvc CN_TaxInvoiceVehicleProdnPlace China Tax Invoice Vehicle Place of Production
CN_TaxInvoiceVehicleCertNumber I_CN_TaxInputInvc CN_TaxInvoiceVehicleCertNumber China Tax Invoice Vehicle Certification Number
CN_TaxInvoiceVehImportCertNmbr I_CN_TaxInputInvc CN_TaxInvoiceVehImportCertNmbr China Tax Invoice Vehicle Import Certification Number
CN_TaxInvoiceVehicleInspNumber I_CN_TaxInputInvc CN_TaxInvoiceVehicleInspNumber China Tax Invoice Vehicle Inspection Number
CN_TaxInvoiceVehicleEngineNmbr I_CN_TaxInputInvc CN_TaxInvoiceVehicleEngineNmbr China Tax Invoice Vehicle Engine Number
CN_TaxInvoiceVehicleNumber I_CN_TaxInputInvc CN_TaxInvoiceVehicleNumber China Tax Invoice Vehicle Number
CN_TaxInvcVehTotAmtInInvcCrcy I_CN_TaxInputInvc CN_TaxInvcVehTotAmtInInvcCrcy China Tax Invoice Vehicle Total Amount
CN_TaxInvoiceVehTxnRecordNmbr I_CN_TaxInputInvc CN_TaxInvoiceVehTxnRecordNmbr China Tax Invoice Vehicle Taxation Record Number
CN_TaxInvoiceVehicleTonnage I_CN_TaxInputInvc CN_TaxInvoiceVehicleTonnage China Tax Invoice Vehicle Tonnage
CN_TaxInvoiceVehPassengerLimit I_CN_TaxInputInvc CN_TaxInvoiceVehPassengerLimit China Tax Invoice Vehicle Limitation on Passengers
PurchasingOrganization Purchasing Organization
PurchasingGroup Purchasing Group
_InvoiceType _InvoiceType
_Supplier _Supplier

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_TaxInvoiceHeader.
-- 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_CN_TaxInvoiceHeader AS
SELECT
  hdr.CN_TaxInvcUUID AS CN_TaxInvcUUID,
  hdr.CN_TaxInvcCode AS CN_TaxInvcCode,
  hdr.CN_TaxInvcNmbr AS CN_TaxInvcNmbr,
  cast( hdr.CN_TaxInvcType as ficntaxinvc_type preserving type) AS CN_TaxInvcType,
  hdr.CN_TaxInvcDate AS CN_TaxInvcDate,
  hdr.CN_TaxSellerRegnNmbr AS CN_TaxSellerRegnNmbr,
  hdr.CN_TaxSellerName AS CN_TaxSellerName,
  hdr.CN_TaxInvcCrcy AS CN_TaxInvcCrcy,
  hdr.CN_TaxInvcNetAmtInInvcCrcy AS CN_TaxInvcNetAmtInInvcCrcy,
  hdr.CN_TaxInvcTaxAmtInInvcCrcy AS CN_TaxInvcTaxAmtInInvcCrcy,
  hdr.CreatedByUser AS CreatedByUser,
  cast( hdr.CompanyCode as fis_bukrs preserving type) AS CompanyCode,
  cast( hdr.Supplier as elifn preserving type) AS Supplier,
  hdr.CN_TaxEntityID AS CN_TaxEntityID,
  hdr.CN_TaxBuyerRegnNmbr AS CN_TaxBuyerRegnNmbr,
  hdr.CN_TaxInvcDeductAmtInInvcCrcy AS CN_TaxInvcDeductAmtInInvcCrcy,
  hdr.CN_TaxInvcDiscNetAmtInInvcCrcy AS CN_TaxInvcDiscNetAmtInInvcCrcy,
  hdr.CN_TaxInvcDiscTaxAmtInInvcCrcy AS CN_TaxInvcDiscTaxAmtInInvcCrcy,
  hdr.TaxRate AS TaxRate,
  hdr.CN_TaxInvcGldnTxSystSts AS CN_TaxInvcGldnTxSystSts,
  hdr.CN_TaxInvcInptProcgSts AS CN_TaxInvcInptProcgSts,
  cast( hdr.CN_TaxInvcDeductionType as ficntaxinvc_deduct_type preserving type) AS CN_TaxInvcDeductionType,
  hdr.CN_TaxInvcComment AS CN_TaxInvcComment,
  hdr.CN_TaxInvoiceUsage AS CN_TaxInvoiceUsage,
  hdr.CN_TaxInvoiceDataSource AS CN_TaxInvoiceDataSource,
  hdr.CN_TaxInvoiceExpenseReportNmbr AS CN_TaxInvoiceExpenseReportNmbr,
  hdr.IsPostedOnAccount AS IsPostedOnAccount,
  cast( hdr.TaxCategory as ficntax_input_vat_cat preserving type) AS TaxCategory,
  hdr.CN_TaxDeclnYear AS CN_TaxDeclnYear,
  hdr.CN_TaxDeclnMonth AS CN_TaxDeclnMonth,
  hdr.TaxInvoiceBuyerAddressPhone AS TaxInvoiceBuyerAddressPhone,
  hdr.TaxInvoiceBuyerBankAccount AS TaxInvoiceBuyerBankAccount,
  hdr.TaxInvoiceSellerAddressPhone AS TaxInvoiceSellerAddressPhone,
  hdr.TaxInvoiceSellerBankAccount AS TaxInvoiceSellerBankAccount,
  hdr.CN_TaxInvoiceVehicleType AS CN_TaxInvoiceVehicleType,
  hdr.CN_TaxInvoiceVehFactoryModel AS CN_TaxInvoiceVehFactoryModel,
  hdr.CN_TaxInvoiceVehicleProdnPlace AS CN_TaxInvoiceVehicleProdnPlace,
  hdr.CN_TaxInvoiceVehicleCertNumber AS CN_TaxInvoiceVehicleCertNumber,
  hdr.CN_TaxInvoiceVehImportCertNmbr AS CN_TaxInvoiceVehImportCertNmbr,
  hdr.CN_TaxInvoiceVehicleInspNumber AS CN_TaxInvoiceVehicleInspNumber,
  hdr.CN_TaxInvoiceVehicleEngineNmbr AS CN_TaxInvoiceVehicleEngineNmbr,
  hdr.CN_TaxInvoiceVehicleNumber AS CN_TaxInvoiceVehicleNumber,
  hdr.CN_TaxInvcVehTotAmtInInvcCrcy AS CN_TaxInvcVehTotAmtInInvcCrcy,
  hdr.CN_TaxInvoiceVehTxnRecordNmbr AS CN_TaxInvoiceVehTxnRecordNmbr,
  hdr.CN_TaxInvoiceVehicleTonnage AS CN_TaxInvoiceVehicleTonnage,
  hdr.CN_TaxInvoiceVehPassengerLimit AS CN_TaxInvoiceVehPassengerLimit,
  cast( hdr.PurchasingOrganization as ekorg preserving type) AS PurchasingOrganization,
  cast( hdr.PurchasingGroup as ekgrp preserving type) AS PurchasingGroup
FROM I_CN_TaxInputInvc AS hdr
LEFT OUTER JOIN I_CN_TaxInvcType AS _InvoiceType ON CN_TaxInvcType = _InvoiceType.CN_TaxInvcType  -- association [1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
;