SAP ABAP View VF_KRED (Database View for LFA1 and LFB1)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM (Application Component) Customer Relationship Management
⤷
CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷
FBAS (Package) Financial accounting 'Basis'

⤷

⤷

⤷

Basic Data
View Type | D | Database View |
Database View | VF_KRED | |
Short Description | Database View for LFA1 and LFB1 | |
Root table | LFA1 | Vendor Master (General Section) |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | ![]() |
LFA1 | ||
2 | ![]() |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
MANDT | JL | EQ | 0 | 0 | ||||
2 | ![]() |
MANDT | JR | EQ | AND | 0 | 0 | |||
3 | ![]() |
LIFNR | JL | EQ | 0 | 0 | ||||
4 | ![]() |
LIFNR | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | ![]() |
![]() |
MANDT | MANDT | Client | |||
2 | ![]() |
![]() |
LIFNR | LIFNR | Account Number of Vendor or Creditor | |||
3 | ![]() |
![]() |
BUKRS | BUKRS | Company Code | |||
4 | ![]() |
![]() |
ANRED | ANRED | Title | |||
5 | ![]() |
![]() |
BBBNR | BBBNR | International location number (part 1) | |||
6 | ![]() |
![]() |
BBSNR | BBSNR | International location number (Part 2) | |||
7 | ![]() |
![]() |
BEGRU | BRGRU | Authorization Group | |||
8 | ![]() |
![]() |
BRSCH | BRSCH | Industry key | |||
9 | ![]() |
![]() |
BUBKZ | BUBKZ | Check digit for the international location number | |||
10 | ![]() |
![]() |
DATLT | DATLT | Data communication line no. | |||
11 | ![]() |
![]() |
DTAMS | DTAMS | Report key for data medium exchange | |||
12 | ![]() |
![]() |
DTAWS | DTAWS | Instruction key for data medium exchange | |||
13 | ![]() |
![]() |
ERDAT | ERDAT_RF | Date on which the Record Was Created | |||
14 | ![]() |
![]() |
ERNAM | ERNAM_RF | Name of Person who Created the Object | |||
15 | ![]() |
![]() |
ESRNR | ESRNR | POR subscriber number | |||
16 | ![]() |
![]() |
KONZS | KONZS | Group key | |||
17 | ![]() |
![]() |
KUNNR | KUNNR | Customer Number | |||
18 | ![]() |
![]() |
LAND1 | LAND1_GP | Country Key | |||
19 | ![]() |
![]() |
LNRZA | LNRZA | Account Number of the Alternative Payee | |||
20 | ![]() |
![]() |
LOEVM | LOEVM_X | Central Deletion Flag for Master Record | |||
21 | ![]() |
![]() |
NAME1 | NAME1_GP | Name 1 | |||
22 | ![]() |
![]() |
NAME2 | NAME2_GP | Name 2 | |||
23 | ![]() |
![]() |
NAME3 | NAME3_GP | Name 3 | |||
24 | ![]() |
![]() |
NAME4 | NAME4_GP | Name 4 | |||
25 | ![]() |
![]() |
ORT01 | ORT01_GP | City | |||
26 | ![]() |
![]() |
ORT02 | ORT02_GP | District | |||
27 | ![]() |
![]() |
PFACH | PFACH | PO Box | |||
28 | ![]() |
![]() |
PSTL2 | PSTL2 | P.O. Box Postal Code | |||
29 | ![]() |
![]() |
PSTLZ | PSTLZ | Postal Code | |||
30 | ![]() |
![]() |
REGIO | REGIO | Region (State, Province, County) | |||
31 | ![]() |
![]() |
SORTL | SORTL | Sort field | |||
32 | ![]() |
![]() |
SPERR | SPERB_X | Central posting block | |||
33 | ![]() |
![]() |
SPERM | SPERM_X | Centrally imposed purchasing block | |||
34 | ![]() |
![]() |
SPRAS | SPRAS | Language Key | |||
35 | ![]() |
![]() |
STCD1 | STCD1 | Tax Number 1 | |||
36 | ![]() |
![]() |
STCD2 | STCD2 | Tax Number 2 | |||
37 | ![]() |
![]() |
STKZA | STKZA | Indicator: Business Partner Subject to Equalization Tax? | |||
38 | ![]() |
![]() |
STKZU | STKZU | Liable for VAT | |||
39 | ![]() |
![]() |
STRAS | STRAS_GP | House number and street | |||
40 | ![]() |
![]() |
XCPDK | XCPDK | Indicator: Is the account a one-time account? | |||
41 | ![]() |
![]() |
XZEMP | XZEMP | Indicator: Alternative payee in document allowed ? | |||
42 | ![]() |
![]() |
VBUND | RASSC | Company ID of trading partner | |||
43 | ![]() |
![]() |
FISKN | FISKN_K | Account number of the master record with fiscal address | |||
44 | ![]() |
![]() |
FISKU | FISKU | Account Number of Master Record of Tax Office Responsible | |||
45 | ![]() |
![]() |
STENR | STENR | Tax Number at Responsible Tax Authority | |||
46 | ![]() |
![]() |
SPERR | SPERB_B | Posting block for company code | |||
47 | ![]() |
![]() |
LOEVM | LOEVM_B | Deletion Flag for Master Record (Company Code Level) | |||
48 | ![]() |
![]() |
ZUAWA | DZUAWA | Key for sorting according to assignment numbers | |||
49 | ![]() |
![]() |
AKONT | AKONT | Reconciliation Account in General Ledger | |||
50 | ![]() |
![]() |
BEGRU | BRGRU | Authorization Group | |||
51 | ![]() |
![]() |
VZSKZ | VZSKZ | Interest calculation indicator | |||
52 | ![]() |
![]() |
ZWELS | DZWELS | List of the Payment Methods to be Considered | |||
53 | ![]() |
![]() |
XVERR | XVERR_LFB1 | Indicator: Clearing between customer and vendor? | |||
54 | ![]() |
![]() |
ZAHLS | DZAHLS | Block Key for Payment | |||
55 | ![]() |
![]() |
ZTERM | DZTERM | Terms of payment key | |||
56 | ![]() |
![]() |
EIKTO | EIKTO_K | Our account number with the vendor | |||
57 | ![]() |
![]() |
ZSABE | DZSABE_K | Clerk at vendor | |||
58 | ![]() |
![]() |
KVERM | KVERM | Memo | |||
59 | ![]() |
![]() |
FDGRV | FDGRV | Planning group | |||
60 | ![]() |
![]() |
BUSAB | BUSAB | Accounting clerk | |||
61 | ![]() |
![]() |
LNRZE | LNRZE | Head office account number | |||
62 | ![]() |
![]() |
LNRZB | LNRZB | Account number of the alternative payee | |||
63 | ![]() |
![]() |
ZINDT | DZINDT | Key date of the last interest calculation | |||
64 | ![]() |
![]() |
ZINRT | DZINRT | Interest calculation frequency in months | |||
65 | ![]() |
![]() |
DATLZ | DATLZ | Date of the last interest calculation run | |||
66 | ![]() |
![]() |
XDEZV | XDEZV | Indicator: Local processing? | |||
67 | ![]() |
![]() |
WEBTR | WEBTR | Bill of exchange limit (in local currency) | |||
68 | ![]() |
![]() |
KULTG | KULTG | Probable time until check is paid | |||
69 | ![]() |
![]() |
REPRF | REPRF | Check Flag for Double Invoices or Credit Memos | |||
70 | ![]() |
![]() |
TOGRU | TOGRU | Tolerance group for the business partner/G/L account | |||
71 | ![]() |
![]() |
HBKID | HBKID | Short key for a house bank | |||
72 | ![]() |
![]() |
XPORE | XPORE | Indicator: Pay all items separately ? | |||
73 | ![]() |
![]() |
QSZNR | QSZNR | Certificate Number of the Withholding Tax Exemption | |||
74 | ![]() |
![]() |
QSZDT | QSZDT | Validity Date for Withholding Tax Exemption Certificate | |||
75 | ![]() |
![]() |
QSSKZ | QSSKZ | Withholding Tax Code | |||
76 | ![]() |
![]() |
BLNKZ | BLNKZ | Subsidy Indicator for Determining the Reduction Rates | |||
77 | ![]() |
![]() |
KTOKK | KTOKK | Vendor account group | |||
78 | ![]() |
![]() |
TELBX | TELBX | Telebox number | |||
79 | ![]() |
![]() |
TELF1 | TELF1 | First telephone number | |||
80 | ![]() |
![]() |
TELF2 | TELF2 | Second telephone number | |||
81 | ![]() |
![]() |
TELFX | TELFX | Fax Number | |||
82 | ![]() |
![]() |
TELTX | TELTX | Teletex number | |||
83 | ![]() |
![]() |
TELX1 | TELX1 | Telex number | |||
84 | ![]() |
![]() |
ERDAT | ERDAT_RF | Date on which the Record Was Created | |||
85 | ![]() |
![]() |
ERNAM | ERNAM_RF | Name of Person who Created the Object | |||
86 | ![]() |
![]() |
STCEG | STCEG | VAT Registration Number | |||
87 | ![]() |
![]() |
STKZN | STKZN | Natural Person | |||
88 | ![]() |
![]() |
MINDK | MINDK | Minority Indicators | |||
89 | ![]() |
![]() |
ALTKN | ALTKN | Previous Master Record Number | |||
90 | ![]() |
![]() |
ZGRUP | DZGRUP | Key for Payment Grouping | |||
91 | ![]() |
![]() |
MGRUP | MGRUP | Key for dunning notice grouping | |||
92 | ![]() |
![]() |
ADRNR | ADRNR | Address | |||
93 | ![]() |
![]() |
UZAWE | UZAWE | Payment method supplement | |||
94 | ![]() |
![]() |
QLAND | QLAND | Withholding Tax Country Key | |||
95 | ![]() |
![]() |
KRAUS | KRAUS_CM | Credit information number | |||
96 | ![]() |
![]() |
REVDB | REVDB_CM | Last review (external) | |||
97 | ![]() |
![]() |
QSSYS | QSSYS_IST | Vendor's QM system | |||
98 | ![]() |
![]() |
GBORT | GBORT_Q | Place of birth of the person subject to withholding tax | |||
99 | ![]() |
![]() |
GBDAT | GBDAT_Q | Date of birth of the person subject to withholding tax | |||
100 | ![]() |
![]() |
SEXKZ | SEXKZ | Key for the Sex of the Person Subject to Withholding Tax | |||
101 | ![]() |
![]() |
KTOCK | KTOCK | Reference Account Group for One-Time Account (Vendor) | |||
102 | ![]() |
![]() |
PFORT | PFORT_GP | PO Box city | |||
103 | ![]() |
![]() |
XEDIP | XEDIP | Indicator: Send Payment Advices by EDI | |||
104 | ![]() |
![]() |
SPERZ | SPERZ | Payment Block | |||
105 | ![]() |
![]() |
PERNR | PERNR_D | Personnel Number | |||
106 | ![]() |
![]() |
QSREC | QSREC | Vendor Recipient Type | |||
107 | ![]() |
![]() |
QSBGR | QSBGR | Authority for Exemption from Withholding Tax | |||
108 | ![]() |
![]() |
FRGRP | FRGRP | Release Approval Group | |||
109 | ![]() |
![]() |
TLFXS | TLFXS | Accounting clerk's fax number at the customer/vendor | |||
110 | ![]() |
![]() |
INTAD | INTAD | Internet address of partner company clerk | |||
111 | ![]() |
![]() |
XLFZA | XLFZA | Indicator: Alternative payee using account number | |||
112 | ![]() |
![]() |
XLFZB | XLFZB | Indicator: Alternative payee using account number | |||
113 | ![]() |
![]() |
GUZTE | GUZTE | Payment Terms Key for Credit Memos | |||
114 | ![]() |
![]() |
TOGRR | TOGRR | Tolerance group; Invoice Verification | |||
115 | ![]() |
![]() |
XAUSZ | XAUSZ | Indicator for periodic account statements | |||
116 | ![]() |
![]() |
GRICD | J_1AGICD_D | Activity Code for Gross Income Tax | |||
117 | ![]() |
![]() |
GRIDT | J_1ADTYP_D | Distribution Type for Employment Tax | |||
118 | ![]() |
![]() |
NODEL | NODEL_X | Central deletion block for master record | |||
119 | ![]() |
![]() |
CONFS | CONFS_X | Status of Change Authorization (Central) | |||
120 | ![]() |
![]() |
UPDAT | UPDAT_RF | Date on Which the Changes Were Confirmed | |||
121 | ![]() |
![]() |
UPTIM | UPTIM_RF | Time of Last Change Confirmation | |||
122 | ![]() |
![]() |
NODEL | NODEL_B | Deletion bock for master record (company code level) | |||
123 | ![]() |
![]() |
CONFS | CONFS_B | Status of Change Authorization (Company Code Level) | |||
124 | ![]() |
![]() |
UPDAT | UPDAT_RF | Date on Which the Changes Were Confirmed | |||
125 | ![]() |
![]() |
UPTIM | UPTIM_RF | Time of Last Change Confirmation | |||
126 | ![]() |
![]() |
SCACD | SCACD | Standard carrier access code | |||
127 | ![]() |
![]() |
J_1KFREPRE | REPRES | Name of Representative | |||
128 | ![]() |
![]() |
J_1KFTBUS | GESTYP | Type of Business | |||
129 | ![]() |
![]() |
J_1KFTIND | INDTYP | Type of Industry | |||
130 | ![]() |
![]() |
TLFNS | TLFNS | Accounting clerk's telephone number at business partner | |||
131 | ![]() |
![]() |
SFRGR | SFRGR | Forwarding Agent Freight Group | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in |