I_CADocumentBPItemPaymentData

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_CADocumentBPItemPaymentData.
-- 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 I_CADocumentBPItemPaymentData AS
SELECT
  opbel AS CADocumentNumber,
  pygrp AS CAGroupingForPayment,
  ccins AS PaymentCardType,
  ccnum AS PaytCardByDigitalPaymentSrvc,
  ccfol AS PaymentCardSequenceNumber,
  datab AS PaymentCardValidityStartDate,
  datbi AS PaymentCardValidityEndDate,
  ccname AS PaymentCardHolderName,
  masked_id AS PaymentCardMaskedNumber,
  aunum AS CAAuthznByDigitalPaytSrvc,
  autra AS CAAuthorizationByAcquirer,
  audat AS AuthorizationDate,
  autim AS AuthorizationTime,
  auart AS CAAuthorizationType,
  autwr AS AuthorizedAmountInAuthznCrcy,
  ccwae AS AuthorizationCurrency,
  merch AS MerchantByClearingHouse,
  expdt AS AuthorizationExpirationDate,
  exptm AS AuthorizationExpirationTime,
  aucid AS CAPaymentIDAuthznWithBilling,
  avref AS CASettlementPaymentAdviceRef,
  dp_auth_rel_id AS PaymentCardAuthznRelationID,
  dp_fraud_risk AS DigitalPaymentFraudRisk,
  cguid AS PaymentCardUUID,
  enctp AS EncryptionType,
  xguid AS CAKeyForPaymentCardSupplement,
  pays_prov AS PaymentServiceProvider,
  pays_tran AS PaymentRefByPaytSrvcProvider,
  orig_pays_tran AS OriglPaytRefByPaytSrvcProvider,
  orig_credit AS OriginalSourceOfCredit,
  dp_payment_type AS DigitalPaymentType,
  dp_trans_id AS PaymentByDigitalPaymentService
FROM dfkkopc
LEFT OUTER JOIN I_CAAuthorizationType AS _CAAuthorizationType ON CAAuthorizationType = _CAAuthorizationType.CAAuthorizationType  -- association [0..1]
LEFT OUTER JOIN I_CADocumentHeader AS _DocHeader ON CADocumentNumber = _DocHeader.CADocumentNumber  -- association [1..1]
LEFT OUTER JOIN I_CACreditPostingOrigin AS _CACreditPostingOrigin ON OriginalSourceOfCredit = _CACreditPostingOrigin.OriginalSourceOfCredit  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _AuthorizationCurrency ON AuthorizationCurrency = _AuthorizationCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_PaytServiceProviderIdn AS _PaymentServiceProvider ON PaymentServiceProvider = _PaymentServiceProvider.PaymentServiceProvider  -- association [1..1]
;