SAP table TVFK (Billing: Document Types)

SAP table TVFK has 2 primary key fields being MANDT,FKART.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
FKART Billing Type CHAR 4 0 FKART
KOPGR Screen sequence group in doc. header CHAR 4 0 KOPGR
NUMKI Number Range of Internal Number Assignment CHAR 2 0 NUMKI
NUMKE Number Range of External Number Assignment CHAR 2 0 NUMKE
INCPO Item Number Increment of SD Documents NUMC 6 0 INCPO
KUNN0 Billing type for rebate processing CHAR 1 0 BOFKT
A Final rebate settlement
B Rebate correction document
C Partial settlement for a rebate agreement
D Manual accruals for a rebate agreement
UEVOR F-code default for overview screen CHAR 4 0 UEVOR_VF
Remain on initial screen until a function is selected
UEBK Press ENTER to reach billing document overview
UMFNG Display Range CHAR 20 0 UMFNG
UALL All items
UHAU Main items
UMAR Selected items
RFBFK Blocked for transfer to accounting CHAR 1 0 RFBFK
TRVOG Transaction Group CHAR 1 0 TRVOG
0 Sales Order
1 Inquiry
2 Quotation
3 Scheduling Agreement
4 Contract
5 Item Proposal
6 Delivery
7 Billing Documents
8 Proforma Invoices
9 Sales Activities
A Sales Promotions
B Customer Independent Requirements
D Shipping Notification
G Rough Goods Receipt
O Cost Accounting: Variance Calculation
P Pre-Billing Document
R Billing Document Request
TXN08 Number of the Standard Text CHAR 8 0 TXN08
VBTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
0 Master Contract
1 Sales Activities (CAS)
2 External Transaction
3 Invoice List
4 Credit Memo List
5 Intercompany Invoice
6 Intercompany Credit Memo
7 Delivery/Shipping Notification
8 Shipment
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
PARGK Partner determination procedure for the billing doc.header CHAR 4 0 PARGK
PARGP Partner determination procedure for the billing doc.item CHAR 4 0 PARGP
KALSMC Account Determination Procedure for G/L Accounts CHAR 6 0 T683 KALSMC
FKARTS Billing Type for Cancellation CHAR 4 0 TVFK FKARTS
TXTGR Text Determination Procedure CHAR 2 0 TTXG TXTGR
KAPPL Application for output conditions CHAR 2 0 T681A NA_KAPPL
KALSM Output determination procedure CHAR 6 0 T683 KALSMB
KSCHL Output Type CHAR 4 0 NA_KSCHL
STAFO Update Group for statistics update CHAR 6 0 STAFO
KVSLV Account key for cash allocation CHAR 3 0 T687 KVSLV
KALVG Document Classification for Pricing Procedure Determination CHAR 2 0 TVKV KALVG
TXTGR_P Text determination procedure for billing item CHAR 2 0 TTXG TXTGR_P
STATI Update statistics CHAR 1 0 STATI
KALSMBP Procedure for item output CHAR 6 0 T683 KALSMBP
BORVF Billing Document is Relevant for Sales Rebate Processing CHAR 1 0 BORVF
FKART_RL Invoice List Type CHAR 4 0 TVFK FKART_RL
RELEP Forward invoice lists with line items to FI CHAR 1 0 RELEP
TXTLF Copy texts from delivery note CHAR 1 0 TXTLF
HITYP_PR Hierarchy type for pricing CHAR 1 0 THIT HITYP_PR
FKART_AB Accrual Billing Type CHAR 4 0 TVFK FKART_AB
GRBED_S Copying Requirements NUMC 3 0 GRBED
ORDNR_FI_S Assignment Number (Financial Accounting) CHAR 1 0 ORDNR_FI
A Customer Reference
B Sales Order Number
C Delivery Number
D External Delivery Number
E Actual Billing Document Number
F External delivery no. if available, otherwise delivery no.
XBLNR_FI_S FI reference number CHAR 1 0 XBLNR_FI
A Customer Reference
B Sales Order Number
C Delivery Number
D External Delivery Number
E Current Billing Document Number
F External delivery no. if avalable, otherwise delivery no.
J_1BNFREL Nota Fiscal Relevance CHAR 1 0 J_1BNFREL
J_1BMAINPA Main partner function ID (e.g. SH for ship-to party) CHAR 2 0 J_1BAD J_1BMAINPA
J_1BTDIDH Text Id. Nota Fiscal header CHAR 4 0 TTXID J_1BTDIDH
J_1BTDCOH Number of text lines header NUMC 1 0 J_1BTDCOH
J_1BTDIDL Text Id Nota Fiscal lines CHAR 4 0 TTXID J_1BTDIDL
J_1BTDCOL Counter Number of text lines NF line NUMC 1 0 J_1BTDCOL
FKTYP Billing Category CHAR 1 0 FKTYP_2
P Down payment request
U Billing request
W POS billing document
XNEGP Negative posting CHAR 1 0 XNEGP_VF
No negative posting
A Negative posting for same period
B Negative posting - general
C Negative posting - reversal reason as selected
BLART Document Type CHAR 2 0 T003 BLART
XFILKD Branch/head office relationship CHAR 1 0 XFILKD_VF
Customer=Payer/Branch=sold-to party
A Customer=sold-to party
B Customer=Payer
XVALGS Correction Document with Value Date CHAR 1 0 XVALGS
KALSMCA Pricing procedure for account determination extra pay CHAR 6 0 T683 KALSMCA
KALSMCB Pricing procedure for acc. determ. reconciliation account CHAR 6 0 T683 KALSMCB
KALSMCC Pricing procedure for account determination cash settlement CHAR 6 0 T683 KALSMCC
KALSMCD Pricing procedure for account determination payment cards CHAR 6 0 T683 KALSMCD
XKOIV Account assignment offsetting entry in intercompany billing CHAR 1 0 XKOIV
J_1AINVREF Invoice reference in billing document CHAR 1 0 J_1AINVREF
1 Fields for inv. reference maintable
2 Fields for inv. reference required
J_1ACPDEL Indicator: Copy branch from Delivery note CHAR 1 0 J_1ACPDEL
UVEIB Doc. pricing procedure for incomplete export/import data CHAR 3 0 UVEIB
FKART_MEV_RESET Billing Document Type for Period-End Reset CHAR 4 0 TVFK FKART_MEV_RESET
VBTYP_EXT Extension of SD Document Category - Obsolete CHAR 4 0 TDD_VBTYP_EXT_OBSOLETE
FLEXNUM_ROUTINE_NO Routine No. for Flexible Billing Doc. Numbering NUMC 7 0 SDBIL_FLEXNUM_ROUTINE_NO
FLEXCANC_ROUTINE_NO Routine No. for Flexible Billing Document Cancellation NUMC 7 0 SDBIL_FLEXCANC_ROUTINE_NO
OICINPD Invoice pricing date rule CHAR 1 0 OIC_INPD
Ref Sales Order (VBKD-PRSDT VBKD-OIC_TIME)
1 Invoice Creation (SY-UZEIT SY-DATUM at Inv Creatn)
2 Delivery (LIKP-LFDAT LIKP-LFUHR)
3 Actual Goods Issue (LIKP-WADAT_IST LIKP-OIWATIM)
4 Loading (LIKP-LDDAT LIKP-OILDTIM)
5 Planned Goods Issue (LIKP-WADAT LIKP-WAUHR)
OIFEEPD Fee pricing date CHAR 1 0 OIA_FEEPD
OIINVCYC1 Invoice cycle indicator active (X/ ) CHAR 1 0 OIA_INCYCA
OIINVCYC2 Invoice cycle indicator active (X/ ) CHAR 1 0 OIA_INCYCA
OIINVCYC3 Invoice cycle indicator active (X/ ) CHAR 1 0 OIA_INCYCA
OIINVCYC4 Invoice cycle indicator active (X/ ) CHAR 1 0 OIA_INCYCA
OIINVCYC5 Invoice cycle indicator active (X/ ) CHAR 1 0 OIA_INCYCA
OIINVCYC6 Invoice cycle indicator active (X/ ) CHAR 1 0 OIA_INCYCA
OIINVCYC7 Invoice cycle indicator active (X/ ) CHAR 1 0 OIA_INCYCA
OIINVCYC8 Invoice cycle indicator active (X/ ) CHAR 1 0 OIA_INCYCA
OIINVCYC9 Invoice cycle indicator active (X/ ) CHAR 1 0 OIA_INCYCA
OINETEXIT User exit for netting cycle determination NUMC 3 0 OIA_NEXIT
OIPTRMEX Payment term transfer to VBRK NUMC 3 0 OIA_PTEXIT
OIC_DIFFIN Differential invoice CHAR 1 0 OIC_DIFFIN
Not a differential invoice
1 Diff. inv. (even if F&A cond. are set to provisional)
2 Diff. Inv. (only if all F&A cond. are set to final)
OIC_DICNTR Differential invoice control CHAR 1 0 OIC_DICNTR
Produce if at least one cycle non final
X Produce even if all cycles final
OIC_ACCVAL User exit to accumulate already-invoiced values NUMC 3 0 OIC_ACCVAL
OIC_ERRHA User exit for error handling/no breakdown of diff. amount NUMC 3 0 OIC_ERRHA
OIC_FKART Default billing type for cancel / rebill CHAR 4 0 TVFK OIC_FKART
OISELEXIT Movements index selection exit NUMC 3 0 OIA_SELEX
OIFINEXIT Financial document selection exit NUMC 3 0 OIA_FINEX
OINETRPT ABAP Program Name CHAR 40 0 TRDIR PROGNAME
OIBTCEXIT BTCI generation exit for movements based netting NUMC 3 0 OIA_BTCEX
OIAMWOFI Movements without financials indicator CHAR 1 0 OIA_MWOFI
OIABALAN Include balances indicator CHAR 1 0 OIA_BALAN
OIINVAPP Invoice Approval Process (IAP) active flag CHAR 1 0 OIC_SDP_INAPPR
OIINDCM Active flag f. Document Change Management (DCM) for invoice CHAR 1 0 OIC_SDP_DCM

TVFK foreign key relationships

Table Field Check Table Check Field
0 TVFK BLART T003 Document Types MANDT
1 TVFK FKARTS TVFK Billing: Document Types MANDT
1 TVFK FKARTS TVFK Billing: Document Types FKART
0 TVFK FKART_AB TVFK Billing: Document Types MANDT
0 TVFK FKART_AB TVFK Billing: Document Types FKART
1 TVFK FKART_MEV_RESET TVFK Billing: Document Types MANDT
1 TVFK FKART_MEV_RESET TVFK Billing: Document Types FKART
0 TVFK FKART_RL TVFK Billing: Document Types MANDT
0 TVFK FKART_RL TVFK Billing: Document Types FKART
1 TVFK HITYP_PR THIT Customer Hierarchy Types MANDT
1 TVFK HITYP_PR THIT Customer Hierarchy Types HITYP
0 TVFK J_1BMAINPA J_1BAD Partner function ID MANDT
0 TVFK J_1BMAINPA J_1BAD Partner function ID PARVW
1 TVFK KALSM T683 Pricing procedures KAPPL
1 TVFK KALSM T683 Pricing procedures KALSM
0 TVFK KALSMBP T683 Pricing procedures KAPPL
0 TVFK KALSMBP T683 Pricing procedures KALSM
1 TVFK KALSMC T683 Pricing procedures KAPPL
1 TVFK KALSMC T683 Pricing procedures KALSM
0 TVFK KALSMCA T683 Pricing procedures KAPPL
0 TVFK KALSMCA T683 Pricing procedures KALSM
1 TVFK KALSMCB T683 Pricing procedures KAPPL
1 TVFK KALSMCB T683 Pricing procedures KALSM
0 TVFK KALSMCC T683 Pricing procedures KAPPL
0 TVFK KALSMCC T683 Pricing procedures KALSM
1 TVFK KALSMCD T683 Pricing procedures KAPPL
1 TVFK KALSMCD T683 Pricing procedures KALSM
0 TVFK KALVG TVKV Document classification for pricing procedure determination MANDT
0 TVFK KALVG TVKV Document classification for pricing procedure determination KALVG
1 TVFK KAPPL T681A Conditions: Applications KAPPL
0 TVFK KVSLV T687 Account Determination: Account Key KAPPL
1 TVFK OIC_FKART TVFK Billing: Document Types MANDT
1 TVFK OIC_FKART TVFK Billing: Document Types FKART
0 TVFK OINETRPT TRDIR Generated Table for View NAME
1 TVFK TXTGR TTXG Text Processing: Text ID Groups MANDT
0 TVFK TXTGR_P TTXG Text Processing: Text ID Groups MANDT