SAP ABAP Table WPLFB1 (Extended LFB1 structure (planned changes))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ WLIF (Package) IS-R: Vendor master

Basic Data

Table Category	INTTAB	Structure
Structure	WPLFB1	Table Relationship Diagram
Short Description	Extended LFB1 structure (planned changes)

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	DATUM	☐	WJDPOSDAT	DATUM	DATS	8	0	POS interface: date
2	UTIME	☐	UTIME	UZEIT	TIMS	6	0	Time of Last Change
3	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	*
4	CHGFLAG	☐	WJDPOSFLAG	X	CHAR	1	0	POS interface: flag for certain field changes
5	.INCLUDE	☐				0	0	Vendor Master (Company Code)
6	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
7	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
8	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
9	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
10	.INCLUDE	☐				0	0	Vendor Master (Company Code)
11	ERDAT	☐	ERDAT_RF	DATUM	DATS	8	0	Date on which the Record Was Created
12	ERNAM	☐	ERNAM_RF	USNAM	CHAR	12	0	Name of Person who Created the Object
13	SPERR	☐	SPERB_B	XFELD	CHAR	1	0	Posting block for company code
14	LOEVM	☐	LOEVM_B	XFELD	CHAR	1	0	Deletion Flag for Master Record (Company Code Level)
15	ZUAWA	☐	DZUAWA	ZUAWA	CHAR	3	0	Key for sorting according to assignment numbers	TZUN
16	AKONT	☐	AKONT	SAKNR	CHAR	10	0	Reconciliation Account in General Ledger	SKB1
17	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group	*
18	VZSKZ	☐	VZSKZ	VZSKZ	CHAR	2	0	Interest calculation indicator	T056
19	ZWELS	☐	DZWELS	ZWELS	CHAR	10	0	List of the Payment Methods to be Considered
20	XVERR	☐	XVERR_LFB1	XFELD	CHAR	1	0	Indicator: Clearing between customer and vendor?
21	ZAHLS	☐	DZAHLS	ZAHLS	CHAR	1	0	Block Key for Payment	T008
22	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
23	EIKTO	☐	EIKTO_K	CHAR12	CHAR	12	0	Our account number with the vendor
24	ZSABE	☐	DZSABE_K	TEXT15	CHAR	15	0	Clerk at vendor
25	KVERM	☐	KVERM	TEXT30	CHAR	30	0	Memo
26	FDGRV	☐	FDGRV	FDGRP	CHAR	10	0	Planning group	T035
27	BUSAB	☐	BUSAB	BUSAB	CHAR	2	0	Accounting clerk	T001S
28	LNRZE	☐	LNRZE	LIFNR	CHAR	10	0	Head office account number	LFA1
29	LNRZB	☐	LNRZB	LIFNR	CHAR	10	0	Account number of the alternative payee	LFA1
30	ZINDT	☐	DZINDT	DATUM	DATS	8	0	Key date of the last interest calculation
31	ZINRT	☐	DZINRT	ZINRT	NUMC	2	0	Interest calculation frequency in months
32	DATLZ	☐	DATLZ	DATUM	DATS	8	0	Date of the last interest calculation run
33	XDEZV	☐	XDEZV	XFELD	CHAR	1	0	Indicator: Local processing?
34	WEBTR	☐	WEBTR	WERT7	CURR	13	2	Bill of exchange limit (in local currency)
35	KULTG	☐	KULTG	PACK2	DEC	3	0	Probable time until check is paid
36	REPRF	☐	REPRF	XFELD	CHAR	1	0	Check Flag for Double Invoices or Credit Memos
37	TOGRU	☐	TOGRU	TOGRU	CHAR	4	0	Tolerance group for the business partner/G/L account	T043G
38	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	T012
39	XPORE	☐	XPORE	XFELD	CHAR	1	0	Indicator: Pay all items separately ?
40	QSZNR	☐	QSZNR	CHAR10	CHAR	10	0	Certificate Number of the Withholding Tax Exemption
41	QSZDT	☐	QSZDT	DATUM	DATS	8	0	Validity Date for Withholding Tax Exemption Certificate
42	QSSKZ	☐	QSSKZ	QSSKZ	CHAR	2	0	Withholding Tax Code	*
43	BLNKZ	☐	BLNKZ	BLNKZ	CHAR	2	0	Subsidy Indicator for Determining the Reduction Rates	*
44	MINDK	☐	MINDK	MINDK	CHAR	3	0	Minority Indicators	T059M
45	ALTKN	☐	ALTKN	CHAR10	CHAR	10	0	Previous Master Record Number
46	ZGRUP	☐	DZGRUP	ZGRUP	CHAR	2	0	Key for Payment Grouping	TZGR
47	MGRUP	☐	MGRUP	MGRUP	CHAR	2	0	Key for dunning notice grouping	T047R
48	UZAWE	☐	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	T042F
49	QSREC	☐	QSREC	QSREC	CHAR	2	0	Vendor Recipient Type	T059A
50	QSBGR	☐	QSBGR	QSBGR	CHAR	1	0	Authority for Exemption from Withholding Tax
51	QLAND	☐	QLAND	QLAND	CHAR	3	0	Withholding Tax Country Key	T005Q
52	XEDIP	☐	XEDIP	XFELD	CHAR	1	0	Indicator: Send Payment Advices by EDI
53	FRGRP	☐	FRGRP	FRGRP	CHAR	4	0	Release Approval Group	VBWF08
54	TOGRR	☐	TOGRR	TOGRR	CHAR	4	0	Tolerance group; Invoice Verification	T169L
55	TLFXS	☐	TLFXS	TEXT31	CHAR	31	0	Accounting clerk's fax number at the customer/vendor
56	INTAD	☐	INTAD	TXT130	CHAR	130	0	Internet address of partner company clerk
57	XLFZB	☐	XLFZB	XFELD	CHAR	1	0	Indicator: Alternative payee using account number
58	GUZTE	☐	GUZTE	ZTERM	CHAR	4	0	Payment Terms Key for Credit Memos
59	GRICD	☐	J_1AGICD_D	J_1AGICD2	CHAR	2	0	Activity Code for Gross Income Tax	J_1AGICD
60	GRIDT	☐	J_1ADTYP_D	J_1ADTYP	CHAR	2	0	Distribution Type for Employment Tax	J_1ADTYP
61	XAUSZ	☐	XAUSZ	AUSZG	CHAR	1	0	Indicator for periodic account statements	T048K
62	CERDT	☐	CERDT	DATUM	DATS	8	0	Certification date
63	CONFS	☐	CONFS_B	CHAR1	CHAR	1	0	Status of Change Authorization (Company Code Level)
64	UPDAT	☐	UPDAT_RF	DATUM	DATS	8	0	Date on Which the Changes Were Confirmed
65	UPTIM	☐	UPTIM_RF	AS4TIME	TIMS	6	0	Time of Last Change Confirmation
66	NODEL	☐	NODEL_B	XFELD	CHAR	1	0	Deletion bock for master record (company code level)
67	TLFNS	☐	TLFNS	CHAR30	CHAR	30	0	Accounting clerk's telephone number at business partner
68	AVSND	☐	AVSND	AVSND	CHAR	1	0	Indicator: Send Payment Advice by XML
69	AD_HASH	☐	ADHASH	ADHASH	CHAR	10	0	E-Mail Address for Avis: Hash Value
70	.INCLU--AP	☐				0	0	Subcontracting Management
71	J_SC_SUBCONTYPE	☐	/SAPNEA/J_SC_SUBCONTYPE	/SAPNEA/J_SC_SUBCONTYPE	CHAR	1	0	Subcontractor Type
72	J_SC_COMPDATE	☐	/SAPNEA/J_SC_COMPLETIONDATE	/SAPNEA/J_SC_COMPLETIONDATE	NUMC	3	0	Completion Date Of Inspection
73	J_SC_OFFSM	☐	/SAPNEA/J_SC_OFFSM	/SAPNEA/J_SC_OFFSM	CHAR	1	0	Offset Method
74	J_SC_OFFSR	☐	/SAPNEA/J_SC_OFFSR	/SAPNEA/J_SC_OFFSR	NUMC	3	0	Offset Percentage
75	.INCLU--AP	☐				0	0	PS fields for company code-specific master data field
76	BASIS_PNT	☐	FMBASIS_POINTS	FMBASIS_POINTS	DEC	6	3	Average daily basis points for purchase cards
77	.INCLU--AP	☐				0	0	IS-PS: Data Appendix Vendor Master Record (Company Code)
78	GMVKZK	☐	GMVKZK	XFELD	CHAR	1	0	Vendor is in execution
79	.INCLU--AP	☐				0	0	LFB1 Extension with New Fields - Seasonal Procurement
80	.INCLUDE	☐				0	0	LFB1 Extension with New Fields - Seasonal Procurement
81	PREPAY_RELEVANT	☐	WRF_PREPAY_RELEVANT	WRF_PREPAY_RELEVANT	CHAR	1	0	Prepayment Relevance (Vendor Master)
82	ASSIGN_TEST	☐	WRF_MRM_ASSIGN_GROUP	WRF_MRM_ASSIGN_GROUP	CHAR	4	0	Assignment Test Group	WRF_ASSIGN_GRP

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WPLFB1	AKONT	SKB1	SAKNR	REF	1	CN
2	WPLFB1	ASSIGN_TEST	WRF_ASSIGN_GRP	ASSIGN_GROUP	KEY	1	N
3	WPLFB1	BUKRS	T001	BUKRS	KEY	1	CN
4	WPLFB1	BUSAB	T001S	BUSAB	REF	C	CN
5	WPLFB1	FDGRV	T035	GRUPP	REF	C	CN
6	WPLFB1	FRGRP	VBWF08	FRGRP	REF	C	CN
7	WPLFB1	GRICD	J_1AGICD	J_1AGICD		1	CN
8	WPLFB1	GRIDT	J_1ADTYP	J_1ADTYP		1	CN
9	WPLFB1	HBKID	T012	HBKID	REF	C	CN
10	WPLFB1	LIFNR	LFA1	LIFNR	KEY	1	CN
11	WPLFB1	LNRZB	LFA1	LIFNR	REF	C	CN
12	WPLFB1	LNRZE	LFA1	LIFNR	REF	C	CN
13	WPLFB1	MANDT	T000	MANDT	KEY	1	CN
14	WPLFB1	MGRUP	T047R	MGRUP	REF	C	CN
15	WPLFB1	MINDK	T059M	MINDK	REF	C	CN
16	WPLFB1	QLAND	T005Q	QLAND	REF	1	CN
17	WPLFB1	QSREC	T059A	QSREC	REF	1	CN
18	WPLFB1	TOGRR	T169L	TOGRR		1	CN
19	WPLFB1	TOGRU	T043G	TOGRU	REF	C	CN
20	WPLFB1	UZAWE	T042F	UZAWE	REF	C	CN
21	WPLFB1	VZSKZ	T056	VZSKZ	REF	C	CN
22	WPLFB1	XAUSZ	T048K	XAUSZ	REF	C	CN
23	WPLFB1	ZAHLS	T008	ZAHLS	REF	C	CN
24	WPLFB1	ZGRUP	TZGR	ZGRUP	REF	C	CN
25	WPLFB1	ZUAWA	TZUN	ZUAWA	REF	C	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in