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 |
Possible values
|
||||||||
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 |
Possible values
|
||||||||
SPERR | Central posting block | SPERB_X | CHAR | 1 | 0 |
Possible values
|
||||||||
SPERM | Centrally imposed purchasing block | SPERM_X | CHAR | 1 | 0 |
Possible values
|
||||||||
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 |
Possible values
|
||||||||
STKZU | Liable for VAT | STKZU | CHAR | 1 | 0 |
Possible values
|
||||||||
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 |
Possible values
|
||||||||
XZEMP | Indicator: Alternative payee in document allowed ? | XZEMP | CHAR | 1 | 0 |
Possible values
|
||||||||
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 |
Possible values
|
||||||||
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 |
Possible values
|
||||||||
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 |
Possible values
|
||||||||
WERKR | Indicator: plant level relevant | WERKR | CHAR | 1 | 0 |
Possible values
|
||||||||
PLKAL | Factory calendar key | FABKL | TFACD | CHAR | 2 | 0 | ||||||||
DUEFL | Status of Data Transfer into Subsequent Release | DUEFL_BKPF | CHAR | 1 | 0 |
Possible values
|
||||||||
TXJCD | Tax Jurisdiction | TXJCD | TTXJ | CHAR | 15 | 0 | ||||||||
SPERZ | Payment Block | SPERZ | CHAR | 1 | 0 |
Possible values
|
||||||||
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 |
Possible values
|
||||||||
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 |
Possible values
|
||||||||
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 |
Possible values
|
||||||||
TAXBS | Tax Base in Percentage | TAXBS | NUMC | 1 | 0 |
Possible values
|
||||||||
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 |
Possible values
|
||||||||
QSSYSDAT | Validity date of certification | QQSSYSDAT | DATS | 8 | 0 | |||||||||
PODKZB | Vendor indicator relevant for proof of delivery | PODKZB | CHAR | 1 | 0 |
Possible values
|
||||||||
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 |