TIVBPVENDORGEN SAP table for – Vendor Preassignment (General Data)

Here we would like to draw your attention to TIVBPVENDORGEN 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). TIVBPVENDORGEN is a SAP standard transp table used for storing Vendor Preassignment (General Data) related data in SAP. It comes under the package RE_BP_BP.

SAP TIVBPVENDORGEN table

Table TIVBPVENDORGEN technical data

TableTIVBPVENDORGEN
Data storingVendor Preassignment (General Data)
ModuleRE
Sub ModuleRE-FX-BP
SAP PackageRE_BP_BP
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentEA-FIN
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • APPL : Business Partner: Application Category
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : Vendor Master (General Section)
  • ANRED : Title
    Its data type is CHAR (Character String) with field length 15
  • BAHNS : Train station
    Its data type is CHAR (Character String) with field length 25
  • BBBNR : International location number (part 1)
    Its data type is NUMC (Character String with Digits Only) with field length 7
  • BBSNR : International location number (Part 2)
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • BEGRU : Authorization Group
    Its data type is CHAR (Character String) with field length 4
  • BRSCH : Industry key
    Its data type is CHAR (Character String) with field length 4
  • BUBKZ : Check digit for the international location number
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • DATLT : Data communication line no.
    Its data type is CHAR (Character String) with field length 14
  • DTAMS : Report key for data medium exchange
    Its data type is CHAR (Character String) with field length 1
  • DTAWS : Instruction key for data medium exchange
    Its data type is CHAR (Character String) with field length 2
  • ERDAT : Date on which the Record Was Created
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ERNAM : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • ESRNR : POR subscriber number
    Its data type is CHAR (Character String) with field length 11
  • KONZS : Group key
    Its data type is CHAR (Character String) with field length 10
  • KTOKK : Vendor account group
    Its data type is CHAR (Character String) with field length 4
  • KUNNR : Customer Number
    Its data type is CHAR (Character String) with field length 10
  • LNRZA : Account Number of the Alternative Payee
    Its data type is CHAR (Character String) with field length 10
  • LOEVM : Central Deletion Flag for Master Record
    Its data type is CHAR (Character String) with field length 1
  • SPERR : Central posting block
    Its data type is CHAR (Character String) with field length 1
  • SPERM : Centrally imposed purchasing block
    Its data type is CHAR (Character String) with field length 1
  • SPRAS : Language Key
    Its data type is LANG (Language key character with length 1) with field length 1
  • STCD1 : Tax Number 1
    Its data type is CHAR (Character String) with field length 16
  • STCD2 : Tax Number 2
    Its data type is CHAR (Character String) with field length 11
  • STKZA : Indicator: Business Partner Subject to Equalization Tax?
    Its data type is CHAR (Character String) with field length 1
  • STKZU : Liable for VAT
    Its data type is CHAR (Character String) with field length 1
  • TELBX : Telebox number
    Its data type is CHAR (Character String) with field length 15
  • TELF1 : First telephone number
    Its data type is CHAR (Character String) with field length 16
  • TELF2 : Second telephone number
    Its data type is CHAR (Character String) with field length 16
  • TELFX : Fax Number
    Its data type is CHAR (Character String) with field length 31
  • TELTX : Teletex number
    Its data type is CHAR (Character String) with field length 30
  • TELX1 : Telex number
    Its data type is CHAR (Character String) with field length 30
  • XCPDK : Indicator: Is the account a one-time account?
    Its data type is CHAR (Character String) with field length 1
  • XZEMP : Indicator: Alternative payee in document allowed ?
    Its data type is CHAR (Character String) with field length 1
  • VBUND : Company ID of trading partner
    Its data type is CHAR (Character String) with field length 6
  • FISKN : Account number of the master record with fiscal address
    Its data type is CHAR (Character String) with field length 10
  • STCEG : VAT Registration Number
    Its data type is CHAR (Character String) with field length 20
  • STKZN : Natural Person
    Its data type is CHAR (Character String) with field length 1
  • SPERQ : Function That Will Be Blocked
    Its data type is CHAR (Character String) with field length 2
  • GBORT : Place of birth of the person subject to withholding tax
    Its data type is CHAR (Character String) with field length 25
  • GBDAT : Date of birth of the person subject to withholding tax
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SEXKZ : Key for the Sex of the Person Subject to Withholding Tax
    Its data type is CHAR (Character String) with field length 1
  • KRAUS : Credit information number
    Its data type is CHAR (Character String) with field length 11
  • REVDB : Last review (external)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • QSSYS : Vendor’s QM system
    Its data type is CHAR (Character String) with field length 4
  • KTOCK : Reference Account Group for One-Time Account (Vendor)
    Its data type is CHAR (Character String) with field length 4
  • PFORT : PO Box city
    Its data type is CHAR (Character String) with field length 35
  • WERKS : Plant (Own or External)
    Its data type is CHAR (Character String) with field length 4
  • LTSNA : Indicator: vendor sub-range relevant
    Its data type is CHAR (Character String) with field length 1
  • WERKR : Indicator: plant level relevant
    Its data type is CHAR (Character String) with field length 1
  • PLKAL : Factory calendar key
    Its data type is CHAR (Character String) with field length 2
  • DUEFL : Status of Data Transfer into Subsequent Release
    Its data type is CHAR (Character String) with field length 1
  • TXJCD : Tax Jurisdiction
    Its data type is CHAR (Character String) with field length 15
  • SPERZ : Payment Block
    Its data type is CHAR (Character String) with field length 1
  • SCACD : Standard carrier access code
    Its data type is CHAR (Character String) with field length 4
  • SFRGR : Forwarding Agent Freight Group
    Its data type is CHAR (Character String) with field length 4
  • LZONE : Transportation zone to or from which the goods are delivered
    Its data type is CHAR (Character String) with field length 10
  • XLFZA : Indicator: Alternative payee using account number
    Its data type is CHAR (Character String) with field length 1
  • DLGRP : Service agent procedure group
    Its data type is CHAR (Character String) with field length 4
  • FITYP : Tax type
    Its data type is CHAR (Character String) with field length 2
  • STCDT : Tax Number Type
    Its data type is CHAR (Character String) with field length 2
  • REGSS : Registered for Social Insurance
    Its data type is CHAR (Character String) with field length 1
  • ACTSS : Activity Code for Social Insurance
    Its data type is CHAR (Character String) with field length 3
  • STCD3 : Tax Number 3
    Its data type is CHAR (Character String) with field length 18
  • STCD4 : Tax Number 4
    Its data type is CHAR (Character String) with field length 18
  • IPISP : Tax Split
    Its data type is CHAR (Character String) with field length 1
  • TAXBS : Tax Base in Percentage
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • PROFS : Profession
    Its data type is CHAR (Character String) with field length 30
  • STGDL : Shipment: statistics group, transportation service agent
    Its data type is CHAR (Character String) with field length 2
  • EMNFR : External manufacturer code name or number
    Its data type is CHAR (Character String) with field length 10
  • LFURL : Uniform resource locator
    Its data type is CHAR (Character String) with field length 132
  • J_1KFREPRE : Name of Representative
    Its data type is CHAR (Character String) with field length 10
  • J_1KFTBUS : Type of Business
    Its data type is CHAR (Character String) with field length 30
  • J_1KFTIND : Type of Industry
    Its data type is CHAR (Character String) with field length 30
  • CONFS : Status of Change Authorization (Central)
    Its data type is CHAR (Character String) with field length 1
  • UPDAT : Date on Which the Changes Were Confirmed
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UPTIM : Time of Last Change Confirmation
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • NODEL : Central deletion block for master record
    Its data type is CHAR (Character String) with field length 1
  • QSSYSDAT : Validity date of certification
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PODKZB : Vendor indicator relevant for proof of delivery
    Its data type is CHAR (Character String) with field length 1
  • FISKU : Account Number of Master Record of Tax Office Responsible
    Its data type is CHAR (Character String) with field length 10
  • STENR : Tax Number at Responsible Tax Authority
    Its data type is CHAR (Character String) with field length 18