VF_KRED SAP (Generated Table for View) Table View details
Dictionary Type: Table View
Description: Generated Table for View
Description: Generated Table for View
Table View field list including key, data, relationships and ABAP select examples
VF_KRED is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.
The VF_KRED table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include LIFNR (Account Number of Vendor or Creditor), BUKRS (Company Code), ANRED (Title), BBBNR (International location number (part 1)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP VF_KRED table view fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
ANRED | Title | ANRED | CHAR | 15 | TEXT15 | ||||
BBBNR | International location number (part 1) | BBBNR | NUMC | 7 | NUM07 | ||||
BBSNR | International location number (Part 2) | BBSNR | NUMC | 5 | NUM05 | ||||
BEGRU | Authorization Group | BRGRU | CHAR | 4 | BRGRU | ||||
BRSCH | Industry key | BRSCH | CHAR | 4 | T016 | BRSCH | |||
BUBKZ | Check digit for the international location number | BUBKZ | NUMC | 1 | NUM01 | ||||
DATLT | Data communication line no. | DATLT | CHAR | 14 | TEXT14 | ||||
DTAMS | Indicator for Data Medium Exchange | DTAMS | CHAR | 1 | DTAMS | ||||
DTAWS | Instruction key for data medium exchange | DTAWS | CHAR | 2 | DTAWS | ||||
ERDAT | Date on which the Record Was Created | ERDAT_RF | DATS | 8 | DATUM | ||||
ERNAM | Name of Person who Created the Object | ERNAM_RF | CHAR | 12 | USNAM | ||||
ESRNR | ISR Subscriber Number | ESRNR | CHAR | 11 | ESRNR | ||||
KONZS | Group key | KONZS | CHAR | 10 | KONZS | ||||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | C_KUNNR |
LAND1 | Country Key | LAND1_GP | CHAR | 3 | T005 | LAND1 | C_LAND1 | ||
LNRZA | Account Number of the Alternative Payee | LNRZA | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
LOEVM | Central Deletion Flag for Master Record | LOEVM_X | CHAR | 1 | XFELD | ||||
NAME1 | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
NAME2 | Name 2 | NAME2_GP | CHAR | 35 | NAME | ||||
NAME3 | Name 3 | NAME3_GP | CHAR | 35 | NAME | ||||
NAME4 | Name 4 | NAME4_GP | CHAR | 35 | NAME | ||||
ORT01 | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
ORT02 | District | ORT02_GP | CHAR | 35 | TEXT35 | ||||
PFACH | PO Box | PFACH | CHAR | 10 | PFACH | ||||
PSTL2 | P.O. Box Postal Code | PSTL2 | CHAR | 10 | PSTLZ | ||||
PSTLZ | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | T005S | REGIO | |||
SORTL | Sort field | SORTL | CHAR | 10 | CHAR10 | ||||
SPERR | Central posting block | SPERB_X | CHAR | 1 | XFELD | ||||
SPERM | Centrally imposed purchasing block | SPERM_X | CHAR | 1 | XFELD | ||||
SPRAS | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
STCD1 | Tax Number 1 | STCD1 | CHAR | 16 | STCD1 | ||||
STCD2 | Tax Number 2 | STCD2 | CHAR | 11 | STCD2 | ||||
STKZA | Indicator: Business Partner Subject to Equalization Tax? | STKZA | CHAR | 1 | STKZA | ||||
STKZU | Liable for VAT | STKZU | CHAR | 1 | XFELD | ||||
STRAS | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
XCPDK | Indicator: Is the account a one-time account? | XCPDK | CHAR | 1 | XFELD | ||||
XZEMP | Indicator: Alternative payee in document allowed ? | XZEMP | CHAR | 1 | XFELD | ||||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | T880 | ALPHA | RCOMP | PGS | |
FISKN | Account number of the master record with fiscal address | FISKN_K | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
FISKU | Account Number of Master Record of Tax Office Responsible | FISKU | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
STENR | Tax Number at Responsible Tax Authority | STENR | CHAR | 18 | CHAR18 | ||||
SPERR_B | Posting block for company code | SPERB_B | CHAR | 1 | XFELD | ||||
LOEVM_B | Deletion Flag for Master Record (Company Code Level) | LOEVM_B | CHAR | 1 | XFELD | ||||
ZUAWA | Key for sorting according to assignment numbers | DZUAWA | CHAR | 3 | TZUN | ZUAWA | |||
AKONT | Reconciliation Account in General Ledger | AKONT | CHAR | 10 | SKB1 | ALPHA | SAKNR | ||
BEGRU_B | Authorization Group | BRGRU | CHAR | 4 | BRGRU | ||||
VZSKZ | Interest calculation indicator | VZSKZ | CHAR | 2 | T056 | VZSKZ | |||
ZWELS | List of the Payment Methods to be Considered | DZWELS | CHAR | 10 | ZWELS | ||||
XVERR | Indicator: Clearing between customer and vendor? | XVERR_LFB1 | CHAR | 1 | XFELD | ||||
ZAHLS | Block Key for Payment | DZAHLS | CHAR | 1 | T008 | ZAHLS | |||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
EIKTO | Our account number with the vendor | EIKTO_K | CHAR | 12 | CHAR12 | ||||
ZSABE | Clerk at vendor | DZSABE_K | CHAR | 15 | TEXT15 | ||||
KVERM | Memo | KVERM | CHAR | 30 | TEXT30 | ||||
FDGRV | Planning group | FDGRV | CHAR | 10 | T035 | ALPHA | FDGRP | ||
BUSAB | Accounting clerk | BUSAB | CHAR | 2 | T001S | BUSAB | |||
LNRZE | Head office account number | LNRZE | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
LNRZB | Account number of the alternative payee | LNRZB | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
ZINDT | Key date of the last interest calculation | DZINDT | DATS | 8 | DATUM | ||||
ZINRT | Interest calculation frequency in months | DZINRT | NUMC | 2 | ZINRT | ||||
DATLZ | Date of the last interest calculation run | DATLZ | DATS | 8 | DATUM | ||||
XDEZV | Indicator: Local processing? | XDEZV | CHAR | 1 | XFELD | ||||
WEBTR | Bill of exchange limit (in local currency) | WEBTR | CURR | 13(2) | WERT7 | ||||
KULTG | Probable time until check is paid | KULTG | DEC | 3 | PACK2 | ||||
REPRF | Check Flag for Double Invoices or Credit Memos | REPRF | CHAR | 1 | XFELD | ||||
TOGRU | Tolerance group for the business partner/G/L account | TOGRU | CHAR | 4 | T043G | TOGRU | |||
HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | T012 | HBKID | |||
XPORE | Indicator: Pay all items separately ? | XPORE | CHAR | 1 | XFELD | ||||
QSZNR | Certificate Number of the Withholding Tax Exemption | QSZNR | CHAR | 10 | CHAR10 | ||||
QSZDT | Validity Date for Withholding Tax Exemption Certificate | QSZDT | DATS | 8 | DATUM | ||||
QSSKZ | Withholding Tax Code | QSSKZ | CHAR | 2 | QSSKZ | ||||
BLNKZ | Subsidy indicator for determining the reduction rates | BLNKZ | CHAR | 2 | BLNKZ | ||||
KTOKK | Vendor account group | KTOKK | CHAR | 4 | T077K | KTOKK | KGK | ||
TELBX | Telebox number | TELBX | CHAR | 15 | TEXT15 | ||||
TELF1 | First telephone number | TELF1 | CHAR | 16 | TEXT16 | ||||
TELF2 | Second telephone number | TELF2 | CHAR | 16 | TEXT16 | ||||
TELFX | Fax Number | TELFX | CHAR | 31 | TEXT31 | ||||
TELTX | Teletex number | TELTX | CHAR | 30 | TEXT30 | ||||
TELX1 | Telex number | TELX1 | CHAR | 30 | TEXT30 | ||||
ERDAT_B | Date on which the Record Was Created | ERDAT_RF | DATS | 8 | DATUM | ||||
ERNAM_B | Name of Person who Created the Object | ERNAM_RF | CHAR | 12 | USNAM | ||||
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
STKZN | Natural Person | STKZN | CHAR | 1 | STKZN | ||||
MINDK | Minority Indicators | MINDK | CHAR | 3 | T059M | MINDK | |||
ALTKN | Previous Master Record Number | ALTKN | CHAR | 10 | CHAR10 | ||||
ZGRUP | Key for Payment Grouping | DZGRUP | CHAR | 2 | TZGR | ZGRUP | |||
MGRUP | Key for dunning notice grouping | MGRUP | CHAR | 2 | T047R | MGRUP | |||
ADRNR | Address | ADRNR | CHAR | 10 | ALPHA | ADRNR | |||
UZAWE | Payment Method Supplement | UZAWE | CHAR | 2 | T042F | UZAWE | |||
QLAND | Withholding Tax Country Key | QLAND | CHAR | 3 | T005Q | QLAND | |||
KRAUS | Credit information number | KRAUS_CM | CHAR | 11 | CHAR11 | ||||
REVDB | Last review (external) | REVDB_CM | DATS | 8 | DATUM | ||||
QSSYS | Vendor's QM system | QSSYS_IST | CHAR | 4 | TQ02B | QSSYSFAM | |||
GBORT | Place of birth of the person subject to withholding tax | GBORT_Q | CHAR | 25 | TEXT25 | ||||
GBDAT | Date of birth of the person subject to withholding tax | GBDAT_Q | DATS | 8 | DATUM | ||||
SEXKZ | Key for the Sex of the Person Subject to Withholding Tax | SEXKZ | CHAR | 1 | SEXKZ | ||||
KTOCK | Reference Account Group for One-Time Account (Vendor) | KTOCK | CHAR | 4 | T077K | KTOKK | |||
PFORT | PO Box city | PFORT_GP | CHAR | 35 | TEXT35 | ||||
XEDIP | Indicator: Send Payment Advices by EDI | XEDIP | CHAR | 1 | XFELD | ||||
SPERZ | Payment Block | SPERZ | CHAR | 1 | XFELD | ||||
PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
QSREC | Vendor Recipient Type | QSREC | CHAR | 2 | T059A | QSREC | |||
QSBGR | Authority for Exemption from Withholding Tax | QSBGR | CHAR | 1 | QSBGR | ||||
FRGRP | Release Approval Group | FRGRP | CHAR | 4 | VBWF08 | FRGRP | |||
TLFXS | Accounting clerk's fax number at the customer/vendor | TLFXS | CHAR | 31 | TEXT31 | ||||
INTAD | Internet address of partner company clerk | INTAD | CHAR | 130 | TXT130 | ||||
XLFZA | Indicator: Alternative payee using account number | XLFZA | CHAR | 1 | XFELD | ||||
XLFZB | Indicator: Alternative payee using account number | XLFZB | CHAR | 1 | XFELD | ||||
GUZTE | Payment Terms Key for Credit Memos | GUZTE | CHAR | 4 | ZTERM | ||||
TOGRR | Tolerance group; Invoice Verification | TOGRR | CHAR | 4 | T169L | TOGRR | |||
XAUSZ | Indicator for periodic account statements | XAUSZ | CHAR | 1 | T048K | AUSZG | |||
GRICD | Activity Code for Gross Income Tax | J_1AGICD_D | CHAR | 2 | J_1AGICD | J_1AGICD2 | |||
GRIDT | Distribution Type for Employment Tax | J_1ADTYP_D | CHAR | 2 | J_1ADTYP | J_1ADTYP | |||
NODEL | Central deletion block for master record | NODEL_X | CHAR | 1 | XFELD | ||||
CONFS | Status of Change Authorization (Central) | CONFS_X | CHAR | 1 | CHAR1 | ||||
UPDAT | Date on Which the Changes Were Confirmed | UPDAT_RF | DATS | 8 | DATUM | ||||
UPTIM | Time of Last Change Confirmation | UPTIM_RF | TIMS | 6 | AS4TIME | ||||
NODEL_B | Deletion bock for master record (company code level) | NODEL_B | CHAR | 1 | XFELD | ||||
CONFS_B | Status of Change Authorization (Company Code Level) | CONFS_B | CHAR | 1 | CHAR1 | ||||
UPDAT_B | Date on Which the Changes Were Confirmed | UPDAT_RF | DATS | 8 | DATUM | ||||
UPTIM_B | Time of Last Change Confirmation | UPTIM_RF | TIMS | 6 | AS4TIME | ||||
SCACD | Standard carrier access code | SCACD | CHAR | 4 | SCACD | ||||
J_1KFREPRE | Name of Representative | REPRES | CHAR | 10 | REPRES | ||||
J_1KFTBUS | Type of Business | GESTYP | CHAR | 30 | BUSTYPE | GESTYP | |||
J_1KFTIND | Type of Industry | INDTYP | CHAR | 30 | INDUSTYPE | INDTYP | |||
TLFNS | Accounting clerk's telephone number at business partner | TLFNS | CHAR | 30 | CHAR30 | ||||
SFRGR | Forwarding agent freight group | SFRGR | CHAR | 4 | TSFG | SFRGR |
Key field | Non-key field |
How do I retrieve data from SAP table VF_KRED using ABAP code
The following ABAP code Example will allow you to do a basic selection on VF_KRED to SELECT all data from the tableDATA: WA_VF_KRED TYPE VF_KRED.
SELECT SINGLE *
FROM VF_KRED
INTO CORRESPONDING FIELDS OF WA_VF_KRED
WHERE...
How to access SAP table VF_KRED
Within an ECC or HANA version of SAP you can also view further information about VF_KRED and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects