C_IHBPaymentMonitorTP

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_IHBPaymentMonitorTP.
-- 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_IHBPaymentMonitorTP AS
SELECT
  IHBPostingUUID,
  PaymentItemUUID,
  PaymentItemNumber,
  _IHBAccount.IHBAccountNumber AS IHBAccountNumber,
  IHBPostingDateTime,
  IHBValueDateTime,
  tstmp_to_dats(IHBPostingDateTime,'',$session.client,'NULL') AS PostingDate,
  tstmp_to_dats(IHBValueDateTime,'',$session.client,'NULL') AS ValueDate,
  IHBTransactionStatus,
  _IHBTransactionStatus.IHBTransactionStatusText AS IHBTransactionStatusText,
  IHBPostingDirection,
  _PostingCharacteristic[1:Language = $session.system_language ].IHBPostingCharacteristicText AS IHBPostingCharacteristicText,
  _IHBPaymentItemCategoryVH.PaymentItemCategoryText AS PaymentItemCategoryText,
  PaymentItemCategory,
  concat(PaymentItemObjectCategory, concat(PaymentItemDate, concat(PaymentItemNumber, ClearingArea))) AS PaymentItemTechnicalIdentifier,
  TransactionCurrency,
  AmountInTransactionCurrency,
  TransferCurrency,
  AmountInTransferCurrency,
  _IHBBankAreaText[1:IHBBankAreaLanguage = $session.system_language ].IHBBankAreaDescription AS IHBBankAreaDescription,
  IHBBankArea,
  IHBActivityType,
  _ActivityType.IHBActivityTypeDescription AS IHBActivityTypeDescription,
  IHBAcctFeeType,
  _FeeType.IHBFeeTypeText AS IHBFeeTypeText,
  APMInternalCreationProcess,
  _CreationProcess.APMInternalCreationProcessText AS APMInternalCreationProcessText,
  ClearingArea,
  IncomingPaymentOrderNumber,
  IncomingPaymentOrderDate,
  OutgoingPaymentOrderNumber,
  OutgoingPaymentOrderDate,
  PaymentItemDate,
  TransactionType,
  CustomerSegment,
  _APMItmLdgrTransf.AccountingDocument AS AccountingDocument,
  _APMItmLdgrTransf.FiscalYear AS FiscalYear,
  _APMItmLdgrTransf.CompanyCode AS IHBBankAreaCompanyCode,
  IHBLedgerTransferStatus,
  CompanyCode,
  OrderingCompanyCode,
  APMPaymentItemOffsetLinkValue,
  CreationUserName,
  CreationDate,
  _AccountingNotification.AccountingNotificationUUID AS AccountingNotificationUUID,
  FinanceNotificationUUID
FROM I_IHBTransactionItemCmpst
LEFT OUTER JOIN I_IHBItemSensitiveFlag AS _ItemSensitiveFlag ON ClearingArea = _ItemSensitiveFlag.ClearingArea AND PaymentItemDate = _ItemSensitiveFlag.PaymentItemDate AND PaymentItemNumber = _ItemSensitiveFlag.PaymentItemNumber  -- association [0..1]
LEFT OUTER JOIN C_APMCreationProcessVH AS _CreationProcess ON APMInternalCreationProcess = _CreationProcess.APMInternalCreationProcess  -- association [0..1]
LEFT OUTER JOIN C_IHBActivityTypeVH AS _ActivityType ON IHBActivityType = _ActivityType.IHBActivityType  -- association [0..1]
LEFT OUTER JOIN C_IHBFeeTypeVH AS _FeeType ON IHBAcctFeeType = _FeeType.IHBAcctFeeType  -- association [0..1]
LEFT OUTER JOIN I_IHBBankAreaT AS _IHBBankAreaText ON IHBBankArea = _IHBBankAreaText.IHBBankArea  -- association [0..*]
LEFT OUTER JOIN C_IHBTransactionStatusVH AS _IHBTransactionStatus ON IHBTransactionStatus = _IHBTransactionStatus.IHBTransactionStatus  -- association [0..1]
LEFT OUTER JOIN I_IHBPostgCharacteristicText AS _PostingCharacteristic ON IHBPostingDirection = _PostingCharacteristic.IHBPostingCharacteristic  -- association [0..*]
LEFT OUTER JOIN C_IHBPaymentItemCategoryVH AS _IHBPaymentItemCategoryVH ON PaymentItemCategory = _IHBPaymentItemCategoryVH.PaymentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_AccountingNotification AS _AccountingNotification ON FinanceNotificationUUID = _AccountingNotification.FinanceNotificationUUID  -- association [1..1]
;