I_SlsDocPaymentPlanItemDetails

Sales Document Payment Plan Item Details | view: ISDPAYTPLANITEM | TRAN | Extraction: Not supported | Component: Payment Cards
Tables used: FPLTFPLTCVBAK
Column Name Description
SalesDocument Sales Document
PaymentPlanItem FK Item for billing plan/invoice plan/payment cards
Column Name Description
💲 Currency Key (AuthorizationCurrency):
AuthorizedAmountInAuthznCrcy Electronic Payment: Authorized Amount
EPaytToBeAuthorizedAmount Electronic Payment: Amount to Be Authorized
💲 Currency Key (TransactionCurrency):
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
SDDocumentCategory SD Document Category Show values
ElectronicPaymentEntryMode Electronic Payment: Entry Mode 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
PaymentPlanRelatedBillgStatus Billing Status of Payment Plan Show values
EPaytAuthorizationType Payment cards: Authorization type 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
BillingPlanRelatedBillgStsDesc Short Text for Fixed Values DDTEXT
EPaytAuthorizationTypeDesc Short Text for Fixed Values DDTEXT
Master Data Relations Join Conditions
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • I_SLSDOCPAYMENTPLANITEMDETAILS.MANDT == TCURC.MANDT
  • I_SLSDOCPAYMENTPLANITEMDETAILS.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_SLSDOCPAYMENTPLANITEMDETAILS.AUTHORIZATIONCURRENCY == TCURC.WAERS
Distribution channel in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • I_SLSDOCPAYMENTPLANITEMDETAILS.SALESORGANIZATION == TVKOV.VKORG
  • I_SLSDOCPAYMENTPLANITEMDETAILS.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_SLSDOCPAYMENTPLANITEMDETAILS.MANDT == TVKOV.MANDT
Electronic Payment: Payment Type
  • Electronic Payment: Payment Type
  • Client
  • I_SLSDOCPAYMENTPLANITEMDETAILS.ELECTRONICPAYMENTTYPE == TVCIN.CCINS
  • I_SLSDOCPAYMENTPLANITEMDETAILS.MANDT == TVCIN.MANDT
Electronic Payment: Merchant ID at Clearing House
  • Client
  • Electronic Payment: Merchant ID at Clearing House
  • I_SLSDOCPAYMENTPLANITEMDETAILS.MANDT == TCCM.MANDT
  • I_SLSDOCPAYMENTPLANITEMDETAILS.MERCHANTBYCLEARINGHOUSE == TCCM.MERCH
Division in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • Division
  • I_SLSDOCPAYMENTPLANITEMDETAILS.SALESORGANIZATION == TVTA.VKORG
  • I_SLSDOCPAYMENTPLANITEMDETAILS.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_SLSDOCPAYMENTPLANITEMDETAILS.MANDT == TVTA.MANDT
  • I_SLSDOCPAYMENTPLANITEMDETAILS.ORGANIZATIONDIVISION == TVTA.SPART
Order type in order header
  • Sales Document Type
  • Client
  • I_SLSDOCPAYMENTPLANITEMDETAILS.SALESDOCUMENTTYPE == TVAK.AUART
  • I_SLSDOCPAYMENTPLANITEMDETAILS.MANDT == TVAK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • I_SLSDOCPAYMENTPLANITEMDETAILS.SALESORGANIZATION == TVKO.VKORG
  • I_SLSDOCPAYMENTPLANITEMDETAILS.MANDT == TVKO.MANDT
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • I_SLSDOCPAYMENTPLANITEMDETAILS.MANDT == TCURC.MANDT
  • I_SLSDOCPAYMENTPLANITEMDETAILS.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_SLSDOCPAYMENTPLANITEMDETAILS.AUTHORIZATIONCURRENCY == TCURC.WAERS