SAP TABLES | Real Estate Management | Flexible Real Estate Management | Business Partner(RE-FX-BP) SAP RE

TIVBPVENDORGEN SAP Vendor Preassignment (General Data) Table








TIVBPVENDORGEN is a standard SAP Table which is used to store Vendor Preassignment (General Data) information. This is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about Table TIVBPVENDORGEN and the data within it using relevant SAP transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: C - Customizing table, Maintenance only by customer and not updated by SAP import

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories


Dictionary fields for SAP Table TIVBPVENDORGEN




FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3
*
Client
APPLREBPAPPLCHAR4 TPZ12Business Partner: Application Category
.INCLUDEREBPVENDORCA Vendor Master (General Section)
ANREDANREDCHAR15 Title
BAHNSBAHNSCHAR25 Train station
BBBNRBBBNRNUMC7 International location number (part 1)
BBSNRBBSNRNUMC5 International location number (Part 2)
BEGRUBRGRUCHAR4
*
Authorization Group
BRSCHBRSCHCHAR4 T016Industry key
BUBKZBUBKZNUMC1 Check digit for the international location number
DATLTDATLTCHAR14 Data communication line no.
DTAMSDTAMSCHAR1 Indicator for Data Medium Exchange
DTAWSDTAWSCHAR2
*
Instruction key for data medium exchange
ERDATERDAT_RFDATS8 Date on which the Record Was Created
ERNAMERNAM_RFCHAR12 Name of Person who Created the Object
ESRNRESRNRCHAR11 ISR Subscriber Number
KONZSKONZSCHAR10 Group key
KTOKKKTOKKCHAR4 T077KVendor account group
KUNNRKUNNRCHAR10 KNA1Customer NumberALPHA
LNRZALNRZACHAR10 LFA1Account Number of the Alternative PayeeALPHA
LOEVMLOEVM_XCHAR1 Central Deletion Flag for Master Record
SPERRSPERB_XCHAR1 Central posting block
SPERMSPERM_XCHAR1 Centrally imposed purchasing block
SPRASSPRASLANG1 T002Language KeyISOLA
STCD1STCD1CHAR16 Tax Number 1
STCD2STCD2CHAR11 Tax Number 2
STKZASTKZACHAR1 Indicator: Business Partner Subject to Equalization Tax?
STKZUSTKZUCHAR1 Liable for VAT
TELBXTELBXCHAR15 Telebox number
TELF1TELF1CHAR16 First telephone number
TELF2TELF2CHAR16 Second telephone number
TELFXTELFXCHAR31 Fax Number
TELTXTELTXCHAR30 Teletex number
TELX1TELX1CHAR30 Telex number
XCPDKXCPDKCHAR1 Indicator: Is the account a one-time account?
XZEMPXZEMPCHAR1 Indicator: Alternative payee in document allowed ?
VBUNDRASSCCHAR6 T880Company ID of trading partnerALPHA
FISKNFISKN_KCHAR10 LFA1Account number of the master record with fiscal addressALPHA
STCEGSTCEGCHAR20 VAT Registration Number
STKZNSTKZNCHAR1 Natural Person

SPERQQSPERRFKTCHAR2 TQ04AFunction That Will Be Blocked
GBORTGBORT_QCHAR25 Place of birth of the person subject to withholding tax
GBDATGBDAT_QDATS8 Date of birth of the person subject to withholding tax
SEXKZSEXKZCHAR1 Key for the Sex of the Person Subject to Withholding Tax
KRAUSKRAUS_CMCHAR11 Credit information number
REVDBREVDB_CMDATS8 Last review (external)
QSSYSQSSYS_ISTCHAR4 TQ02BVendor's QM system
KTOCKKTOCKCHAR4 T077KReference Account Group for One-Time Account (Vendor)
PFORTPFORT_GPCHAR35 PO Box city
WERKSWERKS_EXTCHAR4
*
Plant (Own or External)
LTSNALTSNACHAR1 Indicator: vendor sub-range relevant
WERKRWERKRCHAR1 Indicator: plant level relevant
PLKALFABKLCHAR2 TFACDFactory calendar key
DUEFLDUEFL_BKPFCHAR1 Status of Data Transfer into Subsequent Release
TXJCDTXJCDCHAR15 TTXJTax Jurisdiction
SPERZSPERZCHAR1 Payment Block
SCACDSCACDCHAR4 Standard carrier access code
SFRGRSFRGRCHAR4 TSFGForwarding agent freight group
LZONELZONECHAR10 TZONETransportation zone to or from which the goods are delivered
XLFZAXLFZACHAR1 Indicator: Alternative payee using account number
DLGRPDLGRPCHAR4 TVFCDService agent procedure group
FITYPJ_1AFITP_DCHAR2 J_1AFITPTax type
STCDTJ_1ATOIDCHAR2 J_1ATODCTax Number Type
REGSSJ_1AREGSSCHAR1 Registered for Social Insurance
ACTSSJ_1AACTSSCHAR3 J_1AACTActivity Code for Social Insurance
STCD3STCD3CHAR18 Tax Number 3
STCD4STCD4CHAR18 Tax Number 4
IPISPJ_1BINDEQUCHAR1 Tax Split
TAXBSTAXBSNUMC1 Tax Base in Percentage
PROFSPROFSCHAR30 Profession
STGDLSTGDLCHAR2 VTSGDShipment: statistics group, transportation service agent
EMNFREMNFRCHAR10 External manufacturer code name or number
LFURLURLCHAR132 Uniform Resource Locator
J_1KFREPREREPRESCHAR10 Name of Representative
J_1KFTBUSGESTYPCHAR30 BUSTYPEType of Business
J_1KFTINDINDTYPCHAR30 INDUSTYPEType of Industry
CONFSCONFS_XCHAR1 Status of Change Authorization (Central)
UPDATUPDAT_RFDATS8 Date on Which the Changes Were Confirmed
UPTIMUPTIM_RFTIMS6 Time of Last Change Confirmation
NODELNODEL_XCHAR1 Central deletion block for master record

QSSYSDATQQSSYSDATDATS8 Validity date of certification
PODKZBPODKZBCHAR1 Vendor indicator relevant for proof of delivery
FISKUFISKUCHAR10 LFA1Account Number of Master Record of Tax Office ResponsibleALPHA
STENRSTENRCHAR18 Tax Number at Responsible Tax Authority


Key field
Non-key field