I_CN_TaxInputInvoiceItemTP

DDL: I_CN_TAXINPUTINVOICEITEMTP Type: view_entity TRANSACTIONAL Package: GLO_FIN_TAX_INVC_MGMT_COMM_CN
21 Fields 1 Data Sources 1 Associations

Incoming VAT Invoice Item

I_CN_TaxInputInvoiceItemTP is a Transactional CDS View that provides data about "Incoming VAT 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 1 association to related views. Part of development package GLO_FIN_TAX_INVC_MGMT_COMM_CN.

Data Sources (1)

SourceAliasJoin Type
I_CN_TaxInputInvoiceItem itm from

Associations (1)

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

Annotations (11)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
VDM.private false view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Incoming VAT Invoice Item view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.representativeKey TaxInvoiceItemUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.allowExtensions true view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY TaxInvoiceItemUUID I_CN_TaxInputInvoiceItem TaxInvoiceItemUUID
KEY CN_TaxInvcUUID I_CN_TaxInputInvoiceItem CN_TaxInvcUUID Invoice UUID
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 Unit Protected Qty
TaxInvoiceItemUnitDescription I_CN_TaxInputInvoiceItem TaxInvoiceItemUnitDescription
TaxInvoiceItemQuantity I_CN_TaxInputInvoiceItem TaxInvoiceItemQuantity
CN_TaxInvcCrcy _Invoice CN_TaxInvcCrcy Currency
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

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_CN_TaxInputInvoiceItemTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_CN_TaxInputInvoiceItemTP AS
SELECT
  itm.TaxInvoiceItemUUID AS TaxInvoiceItemUUID,
  itm.CN_TaxInvcUUID AS CN_TaxInvcUUID,
  itm.CN_TaxInvcCode AS CN_TaxInvcCode,
  itm.CN_TaxInvcNmbr AS CN_TaxInvcNmbr,
  itm.TaxInvoiceItem AS TaxInvoiceItem,
  itm.TaxInvoiceItemGoodsServiceName AS TaxInvoiceItemGoodsServiceName,
  itm.TaxInvoiceItemGoodsNumber AS TaxInvoiceItemGoodsNumber,
  itm.TaxInvoiceItemSpecModel AS TaxInvoiceItemSpecModel,
  itm.UnitOfMeasure AS UnitOfMeasure,
  itm.TaxInvoiceItemUnitDescription AS TaxInvoiceItemUnitDescription,
  itm.TaxInvoiceItemQuantity AS TaxInvoiceItemQuantity,
  _Invoice.CN_TaxInvcCrcy AS CN_TaxInvcCrcy,
  itm.TaxInvoiceItemNetUnitPrice AS TaxInvoiceItemNetUnitPrice,
  itm.TaxInvoiceItemNetAmount AS TaxInvoiceItemNetAmount,
  itm.TaxInvoiceItemTaxRate AS TaxInvoiceItemTaxRate,
  itm.TaxInvoiceItemTaxAmount AS TaxInvoiceItemTaxAmount,
  itm.TaxInvoiceItemTollCarLicPlate AS TaxInvoiceItemTollCarLicPlate,
  itm.TaxInvoiceItemTollCarCategory AS TaxInvoiceItemTollCarCategory,
  itm.TaxInvoiceItemTollStrtDateTime AS TaxInvoiceItemTollStrtDateTime,
  itm.TaxInvoiceItemTollEndDateTime AS TaxInvoiceItemTollEndDateTime
FROM I_CN_TaxInputInvoiceItem AS itm
LEFT OUTER JOIN E_CN_TaxInputInvoiceItem AS _Extension ON TaxInvoiceItemUUID = _Extension.TaxInvoiceItemUUID AND CN_TaxInvcUUID = _Extension.CN_TaxInvcUUID  -- association [1..1]
;

Learn More