SAP Table REBPC_VENDOR_DEF_VAL

Company-Code-Independent Default Values for Create Vendor

REBPC_VENDOR_DEF_VAL (Company-Code-Independent Default Values for Create Vendor) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link REBPC_VENDOR_DEF_VAL to other SAP tables.

Source: REBPC_VENDOR_DEF_VAL (Company-Code-Independent Default Values for Create Vendor)

REBPC_VENDOR_DEF_VAL table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
APPL Business Partner: Application Category REBPAPPL TPZ12 CHAR 4 0
ANRED Title ANRED CHAR 15 0
BAHNS Train station BAHNS CHAR 25 0
BBBNR International location number (part 1) BBBNR NUMC 7 0
BBSNR International location number (Part 2) BBSNR NUMC 5 0
BEGRU Authorization Group BRGRU CHAR 4 0
BRSCH Industry key BRSCH T016 CHAR 4 0
BUBKZ Check digit for the international location number BUBKZ NUMC 1 0
DATLT Data communication line no. DATLT CHAR 14 0
DTAMS Indicator for Data Medium Exchange DTAMS CHAR 1 0
1 Single data record not to be forwarded to the Bundesbank
0 Single data record can be forwarded to the Bundesbank
NULL Use house bank default value
DTAWS Instruction key for data medium exchange DTAWS CHAR 2 0
ERDAT Date on which the Record Was Created ERDAT_RF DATS 8 0
ERNAM Name of Person who Created the Object ERNAM_RF CHAR 12 0
ESRNR ISR Subscriber Number ESRNR CHAR 11 0
KONZS Group key KONZS CHAR 10 0
KTOKK Vendor account group KTOKK T077K CHAR 4 0
KUNNR Customer Number KUNNR KNA1 CHAR 10 0
LNRZA Account Number of the Alternative Payee LNRZA LFA1 CHAR 10 0
LOEVM Central Deletion Flag for Master Record LOEVM_X CHAR 1 0
X Yes
NULL No
SPERR Central posting block SPERB_X CHAR 1 0
X Yes
NULL No
SPERM Centrally imposed purchasing block SPERM_X CHAR 1 0
X Yes
NULL No
SPRAS Language Key SPRAS T002 LANG 1 0
STCD1 Tax Number 1 STCD1 CHAR 16 0
STCD2 Tax Number 2 STCD2 CHAR 11 0
STKZA Indicator: Business Partner Subject to Equalization Tax? STKZA CHAR 1 0
NULL Not subject to equalization tax
X Subject to equalization tax
STKZU Liable for VAT STKZU CHAR 1 0
X Yes
NULL No
TELBX Telebox number TELBX CHAR 15 0
TELF1 First telephone number TELF1 CHAR 16 0
TELF2 Second telephone number TELF2 CHAR 16 0
TELFX Fax Number TELFX CHAR 31 0
TELTX Teletex number TELTX CHAR 30 0
TELX1 Telex number TELX1 CHAR 30 0
XCPDK Indicator: Is the account a one-time account? XCPDK CHAR 1 0
X Yes
NULL No
XZEMP Indicator: Alternative payee in document allowed ? XZEMP CHAR 1 0
X Yes
NULL No
VBUND Company ID of trading partner RASSC T880 CHAR 6 0
FISKN Account number of the master record with fiscal address FISKN_K LFA1 CHAR 10 0
STCEG VAT Registration Number STCEG CHAR 20 0
STKZN Natural Person STKZN CHAR 1 0
X Natural person
NULL Legal person
SPERQ Function That Will Be Blocked QSPERRFKT TQ04A CHAR 2 0
GBORT Place of birth of the person subject to withholding tax GBORT_Q CHAR 25 0
GBDAT Date of birth of the person subject to withholding tax GBDAT_Q DATS 8 0
SEXKZ Key for the Sex of the Person Subject to Withholding Tax SEXKZ CHAR 1 0
1 Male
2 Female
KRAUS Credit information number KRAUS_CM CHAR 11 0
REVDB Last review (external) REVDB_CM DATS 8 0
QSSYS Vendor's QM system QSSYS_IST TQ02B CHAR 4 0
KTOCK Reference Account Group for One-Time Account (Vendor) KTOCK T077K CHAR 4 0
PFORT PO Box city PFORT_GP CHAR 35 0
WERKS Plant (Own or External) WERKS_EXT CHAR 4 0
LTSNA Indicator: vendor sub-range relevant LTSNA CHAR 1 0
X Yes
NULL No
WERKR Indicator: plant level relevant WERKR CHAR 1 0
X Yes
NULL No
PLKAL Factory calendar key FABKL TFACD CHAR 2 0
DUEFL Status of Data Transfer into Subsequent Release DUEFL_BKPF CHAR 1 0
NULL Not transferred yet
A Transfer taken place, document changed later
X Transfer taken place, document unchanged
TXJCD Tax Jurisdiction TXJCD TTXJ CHAR 15 0
SPERZ Payment Block SPERZ CHAR 1 0
X Yes
NULL No
SCACD Standard carrier access code SCACD CHAR 4 0
SFRGR Forwarding agent freight group SFRGR TSFG CHAR 4 0
LZONE Transportation zone to or from which the goods are delivered LZONE TZONE CHAR 10 0
XLFZA Indicator: Alternative payee using account number XLFZA CHAR 1 0
X Yes
NULL No
DLGRP Service agent procedure group DLGRP TVFCD CHAR 4 0
FITYP Tax type J_1AFITP_D J_1AFITP CHAR 2 0
STCDT Tax Number Type J_1ATOID J_1ATODC CHAR 2 0
REGSS Registered for Social Insurance J_1AREGSS CHAR 1 0
X Yes
NULL No
ACTSS Activity Code for Social Insurance J_1AACTSS J_1AACT CHAR 3 0
STCD3 Tax Number 3 STCD3 CHAR 18 0
STCD4 Tax Number 4 STCD4 CHAR 18 0
IPISP Tax Split J_1BINDEQU CHAR 1 0
X Yes
NULL No
TAXBS Tax Base in Percentage TAXBS NUMC 1 0
1 80%
PROFS Profession PROFS CHAR 30 0
STGDL Shipment: statistics group, transportation service agent STGDL VTSGD CHAR 2 0
EMNFR External manufacturer code name or number EMNFR CHAR 10 0
LFURL Uniform Resource Locator URL CHAR 132 0
J_1KFREPRE Name of Representative REPRES CHAR 10 0
J_1KFTBUS Type of Business GESTYP BUSTYPE CHAR 30 0
J_1KFTIND Type of Industry INDTYP INDUSTYPE CHAR 30 0
CONFS Status of Change Authorization (Central) CONFS_X CHAR 1 0
UPDAT Date on Which the Changes Were Confirmed UPDAT_RF DATS 8 0
UPTIM Time of Last Change Confirmation UPTIM_RF TIMS 6 0
NODEL Central deletion block for master record NODEL_X CHAR 1 0
X Yes
NULL No
QSSYSDAT Validity date of certification QQSSYSDAT DATS 8 0
PODKZB Vendor indicator relevant for proof of delivery PODKZB CHAR 1 0
NULL Do not send proof of delivery
A Always send proof of delivery
B Only send proof of delivery if there are changes
FISKU Account Number of Master Record of Tax Office Responsible FISKU LFA1 CHAR 10 0
STENR Tax Number at Responsible Tax Authority STENR CHAR 18 0

REBPC_VENDOR_DEF_VAL foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
REBPC_VENDOR_DEF_VAL ACTSS SYST MANDT J_1AACT Activity code for social security withholding MANDT
REBPC_VENDOR_DEF_VAL ACTSS REBPC_VENDOR_DEF_VAL ACTSS J_1AACT Activity code for social security withholding J_1AACT
REBPC_VENDOR_DEF_VAL APPL REBPC_VENDOR_DEF_VAL APPL TPZ12 Business partner: Application category APPL
REBPC_VENDOR_DEF_VAL APPL REBPC_VENDOR_DEF_VAL MANDT TPZ12 Business partner: Application category MANDT
REBPC_VENDOR_DEF_VAL BRSCH LFA1 MANDT T016 Industries MANDT
REBPC_VENDOR_DEF_VAL BRSCH REBPC_VENDOR_DEF_VAL BRSCH T016 Industries BRSCH
REBPC_VENDOR_DEF_VAL DLGRP LFA1 MANDT TVFCD Service Agent Procedure Group for Shipment Costs MANDT
REBPC_VENDOR_DEF_VAL DLGRP REBPC_VENDOR_DEF_VAL DLGRP TVFCD Service Agent Procedure Group for Shipment Costs DLGRP
REBPC_VENDOR_DEF_VAL FISKN LFA1 MANDT LFA1 Vendor Master (General Section) MANDT
REBPC_VENDOR_DEF_VAL FISKN REBPC_VENDOR_DEF_VAL FISKN LFA1 Vendor Master (General Section) LIFNR
REBPC_VENDOR_DEF_VAL FISKU REBPC_VENDOR_DEF_VAL FISKU LFA1 Vendor Master (General Section) LIFNR
REBPC_VENDOR_DEF_VAL FISKU SYST MANDT LFA1 Vendor Master (General Section) MANDT
REBPC_VENDOR_DEF_VAL FITYP LFA1 MANDT J_1AFITP Tax Types MANDT
REBPC_VENDOR_DEF_VAL FITYP 'K' J_1AFITP Tax Types KOART
REBPC_VENDOR_DEF_VAL FITYP REBPC_VENDOR_DEF_VAL FITYP J_1AFITP Tax Types J_1AFITP
REBPC_VENDOR_DEF_VAL J_1KFTBUS REBPC_VENDOR_DEF_VAL J_1KFTBUS BUSTYPE Type of Business GESTYP
REBPC_VENDOR_DEF_VAL J_1KFTBUS LFA1 MANDT BUSTYPE Type of Business MANDT
REBPC_VENDOR_DEF_VAL J_1KFTIND REBPC_VENDOR_DEF_VAL J_1KFTIND INDUSTYPE Type of Industry INDTYPE
REBPC_VENDOR_DEF_VAL J_1KFTIND LFA1 MANDT INDUSTYPE Type of Industry MANDT
REBPC_VENDOR_DEF_VAL KTOCK LFA1 MANDT T077K Vendor account groups MANDT
REBPC_VENDOR_DEF_VAL KTOCK REBPC_VENDOR_DEF_VAL KTOCK T077K Vendor account groups KTOKK
REBPC_VENDOR_DEF_VAL KTOKK LFA1 MANDT T077K Vendor account groups MANDT
REBPC_VENDOR_DEF_VAL KTOKK REBPC_VENDOR_DEF_VAL KTOKK T077K Vendor account groups KTOKK
REBPC_VENDOR_DEF_VAL KUNNR LFA1 MANDT KNA1 General Data in Customer Master MANDT
REBPC_VENDOR_DEF_VAL KUNNR REBPC_VENDOR_DEF_VAL KUNNR KNA1 General Data in Customer Master KUNNR
REBPC_VENDOR_DEF_VAL LNRZA REBPC_VENDOR_DEF_VAL LNRZA LFA1 Vendor Master (General Section) LIFNR
REBPC_VENDOR_DEF_VAL LNRZA LFA1 MANDT LFA1 Vendor Master (General Section) MANDT
REBPC_VENDOR_DEF_VAL LZONE * TZONE Customers: Regional zones LAND1
REBPC_VENDOR_DEF_VAL LZONE REBPC_VENDOR_DEF_VAL LZONE TZONE Customers: Regional zones ZONE1
REBPC_VENDOR_DEF_VAL LZONE LFA1 MANDT TZONE Customers: Regional zones MANDT
REBPC_VENDOR_DEF_VAL PLKAL REBPC_VENDOR_DEF_VAL PLKAL TFACD Factory calendar definition IDENT
REBPC_VENDOR_DEF_VAL QSSYS REBPC_VENDOR_DEF_VAL QSSYS TQ02B QM system QSSYSFAM
REBPC_VENDOR_DEF_VAL QSSYS LFA1 MANDT TQ02B QM system MANDT
REBPC_VENDOR_DEF_VAL SFRGR REBPC_VENDOR_DEF_VAL SFRGR TSFG Forwarding agent freight group SFRGR
REBPC_VENDOR_DEF_VAL SFRGR LFA1 MANDT TSFG Forwarding agent freight group MANDT
REBPC_VENDOR_DEF_VAL SPERQ REBPC_VENDOR_DEF_VAL SPERQ TQ04A Functions that can be blocked SPERRFKT
REBPC_VENDOR_DEF_VAL SPERQ LFA1 MANDT TQ04A Functions that can be blocked MANDT
REBPC_VENDOR_DEF_VAL SPRAS REBPC_VENDOR_DEF_VAL SPRAS T002 Language Keys (Component BC-I18) SPRAS
REBPC_VENDOR_DEF_VAL STCDT LFA1 MANDT J_1ATODC Type of identification MANDT
REBPC_VENDOR_DEF_VAL STCDT REBPC_VENDOR_DEF_VAL STCDT J_1ATODC Type of identification J_1ATODC
REBPC_VENDOR_DEF_VAL STGDL REBPC_VENDOR_DEF_VAL STGDL VTSGD Shipment: Statistic Groups, Transportation Service Agent STGDL
REBPC_VENDOR_DEF_VAL STGDL LFA1 MANDT VTSGD Shipment: Statistic Groups, Transportation Service Agent MANDT
REBPC_VENDOR_DEF_VAL TXJCD LFA1 MANDT TTXJ Check Table for Tax Jurisdiction MANDT
REBPC_VENDOR_DEF_VAL TXJCD T005 KALSM TTXJ Check Table for Tax Jurisdiction KALSM
REBPC_VENDOR_DEF_VAL TXJCD REBPC_VENDOR_DEF_VAL TXJCD TTXJ Check Table for Tax Jurisdiction TXJCD
REBPC_VENDOR_DEF_VAL VBUND REBPC_VENDOR_DEF_VAL VBUND T880 Global Company Data (for KONS Ledger) RCOMP
REBPC_VENDOR_DEF_VAL VBUND LFA1 MANDT T880 Global Company Data (for KONS Ledger) MANDT