DEABPS SAP (Customer change table: Logical view of BB amounts) Table details
Description: Customer change table: Logical view of BB amounts
Table field list including key, data, relationships and ABAP select examples
DEABPS is a standard SAP Table which is used to store Customer change table: Logical view of BB amounts data and is available within R/3 SAP systems depending on the version and release level.
The DEABPS table consists of various fields, each holding specific information or linking keys about Customer change table: Logical view of BB amounts data available in SAP. These include OPBEL (Number of Contract Accts Rec. & Payable Doc.), OPUPW (Repetition Item in Contract Account Document), OPUPK (Item number in contract account document), OPUPZ (Subitem for a Partial Clearing in Document).. 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 DEABPS 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 | |||
OPBEL | Number of Contract Accts Rec. & Payable Doc. | OPBEL_KK | CHAR | 12 | Assigned to domain | ALPHA | OPBEL_KK | 80B | |
OPUPW | Repetition Item in Contract Account Document | OPUPW_KK | NUMC | 3 | OPUPW_KK | ||||
OPUPK | Item number in contract account document | OPUPK_KK | NUMC | 4 | OPUPK_KK | ||||
OPUPZ | Subitem for a Partial Clearing in Document | OPUPZ_KK | NUMC | 3 | OPUPZ_KK | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
AUGST | Clearing status | AUGST_KK | CHAR | 1 | AUGST_KK | ||||
GPART | Business Partner Number | GPART_KK | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | |
VTREF | Reference Specifications from Contract | VTREF_KK | CHAR | 20 | ALPHA | VTREF_KK | VTZ | ||
VTRE2 | Additional Reference Information | VTRE2_KK | CHAR | 20 | ALPHA | VTREF_KK | |||
VKONT | Contract Account Number | VKONT_KK | CHAR | 12 | Assigned to domain | ALPHA | VKONT_KK | KTO | FKKVKP_F4 |
ABWBL | Number of the substitute FI-CA document | ABWBL_KK | CHAR | 12 | ALPHA | ABWBL_KK | |||
ABWTP | Category of substitute document in FI-CA | ABWTP_KK | CHAR | 1 | ABWTP_KK | ||||
APPLK | Application area | APPLK_KK | CHAR | 1 | APPLK_KK | ||||
HVORG | Main Transaction for Line Item | HVORG_KK | CHAR | 4 | Assigned to domain | HVORG_KK | 8HV | ||
TVORG | Subtransaction for Document Item | TVORG_KK | CHAR | 4 | Assigned to domain | TVORG_KK | |||
KOFIZ | Account Determination ID | KOFIZ_KK | CHAR | 2 | KOFIZ_KK | ||||
SPART | Division | SPART_KK | CHAR | 2 | Assigned to domain | SPART | SPA | ||
HKONT | General ledger account | HKONT_KK | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | SAKO | |
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
MWSZKZ | Supplementary Tax | MWSZKZ_KK | CHAR | 2 | Assigned to domain | MWSKZ | |||
XANZA | Item is a Down Payment/Down Payment Request | XANZA_KK | CHAR | 1 | XFELD | ||||
STAKZ | Type of statistical item | STAKZ_KK | CHAR | 1 | STAKZ_KK | ||||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
OPTXT | Item text | OPTXT_KK | CHAR | 50 | TEXT50 | ||||
WAERS | Transaction Currency | BLWAE_KK | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
FAEDN | Due date for net payment | FAEDN_KK | DATS | 8 | DATUM | ||||
FAEDS | Due Date for Cash Discount | FAEDS_KK | DATS | 8 | DATUM | ||||
VERKZ | Item Can Only Be Cleared | VERKZ_KK | CHAR | 1 | VERKZ_KK | ||||
STUDT | Deferral to | STUDT_KK | DATS | 8 | DATUM | ||||
SKTPZ | Cash discount rate | SKTPZ_KK | DEC | 5(3) | PRZ23 | ||||
XMANL | Exclude Item from Dunning Run | XMANL_KK | CHAR | 1 | XFELD | ||||
KURSF | Exchange rate | KURSF_KK | DEC | 9(5) | EXCRT | KURSF | |||
BETRH | Amount In Local Currency With +/- Signs | BETRH_KK | CURR | 13(2) | WRTV7 | ||||
BETRW | Amount in Transaction Currency with +/- Sign | BETRW_KK | CURR | 13(2) | WRTV7 | ||||
BETR2 | Amount in second parallel currency with +/- sign | BETR2_KK | CURR | 13(2) | WRTV7 | ||||
BETR3 | Amount in third parallel currency with +/- sign | BETR3_KK | CURR | 13(2) | WRTV7 | ||||
SKFBT | Amount eligible for cash discount in document currency | SKFBT_KK | CURR | 13(2) | WRTV7 | ||||
SBETH | Tax Amount in Local Currency With +/- Sign | SBETH_KK | CURR | 13(2) | WRTV7 | ||||
SBETW | Tax Amount in Transaction Currency with +/- Sign | SBETW_KK | CURR | 13(2) | WRTV7 | ||||
SBET2 | Tax amount in second parallel currency | SBET2_KK | CURR | 13(2) | WRTV7 | ||||
SBET3 | Tax amount in third parallel currency | SBET3_KK | CURR | 13(2) | WRTV7 | ||||
MWSKO | Account for posting taxes for down payments | MWSKO_KK | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
MWVKO | Account for offsetting tax posting in down payments | MWVKO_KK | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
SPZAH | Lock Reason for Automatic Payment | SPZAH_KK | CHAR | 1 | Assigned to domain | SPZAH_KK | |||
PYMET | Payment Method | PYMET_KK | CHAR | 1 | Assigned to domain | PYMET_KK | |||
PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
GRKEY | Grouping Key for Displaying Open Items | GRKEY_KK | CHAR | 3 | CHAR3 | ||||
PERSL | Key for Period Assignment | PERSL_KK | CHAR | 4 | Assigned to domain | PERSL_KK | |||
XAESP | Printing - No Changes Possible | XAESP_KK | CHAR | 1 | XFELD | ||||
AUGDT | Clearing date | AUGDT_KK | DATS | 8 | DATUM | ||||
AUGBL | Clearing Document or Printed Document | AUGBL_KK | CHAR | 12 | ALPHA | AUGBL_KK | |||
AUGBD | Clearing document posting date | AUGBD_KK | DATS | 8 | DATUM | ||||
AUGRD | Clearing Reason | AUGRD_KK | CHAR | 2 | Assigned to domain | AUGRD_KK | |||
AUGWA | Clearing currency | AUGWA_KK | CUKY | 5 | Assigned to domain | WAERS | |||
AUGBT | Clearing amount in clearing currency | AUGBT_KK | CURR | 13(2) | WRTV7 | ||||
AUGBS | Tax amount in clearing currency | AUGBS_KK | CURR | 13(2) | WRTV7 | ||||
AUGSK | Cash Discount Granted/Surcharge Levied in Clearing Currency | AUGSK_KK | CURR | 13(2) | WRTV7 | ||||
AUGVD | Value date for clearing | AUGVD_KK | DATS | 8 | DATUM | ||||
AUGOB | Item Canceled | AUGOB_KK | CHAR | 1 | XFELD | ||||
WHANG | Number of repetition items | WHANG_KK | NUMC | 3 | NUM03 | ||||
WHGRP | Repetition group | WHGRP_KK | NUMC | 3 | Assigned to domain | WHGRP_KK | |||
XEIPH | Create Line Item in General Ledger | XEIPH_KK | CHAR | 1 | XFELD | ||||
MAHNV | Dunning Procedure | MAHNV_KK | CHAR | 2 | Assigned to domain | MAHNV_KK | FKK_MAHNV | ||
MANSP | Dunning Lock Reason | MANSP_KK | CHAR | 1 | Assigned to domain | MANSP_KK | |||
XAUGP | Check Sample Record Clearing | XAUGP_KK | CHAR | 1 | XFELD | ||||
ABRZU | Lower Limit of Settlement Period | ABRZU_KK | DATS | 8 | DATUM | ||||
ABRZO | Upper Limit of the Billing Period | ABRZO_KK | DATS | 8 | DATUM | ||||
FDGRP | Planning Group | FDGRP_KK | CHAR | 10 | Assigned to domain | ALPHA | FDGRP | FFG | |
FDLEV | Planning level | FDLEV_KK | CHAR | 2 | Assigned to domain | FDLEV | FFE | ||
FDZTG | Additional Days for Cash Management | FDZTG_KK | NUMC | 2 | NUM2 | ||||
FDWBT | Planning amount in document currency | FDWBT | CURR | 13(2) | WERTV7 | ||||
XTAUS | Item Split | XTAUS_KK | CHAR | 1 | XFELD | ||||
AUGRS | Clearing restriction | AUGRS_KK | CHAR | 1 | AUGRS_KK | ||||
PYGRP | Grouping field for automatic payments | PYGRP_KK | CHAR | 10 | CHAR10 | ||||
SPERZ | Interest Lock Reason | SPERZ_KK | CHAR | 1 | Assigned to domain | SPERZ_KK | |||
INFOZ | Doubtful Item Entry/Individual Value Adjustment | INFOZ_KK | NUMC | 3 | INFOZ_KK | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
TXDAT | Decisive Date for Calculating Taxes | TXDAT_KK | DATS | 8 | DATUM | ||||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | Assigned to domain | ALPHA | RCOMP | PGS | |
KONTT | Account Assignment Category | KONTT_KK | CHAR | 2 | Assigned to domain | KONTT_KK | |||
KONTL | Acct assnmnt string for industry-specific account assngments | KONTL_KK | CHAR | 50 | CHAR50 | ||||
OPSTA | Dunning indicator | OPSTA_KK | CHAR | 3 | OPSTA_KK | ||||
BLART | Document Type | BLART_KK | CHAR | 2 | Assigned to domain | BLART_KK | |||
EMGPA | Alternative Business Partner for Payments | EMGPA_KK | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BUPA | |
EMBVT | Bank Details ID of Payee | EMBVT_KK | CHAR | 4 | CHAR4 | ||||
EMADR | Address number | AD_ADDRNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | |
IKEY | Interest Key | IKEY_KK | CHAR | 2 | Assigned to domain | IKEY_KK | |||
EUROU | Status of Euro Conversion | EUROU_KK | CHAR | 1 | EUROU_KK | ||||
XRAGL | Clearing posting reversed | XRAGL_KK | CHAR | 1 | XFELD | ||||
ASTKZ | Statistical Key of the Initiating Item | ASTKZ_KK | CHAR | 1 | ASTKZ_KK | ||||
XBLNR | Reference document number | XBLNR_KK | CHAR | 16 | ALPHA | XBLNR_KK | |||
INKPS | Collection Item | INKPS_KK | NUMC | 3 | NUM03 | ||||
RNDPS | Type of Rounding Item | RNDPS_KK | CHAR | 1 | RNDPS_KK | ||||
QSSKZ | Withholding Tax Code | QSSKZ | CHAR | 2 | Assigned to domain | QSSKZ | |||
QSSEW | Withholding Tax Supplement | QSSEW_KK | CHAR | 2 | Assigned to domain | QSSEW_KK | |||
QSPTP | Line Item Category From Withholding Tax View | QSPTP_KK | CHAR | 1 | QSPTP_KK | ||||
QSSHB | Tax Base Amount | QSSHB_KK | CURR | 13(2) | WRTV7 | ||||
QBSHB | Withholding Tax Amount (in Document Currency) | QBSHB_KK | CURR | 13(2) | WRTV7 | ||||
QSZNR | Certificate Number of the Withholding Tax Exemption | QSZNR | CHAR | 10 | CHAR10 | ||||
RFUPK | Reference Item In FI-CA Document | RFUPK_KK | NUMC | 4 | OPUPK_KK | ||||
STRKZ | Tax Code for Other Taxes | STRKZ_KK | CHAR | 2 | Assigned to domain | STRKZ_KK | |||
FITPR | Tax type | J_1AFITP_D | CHAR | 2 | Assigned to domain | J_1AFITP | |||
XPYOR | Item Included in a Payment Order | XPYOR_KK | CHAR | 1 | XPYOR_KK | ||||
POTYP | Item category | POTYP_KK | CHAR | 1 | POTYP_KK | ||||
XMARK | Item selected | XMARK_KK | CHAR | 1 | XMARK_KK |
Key field | Non-key field |
How do I retrieve data from SAP table DEABPS using ABAP code
The following ABAP code Example will allow you to do a basic selection on DEABPS to SELECT all data from the tableDATA: WA_DEABPS TYPE DEABPS.
SELECT SINGLE *
FROM DEABPS
INTO CORRESPONDING FIELDS OF WA_DEABPS
WHERE...
How to access SAP table DEABPS
Within an ECC or HANA version of SAP you can also view further information about DEABPS 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