1. SAP Tutorial
  2. Real Estate Management

/CEERE/BSEG SAP table for – Property tax: booked FI items

Here we would like to draw your attention to /CEERE/BSEG table in SAP. As we know it is being mainly used with the SAP RE-FX (Flexible Real Estate Management in RE) component which is coming under RE module (Real Estate Management). /CEERE/BSEG is a SAP standard transp table used for storing Property tax: booked FI items related data in SAP. It comes under the package /CEERE/DANNEM.

SAP /CEERE/BSEG table

Table /CEERE/BSEG technical data

Table/CEERE/BSEG
Data storingProperty tax: booked FI items
ModuleRE
Sub ModuleRE-FX-LC-CZ
SAP Package/CEERE/DANNEM
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

SAP /CEERE/BSEG 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 /CEERE/BSEG table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • BELNR : Accounting Document Number
    Its a key field. Its data type is CHAR (Character String) 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
  • BUZEI : 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
  • BUZID : Identification of the Line Item
    Its data type is CHAR (Character String) with field length 1
  • AUGDT : Clearing Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AUGCP : Clearing Entry Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AUGBL : Document Number of the Clearing Document
    Its data type is CHAR (Character String) with field length 10
  • BSCHL : Posting Key
    Its data type is CHAR (Character String) with field length 2
  • KOART : Account type
    Its data type is CHAR (Character String) with field length 1
  • UMSKZ : Special G/L Indicator
    Its data type is CHAR (Character String) with field length 1
  • UMSKS : Special G/L Transaction Type
    Its data type is CHAR (Character String) with field length 1
  • ZUMSK : Target Special G/L Indicator
    Its data type is CHAR (Character String) with field length 1
  • 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
  • QSSKZ : Withholding Tax 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
  • WRBTR : Amount in document currency
    Its data type is CURR (Currency Field) with field length 13
  • KZBTR : Original Reduction Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • PSWBT : Amount for Updating in General Ledger
    Its data type is CURR (Currency Field) with field length 13
  • PSWSL : Update Currency for General Ledger Transaction Figures
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • TXBHW : Original Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • TXBFW : Original Tax Base Amount in Document Currency
    Its data type is CURR (Currency Field) with field length 13
  • MWSTS : Tax Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • WMWST : Tax amount in document currency
    Its data type is CURR (Currency Field) with field length 13
  • 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
  • HWZUZ : Provision Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • FWZUZ : Additional Tax in Document Currency
    Its data type is CURR (Currency Field) with field length 13
  • SHZUZ : Debit/Credit Addition for Cash Discount
    Its data type is CHAR (Character String) with field length 1
  • STEKZ : Version Number Component
    Its data type is CHAR (Character String) with field length 2
  • MWART : Tax Type
    Its data type is CHAR (Character String) with field length 1
  • TXGRP : Group Indicator for Tax Line Items
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • KTOSL : Transaction Key
    Its data type is CHAR (Character String) with field length 3
  • QSSHB : Withholding Tax Base Amount
    Its data type is CURR (Currency Field) with field length 13
  • 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
  • BDIFF : Valuation Difference
    Its data type is CURR (Currency Field) with field length 13
  • BDIF2 : Valuation Difference for the Second Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • 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
  • VBUND : Company ID of trading partner
    Its data type is CHAR (Character String) with field length 6
  • BEWAR : Transaction type
    Its data type is CHAR (Character String) with field length 3
  • ALTKT : Group Account Number
    Its data type is CHAR (Character String) with field length 10
  • VORGN : Transaction Type for General Ledger
    Its data type is CHAR (Character String) with field length 4
  • 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
  • FKONT : Financial Budget Item
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • 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
  • PROJN : Old: Project number : No longer used –> PS_POSNR
    Its data type is CHAR (Character String) with field length 16
  • AUFNR : Order Number
    Its data type is CHAR (Character String) with field length 12
  • VBELN : Billing document
    Its data type is CHAR (Character String) with field length 10
  • VBEL2 : Sales Document
    Its data type is CHAR (Character String) with field length 10
  • POSN2 : Sales Document Item
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • ETEN2 : 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
  • ANBWA : Asset Transaction Type
    Its data type is CHAR (Character String) with field length 3
  • BZDAT : Asset Value Date
    Its data type is DATS (Date (Date: YYYYMMDD)) 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
  • XHRES : Indicator: Resident G/L Account?
    Its data type is CHAR (Character String) with field length 1
  • XKRES : Indicator: Can Line Items Be Displayed by Account?
    Its data type is CHAR (Character String) with field length 1
  • XOPVW : Indicator: Open Item Management?
    Its data type is CHAR (Character String) with field length 1
  • XCPDD : Indicator: Address and Bank Data Set Individually
    Its data type is CHAR (Character String) with field length 1
  • XSKST : Indicator: Statistical Posting to Cost Center
    Its data type is CHAR (Character String) with field length 1
  • XSAUF : Indicator: Posting to Order Is Statistical
    Its data type is CHAR (Character String) with field length 1
  • XSPRO : Indicator: Posting to Project Is Statistical
    Its data type is CHAR (Character String) with field length 1
  • XSERG : Indicator: Posting to Profitability Analysis Is Statistical
    Its data type is CHAR (Character String) with field length 1
  • XFAKT : Indicator: Billing Document Update Successful?
    Its data type is CHAR (Character String) with field length 1
  • XUMAN : Indicator: Transfer Posting from Down Payment?
    Its data type is CHAR (Character String) with field length 1
  • XANET : Indicator: Down Payment in Net Procedure?
    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
  • XINVE : Indicator: Capital Goods Affected?
    Its data type is CHAR (Character String) with field length 1
  • XPANZ : Display item
    Its data type is CHAR (Character String) with field length 1
  • XAUTO : Indicator: Line item automatically created
    Its data type is CHAR (Character String) with field length 1
  • XNCOP : Indicator: Items Cannot Be Copied?
    Its data type is CHAR (Character String) with field length 1
  • XZAHL : Indicator: Is Posting Key Used in a Payment Transaction?
    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
  • HKONT : General Ledger Account
    Its data type is CHAR (Character String) with field length 10
  • KUNNR : Customer Number
    Its data type is CHAR (Character String) with field length 10
  • LIFNR : Account Number of Vendor or Creditor
    Its data type is CHAR (Character String) with field length 10
  • FILKD : Account Number of the Branch
    Its data type is CHAR (Character String) with field length 10
  • XBILK : Indicator: Account is a balance sheet account?
    Its data type is CHAR (Character String) with field length 1
  • GVTYP : P&L statement account type
    Its data type is CHAR (Character String) with field length 2
  • HZUON : Assignment Number for Special G/L Accounts
    Its data type is CHAR (Character String) with field length 18
  • ZFBDT : Baseline date for due date calculation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ZTERM : Terms of payment key
    Its data type is CHAR (Character String) with field length 4
  • ZBD1T : Cash discount days 1
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • ZBD2T : Cash discount days 2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • ZBD3T : Net Payment Terms Period
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • ZBD1P : Cash discount percentage 1
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • ZBD2P : Cash Discount Percentage 2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • SKFBT : Amount Eligible for Cash Discount in Document Currency
    Its data type is CURR (Currency Field) with field length 13
  • SKNTO : Cash discount amount in local currency
    Its data type is CURR (Currency Field) with field length 13
  • WSKTO : Cash Discount Amount in Document Currency
    Its data type is CURR (Currency Field) with field length 13
  • ZLSCH : Payment Method
    Its data type is CHAR (Character String) with field length 1
  • ZLSPR : Payment Block Key
    Its data type is CHAR (Character String) with field length 1
  • ZBFIX : Fixed Payment Terms
    Its data type is CHAR (Character String) with field length 1
  • HBKID : Short key for a house bank
    Its data type is CHAR (Character String) with field length 5
  • BVTYP : Partner bank type
    Its data type is CHAR (Character String) with field length 4
  • NEBTR : Net Payment Amount
    Its data type is CURR (Currency Field) with field length 13
  • MWSK1 : Tax Code for Distribution
    Its data type is CHAR (Character String) with field length 2
  • DMBT1 : Amount in Local Currency for Tax Distribution
    Its data type is CURR (Currency Field) with field length 13
  • WRBT1 : Amount in foreign currency for tax breakdown
    Its data type is CURR (Currency Field) with field length 13
  • MWSK2 : Tax Code for Distribution
    Its data type is CHAR (Character String) with field length 2
  • DMBT2 : Amount in Local Currency for Tax Distribution
    Its data type is CURR (Currency Field) with field length 13
  • WRBT2 : Amount in foreign currency for tax breakdown
    Its data type is CURR (Currency Field) with field length 13
  • MWSK3 : Tax Code for Distribution
    Its data type is CHAR (Character String) with field length 2
  • DMBT3 : Amount in Local Currency for Tax Distribution
    Its data type is CURR (Currency Field) with field length 13
  • WRBT3 : Amount in foreign currency for tax breakdown
    Its data type is CURR (Currency Field) with field length 13
  • REBZG : Number of the Invoice the Transaction Belongs to
    Its data type is CHAR (Character String) with field length 10
  • REBZJ : Fiscal Year of the Relevant Invoice (for Credit Memo)
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • REBZZ : Line Item in the Relevant Invoice
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • REBZT : Follow-On Document Type
    Its data type is CHAR (Character String) with field length 1
  • ZOLLT : Customs Tariff Number
    Its data type is CHAR (Character String) with field length 8
  • ZOLLD : Customs Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LZBKZ : State central bank indicator
    Its data type is CHAR (Character String) with field length 3
  • LANDL : Supplying Country
    Its data type is CHAR (Character String) with field length 3
  • DIEKZ : Service indicator (foreign payment)
    Its data type is CHAR (Character String) with field length 1
  • SAMNR : Invoice List Number
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • ABPER : Settlement period
    Its data type is ACCP (Posting period YYYYMM) with field length 6
  • VRSKZ : Insurance Indicator
    Its data type is CHAR (Character String) with field length 1
  • VRSDT : Insurance Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DISBN : Number of Bill of Exchange Usage Document (Discount Doc.)
    Its data type is CHAR (Character String) with field length 10
  • DISBJ : Fiscal Year of Bill of Exchange Usage Document
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • DISBZ : Line Item within the Bill of Exchange Usage Document
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • WVERW : Bill of Exchange Usage Type
    Its data type is CHAR (Character String) with field length 1
  • ANFBN : Document Number of the Bill of Exchange Payment Request
    Its data type is CHAR (Character String) with field length 10
  • ANFBJ : Fiscal Year of the Bill of Exchange Payment Request Document
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • ANFBU : Company Code in Which Bill of Exch.Payment Request Is Posted
    Its data type is CHAR (Character String) with field length 4
  • ANFAE : Bill of Exchange Payment Request Due Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BLNBT : Base Amount for Determining the Preference Amount
    Its data type is CURR (Currency Field) with field length 13
  • BLNKZ : Subsidy Indicator for Determining the Reduction Rates
    Its data type is CHAR (Character String) with field length 2
  • BLNPZ : Preference Percentage Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • MSCHL : Dunning key
    Its data type is CHAR (Character String) with field length 1
  • MANSP : Dunning block
    Its data type is CHAR (Character String) with field length 1
  • MADAT : Date of Last Dunning Notice
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • MANST : Dunning Level
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • MABER : Dunning Area
    Its data type is CHAR (Character String) with field length 2
  • ESRNR : POR subscriber number
    Its data type is CHAR (Character String) with field length 11
  • ESRRE : POR reference number
    Its data type is CHAR (Character String) with field length 27
  • ESRPZ : POR check digit
    Its data type is CHAR (Character String) with field length 2
  • KLIBT : Credit Control Amount
    Its data type is CURR (Currency Field) with field length 13
  • QSZNR : Certificate Number of the Withholding Tax Exemption
    Its data type is CHAR (Character String) with field length 10
  • QBSHB : Withholding Tax Amount (in Document Currency)
    Its data type is CURR (Currency Field) with field length 13
  • QSFBT : Withholding Tax-Exempt Amount (in Document Currency)
    Its data type is CURR (Currency Field) with field length 13
  • NAVHW : Non-Deductible Input Tax (in Local Currency)
    Its data type is CURR (Currency Field) with field length 13
  • NAVFW : Non-Deductible Input Tax (in Document Currency)
    Its data type is CURR (Currency Field) with field length 13
  • 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
  • ERFMG : Quantity in unit of entry
    Its data type is QUAN (Quantity field) with field length 13
  • ERFME : Unit of entry
    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
  • BPRME : Order Price Unit (purchasing)
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • 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
  • ZEKKN : Sequential Number of Account Assignment
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • ELIKZ : “Delivery Completed” Indicator
    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
  • 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
  • BUSTW : Posting string for values
    Its data type is CHAR (Character String) with field length 4
  • 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
  • BONFB : Amount Qualifying for Bonus in Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • BUALT : Amount posted in alternative price control
    Its data type is CURR (Currency Field) with field length 13
  • PSALT : Alternative Price Control
    Its data type is CHAR (Character String) with field length 1
  • NPREI : New Price
    Its data type is CURR (Currency Field) with field length 11
  • TBTKZ : Indicator: Subsequent Debit/Credit
    Its data type is CHAR (Character String) with field length 1
  • SPGRP : Blocking Reason: Price
    Its data type is CHAR (Character String) with field length 1
  • SPGRM : Blocking Reason: Quantity
    Its data type is CHAR (Character String) with field length 1
  • SPGRT : Blocking Reason: Date
    Its data type is CHAR (Character String) with field length 1
  • SPGRG : Blocking Reason: Order Price Quantity
    Its data type is CHAR (Character String) with field length 1
  • SPGRV : Blocking Reason: Project Budget
    Its data type is CHAR (Character String) with field length 1
  • SPGRQ : Manual Blocking Reason
    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
  • EGBLD : Country of Destination for Delivery of Goods
    Its data type is CHAR (Character String) with field length 3
  • EGLLD : Supplying Country for Delivery of Goods
    Its data type is CHAR (Character String) with field length 3
  • RSTGR : Reason Code for Payments
    Its data type is CHAR (Character String) with field length 3
  • RYACQ : Year of acquisition
    Its data type is CHAR (Character String) with field length 4
  • RPACQ : Period of Acquisition
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • RDIFF : Exchange Rate Gain/Loss Realized
    Its data type is CURR (Currency Field) with field length 13
  • RDIF2 : Exchange Rate Difference Realized for Second Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • PRCTR : Profit Center
    Its data type is CHAR (Character String) with field length 10
  • XHKOM : Indicator: G/L Account Assigned Manually?
    Its data type is CHAR (Character String) with field length 1
  • 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
  • DEPOT : Securities Account
    Its data type is CHAR (Character String) with field length 10
  • TXJCD : Tax Jurisdiction
    Its data type is CHAR (Character String) with field length 15
  • IMKEY : Internal Key for Real Estate Object
    Its data type is CHAR (Character String) with field length 8
  • DABRZ : Reference date for settlement
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • POPTS : Real Estate Option Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • FIPOS : Commitment Item
    Its data type is CHAR (Character String) with field length 14
  • 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 : Task List Number for Operations in Order
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • APLZL : General Counter for Order
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • PROJK : 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
  • SPGRS : Blocking Reason: Item Amount
    Its data type is CHAR (Character String) with field length 1
  • SPGRC : Blocking Reason: Quality
    Its data type is CHAR (Character String) with field length 1
  • 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
  • LNRAN : Sequence Number of Asset Line Items in Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • HRKFT : Origin Group as Subdivision of Cost Element
    Its data type is CHAR (Character String) with field length 4
  • 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
  • DMB21 : Amount in Second Local Currency for Tax Breakdown
    Its data type is CURR (Currency Field) with field length 13
  • DMB22 : Amount in Second Local Currency for Tax Breakdown
    Its data type is CURR (Currency Field) with field length 13
  • DMB23 : Amount in Second Local Currency for Tax Breakdown
    Its data type is CURR (Currency Field) with field length 13
  • DMB31 : Amount in Third Local Currency for Tax Breakdown
    Its data type is CURR (Currency Field) with field length 13
  • DMB32 : Amount in Third Local Currency for Tax Breakdown
    Its data type is CURR (Currency Field) with field length 13
  • DMB33 : Amount in Third Local Currency for Tax Breakdown
    Its data type is CURR (Currency Field) with field length 13
  • MWST2 : Tax Amount in Second Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • MWST3 : Tax Amount in Third Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • NAVH2 : Non-Deductible Input Tax in Second Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • NAVH3 : Non-Deductible Input Tax in Third Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • SKNT2 : Cash Discount Amount in Second Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • SKNT3 : Cash Discount Amount in Third Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • BDIF3 : Valuation Difference for the Third Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • RDIF3 : Exchange Rate Difference Realized for Third Local 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
  • GLUPM : Update Method for FM – FI-CA Integration
    Its data type is CHAR (Character String) with field length 1
  • XRAGL : Indicator: Clearing was Reversed
    Its data type is CHAR (Character String) with field length 1
  • UZAWE : Payment method supplement
    Its data type is CHAR (Character String) with field length 2
  • LOKKT : Alternative Account Number in Company Code
    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
  • GEBER : Fund
    Its data type is CHAR (Character String) with field length 10
  • STBUK : Tax Company Code
    Its data type is CHAR (Character String) with field length 4
  • TXBH2 : Tax Base/Original Tax Base in Second Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • TXBH3 : Tax Base/Original Tax Base in Third Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • PPRCT : Partner Profit Center
    Its data type is CHAR (Character String) with field length 10
  • 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
  • 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
  • FKBER : Functional Area
    Its data type is CHAR (Character String) with field length 4
  • OBZEI : Number of Line Item in Original Document
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • XNEGP : Indicator: Negative posting
    Its data type is CHAR (Character String) with field length 1
  • RFZEI : Payment Card Item
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • CCBTC : Payment cards: Settlement run
    Its data type is CHAR (Character String) with field length 10
  • KKBER : Credit control area
    Its data type is CHAR (Character String) with field length 4
  • EMPFB : Payee/Payer
    Its data type is CHAR (Character String) with field length 10
  • XREF3 : Reference key for line item
    Its data type is CHAR (Character String) with field length 20
  • DTWS1 : Instruction key 1
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • DTWS2 : Instruction key 2
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • DTWS3 : Instruction key 3
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • DTWS4 : Instruction key 4
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • 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
  • XPYPR : Indicator: Items from Payment Program Blocked
    Its data type is CHAR (Character String) with field length 1
  • KIDNO : Payment Reference
    Its data type is CHAR (Character String) with field length 30
  • ABSBT : Credit Management: Hedged Amount
    Its data type is CURR (Currency Field) with field length 13
  • IDXSP : Inflation Index
    Its data type is CHAR (Character String) with field length 5
  • LINFV : Last Adjustment 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
  • TXDAT : Date for defining tax rates
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AGZEI : Clearing Item
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • PYCUR : Currency for Automatic Payment
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • PYAMT : Amount in Payment Currency
    Its data type is CURR (Currency Field) with field length 13
  • BUPLA : Business Place
    Its data type is CHAR (Character String) with field length 4
  • SECCO : Section Code
    Its data type is CHAR (Character String) with field length 4
  • LSTAR : Activity Type
    Its data type is CHAR (Character String) with field length 6
  • CESSION_KZ : Accounts Receivable Pledging Indicator
    Its data type is CHAR (Character String) with field length 2
  • PRZNR : Business Process
    Its data type is CHAR (Character String) with field length 12
  • PPDIFF : Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)
    Its data type is CURR (Currency Field) with field length 13
  • PPDIF2 : Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)
    Its data type is CURR (Currency Field) with field length 13
  • PPDIF3 : Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)
    Its data type is CURR (Currency Field) with field length 13
  • PENLC1 : Penalty Charge Amount in First Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • PENLC2 : Penalty Charge Amount in Second Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • PENLC3 : Penalty Charge Amount in Third Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • PENFC : Penalty Charge Amount in Document Currency
    Its data type is CURR (Currency Field) with field length 13
  • PENDAYS : Number of Days for Penalty Charge Calculation
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • PENRC : Reason for Late Payment
    Its data type is CHAR (Character String) with field length 2
  • GRANT_NBR : Grant
    Its data type is CHAR (Character String) with field length 20
  • SCTAX : Tax Portion FI-CA Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • FKBER_LONG : Functional Area
    Its data type is CHAR (Character String) with field length 16
  • GMVKZ : Item is in Execution
    Its data type is CHAR (Character String) with field length 1
  • SRTYPE : Type of Additional Receivable
    Its data type is CHAR (Character String) with field length 2
  • INTRENO : Internal Real Estate Master Data Code
    Its data type is CHAR (Character String) with field length 13
  • MEASURE : Funded Program
    Its data type is CHAR (Character String) with field length 24
  • AUGGJ : Fiscal Year of Clearing Document
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • PPA_EX_IND : PPA Exclude Indicator
    Its data type is CHAR (Character String) with field length 1
  • DOCLN : Six-Character Posting Item for Ledger
    Its data type is CHAR (Character String) with field length 6
  • SEGMENT : Segment for Segmental Reporting
    Its data type is CHAR (Character String) with field length 10
  • PSEGMENT : Partner Segment for Segmental Reporting
    Its data type is CHAR (Character String) with field length 10
  • PFKBER : Partner Functional Area
    Its data type is CHAR (Character String) with field length 16
  • HKTID : ID for account details
    Its data type is CHAR (Character String) with field length 5
  • KSTAR : Cost Element
    Its data type is CHAR (Character String) with field length 10
  • XLGCLR : Clearing Specific to Ledger Groups
    Its data type is CHAR (Character String) with field length 1
  • TAXPS : Tax document item number
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • PAYS_PROV : Payment Service Provider
    Its data type is CHAR (Character String) with field length 4
  • PAYS_TRAN : Payment Reference of Payment Service Provider
    Its data type is CHAR (Character String) with field length 35
  • MNDID : Unique Referene to Mandate per Payment Recipient
    Its data type is CHAR (Character String) with field length 35
  • XFRGE_BSEG : Payment Is Released
    Its data type is CHAR (Character String) with field length 1
  • .INCLU–AP : Funds Management EHP4
  • PGEBER : Partner Fund
    Its data type is CHAR (Character String) with field length 10
  • PGRANT_NBR : Partner Grant
    Its data type is CHAR (Character String) with field length 20
  • .INCLU–AP : FM: Budget Period
  • BUDGET_PD : FM: Budget Period
    Its data type is CHAR (Character String) with field length 10
  • PBUDGET_PD : FM: Partner Budget Period
    Its data type is CHAR (Character String) with field length 10
  • .INCLU–AP : FMFG: US Federal Specific Fields
  • PEROP_BEG : Billing Period of Performance Start Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PEROP_END : Billing Period of Performance End Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FASTPAY : PPA Fast Pay Indicator
    Its data type is CHAR (Character String) with field length 1
  • IGNR_IVREF : FMFG: Ignore the invoice reference during FI doc splitting
    Its data type is CHAR (Character String) with field length 1
  • FMFGUS_KEY : United States Federal Government Fields
    Its data type is CHAR (Character String) with field length 22
  • .INCLU–AP : Funds Management Actual Data Reference Document
  • .INCLUDE : Funds Management Actual Data Reference Document
  • FMXDOCNR : FM Reference Document Number
    Its data type is CHAR (Character String) with field length 10
  • FMXYEAR : FM Reference Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • FMXDOCLN : FM Reference Line Item
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • FMXZEKKN : FM Reference Sequence Account Assignment
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • .INCLU–AP : Joint Venture addtional doucment fields
  • PRODPER : Production Month (Date to find period and year)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

    • /CEERE/BSEG related tables

    • /CEERE/TPNEMM : Property categories – mapping to REM
    • /CEERE/FUKDC : Tax office: master data – time dependent
    • /CEERE/RIZENIFU : Property tax control – tax offices
    • /CEERE/FU_TRAN : Connection between Tax Offices 2012 and Tax Offices 2013
    • /CEERE/OBCE : Municipalities
    • /CEERE/SDAN : Property tax return – sheets
    • /CEERE/TPNEM : Property categories
    • /CEERE/FUR : Regional Tax Office Workplace
    • /CEERE/KONSTANTY : Constants
    • /CEERE/RIZENI : PT settings for company code
    • /CEERE/KU : Cadastral district
    • /CEERE/POMNAK : Relative part of property tax to costs
    • /CEERE/SDANP : Property tax – master
    • /CEERE/SDANPARC : Property tax – plots of land
    • /CEERE/USZAV : Property tax: posting schema – liability to the tax office
    • /CEERE/RIZBUK : PT Settings for Company Codes and Dominant Enterprise Co.Cd.
    • /CEERE/SDANJEDN : Property tax – units
    • /CEERE/KOSVOB_MF : Tax exemption codes from Ministry of Finance web
    • /CEERE/KOEFMP : obsolete Koeficients for municipalities parts
    • /CEERE/OKRES : Counties

    /CEERE/BSEG related transaction codes under SAP package /CEERE/DANNEM

    • /CEERE/MMAPLT : Areas for property tax
    • /CEERE/MNUCOK : Company code settings
    • /CEERE/19000334 : IMG activity: /CEERE/KU
    • /CEERE/DNUCTO_IND : Posting
    • /CEERE/MOBCOVYK : Mun.,cad.districts, distr.,mun.regul
    • /CEERE/19000331 : IMG activity: /CEERE/OKRESY
    • /CEERE/SPRO : Property tax: customizing
    • /CEERE/DNZUDP : Assigning usage type/area type (REM)
    • /CEERE/DN05 : Calculation
    • /CEERE/DNUZ : Year closing
    • /CEERE/DNLOAD : Download of key lists from internet
    • /CEERE/19000330 : IMG activity: /CEERE/FU
    • /CEERE/MKUK : SO: Aver.prices of agricultural land
    • /CEERE/19000326 : IMG activity: /CEERE/MTPZDR
    • /CEERE/MFUKDC : Tax office: master data
    • /CEERE/FU_MREGW : Tax office: master data
    • /CEERE/DANXML : xml output of property tax return
    • /CEERE/DNEM02 : Tax objects
    • /CEERE/19000327 : IMG activity: /CEERE/MMAPL
    • /CEERE/IMGHS : Display IMG structure

    Related References

    Related Tutorials

    /CEERE/SDANA SAP table for – Property tax return – items

    /CEERE/SDANA table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    /CEERE/RIZENIFU SAP table for – Property tax control – tax offices

    /CEERE/RIZENIFU table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    /CEERE/SDANFU SAP table for – Property tax return – section IV

    /CEERE/SDANFU table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    /CEERE/SDAN SAP table for – Property tax return – sheets

    /CEERE/SDAN table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    /CEERE/SDANP SAP table for – Property tax – master

    /CEERE/SDANP table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    /CEERE/USZAV SAP table for – Property tax: posting schema – liability to the tax office

    /CEERE/USZAV table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    /CEERE/PROTFU SAP table for – Calculation logs for property tax for TO

    /CEERE/PROTFU table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    «
    »