A_CN_TaxInputInvoice
China Input Tax Invoice
A_CN_TaxInputInvoice is a Basic CDS View that provides data about "China Input Tax Invoice" in SAP S/4HANA. It reads from 1 data source (I_CN_TaxInputInvc) and exposes 52 fields with key field CN_TaxInvcUUID. It has 5 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_CN_TaxInputInvc | hdr | from |
Associations (5)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..*] | A_CN_TaxInputInvoiceItem | _Item | $projection.CN_TaxInvcUUID = _Item.CN_TaxInvcUUID |
| [1..*] | A_CN_TaxInvoiceBindingRecord | _Binding | $projection.CN_TaxInvcUUID = _Binding.CN_TaxInvcUUID |
| [1..1] | A_Supplier | _Supplier | $projection.Supplier = _Supplier.Supplier |
| [1..1] | E_CN_TaxInputInvc | _CommonExtension | $projection.CN_TaxInvcUUID = _CommonExtension.CN_TaxInvcUUID |
| [1..1] | E_CN_TaxInputInvcMng | _ManageExtension | $projection.CN_TaxInvcUUID = _ManageExtension.CN_TaxInvcUUID |
Annotations (17)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | ACNTXIIPT | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| VDM.viewType | #BASIC | view | |
| VDM.lifecycle.contract.type | #PUBLIC_REMOTE_API | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_EXCLUDED | view | |
| ObjectModel.createEnabled | true | view | |
| ObjectModel.updateEnabled | false | view | |
| ObjectModel.deleteEnabled | false | view | |
| ObjectModel.compositionRoot | true | view | |
| ObjectModel.usageType.serviceQuality | #B | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| EndUserText.label | China Input Tax Invoice | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (52)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CN_TaxInvcUUID | I_CN_TaxInputInvc | CN_TaxInvcUUID | |
| CN_TaxInvcCode | I_CN_TaxInputInvc | CN_TaxInvcCode | ||
| CN_TaxInvcNmbr | I_CN_TaxInputInvc | CN_TaxInvcNmbr | ||
| CN_TaxSellerRegnNmbr | I_CN_TaxInputInvc | CN_TaxSellerRegnNmbr | ||
| CN_TaxBuyerRegnNmbr | I_CN_TaxInputInvc | CN_TaxBuyerRegnNmbr | ||
| CN_TaxInvcType | I_CN_TaxInputInvc | CN_TaxInvcType | ||
| CN_TaxInvcDate | I_CN_TaxInputInvc | CN_TaxInvcDate | ||
| CN_TaxInvcCrcy | I_CN_TaxInputInvc | CN_TaxInvcCrcy | ||
| CN_TaxInvcNetAmtInInvcCrcy | I_CN_TaxInputInvc | CN_TaxInvcNetAmtInInvcCrcy | ||
| CN_TaxInvcTaxAmtInInvcCrcy | I_CN_TaxInputInvc | CN_TaxInvcTaxAmtInInvcCrcy | ||
| CN_TaxInvcDeductAmtInInvcCrcy | I_CN_TaxInputInvc | CN_TaxInvcDeductAmtInInvcCrcy | ||
| BusinessPlace | I_CN_TaxInputInvc | CN_TaxEntityID | ||
| CN_TaxInvcDiscNetAmtInInvcCrcy | I_CN_TaxInputInvc | CN_TaxInvcDiscNetAmtInInvcCrcy | ||
| CN_TaxInvcDiscTaxAmtInInvcCrcy | I_CN_TaxInputInvc | CN_TaxInvcDiscTaxAmtInInvcCrcy | ||
| TaxRate | I_CN_TaxInputInvc | TaxRate | ||
| CompanyCode | I_CN_TaxInputInvc | CompanyCode | ||
| CN_TaxInvcGldnTxSystSts | I_CN_TaxInputInvc | CN_TaxInvcGldnTxSystSts | ||
| CN_TaxInvcGldnTxSystStsSyncTme | I_CN_TaxInputInvc | CN_TaxInvcGldnTxSystStsSyncTme | ||
| CN_TaxInvcInptProcgSts | I_CN_TaxInputInvc | CN_TaxInvcInptProcgSts | ||
| CN_TaxInvcDeductionType | I_CN_TaxInputInvc | CN_TaxInvcDeductionType | ||
| CN_TaxSellerName | I_CN_TaxInputInvc | CN_TaxSellerName | ||
| CN_TaxInvcComment | I_CN_TaxInputInvc | CN_TaxInvcComment | ||
| CN_TaxInvoiceUsage | I_CN_TaxInputInvc | CN_TaxInvoiceUsage | ||
| CN_TaxInvoiceDataSource | I_CN_TaxInputInvc | CN_TaxInvoiceDataSource | ||
| CN_TaxInvoiceExpenseReportNmbr | I_CN_TaxInputInvc | CN_TaxInvoiceExpenseReportNmbr | ||
| IsPostedOnAccount | I_CN_TaxInputInvc | IsPostedOnAccount | ||
| TaxCategory | I_CN_TaxInputInvc | TaxCategory | ||
| CN_TaxDeclnTime | I_CN_TaxInputInvc | CN_TaxDeclnTime | ||
| CN_TaxDeclnYear | I_CN_TaxInputInvc | CN_TaxDeclnYear | ||
| CN_TaxDeclnMonth | I_CN_TaxInputInvc | CN_TaxDeclnMonth | ||
| TaxInvoiceBuyerAddressPhone | I_CN_TaxInputInvc | TaxInvoiceBuyerAddressPhone | ||
| TaxInvoiceBuyerBankAccount | I_CN_TaxInputInvc | TaxInvoiceBuyerBankAccount | ||
| TaxInvoiceSellerAddressPhone | I_CN_TaxInputInvc | TaxInvoiceSellerAddressPhone | ||
| TaxInvoiceSellerBankAccount | I_CN_TaxInputInvc | TaxInvoiceSellerBankAccount | ||
| CN_TaxInvoiceVehicleType | I_CN_TaxInputInvc | CN_TaxInvoiceVehicleType | ||
| CN_TaxInvoiceVehFactoryModel | I_CN_TaxInputInvc | CN_TaxInvoiceVehFactoryModel | ||
| CN_TaxInvoiceVehicleProdnPlace | I_CN_TaxInputInvc | CN_TaxInvoiceVehicleProdnPlace | ||
| CN_TaxInvoiceVehicleCertNumber | I_CN_TaxInputInvc | CN_TaxInvoiceVehicleCertNumber | ||
| CN_TaxInvoiceVehImportCertNmbr | I_CN_TaxInputInvc | CN_TaxInvoiceVehImportCertNmbr | ||
| CN_TaxInvoiceVehicleInspNumber | I_CN_TaxInputInvc | CN_TaxInvoiceVehicleInspNumber | ||
| CN_TaxInvoiceVehicleEngineNmbr | I_CN_TaxInputInvc | CN_TaxInvoiceVehicleEngineNmbr | ||
| CN_TaxInvoiceVehicleNumber | I_CN_TaxInputInvc | CN_TaxInvoiceVehicleNumber | ||
| CN_TaxInvcVehTotAmtInInvcCrcy | I_CN_TaxInputInvc | CN_TaxInvcVehTotAmtInInvcCrcy | ||
| CN_TaxInvoiceVehTxnRecordNmbr | I_CN_TaxInputInvc | CN_TaxInvoiceVehTxnRecordNmbr | ||
| CN_TaxInvoiceVehicleTonnage | I_CN_TaxInputInvc | CN_TaxInvoiceVehicleTonnage | ||
| CN_TaxInvoiceVehPassengerLimit | I_CN_TaxInputInvc | CN_TaxInvoiceVehPassengerLimit | ||
| PurchasingOrganization | I_CN_TaxInputInvc | PurchasingOrganization | ||
| PurchasingGroup | I_CN_TaxInputInvc | PurchasingGroup | ||
| Supplier | I_CN_TaxInputInvc | Supplier | ||
| _Item | _Item | |||
| _Binding | _Binding | |||
| _Supplier | _Supplier |
@AbapCatalog.sqlViewName: 'ACNTXIIPT'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
viewType: #BASIC,
lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@AbapCatalog: {
compiler.compareFilter: true,
preserveKey: true
}
@AccessControl: {
authorizationCheck: #CHECK,
personalData.blocking: #BLOCKED_DATA_EXCLUDED
}
@ObjectModel: {
createEnabled: true,
updateEnabled: false,
deleteEnabled: false,
compositionRoot: true,
usageType: {
serviceQuality: #B,
sizeCategory: #L,
dataClass: #TRANSACTIONAL
}
}
@EndUserText.label: 'China Input Tax Invoice'
@Metadata: {
ignorePropagatedAnnotations: true
}
define view A_CN_TaxInputInvoice
as select from I_CN_TaxInputInvc as hdr
association [1..*] to A_CN_TaxInputInvoiceItem as _Item on $projection.CN_TaxInvcUUID = _Item.CN_TaxInvcUUID
association [1..*] to A_CN_TaxInvoiceBindingRecord as _Binding on $projection.CN_TaxInvcUUID = _Binding.CN_TaxInvcUUID
association [1..1] to A_Supplier as _Supplier on $projection.Supplier = _Supplier.Supplier
association [1..1] to E_CN_TaxInputInvc as _CommonExtension on $projection.CN_TaxInvcUUID = _CommonExtension.CN_TaxInvcUUID
association [1..1] to E_CN_TaxInputInvcMng as _ManageExtension on $projection.CN_TaxInvcUUID = _ManageExtension.CN_TaxInvcUUID
{
@ObjectModel.readOnly: true
key hdr.CN_TaxInvcUUID,
hdr.CN_TaxInvcCode,
hdr.CN_TaxInvcNmbr,
hdr.CN_TaxSellerRegnNmbr,
hdr.CN_TaxBuyerRegnNmbr,
@ObjectModel.sapObjectNodeTypeReference:'CN_ValueAddedTaxInvoiceType'
hdr.CN_TaxInvcType,
@Semantics.businessDate.at: true
hdr.CN_TaxInvcDate,
@Semantics.currencyCode: true
hdr.CN_TaxInvcCrcy,
@Semantics.amount.currencyCode: 'CN_TaxInvcCrcy'
hdr.CN_TaxInvcNetAmtInInvcCrcy,
@Semantics.amount.currencyCode: 'CN_TaxInvcCrcy'
hdr.CN_TaxInvcTaxAmtInInvcCrcy,
@Semantics.amount.currencyCode: 'CN_TaxInvcCrcy'
hdr.CN_TaxInvcDeductAmtInInvcCrcy,
hdr.CN_TaxEntityID as BusinessPlace,
@Semantics.amount.currencyCode: 'CN_TaxInvcCrcy'
hdr.CN_TaxInvcDiscNetAmtInInvcCrcy,
@Semantics.amount.currencyCode: 'CN_TaxInvcCrcy'
hdr.CN_TaxInvcDiscTaxAmtInInvcCrcy,
hdr.TaxRate,
hdr.CompanyCode,
@ObjectModel.sapObjectNodeTypeReference:'CN_ValueAddedTaxInvoiceSystSts'
hdr.CN_TaxInvcGldnTxSystSts,
hdr.CN_TaxInvcGldnTxSystStsSyncTme,
@ObjectModel.readOnly: true
@ObjectModel.sapObjectNodeTypeReference:'CN_ValueAddedTaxInvcProcgSts'
hdr.CN_TaxInvcInptProcgSts,
@ObjectModel.sapObjectNodeTypeReference:'CN_ValueAddedTaxDeductionType'
hdr.CN_TaxInvcDeductionType,
hdr.CN_TaxSellerName,
hdr.CN_TaxInvcComment,
hdr.CN_TaxInvoiceUsage,
hdr.CN_TaxInvoiceDataSource,
hdr.CN_TaxInvoiceExpenseReportNmbr,
hdr.IsPostedOnAccount,
@ObjectModel.sapObjectNodeTypeReference:'CN_ValueAddedTaxInvoiceCat'
hdr.TaxCategory,
@ObjectModel.readOnly: true
hdr.CN_TaxDeclnTime,
@ObjectModel.readOnly: true
hdr.CN_TaxDeclnYear,
@ObjectModel.readOnly: true
hdr.CN_TaxDeclnMonth,
hdr.TaxInvoiceBuyerAddressPhone,
hdr.TaxInvoiceBuyerBankAccount,
hdr.TaxInvoiceSellerAddressPhone,
hdr.TaxInvoiceSellerBankAccount,
// Vehicle Invoice
hdr.CN_TaxInvoiceVehicleType,
hdr.CN_TaxInvoiceVehFactoryModel,
hdr.CN_TaxInvoiceVehicleProdnPlace,
hdr.CN_TaxInvoiceVehicleCertNumber,
hdr.CN_TaxInvoiceVehImportCertNmbr,
hdr.CN_TaxInvoiceVehicleInspNumber,
hdr.CN_TaxInvoiceVehicleEngineNmbr,
hdr.CN_TaxInvoiceVehicleNumber,
@Semantics.amount.currencyCode: 'CN_TaxInvcCrcy'
hdr.CN_TaxInvcVehTotAmtInInvcCrcy,
hdr.CN_TaxInvoiceVehTxnRecordNmbr,
hdr.CN_TaxInvoiceVehicleTonnage,
hdr.CN_TaxInvoiceVehPassengerLimit,
hdr.PurchasingOrganization,
hdr.PurchasingGroup,
hdr.Supplier,
// Association
_Item,
_Binding,
_Supplier
}
where
hdr.IsDeleted <> 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CN_TAXINPUTINVC"
],
"ASSOCIATED":
[
"A_CN_TAXINPUTINVOICEITEM",
"A_CN_TAXINVOICEBINDINGRECORD",
"A_SUPPLIER",
"E_CN_TAXINPUTINVC",
"E_CN_TAXINPUTINVCMNG"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA