VIBEITEM SAP table for – Gebuchte Berichtigungen

Here we would like to draw your attention to VIBEITEM table in SAP. As we know it is being mainly used with the SAP RE-IT (Input Tax Treatment in RE) component which is coming under RE module (Real Estate Management). VIBEITEM is a SAP standard transp table used for storing Gebuchte Berichtigungen related data in SAP. It comes under the package REIT.

SAP VIBEITEM table

Table VIBEITEM technical data

TableVIBEITEM
Data storingGebuchte Berichtigungen
ModuleRE
Sub ModuleRE-IT
SAP PackageREIT
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP VIBEITEM 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 VIBEITEM table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • CORITEMGUID : Technischer Schlüssel für Berichtigungsbuchungen
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Gebuchte Berichtigungen – logischer Schlüssel
  • CORBASEGUID : Technischer Schlüssel Berichtigungsbasissatz
    Its data type is RAW (Byte string) with field length 16
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • COROBJ : Berichtigungsobjekt Vorsteuerberichtigung
    Its data type is CHAR (Character String) with field length 10
  • CORJAHR : Jahr des Berichtigungslaufes
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • CORMONAT : Monat, für den der Berichtigungslauf stattfand
    Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : Gebuchte Berichtigungen.
  • MWSKZ : Tax on sales/purchases code
    Its data type is CHAR (Character String) with field length 2
  • COSTAMOUNT : Kosten (netto) der Maßnahmen bzw. AHK
    Its data type is CURR (Currency Field) with field length 13
  • TOTALTAX : Gesamtbetrag der Vorsteuer in Hauswährung
    Its data type is CURR (Currency Field) with field length 13
  • DEDTAXOLD : Ursprünglich abgezogene Vorsteuer
    Its data type is CURR (Currency Field) with field length 13
  • NONDEDTAXOLD : Ursprünglich nicht abzugsfähige Vorsteuer
    Its data type is CURR (Currency Field) with field length 13
  • OPTSATZOLD : Optionssatz nach Vorsteueraufteilung
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • DEDTAXNEW : Gemäß aktueller Nutzungsverhältnissen abzugsfähige Vorsteuer
    Its data type is CURR (Currency Field) with field length 13
  • NONDEDTAXNEW : Gemäß aktuellen Nutzungsverhältnissen nicht abz Vorsteuer
    Its data type is CURR (Currency Field) with field length 13
  • OPTSATZNEW : Für die Vorsteuerberichtigung maßgeblicher Optionssatz
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • OPTSATZJAHR : Hochrechnung Optionssatz
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • CORAMOUNTJAHR : Prognose für den Jahresberichtigungsbetrag
    Its data type is CURR (Currency Field) with field length 13
  • CORAMOUNT : Für den Buchungszeitraum errechneter Berichtigungsbetrag
    Its data type is CURR (Currency Field) with field length 13
  • CORAMOUNT44 : Korr. Berichtigungsbetrag Bagatellgrenzen §44 UStDV
    Its data type is CURR (Currency Field) with field length 13
  • GRUND44 : Ergebnis der Bagatellprüfung
    Its data type is CHAR (Character String) with field length 1
  • POSTAMOUNT : Buchungsbetrag Vorsteuerberichtigung
    Its data type is CURR (Currency Field) with field length 13
  • POSTREASON : Buchungsgrund
    Its data type is CHAR (Character String) with field length 1
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • REFJAHR : Bezugsjahr der Berichtigung
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • HKONT : Sachkonto/Kostenart für Erlös-/Kostenbuchung
    Its data type is CHAR (Character String) with field length 10
  • TAXKONT : Steuerkonto Berichtigungsbuchung
    Its data type is CHAR (Character String) with field length 10
  • OBJNR : Objektnummer des Kontierungsobjektes Berichtigungsbuchung
    Its data type is CHAR (Character String) with field length 22
  • HERKUNFT : Herkunft der Buchung
    Its data type is CHAR (Character String) with field length 1
  • SOLLID : ID des Berichtigungslaufes
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • SOLLIDJAHR : Jahr zur Lauf-Id (nach CPU-Datum)
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • AWKEY : BKPF-AWKEY des Berichtigungsbeleges
    Its data type is CHAR (Character String) with field length 20
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BLDAT : Document Date in Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • STOKZ : Indicator: Document has been reversed
    Its data type is CHAR (Character String) with field length 1
  • STFLG : Reverse document indicator
    Its data type is CHAR (Character String) with field length 1
  • STAWKEY : BKPF-AWKEY des Stornobeleges
    Its data type is CHAR (Character String) with field length 20
  • OPTSATZAV : Durchschnittlicher Optionssatz der Aufteilungen
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9