I_MemoRecordTP

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_MemoRecordTP.
-- 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_MemoRecordTP AS
SELECT
  memo.CashFlowID AS CashFlowID,
  cast ( lpad(substring(memo.CashMemoRecordID,1,10),10,'0') as idenr) AS CashMemoRecordID,
  memo.CompanyCode AS CompanyCode,
  memo.PlanningLevel AS PlanningLevel,
  memo.TransactionDate AS TransactionDate,
  memo.ExpirationDate AS ExpirationDate,
  memo.CashPlanningGroup AS CashPlanningGroup,
  cast('0000' as fclm_revision preserving type ) AS BankAccountRevision,
  memo.TransactionCurrency AS TransactionCurrency,
  memo.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  memo.LiquidityItem AS LiquidityItem,
  _LiquidityItem.LiquidityItemName AS LiquidityItemDescription,
  memo.CreatedByUser AS CreatedByUser,
  cast('' as vdm_userdescription ) AS CreatedByUserDescription,
  memo.CreationTime AS CreationTime,
  memo.LastChangedByUser AS LastChangedByUser,
  cast('' as vdm_userdescription ) AS LastChangedByUserDescription,
  memo.LastChangeDateTime AS LastChangeDateTime,
  memo.BusinessArea AS BusinessArea,
  memo.ProfitCenter AS ProfitCenter,
  memo.Fund AS AssetFund,
  memo.GrantID AS AssetGrant,
  memo.Fund AS Fund,
  _CompanyCode.FinancialManagementArea AS FinancialManagementArea,
  memo.GrantID AS GrantID,
  memo.BankStatementShortID AS BankStatementShortID,
  memo.BankStatementDate AS BankStatementDate,
  memo.GLAccount AS GLAccount,
  memo.OwnerName AS OwnerName,
  memo.CertaintyLevel AS CertaintyLevel,
  memo.OriginApplication AS OriginApplication,
  memo.CashFlowCategory AS CashFlowCategory,
  memo.CashFlowType AS CashFlowType,
  memo.IsDeleted AS IsDeleted,
  memo.MemoRecordStatus AS MemoRecordStatus,
  memo.CustomerFactoryCalenderCode AS CustomerFactoryCalenderCode,
  memo.EffectiveInterestRate AS EffectiveInterestRate,
  memo.TermStartDate AS TermStartDate,
  memo.TextDescription AS TextDescription,
  memo.Segment AS Segment,
  memo.CashReleaseStatus AS CashReleaseStatus,
  _StatusText.CashReleaseStatusText AS CashReleaseStatusText,
  memo.OffsettingCompanyCode AS OffsettingCompanyCode,
  memo.OffsettingAccount AS OffsettingAccount,
  memo.OffsettingValueDate AS OffsettingValueDate,
  memo.OffsettingBankAccount AS OffsettingBankAccount,
  _OffstgBankAccount.BankAccountNumber AS OffsetBankAccountNumber,
  memo.OffsettingHouseBank AS OffsettingHouseBank,
  memo.OffsettingHouseBankAccount AS OffsettingHouseBankAccount,
  CashRequestStatus,
  _CashRequestStatusText.CashRequestStatusDesc AS CashRequestStatusDesc,
  CashReqInstrCategory,
  _CashReqInstrCategoryText.CashReqInstrCategoryDesc AS CashReqInstrCategoryDesc,
  FollowingCurrency,
  AmountInFollowingCurrency,
  TrsyTradedAmountBuySellCode,
  ReceivingBankAccountIntID,
  _RcvgBankAccount.BankAccountNumber AS ReceivingBankAccount,
  cast('' as fclm_bam_description ) AS ReceivingBankAccountName,
  CashReqHasDocument,
  FinancialInstrumentAssignment,
  _FinancialAssignmentText.FinancialInstrAssignmentDesc AS FinancialInstrAssignmentDesc,
  FinancialInstrumentReference,
  _FinancialReferenceText.FinancialInstrReferenceDesc AS FinancialInstrReferenceDesc,
  FinancialInstrCharacteristic,
  _FinancialInstrCharcText.FinancialInstrCharcDesc AS FinancialInstrCharcDesc,
  BankIdentification,
  BusinessPartner,
  _BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  memo.TransactionDate AS CashReqValueDate,
  memo.CompanyCode AS CashReqCompanyCode,
  _CashReqCompanyCode.CompanyCodeName AS CashReqCompanyCodeName,
  memo.TransactionCurrency AS TradedCurrency,
  memo.AmountInTransactionCurrency AS OpenAmountInTradedCurrency,
  memo.BankAccountInternalID AS SendingBankAccountIntID,
  _SndgBankAccount.BankAccountNumber AS SendingBankAccount,
  cast('' as fclm_bam_description ) AS SendingBankAccountName,
  memo.PlanningLevel AS CashReqPlanningLevel,
  memo.LiquidityItem AS CashReqLiquidityItem,
  _LiquidityItem.LiquidityItemName AS CashReqLiquidityItemName,
  cast('' as tpi_trade_request_id ) AS TreasuryTradeRequest,
  cast('' as tpi_cancel_reason ) AS TrsyTradeReqCancellationReason,
  cast('' as val_text ) AS TrsyTradeReqCanclnRsnName,
  memo.TextDescription AS CashRequestText,
  AmountInLocalCurrency AS AmountInTradedCurrency,
  OpenAmountInFollowingCurrency,
  IsStatisticalItem,
  TermEndDate,
  RequestedNetAmount,
  PurReqCurrency,
  TrsyCshFlowDebtInvmtCode,
  LoanTermStartDate,
  LoanTermEndDate,
  cast(case when CertaintyLevel = 'CSHRQ' then '' else 'X' end as abap_boolean) AS CshTrdReqSubmdByUserIsHidden,
  OffstgBankAccountInternalID,
  CashPaymentAdviceGroup,
  memo.CshTrdReqFXLeg1BuySellCode AS CshTrdReqFXLeg1BuySellCode,
  memo.CshTrdReqFXLeg1OpenAmtInOTDC AS CshTrdReqFXLeg1OpenAmtInOTDC,
  memo.CshTrdReqFXLeg2ValueDate AS CshTrdReqFXLeg2ValueDate,
  memo.CshTrdReqFXLeg2ReqdAmtInTDC AS CshTrdReqFXLeg2ReqdAmtInTDC,
  memo.CshTrdReqFXLeg2TradedCurrency AS CshTrdReqFXLeg2TradedCurrency,
  memo.CshTrdReqFXLeg2ReqdAmtInOTDC AS CshTrdReqFXLeg2ReqdAmtInOTDC,
  memo.CshTrdReqFXLeg2OpenAmtInOTDC AS CshTrdReqFXLeg2OpenAmtInOTDC,
  memo.CshTrdReqFXLeg2OpstTrddCrcy AS CshTrdReqFXLeg2OpstTrddCrcy,
  memo.CshTrdReqFXLeg2SndgBkAcctIntID AS CshTrdReqFXLeg2SndgBkAcctIntID,
  memo.CshTrdReqFXLeg2RcvgBkAcctIntID AS CshTrdReqFXLeg2RcvgBkAcctIntID
FROM I_MemoRecordWithFilter AS memo
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_BankAccountBasicData AS _OffstgBankAccount ON OffstgBankAccountInternalID = _OffstgBankAccount.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_LiquidityItemText AS _LiquidityItem ON LiquidityItem = _LiquidityItem.LiquidityItem AND _LiquidityItem.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CashReleaseStatusText AS _StatusText ON CashReleaseStatus = _StatusText.CashReleaseStatus  -- association [1..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_BankAccountBasicData AS _SndgBankAccount ON SendingBankAccountIntID = _SndgBankAccount.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_BankAccountBasicData AS _RcvgBankAccount ON ReceivingBankAccountIntID = _RcvgBankAccount.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_FinancialInstrAssignment AS _FinInstrAssignment ON FinancialInstrumentAssignment = _FinInstrAssignment.FinancialInstrumentAssignment  -- association [0..1]
LEFT OUTER JOIN I_FinancialInstrAssignmentText AS _FinancialAssignmentText ON FinancialInstrumentAssignment = _FinancialAssignmentText.FinancialInstrumentAssignment AND _FinancialAssignmentText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FinancialInstrReference AS _FinInstrReference ON FinancialInstrumentReference = _FinInstrReference.FinancialInstrumentReference  -- association [0..1]
LEFT OUTER JOIN I_FinancialInstrReferenceText AS _FinancialReferenceText ON FinancialInstrumentReference = _FinancialReferenceText.FinancialInstrumentReference AND _FinancialReferenceText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FinancialInstrCharacteristic AS _FinInstrCharc ON FinancialInstrCharacteristic = _FinInstrCharc.FinancialInstrCharacteristic  -- association [0..1]
LEFT OUTER JOIN I_FinancialInstrCharcText AS _FinancialInstrCharcText ON FinancialInstrCharacteristic = _FinancialInstrCharcText.FinancialInstrCharacteristic AND _FinancialInstrCharcText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CashReqCompanyCode ON CashReqCompanyCode = _CashReqCompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CashReqInstrCategory AS _CashReqInstrCategory ON CashReqInstrCategory = _CashReqInstrCategory.CashReqInstrCategory  -- association [0..1]
LEFT OUTER JOIN I_CashReqInstrCategoryText AS _CashReqInstrCategoryText ON CashReqInstrCategory = _CashReqInstrCategoryText.CashReqInstrCategory AND _CashReqInstrCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CashRequestStatus AS _CashRequestStatus ON CashRequestStatus = _CashRequestStatus.CashRequestStatus  -- association [0..1]
LEFT OUTER JOIN I_CashRequestStatusText AS _CashRequestStatusText ON CashRequestStatus = _CashRequestStatusText.CashRequestStatus AND _CashRequestStatusText.Language = $session.system_language  -- association [0..1]
;