C_IHBAccountPaymentItemTP

DDL: C_IHBACCOUNTPAYMENTITEMTP Type: view_entity CONSUMPTION
31 Fields 1 Data Sources 6 Associations

IHB Account Payment Item Consumption

C_IHBAccountPaymentItemTP is a Consumption CDS View that provides data about "IHB Account Payment Item Consumption" in SAP S/4HANA. It reads from 1 data source (I_IHBTransactionItemCmpst) and exposes 31 fields with key field IHBPostingUUID. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_IHBTransactionItemCmpst I_IHBTransactionItemCmpst from

Associations (6)

CardinalityTargetAliasCondition
[0..1] C_IHBAccountPaymentItemStatVH _IHBAccountPaymentItemIHBStat $projection.IHBPaymentItemStatus = _IHBAccountPaymentItemIHBStat.IHBPaymentItemIHBStatus
[0..1] /PF1/C_VH_TRANSTYPE _transType $projection.TransactionType = _transType.TransactionType and $projection.ClearingArea = _transType.ClearingArea
[0..1] I_IHBBkStatementCmpst _IHBBKSTATEMENTCMPST $projection.IHBBankStatementUUID = _IHBBKSTATEMENTCMPST.IHBStmntUUID
[0..1] /PF1/I_DRB_PI _i_drb_pi $projection.ClearingArea = _i_drb_pi.clearing_area and $projection.PaymentItemDate = _i_drb_pi.pi_date and $projection.PaymentItemNumber = _i_drb_pi.pi_no and $projection.IHBPostingDirection = _i_drb_pi.process
[0..*] I_IHBTransactionStatusText _IHBTransactionStatus $projection.IHBTransactionStatus = _IHBTransactionStatus.IHBTransactionStatus
[0..*] I_IHBPostgCharacteristicText _PostingCharacteristic $projection.IHBPostingDirection = _PostingCharacteristic.IHBPostingCharacteristic

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label IHB Account Payment Item Consumption view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY IHBPostingUUID IHBPostingUUID
PaymentItemUUID PaymentItemUUID
IHBAccountUUID IHBAccountUUID Account ID
ClearingArea ClearingArea Clearing Area
PaymentItemDate PaymentItemDate
PaymentItemNumber PaymentItemNumber
PaymentItemCategory PaymentItemCategory
PaymentItemObjectCategory PaymentItemObjectCategory
PostingDate
AmountInTransactionCurrency AmountInTransactionCurrency Amount in Transaction Currency
TransactionCurrency TransactionCurrency Transaction Currency
AmountInTransferCurrency AmountInTransferCurrency Amount in Account Currency
TransferCurrency TransferCurrency
CustomerSegment CustomerSegment
IHBBankArea IHBBankArea Bank Area
IHBPaymentItemStatus IHBPaymentItemStatus
IHBAccountPaymentItemStatusTxt _IHBAccountPaymentItemIHBStat IHBAccountPaymentItemStatusTxt
TransactionType TransactionType Trans. Type - Header
TransactionTypeDescription _transType TransactionTypeDesc
IHBTransactionStatus IHBTransactionStatus
IHBTransactionStatusText Transaction Direction Status Description
IHBPostingDirection IHBPostingDirection Posting Characteristic
IHBPostingCharacteristicText Posting Characteristic Description
PaymentItemTechnicalIdentifier Technical Identifier
IHBBankStatementUUID IHBBankStatementUUID
IHBStmntYear _IHBBKSTATEMENTCMPST IHBStmntYear Statement Year
IHBAccountStmntNumber _IHBBKSTATEMENTCMPST IHBAccountStmntNumber
AccountingDocument _i_drb_pi belnr SD Document
FiscalYear _i_drb_pi gjahr Settlement Year
CompanyCode _i_drb_pi rbukrs Company Code
_IHBTransactionStatus _IHBTransactionStatus

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_IHBAccountPaymentItemTP.
-- 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_IHBAccountPaymentItemTP AS
SELECT
  IHBPostingUUID,
  PaymentItemUUID,
  IHBAccountUUID,
  ClearingArea,
  PaymentItemDate,
  PaymentItemNumber,
  PaymentItemCategory,
  PaymentItemObjectCategory,
  tstmp_to_dats( IHBPostingDateTime,'', $session.client, 'NULL' ) AS PostingDate,
  AmountInTransactionCurrency,
  TransactionCurrency,
  AmountInTransferCurrency,
  TransferCurrency,
  CustomerSegment,
  IHBBankArea,
  IHBPaymentItemStatus,
  _IHBAccountPaymentItemIHBStat.IHBAccountPaymentItemStatusTxt AS IHBAccountPaymentItemStatusTxt,
  TransactionType,
  _transType.TransactionTypeDesc AS TransactionTypeDescription,
  IHBTransactionStatus,
  _IHBTransactionStatus[1:Language = $session.system_language ].IHBTransactionStatusText AS IHBTransactionStatusText,
  IHBPostingDirection,
  _PostingCharacteristic[1:Language = $session.system_language ].IHBPostingCharacteristicText AS IHBPostingCharacteristicText,
  concat( PaymentItemObjectCategory, concat(PaymentItemDate, concat(PaymentItemNumber, ClearingArea))) AS PaymentItemTechnicalIdentifier,
  IHBBankStatementUUID,
  _IHBBKSTATEMENTCMPST.IHBStmntYear AS IHBStmntYear,
  _IHBBKSTATEMENTCMPST.IHBAccountStmntNumber AS IHBAccountStmntNumber,
  _i_drb_pi.belnr AS AccountingDocument,
  _i_drb_pi.gjahr AS FiscalYear,
  _i_drb_pi.rbukrs AS CompanyCode
FROM I_IHBTransactionItemCmpst
LEFT OUTER JOIN C_IHBAccountPaymentItemStatVH AS _IHBAccountPaymentItemIHBStat ON IHBPaymentItemStatus = _IHBAccountPaymentItemIHBStat.IHBPaymentItemIHBStatus  -- association [0..1]
LEFT OUTER JOIN /PF1/C_VH_TRANSTYPE AS _transType ON TransactionType = _transType.TransactionType AND ClearingArea = _transType.ClearingArea  -- association [0..1]
LEFT OUTER JOIN I_IHBBkStatementCmpst AS _IHBBKSTATEMENTCMPST ON IHBBankStatementUUID = _IHBBKSTATEMENTCMPST.IHBStmntUUID  -- association [0..1]
LEFT OUTER JOIN /PF1/I_DRB_PI AS _i_drb_pi ON ClearingArea = _i_drb_pi.clearing_area AND PaymentItemDate = _i_drb_pi.pi_date AND PaymentItemNumber = _i_drb_pi.pi_no AND IHBPostingDirection = _i_drb_pi.process  -- association [0..1]
LEFT OUTER JOIN I_IHBTransactionStatusText AS _IHBTransactionStatus ON IHBTransactionStatus = _IHBTransactionStatus.IHBTransactionStatus  -- association [0..*]
LEFT OUTER JOIN I_IHBPostgCharacteristicText AS _PostingCharacteristic ON IHBPostingDirection = _PostingCharacteristic.IHBPostingCharacteristic  -- association [0..*]
;

Learn More