C_MemoRecordObjPgTP

DDL: C_MEMORECORDOBJPGTP Type: view_entity CONSUMPTION
49 Fields 1 Data Sources 1 OData Services

Manage Memo Record Transaction

C_MemoRecordObjPgTP is a Consumption CDS View that provides data about "Manage Memo Record Transaction" in SAP S/4HANA. It reads from 1 data source (R_MemoRecordTP) and exposes 49 fields with key field MemoRecord. It is exposed through 1 OData service (UI_MEMORECORD_MANAGE).

Data Sources (1)

SourceAliasJoin Type
R_MemoRecordTP R_MemoRecordTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Manage Memo Record Transaction view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
Search.searchable true view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

OData Services (1)

ServiceBindingVersionContractRelease
UI_MEMORECORD_MANAGE UI_MEMORECORD_MANAGE V4 C1 NOT_RELEASED

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY MemoRecord MemoRecord Memo Record
MemoRecordDescription MemoRecordDescription Text
CompanyCode CompanyCode Receiver Company Code
MemoRecordCategory MemoRecordCategory Memo Record Category
MemoRecordType MemoRecordType Memo Recd Type
MemoRecordTypeForCreate MemoRecordTypeForCreate Memo Recd Type
PlanningLevel PlanningLevel Planning Level
TransactionDate TransactionDate Value Date
ExpirationDate ExpirationDate Expiratn Date
MemoRecordStatus_2 MemoRecordStatus_2 Memo Record Status
BankAccountInternalID BankAccountInternalID Technical ID
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
TransactionCurrency TransactionCurrency Transaction Currency
CashFlowReconciliationBundle CashFlowReconciliationBundle Reconciliation Bundle
CashPlanningGroup CashPlanningGroup Planning Group
LiquidityItem LiquidityItem Liquidity Item
BankStatementShortID BankStatementShortID Statement Short Key
BankStatementItem BankStatementItem Memo Record No.
MemoRecordImport MemoRecordImport Memo Record Import ID
ProfitCenter ProfitCenter Profit Center
Fund Fund Sender Fund
GrantID GrantID Sender Grant
BusinessArea BusinessArea Business Area
MemoRecordStatisticsIndicator MemoRecordStatisticsIndicator Statistics Ind.
FinancialInstrCharacteristic FinancialInstrCharacteristic Characteristics
HouseBank HouseBank House Bank
HouseBankAccount HouseBankAccount House Bank Account
CreationDate CreationDate Time Stamp
LastChangeDate LastChangeDate Time Stamp
MemoRecordStatus MemoRecordStatus Memo Record Status
MemoRecordStatusCriticality MemoRecordStatusCriticality INT1
ControllingArea ControllingArea Controlling Area
FinancialManagementArea FinancialManagementArea FM Area
ProfitCenterValidityEndDate ProfitCenterValidityEndDate Valid To
BankAccountNumber _BankAccount BankAccountNumber Bank Account
virtualUICT_FUNDISHIDDENabap_boolean
virtualUICT_GRANTIDISHIDDENabap_boolean
GrantNameasGrantNamelocalized
FundNameasFundNamelocalized
CompanyCodeName CompanyCodeName Company Name
LastChangeDateTime LastChangeDateTime Timestamp
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangeByUser LastChangeByUser User Name
LocalLastChangeDateTime LocalLastChangeDateTime Time Stamp
_CreatedBy _CreatedBy
_ChangedBy _ChangedBy
CreatedByUserFullName _CreatedBy FullName Name
LastChangedByUserFullName _ChangedBy FullName Name

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,
  MemoRecordTypeForCreate,
  PlanningLevel,
  TransactionDate,
  ExpirationDate,
  MemoRecordStatus_2,
  BankAccountInternalID,
  AmountInTransactionCurrency,
  TransactionCurrency,
  CashFlowReconciliationBundle,
  CashPlanningGroup,
  LiquidityItem,
  BankStatementShortID,
  BankStatementItem,
  MemoRecordImport,
  ProfitCenter,
  Fund,
  GrantID,
  BusinessArea,
  MemoRecordStatisticsIndicator,
  FinancialInstrCharacteristic,
  HouseBank,
  HouseBankAccount,
  CreationDate,
  LastChangeDate,
  MemoRecordStatus,
  MemoRecordStatusCriticality,
  ControllingArea,
  FinancialManagementArea,
  ProfitCenterValidityEndDate,
  _BankAccount.BankAccountNumber AS BankAccountNumber,
  virtual UICT_FUNDISHIDDEN : abap_boolean AS virtualUICT_FUNDISHIDDENabap_boolean,
  virtual UICT_GRANTIDISHIDDEN : abap_boolean AS virtualUICT_GRANTIDISHIDDENabap_boolean,
  _GrantText.GrantName as GrantName : localized AS GrantNameasGrantNamelocalized,
  _FundText.FundName as FundName : localized AS FundNameasFundNamelocalized,
  CompanyCodeName,
  LastChangeDateTime,
  CreatedByUser,
  CreationDateTime,
  LastChangeByUser,
  LocalLastChangeDateTime,
  _CreatedBy.FullName AS CreatedByUserFullName,
  _ChangedBy.FullName AS LastChangedByUserFullName
FROM R_MemoRecordTP
;

Learn More