I_TrsyAccountingItemBase

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_TrsyAccountingItemBase.
-- 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: ITRSYACCTITEMB

CREATE VIEW I_TrsyAccountingItemBase AS
SELECT
  accitem.document_guid AS TrsyAccountingDocumentUUID,
  accitem.item_number AS AccountingDocumentItemRef,
  accitem.pc_guid AS TrsyPositionContextUUID,
  accitem.dis_flowtype AS TreasuryUpdateType,
  accitem.szart AS IsUsedInPaymentTransaction,
  accitem.aa_ref AS TreasuryGLAccountAssignmentRef,
  accitem.acc_symbol AS TreasuryGLAccountSymbol,
  cast(accitem.posting_cat as ftr_gen_posting_category preserving type) AS TreasuryPostingCategory,
  accitem.posting_key AS PostingKey,
  accitem.gl_account AS GLAccount,
  cast(accitem.position_amt as ftr_gen_amount_position_crcy) AS AmountInPositionCurrency,
  cast(accitem.position_curr as ftr_gen_position_crcy) AS PositionCurrency,
  accitem.local_amt AS AmountInCompanyCodeCurrency,
  accitem.local_curr AS CompanyCodeCurrency,
  accitem.trdflownr AS TreasuryTransactionFlow,
  accitem.belnr AS AccountingDocument,
  cast(accitem.reversal_belnr as fis_stblg preserving type) AS ReverseDocument,
  accitem.buzei AS AccountingDocumentItem,
  accitem.blart AS JournalEntryType,
  accitem.payment_date AS PaymentDate,
  accitem.kunnr AS Customer,
  accitem.lifnr AS Supplier,
  accitem.zterm AS PaymentTerms,
  accitem.zlsch AS PaymentMethod,
  accitem.uzawe AS PaymentMethodSupplement,
  accitem.zlspr AS PaymentBlockingReason,
  accitem.rpzahl AS PayerPayee,
  accitem.rpbank AS BPBankAccountInternalID,
  accitem.house_bank AS HouseBank,
  accitem.house_bank_acc AS HouseBankAccount,
  accitem.sign AS TreasuryPaymentFlowDirection,
  accitem.lzbkz AS StateCentralBankPaymentReason,
  accitem.landl AS SupplyingCountry,
  accitem.allocnr AS AssignmentReference,
  cast(accitem.sgtxt as fis_sgtxt preserving type) AS JournalEntryItemText,
  accitem.gsber AS BusinessArea,
  accitem.kostl AS CostCenter,
  cast(accitem.rmvct as ftr_gen_transaction_type_fi preserving type) AS FinancialTransactionType,
  accitem.vbund AS PartnerCompany,
  cast(accitem.kontrahent as rkontrah_new preserving type ) AS Counterparty,
  accitem.issuer AS Issuer,
  accitem.mndid AS SEPAMandate,
  accitem.spgl_ind AS SpecialGLCode,
  accitem.payment_reason AS PaymentReason
FROM tract_accitem AS accitem
LEFT OUTER JOIN I_TrsyAccountingItemDocument AS _TrsyAcctItemDocument ON accitem.document_guid = _TrsyAcctItemDocument.TrsyAcctItemDocumentDocUUID  -- association [0..1]
LEFT OUTER JOIN I_TrsyAcctItemPositionContext AS _TrsyAcctItemPosContext ON accitem.pc_guid = _TrsyAcctItemPosContext.TrsyPositionContextUUID  -- association [0..1]
LEFT OUTER JOIN I_Treasuryupdatetype AS _TreasuryUpdateType ON TreasuryUpdateType = _TreasuryUpdateType.TreasuryUpdateType  -- association [0..1]
LEFT OUTER JOIN I_TreasuryGLAccountAssignRef AS _TreasuryGLAccountAssignRef ON TreasuryGLAccountAssignmentRef = _TreasuryGLAccountAssignRef.TreasuryGLAccountAssignmentRef  -- association [0..1]
LEFT OUTER JOIN I_Treasuryglaccountsymbol AS _TreasuryGLAccountSymbol ON TreasuryGLAccountSymbol = _TreasuryGLAccountSymbol.TreasuryGLAccountSymbol  -- association [0..1]
LEFT OUTER JOIN I_TreasuryPostingCategory AS _TreasuryPostingCategory ON accitem.posting_cat = _TreasuryPostingCategory.TreasuryPostingCategory  -- association [0..1]
LEFT OUTER JOIN I_Partnercompany AS _PartnerCompany ON PartnerCompany = _PartnerCompany.PartnerCompany AND _PartnerCompany.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Paymentmethodsupplement AS _Paymentmethodsupplement ON PaymentMethodSupplement = _Paymentmethodsupplement.PaymentMethodSupplement  -- association [0..1]
LEFT OUTER JOIN I_PAYERPAYEE AS _PayerPayee ON PayerPayee = _PayerPayee.PayerPayee  -- association [0..1]
LEFT OUTER JOIN I_PostingKeyWithSpecialGLCode AS _PostingKeyWithSpecialGLCode ON PostingKey = _PostingKeyWithSpecialGLCode.PostingKey AND SpecialGLCode = _PostingKeyWithSpecialGLCode.SpecialGLCode  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentType AS _AccountingDocumentType ON JournalEntryType = _AccountingDocumentType.AccountingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_PaymentMethod AS _PaymentMethod ON PaymentMethod = _PaymentMethod.PaymentMethod AND SupplyingCountry = _PaymentMethod.Country  -- association [0..1]
LEFT OUTER JOIN I_PaymentBlockingReason AS _PaymentBlockingReason ON PaymentBlockingReason = _PaymentBlockingReason.PaymentBlockingReason  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON SupplyingCountry = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_FinancialTransactionType AS _FinancialTransactionType ON FinancialTransactionType = _FinancialTransactionType.FinancialTransactionType  -- association [0..1]
LEFT OUTER JOIN I_PostingKey AS _PostingKey ON PostingKey = _PostingKey.PostingKey  -- association [0..1]
LEFT OUTER JOIN I_SpecialGLCode AS _SpecialGLCode ON SpecialGLCode = _SpecialGLCode.SpecialGLCode AND _SpecialGLCode.FinancialAccountType = 'D'  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _IssuerName ON Issuer = _IssuerName.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _CounterpartyName ON Counterparty = _CounterpartyName.BusinessPartner  -- association [0..1]
;