A_CN_TaxInputInvoiceItem

DDL: A_CN_TAXINPUTINVOICEITEM SQL: ACNTXIIPTITM Type: view BASIC

China Input Tax Invoice Item

A_CN_TaxInputInvoiceItem is a Basic CDS View that provides data about "China Input Tax Invoice Item" in SAP S/4HANA. It reads from 1 data source (I_CN_TaxInputInvoiceItem) and exposes 21 fields with key fields TaxInvoiceItemUUID, CN_TaxInvcUUID. It has 2 associations to related views.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
I_CN_TaxInputInvoiceItem itm from

Associations (2)

CardinalityTargetAliasCondition
[1..1] A_CN_TaxInputInvoice _Invoice $projection.CN_TaxInvcUUID = _Invoice.CN_TaxInvcUUID
[1..1] E_CN_TaxInputInvoiceItem _Extension $projection.TaxInvoiceItemUUID = _Extension.TaxInvoiceItemUUID and $projection.CN_TaxInvcUUID = _Extension.CN_TaxInvcUUID

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ACNTXIIPTITM 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
ObjectModel.createEnabled true view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view
ObjectModel.compositionRoot false view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label China Input Tax Invoice Item view
Metadata.ignorePropagatedAnnotations true view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY TaxInvoiceItemUUID I_CN_TaxInputInvoiceItem TaxInvoiceItemUUID
KEY CN_TaxInvcUUID I_CN_TaxInputInvoiceItem CN_TaxInvcUUID
CN_TaxInvcCode I_CN_TaxInputInvoiceItem CN_TaxInvcCode
CN_TaxInvcNmbr I_CN_TaxInputInvoiceItem CN_TaxInvcNmbr
TaxInvoiceItem I_CN_TaxInputInvoiceItem TaxInvoiceItem
TaxInvoiceItemGoodsServiceName I_CN_TaxInputInvoiceItem TaxInvoiceItemGoodsServiceName
TaxInvoiceItemGoodsNumber I_CN_TaxInputInvoiceItem TaxInvoiceItemGoodsNumber
TaxInvoiceItemSpecModel I_CN_TaxInputInvoiceItem TaxInvoiceItemSpecModel
UnitOfMeasure I_CN_TaxInputInvoiceItem UnitOfMeasure
TaxInvoiceItemUnitDescription I_CN_TaxInputInvoiceItem TaxInvoiceItemUnitDescription
TaxInvoiceItemQuantity I_CN_TaxInputInvoiceItem TaxInvoiceItemQuantity
CN_TaxInvcCrcy _Invoice CN_TaxInvcCrcy
TaxInvoiceItemNetUnitPrice I_CN_TaxInputInvoiceItem TaxInvoiceItemNetUnitPrice
TaxInvoiceItemNetAmount I_CN_TaxInputInvoiceItem TaxInvoiceItemNetAmount
TaxInvoiceItemTaxRate I_CN_TaxInputInvoiceItem TaxInvoiceItemTaxRate
TaxInvoiceItemTaxAmount I_CN_TaxInputInvoiceItem TaxInvoiceItemTaxAmount
TaxInvoiceItemTollCarLicPlate I_CN_TaxInputInvoiceItem TaxInvoiceItemTollCarLicPlate
TaxInvoiceItemTollCarCategory I_CN_TaxInputInvoiceItem TaxInvoiceItemTollCarCategory
TaxInvoiceItemTollStrtDateTime I_CN_TaxInputInvoiceItem TaxInvoiceItemTollStrtDateTime
TaxInvoiceItemTollEndDateTime I_CN_TaxInputInvoiceItem TaxInvoiceItemTollEndDateTime
_Invoice _Invoice 
@AbapCatalog.sqlViewName: 'ACNTXIIPTITM'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@AbapCatalog: {
  compiler.compareFilter: true,
  preserveKey: true
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
  createEnabled: true,
  updateEnabled: false,
  deleteEnabled: false,
  compositionRoot: false,
  usageType: {
    serviceQuality: #B,
    sizeCategory: #L,
    dataClass: #TRANSACTIONAL
  }
}
@EndUserText.label: 'China Input Tax Invoice Item'
@Metadata: {
  ignorePropagatedAnnotations: true
}

define view A_CN_TaxInputInvoiceItem

  as select from I_CN_TaxInputInvoiceItem as itm

  association [1..1] to A_CN_TaxInputInvoice     as _Invoice   on  $projection.CN_TaxInvcUUID = _Invoice.CN_TaxInvcUUID

  association [1..1] to E_CN_TaxInputInvoiceItem as _Extension on  $projection.TaxInvoiceItemUUID = _Extension.TaxInvoiceItemUUID
                                                               and $projection.CN_TaxInvcUUID     = _Extension.CN_TaxInvcUUID
{
      @ObjectModel.readOnly: true
  key itm.TaxInvoiceItemUUID,
      @ObjectModel.readOnly: true
  key itm.CN_TaxInvcUUID,

      itm.CN_TaxInvcCode,
      itm.CN_TaxInvcNmbr,
      @ObjectModel.readOnly: true
      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,

      // Associations

      _Invoice
}
where
  itm.IsDeleted <> 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"A_CN_TAXINPUTINVOICE",
"I_CN_TAXINPUTINVOICEITEM"
],
"ASSOCIATED":
[
"A_CN_TAXINPUTINVOICE",
"E_CN_TAXINPUTINVOICEITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More