ACCCLR_ITM SAP (Accounting Interface: Items to be Cleared) Structure details
Description: Accounting Interface: Items to be Cleared
Structure field list including key, data, relationships and ABAP select examples
ACCCLR_ITM is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Accounting Interface: Items to be Cleared" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_ACCCLR_ITM TYPE ACCCLR_ITM.
The ACCCLR_ITM table consists of various fields, each holding specific information or linking keys about Accounting Interface: Items to be Cleared data available in SAP. These include AUFNR (Order Number), BDIF2 (Valuation Difference for the Second Local Currency), BDIF3 (Valuation Difference for the Third Local Currency), BDIFF (Valuation Difference).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP ACCCLR_ITM structure 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 |
AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
BDIF2 | Valuation Difference for the Second Local Currency | BDIF2 | CURR | 13(2) | WRTV7 | ||||
BDIF3 | Valuation Difference for the Third Local Currency | BDIF3 | CURR | 13(2) | WRTV7 | ||||
BDIFF | Valuation Difference | BDIFF | CURR | 13(2) | WRTV7 | ||||
BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
BLART | Document Type | BLART | CHAR | 2 | Assigned to domain | BLART | BAR | ||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
BSCHL | Posting Key | BSCHL | CHAR | 2 | Assigned to domain | BSCHL | |||
BSTAT | Document Status | BSTAT_D | CHAR | 1 | BSTAT | ||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
BUPLA | Business Place | BUPLA | CHAR | 4 | Assigned to domain | J_1BBRANCH | |||
BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | BUZEI | BUZ | |||
BUZID | Identification of the Line Item | BUZID | CHAR | 1 | CHAR1 | ||||
DABRZ | Reference Date for Settlement | DABRBEZ | DATS | 8 | DDAT | ||||
DMBE2 | Amount in Second Local Currency | DMBE2 | CURR | 13(2) | WERT7 | ||||
DMBE3 | Amount in Third Local Currency | DMBE3 | CURR | 13(2) | WERT7 | ||||
DMBTR | Amount in Local Currency | DMBTR | CURR | 13(2) | WERT7 | ||||
FIPOS | Commitment Item | FIPOS | CHAR | 14 | Assigned to domain | FIPOS | FIP | ||
FISTL | Funds Center | FISTL | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
FKBER | Functional Area | FKBER | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
GEBER | Fund | BP_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
HKONT | General Ledger Account | HKONT | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | IMKEY | ||||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
MWST2 | Tax Amount in Second Local Currency | MWST2 | CURR | 13(2) | WERT7 | ||||
MWST3 | Tax Amount in Third Local Currency | MWST3 | CURR | 13(2) | WERT7 | ||||
MWSTS | Tax Amount in Local Currency | MWSTS | CURR | 13(2) | WERT7 | ||||
PPDIF2 | Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments) | PPDIF2 | CURR | 13(2) | WRTV7 | ||||
PPDIF3 | Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments) | PPDIF3 | CURR | 13(2) | WRTV7 | ||||
PPDIFF | Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments) | PPDIFF | CURR | 13(2) | WRTV7 | ||||
PPRCT | Partner Profit Center | PPRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PPC | |
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
PROJK | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
PSWBT | Amount for Updating in General Ledger | PSWBT | CURR | 13(2) | WERT7 | ||||
PSWSL | Update Currency for General Ledger Transaction Figures | PSWSL | CUKY | 5 | Assigned to domain | WAERS | |||
QSSKZ | Withholding Tax Code | QSSKZ | CHAR | 2 | Assigned to domain | QSSKZ | |||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | Assigned to domain | ALPHA | RCOMP | PGS | |
WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
WMWST | Tax amount in document currency | WMWST | CURR | 13(2) | WERT7 | ||||
WRBTR | Amount in document currency | WRBTR | CURR | 13(2) | WERT7 | ||||
XBLNR | Reference Document Number | XBLNR1 | CHAR | 16 | XBLNR1 | ||||
XNEGP | Indicator: Negative posting | XNEGP | CHAR | 1 | XFELD | ||||
XRAGL | Indicator: Clearing was Reversed | XRAGL | CHAR | 1 | XFELD | ||||
XREF3 | Reference key for line item | XREF3 | CHAR | 20 | CHAR20 | ||||
XSTOV | Indicator: Document is flagged for reversal | XSTOV | CHAR | 1 | XFELD | ||||
ZFBDT | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | DATUM | ||||
ZUONR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
BUDGET_PD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
SKTFW | Cash discount amount in document currency | WSKTO | CURR | 13(2) | WERT7 | ||||
KDWBT | Difference Amount Due to Payment in Alternative Currency | KDWBT | CURR | 13(2) | WERT7 | ||||
ANFBJ | Fiscal Year of the Bill of Exchange Payment Request Document | ANFBJ | NUMC | 4 | GJAHR | GJAHR | |||
ANFBN | Document Number of the Bill of Exchange Payment Request | ANFBN | CHAR | 10 | ALPHA | BELNR | |||
ANFBU | Company Code in Which Bill of Exch.Payment Request Is Posted | ANFBU | CHAR | 4 | Assigned to domain | BUKRS | |||
ANLN1 | Main Asset Number | ANLN1 | CHAR | 12 | Assigned to domain | ALPHA | ANLN1 | AN1 | |
ANLN2 | New asset subnumber, 4 characters | ANLN2_4 | CHAR | 4 | ALPHA | ANLN2_4 | AN2 | ||
APLZL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
BVTYP | Partner Bank Type | BVTYP | CHAR | 4 | BVTYP | ||||
CESSION_KZ | Accounts Receivable Pledging Indicator | CESSION_KZ | CHAR | 2 | Assigned to domain | CESSION_KZ | |||
DIEKZ | Service Indicator (Foreign Payment) | DIEKZ | CHAR | 1 | DIEKZ | ||||
DMB21 | Amount in Second Local Currency for Tax Breakdown | DMB2X | CURR | 13(2) | WRTV7 | ||||
DMB22 | Amount in Second Local Currency for Tax Breakdown | DMB2X | CURR | 13(2) | WRTV7 | ||||
DMB23 | Amount in Second Local Currency for Tax Breakdown | DMB2X | CURR | 13(2) | WRTV7 | ||||
DMB31 | Amount in Third Local Currency for Tax Breakdown | DMB3X | CURR | 13(2) | WRTV7 | ||||
DMB32 | Amount in Third Local Currency for Tax Breakdown | DMB3X | CURR | 13(2) | WRTV7 | ||||
DMB33 | Amount in Third Local Currency for Tax Breakdown | DMB3X | CURR | 13(2) | WRTV7 | ||||
DMBT1 | Amount in Local Currency for Tax Distribution | DMBTX | CURR | 13(2) | WRTV7 | ||||
DMBT2 | Amount in Local Currency for Tax Distribution | DMBTX | CURR | 13(2) | WRTV7 | ||||
DMBT3 | Amount in Local Currency for Tax Distribution | DMBTX | CURR | 13(2) | WRTV7 | ||||
DTWS1 | Instruction key 1 | DTAT16 | NUMC | 2 | Assigned to domain | DTWSX | |||
DTWS2 | Instruction key 2 | DTAT17 | NUMC | 2 | Assigned to domain | DTWSX | |||
DTWS3 | Instruction key 3 | DTAT18 | NUMC | 2 | Assigned to domain | DTWSX | |||
DTWS4 | Instruction key 4 | DTAT19 | NUMC | 2 | Assigned to domain | DTWSX | |||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | Assigned to domain | EBELP | BSP | ||
EGBLD | Country of Destination for Delivery of Goods | EGBLD | CHAR | 3 | Assigned to domain | LAND1 | |||
EGLLD | Supplying Country for Delivery of Goods | EGLLD | CHAR | 3 | Assigned to domain | LAND1 | |||
EMPFB | Payee/Payer | EMPFB | CHAR | 10 | ALPHA | MAXKK | |||
ETEN2 | Delivery Schedule Line Number | ETENR | NUMC | 4 | Assigned to domain | ETENR | |||
FILKD | Account Number of the Branch | FILKD | CHAR | 10 | ALPHA | MAXKK | |||
HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | Assigned to domain | HBKID | |||
KBLNR | Document Number for Earmarked Funds | KBLNR_FI | CHAR | 10 | Assigned to domain | ALPHA | KBLNR | KBL | |
KBLPOS | Earmarked Funds: Document Item | KBLPOS | NUMC | 3 | Assigned to domain | KBLPOS | KBP | ||
KIDNO | Payment Reference | KIDNO | CHAR | 30 | CHAR30 | ||||
KKBER | Credit control area | KKBER | CHAR | 4 | Assigned to domain | KKBER | KKB | ||
LANDL | Supplying Country | LANDL | CHAR | 3 | Assigned to domain | LAND1 | |||
LOTKZ | Lot Number for Requests | PSO_LOTKZ | CHAR | 10 | ALPHA | LOTKZ | LOT | ||
LZBKZ | State Central Bank Indicator | LZBKZ | CHAR | 3 | Assigned to domain | LZBKZ | |||
MABER | Dunning Area | MABER | CHAR | 2 | Assigned to domain | MABER | |||
MANSP | Dunning block | MANSP | CHAR | 1 | Assigned to domain | MANSP | |||
MANST | Dunning level | MAHNS_D | NUMC | 1 | MAHNS | ||||
MWSK1 | Tax Code for Distribution | MWSKX | CHAR | 2 | Assigned to domain | MWSKZ | |||
MWSK2 | Tax Code for Distribution | MWSKX | CHAR | 2 | Assigned to domain | MWSKZ | |||
MWSK3 | Tax Code for Distribution | MWSKX | CHAR | 2 | Assigned to domain | MWSKZ | |||
NPLNR | Network Number for Account Assignment | NPLNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | NET | |
POSN2 | Sales Document Item | POSNR_VA | NUMC | 6 | Assigned to domain | POSNR | APO | ||
PYAMT | Amount in Payment Currency | PYAMT | CURR | 13(2) | WERT7 | ||||
PYCUR | Currency for Automatic Payment | PYCUR | CUKY | 5 | Assigned to domain | WAERS | |||
QBSHB | Withholding Tax Amount (in Document Currency) | QBSHB | CURR | 13(2) | WERT7 | ||||
QSSHB | Withholding Tax Base Amount | QSSHB | CURR | 13(2) | WERT7 | ||||
QSZNR | Certificate Number of the Withholding Tax Exemption | QSZNR | CHAR | 10 | CHAR10 | ||||
REBZG | Number of the Invoice the Transaction Belongs to | REBZG | CHAR | 10 | ALPHA | BELNR | |||
REBZJ | Fiscal Year of the Relevant Invoice (for Credit Memo) | REBZJ | NUMC | 4 | GJAHR | GJAHR | |||
REBZT | Follow-On Document Type | REBZT | CHAR | 1 | REBZT | ||||
REBZZ | Line Item in the Relevant Invoice | REBZZ | NUMC | 3 | BUZEI | ||||
RSTGR | Reason Code for Payments | RSTGR | CHAR | 3 | Assigned to domain | RSTGR | |||
SAKNR | G/L Account Number | SAKNR | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | SAK | C_SAKNR |
SAMNR | Invoice List Number | SAMNR | NUMC | 8 | SAMNR | ||||
SECCO | Section Code | SECCO | CHAR | 4 | Assigned to domain | SECCO | SECCO_ABA | ||
SKFBT | Amount Eligible for Cash Discount in Document Currency | SKFBT | CURR | 13(2) | WERT7 | ||||
SKNT2 | Cash Discount Amount in Second Local Currency | SKNT2 | CURR | 13(2) | WERT7 | ||||
SKNT3 | Cash Discount Amount in Third Local Currency | SKNT3 | CURR | 13(2) | WERT7 | ||||
SKNTO | Cash discount amount in local currency | SKNTO | CURR | 13(2) | WERT7 | ||||
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
UMSKS | Special G/L Transaction Type | UMSKS | CHAR | 1 | UMSKS | ||||
UMSKZ | Special G/L Indicator | UMSKZ | CHAR | 1 | Assigned to domain | UMSKZ | |||
UZAWE | Payment Method Supplement | UZAWE | CHAR | 2 | Assigned to domain | UZAWE | |||
VBEL2 | Sales Document | VBELN_VA | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
VBELN | Billing Document | VBELN_VF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | VF | |
VBEWA | Flow Type | SBEWART | CHAR | 4 | Assigned to domain | SBEWART | |||
VERTN | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
VERTT | Contract Type | RANTYP | CHAR | 1 | RANTYP | ||||
WRBT1 | Amount in foreign currency for tax breakdown | WRBTX | CURR | 13(2) | WRTV7 | ||||
WRBT2 | Amount in foreign currency for tax breakdown | WRBTX | CURR | 13(2) | WRTV7 | ||||
WRBT3 | Amount in foreign currency for tax breakdown | WRBTX | CURR | 13(2) | WRTV7 | ||||
WSKTO | Cash discount amount in document currency | WSKTO | CURR | 13(2) | WERT7 | ||||
XANET | Indicator: Down payment in net procedure ? | XANET | CHAR | 1 | XFELD | ||||
XCPDD | Indicator: Address and bank data set individually | XCPDD | CHAR | 1 | XFELD | ||||
XEGDR | Indicator: Triangular deal within the EU ? | XEGDR | CHAR | 1 | XFELD | ||||
XINVE | Indicator: Capital Goods Affected? | XINVE | CHAR | 1 | XFELD | ||||
XNETB | Indicator: Document posted net ? | XNETB | CHAR | 1 | XFELD | ||||
XPYPR | Indicator: Items from Payment Program Blocked | XPYPR | CHAR | 1 | XFELD | ||||
XREF1 | Business partner reference key | XREF1 | CHAR | 12 | CHAR12 | ||||
XREF2 | Business partner reference key | XREF2 | CHAR | 12 | CHAR12 | ||||
ZBD1P | Cash Discount Percentage 1 | DZBD1P | DEC | 5(3) | PRZ23 | ||||
ZBD1T | Cash discount days 1 | DZBD1T | DEC | 3 | ZBDXT | ||||
ZBD2P | Cash Discount Percentage 2 | DZBD2P | DEC | 5(3) | PRZ23 | ||||
ZBD2T | Cash discount days 2 | DZBD2T | DEC | 3 | ZBDXT | ||||
ZBD3T | Net Payment Terms Period | DZBD3T | DEC | 3 | ZBDXT | ||||
ZBFIX | Fixed Payment Terms | DZBFIX | CHAR | 1 | ZBFIX | ||||
ZEKKN | Sequential Number of Account Assignment | DZEKKN | NUMC | 2 | NUM02 | ||||
ZINKZ | Exempted from interest calculation | DZINKZ | CHAR | 2 | ZINKZ | ||||
ZLSCH | Payment Method | DZLSCH | CHAR | 1 | Assigned to domain | ZLSCH | |||
ZLSPR | Payment Block Key | DZLSPR | CHAR | 1 | Assigned to domain | ZAHLS | SPE | ||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
ZUMSK | Target Special G/L Indicator | DZUMSK | CHAR | 1 | Assigned to domain | UMSKZ | |||
BEWAR | Transaction Type | RMVCT | CHAR | 3 | Assigned to domain | RMVCT | |||
VALUT | Value date | VALUT | DATS | 8 | DATUM | ||||
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
KOART | Account Type | KOART | CHAR | 1 | KOART | ||||
KONKO | Open item account number | KONKO | CHAR | 10 | ALPHA | MAXKK | |||
WAERS_CLR | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
STATUS | Exception Status for the Open Item | STATU_OPS | CHAR | 1 | CHAR1 | ||||
DIFFW | Amount Difference in Foreign Currency | DIFFW | CURR | 13(2) | WRTV7 | ||||
DIFHW | Amount Difference in Local Currency | DIFHW | CURR | 13(2) | WERT7 | ||||
DIFH2 | Amount Difference in Second Local Currency | DIFH2 | CURR | 13(2) | WERT7 | ||||
DIFH3 | Amount Difference in Third Local Currency | DIFH3 | CURR | 13(2) | WERT7 | ||||
XAKTS | Indicator: Cash discount activated ? | XAKTS | CHAR | 1 | XFELD | ||||
XVORT | Indicator: Carryforward residual bal. for pmnt difference ? | XVORT | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP structure ACCCLR_ITM using ABAP code?
As ACCCLR_ITM is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on ACCCLR_ITM as there is no data to select.How to access SAP table ACCCLR_ITM
Within an ECC or HANA version of SAP you can also view further information about ACCCLR_ITM 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