SAP Table TVCPF

Billing: Copying Control

TVCPF (Billing: Copying Control) 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 TVCPF to other SAP tables.

TVCPF table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
FKARN Copy control: target billing type FKART_NACH TVFK CHAR 4 0
AUARV Copying control: Reference document type AUART_VON TVAK CHAR 4 0
LFARV Copy control: from delivery type LFART_VON TVLK CHAR 4 0
FKARV Copying control: Reference billing document type FKART_VON TVFK CHAR 4 0
PSTYV Reference item category PSTYV_VON TVPT CHAR 4 0
GRBED Copying requirements GRBED NUMC 3 0
GRURK Data transfer VBRK GRURK NUMC 3 0
GRURP Data transfer VBRK/VBRP GRURP NUMC 3 0
GRUKO Data transfer KOMV GRUKO NUMC 3 0
KNPRS Pricing type KNPRS CHAR 1 0
A Copy price components and redetermine scales
B Carry out new pricing
C Copy manual pricing elements and redetermine the others
D Copy pricing elements unchanged
E Adopt price components and fix values
F Copy pricing elements, turn value and fix
G Copy pricing elements unchanged and redetermine taxes
H Redetermine freight conditions
I Redetermine rebate conditions
J Redetermine confirmed purch. net price / value (KNTYP=d)
K Adopt price components and cose. Redetermine taxes.
M Copy pricing elements, turn value
N Transfer pricing components unchanged, new cost
O Redetermine variant conditions (KNTYP=O)
Q Redetermine calculation conditions (KNTYP=Q)
R Apply Price Parts and Bonus Conditions
U Redetermine precious metal conditions (KNTYP=U)
X Customer reserve X
Y Customer reserve Y
Z Customer reserve Z
1 Customer reserve 1
2 Customer reserve 2
3 Customer reserve 3
4 Customer reserve 4
5 Customer reserve 5
6 Customer reserve 6
7 Customer reserve 7
8 Customer reserve 8
9 Customer reserve 9
S Ship & Debit (IBU HiTec)
PLMIN Quantity is calculated positively, negatively or not at all PLMIN CHAR 1 0
0 Zero
+ Positive
- Negative
FKMGK Billing quantity indicator FKMGK CHAR 1 0
A Order quantity less invoiced quantity
B Delivery quantity less invoiced quantity
C Order quantity
D Delivery quantity
E Goods receipt quantity less invoiced quantity
F Invoice receipt quantity less invoiced quantity
G Cumulative batch quantity minus invoiced quantity
H Cumul.batch quantity
I Purchase quantity minus quantity already billed
POSVO Copy item number from reference POSVO CHAR 1 0
X Yes
NULL No
HINEU Determine customer heirarchy again HINEU CHAR 1 0
X Yes
NULL No
PFKUR Determine pricing exchange rate PFKUR CHAR 1 0
A Copy from sales order
B Price exchange rate = Accouting rate
C Exchange rate determination according to billing date
D Exchange rate determination according to pricing date
E Exchange rate determination according to current date
F Exch.rate determination accord.to date of services rendered
NULL
EXPIM Determination of export data in billing document EXPIM CHAR 1 0
NULL Refer to export data in the delivery
A Copy export data in the delivery
B Redetermine the export data
ORDNR_FI 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 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.
PRSQU Price source PRSQU CHAR 1 0
NULL Order
A Purchase order
B Purchase order/delivery
C not used
D Delivery
E Delivery/order
F Shipment costs
G external
KVPRS Cumulate cost KVPRS CHAR 1 0
X Yes
NULL No
PSTYN Default item category PSTYV_NACH TVPT CHAR 4 0
OIFERP Fee repricing indicator OIA_FERP CHAR 1 0
1 Carry out new fee rate determination
2 Copy manually entered fee rates and redetermine others
3 Copy all fee elements unchanged
OIFEECH Fee edit control OIA_FEECH CHAR 1 0
1 Add, delete, change, reprice abilities active
2 Change, reprice only
3 Display only active
GRURP_2 Data Transfer 2nd Item GRURP_2 NUMC 3 0

TVCPF foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TVCPF AUARV TVCPF MANDT TVAK Sales Document Types MANDT
TVCPF AUARV TVCPF AUARV TVAK Sales Document Types AUART
TVCPF FKARN TVCPF MANDT TVFK Billing: Document Types MANDT
TVCPF FKARN TVCPF FKARN TVFK Billing: Document Types FKART
TVCPF FKARV TVCPF MANDT TVFK Billing: Document Types MANDT
TVCPF FKARV TVCPF FKARV TVFK Billing: Document Types FKART
TVCPF LFARV TVCPF LFARV TVLK Delivery Types LFART
TVCPF LFARV TVCPF MANDT TVLK Delivery Types MANDT
TVCPF MANDT TVCPF MANDT T000 Clients MANDT
TVCPF PSTYN TVCPF MANDT TVPT Sales documents: Item categories MANDT
TVCPF PSTYN TVCPF PSTYN TVPT Sales documents: Item categories PSTYV
TVCPF PSTYV TVCPF MANDT TVPT Sales documents: Item categories MANDT
TVCPF PSTYV TVCPF PSTYV TVPT Sales documents: Item categories PSTYV