BKKPOIT SAP (Item in Payment Order) Table details
Dictionary Type: Table
Description: Item in Payment Order
Description: Item in Payment Order
Table field list including key, data, relationships and ABAP select examples
BKKPOIT is a standard SAP Table which is used to store Item in Payment Order data and is available within R/3 SAP systems depending on the version and release level.
The BKKPOIT table consists of various fields, each holding specific information or linking keys about Item in Payment Order data available in SAP. These include BKKRS (Bank Area), PAORN (Payment order number), POSNO (Item in Payment Order), BKKRS_ITEM (Bank Area Items in Payment Order).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP BKKPOIT table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
BKKRS | Bank Area | BKK_BKKRS | CHAR | 4 | Assigned to domain | BKK_BKKRS | BNS | ||
PAORN | Payment order number | BKK_PAORN | NUMC | 12 | BKK_PAORN | PYN | |||
POSNO | Item in Payment Order | BKK_POPOS | NUMC | 5 | BKK_POPOS | ||||
BKKRS_ITEM | Bank Area Items in Payment Order | BKK_BKKRSI | CHAR | 4 | Assigned to domain | BKK_BKKRS | |||
ACNUM_INT | Internal Account Number for Current Account | BKK_ACCNT | CHAR | 10 | Assigned to domain | ALPHA | BKK_ACCNT | ACI | |
BANKS | Bank country key | BANKS | CHAR | 3 | Assigned to domain | LAND1 | BKL | ||
BANKL | Bank Keys | BANKK | CHAR | 15 | BANKK | BNK | |||
SWIFT | SWIFT/BIC for International Payments | SWIFT | CHAR | 11 | SWIFT | ||||
ACNUM_EXT | Account number for current account | BKK_ACEXT | CHAR | 35 | ACEXT | BKK_ACEXT | ACE | BKKACEXT | |
BKS | Bank Control Key | BKK_BKS | CHAR | 2 | BKONT | ||||
ACNUM_IBAN | International Bank Account Number | BKK_ACIBAN | CHAR | 35 | ALPHA | BKK_ACIBAN | |||
BUPA_NO | Business Partner Account Holder | BKK_ACHOLD | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | ||
BUPA_NAME | Account holder name | BKK_NAME | CHAR | 70 | BKK_NAME | ||||
X_ACTCHK_E | Indicator: Error in Check Digits for Account | BKK_ACTCHK | CHAR | 1 | X | ||||
TRNSTYPE | Transaction Type | BKK_TTYPE | CHAR | 4 | TBKKG3 | BKK_TTYPE | |||
MEDIUM | Medium | BKK_MEDIUM | CHAR | 4 | TBKKG1 | BKK_MEDIUM | |||
PAYMETHOD | Payment Method | BKK_PAYMET | CHAR | 4 | Assigned to domain | BKK_MEDIUM | BCA_SH_PAYMETHOD | ||
BUTXT | Posting Text | BKK_BUTXT | CHAR | 50 | TEXT50 | ||||
DATE_VALUE | Value date | BKK_VALDAT | DATS | 8 | DATUM | ||||
XVALDATSET | Indicator: Value Date was Specified | BKK_VDTSET | CHAR | 1 | XFELD | ||||
TCUR | Transaction Currency | BKK_TCUR | CUKY | 5 | Assigned to domain | WAERS | |||
T_AMOUNT | Amount in Transaction Currency | BKK_TAMNT | CURR | 17(2) | BKK_ITAMT | ||||
T_CHARGE | Charge in Transaction Currency | BKK_TCHARG | CURR | 17(2) | BKK_ITAMT | ||||
NACUR | Reporting Account Currency | BKK_NACUR | CUKY | 5 | Assigned to domain | WAERS | |||
NA_AMOUNT | Amount in Information Account Currency | BKK_NAAMNT | CURR | 17(2) | BKK_ITAMT | ||||
NA_CHARGE | Charge in Reporting Currency | BKK_NACHARG | CURR | 17(2) | BKK_ITAMT | ||||
ACUR | Account Currency | BKK_ACUR | CUKY | 5 | Assigned to domain | WAERS | |||
A_AMOUNT | Amount in Account Currency | BKK_AAMNT | CURR | 17(2) | BKK_ITAMT | ||||
A_CHARGE | Charge in Account Currency | BKK_ACHARG | CURR | 17(2) | BKK_ITAMT | ||||
EXCHNGRATE | Exchange Rate | BKK_EXRATE | DEC | 9(5) | EXCRT | BKK_EXRATE | |||
CHEQUE_TYP | Means of Payment Position Type | BKK_CASHBT | CHAR | 4 | Assigned to domain | ALPHA | BKK_CASHBT | CBT | |
CHEQUE_NO | Check Number (External) | BKK_CHEQEX | CHAR | 20 | ALPHA | BKK_CASHBX | |||
XCHK_CHQUE | Indicator: Check for the Check (Cheque) Switched Off? | BKK_XCHKCH | CHAR | 1 | XFELD | ||||
XCHK_VALUE | Indicator, value date check exluded? | BKK_XCHKV | CHAR | 1 | XFELD | ||||
XCHK_LIMIT | Indicator, limit check excluded? | BKK_XCHKL | CHAR | 1 | XFELD | ||||
XCHK_ACLCK | Indicator, account block check excluded? | BKK_XCHKAC | CHAR | 1 | XFELD | ||||
XCHK_BPLCK | Indicator, business partner check excluded? | BKK_XCHKBP | CHAR | 1 | XFELD | ||||
XCHK_MANDATE | Exclude Mandate Check | BKK_DTE_FLG_EXC_MND_CHK | CHAR | 1 | XFELD | ||||
XCHK_PRENOTE | Exclude Prenote Check | BKK_DTE_FLG_EXC_PRENOTE_CHK | CHAR | 1 | BKK_XFLD | ||||
XCHK_EXTD_MND | Indicator: Extended Mandate Check Excluded? | BKK_DTE_FLG_EXC_EXTD_MND_CHK | CHAR | 1 | BKK_XFLD | ||||
PUBLIC_CONT_L1 | Public Field Length 35 | BCA_DTE_CHAR035 | CHAR | 35 | BCA_DOM_CF_CHAR35 | ||||
PUBLIC_CONT_L2 | Public Field Length 35 | BCA_DTE_CHAR035 | CHAR | 35 | BCA_DOM_CF_CHAR35 | ||||
PUBLIC_CONT_L3 | Public Field Length 35 | BCA_DTE_CHAR035 | CHAR | 35 | BCA_DOM_CF_CHAR35 | ||||
PUBLIC_CONT_L4 | Public Field Length 35 | BCA_DTE_CHAR035 | CHAR | 35 | BCA_DOM_CF_CHAR35 | ||||
PUBLIC_CONT_S1 | Public Field Length 20 | BCA_DTE_CHAR020 | CHAR | 20 | BCA_DOM_CF_CHAR20 | ||||
PUBLIC_CONT_S2 | Public Field Length 20 | BCA_DTE_CHAR020 | CHAR | 20 | BCA_DOM_CF_CHAR20 | ||||
MANDATE_ID | Mandate Reference | BKK_DTE_MND_ID | CHAR | 35 | BKK_MND_ID | ||||
UCI | Creditor Identification | BKK_DTE_CRD_ID | CHAR | 35 | BKK_CRD_ID | ||||
PRENOTE_REF_NO | Prenote Reference ID | BKK_DTE_PRENOTE_REF_ID | CHAR | 40 | BKK_PRENOTE_REF_ID | ||||
PO_MGUID | SEPA Mandate: GUID of Mandate | SEPA_MGUID | RAW | 16 | |||||
PO_MVERS | Version of Mandate used for Enrichment | BKK_DTE_MANDATE_ENRICH_VERSION | NUMC | 4 | NUM04 | ||||
RECONC_SYSTEM | Identification of Supplying System | BKK_DTE_SYST_FROM | CHAR | 10 | BKK_DOM_SYSTEM | ||||
RECONC_APPL | Reconciliation - Supplying Application ID | BKK_DTE_APPL_FROM | CHAR | 5 | BKK_DOM_APPL | ||||
RECONC_NO | Reconciliation Unit - Additional ID | BKK_DTE_RECONC_NO | CHAR | 15 | BKK_DOM_RECONC_NO | ||||
.INCLU--AP | 0 | ||||||||
TAX_YEAR | Tax-year | RTP_US_TAXYEAR | NUMC | 4 | RTP_US_DATE_YEAR | ||||
AMOUNT_ID | Amount identifier code | RTP_US_AMN_ID | CHAR | 2 | RTP_US_AMN_ID | ||||
CONTRIB_ID | Contribution identifier | RTP_US_CON_ID | CHAR | 2 | RTP_US_CON_ID | ||||
IRS_DCODE | Retirement plan distribution code | RTP_US_IRS | CHAR | 1 | RTP_US_IRS | ||||
IRS_SCODE | Retirement plan distribution sub-code | RTP_US_IRS_SUB | CHAR | 1 | RTP_US_IRS | ||||
WH_AMOUNT_TOTAL | Total fed withholding amount for IRA distribution payment | RTP_US_WH_AMOUNT_TOTAL | CURR | 17(2) | RTP_US_AMOUNT | ||||
.INCLU--AP | 0 | ||||||||
XMEMO_ITEM | Items are memo items | BCA_US_XMEMO | CHAR | 1 | FLAG | ||||
.INCLU--AP | 0 | ||||||||
REBOOK | Payment Items Were Transfer Posted | BKK_REBOOK | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
AI_POST | Posting Decision: Interest Penalty | BKK_AI_POST | CHAR | 1 | BKK_AI_POST | ||||
.INCLU--AP | 0 | ||||||||
REF_ACEXT | Reference Account Number | BKK_REFACN | CHAR | 35 | ACEXT | BKK_ACEXT | |||
REF_IBAN | Reference IBAN | BKK_REFIBA | CHAR | 35 | ALPHA | BKK_ACIBAN | |||
REF_NAME | Reference Name of Account Holder | BKK_REFNAM | CHAR | 70 | BKK_NAME | ||||
REF_BANKS | Reference Country Key of Bank | BKK_REFBKS | CHAR | 3 | Assigned to domain | LAND1 | |||
REF_BANKL | Reference Bank Key | BKK_REFBKL | CHAR | 15 | BANKK |
Key field | Non-key field |
How do I retrieve data from SAP table BKKPOIT using ABAP code
The following ABAP code Example will allow you to do a basic selection on BKKPOIT to SELECT all data from the tableDATA: WA_BKKPOIT TYPE BKKPOIT.
SELECT SINGLE *
FROM BKKPOIT
INTO CORRESPONDING FIELDS OF WA_BKKPOIT
WHERE...
How to access SAP table BKKPOIT
Within an ECC or HANA version of SAP you can also view further information about BKKPOIT and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects