TRACT_ACCITEM SAP (Accounting Items) Table details

Dictionary Type: Table
Description: Accounting Items




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




Table field list including key, data, relationships and ABAP select examples

TRACT_ACCITEM is a standard SAP Table which is used to store Accounting Items data and is available within R/3 SAP systems depending on the version and release level.

The TRACT_ACCITEM table consists of various fields, each holding specific information or linking keys about Accounting Items data available in SAP. These include DOCUMENT_GUID (Object Identity in Database Format), ITEM_NUMBER (Accounting Document Line Item Number), PC_GUID (Object Identity in Database Format), DIS_FLOWTYPE (Update Type).. 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 TRACT_ACCITEM 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
MANDTClient MANDTCLNT3Assigned to domainMANDT
DOCUMENT_GUIDObject Identity in Database Format TPM_DB_OS_GUIDCHAR32TRACT_DOCUMENTTPM_DB_OS_GUID
ITEM_NUMBERAccounting Document Line Item Number POSNR_ACCNUMC10POSNR_ACC
PC_GUIDObject Identity in Database Format TPM_DB_OS_GUIDCHAR32TRACT_POSCONTEXTTPM_DB_OS_GUID
DIS_FLOWTYPEUpdate Type TPM_DIS_FLOWTYPECHAR8TRDC_DFLOWTYPETPM_DIS_FLOWTYPE
SZARTPayment Transaction TPM_SZARTCHAR1XFELD
AA_REFAccount Assignment Reference of Position Management TPM_AA_REFCHAR12Assigned to domainTPM_AA_REFTRAC_AA_REF
ACC_SYMBOLAccount Symbol for Account Assignment Reference TPM_ACC_SYMBOLCHAR16TRAC_ACCSYMBTPM_ACC_SYMBOL
POSTING_CATPosting Category TPM_POSTING_CATINT13TPM_POSTING_CAT
POSTING_KEYPosting Key BSCHLCHAR2Assigned to domainBSCHL
GL_ACCOUNTG/L Account Number SAKNRCHAR10Assigned to domainALPHASAKNRSAKC_SAKNR
POSITION_AMTAmount in Transaction Currency TPM_FOREIGN_AMTCURR21(2) TPM_AMOUNT
POSITION_CURRTransaction Currency TPM_FOREIGN_CURRCUKY5Assigned to domainWAERS
LOCAL_AMTAmount (Local Currency) TPM_LOCAL_AMTCURR21(2) TPM_AMOUNT
LOCAL_CURRLocal Currency TPM_LOCAL_CURRCUKY5Assigned to domainWAERS
TRDFLOWNRNumber of a Distributor Flow TPM_TRDFLOWNRINT410TPM_TRDFLOWNR
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
REVERSAL_BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
LOGVOLogical Transaction LOGVOCHAR6LOGVO
BLARTDocument Type BLARTCHAR2Assigned to domainBLARTBAR
PAYMENT_DATEPayment Date TPM_PAYMENT_DATEDATS8TPM_POSITION_DATE
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
ZLSCHPayment Method DZLSCHCHAR1Assigned to domainZLSCH
UZAWEPayment Method Supplement UZAWECHAR2Assigned to domainUZAWE
ZLSPRPayment Block Key DZLSPRCHAR1Assigned to domainZAHLSSPE
RPZAHLPayer/payee TB_RPZAHL_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
RPBANKPartner bank details TB_RPBANKCHAR4BVTYP
HOUSE_BANKShort key for own house bank TB_RHABKICHAR5Assigned to domainHBKID
HOUSE_BANK_ACCShort key for house bank account TB_RHKTIDCHAR5Assigned to domainHKTID
SIGNDirection of flow TB_SSIGNCHAR1T_SSIGN
LZBKZState Central Bank Indicator LZBKZCHAR3Assigned to domainLZBKZ
LANDLSupplying Country LANDLCHAR3Assigned to domainLAND1
ALLOCNRAssignment Number DZUONRCHAR18ZUONR
SGTXTItem Text SGTXTCHAR50TEXT50
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
RMVCTTransaction Type RMVCTCHAR3Assigned to domainRMVCT
VBUNDCompany ID VBUNDCHAR6Assigned to domainALPHARCOMP
KONTRAHENTBusiness Partner Number TB_KUNNR_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
ISSUERIssuer Identity Key REPKE_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
SUB_FLOW_NUMBERNumber of a Distributor Flow TPM_TRDFLOWNRINT410TPM_TRDFLOWNR
MNDIDUnique Referene to Mandate per Payment Recipient SEPA_MNDIDCHAR35ID035

Key field Non-key field



How do I retrieve data from SAP table TRACT_ACCITEM using ABAP code

The following ABAP code Example will allow you to do a basic selection on TRACT_ACCITEM to SELECT all data from the table
DATA: WA_TRACT_ACCITEM TYPE TRACT_ACCITEM.

SELECT SINGLE *
FROM TRACT_ACCITEM
INTO CORRESPONDING FIELDS OF WA_TRACT_ACCITEM
WHERE...

How to access SAP table TRACT_ACCITEM

Within an ECC or HANA version of SAP you can also view further information about TRACT_ACCITEM 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!