VIITTAXDSBASE SAP table for – Tax Document Item to Be Broken Down (VIITTAXDSBASE)

Here we would like to draw your attention to VIITTAXDSBASE 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). VIITTAXDSBASE is a SAP standard transp table used for storing Tax Document Item to Be Broken Down (VIITTAXDSBASE) related data in SAP. It comes under the package RE_IT_DS.

SAP VIITTAXDSBASE table

Table VIITTAXDSBASE technical data

TableVIITTAXDSBASE
Data storingTax Document Item to Be Broken Down (VIITTAXDSBASE)
ModuleRE
Sub ModuleRE-FX-IT
SAP PackageRE_IT_DS
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Key for Tax Shares per Account Assignment (VIITTAXDSBASE)
    Its a key field.
  • DOCGUID : GUID: Unique Internal Key for Tax Document
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • ITEMNO : Internal Item Number for Tax Document Item
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • .INCLUDE : Table Flds for Tax Shares per Acct Assignmt (VIITTAXDSBASE)
  • REFDOCTYPE : Reference to Document Class
    Its data type is CHAR (Character String) with field length 5
  • REFDOCID : Reference Key of Document
    Its data type is CHAR (Character String) with field length 20
  • REFITEMNO : Accounting Document Line Item Number
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • ACCSYSTEM : Definition of Accounting System
    Its data type is CHAR (Character String) with field length 4
  • LOGSYSTEM : Logical System
    Its data type is CHAR (Character String) with field length 10
  • REVDOCID : Reference Key of Reversal Document
    Its data type is CHAR (Character String) with field length 20
  • STATUS : Tax Breakdown Status
    Its data type is CHAR (Character String) with field length 1
  • FISCALYEAR : Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • PSTNGPERIOD : Posting Period
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • PSTNGDATE : Posting Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • OBJNR : ID of Object for which Option Rate Was Determined
    Its data type is CHAR (Character String) with field length 22
  • REFDATE : Reference date for settlement
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DCINDICATOR : Debit/Credit Indicator
    Its data type is CHAR (Character String) with field length 1
  • COSTACCOUNT : Cost Account in G/L Accounting
    Its data type is CHAR (Character String) with field length 15
  • TAXTYPE : Tax Type
    Its data type is CHAR (Character String) with field length 4
  • TAXGROUP : Tax Group
    Its data type is CHAR (Character String) with field length 20
  • TAXACCOUNT : Tax Account of General Ledger Accounting
    Its data type is CHAR (Character String) with field length 15
  • OBJNROPTRATE : ID of Object from Which the Option Rate Was Read
    Its data type is CHAR (Character String) with field length 22
  • .INCLUDE : Share of Costs
  • NETAMOUNT : Net Amount in Transaction Currency
    Its data type is CURR (Currency Field) with field length 15
  • TAXAMOUNT : Tax Amount in Transaction Currency
    Its data type is CURR (Currency Field) with field length 15
  • DEDTAXAMT : Deductible Tax Amount
    Its data type is CURR (Currency Field) with field length 15
  • NONDEDTAXAMT : Non-Deductible Tax Amount
    Its data type is CURR (Currency Field) with field length 15
  • CURRENCY : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLUDE : Fields for Input Tax Correction
  • .INCLUDE : Attributes for Input Tax Correction
  • TCOBJNR : Object Number
    Its data type is CHAR (Character String) with field length 22
  • DATEOFSERVICE : Date of Service
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • HASDIFFOPTRATE : Has Differing Option Rate
    Its data type is CHAR (Character String) with field length 1
  • DIFFOPTRATE : Differing Option Rate for Distribution
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • NOTAXCORR : Do Not Consider Item in Input Tax Correction
    Its data type is CHAR (Character String) with field length 1
  • AMTRANSTYPE : Transaction Type of Asset Postings
    Its data type is CHAR (Character String) with field length 3
  • POREFDOCID : Reference Document Number of Purchase Order
    Its data type is CHAR (Character String) with field length 20
  • POREFITEMNO : Number of Purchase Order Item
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • TCBASEGUID : GUID for Basis for Input Tax Correction
    Its data type is RAW (Byte string) with field length 16
  • EXTTAXCODE : Tax Code of the Accounting System
    Its data type is CHAR (Character String) with field length 5