ACCCLR_ITM SAP (Accounting Interface: Items to be Cleared) Structure details

Dictionary Type: Structure
Description: Accounting Interface: Items to be Cleared




ABAP Code to SELECT data from ACCCLR_ITM
Related tables to ACCCLR_ITM
Access table ACCCLR_ITM




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
AUFNROrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
BDIF2Valuation Difference for the Second Local Currency BDIF2CURR13(2) WRTV7
BDIF3Valuation Difference for the Third Local Currency BDIF3CURR13(2) WRTV7
BDIFFValuation Difference BDIFFCURR13(2) WRTV7
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
BLARTDocument Type BLARTCHAR2Assigned to domainBLARTBAR
BLDATDocument Date in Document BLDATDATS8DATUM
BSCHLPosting Key BSCHLCHAR2Assigned to domainBSCHL
BSTATDocument Status BSTAT_DCHAR1BSTAT
BUDATPosting Date in the Document BUDATDATS8DATUM
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
BUPLABusiness Place BUPLACHAR4Assigned to domainJ_1BBRANCH
BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
BUZIDIdentification of the Line Item BUZIDCHAR1CHAR1
DABRZReference Date for Settlement DABRBEZDATS8DDAT
DMBE2Amount in Second Local Currency DMBE2CURR13(2) WERT7
DMBE3Amount in Third Local Currency DMBE3CURR13(2) WERT7
DMBTRAmount in Local Currency DMBTRCURR13(2) WERT7
FIPOSCommitment Item FIPOSCHAR14Assigned to domainFIPOSFIP
FISTLFunds Center FISTLCHAR16Assigned to domainFISTLFIS
FKBERFunctional Area FKBERCHAR16Assigned to domainFKBERFBE
GEBERFund BP_GEBERCHAR10Assigned to domainBP_GEBERFIC
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
HKONTGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
IMKEYInternal Key for Real Estate Object IMKEYCHAR8IMKEY
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
MWSKZTax on sales/purchases code MWSKZCHAR2Assigned to domainMWSKZ
MWST2Tax Amount in Second Local Currency MWST2CURR13(2) WERT7
MWST3Tax Amount in Third Local Currency MWST3CURR13(2) WERT7
MWSTSTax Amount in Local Currency MWSTSCURR13(2) WERT7
PPDIF2Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments) PPDIF2CURR13(2) WRTV7
PPDIF3Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments) PPDIF3CURR13(2) WRTV7
PPDIFFRealized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments) PPDIFFCURR13(2) WRTV7
PPRCTPartner Profit Center PPRCTRCHAR10Assigned to domainALPHAPRCTRPPC
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
PROJKWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8Assigned to domainKONPRPS_POSNR
PSWBTAmount for Updating in General Ledger PSWBTCURR13(2) WERT7
PSWSLUpdate Currency for General Ledger Transaction Figures PSWSLCUKY5Assigned to domainWAERS
QSSKZWithholding Tax Code QSSKZCHAR2Assigned to domainQSSKZ
SGTXTItem Text SGTXTCHAR50TEXT50
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
VBUNDCompany ID of trading partner RASSCCHAR6Assigned to domainALPHARCOMPPGS
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
WMWSTTax amount in document currency WMWSTCURR13(2) WERT7
WRBTRAmount in document currency WRBTRCURR13(2) WERT7
XBLNRReference Document Number XBLNR1CHAR16XBLNR1
XNEGPIndicator: Negative posting XNEGPCHAR1XFELD
XRAGLIndicator: Clearing was Reversed XRAGLCHAR1XFELD
XREF3Reference key for line item XREF3CHAR20CHAR20
XSTOVIndicator: Document is flagged for reversal XSTOVCHAR1XFELD
ZFBDTBaseline Date for Due Date Calculation DZFBDTDATS8DATUM
ZUONRAssignment Number DZUONRCHAR18ZUONR
BUDGET_PDFM: Budget Period FM_BUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIODBUDPER
SKTFWCash discount amount in document currency WSKTOCURR13(2) WERT7
KDWBTDifference Amount Due to Payment in Alternative Currency KDWBTCURR13(2) WERT7
ANFBJFiscal Year of the Bill of Exchange Payment Request Document ANFBJNUMC4GJAHRGJAHR
ANFBNDocument Number of the Bill of Exchange Payment Request ANFBNCHAR10ALPHABELNR
ANFBUCompany Code in Which Bill of Exch.Payment Request Is Posted ANFBUCHAR4Assigned to domainBUKRS
ANLN1Main Asset Number ANLN1CHAR12Assigned to domainALPHAANLN1AN1
ANLN2New asset subnumber, 4 characters ANLN2_4CHAR4ALPHAANLN2_4AN2
APLZLInternal counter CIM_COUNTNUMC8CIM_COUNT
AUFPLRouting number of operations in the order CO_AUFPLNUMC10AUFPL
BVTYPPartner Bank Type BVTYPCHAR4BVTYP
CESSION_KZAccounts Receivable Pledging Indicator CESSION_KZCHAR2Assigned to domainCESSION_KZ
DIEKZService Indicator (Foreign Payment) DIEKZCHAR1DIEKZ
DMB21Amount in Second Local Currency for Tax Breakdown DMB2XCURR13(2) WRTV7
DMB22Amount in Second Local Currency for Tax Breakdown DMB2XCURR13(2) WRTV7
DMB23Amount in Second Local Currency for Tax Breakdown DMB2XCURR13(2) WRTV7
DMB31Amount in Third Local Currency for Tax Breakdown DMB3XCURR13(2) WRTV7
DMB32Amount in Third Local Currency for Tax Breakdown DMB3XCURR13(2) WRTV7
DMB33Amount in Third Local Currency for Tax Breakdown DMB3XCURR13(2) WRTV7
DMBT1Amount in Local Currency for Tax Distribution DMBTXCURR13(2) WRTV7
DMBT2Amount in Local Currency for Tax Distribution DMBTXCURR13(2) WRTV7
DMBT3Amount in Local Currency for Tax Distribution DMBTXCURR13(2) WRTV7
DTWS1Instruction key 1 DTAT16NUMC2Assigned to domainDTWSX
DTWS2Instruction key 2 DTAT17NUMC2Assigned to domainDTWSX
DTWS3Instruction key 3 DTAT18NUMC2Assigned to domainDTWSX
DTWS4Instruction key 4 DTAT19NUMC2Assigned to domainDTWSX
EBELNPurchasing Document Number EBELNCHAR10Assigned to domainALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document EBELPNUMC5Assigned to domainEBELPBSP
EGBLDCountry of Destination for Delivery of Goods EGBLDCHAR3Assigned to domainLAND1
EGLLDSupplying Country for Delivery of Goods EGLLDCHAR3Assigned to domainLAND1
EMPFBPayee/Payer EMPFBCHAR10ALPHAMAXKK
ETEN2Delivery Schedule Line Number ETENRNUMC4Assigned to domainETENR
FILKDAccount Number of the Branch FILKDCHAR10ALPHAMAXKK
HBKIDShort Key for a House Bank HBKIDCHAR5Assigned to domainHBKID
KBLNRDocument Number for Earmarked Funds KBLNR_FICHAR10Assigned to domainALPHAKBLNRKBL
KBLPOSEarmarked Funds: Document Item KBLPOSNUMC3Assigned to domainKBLPOSKBP
KIDNOPayment Reference KIDNOCHAR30CHAR30
KKBERCredit control area KKBERCHAR4Assigned to domainKKBERKKB
LANDLSupplying Country LANDLCHAR3Assigned to domainLAND1
LOTKZLot Number for Requests PSO_LOTKZCHAR10ALPHALOTKZLOT
LZBKZState Central Bank Indicator LZBKZCHAR3Assigned to domainLZBKZ
MABERDunning Area MABERCHAR2Assigned to domainMABER
MANSPDunning block MANSPCHAR1Assigned to domainMANSP
MANSTDunning level MAHNS_DNUMC1MAHNS
MWSK1Tax Code for Distribution MWSKXCHAR2Assigned to domainMWSKZ
MWSK2Tax Code for Distribution MWSKXCHAR2Assigned to domainMWSKZ
MWSK3Tax Code for Distribution MWSKXCHAR2Assigned to domainMWSKZ
NPLNRNetwork Number for Account Assignment NPLNRCHAR12Assigned to domainALPHAAUFNRNET
POSN2Sales Document Item POSNR_VANUMC6Assigned to domainPOSNRAPO
PYAMTAmount in Payment Currency PYAMTCURR13(2) WERT7
PYCURCurrency for Automatic Payment PYCURCUKY5Assigned to domainWAERS
QBSHBWithholding Tax Amount (in Document Currency) QBSHBCURR13(2) WERT7
QSSHBWithholding Tax Base Amount QSSHBCURR13(2) WERT7
QSZNRCertificate Number of the Withholding Tax Exemption QSZNRCHAR10CHAR10
REBZGNumber of the Invoice the Transaction Belongs to REBZGCHAR10ALPHABELNR
REBZJFiscal Year of the Relevant Invoice (for Credit Memo) REBZJNUMC4GJAHRGJAHR
REBZTFollow-On Document Type REBZTCHAR1REBZT
REBZZLine Item in the Relevant Invoice REBZZNUMC3BUZEI
RSTGRReason Code for Payments RSTGRCHAR3Assigned to domainRSTGR
SAKNRG/L Account Number SAKNRCHAR10Assigned to domainALPHASAKNRSAKC_SAKNR
SAMNRInvoice List Number SAMNRNUMC8SAMNR
SECCOSection Code SECCOCHAR4Assigned to domainSECCOSECCO_ABA
SKFBTAmount Eligible for Cash Discount in Document Currency SKFBTCURR13(2) WERT7
SKNT2Cash Discount Amount in Second Local Currency SKNT2CURR13(2) WERT7
SKNT3Cash Discount Amount in Third Local Currency SKNT3CURR13(2) WERT7
SKNTOCash discount amount in local currency SKNTOCURR13(2) WERT7
STCEGVAT Registration Number STCEGCHAR20STCEG
UMSKSSpecial G/L Transaction Type UMSKSCHAR1UMSKS
UMSKZSpecial G/L Indicator UMSKZCHAR1Assigned to domainUMSKZ
UZAWEPayment Method Supplement UZAWECHAR2Assigned to domainUZAWE
VBEL2Sales Document VBELN_VACHAR10Assigned to domainALPHAVBELNAUN
VBELNBilling Document VBELN_VFCHAR10Assigned to domainALPHAVBELNVF
VBEWAFlow Type SBEWARTCHAR4Assigned to domainSBEWART
VERTNContract Number RANLCHAR13ALPHARANLRAN
VERTTContract Type RANTYPCHAR1RANTYP
WRBT1Amount in foreign currency for tax breakdown WRBTXCURR13(2) WRTV7
WRBT2Amount in foreign currency for tax breakdown WRBTXCURR13(2) WRTV7
WRBT3Amount in foreign currency for tax breakdown WRBTXCURR13(2) WRTV7
WSKTOCash discount amount in document currency WSKTOCURR13(2) WERT7
XANETIndicator: Down payment in net procedure ? XANETCHAR1XFELD
XCPDDIndicator: Address and bank data set individually XCPDDCHAR1XFELD
XEGDRIndicator: Triangular deal within the EU ? XEGDRCHAR1XFELD
XINVEIndicator: Capital Goods Affected? XINVECHAR1XFELD
XNETBIndicator: Document posted net ? XNETBCHAR1XFELD
XPYPRIndicator: Items from Payment Program Blocked XPYPRCHAR1XFELD
XREF1Business partner reference key XREF1CHAR12CHAR12
XREF2Business partner reference key XREF2CHAR12CHAR12
ZBD1PCash Discount Percentage 1 DZBD1PDEC5(3) PRZ23
ZBD1TCash discount days 1 DZBD1TDEC3ZBDXT
ZBD2PCash Discount Percentage 2 DZBD2PDEC5(3) PRZ23
ZBD2TCash discount days 2 DZBD2TDEC3ZBDXT
ZBD3TNet Payment Terms Period DZBD3TDEC3ZBDXT
ZBFIXFixed Payment Terms DZBFIXCHAR1ZBFIX
ZEKKNSequential Number of Account Assignment DZEKKNNUMC2NUM02
ZINKZExempted from interest calculation DZINKZCHAR2ZINKZ
ZLSCHPayment Method DZLSCHCHAR1Assigned to domainZLSCH
ZLSPRPayment Block Key DZLSPRCHAR1Assigned to domainZAHLSSPE
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
ZUMSKTarget Special G/L Indicator DZUMSKCHAR1Assigned to domainUMSKZ
BEWARTransaction Type RMVCTCHAR3Assigned to domainRMVCT
VALUTValue date VALUTDATS8DATUM
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
KOARTAccount Type KOARTCHAR1KOART
KONKOOpen item account number KONKOCHAR10ALPHAMAXKK
WAERS_CLRCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
STATUSException Status for the Open Item STATU_OPSCHAR1CHAR1
DIFFWAmount Difference in Foreign Currency DIFFWCURR13(2) WRTV7
DIFHWAmount Difference in Local Currency DIFHWCURR13(2) WERT7
DIFH2Amount Difference in Second Local Currency DIFH2CURR13(2) WERT7
DIFH3Amount Difference in Third Local Currency DIFH3CURR13(2) WERT7
XAKTSIndicator: Cash discount activated ? XAKTSCHAR1XFELD
XVORTIndicator: Carryforward residual bal. for pmnt difference ? XVORTCHAR1XFELD

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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!