SAP ABAP Table TVFK (Billing: Document Types)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ VF0C (Package) Customizing R/3 invoice

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TVFK	Table Relationship Diagram
Short Description	Billing: Document Types

Delivery and Maintenance

Pool/cluster
Delivery Class	G	Customizing table, protected against SAP Upd., only INS all.
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	FKART	☑	FKART	FKART	CHAR	4	0	Billing Type
3	KOPGR	☐	KOPGR	KOPGR	CHAR	4	0	Screen sequence group in doc. header
4	NUMKI	☐	NUMKI	NUMKR	CHAR	2	0	Number range in the case of internal number assignment
5	NUMKE	☐	NUMKE	NUMKR	CHAR	2	0	Number range in the case of external number assignment
6	INCPO	☐	INCPO	NUM6	NUMC	6	0	Increment of item number in the SD document
7	KUNN0	☐	BOFKT	BOFKT	CHAR	1	0	Billing type for rebate processing
8	UEVOR	☐	UEVOR_VF	UEVOR_VF	CHAR	4	0	F-code default for overview screen
9	UMFNG	☐	UMFNG	UMFNG	CHAR	20	0	Display criteria
10	RFBFK	☐	RFBFK	XFELD	CHAR	1	0	Blocked for transfer to accounting
11	TRVOG	☐	TRVOG	TRVOG	CHAR	1	0	Transaction group
12	TXN08	☐	TXN08	TXN08	CHAR	8	0	Number of the standard text
13	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
14	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
15	PARGK	☐	PARGK	PARGR	CHAR	4	0	Partner determination procedure for the billing doc.header	*
16	PARGP	☐	PARGP	PARGR	CHAR	4	0	Partner determination procedure for the billing doc.item	*
17	KALSMC	☐	KALSMC	KALSM	CHAR	6	0	Account determination procedure	T683
18	FKARTS	☐	FKARTS	FKART	CHAR	4	0	Billing type for cancellation	TVFK
19	TXTGR	☐	TXTGR	TXTGR	CHAR	2	0	Text Determination Procedure	TTXG
20	KAPPL	☐	NA_KAPPL	KAPPL	CHAR	2	0	Application for output conditions	T681A
21	KALSM	☐	KALSMB	KALSM	CHAR	6	0	Output determination procedure	T683
22	KSCHL	☐	NA_KSCHL	KSCHL	CHAR	4	0	Output Type	*
23	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
24	KVSLV	☐	KVSLV	KVSCHL	CHAR	3	0	Account key for cash allocation	T687
25	KALVG	☐	KALVG	KALVG	CHAR	1	0	Document schema for determining calculation schema	TVKV
26	TXTGR_P	☐	TXTGR_P	TXTGR	CHAR	2	0	Text determination procedure for billing item	TTXG
27	STATI	☐	STATI	XFELD	CHAR	1	0	Update statistics
28	KALSMBP	☐	KALSMBP	KALSM	CHAR	6	0	Procedure for item output	T683
29	BORVF	☐	BORVF	XFELD	CHAR	1	0	Billing document is relevant for rebate processing
30	FKART_RL	☐	FKART_RL	FKART	CHAR	4	0	Invoice list type	TVFK
31	RELEP	☐	RELEP	XFELD	CHAR	1	0	Forward invoice lists with line items to FI
32	TXTLF	☐	TXTLF	XFELD	CHAR	1	0	Copy texts from delivery note
33	HITYP_PR	☐	HITYP_PR	HITYP	CHAR	1	0	Hierarchy type for pricing	THIT
34	FKART_AB	☐	FKART_AB	FKART	CHAR	4	0	Accrual billing type	TVFK
35	GRBED_S	☐	GRBED	GRPNO	NUMC	3	0	Copying requirements	*
36	ORDNR_FI_S	☐	ORDNR_FI	ORDNR_FI	CHAR	1	0	Allocation number FI
37	XBLNR_FI_S	☐	XBLNR_FI	XBLNR_FI	CHAR	1	0	FI reference number
38	J_1BNFREL	☐	J_1BNFREL	J_1BIMNFREL	CHAR	1	0	Nota Fiscal Relevance
39	J_1BMAINPA	☐	J_1BMAINPA	J_1BPARVW	CHAR	2	0	Main partner function ID (e.g. SH for ship-to party)	J_1BAD
40	J_1BTDIDH	☐	J_1BTDIDH	TDID	CHAR	4	0	Text Id. Nota Fiscal header	TTXID
41	J_1BTDCOH	☐	J_1BTDCOH	J_1BTDCO	NUMC	1	0	Number of text lines header
42	J_1BTDIDL	☐	J_1BTDIDL	TDID	CHAR	4	0	Text Id Nota Fiscal lines	TTXID
43	J_1BTDCOL	☐	J_1BTDCOL	J_1BTDCO	NUMC	1	0	Counter Number of text lines NF line
44	FKTYP	☐	FKTYP_2	FKTYP_2	CHAR	1	0	Billing category
45	XNEGP	☐	XNEGP_VF	XNEGP_VF	CHAR	1	0	Negative posting
46	BLART	☐	BLART	BLART	CHAR	2	0	Document type	T003
47	XFILKD	☐	XFILKD_VF	XFILKD_VF	CHAR	1	0	Branch/head office relationship
48	XVALGS	☐	XVALGS	XFELD	CHAR	1	0	Credit memo with value date
49	KALSMCA	☐	KALSMCA	KALSM	CHAR	6	0	Pricing procedure for account determination extra pay	T683
50	KALSMCB	☐	KALSMCB	KALSM	CHAR	6	0	Pricing procedure for acc. determ. reconciliation account	T683
51	KALSMCC	☐	KALSMCC	KALSM	CHAR	6	0	Pricing procedure for account determination cash settlement	T683
52	KALSMCD	☐	KALSMCD	KALSM	CHAR	6	0	Pricing procedure for account determination payment cards	T683
53	XKOIV	☐	XKOIV	XFELD	CHAR	1	0	Account assignment offsetting entry in intercompany billing
54	J_1AINVREF	☐	J_1AINVREF	J_1AINVREF	CHAR	1	0	Invoice reference in billing document
55	J_1ACPDEL	☐	J_1ACPDEL	XFELD	CHAR	1	0	Indicator: Copy branch from Delivery note
56	UVEIB	☐	UVEIB	UVEIB	CHAR	3	0	Doc. pricing procedure for incomplete export/import data	T609B
57	FKART_MEV_RESET	☐	FKART_MEV_RESET	FKART	CHAR	4	0	Billing Document Type for Period-End Reset	TVFK
58	VBTYP_EXT	☐	TDD_VBTYP_EXT	DOM_VBTYP_EXT	CHAR	4	0	Extension of SD Document Category
59	.INCLU--AP	☐				0	0	IS-M: Append for Credit-Side SD Billing Types
60	ISM_XKRVO	☐	XKRVO	XFELD	CHAR	1	0	IS-M: Credit-Side Transaction Indicator
61	.INCLU--AP	☐				0	0	Enchancements IS-OIL TVFK
62	OICINPD	☐	OIC_INPD	OIC_INPD	CHAR	1	0	Invoice pricing date rule
63	OIFEEPD	☐	OIA_FEEPD	OIC_INPD	CHAR	1	0	Fee pricing date
64	.INCLUDE	☐				0	0	Invoice cycle active flag 1-n (grouped)
65	OIINVCYC1	☐	OIA_INCYCA	KREUZ	CHAR	1	0	Invoice cycle indicator active (X/ )
66	OIINVCYC2	☐	OIA_INCYCA	KREUZ	CHAR	1	0	Invoice cycle indicator active (X/ )
67	OIINVCYC3	☐	OIA_INCYCA	KREUZ	CHAR	1	0	Invoice cycle indicator active (X/ )
68	OIINVCYC4	☐	OIA_INCYCA	KREUZ	CHAR	1	0	Invoice cycle indicator active (X/ )
69	OIINVCYC5	☐	OIA_INCYCA	KREUZ	CHAR	1	0	Invoice cycle indicator active (X/ )
70	OIINVCYC6	☐	OIA_INCYCA	KREUZ	CHAR	1	0	Invoice cycle indicator active (X/ )
71	OIINVCYC7	☐	OIA_INCYCA	KREUZ	CHAR	1	0	Invoice cycle indicator active (X/ )
72	OIINVCYC8	☐	OIA_INCYCA	KREUZ	CHAR	1	0	Invoice cycle indicator active (X/ )
73	OIINVCYC9	☐	OIA_INCYCA	KREUZ	CHAR	1	0	Invoice cycle indicator active (X/ )
74	OINETEXIT	☐	OIA_NEXIT	GRPNO	NUMC	3	0	User exit for netting cycle determination	*
75	OIPTRMEX	☐	OIA_PTEXIT	GRPNO	NUMC	3	0	Payment term transfer to VBRK	*
76	OIC_DIFFIN	☐	OIC_DIFFIN	OIC_DIFFIN	CHAR	1	0	Differential invoice
77	OIC_DICNTR	☐	OIC_DICNTR	OIC_DICNTR	CHAR	1	0	Differential invoice control
78	OIC_ACCVAL	☐	OIC_ACCVAL	OIC_ACCVAL	NUMC	3	0	User exit to accumulate already-invoiced values
79	OIC_ERRHA	☐	OIC_ERRHA	OIC_ERRHA	NUMC	3	0	User exit for error handling/no breakdown of diff. amount
80	OIC_FKART	☐	OIC_FKART	FKART	CHAR	4	0	Default billing type for cancel / rebill	TVFK
81	OISELEXIT	☐	OIA_SELEX	GRPNO	NUMC	3	0	Movements index selection exit	*
82	OIFINEXIT	☐	OIA_FINEX	GRPNO	NUMC	3	0	Financial document selection exit	*
83	OINETRPT	☐	PROGNAME	PROGNAME	CHAR	40	0	ABAP Program Name	TRDIR
84	OIBTCEXIT	☐	OIA_BTCEX	GRPNO	NUMC	3	0	BTCI generation exit for movements based netting	*
85	OIAMWOFI	☐	OIA_MWOFI	OI0_SELKZ	CHAR	1	0	Movements without financials indicator
86	OIABALAN	☐	OIA_BALAN	OI0_SELKZ	CHAR	1	0	Include balances indicator
87	OIINVAPP	☐	OIC_SDP_INAPPR	OI0_SELKZ	CHAR	1	0	Invoice Approval Process (IAP) active flag
88	OIINDCM	☐	OIC_SDP_DCM	OI0_SELKZ	CHAR	1	0	Active flag f. Document Change Management (DCM) for invoice

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TVFK	BLART	T003	BLART		C	CN
2	TVFK	FKARTS	TVFK	FKART	REF	1	CN
3	TVFK	FKART_AB	TVFK	FKART	REF	C	CN
4	TVFK	FKART_MEV_RESET	TVFK	FKART	REF	1	CN
5	TVFK	FKART_RL	TVFK	FKART	REF	C	CN
6	TVFK	HITYP_PR	THIT	HITYP	REF	C	CN
7	TVFK	J_1BMAINPA	J_1BAD	PARVW		C	CN
8	TVFK	J_1BTDIDH	TTXID	TDID
9	TVFK	J_1BTDIDL	TTXID	TDID
10	TVFK	KALSM	T683	KALSM	REF	C	CN
11	TVFK	KALSMBP	T683	KALSM	REF	C	CN
12	TVFK	KALSMC	T683	KALSM	REF	1	CN
13	TVFK	KALSMCA	T683	KALSM		C	CN
14	TVFK	KALSMCB	T683	KALSM		C	CN
15	TVFK	KALSMCC	T683	KALSM		C	CN
16	TVFK	KALSMCD	T683	KALSM		C	CN
17	TVFK	KALVG	TVKV	KALVG	REF	C	CN
18	TVFK	KAPPL	T681A	KAPPL	REF	1	CN
19	TVFK	KVSLV	T687	KVSL1	REF	C	CN
20	TVFK	MANDT	T000	MANDT	KEY	1	CN
21	TVFK	OIC_FKART	TVFK	FKART
22	TVFK	OINETRPT	TRDIR	NAME
23	TVFK	TXTGR	TTXG	TXTGR	REF	C	CN
24	TVFK	TXTGR_P	TTXG	TXTGR	REF	C	CN
25	TVFK	UVEIB	T609B	UVEIB		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in