PSOSEGS SAP table for – Recurring Request Document Segment, G/L Accounts

Here we would like to draw your attention to PSOSEGS table in SAP. As we know it is being mainly used with the SAP PSM-FM (Funds Management in PSM) component which is coming under PSM module (Public Sector Management). PSOSEGS is a SAP standard transp table used for storing Recurring Request Document Segment, G/L Accounts related data in SAP. It comes under the package FMFI.

SAP PSOSEGS table

Table PSOSEGS technical data

TablePSOSEGS
Data storingRecurring Request Document Segment, G/L Accounts
ModulePSM
Sub ModulePSM-FM-PO
SAP PackageFMFI
Delivery ClassA – Application table (master and transaction data)
ComponentEA-PS
Table CategoryTRANSP

SAP PSOSEGS Table Fields

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • LOTKZ : Lot Number for Documents
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • ITABKEY : Internal key of internal table
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • GJAHR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • BZKEY : Number of Line Item Within Accounting Document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • AUSBK : Source Company Code
    Its data type is CHAR (Character String) with field length 4
  • BUZEI : Number of Line Item Within Accounting Document
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • BSCHL : Posting Key
    Its data type is CHAR (Character String) with field length 2
  • SHKZG : Debit/Credit Indicator
    Its data type is CHAR (Character String) with field length 1
  • GSBER : Business Area
    Its data type is CHAR (Character String) with field length 4
  • PARGB : Trading partner’s business area
    Its data type is CHAR (Character String) with field length 4
  • MWSKZ : Tax on sales/purchases code
    Its data type is CHAR (Character String) with field length 2
  • DMBTR : Amount in local currency
    Its data type is CURR (Currency Field) with field length 13
  • DMBE2 : Amount in Second Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • DMBE3 : Amount in Third Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • WRBTR : Amount in document currency
    Its data type is CURR (Currency Field) with field length 13
  • HWMET : Method with Which the Local Currency Amount Was Determined
    Its data type is CHAR (Character String) with field length 1
  • HWBAS : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • FWBAS : Tax Base Amount in Document Currency
    Its data type is CURR (Currency Field) with field length 13
  • MWART : Tax Type
    Its data type is CHAR (Character String) with field length 1
  • KURSR : Hedged Exchange Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • GBETR : Hedged Amount in Foreign Currency
    Its data type is CURR (Currency Field) with field length 13
  • ZFBDT : Baseline date for due date calculation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALUT : Fixed Value Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ZUONR : Assignment number
    Its data type is CHAR (Character String) with field length 18
  • SGTXT : Item Text
    Its data type is CHAR (Character String) with field length 50
  • ZINKZ : Exempted from Interest Calculation
    Its data type is CHAR (Character String) with field length 2
  • RMVCT : Transaction type
    Its data type is CHAR (Character String) with field length 3
  • FDLEV : Planning Level
    Its data type is CHAR (Character String) with field length 2
  • FDGRP : Planning Group
    Its data type is CHAR (Character String) with field length 10
  • FDWBT : Planned Amount in Document or G/L Account Currency
    Its data type is CURR (Currency Field) with field length 13
  • FDTAG : Planning Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • KOKRS : Controlling Area
    Its data type is CHAR (Character String) with field length 4
  • KOSTL : Cost Center
    Its data type is CHAR (Character String) with field length 10
  • AUFNR : Order Number
    Its data type is CHAR (Character String) with field length 12
  • KDAUF : Sales Order Number
    Its data type is CHAR (Character String) with field length 10
  • KDPOS : Item number in Sales Order
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • PPRCTR : Partner Profit Center
    Its data type is CHAR (Character String) with field length 10
  • IMKEY : Internal Key for Real Estate Object
    Its data type is CHAR (Character String) with field length 8
  • PERNR : Personnel Number
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • XUMSW : Indicator: Sales-Related Item ?
    Its data type is CHAR (Character String) with field length 1
  • XSKRL : Indicator: Line item not liable to cash discount?
    Its data type is CHAR (Character String) with field length 1
  • SAKNR : G/L Account Number
    Its data type is CHAR (Character String) with field length 10
  • HZUON : Assignment Number for Special G/L Accounts
    Its data type is CHAR (Character String) with field length 18
  • MATNR : Material Number
    Its data type is CHAR (Character String) with field length 18
  • WERKS : Plant
    Its data type is CHAR (Character String) with field length 4
  • MENGE : Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • MEINS : Base Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • BPMNG : Quantity in order price quantity unit
    Its data type is QUAN (Quantity field) with field length 13
  • EBELN : Purchasing Document Number
    Its data type is CHAR (Character String) with field length 10
  • EBELP : Item Number of Purchasing Document
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • REWRT : Invoice Value Entered (in Local Currency)
    Its data type is CURR (Currency Field) with field length 13
  • REWWR : Invoice Value in Foreign Currency
    Its data type is CURR (Currency Field) with field length 13
  • ZEKKN : Sequential Number of Account Assignment
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • LFBNR : Number of goods receipt document
    Its data type is CHAR (Character String) with field length 10
  • LFPOS : Item in material document
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • LFGJA : Year of material document
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • BWKEY : Valuation area
    Its data type is CHAR (Character String) with field length 4
  • BWTAR : Valuation type
    Its data type is CHAR (Character String) with field length 10
  • TBTKZ : Indicator: Subsequent Debit/Credit
    Its data type is CHAR (Character String) with field length 1
  • STCEG : VAT Registration Number
    Its data type is CHAR (Character String) with field length 20
  • PRCTR : Profit Center
    Its data type is CHAR (Character String) with field length 10
  • VNAME : Joint venture
    Its data type is CHAR (Character String) with field length 6
  • RECID : Recovery Indicator
    Its data type is CHAR (Character String) with field length 2
  • EGRUP : Equity group
    Its data type is CHAR (Character String) with field length 3
  • VPTNR : Partner account number
    Its data type is CHAR (Character String) with field length 10
  • VERTT : Contract Type
    Its data type is CHAR (Character String) with field length 1
  • VERTN : Contract Number
    Its data type is CHAR (Character String) with field length 13
  • VBEWA : Flow Type
    Its data type is CHAR (Character String) with field length 4
  • TXJCD : Tax Jurisdiction
    Its data type is CHAR (Character String) with field length 15
  • DABRZ : Reference date for settlement
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • KSTRG : Cost Object
    Its data type is CHAR (Character String) with field length 12
  • NPLNR : Network Number for Account Assignment
    Its data type is CHAR (Character String) with field length 12
  • AUFPL : Routing number of operations in the order
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • PS_PSP_PNR : Work Breakdown Structure Element (WBS Element)
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • PAOBJNR : Profitability Segment Number (CO-PA)
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • PASUBNR : Profitability Segment Changes (CO-PA)
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • BTYPE : Payroll Type
    Its data type is CHAR (Character String) with field length 2
  • ETYPE : Equity type
    Its data type is CHAR (Character String) with field length 3
  • XEGDR : Indicator: Triangular deal within the EU ?
    Its data type is CHAR (Character String) with field length 1
  • HRKFT : Origin Group as Subdivision of Cost Element
    Its data type is CHAR (Character String) with field length 4
  • FIPOS : Commitment Item
    Its data type is CHAR (Character String) with field length 14
  • KOART : Account type
    Its data type is CHAR (Character String) with field length 1
  • VPRSV : Price control indicator
    Its data type is CHAR (Character String) with field length 1
  • PEINH : Price unit
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • KDEIN : Schedule line
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • ANLN1 : Main Asset Number
    Its data type is CHAR (Character String) with field length 12
  • ANLN2 : Asset Subnumber
    Its data type is CHAR (Character String) with field length 4
  • SMWSK : Tax Category in Account Master Record
    Its data type is CHAR (Character String) with field length 2
  • SWAER : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • STUNR : Level Number
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • ZAEHK : Condition counter
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • XFDIS : Indicator: Cash Management activated?
    Its data type is CHAR (Character String) with field length 1
  • KBLNR : Document number for earmarked funds
    Its data type is CHAR (Character String) with field length 10
  • KBLPOS : Earmarked Funds: Document Item
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • STTAX : Tax Amount as Statistical Information in Document Currency
    Its data type is CURR (Currency Field) with field length 13
  • GEBER : Fund
    Its data type is CHAR (Character String) with field length 10
  • FISTL : Funds Center
    Its data type is CHAR (Character String) with field length 16
  • VORNR : Operation/Activity Number
    Its data type is CHAR (Character String) with field length 4
  • ABPER : Settlement period
    Its data type is ACCP (Posting period YYYYMM) with field length 6
  • EREKZ : Final Invoice Indicator
    Its data type is CHAR (Character String) with field length 1
  • FKBER : Functional Area
    Its data type is CHAR (Character String) with field length 16
  • VBUND : Company ID of trading partner
    Its data type is CHAR (Character String) with field length 6
  • XREF1 : Business partner reference key
    Its data type is CHAR (Character String) with field length 12
  • XREF2 : Business partner reference key
    Its data type is CHAR (Character String) with field length 12
  • XREF3 : Reference key for line item
    Its data type is CHAR (Character String) with field length 20
  • CCBTC : Payment cards: Settlement run
    Its data type is CHAR (Character String) with field length 10
  • RSTGR : Reason Code for Payments
    Its data type is CHAR (Character String) with field length 3
  • GRICD : Activity Code for Gross Income Tax
    Its data type is CHAR (Character String) with field length 2
  • GRIRG : Region (State, Province, County)
    Its data type is CHAR (Character String) with field length 3
  • GITYP : Distribution Type for Employment Tax
    Its data type is CHAR (Character String) with field length 2
  • IDXSP : Inflation Index
    Its data type is CHAR (Character String) with field length 5
  • BUZID : Identification of the Line Item
    Its data type is CHAR (Character String) with field length 1
  • ERLKZ : Completion indicator for line item
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • FIPEX : Commitment item
    Its data type is CHAR (Character String) with field length 24
  • CHWRB : Document Parking: Amount not Modifiable
    Its data type is CHAR (Character String) with field length 1
  • BZDAT : Asset Value Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • KONTT : Account Assignment Category for Industry Solution
    Its data type is CHAR (Character String) with field length 2
  • KONTL : Acct assignment string for industry-specific acct assignmnts
    Its data type is CHAR (Character String) with field length 50
  • GRANT_NBR : Grant
    Its data type is CHAR (Character String) with field length 20
  • FKBER_LONG : Functional Area
    Its data type is CHAR (Character String) with field length 16
  • PRZNR : Business Process
    Its data type is CHAR (Character String) with field length 12