I_PaymentPlanItemDetails

Payment Plan Item Details | view: IPAYTPLNITMDETS | TRAN | Extraction: Not supported | Component: Payment Cards
Tables used: FPLTFPLTC
Column Name Description
PaymentPlan FK Billing plan number / invoicing plan number
PaymentPlanItem FK Item for billing plan/invoice plan/payment cards
Column Name Description
💲 Currency Key (AuthorizationCurrency):
AuthorizedAmountInAuthznCrcy Electronic Payment: Authorized Amount
💲 Currency Key (TransactionCurrency):
EPaytToBeAuthorizedAmount Electronic Payment: Amount to Be Authorized
MaximumToBeAuthorizedAmount Value to be billed/calc. on date in billing/invoice plan
Column Name Description
Column Name Description
EPaytValidityStartDate Electronic Payment: Valid from
EPaytValidityEndDate Electronic Payment: Valid to
AuthorizationDate Electronic Payment: Authorization Date
AuthorizationTime Electronic Payment: Authorization Time
Column Name Description
ElectronicPaymentEntryMode Electronic Payment: Entry Mode Show values
PaymentPlanRelatedBillgStatus Billing Status of Payment Plan Show values
EPaytAuthorizationType Payment cards: Authorization type Show values
ElectronicPaymentIsSettled Electronic Payment: Settlement Carried Out Show values
ElectronicPaymentCallStatus Electronic Payment: Call Status Show values
EPaytAuthorizationResult Electronic Payment: Response to Authorization Checks Show values
EPaytAuthorizationIsExpired Electronic Payment: Authorization Expired Show values
EPaytAmountIsChanged Electronic Payment: Amount Changed Show values
PreauthorizationIsRequested Electronic Payment: Preauthorization Show values
Column Name Description Domain name
ElectronicPaymentSequence Electronic Payment: Payment Suffix CHAR10
ElectronicPaymentHolderName Electronic Payment: Name of Account Holder TEXT40
AuthorizationByDigitalPaytSrvc Electronic Payment: Authorization Number CHAR10
AuthorizationByAcquirer Electronic Payment: Authorization Reference Code CHAR15
ElectronicPaymentTerminal Electronic Payment: Terminal CHAR10
EPaytPaymentSettlement Electronic Payment: Settlement Run CCBTC
EPaytByDigitalPaymentSrvc Token for Digital Payment Integration in SD CCNUM
PaymentServiceProvider Payment Service Provider for Digital Payments DP_PAYMENT_SERVICE_PROVIDER
PaymentByPaymentServicePrvdr Digital Payments: Payment ID from Payment Service Provider DP_PAYID
TransactionByPaytSrvcPrvdr SAP Digital Payments: Transaction ID of PSP DP_PSP_TRANS_ID
PaymentCardAuthznRelationID Unique identifier of a previous successful authorization FAR_DP_AUTH_REL_ID
AuthorizationStatusName Payment cards: Result text TXT40
Master Data Relations Join Conditions
Currency Key
  • Currency Key
  • Currency Key
  • Client
  • I_PAYMENTPLANITEMDETAILS.AUTHORIZATIONCURRENCY == TCURC.WAERS
  • I_PAYMENTPLANITEMDETAILS.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_PAYMENTPLANITEMDETAILS.MANDT == TCURC.MANDT
Electronic Payment: Payment Type
  • Client
  • Electronic Payment: Payment Type
  • I_PAYMENTPLANITEMDETAILS.MANDT == TVCIN.MANDT
  • I_PAYMENTPLANITEMDETAILS.ELECTRONICPAYMENTTYPE == TVCIN.CCINS
Electronic Payment: Merchant ID at Clearing House
  • Client
  • Electronic Payment: Merchant ID at Clearing House
  • I_PAYMENTPLANITEMDETAILS.MANDT == TCCM.MANDT
  • I_PAYMENTPLANITEMDETAILS.MERCHANTBYCLEARINGHOUSE == TCCM.MERCH
Currency Key
  • Currency Key
  • Currency Key
  • Client
  • I_PAYMENTPLANITEMDETAILS.AUTHORIZATIONCURRENCY == TCURC.WAERS
  • I_PAYMENTPLANITEMDETAILS.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_PAYMENTPLANITEMDETAILS.MANDT == TCURC.MANDT