SAP ABAP Table BKKITTMP_DEL (Planned Payment Items - Completed)
Hierarchy
☛
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷ IS-B-BCA-AM-IT (Application Component) Payment Item
⤷ FKBP (Package) Bank Customer Accounts: Payment Item
⤷ IS-B-BCA-AM-IT (Application Component) Payment Item
⤷ FKBP (Package) Bank Customer Accounts: Payment Item
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | BKKITTMP_DEL | Table Relationship Diagram |
Short Description | Planned Payment Items - Completed |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | BKKRS | BKK_BKKRS | BKK_BKKRS | CHAR | 4 | 0 | Bank Area | TBKK01 | |
3 | DOCNO_TMP | BKK_DOCNOTMP | BKK_DOCNOTMP | NUMC | 12 | 0 | Document Number for Planned Payment Items | * | |
4 | POSNO | BKK_POSNO | BKK_POSNO | NUMC | 3 | 0 | Position in Item | ||
5 | DOCNO | BKK_DOCNO | BKK_DOCNO | NUMC | 12 | 0 | Item number in current accounts | * | |
6 | .INCLUDE | 0 | 0 | Data Structure of Tables BKKIT and BKKITENQ | |||||
7 | ACNUM_INT | BKK_ACCNT | BKK_ACCNT | CHAR | 10 | 0 | Internal Account Number for Current Account | * | |
8 | BANKS | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | T005 | |
9 | BANKL | BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | ||
10 | SWIFT | SWIFT | SWIFT | CHAR | 11 | 0 | SWIFT/BIC for International Payments | ||
11 | ACNUM_EXT | BKK_ACEXT | BKK_ACEXT | CHAR | 35 | 0 | Account number for current account | ||
12 | BKS | BKK_BKS | BKONT | CHAR | 2 | 0 | Bank Control Key | ||
13 | ACNUM_IBAN | BKK_ACIBAN | BKK_ACIBAN | CHAR | 35 | 0 | International Bank Account Number | ||
14 | ALT_ACEXT | BKK_ALTACE | BKK_ACEXT | CHAR | 35 | 0 | Original Account Number | ||
15 | ALT_IBAN | BKK_ALTIBA | BKK_ACIBAN | CHAR | 35 | 0 | Original IBAN | ||
16 | BUPA_NO | BKK_ACHOLD | BU_PARTNER | CHAR | 10 | 0 | Business Partner Account Holder | * | |
17 | BUPA_NAME | BKK_NAME | BKK_NAME | CHAR | 70 | 0 | Account holder name | ||
18 | REFNO_CR | BKK_CRNO | BKK_REFNO | CHAR | 20 | 0 | Reference Number of Creation | ||
19 | REFNO_PAYM | BKK_PAYMNO | BKK_REFNO | CHAR | 20 | 0 | Reference Number from Payment Transactions | ||
20 | REFNO_PN | BKK_PNNO | BKK_PNNO | CHAR | 12 | 0 | Daybook number | ||
21 | DATE_CR | BKK_CRDATD | DATUM | DATS | 8 | 0 | Creation Date of the Data Medium | ||
22 | DATE_VALUE | BKK_VALDAT | DATUM | DATS | 8 | 0 | Value date | ||
23 | DATE_POST | BKK_PSTDAT | DATUM | DATS | 8 | 0 | Posting date | ||
24 | DATE_COL | BKK_CDATE | DATUM | DATS | 8 | 0 | Date of Subject to Final Payment Balance | ||
25 | TCUR | BKK_TCUR | WAERS | CUKY | 5 | 0 | Transaction Currency | TCURC | |
26 | T_AMOUNT | BKK_TAMNT | BKK_ITAMT | CURR | 17 | 2 | Amount in Transaction Currency | ||
27 | T_CHARGE | BKK_TCHARG | BKK_ITAMT | CURR | 17 | 2 | Charge in Transaction Currency | ||
28 | NACUR | BKK_NACUR | WAERS | CUKY | 5 | 0 | Reporting Account Currency | * | |
29 | NA_AMOUNT | BKK_NAAMNT | BKK_ITAMT | CURR | 17 | 2 | Amount in Information Account Currency | ||
30 | NA_CHARGE | BKK_NACHARG | BKK_ITAMT | CURR | 17 | 2 | Charge in Reporting Currency | ||
31 | ACUR | BKK_ACUR | WAERS | CUKY | 5 | 0 | Account Currency | TCURC | |
32 | A_AMOUNT | BKK_AAMNT | BKK_ITAMT | CURR | 17 | 2 | Amount in Account Currency | ||
33 | A_CHARGE | BKK_ACHARG | BKK_ITAMT | CURR | 17 | 2 | Charge in Account Currency | ||
34 | EXCHNGRATE | BKK_EXRATE | BKK_EXRATE | DEC | 9 | 5 | Exchange Rate | ||
35 | MEDIUM | BKK_MEDIUM | BKK_MEDIUM | CHAR | 4 | 0 | Medium | TBKKG1 | |
36 | PAYMETHOD | BKK_PAYMET | BKK_MEDIUM | CHAR | 4 | 0 | Payment Method | * | |
37 | TRNSTYPE | BKK_TTYPE | BKK_TTYPE | CHAR | 4 | 0 | Transaction Type | TBKKG3 | |
38 | S_TRNSTYPE | BKK_STTYPE | BKK_TTYPE | CHAR | 4 | 0 | Source Transaction Type | * | |
39 | RETURNK | BKK_RKEY | CHAR02 | CHAR | 2 | 0 | Return Reason | ||
40 | COUNTRY | BKK_CNTRY | LAND1 | CHAR | 3 | 0 | Country | * | |
41 | X_ACTCHK_E | BKK_ACTCHK | X | CHAR | 1 | 0 | Indicator: Error in Check Digits for Account | ||
42 | CHEQUE_TYP | BKK_CASHBT | BKK_CASHBT | CHAR | 4 | 0 | Means of Payment Position Type | * | |
43 | CHEQUE_NO | BKK_CHEQEX | BKK_CASHBX | CHAR | 20 | 0 | Check Number (External) | ||
44 | ITEMCNT | BKK_ITCNT | NUMC5 | NUMC | 5 | 0 | Number of Processed Items | ||
45 | BUTXT | BKK_BUTXT | TEXT50 | CHAR | 50 | 0 | Posting Text | ||
46 | REMARK | BKK_REMARK | BKK_CHAR50LOW | CHAR | 50 | 0 | Comment on Order/Item | ||
47 | ITEMTYPE | BKK_ITTYPE | BKK_ITTYPE | CHAR | 2 | 0 | Type of Payment Item | ||
48 | PROCESS | BKK_PROCSS | BKK_PROCSS | CHAR | 4 | 0 | Processes in BCA | TBKKIPROC | |
49 | ITEMSTATUS | BKK_ITSTAT | BKK_ITSTAT | CHAR | 2 | 0 | Status of Payment Item | ||
50 | REF_ACEXT | BKK_REFACN | BKK_ACEXT | CHAR | 35 | 0 | Reference Account Number | ||
51 | REF_BKS | BKK_BKS | BKONT | CHAR | 2 | 0 | Bank Control Key | ||
52 | REF_IBAN | BKK_REFIBA | BKK_ACIBAN | CHAR | 35 | 0 | Reference IBAN | ||
53 | REF_NAME | BKK_REFNAM | BKK_NAME | CHAR | 70 | 0 | Reference Name of Account Holder | ||
54 | REF_BANKS | BKK_REFBKS | LAND1 | CHAR | 3 | 0 | Reference Country Key of Bank | * | |
55 | REF_BANKL | BKK_REFBKL | BANKK | CHAR | 15 | 0 | Reference Bank Key | ||
56 | REF_SWIFT | SWIFT | SWIFT | CHAR | 11 | 0 | SWIFT/BIC for International Payments | ||
57 | XNOGLITEM | BKK_XGLITM | X | CHAR | 1 | 0 | Indicator: No Update in General Ledger | ||
58 | XVALDATSET | BKK_VDTSET | XFELD | CHAR | 1 | 0 | Indicator: Value Date was Specified | ||
59 | XPOSTPRIOR | BKK_PSTPRI | XFELD | CHAR | 1 | 0 | Indicator: Posting to prior period | ||
60 | XPRI_PPROC | BKK_XPRIPP | X | CHAR | 1 | 0 | Indicator: Priority in Postprocessing | ||
61 | XREVERSE | BKK_XREV | XFELD | CHAR | 1 | 0 | Indicator: Reversal Item | ||
62 | REVERSE_NO | BKK_REVNO | BKK_DOCNO | NUMC | 12 | 0 | Reversal no. | * | |
63 | REVERSE_PS | BKK_REVPOS | BKK_POSNO | NUMC | 3 | 0 | Reversal Item | ||
64 | TRNSF_BK_B | BKK_TRFBKB | BKK_BKKRS | CHAR | 4 | 0 | Reference Bank Area from Transfer Posting (Orig. Docu.) | * | |
65 | TRNSF_NO_B | BKK_TRFDCB | BKK_DOCNO | NUMC | 12 | 0 | Reference Document Number from Transfer Posting (Source Doc) | * | |
66 | TRNSF_PS_B | BKK_TRFPSB | BKK_POSNO | NUMC | 3 | 0 | Reference Position Number from Trans.Posting (Orig.Document) | ||
67 | TRNSF_BK_F | BKK_TRFBKF | BKK_BKKRS | CHAR | 4 | 0 | Reference Bank Area from Transfer Posting | * | |
68 | TRNSF_NO_F | BKK_TRFDCF | BKK_DOCNO | NUMC | 12 | 0 | Reference Document Number from Transfer Posting | * | |
69 | TRNSF_PS_F | BKK_TRFPSF | BKK_POSNO | NUMC | 3 | 0 | Reference Position Number from Transfer Posting | ||
70 | REF_PO_BK | BKK_REFPOB | BKK_BKKRS | CHAR | 4 | 0 | Reference Field: Bank Area Generating Payment Order | * | |
71 | REF_PO_NO | BKK_REFPOD | BKK_PAORN | NUMC | 12 | 0 | Reference Field: Number Generating Payment Order | ||
72 | REF_PO_PS | BKK_REFPOP | BKK_POPOS | NUMC | 5 | 0 | Reference Field: Position Generating Payment Order | ||
73 | .INCLUDE | 0 | 0 | Disposition: Indicator Deactivating Partial Checks | |||||
74 | XCHK_CHQUE | BKK_XCHKCH | XFELD | CHAR | 1 | 0 | Indicator: Check for the Check (Cheque) Switched Off? | ||
75 | XCHK_VALUE | BKK_XCHKV | XFELD | CHAR | 1 | 0 | Indicator, value date check exluded? | ||
76 | XCHK_LIMIT | BKK_XCHKL | XFELD | CHAR | 1 | 0 | Indicator, limit check excluded? | ||
77 | XCHK_ACLCK | BKK_XCHKAC | XFELD | CHAR | 1 | 0 | Indicator, account block check excluded? | ||
78 | XCHK_BPLCK | BKK_XCHKBP | XFELD | CHAR | 1 | 0 | Indicator, business partner check excluded? | ||
79 | XCHK_MANDATE | BKK_DTE_FLG_EXC_MND_CHK | XFELD | CHAR | 1 | 0 | Exclude Mandate Check | ||
80 | .INCLUDE | 0 | 0 | Item Check: Indicator Partial Checks Ended with Errors | |||||
81 | XERR_SYST | BKK_XSYSRT | XFELD | CHAR | 1 | 0 | Indicator, error Customizing/master data? | ||
82 | XERR_ENQUE | BKK_XENQRT | XFELD | CHAR | 1 | 0 | Indicator, error in blocking account balance? | ||
83 | XERR_CHQUE | BKK_XCHQRT | XFELD | CHAR | 1 | 0 | Indicator, error in position management check? | ||
84 | XERR_VALUE | BKK_XVALRT | XFELD | CHAR | 1 | 0 | Indicator, error in value date check? | ||
85 | XERR_LIMIT | BKK_XLIMRT | XFELD | CHAR | 1 | 0 | Indicator, error in limit check? | ||
86 | XERR_ACLCK | BKK_XACCRT | XFELD | CHAR | 1 | 0 | Indicator, error in account check? | ||
87 | XERR_BPLCK | BKK_XBUPRT | XFELD | CHAR | 1 | 0 | Indicator, error in business partner check? | ||
88 | XERR_CUREX | BKK_XCURRT | XFELD | CHAR | 1 | 0 | Indicator, error due to block/currency changeover? | ||
89 | XERR_PSTFU | BKK_XPFURT | XFELD | CHAR | 1 | 0 | Indicator - Posting Date is in the Future | ||
90 | XERR_MANDATE | BKK_DTE_FLG_MND_IND | XFELD | CHAR | 1 | 0 | Error in Mandate Lock Check | ||
91 | .INCLUDE | 0 | 0 | Admin. Data BCA Document (Payment Item, Payment Order) | |||||
92 | CRUSR | BKK_CRUSR | USNAM | CHAR | 12 | 0 | User who created the object | ||
93 | CRDAT | BKK_CRDAT | DATUM | DATS | 8 | 0 | Date on which the object was created | ||
94 | CRTIM | BKK_CRTIM | UZEIT | TIMS | 6 | 0 | Time at which the object was created | ||
95 | CHUSR | BKK_CHUSR | USNAM | CHAR | 12 | 0 | Last user to change object | ||
96 | CHDAT | BKK_CHDAT | DATUM | DATS | 8 | 0 | Date on which the object was last changed | ||
97 | CHTIM | BKK_CHTIM | UZEIT | TIMS | 6 | 0 | Time at Which Object was Last Changed | ||
98 | RLUSR | BKK_RLUSR | USNAM | CHAR | 12 | 0 | User who released object | ||
99 | RLDAT | BKK_RLDAT | DATUM | DATS | 8 | 0 | Date on which object was released | ||
100 | RLTIM | BKK_RLTIM | UZEIT | TIMS | 6 | 0 | Time Object Was Releeased | ||
101 | .INCLUDE | 0 | 0 | Public Container Structure for BCA Item Table | |||||
102 | PUBLIC_CONT_L1 | BCA_DTE_CHAR035 | BCA_DOM_CF_CHAR35 | CHAR | 35 | 0 | Public Field Length 35 | ||
103 | PUBLIC_CONT_L2 | BCA_DTE_CHAR035 | BCA_DOM_CF_CHAR35 | CHAR | 35 | 0 | Public Field Length 35 | ||
104 | PUBLIC_CONT_L3 | BCA_DTE_CHAR035 | BCA_DOM_CF_CHAR35 | CHAR | 35 | 0 | Public Field Length 35 | ||
105 | PUBLIC_CONT_L4 | BCA_DTE_CHAR035 | BCA_DOM_CF_CHAR35 | CHAR | 35 | 0 | Public Field Length 35 | ||
106 | PUBLIC_CONT_S1 | BCA_DTE_CHAR020 | BCA_DOM_CF_CHAR20 | CHAR | 20 | 0 | Public Field Length 20 | ||
107 | PUBLIC_CONT_S2 | BCA_DTE_CHAR020 | BCA_DOM_CF_CHAR20 | CHAR | 20 | 0 | Public Field Length 20 | ||
108 | NTCUR | BKK_NTCUR | WAERS | CUKY | 5 | 0 | Reporting Transaction Currency | * | |
109 | NT_AMOUNT | BKK_NTAMNT | BKK_ITAMT | CURR | 17 | 2 | Amount in Reporting Transaction Currency | ||
110 | NT_CHARGE | BKK_NTCHARG | BKK_ITAMT | CURR | 17 | 2 | Charge in Reporting Transaction Currency | ||
111 | .INCLU--AP | 0 | 0 | US specific fields for Planned payment items - completed | |||||
112 | .INCLUDE | 0 | 0 | Retirement plan payment item data | |||||
113 | .INCLUDE | 0 | 0 | Include for Retirement plan payment item data | |||||
114 | TAX_YEAR | RTP_US_TAXYEAR | RTP_US_DATE_YEAR | NUMC | 4 | 0 | Tax-year | ||
115 | AMOUNT_ID | RTP_US_AMN_ID | RTP_US_AMN_ID | CHAR | 2 | 0 | Amount identifier code | ||
116 | CONTRIB_ID | RTP_US_CON_ID | RTP_US_CON_ID | CHAR | 2 | 0 | Contribution identifier | ||
117 | IRS_DCODE | RTP_US_IRS | RTP_US_IRS | CHAR | 1 | 0 | Retirement plan distribution code | ||
118 | IRS_SCODE | RTP_US_IRS_SUB | RTP_US_IRS | CHAR | 1 | 0 | Retirement plan distribution sub-code | ||
119 | .INCLUDE | 0 | 0 | Retirement plan-Include structure withholding information | |||||
120 | WH_AMOUNT_TOTAL | RTP_US_WH_AMOUNT_TOTAL | RTP_US_AMOUNT | CURR | 17 | 2 | Total fed withholding amount for IRA distribution payment | ||
121 | .INCLU--AP | 0 | 0 | Fields for memo items | |||||
122 | .INCLUDE | 0 | 0 | Fields for memo items | |||||
123 | XMEMO_ITEM | BCA_US_XMEMO | FLAG | CHAR | 1 | 0 | Items are memo items |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | BKKITTMP_DEL | ACUR | TCURC | WAERS | 1 | CN | |
2 | BKKITTMP_DEL | BANKS | T005 | LAND1 | 1 | CN | |
3 | BKKITTMP_DEL | BKKRS | TBKK01 | BKKRS | KEY | 1 | CN |
4 | BKKITTMP_DEL | MANDT | T000 | MANDT | KEY | 1 | CN |
5 | BKKITTMP_DEL | MEDIUM | TBKKG1 | MEDIUM | 1 | CN | |
6 | BKKITTMP_DEL | PROCESS | TBKKIPROC | PROCESS | 1 | CN | |
7 | BKKITTMP_DEL | TCUR | TCURC | WAERS | 1 | CN | |
8 | BKKITTMP_DEL | TRNSTYPE | TBKKG3 | TRNSTYPE | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |