UPARI_TC_BUGDTY SAP table for – Budget Type

Here we would like to draw your attention to UPARI_TC_BUGDTY table in SAP. As we know it is being mainly used with the SAP BW-PLA (Planning in BW) component which is coming under BW module (Business Warehouse). UPARI_TC_BUGDTY is a SAP standard transp table used for storing Budget Type related data in SAP. It comes under the package UPARI.

SAP UPARI_TC_BUGDTY table

Table UPARI_TC_BUGDTY technical data

TableUPARI_TC_BUGDTY
Data storingBudget Type
ModuleBW
Sub ModuleBW-PLA-BPS
SAP PackageUPARI
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_BW
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • APPL : Identifier of applications that use planned budgets
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • TYPE : Budget Type
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • DATE_FROM : Start Date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DATE_TO : Finish date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BUDG_LEVEL : Budget Level
    Its data type is CHAR (Character String) with field length 10
  • KEYFIG_SET : Set of key figures
    Its data type is CHAR (Character String) with field length 10
  • ODSOBJECT : DataStore Object
    Its data type is CHAR (Character String) with field length 30
  • INFOAREA : InfoArea
    Its data type is CHAR (Character String) with field length 30
  • IO_BUDG : InfoObject Budget type
    Its data type is CHAR (Character String) with field length 30
  • DELTA_ON : Delta procedure activ
    Its data type is CHAR (Character String) with field length 1
  • TOLERANCE : Tolerance value in percent
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • STATUS_BW : Status budget type
    Its data type is CHAR (Character String) with field length 1
  • PRODUCTIVE : Budget type is used productive
    Its data type is CHAR (Character String) with field length 1
  • CURRENCY : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • RFCDEST_PROD : Destination productive BW system
    Its data type is CHAR (Character String) with field length 32
  • RFCDEST_ACT : RFC Destination Reporting BW
    Its data type is CHAR (Character String) with field length 32
  • .INCLUDE : time stamp
  • TS_DATE_TIME_BW : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • TS_PROG_BW : ABAP Program Name
    Its data type is CHAR (Character String) with field length 40
  • TS_USER_BW : User Name in User Master Record
    Its data type is CHAR (Character String) with field length 12
  • CHECK_TYPE : Type of OTB check
    Its data type is CHAR (Character String) with field length 1
  • OTB_ALLOC : OTB allocation to order periods active
    Its data type is CHAR (Character String) with field length 1
  • ORDER_PERIOD : InfoObject or field name used for selection criteria
    Its data type is CHAR (Character String) with field length 30
  • DEAC_OP_DOC : Deactivation budget buckets
    Its data type is CHAR (Character String) with field length 1