C_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 C_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 C_MemoRecordTP AS
SELECT
  memo.CashFlowID AS CashFlowID,
  memo.CashMemoRecordID AS CashMemoRecordID,
  memo.CompanyCode AS CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  memo.PlanningLevel AS PlanningLevel,
  memo.CashPlanningGroup AS CashPlanningGroup,
  memo.BankAccountInternalID AS BankAccountInternalID,
  memo.BankAccountRevision AS BankAccountRevision,
  memo.BankAccount AS BankAccount,
  memo.BankAccountDescription AS BankAccountDescription,
  memo.TransactionDate AS TransactionDate,
  memo.ExpirationDate AS ExpirationDate,
  memo.MemoRecordStatus AS MemoRecordStatus,
  _MemoRecordStatus.MemoRecordStatusCriticality AS MemoRecordStatusCriticality,
  memo.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  memo.TransactionCurrency AS TransactionCurrency,
  memo.LiquidityItem AS LiquidityItem,
  memo.LiquidityItemDescription AS LiquidityItemDescription,
  memo.BusinessArea AS BusinessArea,
  memo.ProfitCenter AS ProfitCenter,
  cast('' as fis_prctr_shorttext ) AS ProfitCenterName,
  memo.OffsettingCompanyCode AS OffsettingCompanyCode,
  _OffsettingCompanyCode.CompanyCodeName AS OffsettingCompanyCodeName,
  memo.OffsettingAccount AS OffsettingAccount,
  memo.OffsettingValueDate AS OffsettingValueDate,
  memo.OffsettingBankAccount AS OffsettingBankAccount,
  memo.OffsetBankAccountNumber AS OffsetBankAccountNumber,
  cast('' as fclm_bam_description ) AS OffsetBankAccountName,
  memo.OffsettingHouseBank AS OffsettingHouseBank,
  memo.OffsettingHouseBankAccount AS OffsettingHouseBankAccount,
  memo.BankStatementDate AS BankStatementDate,
  memo.BankStatementShortID AS BankStatementShortID,
  memo.Fund AS Fund,
  memo.GrantID AS GrantID,
  memo.CreatedByUser AS CreatedByUser,
  memo.CreatedByUserDescription AS CreatedByUserDescription,
  memo.CreationTime AS CreationTime,
  memo.LastChangedByUser AS LastChangedByUser,
  memo.LastChangedByUserDescription AS LastChangedByUserDescription,
  memo.LastChangeDateTime AS LastChangeDateTime,
  memo.CashRequestSubmittedByUser AS CashRequestSubmittedByUser,
  CshTrdReqSubmdByUserIsHidden,
  memo.HouseBank AS HouseBank,
  memo.HouseBankAccount AS HouseBankAccount,
  memo.GLAccount AS GLAccount,
  memo.OwnerName AS OwnerName,
  memo.CertaintyLevel AS CertaintyLevel,
  _CertaintyLevelText.CertaintyLevelName AS CertaintyLevelName,
  memo.OriginApplication AS OriginApplication,
  memo.CashFlowCategory AS CashFlowCategory,
  memo.CashFlowType AS CashFlowType,
  memo.IsDeleted AS IsDeleted,
  memo.CustomerFactoryCalenderCode AS CustomerFactoryCalenderCode,
  memo.EffectiveInterestRate AS EffectiveInterestRate,
  memo.TermStartDate AS TermStartDate,
  memo.TextDescription AS TextDescription,
  memo.IsStatisticalItem AS IsStatisticalItem,
  _StatisticalItemText.StatisticalItemText AS StatisticalItemText,
  memo.Segment AS Segment,
  memo.CashReleaseStatus AS CashReleaseStatus,
  memo.CashReleaseStatusText AS CashReleaseStatusText,
  TreasuryTradeRequest,
  CashRequestStatus,
  CashRequestStatusDesc,
  CashReqInstrCategory,
  CashReqInstrCategoryDesc,
  CashReqValueDate,
  TrsyTradedAmountBuySellCode,
  CashReqCompanyCode,
  CashReqCompanyCodeName,
  TradedCurrency,
  AmountInTradedCurrency,
  FollowingCurrency,
  AmountInFollowingCurrency,
  OpenAmountInTradedCurrency,
  OpenAmountInFollowingCurrency,
  SendingBankAccountIntID,
  SendingBankAccountName,
  ReceivingBankAccountIntID,
  ReceivingBankAccountName,
  BusinessPartner,
  BusinessPartnerName,
  BankIdentification,
  FinancialInstrumentAssignment,
  FinancialInstrAssignmentDesc,
  FinancialInstrumentReference,
  FinancialInstrReferenceDesc,
  FinancialInstrCharacteristic,
  FinancialInstrCharcDesc,
  CashReqLiquidityItem,
  CashReqLiquidityItemName,
  CashReqPlanningLevel,
  _CashReqPlanningLevelText.PlanningLevelName AS CashReqPlanningLevelName,
  CashReqHasDocument,
  TrsyTradeReqCancellationReason,
  TrsyTradeReqCanclnRsnName,
  CashRequestText,
  AdditionalCurrency1,
  AdditionalCurrency2,
  TrsyCshFlowDebtInvmtCode,
  TermEndDate,
  LoanTermStartDate,
  LoanTermEndDate,
  OffstgBankAccountInternalID,
  CashPaymentAdviceGroup,
  CshTrdReqFXLeg1BuySellCode,
  CshTrdReqFXLeg1ValueDate,
  CshTrdReqFXLeg1ReqdAmtInTDC,
  CshTrdReqFXLeg1ReqdAmtInOTDC,
  CshTrdReqFXLeg1OpenAmtInTDC,
  CshTrdReqFXLeg1OpenAmtInOTDC,
  CshTrdReqFXLeg1TradedCurrency,
  CshTrdReqFXLeg1OpstTrddCrcy,
  CshTrdReqFXLeg1SndgBkAcctIntID,
  CshTrdReqFXLeg1RcvgBkAcctIntID,
  CshTrdReqFXLeg2BuySellCode,
  CshTrdReqFXLeg2ValueDate,
  CshTrdReqFXLeg2ReqdAmtInTDC,
  CshTrdReqFXLeg2ReqdAmtInOTDC,
  CshTrdReqFXLeg2OpenAmtInTDC,
  CshTrdReqFXLeg2OpenAmtInOTDC,
  CshTrdReqFXLeg2TradedCurrency,
  CshTrdReqFXLeg2OpstTrddCrcy,
  CshTrdReqFXLeg2SndgBkAcctIntID,
  CshTrdReqFXLeg2RcvgBkAcctIntID
FROM I_MemoRecordTP AS memo
LEFT OUTER JOIN I_MemoRecordStatus AS _MemoRecordStatus ON MemoRecordStatus = _MemoRecordStatus.MemoRecordStatus AND _MemoRecordStatus.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN C_BankAcctIdVH AS _BankAcctIDVH ON BankAccountInternalID = _BankAcctIDVH.BankAccountInternalID AND BankAccount = _BankAcctIDVH.BankAccountNumber AND HouseBank = _BankAcctIDVH.HouseBank AND HouseBankAccount = _BankAcctIDVH.HouseBankAccount AND CompanyCode = _BankAcctIDVH.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccountVH AS _BankAcctVH ON BankAccountInternalID = _BankAcctVH.BankAccountInternalID AND BankAccount = _BankAcctVH.BankAccount AND HouseBank = _BankAcctVH.HouseBank AND HouseBankAccount = _BankAcctVH.HouseBankAccount AND CompanyCode = _BankAcctVH.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PlanningLevelVH AS _PlanningLevelVH ON PlanningLevel = _PlanningLevelVH.PlanningLevel  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedBy ON CreatedByUser = _CreatedBy.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _SubmittedBy ON CashRequestSubmittedByUser = _SubmittedBy.ContactCardID  -- association [0..1]
LEFT OUTER JOIN C_BankAcctIdVH AS _RcvgBankAcctIDVH ON ReceivingBankAccountIntID = _RcvgBankAcctIDVH.BankAccountInternalID AND ReceivingBankAccount = _RcvgBankAcctIDVH.BankAccountNumber AND CashReqCompanyCode = _RcvgBankAcctIDVH.CompanyCode AND AdditionalCurrency2 = _RcvgBankAcctIDVH.BankAccountCurrency  -- association [0..1]
LEFT OUTER JOIN C_BankAcctIdVH AS _SndgBankAcctIDVH ON SendingBankAccountIntID = _SndgBankAcctIDVH.BankAccountInternalID AND SendingBankAccount = _SndgBankAcctIDVH.BankAccountNumber AND CashReqCompanyCode = _SndgBankAcctIDVH.CompanyCode AND AdditionalCurrency1 = _SndgBankAcctIDVH.BankAccountCurrency  -- association [0..1]
LEFT OUTER JOIN I_PlanningLevel AS _CashReqPlanningLevel ON CashReqPlanningLevel = _CashReqPlanningLevel.PlanningLevel  -- association [0..1]
LEFT OUTER JOIN I_PlanningLevelText AS _CashReqPlanningLevelText ON CashReqPlanningLevel = _CashReqPlanningLevelText.PlanningLevel AND _CashReqPlanningLevelText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerBank AS _BusinessPartnerBank ON BusinessPartner = _BusinessPartnerBank.BusinessPartner AND BankIdentification = _BusinessPartnerBank.BankIdentification  -- association [0..1]
LEFT OUTER JOIN I_FinancialInstrAssignment AS _FinInstrAssignment ON FinancialInstrumentAssignment = _FinInstrAssignment.FinancialInstrumentAssignment  -- association [0..1]
LEFT OUTER JOIN I_FinancialInstrReference AS _FinInstrReference ON FinancialInstrumentReference = _FinInstrReference.FinancialInstrumentReference  -- association [0..1]
LEFT OUTER JOIN I_FinancialInstrCharacteristic AS _FinInstrCharc ON FinancialInstrCharacteristic = _FinInstrCharc.FinancialInstrCharacteristic  -- association [0..1]
LEFT OUTER JOIN I_CashReqInstrCategory AS _CashReqInstrCategory ON CashReqInstrCategory = _CashReqInstrCategory.CashReqInstrCategory  -- association [0..1]
LEFT OUTER JOIN I_CashRequestStatus AS _CashRequestStatus ON CashRequestStatus = _CashRequestStatus.CashRequestStatus  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccountVH AS _HouseBankVH ON BankAccountInternalID = _HouseBankVH.BankAccountInternalID AND BankAccount = _HouseBankVH.BankAccountNumber AND CompanyCode = _HouseBankVH.CompanyCode AND HouseBank = _HouseBankVH.HouseBank AND HouseBankAccount = _HouseBankVH.HouseBankAccount  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccountVH AS _OffsettingBankVH ON OffsetBankAccountNumber = _OffsettingBankVH.BankAccountNumber AND OffsettingCompanyCode = _OffsettingBankVH.CompanyCode AND OffsettingHouseBank = _OffsettingBankVH.HouseBank AND OffsettingHouseBankAccount = _OffsettingBankVH.HouseBankAccount  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _OffsettingCompanyCode ON OffsettingCompanyCode = _OffsettingCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_HouseBankText AS _OffsettingHouseBank ON OffsettingCompanyCode = _OffsettingHouseBank.CompanyCode AND OffsettingHouseBank = _OffsettingHouseBank.HouseBank AND OffsettingHouseBankAccount = _OffsettingHouseBank.HouseBankAccount AND _OffsettingHouseBank.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerVH AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_MemoRecordCertaintyLevelText AS _CertaintyLevelText ON CertaintyLevel = _CertaintyLevelText.CertaintyLevel AND _CertaintyLevelText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_StatisticalItemText AS _StatisticalItemText ON IsStatisticalItem = _StatisticalItemText.MemoRecordStatisticItem AND _StatisticalItemText.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]
LEFT OUTER JOIN I_LiquidityItemText AS _LiquidityItemText ON LiquidityItem = _LiquidityItemText.LiquidityItem AND _LiquidityItemText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FundText AS _FundText ON Fund = _FundText.Fund AND _FundText.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN I_GrantText AS _GrantText ON GrantID = _GrantText.GrantID AND _GrantText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea AND _BusinessAreaText.Language = $session.system_language  -- association [0..1]
;