SAP Table TVFK

Billing: Document Types

TVFK (Billing: Document Types) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TVFK to other SAP tables.

TVFK table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
FKART Billing Type FKART CHAR 4 0
KOPGR Screen sequence group in doc. header KOPGR CHAR 4 0
NUMKI Number range in the case of internal number assignment NUMKI CHAR 2 0
NUMKE Number range in the case of external number assignment NUMKE CHAR 2 0
INCPO Increment of item number in the SD document INCPO NUMC 6 0
KUNN0 Billing type for rebate processing BOFKT CHAR 1 0
NULL
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 UEVOR_VF CHAR 4 0
NULL Remain on initial screen until a function is selected
UEBK Press ENTER to reach billing document overview
UMFNG Display Range UMFNG CHAR 20 0
UALL All items
UHAU Main items
UMAR Selected items
RFBFK Blocked for transfer to accounting RFBFK CHAR 1 0
X Yes
NULL No
TRVOG Transaction group TRVOG CHAR 1 0
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
TXN08 Number of the standard text TXN08 CHAR 8 0
VBTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
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
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
PARGK Partner determination procedure for the billing doc.header PARGK CHAR 4 0
PARGP Partner determination procedure for the billing doc.item PARGP CHAR 4 0
KALSMC Account determination procedure KALSMC T683 CHAR 6 0
FKARTS Billing type for cancellation FKARTS TVFK CHAR 4 0
TXTGR Text determination procedure TXTGR TTXG CHAR 2 0
KAPPL Application for output conditions NA_KAPPL T681A CHAR 2 0
KALSM Output determination procedure KALSMB T683 CHAR 6 0
KSCHL Output Type NA_KSCHL CHAR 4 0
STAFO Update group for statistics update STAFO CHAR 6 0
KVSLV Account key for cash allocation KVSLV T687 CHAR 3 0
KALVG Document procedure (for determining pricing procedure) KALVG TVKV CHAR 1 0
TXTGR_P Text determination procedure for billing item TXTGR_P TTXG CHAR 2 0
STATI Update statistics STATI CHAR 1 0
X Yes
NULL No
KALSMBP Procedure for item output KALSMBP T683 CHAR 6 0
BORVF Billing document is relevant for rebate processing BORVF CHAR 1 0
X Yes
NULL No
FKART_RL Invoice list type FKART_RL TVFK CHAR 4 0
RELEP Forward invoice lists with line items to FI RELEP CHAR 1 0
X Yes
NULL No
TXTLF Copy texts from delivery note TXTLF CHAR 1 0
X Yes
NULL No
HITYP_PR Hierarchy type for pricing HITYP_PR THIT CHAR 1 0
FKART_AB Accrual billing type FKART_AB TVFK CHAR 4 0
GRBED_S Copying requirements GRBED NUMC 3 0
ORDNR_FI_S Allocation number FI ORDNR_FI CHAR 1 0
A Purchase order number
B Sales order number
C Delivery number
D External delivery number
E Actual billing document number
F External delivery no. if avaialable, otherwise delivery no.
XBLNR_FI_S FI reference number XBLNR_FI CHAR 1 0
A Purchase order number
B Sales order number
C Delivery number
D External delivery number
E Current billing document number
F External delivery no. if avaialable, otherwise delivery no.
J_1BNFREL Nota Fiscal Relevance J_1BNFREL CHAR 1 0
X Relevant
NULL Not Relevant
U Relevant, SD/MM Transfer
J_1BMAINPA Main partner function ID (e.g. SH for ship-to party) J_1BMAINPA J_1BAD CHAR 2 0
J_1BTDIDH Text Id. Nota Fiscal header J_1BTDIDH TTXID CHAR 4 0
J_1BTDCOH Number of text lines header J_1BTDCOH NUMC 1 0
1 Maximum nr of lines of text allowed
J_1BTDIDL Text Id Nota Fiscal lines J_1BTDIDL TTXID CHAR 4 0
J_1BTDCOL Counter Number of text lines NF line J_1BTDCOL NUMC 1 0
1 Maximum nr of lines of text allowed
FKTYP Billing category FKTYP_2 CHAR 1 0
P Down payment request
U Billing request
W POS billing document
N Provisional or Differential Billing Document
O Final Billing Document
XNEGP Negative posting XNEGP_VF CHAR 1 0
NULL No negative posting
A Negative posting for same period
B Negative posting - general
C Negative posting - reversal reason as selected
BLART Document Type BLART T003 CHAR 2 0
XFILKD Branch/head office relationship XFILKD_VF CHAR 1 0
NULL Customer=Payer/Branch=sold-to party
A Customer=sold-to party
B Customer=Payer
XVALGS Credit memo with value date XVALGS CHAR 1 0
X Yes
NULL No
KALSMCA Pricing procedure for account determination extra pay KALSMCA T683 CHAR 6 0
KALSMCB Pricing procedure for acc. determ. reconciliation account KALSMCB T683 CHAR 6 0
KALSMCC Pricing procedure for account determination cash settlement KALSMCC T683 CHAR 6 0
KALSMCD Pricing procedure for account determination payment cards KALSMCD T683 CHAR 6 0
XKOIV Account assignment offsetting entry in intercompany billing XKOIV CHAR 1 0
X Yes
NULL No
J_1AINVREF Invoice reference in billing document J_1AINVREF CHAR 1 0
1 Fields for inv. reference maintable
2 Fields for inv. reference required
J_1ACPDEL Indicator: Copy branch from Delivery note J_1ACPDEL CHAR 1 0
X Yes
NULL No
UVEIB Doc. pricing procedure for incomplete export/import data UVEIB T609B CHAR 3 0
FKART_MEV_RESET Billing Document Type for Period-End Reset FKART_MEV_RESET TVFK CHAR 4 0
VBTYP_EXT Extension of SD Document Category TDD_VBTYP_EXT CHAR 4 0
ISM_XKRVO IS-M: Credit-Side Transaction Indicator XKRVO CHAR 1 0
X Yes
NULL No
OICINPD Invoice pricing date rule OIC_INPD CHAR 1 0
NULL 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 OIA_FEEPD CHAR 1 0
NULL 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)
OIINVCYC1 Invoice cycle indicator active (X/ ) OIA_INCYCA CHAR 1 0
X
NULL
OIINVCYC2 Invoice cycle indicator active (X/ ) OIA_INCYCA CHAR 1 0
X
NULL
OIINVCYC3 Invoice cycle indicator active (X/ ) OIA_INCYCA CHAR 1 0
X
NULL
OIINVCYC4 Invoice cycle indicator active (X/ ) OIA_INCYCA CHAR 1 0
X
NULL
OIINVCYC5 Invoice cycle indicator active (X/ ) OIA_INCYCA CHAR 1 0
X
NULL
OIINVCYC6 Invoice cycle indicator active (X/ ) OIA_INCYCA CHAR 1 0
X
NULL
OIINVCYC7 Invoice cycle indicator active (X/ ) OIA_INCYCA CHAR 1 0
X
NULL
OIINVCYC8 Invoice cycle indicator active (X/ ) OIA_INCYCA CHAR 1 0
X
NULL
OIINVCYC9 Invoice cycle indicator active (X/ ) OIA_INCYCA CHAR 1 0
X
NULL
OINETEXIT User exit for netting cycle determination OIA_NEXIT NUMC 3 0
OIPTRMEX Payment term transfer to VBRK OIA_PTEXIT NUMC 3 0
OIC_DIFFIN Differential invoice OIC_DIFFIN CHAR 1 0
NULL 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 OIC_DICNTR CHAR 1 0
NULL Produce if at least one cycle non final
X Produce even if all cycles final
OIC_ACCVAL User exit to accumulate already-invoiced values OIC_ACCVAL NUMC 3 0
OIC_ERRHA User exit for error handling/no breakdown of diff. amount OIC_ERRHA NUMC 3 0
OIC_FKART Default billing type for cancel / rebill OIC_FKART TVFK CHAR 4 0
OISELEXIT Movements index selection exit OIA_SELEX NUMC 3 0
OIFINEXIT Financial document selection exit OIA_FINEX NUMC 3 0
OINETRPT ABAP Program Name PROGNAME TRDIR CHAR 40 0
OIBTCEXIT BTCI generation exit for movements based netting OIA_BTCEX NUMC 3 0
OIAMWOFI Movements without financials indicator OIA_MWOFI CHAR 1 0
NULL Entry not selected / not active / function switched off
X Entry selected / active / function switched on
OIABALAN Include balances indicator OIA_BALAN CHAR 1 0
NULL Entry not selected / not active / function switched off
X Entry selected / active / function switched on
OIINVAPP Invoice Approval Process (IAP) active flag OIC_SDP_INAPPR CHAR 1 0
NULL Entry not selected / not active / function switched off
X Entry selected / active / function switched on
OIINDCM Active flag f. Document Change Management (DCM) for invoice OIC_SDP_DCM CHAR 1 0
NULL Entry not selected / not active / function switched off
X Entry selected / active / function switched on

TVFK foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TVFK BLART TVFK MANDT T003 Document Types MANDT
TVFK BLART TVFK BLART T003 Document Types BLART
TVFK FKARTS TVFK MANDT TVFK Billing: Document Types MANDT
TVFK FKARTS TVFK FKARTS TVFK Billing: Document Types FKART
TVFK FKART_AB TVFK FKART_AB TVFK Billing: Document Types FKART
TVFK FKART_AB TVFK MANDT TVFK Billing: Document Types MANDT
TVFK FKART_MEV_RESET TVFK MANDT TVFK Billing: Document Types MANDT
TVFK FKART_MEV_RESET TVFK FKART_MEV_RESET TVFK Billing: Document Types FKART
TVFK FKART_RL TVFK MANDT TVFK Billing: Document Types MANDT
TVFK FKART_RL TVFK FKART_RL TVFK Billing: Document Types FKART
TVFK HITYP_PR TVFK MANDT THIT Customer Hierarchy Types MANDT
TVFK HITYP_PR TVFK HITYP_PR THIT Customer Hierarchy Types HITYP
TVFK J_1BMAINPA TVFK MANDT J_1BAD Partner function ID MANDT
TVFK J_1BMAINPA TVFK J_1BMAINPA J_1BAD Partner function ID PARVW
TVFK J_1BTDIDH 'VBBK' TTXID Valid text IDs TDOBJECT
TVFK J_1BTDIDH TVFK J_1BTDIDH TTXID Valid text IDs TDID
TVFK J_1BTDIDL 'VBBP' TTXID Valid text IDs TDOBJECT
TVFK J_1BTDIDL TVFK J_1BTDIDL TTXID Valid text IDs TDID
TVFK KALSM TVFK MANDT T683 Pricing procedures MANDT
TVFK KALSM 'B' T683 Pricing procedures KVEWE
TVFK KALSM TVFK KAPPL T683 Pricing procedures KAPPL
TVFK KALSM TVFK KALSM T683 Pricing procedures KALSM
TVFK KALSMBP 'B' T683 Pricing procedures KVEWE
TVFK KALSMBP TVFK KAPPL T683 Pricing procedures KAPPL
TVFK KALSMBP TVFK KALSMBP T683 Pricing procedures KALSM
TVFK KALSMBP TVFK MANDT T683 Pricing procedures MANDT
TVFK KALSMC 'V ' T683 Pricing procedures KAPPL
TVFK KALSMC TVFK KALSMC T683 Pricing procedures KALSM
TVFK KALSMC TVFK MANDT T683 Pricing procedures MANDT
TVFK KALSMC 'C' T683 Pricing procedures KVEWE
TVFK KALSMCA TVFK KALSMCA T683 Pricing procedures KALSM
TVFK KALSMCA TVFK MANDT T683 Pricing procedures MANDT
TVFK KALSMCA 'C' T683 Pricing procedures KVEWE
TVFK KALSMCA 'VA' T683 Pricing procedures KAPPL
TVFK KALSMCB TVFK MANDT T683 Pricing procedures MANDT
TVFK KALSMCB 'C' T683 Pricing procedures KVEWE
TVFK KALSMCB 'VB' T683 Pricing procedures KAPPL
TVFK KALSMCB TVFK KALSMCB T683 Pricing procedures KALSM
TVFK KALSMCC 'C' T683 Pricing procedures KVEWE
TVFK KALSMCC 'VC' T683 Pricing procedures KAPPL
TVFK KALSMCC TVFK KALSMCC T683 Pricing procedures KALSM
TVFK KALSMCC TVFK MANDT T683 Pricing procedures MANDT
TVFK KALSMCD 'VD' T683 Pricing procedures KAPPL
TVFK KALSMCD TVFK KALSMCD T683 Pricing procedures KALSM
TVFK KALSMCD TVFK MANDT T683 Pricing procedures MANDT
TVFK KALSMCD 'C' T683 Pricing procedures KVEWE
TVFK KALVG TVFK MANDT TVKV Pricing Procedures: Transaction MANDT
TVFK KALVG TVFK KALVG TVKV Pricing Procedures: Transaction KALVG
TVFK KAPPL TVFK KAPPL T681A Conditions: Applications KAPPL
TVFK KVSLV TVFK MANDT T687 Account Determination: Account Key MANDT
TVFK KVSLV 'V ' T687 Account Determination: Account Key KAPPL
TVFK KVSLV TVFK KVSLV T687 Account Determination: Account Key KVSL1
TVFK MANDT TVFK MANDT T000 Clients MANDT
TVFK OIC_FKART TVFK OIC_FKART TVFK Billing: Document Types FKART
TVFK OIC_FKART T000 MANDT TVFK Billing: Document Types MANDT
TVFK OINETRPT TVFK OINETRPT TRDIR Generated Table for View NAME
TVFK TXTGR TVFK MANDT TTXG Text Processing: Text ID Groups MANDT
TVFK TXTGR 'VBBK' TTXG Text Processing: Text ID Groups TDOBJECT
TVFK TXTGR TVFK TXTGR TTXG Text Processing: Text ID Groups TXTGR
TVFK TXTGR_P TVFK MANDT TTXG Text Processing: Text ID Groups MANDT
TVFK TXTGR_P 'VBBP' TTXG Text Processing: Text ID Groups TDOBJECT
TVFK TXTGR_P TVFK TXTGR_P TTXG Text Processing: Text ID Groups TXTGR
TVFK UVEIB TVFK MANDT T609B FT: Incompleteness: Doc.Pric.Procedure - Header and Item MANDT
TVFK UVEIB 'A' T609B FT: Incompleteness: Doc.Pric.Procedure - Header and Item KPEXI
TVFK UVEIB TVFK UVEIB T609B FT: Incompleteness: Doc.Pric.Procedure - Header and Item UVEIB