A_CN_TaxInputInvoice

DDL: A_CN_TAXINPUTINVOICE SQL: ACNTXIIPT Type: view BASIC

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)

SourceAliasJoin Type
I_CN_TaxInputInvc hdr from

Associations (5)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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":""
}
}*/