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.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  flow.TransactionCurrency AS TransactionCurrency,
  cast(flow.AmountInCompanyCodeCurrency as fclm_cp_local_amount preserving type ) AS AmountInCompanyCodeCurrency,
  flow.CompanyCodeCurrency 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,
  _FundText[1:Language = $session.system_language].FundName AS FundName,
  flow.FinancialManagementArea AS FinancialManagementArea,
  flow.GrantID AS GrantID,
  _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,
  _LiquidityItemText[1:Language = $session.system_language].LongText AS LiquidityItemDescription,
  WBSElementInternalID,
  WBSElement,
  _WBSElement.WBSDescription AS WBSDescription,
  flow.AssetContract AS AssetContract
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]
LEFT OUTER JOIN I_FundText AS _FundText ON FinancialManagementArea = _FundText.FinancialManagementArea AND Fund = _FundText.Fund  -- association [0..*]
LEFT OUTER JOIN I_GrantText AS _GrantText ON GrantID = _GrantText.GrantID  -- association [0..*]
;