I_PaymentPlanItemDetails

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_PaymentPlanItemDetails.
-- 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.
-- SQL view name: IPAYTPLNITMDETS

CREATE VIEW I_PaymentPlanItemDetails AS
SELECT
  PaymentPlanItemDetails.fplnr AS PaymentPlan,
  PaymentPlanItemDetails.fpltr AS PaymentPlanItem,
  cast(ccins as vdm_epayt_type preserving type) AS ElectronicPaymentType,
  cast(ccnum as vdm_epayt_number preserving type) AS ElectronicPayment,
  cast(ccfol as vdm_epayt_suffix preserving type) AS ElectronicPaymentSequence,
  cast(datab as vdm_epayt_validfrom preserving type) AS EPaytValidityStartDate,
  cast(datbi as vdm_epayt_validto preserving type) AS EPaytValidityEndDate,
  cast(ccname as vdm_epayt_holder preserving type) AS ElectronicPaymentHolderName,
  cast(csour as vdm_epayt_entrymode preserving type) AS ElectronicPaymentEntryMode,
  cast(fksaf as vdm_epayt_billg_status preserving type) AS PaymentPlanRelatedBillgStatus,
  ccaua AS EPaytAuthorizationType,
  cast(autwr as vdm_epayt_authrdamount preserving type) AS AuthorizedAmountInAuthznCrcy,
  waers AS AuthorizationCurrency,
  cast(aunum as vdm_epayt_authznnumber preserving type) AS AuthorizationByDigitalPaytSrvc,
  cast(autra as vdm_epayt_authrefcode preserving type) AS AuthorizationByAcquirer,
  cast(audat as vdm_epayt_authzndate preserving type) AS AuthorizationDate,
  cast(autim as vdm_epayt_authzntime preserving type) AS AuthorizationTime,
  cast(merch as vdm_epayt_merchantid preserving type) AS MerchantByClearingHouse,
  cast(settl as vdm_epayt_settlement preserving type) AS ElectronicPaymentIsSettled,
  cast(trmid as vdm_epayt_terminal preserving type) AS ElectronicPaymentTerminal,
  cast(ccbtc as vdm_epayt_settlementrun preserving type) AS EPaytPaymentSettlement,
  cast(dp_token as vdm_epayt_token preserving type) AS EPaytByDigitalPaymentSrvc,
  dp_psp AS PaymentServiceProvider,
  dp_payid AS PaymentByPaymentServicePrvdr,
  dp_psp_transid AS TransactionByPaytSrvcPrvdr,
  dp_auth_rel_id AS PaymentCardAuthznRelationID,
  dp_trans_id AS DigitalPaymentTransID,
  cast(ccall as vdm_epayt_callstatus preserving type) AS ElectronicPaymentCallStatus,
  cast(react as vdm_epayt_authzncheckresponse preserving type) AS EPaytAuthorizationResult,
  cast(autwv as vdm_epayt_tobeauthrdamount preserving type) AS EPaytToBeAuthorizedAmount,
  cast(ccold as vdm_epayt_authznisexpired preserving type) AS EPaytAuthorizationIsExpired,
  cast(ccval as vdm_epayt_amountchanged preserving type) AS EPaytAmountIsChanged,
  cast(ccpre as vdm_epayt_preauthorization preserving type) AS PreauthorizationIsRequested,
  rtext AS AuthorizationStatusName,
  PaymentPlanItem.fakwr AS MaximumToBeAuthorizedAmount,
  waers AS TransactionCurrency,
  PaymentPlanItem.uelnr AS PaytPlnForAuthorizationItem,
  PaymentPlanItem.ueltr AS PaytPlnItmForAuthorizationItem,
  ueltr_a AS PaymentPlanAuthorizationItem
FROM fpltc AS PaymentPlanItemDetails
INNER JOIN fplt AS PaymentPlanItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PaymentPlan AS _PaymentPlan ON PaymentPlan = _PaymentPlan.PaymentPlan  -- association [1..1]
LEFT OUTER JOIN I_SDDocumentPaymentCardType AS _PaymentCardType ON ElectronicPaymentType = _PaymentCardType.PaymentCardType  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _AuthorizationCurrency ON AuthorizationCurrency = _AuthorizationCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _MaximumToBeAuthorizedCurrency ON TransactionCurrency = _MaximumToBeAuthorizedCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_PaymentCardMerchant AS _PaymentCardMerchant ON MerchantByClearingHouse = _PaymentCardMerchant.MerchantByClearingHouse  -- association [0..1]
LEFT OUTER JOIN I_BillingPlanRelatedBillgSts AS _BillingPlanRelatedBillgSts ON PaymentPlanRelatedBillgStatus = _BillingPlanRelatedBillgSts.BillingPlanRelatedBillgStatus  -- association [0..1]
LEFT OUTER JOIN I_ElectronicPaymentAuthznType AS _ElectronicPaymentAuthznType ON EPaytAuthorizationType = _ElectronicPaymentAuthznType.EPaytAuthorizationType  -- association [0..1]
;