I_CFinSupplierInvoice

DDL: I_CFINSUPPLIERINVOICE SQL: ICFINSIROOT Type: view COMPOSITE
38 Fields 2 Data Sources 2 Associations

CFin Supplier Invoice: Header

I_CFinSupplierInvoice is a Composite CDS View that provides data about "CFin Supplier Invoice: Header" in SAP S/4HANA. It reads from 2 data sources (I_CFinRpldSupplierInvoice, I_SupplierInvoice) and exposes 38 fields with key fields SenderLogicalSystem, CentralFinanceSupplierInvoice, FiscalYear, CentralFinanceSupplierInvoice, FiscalYear. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_CFinRpldSupplierInvoice I_CFinRpldSupplierInvoice from
I_SupplierInvoice I_SupplierInvoice union_all

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_CFinSupplierInvoiceItem _Item $projection.SenderLogicalSystem = _Item.SenderLogicalSystem and $projection.CentralFinanceSupplierInvoice = _Item.CentralFinanceSupplierInvoice and $projection.FiscalYear = _Item.FiscalYear
[0..1] I_LogicalSystem _LogicalSystem $projection.SenderLogicalSystem = _LogicalSystem.LogicalSystem

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label CFin Supplier Invoice: Header view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ICFINSIROOT 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 (38)

KeyFieldSource TableSource FieldDescription
KEY SenderLogicalSystem SenderLogicalSystem Sender Logical System
KEY CentralFinanceSupplierInvoice SD Document
KEY FiscalYear FiscalYear G/L Fiscal Year
DocumentDate DocumentDate Journal Entry Date
CompanyCode CompanyCode Receiver Company Code
SupplierInvoiceStatus SupplierInvoiceStatus Inv. status
ReverseDocument ReverseDocument Reversed With
ReverseDocumentFiscalYear ReverseDocumentFiscalYear Year
SupplierInvoiceOrigin SupplierInvoiceOrigin IV category
DocumentCurrency DocumentCurrency Document Currency
SuplrInvcTransactionCategory SuplrInvcTransactionCategory Transactn Type
InvoicingParty InvoicingParty Supplier
CreationDate CreationDate Time Stamp
ElectronicInvoiceUUID ElectronicInvoiceUUID Mexico UUID
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
IsInvoice IsInvoice TRUE
_CompanyCode _CompanyCode
_Currency _Currency
_Item _Item
KEY CentralFinanceSupplierInvoice SD Document
KEY FiscalYear FiscalYear G/L Fiscal Year
DocumentDate DocumentDate Journal Entry Date
CompanyCode CompanyCode Receiver Company Code
SupplierInvoiceStatus SupplierInvoiceStatus Inv. status
ReverseDocument ReverseDocument Reversed With
ReverseDocumentFiscalYear ReverseDocumentFiscalYear Year
SupplierInvoiceOrigin SupplierInvoiceOrigin IV category
DocumentCurrency DocumentCurrency Document Currency
SuplrInvcTransactionCategory SuplrInvcTransactionCategory Transactn Type
InvoicingParty InvoicingParty Supplier
CreationDate CreationDate Time Stamp
ElectronicInvoiceUUID ElectronicInvoiceUUID Mexico UUID
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
IsInvoice IsInvoice TRUE
_CompanyCode _CompanyCode
_Currency _Currency
_Item _Item
_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_CFinSupplierInvoice.
-- 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: ICFINSIROOT

CREATE VIEW I_CFinSupplierInvoice AS
SELECT
  SenderLogicalSystem,
  cast( CFinRpldSupplierInvoice as fins_cfin_av_supplier_invoice preserving type ) AS CentralFinanceSupplierInvoice,
  FiscalYear,
  DocumentDate,
  CompanyCode,
  SupplierInvoiceStatus,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  SupplierInvoiceOrigin,
  DocumentCurrency,
  SuplrInvcTransactionCategory,
  InvoicingParty,
  CreationDate,
  ElectronicInvoiceUUID,
  IsEndOfPurposeBlocked,
  IsInvoice
FROM I_CFinRpldSupplierInvoice
LEFT OUTER JOIN I_CFinSupplierInvoiceItem AS _Item ON SenderLogicalSystem = _Item.SenderLogicalSystem AND CentralFinanceSupplierInvoice = _Item.CentralFinanceSupplierInvoice AND FiscalYear = _Item.FiscalYear  -- association [0..*]
LEFT OUTER JOIN I_LogicalSystem AS _LogicalSystem ON SenderLogicalSystem = _LogicalSystem.LogicalSystem  -- association [0..1]
-- UNION ALL with additional select branch(es): I_SupplierInvoice
;

Learn More