I_CN_TAXINPUTINVOICEITEM

CDS View

Incoming VAT Invoice Item

I_CN_TAXINPUTINVOICEITEM is a CDS View in S/4HANA. Incoming VAT Invoice Item. It contains 19 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 19 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_CN_TaxInputInvoiceItem view from BASIC China Input Tax Invoice Item
I_CN_TaxInputInvoiceItemTP view_entity from TRANSACTIONAL Incoming VAT Invoice Item

Fields (19)

KeyField CDS FieldsUsed in Views
KEY CN_TaxInvcUUID CN_TaxInvcUUID 2
KEY TaxInvoiceItemUUID TaxInvoiceItemUUID 2
CN_TaxInvcCode CN_TaxInvcCode 2
CN_TaxInvcNmbr CN_TaxInvcNmbr 2
TaxInvoiceItem TaxInvoiceItem 2
TaxInvoiceItemGoodsNumber TaxInvoiceItemGoodsNumber 2
TaxInvoiceItemGoodsServiceName TaxInvoiceItemGoodsServiceName 2
TaxInvoiceItemNetAmount TaxInvoiceItemNetAmount 2
TaxInvoiceItemNetUnitPrice TaxInvoiceItemNetUnitPrice 2
TaxInvoiceItemQuantity TaxInvoiceItemQuantity 2
TaxInvoiceItemSpecModel TaxInvoiceItemSpecModel 2
TaxInvoiceItemTaxAmount TaxInvoiceItemTaxAmount 2
TaxInvoiceItemTaxRate TaxInvoiceItemTaxRate 2
TaxInvoiceItemTollCarCategory TaxInvoiceItemTollCarCategory 2
TaxInvoiceItemTollCarLicPlate TaxInvoiceItemTollCarLicPlate 2
TaxInvoiceItemTollEndDateTime TaxInvoiceItemTollEndDateTime 2
TaxInvoiceItemTollStrtDateTime TaxInvoiceItemTollStrtDateTime 2
TaxInvoiceItemUnitDescription TaxInvoiceItemUnitDescription 2
UnitOfMeasure UnitOfMeasure 2 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog: {
    sqlViewName: 'ICNTXIIPTITM',
    compiler.compareFilter: true
}
@VDM: {
    viewType: #BASIC,
    private: false
}
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Incoming VAT Invoice Item'
@ObjectModel: {
  representativeKey: 'TaxInvoiceItemUUID',
  usageType: {
    serviceQuality: #A,
    sizeCategory: #XL,
    dataClass: #TRANSACTIONAL
  }
}

define view I_CN_TaxInputInvoiceItem

  as select from P_CN_TaxInputInvoiceItem as itm

  association [1..1] to I_CN_TaxInputInvc as _Invoice on $projection.CN_TaxInvcUUID = _Invoice.CN_TaxInvcUUID
{
  key itm.TaxInvoiceItemUUID,
  key itm.CN_TaxInvcUUID,

      itm.CN_TaxInvcCode,
      itm.CN_TaxInvcNmbr,
      
      itm.TaxInvoiceItem,
      itm.TaxInvoiceItemGoodsServiceName,
      itm.TaxInvoiceItemGoodsNumber,
      itm.TaxInvoiceItemSpecModel,
      itm.UnitOfMeasure,
      itm.TaxInvoiceItemUnitDescription,
      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasure'
      itm.TaxInvoiceItemQuantity,
      @Semantics.currencyCode: true
      _Invoice.CN_TaxInvcCrcy as CN_TaxInvcCrcy,
      @Semantics.amount.currencyCode: 'CN_TaxInvcCrcy'
      itm.TaxInvoiceItemNetUnitPrice,
      @Semantics.amount.currencyCode: 'CN_TaxInvcCrcy'
      itm.TaxInvoiceItemNetAmount,
      itm.TaxInvoiceItemTaxRate,
      @Semantics.amount.currencyCode: 'CN_TaxInvcCrcy'
      itm.TaxInvoiceItemTaxAmount,
      itm.TaxInvoiceItemTollCarLicPlate,
      itm.TaxInvoiceItemTollCarCategory,
      itm.TaxInvoiceItemTollStrtDateTime,
      itm.TaxInvoiceItemTollEndDateTime,
      itm.IsDeleted,
      
      _Invoice
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CN_TAXINPUTINVC",
"P_CN_TAXINPUTINVOICEITEM"
],
"ASSOCIATED":
[
"I_CN_TAXINPUTINVC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More