SAP ABAP Table FPLAVB (Reference Structure for XFPLA/YFPLA)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-BF-IF (Application Component) R/3 Interface for Business Transactions
     ⤷ VZ (Package) Application development R/3 RV central functions

Basic Data

Table Category	INTTAB	Structure
Structure	FPLAVB	Table Relationship Diagram
Short Description	Reference Structure for XFPLA/YFPLA

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	.INCLUDE	☐				0	0	Billing Plan
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	FPLNR	☐	FPLNR	FPLNR	CHAR	10	0	Billing plan number / invoicing plan number	*
4	FPTYP	☐	FPTYP_FP	FPTYP	CHAR	1	0	Billing plan category
5	FPART	☐	FPART	FPART	CHAR	2	0	Billing plan/invoice plan type	TFPLA
6	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
7	BEDAT	☐	BEDAT_FP	DATUM	DATS	8	0	Start date for billing plan/invoice plan
8	ENDAT	☐	ENDAT_FP	DATUM	DATS	8	0	End date billing plan/invoice plan
9	HORIZ	☐	HORIZ_FP	VDREG_VEDA	CHAR	2	0	Rule for determining the horizon in the billing/invoice plan	TVRG
10	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
11	BEDAR	☐	BEDAT_FPK	VDREG_VEDA	CHAR	2	0	Rule for origin of start date of billing plan/invoice plan	TVRG
12	ENDAR	☐	ENDAT_FPK	VDREG_VEDA	CHAR	2	0	Rule for origin of end date billing plan/invoice plan	TVRG
13	PERIO	☐	PERIO_FP	VDREG_VEDA	CHAR	2	0	Rule for determining the next billing/invoice date	TVRG
14	FPLAE	☐	FPLAE	NUM3	NUMC	3	0	Length of a standard period in the billing plan
15	RFPLN	☐	RFPLN_D	FPLNR	CHAR	10	0	Standard billing/invoice plan number	FPLA
16	LODAT	☐	TADAT	DATUM	DATS	8	0	Dates from
17	AUTTE	☐	AUTTE	XFELD	CHAR	1	0	Billing/invoice creation in advance
18	LODAR	☐	LODAR	VDREG_VEDA	CHAR	2	0	Rule for Determining Dates from	TVRG
19	PERAF	☐	PERAF_FP	VDREG_VEDA	CHAR	2	0	Rule for determination of a deviating billing/invoice date	TVRG
20	FAKCA	☐	FAKCA	WFCID	CHAR	2	0	Calendar for defining days relevant for billing/invoicing	TFACD
21	TNDAT	☐	TBDAT	DATUM	DATS	8	0	Dates To
22	TNDAR	☐	TBDAR	VDREG_VEDA	CHAR	2	0	Rule for determining dates to	TVRG
23	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
24	APLZL	☐	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order	*
25	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
26	RSPOS	☐	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
27	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
28	FPLTU	☐	FPLTU	FPLTR	NUMC	6	0	Item unlimited in value	*
29	AUST1	☐	AUST1_CC	AUST1_CC	CHAR	1	0	Payment cards: Status regarding requirements
30	AUST2	☐	AUST2_CC	CCALL	CHAR	1	0	Payment cards: Totals status - Call external system
31	AUST3	☐	AUST3_CC	REACT_SD	CHAR	1	0	Payment cards: Overall status - Responses from ext. system
32	AUST4	☐	AUST4_CC	CHAR1	CHAR	1	0	Payment cards: Reserve
33	AUST5	☐	AUST5_CC	XFELD	CHAR	1	0	Payment cards: Authorization block
34	BASISWRT	☐	BASISWRT	WERTV8	CURR	15	2	Target value
35	PSPNR	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	*
36	AUTKOR	☐	AUTKOR	XFELD	CHAR	1	0	Automatic creation of correction dates in billing plan
37	.INCLUDE	☐				0	0	Dynamic Part of the Billing Plan
38	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator
39	SELKZ	☐	SELKZ_LIST	SELKZ	CHAR	1	0	Selection indicator for list screens
40	DFKSAF	☐	DFKSAF	STATV	CHAR	1	0	Note the status of unselected dates
41	NETWRP	☐	NETWRP	WERTV8	CURR	15	2	Net value for item billing plan in document currency

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FPLAVB	BEDAR	TVRG	REGEL
2	FPLAVB	EBELN	EKKO	EBELN	REF	1	CN
3	FPLAVB	ENDAR	TVRG	REGEL
4	FPLAVB	FAKCA	TFACD	IDENT	REF	C	CN
5	FPLAVB	FPART	TFPLA	FPART	REF	1	CN
6	FPLAVB	HORIZ	TVRG	REGEL	REF	C	CN
7	FPLAVB	LODAR	TVRG	REGEL	REF	C	CN
8	FPLAVB	MANDT	T000	MANDT	KEY	1	CN
9	FPLAVB	PERAF	TVRG	REGEL		C	CN
10	FPLAVB	PERIO	TVRG	REGEL
11	FPLAVB	RFPLN	FPLA	FPLNR
12	FPLAVB	TNDAR	TVRG	REGEL	REF	C	CN
13	FPLAVB	VBELN	VBUK	VBELN	REF	C	CN

History

Last changed by/on	SAP	20020219
SAP Release Created in