I_CN_GoldenTaxInvoiceItem

DDL: I_CN_GOLDENTAXINVOICEITEM Type: view BASIC

Golden Tax Invoice Item

I_CN_GoldenTaxInvoiceItem is a Basic CDS View that provides data about "Golden Tax Invoice Item" in SAP S/4HANA. It reads from 1 data source (txi_itm) and exposes 19 fields with key field TaxInvoiceItemUUID. It has 1 association to related views.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
txi_itm txi_itm from

Associations (1)

CardinalityTargetAliasCondition
[1] I_CN_GoldenTaxInvoiceBasic _GTInvoice $projection.CN_TaxInvcCode = _GTInvoice.CN_TaxInvcCode and $projection.CN_TaxInvcNmbr = _GTInvoice.CN_TaxInvcNmbr

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName ICNGTINVCITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Golden Tax Invoice Item view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY TaxInvoiceItemUUID invc_item_uuid
CN_TaxInvcUUID invc_uuid
CN_TaxInvcCode invc_code
CN_TaxInvcNmbr invc_nmbr
TaxInvoiceItem invc_item_nmbr
CN_GoldenTaxIsDiscountLine disc_ind
Product matl_nmbr
ProductName matl_desc
SizeOrDimensionText matl_spec
BilledQuantityUnit unit_of_msr
BilledQuantityUnitName unit_of_msr_desc
BilledQuantity blld_qty
NetAmount net_amount
TaxAmount tax_amount
CN_GoldenTaxUnitPrice unit_price
CN_GoldenTaxDdctdAmtInLoclCrcy deductions
TaxRate tax_rate
LocalCurrency _GTInvoice LocalCurrency
_GTInvoice _GTInvoice 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.personalData.blocking: #REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #L,
  dataClass: #MIXED
}
@VDM: {
  viewType:#BASIC
}
@AbapCatalog: {
  sqlViewName: 'ICNGTINVCITM',
  compiler.compareFilter: true,
  preserveKey: true,
  viewEnhancementCategory: [#NONE]
}
@EndUserText.label: 'Golden Tax Invoice Item'
define view I_CN_GoldenTaxInvoiceItem as select from txi_itm 
association [1] to I_CN_GoldenTaxInvoiceBasic as _GTInvoice
  on $projection.CN_TaxInvcCode = _GTInvoice.CN_TaxInvcCode
  and $projection.CN_TaxInvcNmbr = _GTInvoice.CN_TaxInvcNmbr
{
  key invc_item_uuid as TaxInvoiceItemUUID,
  invc_uuid          as CN_TaxInvcUUID,
  invc_code          as CN_TaxInvcCode,
  invc_nmbr          as CN_TaxInvcNmbr,
  invc_item_nmbr     as TaxInvoiceItem,
  disc_ind           as CN_GoldenTaxIsDiscountLine,
  matl_nmbr          as Product,
  matl_desc          as ProductName,
  matl_spec          as SizeOrDimensionText,
  
  unit_of_msr        as BilledQuantityUnit,
  unit_of_msr_desc   as BilledQuantityUnitName,
  @Semantics.quantity.unitOfMeasure: 'BilledQuantityUnit'
  blld_qty           as BilledQuantity,
  @Semantics.amount.currencyCode: 'LocalCurrency'
  net_amount         as NetAmount,
  @Semantics.amount.currencyCode: 'LocalCurrency'
  tax_amount         as TaxAmount,
  @Semantics.amount.currencyCode: 'LocalCurrency'
  unit_price         as CN_GoldenTaxUnitPrice,
  //tax_ctlg_code      as TaxCtlgCode,

  @Semantics.amount.currencyCode: 'LocalCurrency'
  deductions         as CN_GoldenTaxDdctdAmtInLoclCrcy,
  //goods_nmbr         as GoodsNmbr,

  tax_rate           as TaxRate,
  _GTInvoice.LocalCurrency,
  
  _GTInvoice
  //toll_car_licplate as TollCarLicplate,

  //toll_cat_category as TollCatCategory,

  //toll_start_datetime as TollStartDatetime,

  //toll_end_datetime as TollEndDatetime,

  //mark_as_delete as MarkAsDelete,

  //dummy_ficntxi_itm_incl_eew_ps as DummyFicntxiItmInclEewPs

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CN_GOLDENTAXINVOICEBASIC",
"TXI_ITM"
],
"ASSOCIATED":
[
"I_CN_GOLDENTAXINVOICEBASIC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More