Sunday, May 19, 2024

SAP Table ABPPAY_DRAFT – I_ABPPAYMENTBATCHTP I_ABPPAYMENTTP

ABPPAY_DRAFT is a standard SAP table in SAP ECC (or) S/4HANA which stores I_ABPPAYMENTBATCHTP I_ABPPAYMENTTP data. There are total 65 fields in ABPPAY_DRAFT table.This blog post provides key technical details of SAP table ABPPAY_DRAFT, including its availability across SAP S/4HANA versions and the list of CDS views for ABPPAY_DRAFT table in SAP.

SAP HANA Table Type Column Store
Buffering Permission Buffering not allowed
Buffering Type No buffering
Package Bank Payment Approval (ODATA_BANK_PAYMENT_APPROVAL)
Technical Component Fiori FXU Accounts Payable FI-FIO-AP (CA-GTF-FXU-FI-AP)

SAP ABPPAY_DRAFT Table Fields

The following is the list of fields that are available in SAP ABPPAY_DRAFT table. The key fields of the table are highlighted in color.

Field Description Data Element Domain Check Table Data Type
MANDT Client MANDT MANDT CLNT (3)
DRAFTUUID UUID serving as key (parent key, root key) /BOBF/UUID SYSUUID RAW (16)
PARENTDRAFTUUID UUID serving as key (parent key, root key) /BOBF/UUID SYSUUID RAW (16)
PAYMENTBATCH Batch Identification Number FARP_BNK_BTCH_NO FARP_BNK_COM_BATCH_NO NUMC (10)
PAYMENTBATCHITEM Batch Item Number FARP_BNK_COM_BTCH_CNT BNK_COM_CTR NUMC (5)
PAIDITEMDUEDATE Due Date FARP_AUSFD DATUM DATS (8)
DATAEXCHANGEINSTRUCTIONKEY Instruction Key FARP_DTAWS_REGUH DTAWS CHAR (2)
PAYMENTDOCUMENT Document Number of the Payment Document VBLNR BELNR CHAR (10)
PAYMENTAMOUNTINRULECRCY Payment Amount in Rule Currency FAP_BPA_AMT_RULECU AFLE13D2O18S_TO_23D2O31S CURR (23)
PAYMENTBATCHRULECURRENCY Rule Currency FARP_BNK_RULE_CURRENCY WAERS CUKY (5)
NUMBEROFPAIDITEMS Number of Items Paid RPOST PACK3 DEC (5)
ISURGENTPAYMENT Urgent Payment DTURG XFELD CHAR (1)
PAYEENAME Payee Name FAP_BPA_DZNME1 TEXT35 CHAR (35)
PAYEEBANKNAME Name of Payee Bank FARP_PAYEEBANKA TEXT60 CHAR (60)
PAYEEBANK Payee Bank Number FARP_BNK_COM_DZBNKL BANKL CHAR (15)
SWIFTCODE Swift Code FAP_BPA_SWIFT SWIFT CHAR (11)
PAYEEBANKACCOUNT Bank Account Number of The Payee FAP_BPA_DZBNKN BANKN CHAR (18)
PAYEEBANKACCOUNTLONGID Payee’s Bank Account Number FARP_DZBNKN35 BANKN35 CHAR (35)
PAYEEIBAN IBAN of the Payee FAP_BPA_DZIBAN IBAN CHAR (34)
PAYEE Payee FAP_BPA_PAYEE_LIFNR LIFNR CHAR (10)
PAYMENTMETHOD Payment Method for This Payment RZAWE ZLSCH CHAR (1)
PAYMENTMETHODNAME Payment Method Name FARP_SCHZW_TEXT CHAR30 CHAR (30)
CUSTOMER Customer Number KUNNR KUNNR CHAR (10)
PAYMENTRUNISPROPOSAL Indicator: Only Proposal Run? XVORL XFELD CHAR (1)
PAYINGCOMPANYCODE Paying Company Code FARP_BNK_COM_DZBUKR BUKRS CHAR (4)
PAYMENTRUNDATE Payment Run Date FARP_BNK_COM_LAUFD DATUM DATS (8)
PAYMENTRUNID Payment Run ID FARP_BNK_COM_LAUFI LAUFI CHAR (6)
PAYMENTBATCHMERGEDATE Payment Batch Merge Date FARP_BNK_COM_BTCH_MRGE_DAT DATUM DATS (8)
PAYMENTBATCHMERGE Batch Merge FARP_BNK_COM_BTCH_MRGE_ID LAUFI CHAR (6)
PAYMENTRECIPIENT Payment Recipient FARP_EMPFG EMPFG CHAR (16)
STATUS Object Status CRM_J_STATUS CRM_J_STATUS CHAR (5)
SYSTEMSTATUSSHORTNAME Status ID BNK_COM_STATUS_ID TEXT5 CHAR (5)
STATUSPROFILE Status Profile J_STSMA J_STSMA CHAR (8)
BANKCOUNTRY Bank country key BANKS LAND1 CHAR (3)
HOUSEBANK House Bank Key FARP_HBKID HBKID CHAR (5)
HOUSEBANKACCOUNT ID for Account Details HKTID HKTID CHAR (5)
BANKACCOUNTLONGID Bank Account Number FARP_UBKNT35 BANKN35 CHAR (35)
HOUSEBANKIBAN House Bank IBAN FAP_BPA_UIBAN IBAN CHAR (34)
BANKNAME Name of bank BANKA TEXT60 CHAR (60)
SYSTEMSTATUSNAME Object status J_TXT30 TEXT30 CHAR (30)
PAIDAMOUNTINPAYTCURRENCY Amount Paid in the Payment Currency RWBTR AFLE13D2O18S_TO_23D2O31S CURR (23)
PAYMENTCURRENCY Currency Key WAERS WAERS CUKY (5)
COMPANYCODECURRENCY Local Currency FAP_BPA_WAERS WAERS CUKY (5)
AMOUNTINCOMPANYCODECURRENCY Amount in Company Code Currency FIS_HSL WERTV12 CURR (23)
COMPANYCODENAME Paying Company Code Name FARP_ZBUKRSTXT TEXT25 CHAR (25)
BANKPAYMENTGROUPINGORIGIN Origin of Grouping FAP_BPA_DORIGIN FIBL_ORIGIN CHAR (8)
PAYEEBANKINTERNALID Payee Bank Key FARP_BNK_COM_DZBNKY BANKK CHAR (15)
BANK House Bank Number FARP_UBNKL BANKL CHAR (15)
BILLOFEXCHANGEDUEDATE Bill of Exchange Due Date FAP_BPA_WEFAE DATUM DATS (8)
BILLOFEXCHANGEISSUEDATE Bill of Exchange Issue Date FARP_WDATE DATUM DATS (8)
PAYMENTORIGIN Grouping Criterium for Payments GRPNO_FPM GRPNO_FPM INT4 (10)
PAYMENTREQUESTPAYMENTGROUP Grouping Field for Automatic Payments PAYGR CHAR20 CHAR (20)
PAYMENTACTION Action for Processing Payment FARP_BNK_COM_ACTION CHAR03 CHAR (3)
PAYMENTDEFERDATE Defer Date FARP_BNK_COM_DEFER_DATE DATUM DATS (8)
DUEDATE Due date of the paid items AUSFD DATUM DATS (8)
DATAEXCHANGEINSTRUCTION1 Instruction key for data medium exchange DTAWS DTAWS CHAR (2)
PAYMENTBATCHSTATUS Batch Status Identifier FARP_BNK_COM_BTCH_STATUS_ID BNK_COM_STATUS_ID RAW (16)
BANKPAYMENTORIGIN Payment System BNK_PAYM_SYSTEM BNK_PAYM_SYSTEM CHAR (1)
PAYMENTBATCHITEMEXTENDTOEND End to End Identification (External) BNK_COM_END_TO_END_ID_EXT BNK_COM_END_TO_END_ID_EXT CHAR (35)
HASACTIVEENTITY Draft – Indicator – Has active document SDRAFT_HAS_ACTIVE BOOLE CHAR (1)
DRAFTENTITYCREATIONDATETIME Draft Created On SDRAFT_CREATED_AT TZNTSTMPL DEC (21)
DRAFTENTITYLASTCHANGEDATETIME Draft Last Changed On SDRAFT_LAST_CHANGED_AT TZNTSTMPL DEC (21)
DRAFTADMINISTRATIVEDATAUUID Technical ID for the Administrative Data of a Draft Document SDRAFT_ADMIN_UUID SYSUUID RAW (16)
DRAFTENTITYCONSISTENCYSTATUS Draft Consistency Status SDRAFT_CONSISTENCY_STATUS SDRAFT_CONSISTENCY_STATUS CHAR (1)
DRAFTENTITYOPERATIONCODE Draft – Operation Code SDRAFT_OPERATION_CODE SDRAFT_OPERATION_CODE CHAR (1)

Availability

The SAP table ABPPAY_DRAFT is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.

SAP S/4HANA Version Available?
1909 Yes
2020 Yes
2021 Yes
2022 Yes
2023 Yes

CDS Views for ABPPAY_DRAFT table

There are no CDS views available in the system. We’re updating the content all the time, so check back regularly.