I_CashDocumentChainTraceResult

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_CashDocumentChainTraceResult.
-- 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_CashDocumentChainTraceResult AS
SELECT
  result_uuid AS ChainResultUUID,
  current_step AS DocumentChainCurrentStep,
  trace_uuid AS ChainTraceUUID,
  parent_step AS ParentStep,
  bukrs AS CompanyCode,
  gjahr AS FiscalYear,
  belnr AS AccountingDocument,
  cast( buzei as fqm_buzei preserving type ) AS AccountingDocumentItem,
  fkont AS GeneralLedgerClassification,
  forward_type AS OffsettingType,
  paired_dmbtr AS AmountInCompanyCodeCurrency,
  hwaer AS CompanyCodeCurrency,
  paired_wmbtr AS AmountInTransactionCurrency,
  waers AS TransactionCurrency,
  chain_step AS CashDocumentChainStep,
  is_final AS CashFlowIsFinal,
  trm_product_type AS CashProductType,
  trm_transaction_type AS FinancialTransactionType,
  trm_activity_category AS TreasuryActivityCategory,
  trm_security_id AS SecurityClass,
  trm_security_account AS SecurityAccount,
  trm_portfolio AS Portfolio,
  contract_number AS CashContractNumber,
  fi_account AS GLAccount,
  house_bank AS HouseBank,
  house_bank_account AS HouseBankAccount,
  bank_account_id AS BankAccountInternalID,
  customer_number AS Customer,
  vendor_number AS Supplier,
  Partner,
  Material,
  business_area AS BusinessArea,
  profit_center AS ProfitCenter,
  cost_center AS CostCenter,
  trading_partner AS PartnerCompany,
  liquidity_item AS LiquidityItem,
  Segment,
  cast( assigned_company_code as fqm_assigned_company_code preserving type ) AS AssignedCompanyCode,
  internal_reference AS DocumentReferenceID,
  characteristics AS CashCharacteristic,
  assignment AS AssignmentReference,
  local_last_changed_at AS LocalLastChangedAtDateTime
FROM fclm_fb2_trcrt
LEFT OUTER JOIN I_CashChainTrace AS _Trace ON ChainTraceUUID = _Trace.ChainTraceUUID  -- association [1..1]
LEFT OUTER JOIN I_CashDocumentChainTraceResult AS _Parent ON ChainTraceUUID = _Parent.ChainTraceUUID AND ParentStep = _Parent.DocumentChainCurrentStep  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_LiquidityItemText AS _LiquidityItemText ON LiquidityItem = _LiquidityItemText.LiquidityItem  -- association [0..*]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_OffsettingTypeText AS _OffsettingTypeText ON OffsettingType = _OffsettingTypeText.OffsettingType  -- association [0..*]
LEFT OUTER JOIN I_CashGLClassificationText AS _GLClassificationText ON GeneralLedgerClassification = _GLClassificationText.GeneralLedgerClassification  -- association [0..*]
LEFT OUTER JOIN I_StepNameText AS _StepNameText ON DocumentChainInternalStep = _StepNameText.DocumentChainInternalStep  -- association [0..*]
LEFT OUTER JOIN I_GlAccountTextInCompanycode AS _Account ON GLAccount = _Account.GLAccount AND CompanyCode = _Account.CompanyCode  -- association [0..*]
LEFT OUTER JOIN I_BankAccount AS _BankAccount ON BankAccountInternalID = _BankAccount.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _AssignedCompanyCode ON AssignedCompanyCode = _AssignedCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _PartnerCompany ON PartnerCompany = _PartnerCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _Material ON Material = _Material.Material  -- association [0..*]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..*]
;