C_RecmddLiquidityItem

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_RecmddLiquidityItem.
-- 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: CRECMDDLQYITM

CREATE VIEW C_RecmddLiquidityItem AS
SELECT
  flow.OriginSystem AS OriginSystem,
  flow.OriginApplication AS OriginApplication,
  flow.OriginDocument AS OriginDocument,
  flow.OriginTransaction AS OriginTransaction,
  flow.OriginTransactionQualifier AS OriginTransactionQualifier,
  flow.CashFlow AS CashFlow,
  flow.CompanyCode AS CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  flow.TransactionDate AS TransactionDate,
  flow.LiquidityItem AS LiquidityItem,
  _LiquidityItem._Text[1:Language = $session.system_language].LiquidityItemName AS LiquidityItemName,
  flow.RecommendedLiquidityItem AS RecommendedLiquidityItem,
  _RecommendedLiquidityItem._Text[1:Language = $session.system_language].LiquidityItemName AS RecommendedLiquidityItemName,
  flow.DifferentLiquidityItem AS DifferentLiquidityItem,
  flow.LiquidityItemConfidenceRate AS LiquidityItemConfidenceRate,
  flow.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  flow.Currency AS Currency,
  case when flow.OriginApplication = 'BSEGV' then flow.AccountingDocument when flow.OriginApplication = 'CMMRD' then flow.OriginDocument end as ReferenceDocument AS OriginDocumentendasReferenceDocument,
  flow.DocumentItemText AS DocumentItemText,
  _BankAccount.Bank AS Bank,
  _BankAccount._Bank.BankName AS BankName,
  flow.BankAccountInternalID AS BankAccountInternalID,
  _BankAccount.BankAccountNumber AS BankAccountNumber,
  _BankAccount._Text[1:Language = $session.system_language].BankAccountDescription AS BankAccountDescription,
  flow.HouseBank AS HouseBank,
  flow.HouseBankAccount AS HouseBankAccount,
  flow.GLAccount AS GLAccount,
  _GLAccountText.GLAccountName AS GLAccountName,
  flow.CashPlanningGroup AS CashPlanningGroup,
  _PlanningGroup._Text[1:Language = $session.system_language].CashPlanningGroupName AS CashPlanningGroupName,
  flow.PlanningLevel AS PlanningLevel,
  flow.CostCenter AS CostCenter,
  flow.ProfitCenter AS ProfitCenter,
  flow.BusinessPartner AS BusinessPartner,
  _BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  flow.Customer AS Customer,
  _Customer.CustomerName AS CustomerName,
  flow.Supplier AS Supplier,
  _Supplier.SupplierName AS SupplierName,
  flow.Material AS Material,
  _MaterialText.MaterialName AS MaterialName,
  flow.WBSElement AS WBSElement,
  flow.PartnerCompany AS PartnerCompany,
  _Partnercompany.CompanyName AS TradingPartnerName,
  flow.Segment AS Segment,
  flow.BusinessArea AS BusinessArea
FROM P_RecLiquidityItem
LEFT OUTER JOIN I_CompanyCodeStdVH AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_PlanningLevel AS _PlanningLevel ON PlanningLevel = _PlanningLevel.PlanningLevel  -- association [0..1]
LEFT OUTER JOIN I_PlanningGroup AS _PlanningGroup ON CashPlanningGroup = _PlanningGroup.CashPlanningGroup  -- association [0..1]
LEFT OUTER JOIN I_LiquidityItem AS _RecommendedLiquidityItem ON RecommendedLiquidityItem = _RecommendedLiquidityItem.LiquidityItem  -- association [0..1]
LEFT OUTER JOIN I_LiquidityItem AS _LiquidityItem ON LiquidityItem = _LiquidityItem.LiquidityItem  -- association [0..1]
LEFT OUTER JOIN I_BankAccount AS _BankAccount ON BankAccountInternalID = _BankAccount.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_GlAccountTextInCompanycode AS _GLAccountText ON CompanyCode = _GLAccountText.CompanyCode AND GLAccount = _GLAccountText.GLAccount AND _GLAccountText.Language = $session.system_language  -- 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_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_Partnercompany AS _Partnercompany ON PartnerCompany = _Partnercompany.PartnerCompany  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PlanningLevelText AS _PlanningLevelText ON PlanningLevel = _PlanningLevelText.PlanningLevel AND _PlanningLevelText.Language = $session.system_language  -- association [0..1]
;