I_RO_SAFTAccountingItem

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_RO_SAFTAccountingItem.
-- 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: IROSAFTACCITM

CREATE VIEW I_RO_SAFTAccountingItem AS
SELECT
  _AccountingItem.belnr AS AccountingDocument,
  _AccountingItem.bukrs AS CompanyCode,
  _AccountingItem.gjahr AS FiscalYear,
  _AccountingItem.buzei AS AccountingDocumentItem,
  _AccountingItem.awkey AS OriginalReferenceDocument,
  _AccountingItem.posnr AS AccountingDocumentItemRef,
  _AccountingItem.hkont AS TargetGLAccount,
  _AccountingItem.vbel2 AS SalesOrder,
  _AccountingItem.matnr AS Product,
  _AccountingItem.werks AS Plant,
  _AccountingItem.menge AS Quantity,
  _AccountingItem.meins AS BaseUnit,
  _AccountingItem.shkzg AS DebitCreditCode,
  _AccountingItem.sgtxt AS DocumentItemText,
  _AccountingItem.zlsch AS PaymentMethod,
  _AccountingItem.peinh AS ProductPriceUnitQuantity,
  _AccountingItem.dmbtr AS TransactionAmountInLocalCrcy,
  _AccountingItem.h_budat AS PostingDate,
  _JournalEntry.TransactionCurrency AS TransactionCurrency,
  _AccountingItem.wrbtr AS InvoiceAmountInInvoiceDocCrcy,
  _AccountingItem.kunnr AS Customer,
  _AccountingItem.lifnr AS Supplier,
  cast(substring( _AccountingItem.awkey, 1, 10) as mblnr preserving type) AS MaterialDocument,
  cast(substring( _AccountingItem.awkey, 11, 4) as mjahr) AS MaterialDocumentYear,
  _AccountingItem.awtyp AS ReferenceDocumentType,
  _JournalEntry.AccountingDocumentType AS AccountingDocumentType,
  _AccountingItem.zterm AS PaymentTerms,
  _AccountingItem.kostl AS CostCenter,
  _AccountingItem.koart AS AccountType,
  _AccountingItem.stceg AS CompanyVATRegistration
FROM bseg AS _AccountingItem
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON CompanyCode = _JournalEntry.CompanyCode AND AccountingDocument = _JournalEntry.AccountingDocument AND FiscalYear = _JournalEntry.FiscalYear  -- association [0..1]
;