/SRMERP/D_ACC_IT SAP table for – Account assignment item

Here we would like to draw your attention to /SRMERP/D_ACC_IT table in SAP. As we know it is being mainly used with the SAP MM-PUR (Purchasing in MM) component which is coming under MM module (Material Management). /SRMERP/D_ACC_IT is a SAP standard transparent table used for storing Account assignment item related data in SAP. It comes under the package /SRMERP/OL_DO_ACC.

SAP /SRMERP/D_ACC_IT table

Table /SRMERP/D_ACC_IT technical data

Table/SRMERP/D_ACC_IT
Data storingAccount assignment item
ModuleMM
ComponentMM-PUR
SAP Package/SRMERP/OL_DO_ACC
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP /SRMERP/D_ACC_IT Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in /SRMERP/D_ACC_IT table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • PARENT_NODE_KEY
    Its data type is X (Byte string) with field length 16
  • ZEXKN
    Its data type is N (Character String with Digits Only) with field length 2
  • LOEKZ : CHAR01 data element for SYST
    Its data type is C (Character String) with field length 1
  • AEDAT : (8-character) Date for SYST
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • SAKTO : Cost Element
    Its data type is C (Character String) with field length 10
  • GSBER : Business Area
    Its data type is C (Character String) with field length 4
  • KOSTL : Cost Center
    Its data type is C (Character String) with field length 10
  • VBELN : Sales and Distribution Document Number
    Its data type is C (Character String) with field length 10
  • VBELP
    Its data type is N (Character String with Digits Only) with field length 6
  • DB_KEY
    Its a key field. Its data type is X (Byte string) with field length 16
  • VETEN
    Its data type is N (Character String with Digits Only) with field length 4
  • ANLN1 : Main Asset Number
    Its data type is C (Character String) with field length 12
  • ANLN2 : Asset Subnumber
    Its data type is C (Character String) with field length 4
  • AUFNR : Order Number
    Its data type is C (Character String) with field length 12
  • ABLAD : Unloading Point
    Its data type is C (Character String) with field length 25
  • KOKRS : Controlling Area
    Its data type is C (Character String) with field length 4
  • KSTRG : Cost Object
    Its data type is C (Character String) with field length 12
  • PAOBJNR : Profitability Segment Number (CO-PA)
    Its data type is N (Character String with Digits Only) with field length 10
  • PRCTR : Profit Center
    Its data type is C (Character String) with field length 10
  • PS_PSP_PNR : Work Breakdown Structure Element (WBS Element)
    Its data type is N (Character String with Digits Only) with field length 8
  • ROOT_KEY
    Its data type is X (Byte string) with field length 16
  • NPLNR : Network Number for Account Assignment
    Its data type is C (Character String) with field length 12
  • AUFPL : Routing number of operations in the order
    Its data type is N (Character String with Digits Only) with field length 10
  • IMKEY : Internal Key for Real Estate Object
    Its data type is C (Character String) with field length 8
  • APLZL : Internal counter
    Its data type is N (Character String with Digits Only) with field length 8
  • VPTNR : Partner account number
    Its data type is C (Character String) with field length 10
  • FIPOS : Commitment Item
    Its data type is C (Character String) with field length 14
  • RECID : Recovery Indicator
    Its data type is C (Character String) with field length 2
  • FISTL : Funds Center
    Its data type is C (Character String) with field length 16
  • GEBER : Fund
    Its data type is C (Character String) with field length 10
  • GRANT_NBR : Grant
    Its data type is C (Character String) with field length 20
  • PARENT_KEY
    Its data type is X (Byte string) with field length 16
  • FKBER : Functional Area
    Its data type is C (Character String) with field length 16
  • DABRZ : Reference date for settlement
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • AUFPL_ORD
    Its data type is N (Character String with Digits Only) with field length 10
  • APLZL_ORD
    Its data type is N (Character String with Digits Only) with field length 8
  • MWSKZ : Tax on sales/purchases code
    Its data type is C (Character String) with field length 2
  • TXJCD : Tax Jurisdiction
    Its data type is C (Character String) with field length 15
  • LSTAR : Activity Type
    Its data type is C (Character String) with field length 6
  • PRZNR : Business Process
    Its data type is C (Character String) with field length 12
  • VORNR : Operation/Activity Number
    Its data type is C (Character String) with field length 4
  • PSP_PNR
    Its data type is C (Character String) with field length 24
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is /SRMERP/S_ACC_ITM_D
  • MENGE_F
    Its data type is F (Floating point number) with field length 8
  • BUDGET_PD : FM: Budget Period
    Its data type is C (Character String) with field length 10
  • KBLNR : Document Number for Earmarked Funds
    Its data type is C (Character String) with field length 10
  • KBLPOS : Earmarked Funds: Document Item
    Its data type is N (Character String with Digits Only) with field length 3
  • FM_SPLIT_BATCH
    Its data type is N (Character String with Digits Only) with field length 3
  • FM_SPLIT_BEGRU
    Its data type is C (Character String) with field length 4
  • RECIPIENT_KEY
    Its data type is X (Byte string) with field length 16
  • MENGE : Quantity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • VPROZ
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • NETWR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7