1. SAP Tutorial
  2. Real Estate Management

TIVBPVENDORCMP SAP table for – Vendor Preassignment (CoCd Data)

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

SAP TIVBPVENDORCMP table

Table TIVBPVENDORCMP technical data

TableTIVBPVENDORCMP
Data storingVendor Preassignment (CoCd 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 TIVBPVENDORCMP 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 TIVBPVENDORCMP 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
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : Vendor Master (Company Code)
  • 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
  • SPERR : Posting block for company code
    Its data type is CHAR (Character String) with field length 1
  • LOEVM : Deletion Flag for Master Record (Company Code Level)
    Its data type is CHAR (Character String) with field length 1
  • ZUAWA : Key for sorting according to assignment numbers
    Its data type is CHAR (Character String) with field length 3
  • AKONT : Reconciliation Account in General Ledger
    Its data type is CHAR (Character String) with field length 10
  • BEGRU : Authorization Group
    Its data type is CHAR (Character String) with field length 4
  • VZSKZ : Interest calculation indicator
    Its data type is CHAR (Character String) with field length 2
  • ZWELS : List of the Payment Methods to be Considered
    Its data type is CHAR (Character String) with field length 10
  • XVERR : Indicator: Clearing between customer and vendor?
    Its data type is CHAR (Character String) with field length 1
  • ZAHLS : Block Key for Payment
    Its data type is CHAR (Character String) with field length 1
  • ZTERM : Terms of payment key
    Its data type is CHAR (Character String) with field length 4
  • EIKTO : Our account number with the vendor
    Its data type is CHAR (Character String) with field length 12
  • ZSABE : Clerk at vendor
    Its data type is CHAR (Character String) with field length 15
  • KVERM : Memo
    Its data type is CHAR (Character String) with field length 30
  • FDGRV : Planning group
    Its data type is CHAR (Character String) with field length 10
  • BUSAB : Accounting clerk
    Its data type is CHAR (Character String) with field length 2
  • LNRZE : Head office account number
    Its data type is CHAR (Character String) with field length 10
  • LNRZB : Account number of the alternative payee
    Its data type is CHAR (Character String) with field length 10
  • ZINDT : Key date of the last interest calculation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ZINRT : Interest calculation frequency in months
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • DATLZ : Date of the last interest calculation run
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • XDEZV : Indicator: Local processing?
    Its data type is CHAR (Character String) with field length 1
  • WEBTR : Bill of exchange limit (in local currency)
    Its data type is CURR (Currency Field) with field length 13
  • KULTG : Probable time until check is paid
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • REPRF : Check Flag for Double Invoices or Credit Memos
    Its data type is CHAR (Character String) with field length 1
  • TOGRU : Tolerance group for the business partner/G/L account
    Its data type is CHAR (Character String) with field length 4
  • HBKID : Short key for a house bank
    Its data type is CHAR (Character String) with field length 5
  • XPORE : Indicator: Pay all items separately ?
    Its data type is CHAR (Character String) with field length 1
  • QSZNR : Certificate Number of the Withholding Tax Exemption
    Its data type is CHAR (Character String) with field length 10
  • QSZDT : Validity Date for Withholding Tax Exemption Certificate
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • QSSKZ : Withholding Tax Code
    Its data type is CHAR (Character String) with field length 2
  • BLNKZ : Subsidy Indicator for Determining the Reduction Rates
    Its data type is CHAR (Character String) with field length 2
  • MINDK : Minority Indicators
    Its data type is CHAR (Character String) with field length 3
  • ALTKN : Previous Master Record Number
    Its data type is CHAR (Character String) with field length 10
  • ZGRUP : Key for Payment Grouping
    Its data type is CHAR (Character String) with field length 2
  • MGRUP : Key for dunning notice grouping
    Its data type is CHAR (Character String) with field length 2
  • UZAWE : Payment method supplement
    Its data type is CHAR (Character String) with field length 2
  • QSREC : Vendor Recipient Type
    Its data type is CHAR (Character String) with field length 2
  • QSBGR : Authority for Exemption from Withholding Tax
    Its data type is CHAR (Character String) with field length 1
  • QLAND : Withholding Tax Country Key
    Its data type is CHAR (Character String) with field length 3
  • XEDIP : Indicator: Send Payment Advices by EDI
    Its data type is CHAR (Character String) with field length 1
  • FRGRP : Release Approval Group
    Its data type is CHAR (Character String) with field length 4
  • TOGRR : Tolerance group; Invoice Verification
    Its data type is CHAR (Character String) with field length 4
  • TLFXS : Accounting clerk’s fax number at the customer/vendor
    Its data type is CHAR (Character String) with field length 31
  • INTAD : Internet address of partner company clerk
    Its data type is CHAR (Character String) with field length 130
  • XLFZB : Indicator: Alternative payee using account number
    Its data type is CHAR (Character String) with field length 1
  • GUZTE : Payment Terms Key for Credit Memos
    Its data type is CHAR (Character String) with field length 4
  • GRICD : Activity Code for Gross Income Tax
    Its data type is CHAR (Character String) with field length 2
  • GRIDT : Distribution Type for Employment Tax
    Its data type is CHAR (Character String) with field length 2
  • XAUSZ : Indicator for periodic account statements
    Its data type is CHAR (Character String) with field length 1
  • CERDT : Certification date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CONFS : Status of Change Authorization (Company Code Level)
    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 : Deletion bock for master record (company code level)
    Its data type is CHAR (Character String) with field length 1
  • TLFNS : Accounting clerk’s telephone number at business partner
    Its data type is CHAR (Character String) with field length 30

    • TIVBPVENDORCMP related tables

    • VIBPOBJREL : Business Partner-Object Relationship
    • TIVBPVENDORGEN : Vendor Preassignment (General Data)
    • TIVBPSUBROLET : Role Type (Text)
    • TIVBPSUBROLE : Role Type
    • TIVBPVENDORCMP : Vendor Preassignment (CoCd Data)
    • TIVBPOBJROLE : Allowed Role per Object Type
    • TIVBPGRPCC : Business Partner Grouping per Company Code

    TIVBPVENDORCMP related transaction codes under SAP package RE_BP_BP

    • REBPZC : Role Types
    • REBPZD : Allowed Role Categories
    • REBPZE : BP grouping
    • REBPZA : Applications

    Related References

    Related Tutorials

    TIVBPVENDORGEN SAP table for – Vendor Preassignment (General Data)

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

    VIXCSCCHTAPE SAP table for – Header Data for External Heating Expenses Settlement

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

    J_1IMOVEND SAP table for – Vendor Master Excise Additional Data

    J_1IMOVEND table in SAP FI (Localization in FI) module. This table is used for storing data of Vendor Master Excise...

    TIVAR08 SAP table for – RE: REsearch – Preassignment For Offer Object/Rental Request

    TIVAR08 table in SAP RE (Rental in RE) module. This table is used for storing data of RE: REsearch -...

    VIRAADVPAYEXT SAP table for – Advance Payment – Legacy Data Transfer

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

    VIXCRAESRREFH SAP table for – Assignment of ISR Ref./Cash Flow Plan (Header Data)

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

    VIORMP SAP table for – Move Plan – Header Data

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

    «
    »