I_LeadingMemoRecord

DDL: I_LEADINGMEMORECORD SQL: ILDNGMEMORECORD Type: view BASIC
89 Fields 1 Data Sources

Basic View for Memo Record

I_LeadingMemoRecord is a Basic CDS View that provides data about "Basic View for Memo Record" in SAP S/4HANA. It reads from 1 data source (I_MemoRecord) and exposes 89 fields with key fields CashFlowID, ValidFrom.

Data Sources (1)

SourceAliasJoin Type
I_MemoRecord I_MemoRecord from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ILDNGMEMORECORD view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Basic View for Memo Record view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey CashFlowID view
Metadata.allowExtensions true view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view

Fields (89)

KeyFieldSource TableSource FieldDescription
KEY CashFlowID CashFlowID Flow ID
KEY ValidFrom ValidFrom Vers.Valid From
ValidTo ValidTo Vers.Valid To
OriginApplication OriginApplication Origin Application
CashFlowCategory CashFlowCategory Flow Category
MemoRecord MemoRecord Memo Record
OriginDocument OriginDocument Source Doc. ID
OriginFlowID OriginFlowID Source Flow ID
CompanyCode CompanyCode Receiver Company Code
PlanningLevel PlanningLevel Planning Level
TransactionDate TransactionDate Value Date
ExpirationDate ExpirationDate Expiratn Date
CashPlanningGroup CashPlanningGroup Planning Group
LiquidityItem LiquidityItem Liquidity Item
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
BusinessArea BusinessArea Business Area
ProfitCenter ProfitCenter Profit Center
Fund Fund Sender Fund
GrantID GrantID Sender Grant
BankStatement BankStatement Bank Statement No.
BankStatementDate BankStatementDate Statement Date
BankStatementShortID BankStatementShortID Statement Short Key
BankStatementItem BankStatementItem Memo Record No.
GLAccount GLAccount General Ledger
DocumentItemText DocumentItemText Text
Segment Segment Segment number
CashReleaseStatus CashReleaseStatus Release Status
CertaintyLevel CertaintyLevel
MemoRecordInternalReference MemoRecordInternalReference Reference
MemoRecordStatisticItem MemoRecordStatisticItem Statistics Ind.
BusinessPartner BusinessPartner Issuing Authority
FinancialInstrCharacteristic FinancialInstrCharacteristic Characteristics
HouseBank HouseBank House Bank
HouseBankAccount HouseBankAccount House Bank Account
MemoRecordStatus MemoRecordStatus Memo Record Status
BankAccountInternalID BankAccountInternalID Technical ID
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
TransactionCurrency TransactionCurrency Transaction Currency
AmountInLocalCurrency AmountInLocalCurrency Local Crcy Amt
LocalCurrency LocalCurrency Local Currency
OffsettingAccount OffsettingAccount Offsetting Acct
OffsettingCompanyCode OffsettingCompanyCode Company Code
OffsettingValueDate OffsettingValueDate Value date
OffstgBankAccountInternalID OffstgBankAccountInternalID Offset.Bank Acc
OffsetBankAccountNumber OffsetBankAccountNumber Account Number
OffsettingHouseBank OffsettingHouseBank House Bank
OffsettingHouseBankAccount OffsettingHouseBankAccount Account ID
CashCalendarTypeForFinInvmt CashCalendarTypeForFinInvmt Calendar Type
MemoRecordInterestRate MemoRecordInterestRate Interest rate
MemoRecordExchangeRateType MemoRecordExchangeRateType Exch. Rate Type
CashPaymentAdviceGroup CashPaymentAdviceGroup ID number (grp)
CashPaymentAdvicePairingReason CashPaymentAdvicePairingReason CM pairing
MemoRecordAssignment MemoRecordAssignment Assignment
MemoRecordPlanningType MemoRecordPlanningType Memo Recd Type
CashRequestStatus CashRequestStatus Request Status
CashReqInstrCategory CashReqInstrCategory Instrument Cat.
FollowingCurrency FollowingCurrency Following Crcy
AmountInFollowingCurrency AmountInFollowingCurrency Amount
TrsyTradedAmountBuySellCode TrsyTradedAmountBuySellCode Buy/Sell
ReceivingBankAccountIntID ReceivingBankAccountIntID
CashReqHasDocument CashReqHasDocument Documents Available
FinancialInstrumentAssignment FinancialInstrumentAssignment Assignment
FinancialInstrumentReference FinancialInstrumentReference Internal Ref.
BankIdentification BankIdentification Bank Details
CashRequestSubmittedByUser CashRequestSubmittedByUser Submitted By
TermStartDate TermStartDate Value date
TermEndDate TermEndDate Value date
LoanTermStartDate LoanTermStartDate Value date
LoanTermEndDate LoanTermEndDate Value date
MemoRecordBorrowInvestCode MemoRecordBorrowInvestCode Invest/Borrow
CshTrdReqFXLeg1ValueDate CshTrdReqFXLeg1ValueDate Value Date
CshTrdReqFXLeg1ReqdAmtInTDC CshTrdReqFXLeg1ReqdAmtInTDC Requested Amount
CshTrdReqFXLeg1OpenAmtInTDC CshTrdReqFXLeg1OpenAmtInTDC Open Amount
CshTrdReqFXLeg1TradedCurrency CshTrdReqFXLeg1TradedCurrency Requested Currency
CshTrdReqFXLeg1ReqdAmtInOTDC CshTrdReqFXLeg1ReqdAmtInOTDC Requested Opposite Amount (Forecasted)
CshTrdReqFXLeg1OpstTrddCrcy CshTrdReqFXLeg1OpstTrddCrcy Requested Opposite Currency
CshTrdReqFXLeg1SndgBkAcctIntID CshTrdReqFXLeg1SndgBkAcctIntID Sending Bank Account ID
CshTrdReqFXLeg1RcvgBkAcctIntID CshTrdReqFXLeg1RcvgBkAcctIntID Receiving Bank Account ID
CshTrdReqFXLeg2ValueDate CshTrdReqFXLeg2ValueDate Value Date (Leg 2)
CshTrdReqFXLeg2ReqdAmtInTDC CshTrdReqFXLeg2ReqdAmtInTDC Requested Amount (Leg 2)
CshTrdReqFXLeg2OpenAmtInTDC CshTrdReqFXLeg2OpenAmtInTDC Open Amount (Leg 2)
CshTrdReqFXLeg2TradedCurrency CshTrdReqFXLeg2TradedCurrency Requested Currency
CshTrdReqFXLeg2ReqdAmtInOTDC CshTrdReqFXLeg2ReqdAmtInOTDC Requested Opp. Amt (Forecasted, Leg 2)
CshTrdReqFXLeg2OpstTrddCrcy CshTrdReqFXLeg2OpstTrddCrcy Requested Opposite Currency
CshTrdReqFXLeg2SndgBkAcctIntID CshTrdReqFXLeg2SndgBkAcctIntID Sending Bank Account ID (Leg 2)
CshTrdReqFXLeg2RcvgBkAcctIntID CshTrdReqFXLeg2RcvgBkAcctIntID Receiving Bank Account ID (Leg 2)

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_LeadingMemoRecord.
-- 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: ILDNGMEMORECORD

CREATE VIEW I_LeadingMemoRecord AS
SELECT
  CashFlowID,
  ValidFrom,
  ValidTo,
  OriginApplication,
  CashFlowCategory,
  MemoRecord,
  OriginDocument,
  OriginFlowID,
  CompanyCode,
  PlanningLevel,
  TransactionDate,
  ExpirationDate,
  CashPlanningGroup,
  LiquidityItem,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  BusinessArea,
  ProfitCenter,
  Fund,
  GrantID,
  BankStatement,
  BankStatementDate,
  BankStatementShortID,
  BankStatementItem,
  GLAccount,
  DocumentItemText,
  Segment,
  CashReleaseStatus,
  CertaintyLevel,
  MemoRecordInternalReference,
  MemoRecordStatisticItem,
  BusinessPartner,
  FinancialInstrCharacteristic,
  HouseBank,
  HouseBankAccount,
  MemoRecordStatus,
  BankAccountInternalID,
  AmountInTransactionCurrency,
  TransactionCurrency,
  AmountInLocalCurrency,
  LocalCurrency,
  OffsettingAccount,
  OffsettingCompanyCode,
  OffsettingValueDate,
  OffstgBankAccountInternalID,
  OffsetBankAccountNumber,
  OffsettingHouseBank,
  OffsettingHouseBankAccount,
  CashCalendarTypeForFinInvmt,
  MemoRecordInterestRate,
  MemoRecordExchangeRateType,
  CashPaymentAdviceGroup,
  CashPaymentAdvicePairingReason,
  MemoRecordAssignment,
  MemoRecordPlanningType,
  CashRequestStatus,
  CashReqInstrCategory,
  FollowingCurrency,
  AmountInFollowingCurrency,
  TrsyTradedAmountBuySellCode,
  ReceivingBankAccountIntID,
  CashReqHasDocument,
  FinancialInstrumentAssignment,
  FinancialInstrumentReference,
  BankIdentification,
  CashRequestSubmittedByUser,
  TermStartDate,
  TermEndDate,
  LoanTermStartDate,
  LoanTermEndDate,
  MemoRecordBorrowInvestCode,
  CshTrdReqFXLeg1ValueDate,
  CshTrdReqFXLeg1ReqdAmtInTDC,
  CshTrdReqFXLeg1OpenAmtInTDC,
  CshTrdReqFXLeg1TradedCurrency,
  CshTrdReqFXLeg1ReqdAmtInOTDC,
  CshTrdReqFXLeg1OpstTrddCrcy,
  CshTrdReqFXLeg1SndgBkAcctIntID,
  CshTrdReqFXLeg1RcvgBkAcctIntID,
  CshTrdReqFXLeg2ValueDate,
  CshTrdReqFXLeg2ReqdAmtInTDC,
  CshTrdReqFXLeg2OpenAmtInTDC,
  CshTrdReqFXLeg2TradedCurrency,
  CshTrdReqFXLeg2ReqdAmtInOTDC,
  CshTrdReqFXLeg2OpstTrddCrcy,
  CshTrdReqFXLeg2SndgBkAcctIntID,
  CshTrdReqFXLeg2RcvgBkAcctIntID
FROM I_MemoRecord
;

Learn More