C_MemoRecordObjPgTP

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_MemoRecordObjPgTP.
-- 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_MemoRecordObjPgTP AS
SELECT
  MemoRecord,
  MemoRecordDescription,
  CompanyCode,
  MemoRecordCategory,
  MemoRecordType,
  MemoRecordBalanceDateDimension,
  MemoRecordType AS MemoRecordTypeForCreate,
  PlanningLevel,
  TransactionDate,
  MemoRecordExpirationDateTime,
  MemoRecordStatus_2,
  BankAccountInternalID,
  AmountInTransactionCurrency,
  TransactionCurrency,
  AmountInCompanyCodeCurrency,
  CompanyCodeCurrency,
  CashFlowReconciliationBundle,
  CashPlanningGroup,
  LiquidityItem,
  BankStatementShortID,
  BankStatementItem,
  BankStatement,
  MemoRecordImport,
  GLAccount,
  PostingDate,
  ProfitCenter,
  Fund,
  GrantID,
  MemoRecordStatisticsIndicator,
  MemoRecordCharacteristic,
  MemoRecordInternalReference,
  BankStatementDate,
  HouseBank,
  HouseBankAccount,
  CreationDate,
  LastChangeDate,
  MemoRecordStatus,
  MemoRecordStatusCriticality,
  MemoRecdExprtnCritlty,
  ControllingArea,
  FinancialManagementArea,
  ProfitCenterValidityEndDate,
  _BankAccount.BankAccountNumber AS BankAccountNumber,
  cast( _OffsetBankAccount.BankAccountNumber as fclm_mr_mmrd_offset_acc_num preserving type ) AS MemoRecdOffstgBkAcctNmbr,
  MemoRecdOffstgBkAcctInternalID,
  MemoRecdOffsettingCompanyCode,
  OffsettingMemoRecord,
  MemoRecordOffsettingHouseBank,
  MemoRecdOffstgHouseBankAccount,
  MemoRecdOffstgTransactionDate,
  MemoRecordPairingReason,
  MemoRecordIsLeadingDocument,
  virtual UICT_FUNDISHIDDEN : abap_boolean AS virtualUICT_FUNDISHIDDENabap_boolean,
  virtual UICT_GRANTIDISHIDDEN : abap_boolean AS virtualUICT_GRANTIDISHIDDENabap_boolean,
  virtual MemoRecordCriticality: int1 AS virtualMemoRecordCriticalityint1,
  _GrantText.GrantName as GrantName : localized AS GrantNameasGrantNamelocalized,
  _GLAccountTextInCompanyCode.GLAccountName as GLAccountName : localized AS GLAccountNameasGLAccountNamelocalized,
  _FundText.FundName as FundName : localized AS FundNameasFundNamelocalized,
  CompanyCodeName,
  MemoRecdOffstgCoCodeName,
  LastChangeDateTime,
  CreatedByUser,
  CreationDateTime,
  LastChangeByUser,
  LocalLastChangeDateTime,
  _CreatedBy.FullName AS CreatedByUserFullName,
  _ChangedBy.FullName AS LastChangedByUserFullName
FROM R_MemoRecordTP
;