I_CFinSupplierInvoiceItem

DDL: I_CFINSUPPLIERINVOICEITEM SQL: ICFINSIITEM Type: view COMPOSITE
42 Fields 2 Data Sources 2 Associations

Central Finance Supplier Invoice: Item

I_CFinSupplierInvoiceItem is a Composite CDS View that provides data about "Central Finance Supplier Invoice: Item" in SAP S/4HANA. It reads from 2 data sources (I_CFinRpldSupplierInvoiceItem, I_SupplierInvoiceItemPurOrdRef) and exposes 42 fields with key fields SenderLogicalSystem, CentralFinanceSupplierInvoice, FiscalYear, CFinSupplierInvoiceItem, CentralFinanceSupplierInvoice. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_CFinRpldSupplierInvoiceItem I_CFinRpldSupplierInvoiceItem from
I_SupplierInvoiceItemPurOrdRef I_SupplierInvoiceItemPurOrdRef union_all

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_CFinSupplierInvoice _SupplierInvoice $projection.CFinSupplierInvoiceItem = _SupplierInvoice.CentralFinanceSupplierInvoice and $projection.SenderLogicalSystem = _SupplierInvoice.SenderLogicalSystem and $projection.FiscalYear = _SupplierInvoice.FiscalYear
[0..1] I_LogicalSystem _LogicalSystem $projection.SenderLogicalSystem = _LogicalSystem.LogicalSystem

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Central Finance Supplier Invoice: Item view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ICFINSIITEM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY SenderLogicalSystem SenderLogicalSystem Sender Logical System
KEY CentralFinanceSupplierInvoice
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY CFinSupplierInvoiceItem
CFinPurchasingDocument Purchasing Document
CFinPurchasingDocumentItem Purchasing Document Item
TaxCode TaxCode Tax Code
PurchaseOrderItemMaterial PurchaseOrderItemMaterial Vehicle Model
SupplierInvoiceItemAmount SupplierInvoiceItemAmount Amount
DocumentCurrency DocumentCurrency Document Currency
Plant Plant Valuation Area
QuantityInPurchaseOrderUnit QuantityInPurchaseOrderUnit Quantity
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit Order Unit
FreightSupplier FreightSupplier Supplier
IsSubsequentDebitCredit IsSubsequentDebitCredit Subseq. Dr/Cr
PurchaseOrderPriceUnit PurchaseOrderPriceUnit Order Price Un.
QtyInPurchaseOrderPriceUnit QtyInPurchaseOrderPriceUnit Qty in OPUn
_SupplierInvoice _SupplierInvoice
_Currency _Currency
_UnitOfMeasure _UnitOfMeasure
_PurOrdPriceUnitOfMeasure _PurOrdPriceUnitOfMeasure
KEY CentralFinanceSupplierInvoice
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY CFinSupplierInvoiceItem
CFinPurchasingDocument Purchasing Document
CFinPurchasingDocumentItem Purchasing Document Item
TaxCode TaxCode Tax Code
PurchaseOrderItemMaterial PurchaseOrderItemMaterial Vehicle Model
SupplierInvoiceItemAmount SupplierInvoiceItemAmount Amount
DocumentCurrency DocumentCurrency Document Currency
Plant Plant Valuation Area
QuantityInPurchaseOrderUnit QuantityInPurchaseOrderUnit Quantity
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit Order Unit
FreightSupplier FreightSupplier Supplier
IsSubsequentDebitCredit IsSubsequentDebitCredit Subseq. Dr/Cr
PurchaseOrderPriceUnit PurchaseOrderPriceUnit Order Price Un.
QtyInPurchaseOrderPriceUnit QtyInPurchaseOrderPriceUnit Qty in OPUn
_SupplierInvoice _SupplierInvoice
_Currency _Currency
_UnitOfMeasure _UnitOfMeasure
_PurOrdPriceUnitOfMeasure _PurOrdPriceUnitOfMeasure
_LogicalSystem _LogicalSystem

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_CFinSupplierInvoiceItem.
-- 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.
-- SQL view name: ICFINSIITEM

CREATE VIEW I_CFinSupplierInvoiceItem AS
SELECT
  SenderLogicalSystem,
  cast( CFinRpldSupplierInvoice as fins_cfin_av_supplier_invoice preserving type ) AS CentralFinanceSupplierInvoice,
  FiscalYear,
  cast( CFinRpldSupplierInvoiceItem as fins_cfin_av_suplr_invc_item preserving type ) AS CFinSupplierInvoiceItem,
  cast( CFinRpldPurchasingDocument as fins_cfin_av_purchasing_doc preserving type ) AS CFinPurchasingDocument,
  cast( CFinRpldPurchasingDocumentItem as fins_cfin_av_purg_document_itm preserving type ) AS CFinPurchasingDocumentItem,
  TaxCode,
  PurchaseOrderItemMaterial,
  SupplierInvoiceItemAmount,
  DocumentCurrency,
  Plant,
  QuantityInPurchaseOrderUnit,
  PurchaseOrderQuantityUnit,
  FreightSupplier,
  IsSubsequentDebitCredit,
  PurchaseOrderPriceUnit,
  QtyInPurchaseOrderPriceUnit
FROM I_CFinRpldSupplierInvoiceItem
LEFT OUTER JOIN I_CFinSupplierInvoice AS _SupplierInvoice ON CFinSupplierInvoiceItem = _SupplierInvoice.CentralFinanceSupplierInvoice AND SenderLogicalSystem = _SupplierInvoice.SenderLogicalSystem AND FiscalYear = _SupplierInvoice.FiscalYear  -- association [1..1]
LEFT OUTER JOIN I_LogicalSystem AS _LogicalSystem ON SenderLogicalSystem = _LogicalSystem.LogicalSystem  -- association [0..1]
-- UNION ALL with additional select branch(es): I_SupplierInvoiceItemPurOrdRef
;

Learn More