C_CashFlowSubItemTP

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 C_CashFlowSubItemTP.
-- 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: CCCFISUBITEMTP

CREATE VIEW C_CashFlowSubItemTP AS
SELECT
  flow.OriginSystem AS OriginSystem,
  flow.OriginTransactionValue AS OriginTransactionValue,
  flow.OriginApplication AS OriginApplication,
  flow.OriginDocument AS OriginDocument,
  flow.OriginFlowID AS OriginFlowID,
  flow.CashFlowSnapshotValue AS CashFlowSnapshotValue,
  flow.TransactionDate AS TransactionDate,
  flow.CashFlowID AS CashFlowID,
  flow.OriginTransactionQualifier AS OriginTransactionQualifier,
  flow.CashFlowScopeForAccounting AS CashFlowScopeForAccounting,
  flow.CashFlow AS CashFlow,
  flow.CompanyCode AS CompanyCode,
  flow._CompanyCode.CompanyCodeName AS CompanyCodeName,
  flow.Supplier AS Supplier,
  flow.Customer AS Customer,
  flow._Supplier.BPSupplierName AS BPSupplierName,
  flow._Customer.BPCustomerName AS BPCustomerName,
  cast( flow.AmountInTransactionCurrency as fclm_cp_trans_amount preserving type) AS AmountInTransactionCurrency,
  flow.TransactionCurrency AS TransactionCurrency,
  cast(flow.AmountInCompanyCodeCurrency as fis_hsl preserving type ) AS AmountInCompanyCodeCurrency,
  cast(flow.CompanyCodeCurrency as fis_hwaer preserving type ) AS CompanyCodeCurrency,
  flow.LiquidityItem AS LiquidityItem,
  flow.CostCenter AS CostCenter,
  flow.ProfitCenter AS ProfitCenter,
  flow.Segment AS Segment,
  flow.BusinessPartner AS BusinessPartner,
  flow.BusinessArea AS BusinessArea,
  flow.Fund AS Fund,
  flow._FundText[1:Language = $session.system_language].FundName AS FundName,
  flow.FinancialManagementArea AS FinancialManagementArea,
  flow.GrantID AS GrantID,
  flow._GrantText[1:Language = $session.system_language].GrantName AS GrantName,
  flow.PartnerCompany AS PartnerCompany,
  flow.HouseBank AS HouseBank,
  flow.HouseBankAccount AS HouseBankAccount,
  flow.BankAccountInternalID AS BankAccountInternalID,
  flow._BankAccount.BankAccountNumber AS BankAccountNumber,
  flow._BankAccount._Text[1:Language = $session.system_language].BankAccountDescription AS BankAccountDescription,
  _CompanyCode.ControllingArea AS ControllingArea,
  _CompanyCode._ControllingArea.ControllingAreaName AS ControllingAreaName,
  _LiquidityItem._Text[1:Language = $session.system_language].LiquidityItemName AS LiquidityItemName,
  _LiquidityItemText[1:Language = $session.system_language].LongText AS LiquidityItemDescription,
  flow.AssetContract AS AssetContract,
  flow.RelatedOriginApplication AS RelatedOriginApplication,
  flow.RelatedOriginTransactionID AS RelatedOriginTransactionID,
  flow.TreasuryBusinessTransaction AS TreasuryBusinessTransaction,
  cast( 'X' as abap_boolean ) AS UICT_TRMBusinessTransIsHidden
FROM I_CashFlowSubItemTP AS flow
LEFT OUTER JOIN C_CashFlowItemTP AS _CashFlow ON OriginSystem = _CashFlow.OriginSystem AND OriginTransactionValue = _CashFlow.OriginTransactionValue AND OriginApplication = _CashFlow.OriginApplication AND OriginDocument = _CashFlow.OriginDocument AND OriginFlowID = _CashFlow.OriginFlowID AND CashFlowSnapshotValue = _CashFlow.CashFlowSnapshotValue AND TransactionDate = _CashFlow.TransactionDate AND OriginTransactionQualifier = _CashFlow.OriginTransactionQualifier AND CashFlowScopeForAccounting = _CashFlow.CashFlowScopeForAccounting  -- association [1..1]
LEFT OUTER JOIN C_CashFlowItemSupplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN C_CashFlowItemCustomer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
;