I_CN_TaxInvoiceAccountingDoc

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_TaxInvoiceAccountingDoc.
-- 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_TaxInvoiceAccountingDoc AS
SELECT
  _BindingInfo.CN_TaxInvcBindgItmUUID AS CN_TaxInvcBindgItmUUID,
  _BindingInfo.RelatedDocumentNumber AS RelatedDocumentNumber,
  _BindingInfo.FiscalYear AS FiscalYear,
  _VATInvoice.CompanyCode AS CompanyCode,
  _VATInvoice.CN_TaxInvcNmbr AS CN_TaxInvcNmbr,
  _VATInvoice.CN_TaxInvcCode AS CN_TaxInvcCode,
  _BindingInfo.CN_TaxInvcBindgSrceBusObjType AS CN_TaxInvcBindgSrceBusObjType,
  _BindingInfo.CN_TaxInvcUUID AS CN_TaxInvcUUID,
  _BindingInfo.CN_BindingHeaderDocumentKey AS CN_BindingHeaderDocumentKey,
  _JournalEntry.AccountingDocument AS AccountingDocument,
  _JournalEntry.AccountingDocumentType AS AccountingDocumentType,
  _JournalEntry.TransactionCode AS TransactionCode,
  cast( concat(_VATInvoice.CN_TaxInvcCode, _VATInvoice.CN_TaxInvcNmbr) as ficntaxinvc_code_nmbr ) AS CN_TaxInvcCodeNmbr,
  _VATInvoice.CN_TaxInvcDate AS CN_TaxInvcDate,
  _VATInvoice.CN_TaxInvcInptProcgSts AS CN_TaxInvcInptProcgSts,
  _VATInvoice.CN_TaxInvcGldnTxSystSts AS CN_TaxInvcGldnTxSystSts,
  _VATInvoice.CN_TaxInvcNetAmtInInvcCrcy AS CN_TaxInvcNetAmtInInvcCrcy,
  _VATInvoice.CN_TaxInvcTaxAmtInInvcCrcy AS CN_TaxInvcTaxAmtInInvcCrcy,
  cast (_VATInvoice.CN_TaxInvcNetAmtInInvcCrcy + _VATInvoice.CN_TaxInvcTaxAmtInInvcCrcy as ficntaxinvc_amnt_tot) AS CN_TaxInvcTotAmtInInvcCrcy,
  _VATInvoice.CN_TaxInvcCrcy AS CN_TaxInvcCrcy,
  _VATInvoice.CN_TaxSellerName AS CN_TaxSellerName,
  _VATInvoice.CN_TaxSellerRegnNmbr AS CN_TaxSellerRegnNmbr,
  _VATInvoice.CN_TaxBuyerRegnNmbr AS CN_TaxBuyerRegnNmbr,
  _VATInvoice.CN_TaxInvcType AS CN_TaxInvcType,
  _VATInvoice.IsPostedOnAccount AS IsPostedOnAccount,
  _VATInvoice.Supplier AS Supplier,
  _VATInvoice.CN_TaxEntityID AS CN_TaxEntityID,
  cast( 'X' as boolean) AS CN_TaxInvoiceIsVerified,
  _VATInvoice.CN_TaxDeclnYear AS CN_TaxDeclnYear,
  _VATInvoice.CN_TaxDeclnMonth AS CN_TaxDeclnMonth,
  _VATInvoice.CN_TaxInvoiceUsage AS CN_TaxInvoiceUsage,
  _TransfItem.CN_TaxTransfNetAmtInInvcCrcy AS CN_TaxTransfNetAmtInInvcCrcy,
  _TransfItem.CN_TaxTransfType AS CN_TaxTransfType,
  _TransfItem._TransferType.CN_TaxTransfDrctn AS CN_TaxTransfDrctn,
  _VATInvoice._Supplier AS _Supplier
FROM I_CN_TaxInvoiceBindingInfo AS _BindingInfo
INNER JOIN I_JournalEntry AS _JournalEntry ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CN_TaxInputInvc AS _VATInvoice ON _VATInvoice.CN_TaxInvcUUID = _BindingInfo.CN_TaxInvcUUID  -- association [0..1]
LEFT OUTER JOIN I_CN_TaxInputInvoiceItem AS _InvoiceItem ON CN_TaxInvcUUID = _InvoiceItem.CN_TaxInvcUUID  -- association [0..*]
LEFT OUTER JOIN I_CN_TaxTransfItem AS _TransfItem ON CN_TaxInvcUUID = _TransfItem.CN_TaxInvcUUID  -- association [0..*]
-- UNION ALL with additional select branch(es): I_CN_TaxInvoiceBindingInfo
;