P_TractAccitem

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 P_TractAccitem.
-- 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: PTRACTACCITEM

CREATE VIEW P_TractAccitem AS
SELECT
  accitem.document_guid AS DocumentUUID,
  accitem.item_number AS AccountingDocumentItemRef,
  accitem.pc_guid AS PosContexUUID,
  accitem.dis_flowtype AS TreasuryUpdateType,
  cast(_TreasuryUpdateTypeText.TreasuryUpdateTypeName as ftr_gen_update_type_name preserving type) AS TreasuryUpdateTypeName,
  accitem.szart AS IsUsedInPaymentTransaction,
  accitem.aa_ref AS TreasuryGLAccountAssignmentRef,
  accitem.acc_symbol AS TreasuryGLAccountSymbol,
  cast(_TreasuryGLAccountSymbolText.TreasuryGLAccountSymbolName as ftr_gen_account_symbol_name preserving type) AS TreasuryGLAccountSymbolName,
  cast(accitem.posting_cat as ftr_gen_posting_category preserving type) AS TreasuryPostingCategory,
  _TreasuryPostingCategoryText.TreasuryPostingCategoryName AS TreasuryPostingCategoryName,
  accitem.posting_key AS PostingKey,
  _PostingKeyT.PostingKeyName AS PostingKeyName,
  accitem.gl_account AS GLAccount,
  cast(accitem.position_amt as ftr_gen_amount_position_crcy preserving type) AS AmountInPositionCurrency,
  cast(accitem.position_curr as ftr_gen_position_crcy preserving type) 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.logvo AS LogicalTransaction,
  accitem.blart AS JournalEntryType,
  _AccountingDocumentTypeText.AccountingDocumentTypeName AS AccountingDocumentTypeName,
  accitem.payment_date AS PaymentDate,
  accitem.kunnr AS Customer,
  accitem.zterm AS PaymentTerms,
  accitem.zlsch AS PaymentMethod,
  cast(_PaymentMethodText.text2 as farp_schzw_text preserving type) AS PaymentMethodName,
  accitem.uzawe AS PaymentMethodSupplement,
  cast (_PaymentMethodSupplementText.PaymentMethodSupplementName as ftr_gen_pymnt_meth_suppl_name preserving type) AS PaymentMethodSupplementName,
  accitem.zlspr AS PaymentBlockingReason,
  cast( _PaymentBlockingReasonText.PaymentBlockingReasonName as ftr_gen_pay_block_reason_name preserving type) AS PaymentBlockingReasonName,
  accitem.rpzahl AS PayerPayee,
  cast (_PayerPayee.PayerPayeeFullName as ftr_gen_payerpayee_full_name preserving type) AS PayerPayeeFullName,
  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,
  _CountryText.CountryName AS CountryName,
  accitem.allocnr AS AssignmentReference,
  cast(accitem.sgtxt as fis_sgtxt preserving type ) AS JournalEntryItemText,
  accitem.gsber AS BusinessArea,
  _BusinessAreaText.BusinessAreaName AS BusinessAreaName,
  accitem.kostl AS CostCenter,
  cast(accitem.rmvct as ftr_gen_transaction_type_fi preserving type ) AS FinancialTransactionType,
  cast(_FinancialTransactionTypeT.FinancialTransactionTypeName as ftr_gen_trans_type_fi_name preserving type ) AS FinancialTransactionTypeName,
  accitem.vbund AS PartnerCompany,
  _PartnerCompany.CompanyName AS CompanyName,
  cast (accitem.kontrahent as rkontrah_new preserving type ) AS Counterparty,
  cast(_Counterparty.BusinessPartnerFullName as ftr_gen_counterparty_full_name ) AS CounterpartyFullName,
  accitem.issuer AS Issuer,
  cast(_Issuer.BusinessPartnerFullName as ftr_gen_issuer_full_name ) AS IssuerFullName,
  accitem.sub_flow_number AS SubTraderFlowNumber,
  accitem.mndid AS SEPAMandate,
  accitem.spgl_ind AS SpecialGLCode,
  cast(_SpecialGLCodeText.SpecialGLCodeName as ftr_gen_special_gl_code_name) AS SpecialGLCodeName,
  accitem.payment_reason AS PaymentReason
FROM tract_accitem AS accitem
;