I_SlsOrdPaytCardInfo

Sales Order with Payment Card Data | view: ISLSORDPAYCINFO | TRAN | Extraction: Not supported | Component: S/4HANA: Electronic Payments Sales
Tables used: FPLAFPLTFPLTCVBKDVEDAVBAKTVCIN
Column Name Description
SalesOrder Sales Order
PaymentPlan FK Number of payment card plan type
PaymentPlanItem null
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
💲 Currency Key (AuthorizationCurrency):
AuthorizedAmountInAuthznCrcy Electronic Payment: Authorized Amount
TotalOpenAuthorizedAmount null
Column Name Description
Column Name Description
SalesOrderDate Document Date (Date Received/Sent)
TodayDate Date data element for SYST
OrderCreationDate Date on which the record was created
AuthorizationDate Electronic Payment: Authorization Date
PaytCardAuthznExprtnDate Payment Cards: Valid To
Column Name Description
TotalCreditCheckStatus Overall Status of Credit Checks Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallDeliveryStatus Delivery Status (All Items) Show values
PaytAuthsnCreditCheckSts Status of Credit Check Against Payment Card Authorization Show values
PreauthorizationIsRequested Electronic Payment: Preauthorization Show values
PaymentPlanRelatedBillgStatus Billing Status of Payment Plan Show values
PaytCardAuthznRqmtStatus Payment Cards: Status Regarding Requirements Show values
Column Name Description Domain name
CustomerReferenceNumber Customer Reference Number CHAR40
PaymentCardAuthznPeriodDays 4 Byte Signed Integer INT4
Master Data Relations Join Conditions
Currency Key
  • Currency Key
  • Client
  • I_SLSORDPAYTCARDINFO.AUTHORIZATIONCURRENCY == TCURC.WAERS
  • I_SLSORDPAYTCARDINFO.MANDT == TCURC.MANDT
Distribution channel in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • I_SLSORDPAYTCARDINFO.SALESORGANIZATION == TVKOV.VKORG
  • I_SLSORDPAYTCARDINFO.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_SLSORDPAYTCARDINFO.MANDT == TVKOV.MANDT
Division in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • Division
  • I_SLSORDPAYTCARDINFO.SALESORGANIZATION == TVTA.VKORG
  • I_SLSORDPAYTCARDINFO.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_SLSORDPAYTCARDINFO.MANDT == TVTA.MANDT
  • I_SLSORDPAYTCARDINFO.ORGANIZATIONDIVISION == TVTA.SPART
Electronic Payment: Payment Type
  • Electronic Payment: Payment Type
  • Client
  • I_SLSORDPAYTCARDINFO.PAYMENTCARDTYPE == TVCIN.CCINS
  • I_SLSORDPAYTCARDINFO.MANDT == TVCIN.MANDT
Order type in order header
  • Sales Order Type
  • Client
  • I_SLSORDPAYTCARDINFO.SALESORDERTYPE == TVAK.AUART
  • I_SLSORDPAYTCARDINFO.MANDT == TVAK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • I_SLSORDPAYTCARDINFO.SALESORGANIZATION == TVKO.VKORG
  • I_SLSORDPAYTCARDINFO.MANDT == TVKO.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • I_SLSORDPAYTCARDINFO.SOLDTOPARTY == KNA1.KUNNR
  • I_SLSORDPAYTCARDINFO.MANDT == KNA1.MANDT
Currency in order header
  • SD Document Currency
  • Client
  • I_SLSORDPAYTCARDINFO.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_SLSORDPAYTCARDINFO.MANDT == TCURC.MANDT